Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.2002410888672E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00037693977355957 / seconds
host not found setting manual db connection
loadtime:0.00096893310546875 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0012750625610352 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0014948844909668 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0015418529510498 / seconds
zipcode:
loadtime:0.0015590190887451 / seconds
Query Executed:select * from search_referrer where page_hash='50a230197a7668ab0cdd1d27a5b939f7' limit 10 DB:ezrox_toadli
loadtime:0.001849889755249 / seconds
Operation header executed (non global)
loadtime:0.0018949508666992 / seconds
Operation leaderboard executed (non global)
loadtime:0.0019879341125488 / seconds
Operation square executed (non global)
loadtime:0.0020248889923096 / seconds
Operation square_bottom executed (non global)
loadtime:0.0020589828491211 / seconds
Operation smallsquare executed (non global)
loadtime:0.0021359920501709 / seconds
Operation headeradright executed (non global)
loadtime:0.0021519660949707 / seconds
Operation google_analytics executed (non global)
loadtime:0.0021638870239258 / seconds
Operation topstories executed (non global)
loadtime:0.0021748542785645 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0021860599517822 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0021970272064209 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0025150775909424 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0029029846191406 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0030109882354736 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0031669139862061 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0032038688659668 / seconds
Template key: archive_menu pushed
loadtime:0.0032088756561279 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0032188892364502 / seconds
Template key: get_gravatar pushed
loadtime:0.0032238960266113 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0032279491424561 / seconds
*10)-10)+1 | start:0
loadtime:0.0032498836517334 / seconds
Query loaded from cache:select * from categories where cat_URLid='schools-and-educational-services-nec'
loadtime:0.0032799243927002 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.003309965133667 / seconds
DB connected to localhost business_master_new
loadtime:0.003809928894043 / seconds
Query Executed:select * from `ct_catmap` where sic='8299' order by city ascDB:business_master_new
loadtime:0.010565042495728 / seconds
Query stored in cache : _QUERY_www.toadli.comd775325b7de2a60fe5e417d3af95171a
loadtime:0.011756896972656 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.011836051940918 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='8299'DB:business_master_new
loadtime:0.015672922134399 / seconds
Query stored in cache : _QUERY_www.toadli.coma3e1584842b69991901ffd40eb24a04c
loadtime:0.015784025192261 / seconds
273 / 11
loadtime:0.015871047973633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.015981912612915 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='8299'DB:business_master_new
loadtime:0.019618988037109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.019669055938721 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='8299'DB:business_master_new
loadtime:0.026931047439575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.02699089050293 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='8299'DB:business_master_new
loadtime:0.037137985229492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.037194013595581 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='8299'DB:business_master_new
loadtime:0.039504051208496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.039567947387695 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='8299'DB:business_master_new
loadtime:0.053221940994263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.053277969360352 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='8299'DB:business_master_new
loadtime:0.054877042770386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.054939985275269 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='8299'DB:business_master_new
loadtime:0.055701017379761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.05575704574585 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='8299'DB:business_master_new
loadtime:0.06035304069519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.060405015945435 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='8299'DB:business_master_new
loadtime:0.072340965270996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.072394847869873 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='8299'DB:business_master_new
loadtime:0.079484939575195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.079535961151123 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='8299'DB:business_master_new
loadtime:0.10451984405518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.10456991195679 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='8299'DB:business_master_new
loadtime:0.10548496246338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.10553288459778 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='8299'DB:business_master_new
loadtime:0.13269305229187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.13275694847107 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='8299'DB:business_master_new
loadtime:0.1343560218811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.13441395759583 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='8299'DB:business_master_new
loadtime:0.14901804924011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.1490650177002 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='8299'DB:business_master_new
loadtime:0.15045189857483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.15051484107971 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='8299'DB:business_master_new
loadtime:0.16582798957825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.16588187217712 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='8299'DB:business_master_new
loadtime:0.16784191131592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.16788506507874 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='8299'DB:business_master_new
loadtime:0.17843389511108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.1784999370575 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='8299'DB:business_master_new
loadtime:0.1825270652771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.18259286880493 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='8299'DB:business_master_new
loadtime:0.30334401130676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.30348896980286 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='8299'DB:business_master_new
loadtime:0.30938196182251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.30943989753723 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='8299'DB:business_master_new
loadtime:0.31059503555298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.31064391136169 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='8299'DB:business_master_new
loadtime:0.31604194641113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.31609702110291 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='8299'DB:business_master_new
loadtime:0.31739091873169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.31745505332947 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='8299'DB:business_master_new
loadtime:0.33356285095215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.3336079120636 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='8299'DB:business_master_new
loadtime:0.34774804115295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.34779906272888 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='8299'DB:business_master_new
loadtime:0.35586905479431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.35590600967407 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='8299'DB:business_master_new
loadtime:0.36162185668945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.36166906356812 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='8299'DB:business_master_new
loadtime:0.37963104248047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.37968897819519 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='8299'DB:business_master_new
loadtime:0.38042688369751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.38047695159912 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='8299'DB:business_master_new
loadtime:0.38365387916565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.38370895385742 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='8299'DB:business_master_new
loadtime:0.38512587547302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.38517284393311 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='8299'DB:business_master_new
loadtime:0.38843107223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.38848495483398 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='8299'DB:business_master_new
loadtime:0.38986897468567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.3899290561676 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='8299'DB:business_master_new
loadtime:0.39788389205933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.39794397354126 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='8299'DB:business_master_new
loadtime:0.3988208770752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.39888501167297 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='8299'DB:business_master_new
loadtime:0.39998984336853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.40003895759583 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='8299'DB:business_master_new
loadtime:0.41550493240356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.41556191444397 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='8299'DB:business_master_new
loadtime:0.41859102249146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.41864395141602 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='8299'DB:business_master_new
loadtime:0.42107391357422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.42112588882446 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='8299'DB:business_master_new
loadtime:0.42650294303894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.42654800415039 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='8299'DB:business_master_new
loadtime:0.42781090736389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.42784404754639 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='8299'DB:business_master_new
loadtime:0.43071007728577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.4307599067688 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='8299'DB:business_master_new
loadtime:0.43170785903931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.43177485466003 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='8299'DB:business_master_new
loadtime:0.44535684585571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.4454288482666 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='8299'DB:business_master_new
loadtime:0.44625401496887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.44631099700928 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='8299'DB:business_master_new
loadtime:0.45258784294128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:0.45266699790955 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='8299'DB:business_master_new
loadtime:0.46571898460388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.46578693389893 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='8299'DB:business_master_new
loadtime:0.46732306480408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:0.46738886833191 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='8299'DB:business_master_new
loadtime:0.47568702697754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.47573804855347 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='8299'DB:business_master_new
loadtime:0.48263597488403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.48269295692444 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='8299'DB:business_master_new
loadtime:0.48362588882446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.48368191719055 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='8299'DB:business_master_new
loadtime:0.49428105354309 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:0.49432992935181 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='8299'DB:business_master_new
loadtime:0.49679088592529 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:0.49684500694275 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='8299'DB:business_master_new
loadtime:0.49895095825195 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:0.49900388717651 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='8299'DB:business_master_new
loadtime:0.49948191642761 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:0.49952602386475 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.50750494003296 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:0.50755500793457 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='8299'DB:business_master_new
loadtime:0.51311707496643 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:0.5131778717041 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='8299'DB:business_master_new
loadtime:0.53021097183228 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:0.53025484085083 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.53133702278137 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:0.53139805793762 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='8299'DB:business_master_new
loadtime:0.53450107574463 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.53455090522766 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.5356719493866 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:0.53573894500732 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='8299'DB:business_master_new
loadtime:0.53681707382202 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:0.53685307502747 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='8299'DB:business_master_new
loadtime:0.54308390617371 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.54315400123596 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='8299'DB:business_master_new
loadtime:0.55496001243591 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:0.55499792098999 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.55573892593384 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:0.55578899383545 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='8299'DB:business_master_new
loadtime:0.55794286727905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:0.55798888206482 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='8299'DB:business_master_new
loadtime:0.56018996238708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.56024599075317 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='8299'DB:business_master_new
loadtime:0.57107090950012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:0.57114505767822 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='8299'DB:business_master_new
loadtime:0.57905602455139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.57912707328796 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='8299'DB:business_master_new
loadtime:0.58019185066223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.58025288581848 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='8299'DB:business_master_new
loadtime:0.59537100791931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:0.59542298316956 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='8299'DB:business_master_new
loadtime:0.595871925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.59591698646545 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='8299'DB:business_master_new
loadtime:0.60214495658875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:0.60220003128052 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='8299'DB:business_master_new
loadtime:0.60386490821838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.60391688346863 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='8299'DB:business_master_new
loadtime:0.60500192642212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:0.60505890846252 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='8299'DB:business_master_new
loadtime:0.60856294631958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:0.60860085487366 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='8299'DB:business_master_new
loadtime:0.61069989204407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.61074805259705 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='8299'DB:business_master_new
loadtime:0.6124279499054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.61248803138733 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='8299'DB:business_master_new
loadtime:0.613116979599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:0.61316990852356 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='8299'DB:business_master_new
loadtime:0.61412000656128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:0.61416506767273 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='8299'DB:business_master_new
loadtime:0.61527991294861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.61533904075623 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='8299'DB:business_master_new
loadtime:0.620041847229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.6201069355011 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.62593102455139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:0.62599492073059 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='8299'DB:business_master_new
loadtime:0.62690186500549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.62695789337158 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='8299'DB:business_master_new
loadtime:0.6349880695343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:0.63510894775391 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='8299'DB:business_master_new
loadtime:0.63588404655457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.63597989082336 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='8299'DB:business_master_new
loadtime:0.63758301734924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.63764405250549 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='8299'DB:business_master_new
loadtime:0.64138889312744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.64151501655579 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='8299'DB:business_master_new
loadtime:0.64418196678162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.64424800872803 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='8299'DB:business_master_new
loadtime:0.64492893218994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.64497089385986 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='8299'DB:business_master_new
loadtime:0.65074586868286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.65081596374512 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='8299'DB:business_master_new
loadtime:0.6523859500885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.65244698524475 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='8299'DB:business_master_new
loadtime:0.65311288833618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.653156042099 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.6588728427887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.65892004966736 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='8299'DB:business_master_new
loadtime:0.66646099090576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.66652393341064 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='8299'DB:business_master_new
loadtime:0.66725993156433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.6672990322113 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='8299'DB:business_master_new
loadtime:0.67101097106934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.67105197906494 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='8299'DB:business_master_new
loadtime:0.67386102676392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.67390203475952 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='8299'DB:business_master_new
loadtime:0.67682385444641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.67686986923218 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='8299'DB:business_master_new
loadtime:0.68548202514648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.68552684783936 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='8299'DB:business_master_new
loadtime:0.68968200683594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.68972706794739 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='8299'DB:business_master_new
loadtime:0.69387793540955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.69391989707947 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='8299'DB:business_master_new
loadtime:0.69435906410217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.69439888000488 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='8299'DB:business_master_new
loadtime:0.69786906242371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.69790506362915 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='8299'DB:business_master_new
loadtime:0.70180487632751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.70184588432312 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='8299'DB:business_master_new
loadtime:0.70476794242859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.70481395721436 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='8299'DB:business_master_new
loadtime:0.71224904060364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.71228790283203 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='8299'DB:business_master_new
loadtime:0.71348285675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.71352505683899 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='8299'DB:business_master_new
loadtime:0.71472096443176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.71477198600769 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='8299'DB:business_master_new
loadtime:0.71705603599548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.71713900566101 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='8299'DB:business_master_new
loadtime:0.71761894226074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.71764898300171 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='8299'DB:business_master_new
loadtime:0.71832299232483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.71836400032043 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='8299'DB:business_master_new
loadtime:0.71928191184998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.7193169593811 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='8299'DB:business_master_new
loadtime:0.72303605079651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.72310400009155 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='8299'DB:business_master_new
loadtime:0.72918605804443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.72925090789795 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='8299'DB:business_master_new
loadtime:0.72977995872498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.72982597351074 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='8299'DB:business_master_new
loadtime:0.73067402839661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.73074293136597 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='8299'DB:business_master_new
loadtime:0.73406100273132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.73412990570068 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='8299'DB:business_master_new
loadtime:0.73719096183777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.73736095428467 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='8299'DB:business_master_new
loadtime:0.75202298164368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.75223398208618 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='8299'DB:business_master_new
loadtime:0.75393486022949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.75407290458679 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='8299'DB:business_master_new
loadtime:0.75745987892151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.75754690170288 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='8299'DB:business_master_new
loadtime:0.75902390480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.7591769695282 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='8299'DB:business_master_new
loadtime:0.7615180015564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.76156997680664 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='8299'DB:business_master_new
loadtime:0.76248693466187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.76253485679626 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='8299'DB:business_master_new
loadtime:0.76428198814392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.76432991027832 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='8299'DB:business_master_new
loadtime:0.77421402931213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.7742760181427 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='8299'DB:business_master_new
loadtime:0.7754590511322 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.77550387382507 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='8299'DB:business_master_new
loadtime:0.7766900062561 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.77674984931946 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='8299'DB:business_master_new
loadtime:0.77813291549683 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.77819585800171 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='8299'DB:business_master_new
loadtime:0.77913498878479 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.77920007705688 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='8299'DB:business_master_new
loadtime:0.78264689445496 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.78270387649536 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.78852796554565 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.78859901428223 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='8299'DB:business_master_new
loadtime:0.78959703445435 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.78966093063354 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='8299'DB:business_master_new
loadtime:0.79071187973022 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.79077506065369 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='8299'DB:business_master_new
loadtime:0.79353785514832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.79358887672424 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='8299'DB:business_master_new
loadtime:0.79461598396301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.79467391967773 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='8299'DB:business_master_new
loadtime:0.79586791992188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.7959349155426 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='8299'DB:business_master_new
loadtime:0.8002028465271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.8002610206604 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='8299'DB:business_master_new
loadtime:0.80270600318909 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.80276393890381 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='8299'DB:business_master_new
loadtime:0.80364990234375 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.80370402336121 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='8299'DB:business_master_new
loadtime:0.80441403388977 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.80446004867554 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='8299'DB:business_master_new
loadtime:0.8064329624176 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.80648493766785 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.80754685401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.8075840473175 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='8299'DB:business_master_new
loadtime:0.80923104286194 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.80928301811218 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='8299'DB:business_master_new
loadtime:0.81078004837036 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.81084394454956 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='8299'DB:business_master_new
loadtime:0.81744790077209 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.81750798225403 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='8299'DB:business_master_new
loadtime:0.81852602958679 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.81857705116272 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='8299'DB:business_master_new
loadtime:0.81995487213135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.82000589370728 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='8299'DB:business_master_new
loadtime:0.82091188430786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.82096195220947 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='8299'DB:business_master_new
loadtime:0.8261878490448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.82623505592346 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='8299'DB:business_master_new
loadtime:0.83204984664917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.83213901519775 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='8299'DB:business_master_new
loadtime:0.8331298828125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.83319187164307 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='8299'DB:business_master_new
loadtime:0.8343870639801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.8344349861145 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='8299'DB:business_master_new
loadtime:0.83763790130615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.83769106864929 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='8299'DB:business_master_new
loadtime:0.83865785598755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.8387188911438 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='8299'DB:business_master_new
loadtime:0.84358096122742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.84364199638367 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='8299'DB:business_master_new
loadtime:0.84426093101501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.84429097175598 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='8299'DB:business_master_new
loadtime:0.84516596794128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.84522604942322 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='8299'DB:business_master_new
loadtime:0.84571194648743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.84575605392456 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='8299'DB:business_master_new
loadtime:0.8468599319458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.84691786766052 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='8299'DB:business_master_new
loadtime:0.84779286384583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.84784984588623 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='8299'DB:business_master_new
loadtime:0.85215187072754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.85220193862915 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='8299'DB:business_master_new
loadtime:0.85271596908569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.85276293754578 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='8299'DB:business_master_new
loadtime:0.8532600402832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.8532989025116 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='8299'DB:business_master_new
loadtime:0.85660004615784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.85666084289551 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='8299'DB:business_master_new
loadtime:0.85753202438354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.85759305953979 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='8299'DB:business_master_new
loadtime:0.86070489883423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.86076307296753 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='8299'DB:business_master_new
loadtime:0.86118388175964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.86122584342957 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='8299'DB:business_master_new
loadtime:0.86292791366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.8629789352417 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='8299'DB:business_master_new
loadtime:0.86412405967712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.86415886878967 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='8299'DB:business_master_new
loadtime:0.86583685874939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.86589884757996 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='8299'DB:business_master_new
loadtime:0.86644506454468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.8665030002594 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='8299'DB:business_master_new
loadtime:0.86987590789795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.86993503570557 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='8299'DB:business_master_new
loadtime:0.87398386001587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.87403297424316 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='8299'DB:business_master_new
loadtime:0.87494707107544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.87500286102295 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='8299'DB:business_master_new
loadtime:0.87850499153137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.87856793403625 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.87945795059204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.87951493263245 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='8299'DB:business_master_new
loadtime:0.8800208568573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.88006591796875 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='8299'DB:business_master_new
loadtime:0.88098692893982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.88104796409607 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='8299'DB:business_master_new
loadtime:0.88160300254822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.88165402412415 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='8299'DB:business_master_new
loadtime:0.88219404220581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.88223600387573 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='8299'DB:business_master_new
loadtime:0.88371396064758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.88377904891968 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='8299'DB:business_master_new
loadtime:0.89075994491577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.89082193374634 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='8299'DB:business_master_new
loadtime:0.89139699935913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.89145994186401 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='8299'DB:business_master_new
loadtime:0.89210200309753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.89213991165161 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.89312887191772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.89318895339966 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='8299'DB:business_master_new
loadtime:0.89366507530212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.89371204376221 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='8299'DB:business_master_new
loadtime:0.89510202407837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.89514899253845 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='8299'DB:business_master_new
loadtime:0.89638805389404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.89644289016724 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='8299'DB:business_master_new
loadtime:0.8979480266571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.89799690246582 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='8299'DB:business_master_new
loadtime:0.903480052948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.90354204177856 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='8299'DB:business_master_new
loadtime:0.90413093566895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.90418004989624 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='8299'DB:business_master_new
loadtime:0.90511703491211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.90517807006836 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='8299'DB:business_master_new
loadtime:0.90725088119507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.90730905532837 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='8299'DB:business_master_new
loadtime:0.9087929725647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.9088568687439 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='8299'DB:business_master_new
loadtime:0.91128897666931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.91134095191956 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='8299'DB:business_master_new
loadtime:0.91223907470703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.9122998714447 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='8299'DB:business_master_new
loadtime:0.91650891304016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.9165940284729 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='8299'DB:business_master_new
loadtime:0.91713786125183 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.9171998500824 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='8299'DB:business_master_new
loadtime:0.91776084899902 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.91780805587769 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='8299'DB:business_master_new
loadtime:0.919429063797 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.91948795318604 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='8299'DB:business_master_new
loadtime:0.92009806632996 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.92015600204468 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='8299'DB:business_master_new
loadtime:0.9208710193634 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.92090797424316 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='8299'DB:business_master_new
loadtime:0.92132091522217 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.92136788368225 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='8299'DB:business_master_new
loadtime:0.92192697525024 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.92196202278137 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='8299'DB:business_master_new
loadtime:0.92811107635498 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.92817807197571 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='8299'DB:business_master_new
loadtime:0.92874884605408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.92880797386169 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='8299'DB:business_master_new
loadtime:0.9299738407135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.93003296852112 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='8299'DB:business_master_new
loadtime:0.93102097511292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.93108487129211 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='8299'DB:business_master_new
loadtime:0.93193387985229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.93198704719543 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='8299'DB:business_master_new
loadtime:0.93263602256775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.93267798423767 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='8299'DB:business_master_new
loadtime:0.9352560043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.9353129863739 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='8299'DB:business_master_new
loadtime:0.93576288223267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.93580985069275 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='8299'DB:business_master_new
loadtime:0.94160604476929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.94169497489929 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='8299'DB:business_master_new
loadtime:0.94244194030762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.94249606132507 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='8299'DB:business_master_new
loadtime:0.94305992126465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.94312286376953 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='8299'DB:business_master_new
loadtime:0.94595384597778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.9460129737854 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='8299'DB:business_master_new
loadtime:0.94869804382324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.94874501228333 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='8299'DB:business_master_new
loadtime:0.95449304580688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.95455694198608 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='8299'DB:business_master_new
loadtime:0.95804786682129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.95811200141907 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='8299'DB:business_master_new
loadtime:0.95854902267456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.95860195159912 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='8299'DB:business_master_new
loadtime:0.95944905281067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.95949196815491 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='8299'DB:business_master_new
loadtime:0.96015000343323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.9602210521698 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='8299'DB:business_master_new
loadtime:0.96194386482239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.96200203895569 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='8299'DB:business_master_new
loadtime:0.96513986587524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.96519589424133 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='8299'DB:business_master_new
loadtime:0.9663188457489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.96637105941772 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='8299'DB:business_master_new
loadtime:0.96980595588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.96986603736877 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='8299'DB:business_master_new
loadtime:0.97094988822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.97101187705994 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='8299'DB:business_master_new
loadtime:0.97251486778259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.97256684303284 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='8299'DB:business_master_new
loadtime:0.97450804710388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.9745569229126 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='8299'DB:business_master_new
loadtime:0.97619891166687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.97626185417175 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='8299'DB:business_master_new
loadtime:0.97715497016907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.97721695899963 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='8299'DB:business_master_new
loadtime:0.97767496109009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.97771692276001 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='8299'DB:business_master_new
loadtime:0.97866892814636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.97871804237366 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='8299'DB:business_master_new
loadtime:0.98444890975952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.98451495170593 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='8299'DB:business_master_new
loadtime:0.98545789718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.98551893234253 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='8299'DB:business_master_new
loadtime:0.98774600028992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.98778200149536 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='8299'DB:business_master_new
loadtime:0.99354791641235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.99361896514893 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='8299'DB:business_master_new
loadtime:0.99785590171814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.99790787696838 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='8299'DB:business_master_new
loadtime:1.002063035965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:1.0021140575409 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='8299'DB:business_master_new
loadtime:1.0026180744171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:1.002671957016 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='8299'DB:business_master_new
loadtime:1.0052108764648 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:1.0053088665009 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='8299'DB:business_master_new
loadtime:1.00727891922 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:1.0074188709259 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='8299'DB:business_master_new
loadtime:1.0091650485992 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:1.0093190670013 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='8299'DB:business_master_new
loadtime:1.0127840042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:1.0128500461578 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='8299'DB:business_master_new
loadtime:1.0132780075073 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:1.0133090019226 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='8299'DB:business_master_new
loadtime:1.0148050785065 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:1.0148658752441 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='8299'DB:business_master_new
loadtime:1.0154218673706 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:1.0154600143433 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='8299'DB:business_master_new
loadtime:1.0160610675812 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:1.0161340236664 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='8299'DB:business_master_new
loadtime:1.0173358917236 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:1.0173809528351 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='8299'DB:business_master_new
loadtime:1.0183398723602 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:1.0183939933777 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='8299'DB:business_master_new
loadtime:1.0188200473785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:1.0188639163971 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='8299'DB:business_master_new
loadtime:1.0229148864746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:1.0229640007019 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='8299'DB:business_master_new
loadtime:1.0239319801331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:1.0239908695221 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='8299'DB:business_master_new
loadtime:1.0297729969025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:1.029844045639 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='8299'DB:business_master_new
loadtime:1.0308439731598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:1.0309040546417 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='8299'DB:business_master_new
loadtime:1.0317149162292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:1.031772851944 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='8299'DB:business_master_new
loadtime:1.0335988998413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.0336489677429 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='8299'DB:business_master_new
loadtime:1.0394330024719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:1.0394868850708 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='8299'DB:business_master_new
loadtime:1.039962053299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:1.0400140285492 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='8299'DB:business_master_new
loadtime:1.0408420562744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:1.0408899784088 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='8299'DB:business_master_new
loadtime:1.0418310165405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:1.0418899059296 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='8299'DB:business_master_new
loadtime:1.0427238941193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:1.0427830219269 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='8299'DB:business_master_new
loadtime:1.0435900688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:1.0436480045319 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='8299'DB:business_master_new
loadtime:1.0446238517761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:1.0446848869324 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='8299'DB:business_master_new
loadtime:1.0456299781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:1.0456869602203 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='8299'DB:business_master_new
loadtime:1.0465488433838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.0466060638428 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='8299'DB:business_master_new
loadtime:1.0488028526306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:1.0488488674164 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='8299'DB:business_master_new
loadtime:1.0493869781494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:1.0494458675385 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='8299'DB:business_master_new
loadtime:1.0499739646912 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.0500628948212 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.050253868103 / seconds
Operation template executed (chunk cache operation)
loadtime:1.0503339767456 / seconds
template override:Default
loadtime:1.0503540039062 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.0511510372162 / seconds
Template Constructed, Array Rows:49
loadtime:1.0514290332794 / seconds
TOTAL EXECUTION TIME: 1.0512
loadtime:1.0516610145569 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => schools-and-educational-services-nec [stateURLid] => connecticut )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.0516738891602
TOTAL KEY ARRAYS: 69