Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.7949295043945E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00049400329589844 / seconds
host not found setting manual db connection
loadtime:0.00083589553833008 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010919570922852 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012640953063965 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0013151168823242 / seconds
zipcode:
loadtime:0.0013320446014404 / seconds
Query Executed:select * from search_referrer where page_hash='0895ec4f6df12892d3f215f4c5925459' limit 10 DB:ezrox_toadli
loadtime:0.0015280246734619 / seconds
Operation header executed (non global)
loadtime:0.0015449523925781 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015799999237061 / seconds
Operation square executed (non global)
loadtime:0.001594066619873 / seconds
Operation square_bottom executed (non global)
loadtime:0.0016059875488281 / seconds
Operation smallsquare executed (non global)
loadtime:0.0016179084777832 / seconds
Operation headeradright executed (non global)
loadtime:0.0016300678253174 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016400814056396 / seconds
Operation topstories executed (non global)
loadtime:0.0016520023345947 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016639232635498 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016739368438721 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018959045410156 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0020449161529541 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020830631256104 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0021450519561768 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021810531616211 / seconds
Template key: archive_menu pushed
loadtime:0.0021860599517822 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0022060871124268 / seconds
Template key: get_gravatar pushed
loadtime:0.0022110939025879 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0022149085998535 / seconds
*10)-10)+1 | start:0
loadtime:0.0022389888763428 / seconds
Query loaded from cache:select * from categories where cat_URLid='hotels-and-motels'
loadtime:0.0022721290588379 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.00229811668396 / seconds
DB connected to localhost business_master_new
loadtime:0.0030930042266846 / seconds
Query Executed:select * from `nh_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.013791084289551 / seconds
Query stored in cache : _QUERY_www.toadli.com95ef9e04f8281a27ba1c8b26e617484e
loadtime:0.014297962188721 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.014327049255371 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='7011'DB:business_master_new
loadtime:0.016101121902466 / seconds
Query stored in cache : _QUERY_www.toadli.comec53c3b487d7e85e0f3740a0e17be206
loadtime:0.016140937805176 / seconds
309 / 11
loadtime:0.016175031661987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acworth' limit 1
loadtime:0.016235113143921 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='7011'DB:business_master_new
loadtime:0.024661064147949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.024722099304199 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='7011'DB:business_master_new
loadtime:0.028248071670532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.028290987014771 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='7011'DB:business_master_new
loadtime:0.029894113540649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenstown' limit 1
loadtime:0.029944896697998 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='7011'DB:business_master_new
loadtime:0.033247947692871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alstead' limit 1
loadtime:0.033288955688477 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='7011'DB:business_master_new
loadtime:0.033946990966797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.033981084823608 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='7011'DB:business_master_new
loadtime:0.035072088241577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton Bay' limit 1
loadtime:0.035115957260132 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='7011'DB:business_master_new
loadtime:0.037655115127563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.037713050842285 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='7011'DB:business_master_new
loadtime:0.039923906326294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.039969921112061 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='7011'DB:business_master_new
loadtime:0.041493892669678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antrim' limit 1
loadtime:0.041853904724121 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='7011'DB:business_master_new
loadtime:0.043987989425659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.044044971466064 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='7011'DB:business_master_new
loadtime:0.047451019287109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashuelot' limit 1
loadtime:0.047492027282715 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='7011'DB:business_master_new
loadtime:0.053004026412964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.053056001663208 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='7011'DB:business_master_new
loadtime:0.054758071899414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.054810047149658 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='7011'DB:business_master_new
loadtime:0.05549693107605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstead' limit 1
loadtime:0.0555260181427 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='7011'DB:business_master_new
loadtime:0.056102991104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.05613899230957 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='7011'DB:business_master_new
loadtime:0.05712103843689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.057163953781128 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='7011'DB:business_master_new
loadtime:0.062812089920044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.06287693977356 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='7011'DB:business_master_new
loadtime:0.063924074172974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.063973903656006 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='7011'DB:business_master_new
loadtime:0.06743597984314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.067485094070435 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='7011'DB:business_master_new
loadtime:0.068217039108276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.068244934082031 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='7011'DB:business_master_new
loadtime:0.06929612159729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.069340944290161 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='7011'DB:business_master_new
loadtime:0.069574117660522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.069608926773071 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='7011'DB:business_master_new
loadtime:0.070719957351685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.070768117904663 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='7011'DB:business_master_new
loadtime:0.075957059860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boscawen' limit 1
loadtime:0.075998067855835 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='7011'DB:business_master_new
loadtime:0.078483104705811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bow' limit 1
loadtime:0.078524112701416 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='7011'DB:business_master_new
loadtime:0.079508066177368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.079543113708496 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='7011'DB:business_master_new
loadtime:0.081555128097534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentwood' limit 1
loadtime:0.081602096557617 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='7011'DB:business_master_new
loadtime:0.084635972976685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bretton Woods' limit 1
loadtime:0.084676027297974 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='7011'DB:business_master_new
loadtime:0.08807110786438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.088105916976929 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='7011'DB:business_master_new
loadtime:0.092750072479248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.09279990196228 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='7011'DB:business_master_new
loadtime:0.093506097793579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.093542098999023 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='7011'DB:business_master_new
loadtime:0.094207048416138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campton' limit 1
loadtime:0.094232082366943 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='7011'DB:business_master_new
loadtime:0.098990917205811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.099054098129272 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='7011'DB:business_master_new
loadtime:0.10001707077026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candia' limit 1
loadtime:0.10007500648499 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='7011'DB:business_master_new
loadtime:0.10131096839905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.10135507583618 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='7011'DB:business_master_new
loadtime:0.10201001167297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.10205912590027 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='7011'DB:business_master_new
loadtime:0.10363292694092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Barnstead' limit 1
loadtime:0.10367608070374 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='7011'DB:business_master_new
loadtime:0.10500812530518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Conway' limit 1
loadtime:0.10506296157837 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='7011'DB:business_master_new
loadtime:0.10673689842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Harbor' limit 1
loadtime:0.10678195953369 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='7011'DB:business_master_new
loadtime:0.10822200775146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Ossipee' limit 1
loadtime:0.10826992988586 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='7011'DB:business_master_new
loadtime:0.10981607437134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Sandwich' limit 1
loadtime:0.1098620891571 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='7011'DB:business_master_new
loadtime:0.1104850769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Strafford' limit 1
loadtime:0.11051106452942 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='7011'DB:business_master_new
loadtime:0.11644911766052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Center Tuftonboro' limit 1
loadtime:0.11649799346924 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='7011'DB:business_master_new
loadtime:0.11707997322083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.11711812019348 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='7011'DB:business_master_new
loadtime:0.11806011199951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.11811494827271 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='7011'DB:business_master_new
loadtime:0.11968493461609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.1197350025177 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='7011'DB:business_master_new
loadtime:0.12072205543518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.12077808380127 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='7011'DB:business_master_new
loadtime:0.1214120388031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chichester' limit 1
loadtime:0.12143993377686 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='7011'DB:business_master_new
loadtime:0.12257599830627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocorua' limit 1
loadtime:0.12263607978821 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='7011'DB:business_master_new
loadtime:0.124596118927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.12465500831604 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='7011'DB:business_master_new
loadtime:0.12660002708435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.12666010856628 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='7011'DB:business_master_new
loadtime:0.12721991539001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.12725591659546 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='7011'DB:business_master_new
loadtime:0.13216090202332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.13224411010742 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='7011'DB:business_master_new
loadtime:0.13903594017029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Contoocook' limit 1
loadtime:0.13910508155823 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='7011'DB:business_master_new
loadtime:0.14034008979797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.14039897918701 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='7011'DB:business_master_new
loadtime:0.14505505561829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.14510607719421 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='7011'DB:business_master_new
loadtime:0.14601993560791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish Flat' limit 1
loadtime:0.14607691764832 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='7011'DB:business_master_new
loadtime:0.15140795707703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.15144300460815 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='7011'DB:business_master_new
loadtime:0.15223002433777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1
loadtime:0.15228009223938 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='7011'DB:business_master_new
loadtime:0.15251612663269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.15255308151245 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='7011'DB:business_master_new
loadtime:0.15302491188049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.15306091308594 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='7011'DB:business_master_new
loadtime:0.15409994125366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.15415906906128 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='7011'DB:business_master_new
loadtime:0.15480494499207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.15485501289368 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='7011'DB:business_master_new
loadtime:0.15555191040039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deering' limit 1
loadtime:0.15558695793152 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='7011'DB:business_master_new
loadtime:0.15798401832581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derry' limit 1
loadtime:0.15803194046021 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='7011'DB:business_master_new
loadtime:0.15944290161133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.15950012207031 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='7011'DB:business_master_new
loadtime:0.15974307060242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.15978097915649 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='7011'DB:business_master_new
loadtime:0.1628270149231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drewsville' limit 1
loadtime:0.16287302970886 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='7011'DB:business_master_new
loadtime:0.16375589370728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.16380405426025 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='7011'DB:business_master_new
loadtime:0.1644070148468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dummer' limit 1
loadtime:0.16443395614624 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='7011'DB:business_master_new
loadtime:0.16510796546936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunbarton' limit 1
loadtime:0.16515803337097 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='7011'DB:business_master_new
loadtime:0.16580200195312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.16584992408752 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='7011'DB:business_master_new
loadtime:0.16955304145813 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Andover' limit 1
loadtime:0.16960000991821 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='7011'DB:business_master_new
loadtime:0.17362904548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Candia' limit 1
loadtime:0.17367911338806 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='7011'DB:business_master_new
loadtime:0.17392301559448 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Derry' limit 1
loadtime:0.17395496368408 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='7011'DB:business_master_new
loadtime:0.18369698524475 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampstead' limit 1
loadtime:0.18374609947205 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='7011'DB:business_master_new
loadtime:0.18436503410339 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hebron' limit 1
loadtime:0.18441295623779 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='7011'DB:business_master_new
loadtime:0.18493008613586 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Kingston' limit 1
loadtime:0.18496608734131 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='7011'DB:business_master_new
loadtime:0.18565511703491 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Swanzey' limit 1
loadtime:0.18570399284363 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='7011'DB:business_master_new
loadtime:0.18595600128174 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wakefield' limit 1
loadtime:0.18598389625549 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='7011'DB:business_master_new
loadtime:0.19909000396729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eaton Center' limit 1
loadtime:0.19914507865906 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='7011'DB:business_master_new
loadtime:0.20661306381226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Effingham' limit 1
loadtime:0.20666193962097 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='7011'DB:business_master_new
loadtime:0.21278595924377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.21284508705139 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='7011'DB:business_master_new
loadtime:0.21802306175232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.21808004379272 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='7011'DB:business_master_new
loadtime:0.21832299232483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.21836304664612 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='7011'DB:business_master_new
loadtime:0.22030901908875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield Center' limit 1
loadtime:0.22035503387451 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='7011'DB:business_master_new
loadtime:0.22300791740417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epping' limit 1
loadtime:0.22305989265442 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='7011'DB:business_master_new
loadtime:0.22499895095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epsom' limit 1
loadtime:0.22503590583801 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='7011'DB:business_master_new
loadtime:0.22578191757202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Errol' limit 1
loadtime:0.22582411766052 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='7011'DB:business_master_new
loadtime:0.22829103469849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.22832608222961 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='7011'DB:business_master_new
loadtime:0.24231004714966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeter' limit 1
loadtime:0.24237298965454 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='7011'DB:business_master_new
loadtime:0.24504899978638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.24510812759399 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='7011'DB:business_master_new
loadtime:0.24628710746765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitzwilliam' limit 1
loadtime:0.24634599685669 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='7011'DB:business_master_new
loadtime:0.24741101264954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Francestown' limit 1
loadtime:0.24745512008667 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='7011'DB:business_master_new
loadtime:0.24900794029236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.24906611442566 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='7011'DB:business_master_new
loadtime:0.25343012809753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.25349402427673 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='7011'DB:business_master_new
loadtime:0.25553512573242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.25559592247009 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='7011'DB:business_master_new
loadtime:0.25688505172729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.25694394111633 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='7011'DB:business_master_new
loadtime:0.25762701034546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georges Mills' limit 1
loadtime:0.2576630115509 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.27842402458191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilford' limit 1
loadtime:0.2785439491272 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='7011'DB:business_master_new
loadtime:0.28480005264282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton' limit 1
loadtime:0.28487110137939 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='7011'DB:business_master_new
loadtime:0.28615307807922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1
loadtime:0.28621697425842 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='7011'DB:business_master_new
loadtime:0.29895091056824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilsum' limit 1
loadtime:0.29901003837585 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='7011'DB:business_master_new
loadtime:0.31151509284973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.31155300140381 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='7011'DB:business_master_new
loadtime:0.31418108940125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencliff' limit 1
loadtime:0.31425595283508 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='7011'DB:business_master_new
loadtime:0.31541204452515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1
loadtime:0.31544899940491 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='7011'DB:business_master_new
loadtime:0.31656789779663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goffstown' limit 1
loadtime:0.31661796569824 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='7011'DB:business_master_new
loadtime:0.31820106506348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:0.31825995445251 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='7011'DB:business_master_new
loadtime:0.32387900352478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.32393312454224 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='7011'DB:business_master_new
loadtime:0.34087300300598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.34095692634583 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='7011'DB:business_master_new
loadtime:0.35227704048157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantham' limit 1
loadtime:0.35231399536133 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='7011'DB:business_master_new
loadtime:0.35323190689087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.35328698158264 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='7011'DB:business_master_new
loadtime:0.35469603538513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.35475301742554 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='7011'DB:business_master_new
loadtime:0.35554790496826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.35560512542725 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='7011'DB:business_master_new
loadtime:0.35626912117004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveton' limit 1
loadtime:0.35631799697876 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='7011'DB:business_master_new
loadtime:0.35779690742493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guild' limit 1
loadtime:0.35784292221069 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='7011'DB:business_master_new
loadtime:0.36102294921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hales Location' limit 1
loadtime:0.36107301712036 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='7011'DB:business_master_new
loadtime:0.36132192611694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.36135411262512 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='7011'DB:business_master_new
loadtime:0.36212110519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.36217594146729 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='7011'DB:business_master_new
loadtime:0.38238406181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton Falls' limit 1
loadtime:0.38251495361328 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.38351106643677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.38357496261597 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='7011'DB:business_master_new
loadtime:0.38481211662292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.3848569393158 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='7011'DB:business_master_new
loadtime:0.38663196563721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.38668894767761 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='7011'DB:business_master_new
loadtime:0.38729190826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harts Location' limit 1
loadtime:0.3873291015625 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='7011'DB:business_master_new
loadtime:0.38840889930725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.38846707344055 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='7011'DB:business_master_new
loadtime:0.39420390129089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.39424800872803 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='7011'DB:business_master_new
loadtime:0.40493392944336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henniker' limit 1
loadtime:0.40499305725098 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='7011'DB:business_master_new
loadtime:0.4065990447998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill' limit 1
loadtime:0.40664601325989 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.4072539806366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.40731000900269 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='7011'DB:business_master_new
loadtime:0.42020511627197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.42026495933533 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='7011'DB:business_master_new
loadtime:0.42181706428528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.42187690734863 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='7011'DB:business_master_new
loadtime:0.42256212234497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holderness' limit 1
loadtime:0.42261004447937 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='7011'DB:business_master_new
loadtime:0.43455100059509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollis' limit 1
loadtime:0.43462204933167 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='7011'DB:business_master_new
loadtime:0.4354350566864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooksett' limit 1
loadtime:0.43547201156616 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='7011'DB:business_master_new
loadtime:0.43714904785156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.43721795082092 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='7011'DB:business_master_new
loadtime:0.43972396850586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.43979096412659 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='7011'DB:business_master_new
loadtime:0.44112300872803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Intervale' limit 1
loadtime:0.44116997718811 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='7011'DB:business_master_new
loadtime:0.44424891471863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.44431304931641 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='7011'DB:business_master_new
loadtime:0.45324492454529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jaffrey' limit 1
loadtime:0.45332503318787 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='7011'DB:business_master_new
loadtime:0.45597410202026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.45603203773499 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='7011'DB:business_master_new
loadtime:0.45838308334351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearsarge' limit 1
loadtime:0.45844507217407 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='7011'DB:business_master_new
loadtime:0.46123194694519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.46127510070801 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='7011'DB:business_master_new
loadtime:0.46432900428772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:0.46439003944397 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='7011'DB:business_master_new
loadtime:0.46494889259338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.46499395370483 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='7011'DB:business_master_new
loadtime:0.46577095985413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:0.46582102775574 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='7011'DB:business_master_new
loadtime:0.4784300327301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.47851204872131 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='7011'DB:business_master_new
loadtime:0.48130893707275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landaff' limit 1
loadtime:0.48135709762573 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='7011'DB:business_master_new
loadtime:0.48184704780579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langdon' limit 1
loadtime:0.4818959236145 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='7011'DB:business_master_new
loadtime:0.48310589790344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.48315691947937 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='7011'DB:business_master_new
loadtime:0.48476696014404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:0.48481202125549 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='7011'DB:business_master_new
loadtime:0.48568606376648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lempster' limit 1
loadtime:0.48574209213257 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='7011'DB:business_master_new
loadtime:0.49723410606384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.49728608131409 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='7011'DB:business_master_new
loadtime:0.50513792037964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.50522804260254 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='7011'DB:business_master_new
loadtime:0.50696706771851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.50702595710754 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='7011'DB:business_master_new
loadtime:0.50770807266235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.50774502754211 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='7011'DB:business_master_new
loadtime:0.51075911521912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lochmere' limit 1
loadtime:0.51081800460815 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='7011'DB:business_master_new
loadtime:0.51454401016235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.51459908485413 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='7011'DB:business_master_new
loadtime:0.51655793190002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loudon' limit 1
loadtime:0.51661491394043 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='7011'DB:business_master_new
loadtime:0.51784110069275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.51789999008179 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='7011'DB:business_master_new
loadtime:0.51813197135925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme' limit 1
loadtime:0.51816606521606 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='7011'DB:business_master_new
loadtime:0.52027893066406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyme Center' limit 1
loadtime:0.52033805847168 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='7011'DB:business_master_new
loadtime:0.52129912376404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndeborough' limit 1
loadtime:0.52133512496948 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='7011'DB:business_master_new
loadtime:0.52195501327515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madbury' limit 1
loadtime:0.52200198173523 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='7011'DB:business_master_new
loadtime:0.53091311454773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.53096294403076 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='7011'DB:business_master_new
loadtime:0.53222107887268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.53227090835571 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='7011'DB:business_master_new
loadtime:0.63059210777283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.63072204589844 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='7011'DB:business_master_new
loadtime:0.63156008720398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlow' limit 1
loadtime:0.63161492347717 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='7011'DB:business_master_new
loadtime:0.63898110389709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:0.6390368938446 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='7011'DB:business_master_new
loadtime:0.64092993736267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadows' limit 1
loadtime:0.6409649848938 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='7011'DB:business_master_new
loadtime:0.64121508598328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin Village' limit 1
loadtime:0.64125394821167 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='7011'DB:business_master_new
loadtime:0.64805293083191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.648118019104 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='7011'DB:business_master_new
loadtime:0.64909291267395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.64914107322693 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='7011'DB:business_master_new
loadtime:0.6589150428772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimack' limit 1
loadtime:0.65897107124329 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='7011'DB:business_master_new
loadtime:0.66017389297485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:0.66024303436279 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='7011'DB:business_master_new
loadtime:0.66050601005554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.66054391860962 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='7011'DB:business_master_new
loadtime:0.66114592552185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.66117906570435 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='7011'DB:business_master_new
loadtime:0.66214203834534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.66219902038574 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='7011'DB:business_master_new
loadtime:0.66282200813293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Mills' limit 1
loadtime:0.66285395622253 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.66494297981262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mirror Lake' limit 1
loadtime:0.66497802734375 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.67079710960388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.6708459854126 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='7011'DB:business_master_new
loadtime:0.67971205711365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mont Vernon' limit 1
loadtime:0.67974495887756 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='7011'DB:business_master_new
loadtime:0.68039011955261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moultonborough' limit 1
loadtime:0.68043494224548 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='7011'DB:business_master_new
loadtime:0.68122100830078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sunapee' limit 1
loadtime:0.68125796318054 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='7011'DB:business_master_new
loadtime:0.68148803710938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munsonville' limit 1
loadtime:0.68152499198914 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='7011'DB:business_master_new
loadtime:0.68297600746155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.68301701545715 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='7011'DB:business_master_new
loadtime:0.68534207344055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.68539094924927 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='7011'DB:business_master_new
loadtime:0.68694400787354 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:0.6869809627533 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='7011'DB:business_master_new
loadtime:0.68767499923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.68770599365234 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='7011'DB:business_master_new
loadtime:0.68832612037659 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Durham' limit 1
loadtime:0.6883659362793 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='7011'DB:business_master_new
loadtime:0.68896412849426 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:0.68900203704834 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='7011'DB:business_master_new
loadtime:0.68964600563049 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ipswich' limit 1
loadtime:0.68967509269714 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='7011'DB:business_master_new
loadtime:0.6903600692749 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.69039797782898 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='7011'DB:business_master_new
loadtime:0.69140005111694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.69144606590271 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='7011'DB:business_master_new
loadtime:0.6920850276947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfields' limit 1
loadtime:0.69211792945862 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='7011'DB:business_master_new
loadtime:0.69270706176758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.69273996353149 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='7011'DB:business_master_new
loadtime:0.69451498985291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newmarket' limit 1
loadtime:0.69455289840698 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='7011'DB:business_master_new
loadtime:0.69526410102844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.69530010223389 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='7011'DB:business_master_new
loadtime:0.69610810279846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.69614005088806 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='7011'DB:business_master_new
loadtime:0.69678211212158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Junction' limit 1
loadtime:0.69681692123413 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.70007801055908 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Conway' limit 1
loadtime:0.7001039981842 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='7011'DB:business_master_new
loadtime:0.70159697532654 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:0.7016749382019 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='7011'DB:business_master_new
loadtime:0.7025260925293 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haverhill' limit 1
loadtime:0.70255994796753 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='7011'DB:business_master_new
loadtime:0.70318508148193 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:0.70323610305786 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='7011'DB:business_master_new
loadtime:0.70979905128479 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sandwich' limit 1
loadtime:0.70982909202576 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='7011'DB:business_master_new
loadtime:0.71273589134216 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stratford' limit 1
loadtime:0.71278095245361 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='7011'DB:business_master_new
loadtime:0.71338391304016 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Sutton' limit 1
loadtime:0.71342706680298 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='7011'DB:business_master_new
loadtime:0.71642899513245 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Walpole' limit 1
loadtime:0.71646595001221 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='7011'DB:business_master_new
loadtime:0.72186398506165 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Woodstock' limit 1
loadtime:0.72191309928894 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='7011'DB:business_master_new
loadtime:0.72272801399231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.72277998924255 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='7011'DB:business_master_new
loadtime:0.7233099937439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:0.72335195541382 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='7011'DB:business_master_new
loadtime:0.72411203384399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottingham' limit 1
loadtime:0.72415709495544 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='7011'DB:business_master_new
loadtime:0.72480010986328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.72484803199768 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='7011'DB:business_master_new
loadtime:0.72508597373962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orford' limit 1
loadtime:0.72511291503906 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='7011'DB:business_master_new
loadtime:0.72578096389771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossipee' limit 1
loadtime:0.72583889961243 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='7011'DB:business_master_new
loadtime:0.72654104232788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:0.72660803794861 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='7011'DB:business_master_new
loadtime:0.72743201255798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:0.72746896743774 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='7011'DB:business_master_new
loadtime:0.72905707359314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penacook' limit 1
loadtime:0.72910404205322 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='7011'DB:business_master_new
loadtime:0.72938299179077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterborough' limit 1
loadtime:0.72941303253174 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='7011'DB:business_master_new
loadtime:0.73031210899353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piermont' limit 1
loadtime:0.73035907745361 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='7011'DB:business_master_new
loadtime:0.74039602279663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike' limit 1
loadtime:0.74044108390808 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='7011'DB:business_master_new
loadtime:0.7426700592041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:0.74272394180298 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='7011'DB:business_master_new
loadtime:0.74352407455444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:0.74358010292053 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='7011'DB:business_master_new
loadtime:0.74426007270813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.74428796768188 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='7011'DB:business_master_new
loadtime:0.74492001533508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plaistow' limit 1
loadtime:0.744961977005 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='7011'DB:business_master_new
loadtime:0.74583601951599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.74587607383728 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='7011'DB:business_master_new
loadtime:0.74681210517883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.7468581199646 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='7011'DB:business_master_new
loadtime:0.74900007247925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.74906301498413 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='7011'DB:business_master_new
loadtime:0.75043797492981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.75048494338989 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='7011'DB:business_master_new
loadtime:0.75123405456543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.75129199028015 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='7011'DB:business_master_new
loadtime:0.75183701515198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rindge' limit 1
loadtime:0.75187397003174 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='7011'DB:business_master_new
loadtime:0.75259900093079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.75265908241272 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='7011'DB:business_master_new
loadtime:0.75392007827759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rollinsford' limit 1
loadtime:0.75396800041199 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='7011'DB:business_master_new
loadtime:0.75464797019958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.75469708442688 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='7011'DB:business_master_new
loadtime:0.75491690635681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumney' limit 1
loadtime:0.75494503974915 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='7011'DB:business_master_new
loadtime:0.75559306144714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:0.75564002990723 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='7011'DB:business_master_new
loadtime:0.7564709186554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye Beach' limit 1
loadtime:0.75653290748596 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='7011'DB:business_master_new
loadtime:0.76453495025635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.7645959854126 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:0.76605010032654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.7660961151123 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='7011'DB:business_master_new
loadtime:0.76679110527039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornton' limit 1
loadtime:0.76683497428894 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='7011'DB:business_master_new
loadtime:0.76754093170166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanbornville' limit 1
loadtime:0.76759791374207 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='7011'DB:business_master_new
loadtime:0.76832008361816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandown' limit 1
loadtime:0.76836490631104 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='7011'DB:business_master_new
loadtime:0.76899695396423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.76904511451721 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='7011'DB:business_master_new
loadtime:0.76995992660522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.77000689506531 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='7011'DB:business_master_new
loadtime:0.77067589759827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne' limit 1
loadtime:0.77073502540588 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='7011'DB:business_master_new
loadtime:0.77129197120667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:0.77132701873779 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.77423191070557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersworth' limit 1
loadtime:0.77428889274597 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='7011'DB:business_master_new
loadtime:0.77518391609192 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Acworth' limit 1
loadtime:0.7752571105957 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='7011'DB:business_master_new
loadtime:0.77924299240112 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Effingham' limit 1
loadtime:0.7792809009552 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='7011'DB:business_master_new
loadtime:0.779541015625 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hampton' limit 1
loadtime:0.77959609031677 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='7011'DB:business_master_new
loadtime:0.78038311004639 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Newbury' limit 1
loadtime:0.78042101860046 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='7011'DB:business_master_new
loadtime:0.78070402145386 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Sutton' limit 1
loadtime:0.78074908256531 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='7011'DB:business_master_new
loadtime:0.78225994110107 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Tamworth' limit 1
loadtime:0.78229594230652 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='7011'DB:business_master_new
loadtime:0.78404998779297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spofford' limit 1
loadtime:0.78410506248474 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='7011'DB:business_master_new
loadtime:0.78475189208984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.78480911254883 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='7011'DB:business_master_new
loadtime:0.78540396690369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stark' limit 1
loadtime:0.78543090820312 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='7011'DB:business_master_new
loadtime:0.78566598892212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartstown' limit 1
loadtime:0.78570199012756 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='7011'DB:business_master_new
loadtime:0.78592991828918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stinson Lake' limit 1
loadtime:0.785964012146 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.78616309165955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoddard' limit 1
loadtime:0.78619909286499 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='7011'DB:business_master_new
loadtime:0.79036903381348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.79041790962219 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='7011'DB:business_master_new
loadtime:0.79105806350708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratham' limit 1
loadtime:0.79111003875732 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='7011'DB:business_master_new
loadtime:0.7919499874115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Hill' limit 1
loadtime:0.79199290275574 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='7011'DB:business_master_new
loadtime:0.79465699195862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:0.79471707344055 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='7011'DB:business_master_new
loadtime:0.79763603210449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunapee' limit 1
loadtime:0.79768395423889 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='7011'DB:business_master_new
loadtime:0.79847192764282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suncook' limit 1
loadtime:0.79851198196411 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='7011'DB:business_master_new
loadtime:0.79932808876038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:0.79937601089478 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='7011'DB:business_master_new
loadtime:0.80004811286926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanzey' limit 1
loadtime:0.80008411407471 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='7011'DB:business_master_new
loadtime:0.80086803436279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamworth' limit 1
loadtime:0.80092597007751 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='7011'DB:business_master_new
loadtime:0.80166411399841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:0.80172300338745 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='7011'DB:business_master_new
loadtime:0.80236601829529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.8024001121521 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='7011'DB:business_master_new
loadtime:0.80796003341675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tilton' limit 1
loadtime:0.80801796913147 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='7011'DB:business_master_new
loadtime:0.80897402763367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.80903601646423 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='7011'DB:business_master_new
loadtime:0.80966901779175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Twin Mountain' limit 1
loadtime:0.80970597267151 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='7011'DB:business_master_new
loadtime:0.81059312820435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.81066298484802 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='7011'DB:business_master_new
loadtime:0.81128191947937 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:0.81133198738098 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='7011'DB:business_master_new
loadtime:0.81210398674011 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Peterborough' limit 1
loadtime:0.81214690208435 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='7011'DB:business_master_new
loadtime:0.81238102912903 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Stewartstown' limit 1
loadtime:0.81242108345032 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='7011'DB:business_master_new
loadtime:0.8162100315094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:0.81626605987549 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='7011'DB:business_master_new
loadtime:0.81696605682373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.81700110435486 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='7011'DB:business_master_new
loadtime:0.81773400306702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.81779098510742 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='7011'DB:business_master_new
loadtime:0.82450103759766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.82455897331238 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='7011'DB:business_master_new
loadtime:0.8252100944519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Valley' limit 1
loadtime:0.82525491714478 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.82599592208862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville Vly' limit 1
loadtime:0.82604002952576 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='7011'DB:business_master_new
loadtime:0.82654190063477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weare' limit 1
loadtime:0.82659602165222 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='7011'DB:business_master_new
loadtime:0.82742691040039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.82746601104736 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='7011'DB:business_master_new
loadtime:0.82774496078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.82778692245483 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='7011'DB:business_master_new
loadtime:0.82844710350037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworths Loctn' limit 1
loadtime:0.82849597930908 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='7011'DB:business_master_new
loadtime:0.82873511314392 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:0.82876491546631 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='7011'DB:business_master_new
loadtime:0.82935810089111 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:0.82939910888672 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='7011'DB:business_master_new
loadtime:0.83026194572449 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Nottingham' limit 1
loadtime:0.83031296730042 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='7011'DB:business_master_new
loadtime:0.83197903633118 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Ossipee' limit 1
loadtime:0.83201003074646 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='7011'DB:business_master_new
loadtime:0.83266091346741 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Peterborough' limit 1
loadtime:0.83271098136902 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='7011'DB:business_master_new
loadtime:0.83349800109863 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:0.83352899551392 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='7011'DB:business_master_new
loadtime:0.83378195762634 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stewartstown' limit 1
loadtime:0.83382201194763 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='7011'DB:business_master_new
loadtime:0.83554005622864 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Swanzey' limit 1
loadtime:0.83557510375977 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='7011'DB:business_master_new
loadtime:0.83623504638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:0.83627796173096 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='7011'DB:business_master_new
loadtime:0.83691811561584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitefield' limit 1
loadtime:0.83695793151855 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='7011'DB:business_master_new
loadtime:0.83774209022522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.83779501914978 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='7011'DB:business_master_new
loadtime:0.83845496177673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot Flat' limit 1
loadtime:0.83850502967834 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='7011'DB:business_master_new
loadtime:0.83874106407166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.83877301216125 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='7011'DB:business_master_new
loadtime:0.8395459651947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:0.83959794044495 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='7011'DB:business_master_new
loadtime:0.84031009674072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.84034204483032 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='7011'DB:business_master_new
loadtime:0.8411660194397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.84123706817627 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='7011'DB:business_master_new
loadtime:0.84160304069519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnisquam' limit 1
loadtime:0.84164190292358 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='7011'DB:business_master_new
loadtime:0.84229803085327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro' limit 1
loadtime:0.84233808517456 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='7011'DB:business_master_new
loadtime:0.84345293045044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolfeboro Falls' limit 1
loadtime:0.8435161113739 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='7011'DB:business_master_new
loadtime:0.84415602684021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wonalancet' limit 1
loadtime:0.84421396255493 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='7011'DB:business_master_new
loadtime:0.84495902061462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.84500002861023 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='7011'DB:business_master_new
loadtime:0.84563994407654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodsville' limit 1
loadtime:0.84569096565247 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='7011'DB:business_master_new
loadtime:0.84639191627502 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.84648299217224 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.84666991233826 / seconds
Operation template executed (chunk cache operation)
loadtime:0.84675002098083 / seconds
template override:Default
loadtime:0.8467710018158 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.84760499000549 / seconds
Template Constructed, Array Rows:49
loadtime:0.8478410243988 / seconds
TOTAL EXECUTION TIME: 0.84765
loadtime:0.84796190261841 / 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] => hotels-and-motels [stateURLid] => new-hampshire )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.84796905517578
TOTAL KEY ARRAYS: 69