Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:9.1075897216797E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018470287322998 / seconds
host not found setting manual db connection
loadtime:0.0096051692962646 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0098650455474854 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010110139846802 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010179996490479 / seconds
zipcode:
loadtime:0.010208129882812 / seconds
Query Executed:select * from search_referrer where page_hash='3d7df26fbe403433fb485ab7a2a07ae1' limit 10 DB:ezrox_toadli
loadtime:0.010480165481567 / seconds
Operation header executed (non global)
loadtime:0.010513067245483 / seconds
Operation leaderboard executed (non global)
loadtime:0.010565042495728 / seconds
Operation square executed (non global)
loadtime:0.010594129562378 / seconds
Operation square_bottom executed (non global)
loadtime:0.010622024536133 / seconds
Operation smallsquare executed (non global)
loadtime:0.010647058486938 / seconds
Operation headeradright executed (non global)
loadtime:0.010672092437744 / seconds
Operation google_analytics executed (non global)
loadtime:0.01069712638855 / seconds
Operation topstories executed (non global)
loadtime:0.010722160339355 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010749101638794 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0107741355896 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011088132858276 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011334180831909 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01137113571167 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011431217193604 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011480093002319 / seconds
Template key: archive_menu pushed
loadtime:0.011489152908325 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011503219604492 / seconds
Template key: get_gravatar pushed
loadtime:0.01150918006897 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011518001556396 / seconds
*10)-10)+1 | start:0
loadtime:0.011560201644897 / seconds
DB connected to localhost business_master_new
loadtime:0.011787176132202 / seconds
Query Executed:select * from categories where cat_URLid='retail-bakeries'DB:business_master_new
loadtime:0.012768030166626 / seconds
Query stored in cache : _QUERY_www.toadli.com4c1dab8efba749ffdae7a52224d8c45c
loadtime:0.01282811164856 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.012868165969849 / seconds
Query Executed:select * from `ma_catmap` where sic='5461' order by city ascDB:business_master_new
loadtime:0.030220031738281 / seconds
Query stored in cache : _QUERY_www.toadli.comf7167113ce1c12ab78682bc6077fe677
loadtime:0.032415151596069 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.032476186752319 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='5461'DB:business_master_new
loadtime:0.035415172576904 / seconds
Query stored in cache : _QUERY_www.toadli.com66821a7d54a3a85cfbe4d1def6946a86
loadtime:0.03545618057251 / seconds
559 / 11
loadtime:0.035513162612915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.035579204559326 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='5461'DB:business_master_new
loadtime:0.057258129119873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.057342052459717 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='5461'DB:business_master_new
loadtime:0.057860136032104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.057928085327148 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='5461'DB:business_master_new
loadtime:0.068766117095947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.068852186203003 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='5461'DB:business_master_new
loadtime:0.072925090789795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.073003053665161 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='5461'DB:business_master_new
loadtime:0.077095985412598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.077174186706543 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='5461'DB:business_master_new
loadtime:0.08440113067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.084484100341797 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='5461'DB:business_master_new
loadtime:0.08489203453064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.084956169128418 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='5461'DB:business_master_new
loadtime:0.093341112136841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.093427181243896 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='5461'DB:business_master_new
loadtime:0.1006190776825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.10070204734802 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='5461'DB:business_master_new
loadtime:0.11156105995178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.11164808273315 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='5461'DB:business_master_new
loadtime:0.12601804733276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.1261191368103 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='5461'DB:business_master_new
loadtime:0.12651920318604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.12658309936523 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='5461'DB:business_master_new
loadtime:0.14015221595764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.14023900032043 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='5461'DB:business_master_new
loadtime:0.14065718650818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.14071917533875 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='5461'DB:business_master_new
loadtime:0.14112019538879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.14118099212646 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='5461'DB:business_master_new
loadtime:0.14416003227234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.14422202110291 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='5461'DB:business_master_new
loadtime:0.14562821388245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.1456880569458 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='5461'DB:business_master_new
loadtime:0.14673018455505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.14679002761841 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='5461'DB:business_master_new
loadtime:0.15393114089966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.15401315689087 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.15464210510254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.15470409393311 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='5461'DB:business_master_new
loadtime:0.15643310546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.156494140625 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='5461'DB:business_master_new
loadtime:0.16191101074219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.1619930267334 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='5461'DB:business_master_new
loadtime:0.17514705657959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.17523598670959 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='5461'DB:business_master_new
loadtime:0.17672204971313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.17678499221802 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='5461'DB:business_master_new
loadtime:0.18620800971985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.18629217147827 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='5461'DB:business_master_new
loadtime:0.19043898582458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.1905210018158 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='5461'DB:business_master_new
loadtime:0.19449019432068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.19457006454468 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='5461'DB:business_master_new
loadtime:0.19896006584167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.19903707504272 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='5461'DB:business_master_new
loadtime:0.19946599006653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.19952702522278 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='5461'DB:business_master_new
loadtime:0.20063614845276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.20069718360901 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='5461'DB:business_master_new
loadtime:0.20408010482788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.2041552066803 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='5461'DB:business_master_new
loadtime:0.20738005638123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.20744299888611 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='5461'DB:business_master_new
loadtime:0.20782017707825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.20788216590881 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='5461'DB:business_master_new
loadtime:0.20896816253662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.20902800559998 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='5461'DB:business_master_new
loadtime:0.21664714813232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.21672511100769 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='5461'DB:business_master_new
loadtime:0.22141814231873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.22149515151978 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='5461'DB:business_master_new
loadtime:0.22772908210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.22780799865723 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='5461'DB:business_master_new
loadtime:0.23798418045044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.23808312416077 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='5461'DB:business_master_new
loadtime:0.23968601226807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.23976111412048 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='5461'DB:business_master_new
loadtime:0.24027419090271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.24033498764038 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='5461'DB:business_master_new
loadtime:0.24182510375977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.24190521240234 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='5461'DB:business_master_new
loadtime:0.24311208724976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.24318599700928 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='5461'DB:business_master_new
loadtime:0.26020503044128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.26029920578003 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='5461'DB:business_master_new
loadtime:0.27006912231445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.27015113830566 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='5461'DB:business_master_new
loadtime:0.27336406707764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.273442029953 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='5461'DB:business_master_new
loadtime:0.27422118186951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.27428317070007 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='5461'DB:business_master_new
loadtime:0.27731513977051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.27737712860107 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='5461'DB:business_master_new
loadtime:0.27798700332642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.27805805206299 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='5461'DB:business_master_new
loadtime:0.29240202903748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:0.29260921478271 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='5461'DB:business_master_new
loadtime:0.29356408119202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:0.29363608360291 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='5461'DB:business_master_new
loadtime:0.29682898521423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:0.29691004753113 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='5461'DB:business_master_new
loadtime:0.30002808570862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:0.30011606216431 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='5461'DB:business_master_new
loadtime:0.30306816101074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.30314421653748 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='5461'DB:business_master_new
loadtime:0.30355310440063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:0.30361700057983 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='5461'DB:business_master_new
loadtime:0.320965051651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:0.32106804847717 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='5461'DB:business_master_new
loadtime:0.32164311408997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.32170605659485 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='5461'DB:business_master_new
loadtime:0.32758212089539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.32766199111938 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='5461'DB:business_master_new
loadtime:0.33469414710999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.3347761631012 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='5461'DB:business_master_new
loadtime:0.34627103805542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:0.34635901451111 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='5461'DB:business_master_new
loadtime:0.348060131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:0.3481240272522 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='5461'DB:business_master_new
loadtime:0.37337112426758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.37349200248718 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='5461'DB:business_master_new
loadtime:0.37490606307983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.37497210502625 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='5461'DB:business_master_new
loadtime:0.39533519744873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:0.39543199539185 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='5461'DB:business_master_new
loadtime:0.39595699310303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:0.39601922035217 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='5461'DB:business_master_new
loadtime:0.39642906188965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:0.3964900970459 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='5461'DB:business_master_new
loadtime:0.39702415466309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:0.39709615707397 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='5461'DB:business_master_new
loadtime:0.39768505096436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.39774608612061 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='5461'DB:business_master_new
loadtime:0.41150903701782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:0.41159701347351 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='5461'DB:business_master_new
loadtime:0.41801309585571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:0.4181079864502 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='5461'DB:business_master_new
loadtime:0.4194610118866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.41952300071716 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='5461'DB:business_master_new
loadtime:0.46849918365479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.4686541557312 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='5461'DB:business_master_new
loadtime:0.4803102016449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.48040199279785 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='5461'DB:business_master_new
loadtime:0.48260521888733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:0.4826672077179 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='5461'DB:business_master_new
loadtime:0.4871461391449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:0.48722219467163 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='5461'DB:business_master_new
loadtime:0.48845219612122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.48852705955505 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='5461'DB:business_master_new
loadtime:0.4936511516571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:0.49372911453247 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='5461'DB:business_master_new
loadtime:0.49471020698547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.49477100372314 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='5461'DB:business_master_new
loadtime:0.50224804878235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:0.50232815742493 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='5461'DB:business_master_new
loadtime:0.50753307342529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:0.50761198997498 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='5461'DB:business_master_new
loadtime:0.508141040802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:0.50820302963257 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='5461'DB:business_master_new
loadtime:0.50864601135254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:0.50870609283447 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='5461'DB:business_master_new
loadtime:0.50923299789429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.50929403305054 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='5461'DB:business_master_new
loadtime:0.51521301269531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:0.51529312133789 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='5461'DB:business_master_new
loadtime:0.52743315696716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.52751803398132 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='5461'DB:business_master_new
loadtime:0.53746509552002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:0.53755402565002 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='5461'DB:business_master_new
loadtime:0.53858804702759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.53865098953247 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='5461'DB:business_master_new
loadtime:0.53990912437439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.53997206687927 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='5461'DB:business_master_new
loadtime:0.54075908660889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.54081916809082 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='5461'DB:business_master_new
loadtime:0.54157209396362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:0.54163217544556 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='5461'DB:business_master_new
loadtime:0.5486171245575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:0.54870009422302 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='5461'DB:business_master_new
loadtime:0.56281805038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:0.56291317939758 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='5461'DB:business_master_new
loadtime:0.56457710266113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.56464004516602 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='5461'DB:business_master_new
loadtime:0.56505608558655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.56511807441711 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='5461'DB:business_master_new
loadtime:0.57047700881958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:0.57055521011353 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='5461'DB:business_master_new
loadtime:0.57569003105164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:0.57577109336853 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='5461'DB:business_master_new
loadtime:0.57665514945984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.57671713829041 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='5461'DB:business_master_new
loadtime:0.58917212486267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.58925414085388 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='5461'DB:business_master_new
loadtime:0.59021711349487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:0.59027910232544 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='5461'DB:business_master_new
loadtime:0.59201407432556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:0.59210014343262 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='5461'DB:business_master_new
loadtime:0.59261107444763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:0.5926730632782 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='5461'DB:business_master_new
loadtime:0.59354019165039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:0.59361410140991 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='5461'DB:business_master_new
loadtime:0.59406018257141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.59412217140198 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='5461'DB:business_master_new
loadtime:0.59714508056641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:0.59720706939697 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='5461'DB:business_master_new
loadtime:0.61189007759094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:0.61199903488159 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='5461'DB:business_master_new
loadtime:0.6126070022583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.61267018318176 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='5461'DB:business_master_new
loadtime:0.62418413162231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.62426519393921 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='5461'DB:business_master_new
loadtime:0.62519216537476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.62525415420532 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='5461'DB:business_master_new
loadtime:0.62882709503174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:0.62890815734863 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='5461'DB:business_master_new
loadtime:0.63225507736206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:0.63233709335327 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='5461'DB:business_master_new
loadtime:0.63339805603027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:0.63346099853516 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='5461'DB:business_master_new
loadtime:0.63504004478455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.63511300086975 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='5461'DB:business_master_new
loadtime:0.65245413780212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:0.65254616737366 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='5461'DB:business_master_new
loadtime:0.65297818183899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.65304112434387 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='5461'DB:business_master_new
loadtime:0.65650606155396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.65658712387085 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='5461'DB:business_master_new
loadtime:0.65953612327576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:0.65959906578064 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='5461'DB:business_master_new
loadtime:0.66849517822266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:0.6685791015625 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='5461'DB:business_master_new
loadtime:0.66902017593384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.66909313201904 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='5461'DB:business_master_new
loadtime:0.67290806770325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:0.67298412322998 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='5461'DB:business_master_new
loadtime:0.67441010475159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:0.67448616027832 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='5461'DB:business_master_new
loadtime:0.6811420917511 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.68122100830078 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='5461'DB:business_master_new
loadtime:0.68161821365356 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:0.68167901039124 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='5461'DB:business_master_new
loadtime:0.68268799781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:0.68276309967041 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='5461'DB:business_master_new
loadtime:0.68781805038452 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:0.6878821849823 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='5461'DB:business_master_new
loadtime:0.68908619880676 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:0.68914818763733 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='5461'DB:business_master_new
loadtime:0.69011521339417 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:0.69017720222473 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='5461'DB:business_master_new
loadtime:0.69059014320374 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:0.6906521320343 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='5461'DB:business_master_new
loadtime:0.69781804084778 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:0.69790601730347 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='5461'DB:business_master_new
loadtime:0.701327085495 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:0.70140600204468 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='5461'DB:business_master_new
loadtime:0.70952200889587 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:0.70960021018982 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='5461'DB:business_master_new
loadtime:0.71000814437866 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:0.71008110046387 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='5461'DB:business_master_new
loadtime:0.71094799041748 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:0.71100902557373 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='5461'DB:business_master_new
loadtime:0.71153712272644 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:0.71160006523132 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='5461'DB:business_master_new
loadtime:0.71199798583984 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:0.71206998825073 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='5461'DB:business_master_new
loadtime:0.71514511108398 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:0.71520709991455 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='5461'DB:business_master_new
loadtime:0.71669912338257 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:0.7167751789093 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='5461'DB:business_master_new
loadtime:0.71740102767944 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:0.71746301651001 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='5461'DB:business_master_new
loadtime:0.71921110153198 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:0.71928715705872 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='5461'DB:business_master_new
loadtime:0.72218012809753 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:0.72225904464722 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='5461'DB:business_master_new
loadtime:0.72859001159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:0.72867012023926 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='5461'DB:business_master_new
loadtime:0.73112607002258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:0.73120307922363 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='5461'DB:business_master_new
loadtime:0.73814511299133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.73822402954102 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='5461'DB:business_master_new
loadtime:0.73888516426086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:0.73896217346191 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='5461'DB:business_master_new
loadtime:0.74526500701904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:0.74534702301025 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='5461'DB:business_master_new
loadtime:0.74576807022095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:0.74583005905151 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='5461'DB:business_master_new
loadtime:0.74646902084351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.74652910232544 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='5461'DB:business_master_new
loadtime:0.75015306472778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:0.75022912025452 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='5461'DB:business_master_new
loadtime:0.76207304000854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:0.76216411590576 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='5461'DB:business_master_new
loadtime:0.76876902580261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:0.76885104179382 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='5461'DB:business_master_new
loadtime:0.7950701713562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.79521203041077 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='5461'DB:business_master_new
loadtime:0.80489015579224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:0.80499219894409 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='5461'DB:business_master_new
loadtime:0.80562520027161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:0.80568718910217 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='5461'DB:business_master_new
loadtime:0.80993318557739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:0.81000900268555 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='5461'DB:business_master_new
loadtime:0.81164598464966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:0.81172204017639 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='5461'DB:business_master_new
loadtime:0.82545018196106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.82554721832275 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='5461'DB:business_master_new
loadtime:0.83022713661194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:0.8303050994873 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='5461'DB:business_master_new
loadtime:0.83072400093079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:0.83078598976135 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='5461'DB:business_master_new
loadtime:0.83187818527222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:0.83194303512573 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='5461'DB:business_master_new
loadtime:0.83969712257385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:0.83977508544922 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='5461'DB:business_master_new
loadtime:0.85348606109619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.85357999801636 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='5461'DB:business_master_new
loadtime:0.86457204818726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.86466002464294 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='5461'DB:business_master_new
loadtime:0.87248110771179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:0.872563123703 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='5461'DB:business_master_new
loadtime:0.87296199798584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.87302303314209 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='5461'DB:business_master_new
loadtime:0.87722611427307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.87730121612549 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='5461'DB:business_master_new
loadtime:0.87810707092285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.8781681060791 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='5461'DB:business_master_new
loadtime:0.87895917892456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.87901902198792 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='5461'DB:business_master_new
loadtime:0.87946200370789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.87952208518982 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='5461'DB:business_master_new
loadtime:0.89358115196228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.89366602897644 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='5461'DB:business_master_new
loadtime:0.89429521560669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.89435815811157 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='5461'DB:business_master_new
loadtime:0.89796710014343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.89802813529968 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='5461'DB:business_master_new
loadtime:0.90062618255615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.9007031917572 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='5461'DB:business_master_new
loadtime:0.90166401863098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:0.90172600746155 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='5461'DB:business_master_new
loadtime:0.9099440574646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:0.91002416610718 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='5461'DB:business_master_new
loadtime:0.91055417060852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:0.91061615943909 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='5461'DB:business_master_new
loadtime:0.91110610961914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.91116619110107 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='5461'DB:business_master_new
loadtime:0.92108821868896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.92117214202881 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='5461'DB:business_master_new
loadtime:0.92582511901855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:0.9259090423584 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='5461'DB:business_master_new
loadtime:0.92901015281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:0.92910003662109 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='5461'DB:business_master_new
loadtime:0.93406414985657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.93414211273193 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='5461'DB:business_master_new
loadtime:0.9371190071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.93719506263733 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='5461'DB:business_master_new
loadtime:0.93783211708069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:0.93791103363037 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='5461'DB:business_master_new
loadtime:0.9410560131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.94113516807556 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='5461'DB:business_master_new
loadtime:0.94175004959106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.94181299209595 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='5461'DB:business_master_new
loadtime:0.95127701759338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:0.95135998725891 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='5461'DB:business_master_new
loadtime:0.95196008682251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:0.95202207565308 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='5461'DB:business_master_new
loadtime:0.95607614517212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.95615410804749 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='5461'DB:business_master_new
loadtime:0.95688009262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:0.95694613456726 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='5461'DB:business_master_new
loadtime:0.96064209938049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:0.96072006225586 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='5461'DB:business_master_new
loadtime:0.96664118766785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:0.9667181968689 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='5461'DB:business_master_new
loadtime:0.96871113777161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:0.96878600120544 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='5461'DB:business_master_new
loadtime:0.97014713287354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:0.97021007537842 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='5461'DB:business_master_new
loadtime:0.97067999839783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.97074007987976 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='5461'DB:business_master_new
loadtime:0.98894500732422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:0.98904013633728 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='5461'DB:business_master_new
loadtime:0.98946905136108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:0.98953318595886 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='5461'DB:business_master_new
loadtime:0.9905412197113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:0.99060106277466 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='5461'DB:business_master_new
loadtime:0.99112820625305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:0.99118900299072 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='5461'DB:business_master_new
loadtime:1.0034241676331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:1.0035049915314 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='5461'DB:business_master_new
loadtime:1.0046231746674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:1.0046861171722 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='5461'DB:business_master_new
loadtime:1.0093162059784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:1.0093941688538 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='5461'DB:business_master_new
loadtime:1.0153610706329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:1.0154411792755 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='5461'DB:business_master_new
loadtime:1.0162260532379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:1.0163011550903 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='5461'DB:business_master_new
loadtime:1.023638010025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:1.0237011909485 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='5461'DB:business_master_new
loadtime:1.0388321876526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:1.0389220714569 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='5461'DB:business_master_new
loadtime:1.0421512126923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.0422141551971 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='5461'DB:business_master_new
loadtime:1.0483191013336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:1.048397064209 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='5461'DB:business_master_new
loadtime:1.0494930744171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.0495681762695 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='5461'DB:business_master_new
loadtime:1.0511159896851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.0511782169342 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='5461'DB:business_master_new
loadtime:1.0595049858093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.0595850944519 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='5461'DB:business_master_new
loadtime:1.0640110969543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:1.0641031265259 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='5461'DB:business_master_new
loadtime:1.0645961761475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.064658164978 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='5461'DB:business_master_new
loadtime:1.0658550262451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:1.0659201145172 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='5461'DB:business_master_new
loadtime:1.0838191509247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:1.0839149951935 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='5461'DB:business_master_new
loadtime:1.0844721794128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:1.0845351219177 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='5461'DB:business_master_new
loadtime:1.092236995697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:1.0923171043396 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='5461'DB:business_master_new
loadtime:1.0963201522827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:1.0963971614838 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='5461'DB:business_master_new
loadtime:1.1036901473999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:1.1037700176239 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='5461'DB:business_master_new
loadtime:1.1148722171783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.114963054657 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='5461'DB:business_master_new
loadtime:1.1159801483154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.1160440444946 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='5461'DB:business_master_new
loadtime:1.1232430934906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:1.123321056366 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:1.1237461566925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.1238071918488 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='5461'DB:business_master_new
loadtime:1.1286001205444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.1286771297455 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='5461'DB:business_master_new
loadtime:1.1317751407623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.1318371295929 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='5461'DB:business_master_new
loadtime:1.1338741779327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.1339530944824 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='5461'DB:business_master_new
loadtime:1.1527349948883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.1528360843658 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='5461'DB:business_master_new
loadtime:1.157769203186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.1578500270844 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='5461'DB:business_master_new
loadtime:1.1587660312653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.1588280200958 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='5461'DB:business_master_new
loadtime:1.1623661518097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.1624431610107 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='5461'DB:business_master_new
loadtime:1.1670670509338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:1.1671431064606 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='5461'DB:business_master_new
loadtime:1.1677520275116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:1.1678130626678 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='5461'DB:business_master_new
loadtime:1.1837441921234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:1.1838331222534 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='5461'DB:business_master_new
loadtime:1.1847970485687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.1848599910736 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='5461'DB:business_master_new
loadtime:1.1995460987091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:1.199630022049 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='5461'DB:business_master_new
loadtime:1.2000741958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.2001371383667 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='5461'DB:business_master_new
loadtime:1.2040710449219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.2041480541229 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='5461'DB:business_master_new
loadtime:1.2048552036285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.2049221992493 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='5461'DB:business_master_new
loadtime:1.210529088974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:1.2106051445007 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='5461'DB:business_master_new
loadtime:1.2160379886627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.2161271572113 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='5461'DB:business_master_new
loadtime:1.2426462173462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.2427580356598 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='5461'DB:business_master_new
loadtime:1.2502272129059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:1.2503101825714 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='5461'DB:business_master_new
loadtime:1.254212141037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.2542870044708 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='5461'DB:business_master_new
loadtime:1.2743151187897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:1.2744140625 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='5461'DB:business_master_new
loadtime:1.2790081501007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:1.2791001796722 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='5461'DB:business_master_new
loadtime:1.2951550483704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:1.295243024826 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='5461'DB:business_master_new
loadtime:1.2958312034607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.2959010601044 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='5461'DB:business_master_new
loadtime:1.2986421585083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:1.2987160682678 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='5461'DB:business_master_new
loadtime:1.2996511459351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:1.2997131347656 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='5461'DB:business_master_new
loadtime:1.3134641647339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:1.3135461807251 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='5461'DB:business_master_new
loadtime:1.3240151405334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.3241081237793 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='5461'DB:business_master_new
loadtime:1.3278331756592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.3279139995575 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='5461'DB:business_master_new
loadtime:1.345899105072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:1.345997095108 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='5461'DB:business_master_new
loadtime:1.3553349971771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:1.3554201126099 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='5461'DB:business_master_new
loadtime:1.3559520244598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:1.3560140132904 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='5461'DB:business_master_new
loadtime:1.3605320453644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:1.3606081008911 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='5461'DB:business_master_new
loadtime:1.3683001995087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:1.3683791160583 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='5461'DB:business_master_new
loadtime:1.3738861083984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:1.3739972114563 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='5461'DB:business_master_new
loadtime:1.3782651424408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:1.3783411979675 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='5461'DB:business_master_new
loadtime:1.3836221694946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:1.38370013237 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='5461'DB:business_master_new
loadtime:1.389368057251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:1.389445066452 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='5461'DB:business_master_new
loadtime:1.4065589904785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:1.4066610336304 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='5461'DB:business_master_new
loadtime:1.4119870662689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.4120800495148 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='5461'DB:business_master_new
loadtime:1.4210209846497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.421117067337 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='5461'DB:business_master_new
loadtime:1.4249331951141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:1.4250102043152 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='5461'DB:business_master_new
loadtime:1.4254422187805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:1.4255030155182 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='5461'DB:business_master_new
loadtime:1.428747177124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:1.4288260936737 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='5461'DB:business_master_new
loadtime:1.4423990249634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:1.4424870014191 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='5461'DB:business_master_new
loadtime:1.4510991573334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:1.4511849880219 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='5461'DB:business_master_new
loadtime:1.4517061710358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.4517691135406 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='5461'DB:business_master_new
loadtime:1.4569571018219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.4570381641388 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='5461'DB:business_master_new
loadtime:1.4694321155548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:1.469523191452 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='5461'DB:business_master_new
loadtime:1.4701511859894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:1.4702141284943 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='5461'DB:business_master_new
loadtime:1.4763970375061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:1.4764740467072 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='5461'DB:business_master_new
loadtime:1.4771339893341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:1.4771962165833 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='5461'DB:business_master_new
loadtime:1.4816370010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:1.4817140102386 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='5461'DB:business_master_new
loadtime:1.4826951026917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.4827580451965 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='5461'DB:business_master_new
loadtime:1.4902930259705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:1.4903700351715 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='5461'DB:business_master_new
loadtime:1.4908030033112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:1.4908649921417 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='5461'DB:business_master_new
loadtime:1.4912731647491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:1.4913330078125 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='5461'DB:business_master_new
loadtime:1.4917211532593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:1.4917800426483 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='5461'DB:business_master_new
loadtime:1.4922211170197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:1.4922831058502 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='5461'DB:business_master_new
loadtime:1.4962201118469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.4962961673737 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='5461'DB:business_master_new
loadtime:1.4975650310516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:1.4976260662079 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='5461'DB:business_master_new
loadtime:1.4983501434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.498409986496 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='5461'DB:business_master_new
loadtime:1.4988431930542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:1.4989080429077 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.4995992183685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:1.4996590614319 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='5461'DB:business_master_new
loadtime:1.5133991241455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:1.5134751796722 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='5461'DB:business_master_new
loadtime:1.5251550674438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:1.5252351760864 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='5461'DB:business_master_new
loadtime:1.5419790744781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:1.5420830249786 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='5461'DB:business_master_new
loadtime:1.5554370880127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:1.5555300712585 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='5461'DB:business_master_new
loadtime:1.5640721321106 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:1.564150094986 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='5461'DB:business_master_new
loadtime:1.5645730495453 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:1.5646340847015 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='5461'DB:business_master_new
loadtime:1.5932071208954 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:1.5933420658112 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='5461'DB:business_master_new
loadtime:1.5942251682281 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:1.5942940711975 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='5461'DB:business_master_new
loadtime:1.5947949886322 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:1.5948550701141 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='5461'DB:business_master_new
loadtime:1.5955510139465 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:1.5956110954285 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='5461'DB:business_master_new
loadtime:1.596134185791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.5961940288544 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='5461'DB:business_master_new
loadtime:1.5992300510406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:1.599308013916 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='5461'DB:business_master_new
loadtime:1.6120321750641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.6121261119843 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='5461'DB:business_master_new
loadtime:1.6212902069092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:1.6213731765747 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='5461'DB:business_master_new
loadtime:1.6323800086975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:1.6324620246887 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='5461'DB:business_master_new
loadtime:1.6373510360718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:1.6374320983887 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='5461'DB:business_master_new
loadtime:1.6392450332642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:1.6393082141876 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='5461'DB:business_master_new
loadtime:1.6397120952606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:1.6397721767426 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='5461'DB:business_master_new
loadtime:1.6443300247192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:1.644406080246 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='5461'DB:business_master_new
loadtime:1.6448311805725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:1.6448981761932 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='5461'DB:business_master_new
loadtime:1.6501212120056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:1.650199174881 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='5461'DB:business_master_new
loadtime:1.6505961418152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:1.6506581306458 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='5461'DB:business_master_new
loadtime:1.6547031402588 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.6547791957855 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='5461'DB:business_master_new
loadtime:1.6618540287018 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:1.6619381904602 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='5461'DB:business_master_new
loadtime:1.6624541282654 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:1.6625161170959 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='5461'DB:business_master_new
loadtime:1.6742031574249 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:1.6742889881134 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='5461'DB:business_master_new
loadtime:1.6838581562042 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:1.6839501857758 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='5461'DB:business_master_new
loadtime:1.6896741390228 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:1.689756155014 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='5461'DB:business_master_new
loadtime:1.692675113678 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:1.6927380561829 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='5461'DB:business_master_new
loadtime:1.6931459903717 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:1.693207025528 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='5461'DB:business_master_new
loadtime:1.6936800479889 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:1.6937401294708 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='5461'DB:business_master_new
loadtime:1.6945672035217 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:1.6946280002594 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='5461'DB:business_master_new
loadtime:1.6994349956512 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:1.6995100975037 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='5461'DB:business_master_new
loadtime:1.7082660198212 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:1.7083461284637 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='5461'DB:business_master_new
loadtime:1.7096841335297 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:1.7097589969635 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='5461'DB:business_master_new
loadtime:1.7108931541443 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:1.710969209671 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='5461'DB:business_master_new
loadtime:1.7160069942474 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:1.7161002159119 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='5461'DB:business_master_new
loadtime:1.7165780067444 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:1.716639995575 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='5461'DB:business_master_new
loadtime:1.7197930812836 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:1.7198820114136 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='5461'DB:business_master_new
loadtime:1.7236711978912 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:1.7237501144409 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='5461'DB:business_master_new
loadtime:1.7242300510406 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:1.7242920398712 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='5461'DB:business_master_new
loadtime:1.7247381210327 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:1.7247982025146 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='5461'DB:business_master_new
loadtime:1.7260341644287 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:1.7261180877686 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='5461'DB:business_master_new
loadtime:1.7265861034393 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:1.7266461849213 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='5461'DB:business_master_new
loadtime:1.7271060943604 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:1.7271680831909 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='5461'DB:business_master_new
loadtime:1.7342720031738 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:1.7343511581421 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='5461'DB:business_master_new
loadtime:1.7348120212555 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:1.7348740100861 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='5461'DB:business_master_new
loadtime:1.7359690666199 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:1.7360291481018 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='5461'DB:business_master_new
loadtime:1.7367100715637 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:1.7367701530457 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='5461'DB:business_master_new
loadtime:1.7372071743011 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:1.7372670173645 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='5461'DB:business_master_new
loadtime:1.7395250797272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:1.7395989894867 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='5461'DB:business_master_new
loadtime:1.7534461021423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:1.7535281181335 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='5461'DB:business_master_new
loadtime:1.7623891830444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:1.7624740600586 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='5461'DB:business_master_new
loadtime:1.7653450965881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.765408039093 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='5461'DB:business_master_new
loadtime:1.7667920589447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:1.7668662071228 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='5461'DB:business_master_new
loadtime:1.7726521492004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:1.7727320194244 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='5461'DB:business_master_new
loadtime:1.780109167099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.7801880836487 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='5461'DB:business_master_new
loadtime:1.7963140010834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:1.796403169632 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.7968430519104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:1.7969110012054 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='5461'DB:business_master_new
loadtime:1.8016610145569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:1.8017401695251 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='5461'DB:business_master_new
loadtime:1.8026921749115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:1.8027541637421 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='5461'DB:business_master_new
loadtime:1.8031871318817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:1.803248167038 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='5461'DB:business_master_new
loadtime:1.8041651248932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.8042302131653 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='5461'DB:business_master_new
loadtime:1.8081650733948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.8082430362701 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='5461'DB:business_master_new
loadtime:1.8162980079651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:1.8164441585541 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='5461'DB:business_master_new
loadtime:1.8213081359863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:1.8213810920715 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='5461'DB:business_master_new
loadtime:1.8223791122437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.8224420547485 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='5461'DB:business_master_new
loadtime:1.8273541927338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.827436208725 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='5461'DB:business_master_new
loadtime:1.8329641819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:1.8330571651459 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='5461'DB:business_master_new
loadtime:1.8346571922302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:1.8347320556641 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='5461'DB:business_master_new
loadtime:1.8532311916351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.8533329963684 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='5461'DB:business_master_new
loadtime:1.8537871837616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.8538501262665 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='5461'DB:business_master_new
loadtime:1.8616540431976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:1.861732006073 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='5461'DB:business_master_new
loadtime:1.8666741847992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.8667521476746 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='5461'DB:business_master_new
loadtime:1.8672301769257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:1.8672912120819 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='5461'DB:business_master_new
loadtime:1.8683001995087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:1.8683609962463 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='5461'DB:business_master_new
loadtime:1.8688139915466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:1.8688740730286 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='5461'DB:business_master_new
loadtime:1.8693161010742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.8693771362305 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='5461'DB:business_master_new
loadtime:1.8881590366364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.8882501125336 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='5461'DB:business_master_new
loadtime:1.8889000415802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:1.888964176178 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='5461'DB:business_master_new
loadtime:1.8935170173645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.8935980796814 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='5461'DB:business_master_new
loadtime:1.9146740436554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:1.9147779941559 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='5461'DB:business_master_new
loadtime:1.9164230823517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:1.9164991378784 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='5461'DB:business_master_new
loadtime:1.9196140766144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:1.9196891784668 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='5461'DB:business_master_new
loadtime:1.9201672077179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.9202270507812 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='5461'DB:business_master_new
loadtime:1.9218480587006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:1.9219131469727 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='5461'DB:business_master_new
loadtime:1.9290161132812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:1.9291090965271 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='5461'DB:business_master_new
loadtime:1.9566411972046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.9567542076111 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='5461'DB:business_master_new
loadtime:1.9659931659698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:1.9660890102386 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='5461'DB:business_master_new
loadtime:1.972843170166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:1.9729330539703 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='5461'DB:business_master_new
loadtime:1.9734530448914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:1.9735159873962 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='5461'DB:business_master_new
loadtime:1.9821670055389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:1.982250213623 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='5461'DB:business_master_new
loadtime:1.982794046402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:1.9828560352325 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='5461'DB:business_master_new
loadtime:1.9877090454102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:1.9877851009369 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='5461'DB:business_master_new
loadtime:1.9998490810394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.9999461174011 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='5461'DB:business_master_new
loadtime:2.0009582042694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:2.0010221004486 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='5461'DB:business_master_new
loadtime:2.0020260810852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:2.0020990371704 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='5461'DB:business_master_new
loadtime:2.0038900375366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:2.003986120224 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='5461'DB:business_master_new
loadtime:2.0114641189575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:2.0115430355072 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='5461'DB:business_master_new
loadtime:2.0167231559753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:2.0168030261993 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='5461'DB:business_master_new
loadtime:2.0246441364288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:2.0247330665588 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='5461'DB:business_master_new
loadtime:2.0253381729126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:2.0254011154175 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='5461'DB:business_master_new
loadtime:2.0297222137451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:2.0298011302948 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='5461'DB:business_master_new
loadtime:2.0379199981689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:2.0379991531372 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='5461'DB:business_master_new
loadtime:2.0406420230865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:2.0407221317291 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='5461'DB:business_master_new
loadtime:2.0414571762085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:2.0415182113647 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='5461'DB:business_master_new
loadtime:2.0423011779785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:2.042375087738 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='5461'DB:business_master_new
loadtime:2.0445971488953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:2.044673204422 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='5461'DB:business_master_new
loadtime:2.0457692146301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:2.0458459854126 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='5461'DB:business_master_new
loadtime:2.0475180149078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:2.0475940704346 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='5461'DB:business_master_new
loadtime:2.064474105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.0645711421967 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='5461'DB:business_master_new
loadtime:2.0705120563507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:2.0705940723419 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='5461'DB:business_master_new
loadtime:2.0710320472717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:2.0711061954498 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='5461'DB:business_master_new
loadtime:2.0718450546265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:2.0719101428986 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='5461'DB:business_master_new
loadtime:2.0791070461273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:2.0791881084442 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='5461'DB:business_master_new
loadtime:2.0896182060242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:2.0897030830383 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='5461'DB:business_master_new
loadtime:2.0902810096741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:2.0903429985046 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='5461'DB:business_master_new
loadtime:2.1040921211243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:2.1041750907898 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='5461'DB:business_master_new
loadtime:2.1114571094513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.111545085907 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='5461'DB:business_master_new
loadtime:2.1177251338959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.1178040504456 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='5461'DB:business_master_new
loadtime:2.1202120780945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:2.120274066925 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='5461'DB:business_master_new
loadtime:2.1236071586609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:2.1236691474915 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='5461'DB:business_master_new
loadtime:2.1241390705109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:2.1241991519928 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='5461'DB:business_master_new
loadtime:2.1271212100983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:2.1271960735321 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='5461'DB:business_master_new
loadtime:2.1301720142365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:2.1302490234375 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='5461'DB:business_master_new
loadtime:2.1436591148376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:2.1437451839447 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='5461'DB:business_master_new
loadtime:2.1444900035858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:2.1445531845093 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='5461'DB:business_master_new
loadtime:2.1452100276947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:2.1452701091766 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='5461'DB:business_master_new
loadtime:2.1456620693207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.1457211971283 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='5461'DB:business_master_new
loadtime:2.1514790058136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.1515641212463 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='5461'DB:business_master_new
loadtime:2.1719892024994 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:2.1721131801605 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='5461'DB:business_master_new
loadtime:2.1727070808411 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.1727712154388 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='5461'DB:business_master_new
loadtime:2.1734781265259 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:2.1735391616821 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='5461'DB:business_master_new
loadtime:2.1741321086884 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:2.1741931438446 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='5461'DB:business_master_new
loadtime:2.1752820014954 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:2.1753430366516 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='5461'DB:business_master_new
loadtime:2.1757371425629 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:2.1757969856262 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='5461'DB:business_master_new
loadtime:2.1803750991821 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:2.1804552078247 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='5461'DB:business_master_new
loadtime:2.1831901073456 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:2.1832661628723 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='5461'DB:business_master_new
loadtime:2.1877779960632 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:2.18785405159 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='5461'DB:business_master_new
loadtime:2.1943550109863 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:2.1944351196289 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='5461'DB:business_master_new
loadtime:2.1952610015869 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:2.1953229904175 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='5461'DB:business_master_new
loadtime:2.1965072154999 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:2.1965680122375 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='5461'DB:business_master_new
loadtime:2.2020330429077 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:2.2021191120148 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='5461'DB:business_master_new
loadtime:2.2048401832581 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:2.2049210071564 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='5461'DB:business_master_new
loadtime:2.2054769992828 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:2.2055389881134 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='5461'DB:business_master_new
loadtime:2.2062051296234 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:2.2062652111053 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='5461'DB:business_master_new
loadtime:2.2068011760712 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:2.2068610191345 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='5461'DB:business_master_new
loadtime:2.2075011730194 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:2.2075622081757 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='5461'DB:business_master_new
loadtime:2.2081370353699 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:2.2081980705261 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='5461'DB:business_master_new
loadtime:2.2089331150055 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:2.2089931964874 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='5461'DB:business_master_new
loadtime:2.2153561115265 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:2.2154381275177 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='5461'DB:business_master_new
loadtime:2.2220621109009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:2.2221481800079 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='5461'DB:business_master_new
loadtime:2.2241179943085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:2.2241950035095 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='5461'DB:business_master_new
loadtime:2.2297830581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:2.2298591136932 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.2362310886383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.236307144165 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='5461'DB:business_master_new
loadtime:2.2369241714478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:2.236985206604 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='5461'DB:business_master_new
loadtime:2.2416172027588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.2416951656342 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='5461'DB:business_master_new
loadtime:2.2471539974213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.2472321987152 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='5461'DB:business_master_new
loadtime:2.2609651088715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.2610931396484 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='5461'DB:business_master_new
loadtime:2.2653131484985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:2.2653791904449 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='5461'DB:business_master_new
loadtime:2.2658979892731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.2659611701965 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.2676961421967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:2.2677700519562 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='5461'DB:business_master_new
loadtime:2.2771961688995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.2772769927979 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='5461'DB:business_master_new
loadtime:2.2897610664368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:2.2898499965668 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='5461'DB:business_master_new
loadtime:2.2941420078278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:2.2942202091217 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.2987430095673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:2.2988200187683 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='5461'DB:business_master_new
loadtime:2.307296037674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:2.3073740005493 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='5461'DB:business_master_new
loadtime:2.3088250160217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:2.3088910579681 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='5461'DB:business_master_new
loadtime:2.3131680488586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:2.313246011734 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='5461'DB:business_master_new
loadtime:2.3190841674805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:2.3191630840302 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='5461'DB:business_master_new
loadtime:2.3257961273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:2.3258831501007 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='5461'DB:business_master_new
loadtime:2.3407740592957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:2.3408691883087 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='5461'DB:business_master_new
loadtime:2.3412930965424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.3413569927216 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='5461'DB:business_master_new
loadtime:2.3428761959076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:2.3429582118988 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='5461'DB:business_master_new
loadtime:2.3534150123596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:2.353502035141 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='5461'DB:business_master_new
loadtime:2.3541350364685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.354198217392 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='5461'DB:business_master_new
loadtime:2.3553690910339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:2.3554301261902 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='5461'DB:business_master_new
loadtime:2.3558211326599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:2.3558821678162 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='5461'DB:business_master_new
loadtime:2.3605961799622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.3606741428375 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='5461'DB:business_master_new
loadtime:2.3632040023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.3632822036743 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='5461'DB:business_master_new
loadtime:2.3645851612091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:2.3646471500397 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='5461'DB:business_master_new
loadtime:2.3677580356598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:2.3678200244904 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='5461'DB:business_master_new
loadtime:2.37362408638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:2.3737041950226 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='5461'DB:business_master_new
loadtime:2.3742370605469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:2.3742990493774 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='5461'DB:business_master_new
loadtime:2.3779091835022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:2.3779871463776 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.3855609893799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:2.3856410980225 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='5461'DB:business_master_new
loadtime:2.386087179184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:2.3861491680145 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='5461'DB:business_master_new
loadtime:2.3940260410309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:2.3941202163696 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='5461'DB:business_master_new
loadtime:2.3945400714874 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.394602060318 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='5461'DB:business_master_new
loadtime:2.3950409889221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:2.3951120376587 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='5461'DB:business_master_new
loadtime:2.3971982002258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.397274017334 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='5461'DB:business_master_new
loadtime:2.4101111888885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.4101960659027 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='5461'DB:business_master_new
loadtime:2.4111061096191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.4111762046814 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='5461'DB:business_master_new
loadtime:2.4202580451965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:2.4203350543976 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='5461'DB:business_master_new
loadtime:2.4485321044922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:2.4486300945282 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='5461'DB:business_master_new
loadtime:2.4491231441498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:2.4491860866547 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='5461'DB:business_master_new
loadtime:2.4496080875397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:2.4496681690216 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='5461'DB:business_master_new
loadtime:2.4541330337524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:2.4542109966278 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='5461'DB:business_master_new
loadtime:2.4606580734253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.4607400894165 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='5461'DB:business_master_new
loadtime:2.4620070457458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:2.4620962142944 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='5461'DB:business_master_new
loadtime:2.4626851081848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.4627461433411 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='5461'DB:business_master_new
loadtime:2.4631931781769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.4632530212402 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='5461'DB:business_master_new
loadtime:2.4770882129669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:2.4771740436554 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='5461'DB:business_master_new
loadtime:2.4776380062103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.4777011871338 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='5461'DB:business_master_new
loadtime:2.483775138855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.4838540554047 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='5461'DB:business_master_new
loadtime:2.490797996521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:2.4908821582794 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='5461'DB:business_master_new
loadtime:2.4988880157471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:2.4989950656891 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='5461'DB:business_master_new
loadtime:2.5097651481628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:2.5098450183868 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='5461'DB:business_master_new
loadtime:2.5136501789093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.513729095459 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='5461'DB:business_master_new
loadtime:2.5144481658936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:2.5145101547241 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='5461'DB:business_master_new
loadtime:2.5149600505829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:2.5150201320648 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='5461'DB:business_master_new
loadtime:2.5165932178497 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:2.5166540145874 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='5461'DB:business_master_new
loadtime:2.5197660923004 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:2.5198421478271 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='5461'DB:business_master_new
loadtime:2.520339012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:2.5204010009766 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='5461'DB:business_master_new
loadtime:2.5256609916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:2.525740146637 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='5461'DB:business_master_new
loadtime:2.5312371253967 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:2.5313181877136 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='5461'DB:business_master_new
loadtime:2.5331001281738 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:2.5331621170044 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='5461'DB:business_master_new
loadtime:2.5339090824127 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.5339720249176 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='5461'DB:business_master_new
loadtime:2.5344190597534 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:2.5344791412354 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='5461'DB:business_master_new
loadtime:2.53489112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:2.5349531173706 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='5461'DB:business_master_new
loadtime:2.5366251468658 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:2.5366861820221 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='5461'DB:business_master_new
loadtime:2.5375599861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:2.5376200675964 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='5461'DB:business_master_new
loadtime:2.5381951332092 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:2.5382561683655 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='5461'DB:business_master_new
loadtime:2.5395669937134 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:2.5396280288696 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='5461'DB:business_master_new
loadtime:2.5405061244965 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:2.5405671596527 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='5461'DB:business_master_new
loadtime:2.5410690307617 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:2.5411291122437 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='5461'DB:business_master_new
loadtime:2.5415592193604 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:2.5416190624237 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='5461'DB:business_master_new
loadtime:2.5420241355896 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:2.5420961380005 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='5461'DB:business_master_new
loadtime:2.5447900295258 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:2.544851064682 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='5461'DB:business_master_new
loadtime:2.5499761104584 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:2.5500681400299 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='5461'DB:business_master_new
loadtime:2.5583209991455 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:2.5584070682526 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='5461'DB:business_master_new
loadtime:2.5587940216064 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.5588572025299 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='5461'DB:business_master_new
loadtime:2.5739212036133 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:2.5740041732788 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='5461'DB:business_master_new
loadtime:2.5751230716705 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:2.5752000808716 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='5461'DB:business_master_new
loadtime:2.5781450271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:2.5782220363617 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='5461'DB:business_master_new
loadtime:2.5791521072388 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:2.5792140960693 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='5461'DB:business_master_new
loadtime:2.5804660320282 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:2.5805401802063 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='5461'DB:business_master_new
loadtime:2.5812711715698 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:2.5813322067261 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='5461'DB:business_master_new
loadtime:2.5817492008209 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:2.5818090438843 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='5461'DB:business_master_new
loadtime:2.5865712165833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:2.5866510868073 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='5461'DB:business_master_new
loadtime:2.5999820232391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.6000740528107 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='5461'DB:business_master_new
loadtime:2.6138141155243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:2.6139051914215 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='5461'DB:business_master_new
loadtime:2.6230940818787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:2.6231751441956 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='5461'DB:business_master_new
loadtime:2.6235840320587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:2.6236460208893 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='5461'DB:business_master_new
loadtime:2.6272571086884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.6273341178894 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='5461'DB:business_master_new
loadtime:2.6323051452637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.632383108139 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='5461'DB:business_master_new
loadtime:2.639121055603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:2.6392002105713 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='5461'DB:business_master_new
loadtime:2.6397061347961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:2.6397671699524 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='5461'DB:business_master_new
loadtime:2.6466720104218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:2.6467521190643 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='5461'DB:business_master_new
loadtime:2.6524081230164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:2.6524860858917 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='5461'DB:business_master_new
loadtime:2.6534090042114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:2.6534700393677 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='5461'DB:business_master_new
loadtime:2.6539239883423 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:2.6539831161499 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='5461'DB:business_master_new
loadtime:2.6543910503387 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:2.6544511318207 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='5461'DB:business_master_new
loadtime:2.6549220085144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:2.6549830436707 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='5461'DB:business_master_new
loadtime:2.6593961715698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:2.6594750881195 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='5461'DB:business_master_new
loadtime:2.6646990776062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:2.6647791862488 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='5461'DB:business_master_new
loadtime:2.670844078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:2.6709291934967 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='5461'DB:business_master_new
loadtime:2.671355009079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.6714169979095 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='5461'DB:business_master_new
loadtime:2.6730110645294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:2.6730980873108 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='5461'DB:business_master_new
loadtime:2.6775851249695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.6776621341705 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='5461'DB:business_master_new
loadtime:2.6873030662537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:2.6873841285706 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='5461'DB:business_master_new
loadtime:2.6914250850677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:2.6915040016174 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='5461'DB:business_master_new
loadtime:2.6919531822205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:2.692015171051 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='5461'DB:business_master_new
loadtime:2.6925420761108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.6926031112671 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='5461'DB:business_master_new
loadtime:2.7017080783844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.7017920017242 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='5461'DB:business_master_new
loadtime:2.7024691104889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.7025320529938 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='5461'DB:business_master_new
loadtime:2.7087721824646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:2.7088530063629 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='5461'DB:business_master_new
loadtime:2.7311379909515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:2.7312490940094 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='5461'DB:business_master_new
loadtime:2.7316801548004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:2.7317430973053 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='5461'DB:business_master_new
loadtime:2.7330050468445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.7330911159515 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='5461'DB:business_master_new
loadtime:2.7335751056671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:2.733635187149 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='5461'DB:business_master_new
loadtime:2.7473750114441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:2.7475180625916 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='5461'DB:business_master_new
loadtime:2.7479591369629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.7480251789093 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='5461'DB:business_master_new
loadtime:2.7489550113678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:2.7490150928497 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='5461'DB:business_master_new
loadtime:2.755261182785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:2.7553381919861 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='5461'DB:business_master_new
loadtime:2.7595980167389 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.7597501277924 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.7602140903473 / seconds
Operation template executed (chunk cache operation)
loadtime:2.7603781223297 / seconds
template override:Default
loadtime:2.7604191303253 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:2.7616560459137 / seconds
Template Constructed, Array Rows:49
loadtime:2.7622041702271 / seconds
TOTAL EXECUTION TIME: 2.76175
loadtime:2.76509308815 / 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] => retail-bakeries [stateURLid] => massachusetts )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:2.7651040554047
TOTAL KEY ARRAYS: 69