Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.0108642578125E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018770694732666 / seconds
host not found setting manual db connection
loadtime:0.0099010467529297 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010200023651123 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010416984558105 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010493993759155 / seconds
zipcode:
loadtime:0.010524034500122 / seconds
Query Executed:select * from search_referrer where page_hash='c3abdb2346b406562984040f0cc9353a' limit 10 DB:ezrox_toadli
loadtime:0.010766983032227 / seconds
Operation header executed (non global)
loadtime:0.01079797744751 / seconds
Operation leaderboard executed (non global)
loadtime:0.010853052139282 / seconds
Operation square executed (non global)
loadtime:0.010885000228882 / seconds
Operation square_bottom executed (non global)
loadtime:0.010914087295532 / seconds
Operation smallsquare executed (non global)
loadtime:0.010941982269287 / seconds
Operation headeradright executed (non global)
loadtime:0.010968208312988 / seconds
Operation google_analytics executed (non global)
loadtime:0.01099419593811 / seconds
Operation topstories executed (non global)
loadtime:0.011021137237549 / seconds
Operation businessnearyou executed (non global)
loadtime:0.011049032211304 / seconds
Operation memberbuscount executed (non global)
loadtime:0.011075019836426 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011314153671265 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011482000350952 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011519193649292 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011579990386963 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011628150939941 / seconds
Template key: archive_menu pushed
loadtime:0.011638164520264 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011651039123535 / seconds
Template key: get_gravatar pushed
loadtime:0.011658191680908 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011667013168335 / seconds
*10)-10)+1 | start:0
loadtime:0.011710166931152 / seconds
Query loaded from cache:select * from categories where cat_URLid='schools-and-educational-services-nec'
loadtime:0.011752128601074 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.011790990829468 / seconds
DB connected to localhost business_master_new
loadtime:0.012026071548462 / seconds
Query Executed:select * from `ma_catmap` where sic='8299' order by city ascDB:business_master_new
loadtime:0.028103113174438 / seconds
Query stored in cache : _QUERY_www.toadli.com94a8820f3064151fc078c5812a54ec2b
loadtime:0.030358076095581 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='massachusetts'
loadtime:0.030421018600464 / seconds
Query Executed:select sum(totalcount) as totalsum from `ma_catmap` where sic='8299'DB:business_master_new
loadtime:0.033429145812988 / seconds
Query stored in cache : _QUERY_www.toadli.com0e5a9e517fe6d1818b4343441955700e
loadtime:0.033465147018433 / seconds
559 / 11
loadtime:0.033524036407471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.033591032028198 / seconds
Query Executed:select id FROM `ma` where city='Abington' && SIC_code='8299'DB:business_master_new
loadtime:0.048374176025391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Accord' limit 1
loadtime:0.048448085784912 / seconds
Query Executed:select id FROM `ma` where city='Accord' && SIC_code='8299'DB:business_master_new
loadtime:0.048959016799927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acton' limit 1
loadtime:0.049012184143066 / seconds
Query Executed:select id FROM `ma` where city='Acton' && SIC_code='8299'DB:business_master_new
loadtime:0.059882164001465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Acushnet' limit 1
loadtime:0.059969186782837 / seconds
Query Executed:select id FROM `ma` where city='Acushnet' && SIC_code='8299'DB:business_master_new
loadtime:0.064000129699707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adams' limit 1
loadtime:0.064055204391479 / seconds
Query Executed:select id FROM `ma` where city='Adams' && SIC_code='8299'DB:business_master_new
loadtime:0.068071126937866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Agawam' limit 1
loadtime:0.068138122558594 / seconds
Query Executed:select id FROM `ma` where city='Agawam' && SIC_code='8299'DB:business_master_new
loadtime:0.075272083282471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alford' limit 1
loadtime:0.075342178344727 / seconds
Query Executed:select id FROM `ma` where city='Alford' && SIC_code='8299'DB:business_master_new
loadtime:0.075729131698608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allston' limit 1
loadtime:0.075783014297485 / seconds
Query Executed:select id FROM `ma` where city='Allston' && SIC_code='8299'DB:business_master_new
loadtime:0.084084987640381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amesbury' limit 1
loadtime:0.084160089492798 / seconds
Query Executed:select id FROM `ma` where city='Amesbury' && SIC_code='8299'DB:business_master_new
loadtime:0.091331005096436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.09141206741333 / seconds
Query Executed:select id FROM `ma` where city='Amherst' && SIC_code='8299'DB:business_master_new
loadtime:0.10222911834717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.10231399536133 / seconds
Query Executed:select id FROM `ma` where city='Andover' && SIC_code='8299'DB:business_master_new
loadtime:0.11670017242432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aquinnah' limit 1
loadtime:0.11679720878601 / seconds
Query Executed:select id FROM `ma` where city='Aquinnah' && SIC_code='8299'DB:business_master_new
loadtime:0.11720609664917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.11726307868958 / seconds
Query Executed:select id FROM `ma` where city='Arlington' && SIC_code='8299'DB:business_master_new
loadtime:0.13093519210815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Heights' limit 1
loadtime:0.131019115448 / seconds
Query Executed:select id FROM `ma` where city='Arlington Heights' && SIC_code='8299'DB:business_master_new
loadtime:0.13145303726196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington Hts' limit 1
loadtime:0.13150811195374 / seconds
Query Executed:select id FROM `ma` where city='Arlington Hts' && SIC_code='8299'DB:business_master_new
loadtime:0.13188099861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashburnham' limit 1
loadtime:0.13193202018738 / seconds
Query Executed:select id FROM `ma` where city='Ashburnham' && SIC_code='8299'DB:business_master_new
loadtime:0.13488101959229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashby' limit 1
loadtime:0.13493609428406 / seconds
Query Executed:select id FROM `ma` where city='Ashby' && SIC_code='8299'DB:business_master_new
loadtime:0.13635802268982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashfield' limit 1
loadtime:0.13641214370728 / seconds
Query Executed:select id FROM `ma` where city='Ashfield' && SIC_code='8299'DB:business_master_new
loadtime:0.137451171875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.13750410079956 / seconds
Query Executed:select id FROM `ma` where city='Ashland' && SIC_code='8299'DB:business_master_new
loadtime:0.14455413818359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashley Falls' limit 1
loadtime:0.14462518692017 / seconds
Query Executed:select id FROM `ma` where city='Ashley Falls' && SIC_code='8299'DB:business_master_new
loadtime:0.14524602890015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Assonet' limit 1
loadtime:0.1453001499176 / seconds
Query Executed:select id FROM `ma` where city='Assonet' && SIC_code='8299'DB:business_master_new
loadtime:0.14701104164124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athol' limit 1
loadtime:0.14706420898438 / seconds
Query Executed:select id FROM `ma` where city='Athol' && SIC_code='8299'DB:business_master_new
loadtime:0.15241003036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro' limit 1
loadtime:0.15248012542725 / seconds
Query Executed:select id FROM `ma` where city='Attleboro' && SIC_code='8299'DB:business_master_new
loadtime:0.16551899909973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attleboro Falls' limit 1
loadtime:0.16559410095215 / seconds
Query Executed:select id FROM `ma` where city='Attleboro Falls' && SIC_code='8299'DB:business_master_new
loadtime:0.16708397865295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.16715216636658 / seconds
Query Executed:select id FROM `ma` where city='Auburn' && SIC_code='8299'DB:business_master_new
loadtime:0.17659711837769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburndale' limit 1
loadtime:0.17666721343994 / seconds
Query Executed:select id FROM `ma` where city='Auburndale' && SIC_code='8299'DB:business_master_new
loadtime:0.18072319030762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.18079018592834 / seconds
Query Executed:select id FROM `ma` where city='Avon' && SIC_code='8299'DB:business_master_new
loadtime:0.18470215797424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayer' limit 1
loadtime:0.18476819992065 / seconds
Query Executed:select id FROM `ma` where city='Ayer' && SIC_code='8299'DB:business_master_new
loadtime:0.18904209136963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Babson Park' limit 1
loadtime:0.18909621238708 / seconds
Query Executed:select id FROM `ma` where city='Babson Park' && SIC_code='8299'DB:business_master_new
loadtime:0.18952107429504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwinville' limit 1
loadtime:0.1895751953125 / seconds
Query Executed:select id FROM `ma` where city='Baldwinville' && SIC_code='8299'DB:business_master_new
loadtime:0.19067311286926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnstable' limit 1
loadtime:0.19072604179382 / seconds
Query Executed:select id FROM `ma` where city='Barnstable' && SIC_code='8299'DB:business_master_new
loadtime:0.19404721260071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barre' limit 1
loadtime:0.19411301612854 / seconds
Query Executed:select id FROM `ma` where city='Barre' && SIC_code='8299'DB:business_master_new
loadtime:0.19732809066772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bass River' limit 1
loadtime:0.19740009307861 / seconds
Query Executed:select id FROM `ma` where city='Bass River' && SIC_code='8299'DB:business_master_new
loadtime:0.19777297973633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becket' limit 1
loadtime:0.19782614707947 / seconds
Query Executed:select id FROM `ma` where city='Becket' && SIC_code='8299'DB:business_master_new
loadtime:0.19890308380127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.19896912574768 / seconds
Query Executed:select id FROM `ma` where city='Bedford' && SIC_code='8299'DB:business_master_new
loadtime:0.20656204223633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belchertown' limit 1
loadtime:0.20663499832153 / seconds
Query Executed:select id FROM `ma` where city='Belchertown' && SIC_code='8299'DB:business_master_new
loadtime:0.2112181186676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellingham' limit 1
loadtime:0.21128416061401 / seconds
Query Executed:select id FROM `ma` where city='Bellingham' && SIC_code='8299'DB:business_master_new
loadtime:0.21742820739746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.21749401092529 / seconds
Query Executed:select id FROM `ma` where city='Belmont' && SIC_code='8299'DB:business_master_new
loadtime:0.22760510444641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkley' limit 1
loadtime:0.22768306732178 / seconds
Query Executed:select id FROM `ma` where city='Berkley' && SIC_code='8299'DB:business_master_new
loadtime:0.22928810119629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkshire' limit 1
loadtime:0.22934317588806 / seconds
Query Executed:select id FROM `ma` where city='Berkshire' && SIC_code='8299'DB:business_master_new
loadtime:0.22983503341675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.22988605499268 / seconds
Query Executed:select id FROM `ma` where city='Berlin' && SIC_code='8299'DB:business_master_new
loadtime:0.2314510345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardston' limit 1
loadtime:0.23151707649231 / seconds
Query Executed:select id FROM `ma` where city='Bernardston' && SIC_code='8299'DB:business_master_new
loadtime:0.23270702362061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.23276114463806 / seconds
Query Executed:select id FROM `ma` where city='Beverly' && SIC_code='8299'DB:business_master_new
loadtime:0.24972009658813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billerica' limit 1
loadtime:0.24980807304382 / seconds
Query Executed:select id FROM `ma` where city='Billerica' && SIC_code='8299'DB:business_master_new
loadtime:0.25961399078369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackstone' limit 1
loadtime:0.25969099998474 / seconds
Query Executed:select id FROM `ma` where city='Blackstone' && SIC_code='8299'DB:business_master_new
loadtime:0.26283597946167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blandford' limit 1
loadtime:0.26290321350098 / seconds
Query Executed:select id FROM `ma` where city='Blandford' && SIC_code='8299'DB:business_master_new
loadtime:0.2636730670929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.26372599601746 / seconds
Query Executed:select id FROM `ma` where city='Bolton' && SIC_code='8299'DB:business_master_new
loadtime:0.2667121887207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondsville' limit 1
loadtime:0.26676511764526 / seconds
Query Executed:select id FROM `ma` where city='Bondsville' && SIC_code='8299'DB:business_master_new
loadtime:0.26737117767334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boston' limit 1
loadtime:0.26742315292358 / seconds
Query Executed:select id FROM `ma` where city='Boston' && SIC_code='8299'DB:business_master_new
loadtime:0.27973008155823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bourne' limit 1
loadtime:0.27994608879089 / seconds
Query Executed:select id FROM `ma` where city='Bourne' && SIC_code='8299'DB:business_master_new
loadtime:0.28088712692261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxborough' limit 1
loadtime:0.28096318244934 / seconds
Query Executed:select id FROM `ma` where city='Boxborough' && SIC_code='8299'DB:business_master_new
loadtime:0.28410816192627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boxford' limit 1
loadtime:0.28417420387268 / seconds
Query Executed:select id FROM `ma` where city='Boxford' && SIC_code='8299'DB:business_master_new
loadtime:0.28717803955078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boylston' limit 1
loadtime:0.28725218772888 / seconds
Query Executed:select id FROM `ma` where city='Boylston' && SIC_code='8299'DB:business_master_new
loadtime:0.29012298583984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.29017615318298 / seconds
Query Executed:select id FROM `ma` where city='Bradford' && SIC_code='8299'DB:business_master_new
loadtime:0.29059410095215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Braintree' limit 1
loadtime:0.29064607620239 / seconds
Query Executed:select id FROM `ma` where city='Braintree' && SIC_code='8299'DB:business_master_new
loadtime:0.30792713165283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brant Rock' limit 1
loadtime:0.30800104141235 / seconds
Query Executed:select id FROM `ma` where city='Brant Rock' && SIC_code='8299'DB:business_master_new
loadtime:0.30858516693115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewster' limit 1
loadtime:0.30863809585571 / seconds
Query Executed:select id FROM `ma` where city='Brewster' && SIC_code='8299'DB:business_master_new
loadtime:0.31442499160767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.31449007987976 / seconds
Query Executed:select id FROM `ma` where city='Bridgewater' && SIC_code='8299'DB:business_master_new
loadtime:0.32147002220154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.32154202461243 / seconds
Query Executed:select id FROM `ma` where city='Brighton' && SIC_code='8299'DB:business_master_new
loadtime:0.33301901817322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brimfield' limit 1
loadtime:0.33309507369995 / seconds
Query Executed:select id FROM `ma` where city='Brimfield' && SIC_code='8299'DB:business_master_new
loadtime:0.3347761631012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brockton' limit 1
loadtime:0.33483099937439 / seconds
Query Executed:select id FROM `ma` where city='Brockton' && SIC_code='8299'DB:business_master_new
loadtime:0.35993313789368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.36003303527832 / seconds
Query Executed:select id FROM `ma` where city='Brookfield' && SIC_code='8299'DB:business_master_new
loadtime:0.36145806312561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline' limit 1
loadtime:0.36152601242065 / seconds
Query Executed:select id FROM `ma` where city='Brookline' && SIC_code='8299'DB:business_master_new
loadtime:0.38180112838745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Village' limit 1
loadtime:0.38189506530762 / seconds
Query Executed:select id FROM `ma` where city='Brookline Village' && SIC_code='8299'DB:business_master_new
loadtime:0.38242411613464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookline Vlg' limit 1
loadtime:0.38248014450073 / seconds
Query Executed:select id FROM `ma` where city='Brookline Vlg' && SIC_code='8299'DB:business_master_new
loadtime:0.38287210464478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryantville' limit 1
loadtime:0.3829231262207 / seconds
Query Executed:select id FROM `ma` where city='Bryantville' && SIC_code='8299'DB:business_master_new
loadtime:0.38345313072205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckland' limit 1
loadtime:0.38352203369141 / seconds
Query Executed:select id FROM `ma` where city='Buckland' && SIC_code='8299'DB:business_master_new
loadtime:0.38409900665283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.38415098190308 / seconds
Query Executed:select id FROM `ma` where city='Burlington' && SIC_code='8299'DB:business_master_new
loadtime:0.39643502235413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buzzards Bay' limit 1
loadtime:0.39651012420654 / seconds
Query Executed:select id FROM `ma` where city='Buzzards Bay' && SIC_code='8299'DB:business_master_new
loadtime:0.40282702445984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byfield' limit 1
loadtime:0.40289902687073 / seconds
Query Executed:select id FROM `ma` where city='Byfield' && SIC_code='8299'DB:business_master_new
loadtime:0.40424704551697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.4043140411377 / seconds
Query Executed:select id FROM `ma` where city='Cambridge' && SIC_code='8299'DB:business_master_new
loadtime:0.45328497886658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.45347619056702 / seconds
Query Executed:select id FROM `ma` where city='Canton' && SIC_code='8299'DB:business_master_new
loadtime:0.46504807472229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlisle' limit 1
loadtime:0.46512508392334 / seconds
Query Executed:select id FROM `ma` where city='Carlisle' && SIC_code='8299'DB:business_master_new
loadtime:0.46734619140625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carver' limit 1
loadtime:0.46741604804993 / seconds
Query Executed:select id FROM `ma` where city='Carver' && SIC_code='8299'DB:business_master_new
loadtime:0.47179198265076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cataumet' limit 1
loadtime:0.47184610366821 / seconds
Query Executed:select id FROM `ma` where city='Cataumet' && SIC_code='8299'DB:business_master_new
loadtime:0.47307205200195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.47313809394836 / seconds
Query Executed:select id FROM `ma` where city='Centerville' && SIC_code='8299'DB:business_master_new
loadtime:0.47822618484497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlemont' limit 1
loadtime:0.4782931804657 / seconds
Query Executed:select id FROM `ma` where city='Charlemont' && SIC_code='8299'DB:business_master_new
loadtime:0.47926807403564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.47932100296021 / seconds
Query Executed:select id FROM `ma` where city='Charlestown' && SIC_code='8299'DB:business_master_new
loadtime:0.48662519454956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton' limit 1
loadtime:0.48667907714844 / seconds
Query Executed:select id FROM `ma` where city='Charlton' && SIC_code='8299'DB:business_master_new
loadtime:0.49179315567017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton City' limit 1
loadtime:0.49186015129089 / seconds
Query Executed:select id FROM `ma` where city='Charlton City' && SIC_code='8299'DB:business_master_new
loadtime:0.4923779964447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlton Depot' limit 1
loadtime:0.49243307113647 / seconds
Query Executed:select id FROM `ma` where city='Charlton Depot' && SIC_code='8299'DB:business_master_new
loadtime:0.49286508560181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chartley' limit 1
loadtime:0.49291610717773 / seconds
Query Executed:select id FROM `ma` where city='Chartley' && SIC_code='8299'DB:business_master_new
loadtime:0.49342703819275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.49347805976868 / seconds
Query Executed:select id FROM `ma` where city='Chatham' && SIC_code='8299'DB:business_master_new
loadtime:0.49933099746704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelmsford' limit 1
loadtime:0.49940514564514 / seconds
Query Executed:select id FROM `ma` where city='Chelmsford' && SIC_code='8299'DB:business_master_new
loadtime:0.51142621040344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.51149916648865 / seconds
Query Executed:select id FROM `ma` where city='Chelsea' && SIC_code='8299'DB:business_master_new
loadtime:0.52133417129517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Valley' limit 1
loadtime:0.52140998840332 / seconds
Query Executed:select id FROM `ma` where city='Cherry Valley' && SIC_code='8299'DB:business_master_new
loadtime:0.52244210243225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.52249598503113 / seconds
Query Executed:select id FROM `ma` where city='Cheshire' && SIC_code='8299'DB:business_master_new
loadtime:0.52374315261841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.52379608154297 / seconds
Query Executed:select id FROM `ma` where city='Chester' && SIC_code='8299'DB:business_master_new
loadtime:0.52458906173706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.52464199066162 / seconds
Query Executed:select id FROM `ma` where city='Chesterfield' && SIC_code='8299'DB:business_master_new
loadtime:0.52538704872131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chestnut Hill' limit 1
loadtime:0.52545213699341 / seconds
Query Executed:select id FROM `ma` where city='Chestnut Hill' && SIC_code='8299'DB:business_master_new
loadtime:0.53239703178406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chicopee' limit 1
loadtime:0.53246998786926 / seconds
Query Executed:select id FROM `ma` where city='Chicopee' && SIC_code='8299'DB:business_master_new
loadtime:0.54643797874451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chilmark' limit 1
loadtime:0.54651713371277 / seconds
Query Executed:select id FROM `ma` where city='Chilmark' && SIC_code='8299'DB:business_master_new
loadtime:0.54817008972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.54823398590088 / seconds
Query Executed:select id FROM `ma` where city='Clarksburg' && SIC_code='8299'DB:business_master_new
loadtime:0.5486261844635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.54867911338806 / seconds
Query Executed:select id FROM `ma` where city='Clinton' && SIC_code='8299'DB:business_master_new
loadtime:0.55398201942444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cohasset' limit 1
loadtime:0.55405020713806 / seconds
Query Executed:select id FROM `ma` where city='Cohasset' && SIC_code='8299'DB:business_master_new
loadtime:0.55908703804016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colrain' limit 1
loadtime:0.55915403366089 / seconds
Query Executed:select id FROM `ma` where city='Colrain' && SIC_code='8299'DB:business_master_new
loadtime:0.5600380897522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.56010508537292 / seconds
Query Executed:select id FROM `ma` where city='Concord' && SIC_code='8299'DB:business_master_new
loadtime:0.57242703437805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.57250213623047 / seconds
Query Executed:select id FROM `ma` where city='Conway' && SIC_code='8299'DB:business_master_new
loadtime:0.5734601020813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cotuit' limit 1
loadtime:0.57351517677307 / seconds
Query Executed:select id FROM `ma` where city='Cotuit' && SIC_code='8299'DB:business_master_new
loadtime:0.57524609565735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummaquid' limit 1
loadtime:0.57531213760376 / seconds
Query Executed:select id FROM `ma` where city='Cummaquid' && SIC_code='8299'DB:business_master_new
loadtime:0.57581520080566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cummington' limit 1
loadtime:0.57586908340454 / seconds
Query Executed:select id FROM `ma` where city='Cummington' && SIC_code='8299'DB:business_master_new
loadtime:0.57671999931335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuttyhunk' limit 1
loadtime:0.57677221298218 / seconds
Query Executed:select id FROM `ma` where city='Cuttyhunk' && SIC_code='8299'DB:business_master_new
loadtime:0.57720804214478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.57726120948792 / seconds
Query Executed:select id FROM `ma` where city='Dalton' && SIC_code='8299'DB:business_master_new
loadtime:0.58024311065674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danvers' limit 1
loadtime:0.58031010627747 / seconds
Query Executed:select id FROM `ma` where city='Danvers' && SIC_code='8299'DB:business_master_new
loadtime:0.59492897987366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dartmouth' limit 1
loadtime:0.59501004219055 / seconds
Query Executed:select id FROM `ma` where city='Dartmouth' && SIC_code='8299'DB:business_master_new
loadtime:0.59564900398254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.59570407867432 / seconds
Query Executed:select id FROM `ma` where city='Dedham' && SIC_code='8299'DB:business_master_new
loadtime:0.60711717605591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.60720109939575 / seconds
Query Executed:select id FROM `ma` where city='Deerfield' && SIC_code='8299'DB:business_master_new
loadtime:0.6081120967865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.60817813873291 / seconds
Query Executed:select id FROM `ma` where city='Dennis' && SIC_code='8299'DB:business_master_new
loadtime:0.61172008514404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis Port' limit 1
loadtime:0.6117889881134 / seconds
Query Executed:select id FROM `ma` where city='Dennis Port' && SIC_code='8299'DB:business_master_new
loadtime:0.61503314971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devens' limit 1
loadtime:0.6150860786438 / seconds
Query Executed:select id FROM `ma` where city='Devens' && SIC_code='8299'DB:business_master_new
loadtime:0.61613202095032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dighton' limit 1
loadtime:0.61620616912842 / seconds
Query Executed:select id FROM `ma` where city='Dighton' && SIC_code='8299'DB:business_master_new
loadtime:0.61778903007507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.61784315109253 / seconds
Query Executed:select id FROM `ma` where city='Dorchester' && SIC_code='8299'DB:business_master_new
loadtime:0.63515710830688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester Ctr' limit 1
loadtime:0.63524913787842 / seconds
Query Executed:select id FROM `ma` where city='Dorchester Ctr' && SIC_code='8299'DB:business_master_new
loadtime:0.63569307327271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.63575100898743 / seconds
Query Executed:select id FROM `ma` where city='Douglas' && SIC_code='8299'DB:business_master_new
loadtime:0.63910913467407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.63916301727295 / seconds
Query Executed:select id FROM `ma` where city='Dover' && SIC_code='8299'DB:business_master_new
loadtime:0.64205098152161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dracut' limit 1
loadtime:0.64211702346802 / seconds
Query Executed:select id FROM `ma` where city='Dracut' && SIC_code='8299'DB:business_master_new
loadtime:0.65102410316467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drury' limit 1
loadtime:0.65109419822693 / seconds
Query Executed:select id FROM `ma` where city='Drury' && SIC_code='8299'DB:business_master_new
loadtime:0.65153217315674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:0.65158700942993 / seconds
Query Executed:select id FROM `ma` where city='Dudley' && SIC_code='8299'DB:business_master_new
loadtime:0.65536499023438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunstable' limit 1
loadtime:0.65543413162231 / seconds
Query Executed:select id FROM `ma` where city='Dunstable' && SIC_code='8299'DB:business_master_new
loadtime:0.656583070755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duxbury' limit 1
loadtime:0.65663909912109 / seconds
Query Executed:select id FROM `ma` where city='Duxbury' && SIC_code='8299'DB:business_master_new
loadtime:0.66324520111084 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Arlington' limit 1
loadtime:0.6632981300354 / seconds
Query Executed:select id FROM `ma` where city='East Arlington' && SIC_code='8299'DB:business_master_new
loadtime:0.66368913650513 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Boston' limit 1
loadtime:0.663743019104 / seconds
Query Executed:select id FROM `ma` where city='East Boston' && SIC_code='8299'DB:business_master_new
loadtime:0.66474318504333 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bridgewater' limit 1
loadtime:0.66481113433838 / seconds
Query Executed:select id FROM `ma` where city='East Bridgewater' && SIC_code='8299'DB:business_master_new
loadtime:0.66981315612793 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brookfield' limit 1
loadtime:0.66988015174866 / seconds
Query Executed:select id FROM `ma` where city='East Brookfield' && SIC_code='8299'DB:business_master_new
loadtime:0.67106914520264 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Dennis' limit 1
loadtime:0.67113399505615 / seconds
Query Executed:select id FROM `ma` where city='East Dennis' && SIC_code='8299'DB:business_master_new
loadtime:0.67207217216492 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Douglas' limit 1
loadtime:0.67212510108948 / seconds
Query Executed:select id FROM `ma` where city='East Douglas' && SIC_code='8299'DB:business_master_new
loadtime:0.67254400253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Falmouth' limit 1
loadtime:0.67259812355042 / seconds
Query Executed:select id FROM `ma` where city='East Falmouth' && SIC_code='8299'DB:business_master_new
loadtime:0.67966198921204 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Freetown' limit 1
loadtime:0.67971515655518 / seconds
Query Executed:select id FROM `ma` where city='East Freetown' && SIC_code='8299'DB:business_master_new
loadtime:0.68303918838501 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Longmeadow' limit 1
loadtime:0.68309211730957 / seconds
Query Executed:select id FROM `ma` where city='East Longmeadow' && SIC_code='8299'DB:business_master_new
loadtime:0.69117712974548 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Mansfield' limit 1
loadtime:0.69125819206238 / seconds
Query Executed:select id FROM `ma` where city='East Mansfield' && SIC_code='8299'DB:business_master_new
loadtime:0.69165015220642 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orleans' limit 1
loadtime:0.6917040348053 / seconds
Query Executed:select id FROM `ma` where city='East Orleans' && SIC_code='8299'DB:business_master_new
loadtime:0.69256520271301 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Otis' limit 1
loadtime:0.69261717796326 / seconds
Query Executed:select id FROM `ma` where city='East Otis' && SIC_code='8299'DB:business_master_new
loadtime:0.69313216209412 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Princeton' limit 1
loadtime:0.69319105148315 / seconds
Query Executed:select id FROM `ma` where city='East Princeton' && SIC_code='8299'DB:business_master_new
loadtime:0.69357013702393 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Sandwich' limit 1
loadtime:0.69362306594849 / seconds
Query Executed:select id FROM `ma` where city='East Sandwich' && SIC_code='8299'DB:business_master_new
loadtime:0.69662499427795 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Taunton' limit 1
loadtime:0.69667816162109 / seconds
Query Executed:select id FROM `ma` where city='East Taunton' && SIC_code='8299'DB:business_master_new
loadtime:0.69816613197327 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Templeton' limit 1
loadtime:0.69824004173279 / seconds
Query Executed:select id FROM `ma` where city='East Templeton' && SIC_code='8299'DB:business_master_new
loadtime:0.69884610176086 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Walpole' limit 1
loadtime:0.69889998435974 / seconds
Query Executed:select id FROM `ma` where city='East Walpole' && SIC_code='8299'DB:business_master_new
loadtime:0.70063805580139 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Wareham' limit 1
loadtime:0.70070505142212 / seconds
Query Executed:select id FROM `ma` where city='East Wareham' && SIC_code='8299'DB:business_master_new
loadtime:0.70351815223694 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Weymouth' limit 1
loadtime:0.7035870552063 / seconds
Query Executed:select id FROM `ma` where city='East Weymouth' && SIC_code='8299'DB:business_master_new
loadtime:0.70979619026184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastham' limit 1
loadtime:0.70986318588257 / seconds
Query Executed:select id FROM `ma` where city='Eastham' && SIC_code='8299'DB:business_master_new
loadtime:0.71230506896973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easthampton' limit 1
loadtime:0.7123761177063 / seconds
Query Executed:select id FROM `ma` where city='Easthampton' && SIC_code='8299'DB:business_master_new
loadtime:0.71925902366638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.71932911872864 / seconds
Query Executed:select id FROM `ma` where city='Easton' && SIC_code='8299'DB:business_master_new
loadtime:0.71998310089111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgartown' limit 1
loadtime:0.72003698348999 / seconds
Query Executed:select id FROM `ma` where city='Edgartown' && SIC_code='8299'DB:business_master_new
loadtime:0.72628617286682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood' limit 1
loadtime:0.72635507583618 / seconds
Query Executed:select id FROM `ma` where city='Elmwood' && SIC_code='8299'DB:business_master_new
loadtime:0.72676801681519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erving' limit 1
loadtime:0.72681903839111 / seconds
Query Executed:select id FROM `ma` where city='Erving' && SIC_code='8299'DB:business_master_new
loadtime:0.72745609283447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.72750902175903 / seconds
Query Executed:select id FROM `ma` where city='Essex' && SIC_code='8299'DB:business_master_new
loadtime:0.73107814788818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everett' limit 1
loadtime:0.73114705085754 / seconds
Query Executed:select id FROM `ma` where city='Everett' && SIC_code='8299'DB:business_master_new
loadtime:0.74292612075806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhaven' limit 1
loadtime:0.74300098419189 / seconds
Query Executed:select id FROM `ma` where city='Fairhaven' && SIC_code='8299'DB:business_master_new
loadtime:0.74956512451172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fall River' limit 1
loadtime:0.74963307380676 / seconds
Query Executed:select id FROM `ma` where city='Fall River' && SIC_code='8299'DB:business_master_new
loadtime:0.775719165802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falmouth' limit 1
loadtime:0.77580714225769 / seconds
Query Executed:select id FROM `ma` where city='Falmouth' && SIC_code='8299'DB:business_master_new
loadtime:0.7854311466217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayville' limit 1
loadtime:0.78550314903259 / seconds
Query Executed:select id FROM `ma` where city='Fayville' && SIC_code='8299'DB:business_master_new
loadtime:0.7861180305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Feeding Hills' limit 1
loadtime:0.78617119789124 / seconds
Query Executed:select id FROM `ma` where city='Feeding Hills' && SIC_code='8299'DB:business_master_new
loadtime:0.79037308692932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fiskdale' limit 1
loadtime:0.79043817520142 / seconds
Query Executed:select id FROM `ma` where city='Fiskdale' && SIC_code='8299'DB:business_master_new
loadtime:0.79207301139832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitchburg' limit 1
loadtime:0.79214000701904 / seconds
Query Executed:select id FROM `ma` where city='Fitchburg' && SIC_code='8299'DB:business_master_new
loadtime:0.8057861328125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.80585598945618 / seconds
Query Executed:select id FROM `ma` where city='Florence' && SIC_code='8299'DB:business_master_new
loadtime:0.81056118011475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florida' limit 1
loadtime:0.81063413619995 / seconds
Query Executed:select id FROM `ma` where city='Florida' && SIC_code='8299'DB:business_master_new
loadtime:0.81104207038879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forestdale' limit 1
loadtime:0.81109619140625 / seconds
Query Executed:select id FROM `ma` where city='Forestdale' && SIC_code='8299'DB:business_master_new
loadtime:0.81216907501221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxboro' limit 1
loadtime:0.81222915649414 / seconds
Query Executed:select id FROM `ma` where city='Foxboro' && SIC_code='8299'DB:business_master_new
loadtime:0.81996202468872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Framingham' limit 1
loadtime:0.82003211975098 / seconds
Query Executed:select id FROM `ma` where city='Framingham' && SIC_code='8299'DB:business_master_new
loadtime:0.83232021331787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.83242321014404 / seconds
Query Executed:select id FROM `ma` where city='Franklin' && SIC_code='8299'DB:business_master_new
loadtime:0.84344720840454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardner' limit 1
loadtime:0.84352397918701 / seconds
Query Executed:select id FROM `ma` where city='Gardner' && SIC_code='8299'DB:business_master_new
loadtime:0.851243019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gay Head' limit 1
loadtime:0.85131216049194 / seconds
Query Executed:select id FROM `ma` where city='Gay Head' && SIC_code='8299'DB:business_master_new
loadtime:0.85169506072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.85174918174744 / seconds
Query Executed:select id FROM `ma` where city='Georgetown' && SIC_code='8299'DB:business_master_new
loadtime:0.85583400726318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.85588717460632 / seconds
Query Executed:select id FROM `ma` where city='Gilbertville' && SIC_code='8299'DB:business_master_new
loadtime:0.85668206214905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gill' limit 1
loadtime:0.85673499107361 / seconds
Query Executed:select id FROM `ma` where city='Gill' && SIC_code='8299'DB:business_master_new
loadtime:0.85751605033875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.85757112503052 / seconds
Query Executed:select id FROM `ma` where city='Glendale' && SIC_code='8299'DB:business_master_new
loadtime:0.857990026474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:0.85804200172424 / seconds
Query Executed:select id FROM `ma` where city='Gloucester' && SIC_code='8299'DB:business_master_new
loadtime:0.87211418151855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.87219715118408 / seconds
Query Executed:select id FROM `ma` where city='Goshen' && SIC_code='8299'DB:business_master_new
loadtime:0.87280917167664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.87286305427551 / seconds
Query Executed:select id FROM `ma` where city='Grafton' && SIC_code='8299'DB:business_master_new
loadtime:0.87643504142761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.87650418281555 / seconds
Query Executed:select id FROM `ma` where city='Granby' && SIC_code='8299'DB:business_master_new
loadtime:0.87902808189392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.87908220291138 / seconds
Query Executed:select id FROM `ma` where city='Granville' && SIC_code='8299'DB:business_master_new
loadtime:0.88003706932068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Barrington' limit 1
loadtime:0.88008999824524 / seconds
Query Executed:select id FROM `ma` where city='Great Barrington' && SIC_code='8299'DB:business_master_new
loadtime:0.8882040977478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Harbor' limit 1
loadtime:0.88827514648438 / seconds
Query Executed:select id FROM `ma` where city='Green Harbor' && SIC_code='8299'DB:business_master_new
loadtime:0.88879013061523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenbush' limit 1
loadtime:0.88884305953979 / seconds
Query Executed:select id FROM `ma` where city='Greenbush' && SIC_code='8299'DB:business_master_new
loadtime:0.88932800292969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.88938617706299 / seconds
Query Executed:select id FROM `ma` where city='Greenfield' && SIC_code='8299'DB:business_master_new
loadtime:0.89921903610229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.89929509162903 / seconds
Query Executed:select id FROM `ma` where city='Groton' && SIC_code='8299'DB:business_master_new
loadtime:0.90390801429749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveland' limit 1
loadtime:0.90398001670837 / seconds
Query Executed:select id FROM `ma` where city='Groveland' && SIC_code='8299'DB:business_master_new
loadtime:0.90699100494385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadley' limit 1
loadtime:0.9070451259613 / seconds
Query Executed:select id FROM `ma` where city='Hadley' && SIC_code='8299'DB:business_master_new
loadtime:0.91195797920227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:0.91202902793884 / seconds
Query Executed:select id FROM `ma` where city='Halifax' && SIC_code='8299'DB:business_master_new
loadtime:0.91493511199951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.91500115394592 / seconds
Query Executed:select id FROM `ma` where city='Hamilton' && SIC_code='8299'DB:business_master_new
loadtime:0.91564202308655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampden' limit 1
loadtime:0.91569709777832 / seconds
Query Executed:select id FROM `ma` where city='Hampden' && SIC_code='8299'DB:business_master_new
loadtime:0.91873502731323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.91878700256348 / seconds
Query Executed:select id FROM `ma` where city='Hancock' && SIC_code='8299'DB:business_master_new
loadtime:0.91941714286804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.91946911811829 / seconds
Query Executed:select id FROM `ma` where city='Hanover' && SIC_code='8299'DB:business_master_new
loadtime:0.92891311645508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanscom Afb' limit 1
loadtime:0.92898416519165 / seconds
Query Executed:select id FROM `ma` where city='Hanscom Afb' && SIC_code='8299'DB:business_master_new
loadtime:0.92959213256836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanson' limit 1
loadtime:0.92964720726013 / seconds
Query Executed:select id FROM `ma` where city='Hanson' && SIC_code='8299'DB:business_master_new
loadtime:0.93367719650269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:0.93374514579773 / seconds
Query Executed:select id FROM `ma` where city='Hardwick' && SIC_code='8299'DB:business_master_new
loadtime:0.93447613716125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvard' limit 1
loadtime:0.93453121185303 / seconds
Query Executed:select id FROM `ma` where city='Harvard' && SIC_code='8299'DB:business_master_new
loadtime:0.9381320476532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich' limit 1
loadtime:0.93819403648376 / seconds
Query Executed:select id FROM `ma` where city='Harwich' && SIC_code='8299'DB:business_master_new
loadtime:0.94405007362366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwich Port' limit 1
loadtime:0.94411706924438 / seconds
Query Executed:select id FROM `ma` where city='Harwich Port' && SIC_code='8299'DB:business_master_new
loadtime:0.94610714912415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatfield' limit 1
loadtime:0.94616198539734 / seconds
Query Executed:select id FROM `ma` where city='Hatfield' && SIC_code='8299'DB:business_master_new
loadtime:0.94751501083374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hathorne' limit 1
loadtime:0.94758105278015 / seconds
Query Executed:select id FROM `ma` where city='Hathorne' && SIC_code='8299'DB:business_master_new
loadtime:0.94803905487061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.94809198379517 / seconds
Query Executed:select id FROM `ma` where city='Haverhill' && SIC_code='8299'DB:business_master_new
loadtime:0.96614718437195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawley' limit 1
loadtime:0.9662389755249 / seconds
Query Executed:select id FROM `ma` where city='Hawley' && SIC_code='8299'DB:business_master_new
loadtime:0.96665501594543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haydenville' limit 1
loadtime:0.96671104431152 / seconds
Query Executed:select id FROM `ma` where city='Haydenville' && SIC_code='8299'DB:business_master_new
loadtime:0.96770620346069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heath' limit 1
loadtime:0.96775913238525 / seconds
Query Executed:select id FROM `ma` where city='Heath' && SIC_code='8299'DB:business_master_new
loadtime:0.96826601028442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hingham' limit 1
loadtime:0.96831798553467 / seconds
Query Executed:select id FROM `ma` where city='Hingham' && SIC_code='8299'DB:business_master_new
loadtime:0.98040199279785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.98046898841858 / seconds
Query Executed:select id FROM `ma` where city='Hinsdale' && SIC_code='8299'DB:business_master_new
loadtime:0.98158001899719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:0.98163414001465 / seconds
Query Executed:select id FROM `ma` where city='Holbrook' && SIC_code='8299'DB:business_master_new
loadtime:0.98618602752686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.9862539768219 / seconds
Query Executed:select id FROM `ma` where city='Holden' && SIC_code='8299'DB:business_master_new
loadtime:0.99220108985901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:0.99226903915405 / seconds
Query Executed:select id FROM `ma` where city='Holland' && SIC_code='8299'DB:business_master_new
loadtime:0.99303007125854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holliston' limit 1
loadtime:0.99308705329895 / seconds
Query Executed:select id FROM `ma` where city='Holliston' && SIC_code='8299'DB:business_master_new
loadtime:1.0004651546478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holyoke' limit 1
loadtime:1.000538110733 / seconds
Query Executed:select id FROM `ma` where city='Holyoke' && SIC_code='8299'DB:business_master_new
loadtime:1.0155720710754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopedale' limit 1
loadtime:1.015652179718 / seconds
Query Executed:select id FROM `ma` where city='Hopedale' && SIC_code='8299'DB:business_master_new
loadtime:1.0188541412354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:1.0189261436462 / seconds
Query Executed:select id FROM `ma` where city='Hopkinton' && SIC_code='8299'DB:business_master_new
loadtime:1.0249910354614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Housatonic' limit 1
loadtime:1.0250611305237 / seconds
Query Executed:select id FROM `ma` where city='Housatonic' && SIC_code='8299'DB:business_master_new
loadtime:1.0261461734772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbardston' limit 1
loadtime:1.0262091159821 / seconds
Query Executed:select id FROM `ma` where city='Hubbardston' && SIC_code='8299'DB:business_master_new
loadtime:1.0277450084686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:1.0277981758118 / seconds
Query Executed:select id FROM `ma` where city='Hudson' && SIC_code='8299'DB:business_master_new
loadtime:1.0362181663513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:1.0362861156464 / seconds
Query Executed:select id FROM `ma` where city='Hull' && SIC_code='8299'DB:business_master_new
loadtime:1.0406441688538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humarock' limit 1
loadtime:1.0407111644745 / seconds
Query Executed:select id FROM `ma` where city='Humarock' && SIC_code='8299'DB:business_master_new
loadtime:1.0412051677704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:1.0412580966949 / seconds
Query Executed:select id FROM `ma` where city='Huntington' && SIC_code='8299'DB:business_master_new
loadtime:1.0424470901489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis' limit 1
loadtime:1.0425000190735 / seconds
Query Executed:select id FROM `ma` where city='Hyannis' && SIC_code='8299'DB:business_master_new
loadtime:1.0602250099182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyannis Port' limit 1
loadtime:1.0603001117706 / seconds
Query Executed:select id FROM `ma` where city='Hyannis Port' && SIC_code='8299'DB:business_master_new
loadtime:1.0608429908752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:1.0608971118927 / seconds
Query Executed:select id FROM `ma` where city='Hyde Park' && SIC_code='8299'DB:business_master_new
loadtime:1.0685150623322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Orchard' limit 1
loadtime:1.068587064743 / seconds
Query Executed:select id FROM `ma` where city='Indian Orchard' && SIC_code='8299'DB:business_master_new
loadtime:1.072564125061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ipswich' limit 1
loadtime:1.0726311206818 / seconds
Query Executed:select id FROM `ma` where city='Ipswich' && SIC_code='8299'DB:business_master_new
loadtime:1.0797770023346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica Plain' limit 1
loadtime:1.0798470973969 / seconds
Query Executed:select id FROM `ma` where city='Jamaica Plain' && SIC_code='8299'DB:business_master_new
loadtime:1.0908770561218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.0909531116486 / seconds
Query Executed:select id FROM `ma` where city='Jefferson' && SIC_code='8299'DB:business_master_new
loadtime:1.0919671058655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.0920331478119 / seconds
Query Executed:select id FROM `ma` where city='Kingston' && SIC_code='8299'DB:business_master_new
loadtime:1.0991950035095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Pleasant' limit 1
loadtime:1.0992691516876 / seconds
Query Executed:select id FROM `ma` where city='Lake Pleasant' && SIC_code='8299'DB:business_master_new
loadtime:1.0996901988983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:1.0997450351715 / seconds
Query Executed:select id FROM `ma` where city='Lakeville' && SIC_code='8299'DB:business_master_new
loadtime:1.1045401096344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:1.1046080589294 / seconds
Query Executed:select id FROM `ma` where city='Lancaster' && SIC_code='8299'DB:business_master_new
loadtime:1.1076300144196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:1.107684135437 / seconds
Query Executed:select id FROM `ma` where city='Lanesboro' && SIC_code='8299'DB:business_master_new
loadtime:1.1097002029419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.1097531318665 / seconds
Query Executed:select id FROM `ma` where city='Lawrence' && SIC_code='8299'DB:business_master_new
loadtime:1.1285212039948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:1.1286020278931 / seconds
Query Executed:select id FROM `ma` where city='Lee' && SIC_code='8299'DB:business_master_new
loadtime:1.1336140632629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.133682012558 / seconds
Query Executed:select id FROM `ma` where city='Leeds' && SIC_code='8299'DB:business_master_new
loadtime:1.1346020698547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:1.1346662044525 / seconds
Query Executed:select id FROM `ma` where city='Leicester' && SIC_code='8299'DB:business_master_new
loadtime:1.1381511688232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:1.1382281780243 / seconds
Query Executed:select id FROM `ma` where city='Lenox' && SIC_code='8299'DB:business_master_new
loadtime:1.1427640914917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox Dale' limit 1
loadtime:1.1428310871124 / seconds
Query Executed:select id FROM `ma` where city='Lenox Dale' && SIC_code='8299'DB:business_master_new
loadtime:1.1434471607208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leominster' limit 1
loadtime:1.1435010433197 / seconds
Query Executed:select id FROM `ma` where city='Leominster' && SIC_code='8299'DB:business_master_new
loadtime:1.1594240665436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leverett' limit 1
loadtime:1.1595010757446 / seconds
Query Executed:select id FROM `ma` where city='Leverett' && SIC_code='8299'DB:business_master_new
loadtime:1.160462141037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.160530090332 / seconds
Query Executed:select id FROM `ma` where city='Lexington' && SIC_code='8299'DB:business_master_new
loadtime:1.1751530170441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leyden' limit 1
loadtime:1.1752490997314 / seconds
Query Executed:select id FROM `ma` where city='Leyden' && SIC_code='8299'DB:business_master_new
loadtime:1.1756711006165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.1757271289825 / seconds
Query Executed:select id FROM `ma` where city='Lincoln' && SIC_code='8299'DB:business_master_new
loadtime:1.1795830726624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.1796519756317 / seconds
Query Executed:select id FROM `ma` where city='Linwood' && SIC_code='8299'DB:business_master_new
loadtime:1.1803650856018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:1.1804192066193 / seconds
Query Executed:select id FROM `ma` where city='Littleton' && SIC_code='8299'DB:business_master_new
loadtime:1.185967206955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longmeadow' limit 1
loadtime:1.1860370635986 / seconds
Query Executed:select id FROM `ma` where city='Longmeadow' && SIC_code='8299'DB:business_master_new
loadtime:1.1914529800415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:1.1915330886841 / seconds
Query Executed:select id FROM `ma` where city='Lowell' && SIC_code='8299'DB:business_master_new
loadtime:1.2178230285645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.2179110050201 / seconds
Query Executed:select id FROM `ma` where city='Ludlow' && SIC_code='8299'DB:business_master_new
loadtime:1.2253301143646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lunenburg' limit 1
loadtime:1.2254090309143 / seconds
Query Executed:select id FROM `ma` where city='Lunenburg' && SIC_code='8299'DB:business_master_new
loadtime:1.2293140888214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.2293741703033 / seconds
Query Executed:select id FROM `ma` where city='Lynn' && SIC_code='8299'DB:business_master_new
loadtime:1.2492101192474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnfield' limit 1
loadtime:1.2493190765381 / seconds
Query Executed:select id FROM `ma` where city='Lynnfield' && SIC_code='8299'DB:business_master_new
loadtime:1.254506111145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malden' limit 1
loadtime:1.2545740604401 / seconds
Query Executed:select id FROM `ma` where city='Malden' && SIC_code='8299'DB:business_master_new
loadtime:1.2719511985779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchaug' limit 1
loadtime:1.2720341682434 / seconds
Query Executed:select id FROM `ma` where city='Manchaug' && SIC_code='8299'DB:business_master_new
loadtime:1.2726330757141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:1.2726881504059 / seconds
Query Executed:select id FROM `ma` where city='Manchester' && SIC_code='8299'DB:business_master_new
loadtime:1.2754371166229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manomet' limit 1
loadtime:1.275505065918 / seconds
Query Executed:select id FROM `ma` where city='Manomet' && SIC_code='8299'DB:business_master_new
loadtime:1.2764279842377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield' limit 1
loadtime:1.2764821052551 / seconds
Query Executed:select id FROM `ma` where city='Mansfield' && SIC_code='8299'DB:business_master_new
loadtime:1.2886741161346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marblehead' limit 1
loadtime:1.2887511253357 / seconds
Query Executed:select id FROM `ma` where city='Marblehead' && SIC_code='8299'DB:business_master_new
loadtime:1.299252986908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.299329996109 / seconds
Query Executed:select id FROM `ma` where city='Marion' && SIC_code='8299'DB:business_master_new
loadtime:1.3030200004578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:1.3030891418457 / seconds
Query Executed:select id FROM `ma` where city='Marlborough' && SIC_code='8299'DB:business_master_new
loadtime:1.321013212204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield' limit 1
loadtime:1.3210971355438 / seconds
Query Executed:select id FROM `ma` where city='Marshfield' && SIC_code='8299'DB:business_master_new
loadtime:1.3303670883179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshfield Hills' limit 1
loadtime:1.3304409980774 / seconds
Query Executed:select id FROM `ma` where city='Marshfield Hills' && SIC_code='8299'DB:business_master_new
loadtime:1.3309531211853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marstons Mills' limit 1
loadtime:1.3310060501099 / seconds
Query Executed:select id FROM `ma` where city='Marstons Mills' && SIC_code='8299'DB:business_master_new
loadtime:1.3355071544647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mashpee' limit 1
loadtime:1.3355741500854 / seconds
Query Executed:select id FROM `ma` where city='Mashpee' && SIC_code='8299'DB:business_master_new
loadtime:1.3430781364441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapan' limit 1
loadtime:1.3431479930878 / seconds
Query Executed:select id FROM `ma` where city='Mattapan' && SIC_code='8299'DB:business_master_new
loadtime:1.3485860824585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattapoisett' limit 1
loadtime:1.3486561775208 / seconds
Query Executed:select id FROM `ma` where city='Mattapoisett' && SIC_code='8299'DB:business_master_new
loadtime:1.3528361320496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:1.3528900146484 / seconds
Query Executed:select id FROM `ma` where city='Maynard' && SIC_code='8299'DB:business_master_new
loadtime:1.3581130504608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medfield' limit 1
loadtime:1.3581931591034 / seconds
Query Executed:select id FROM `ma` where city='Medfield' && SIC_code='8299'DB:business_master_new
loadtime:1.3638060092926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:1.3638741970062 / seconds
Query Executed:select id FROM `ma` where city='Medford' && SIC_code='8299'DB:business_master_new
loadtime:1.3807551860809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medway' limit 1
loadtime:1.380832195282 / seconds
Query Executed:select id FROM `ma` where city='Medway' && SIC_code='8299'DB:business_master_new
loadtime:1.3862791061401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:1.3863492012024 / seconds
Query Executed:select id FROM `ma` where city='Melrose' && SIC_code='8299'DB:business_master_new
loadtime:1.3951940536499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:1.3952720165253 / seconds
Query Executed:select id FROM `ma` where city='Mendon' && SIC_code='8299'DB:business_master_new
loadtime:1.3989810943604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menemsha' limit 1
loadtime:1.3990371227264 / seconds
Query Executed:select id FROM `ma` where city='Menemsha' && SIC_code='8299'DB:business_master_new
loadtime:1.3994791507721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrimac' limit 1
loadtime:1.3995320796967 / seconds
Query Executed:select id FROM `ma` where city='Merrimac' && SIC_code='8299'DB:business_master_new
loadtime:1.402496099472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Methuen' limit 1
loadtime:1.4025490283966 / seconds
Query Executed:select id FROM `ma` where city='Methuen' && SIC_code='8299'DB:business_master_new
loadtime:1.4159910678864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleboro' limit 1
loadtime:1.4160711765289 / seconds
Query Executed:select id FROM `ma` where city='Middleboro' && SIC_code='8299'DB:business_master_new
loadtime:1.4245870113373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:1.4246580600739 / seconds
Query Executed:select id FROM `ma` where city='Middlefield' && SIC_code='8299'DB:business_master_new
loadtime:1.4251670837402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:1.4252300262451 / seconds
Query Executed:select id FROM `ma` where city='Middleton' && SIC_code='8299'DB:business_master_new
loadtime:1.4303259849548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:1.4304001331329 / seconds
Query Executed:select id FROM `ma` where city='Milford' && SIC_code='8299'DB:business_master_new
loadtime:1.4427800178528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill River' limit 1
loadtime:1.4428532123566 / seconds
Query Executed:select id FROM `ma` where city='Mill River' && SIC_code='8299'DB:business_master_new
loadtime:1.4434700012207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbury' limit 1
loadtime:1.4435250759125 / seconds
Query Executed:select id FROM `ma` where city='Millbury' && SIC_code='8299'DB:business_master_new
loadtime:1.449627161026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Falls' limit 1
loadtime:1.4496810436249 / seconds
Query Executed:select id FROM `ma` where city='Millers Falls' && SIC_code='8299'DB:business_master_new
loadtime:1.4503231048584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millis' limit 1
loadtime:1.4503800868988 / seconds
Query Executed:select id FROM `ma` where city='Millis' && SIC_code='8299'DB:business_master_new
loadtime:1.4547610282898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:1.4548280239105 / seconds
Query Executed:select id FROM `ma` where city='Millville' && SIC_code='8299'DB:business_master_new
loadtime:1.4558072090149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:1.4558720588684 / seconds
Query Executed:select id FROM `ma` where city='Milton' && SIC_code='8299'DB:business_master_new
loadtime:1.4633882045746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton Village' limit 1
loadtime:1.4634580612183 / seconds
Query Executed:select id FROM `ma` where city='Milton Village' && SIC_code='8299'DB:business_master_new
loadtime:1.4638831615448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minot' limit 1
loadtime:1.4639360904694 / seconds
Query Executed:select id FROM `ma` where city='Minot' && SIC_code='8299'DB:business_master_new
loadtime:1.4643311500549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monponsett' limit 1
loadtime:1.4643881320953 / seconds
Query Executed:select id FROM `ma` where city='Monponsett' && SIC_code='8299'DB:business_master_new
loadtime:1.4647660255432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Bridge' limit 1
loadtime:1.4648170471191 / seconds
Query Executed:select id FROM `ma` where city='Monroe Bridge' && SIC_code='8299'DB:business_master_new
loadtime:1.4652371406555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monson' limit 1
loadtime:1.4652900695801 / seconds
Query Executed:select id FROM `ma` where city='Monson' && SIC_code='8299'DB:business_master_new
loadtime:1.4691472053528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:1.4692220687866 / seconds
Query Executed:select id FROM `ma` where city='Montague' && SIC_code='8299'DB:business_master_new
loadtime:1.4704911708832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monterey' limit 1
loadtime:1.4705581665039 / seconds
Query Executed:select id FROM `ma` where city='Monterey' && SIC_code='8299'DB:business_master_new
loadtime:1.4712591171265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.471312046051 / seconds
Query Executed:select id FROM `ma` where city='Montgomery' && SIC_code='8299'DB:business_master_new
loadtime:1.4717350006104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Beach' limit 1
loadtime:1.4717891216278 / seconds
Query Executed:select id FROM `ma` where city='Monument Beach' && SIC_code='8299'DB:business_master_new
loadtime:1.4724760055542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nahant' limit 1
loadtime:1.4725279808044 / seconds
Query Executed:select id FROM `ma` where city='Nahant' && SIC_code='8299'DB:business_master_new
loadtime:1.4847531318665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nantucket' limit 1
loadtime:1.4848201274872 / seconds
Query Executed:select id FROM `ma` where city='Nantucket' && SIC_code='8299'DB:business_master_new
loadtime:1.4964621067047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natick' limit 1
loadtime:1.4965360164642 / seconds
Query Executed:select id FROM `ma` where city='Natick' && SIC_code='8299'DB:business_master_new
loadtime:1.5132601261139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:1.5133450031281 / seconds
Query Executed:select id FROM `ma` where city='Needham' && SIC_code='8299'DB:business_master_new
loadtime:1.5252170562744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham Heights' limit 1
loadtime:1.5252912044525 / seconds
Query Executed:select id FROM `ma` where city='Needham Heights' && SIC_code='8299'DB:business_master_new
loadtime:1.5338931083679 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Ashford' limit 1
loadtime:1.5339691638947 / seconds
Query Executed:select id FROM `ma` where city='New Ashford' && SIC_code='8299'DB:business_master_new
loadtime:1.5343980789185 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bedford' limit 1
loadtime:1.5344541072845 / seconds
Query Executed:select id FROM `ma` where city='New Bedford' && SIC_code='8299'DB:business_master_new
loadtime:1.5461270809174 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Braintree' limit 1
loadtime:1.5462172031403 / seconds
Query Executed:select id FROM `ma` where city='New Braintree' && SIC_code='8299'DB:business_master_new
loadtime:1.5470330715179 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Marlborough' limit 1
loadtime:1.5470881462097 / seconds
Query Executed:select id FROM `ma` where city='New Marlborough' && SIC_code='8299'DB:business_master_new
loadtime:1.5475921630859 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Salem' limit 1
loadtime:1.5476450920105 / seconds
Query Executed:select id FROM `ma` where city='New Salem' && SIC_code='8299'DB:business_master_new
loadtime:1.5483310222626 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Town' limit 1
loadtime:1.5483891963959 / seconds
Query Executed:select id FROM `ma` where city='New Town' && SIC_code='8299'DB:business_master_new
loadtime:1.5488820075989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:1.5489339828491 / seconds
Query Executed:select id FROM `ma` where city='Newbury' && SIC_code='8299'DB:business_master_new
loadtime:1.5518879890442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newburyport' limit 1
loadtime:1.5519580841064 / seconds
Query Executed:select id FROM `ma` where city='Newburyport' && SIC_code='8299'DB:business_master_new
loadtime:1.5648729801178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.5649521350861 / seconds
Query Executed:select id FROM `ma` where city='Newton' && SIC_code='8299'DB:business_master_new
loadtime:1.5758140087128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Center' limit 1
loadtime:1.5758872032166 / seconds
Query Executed:select id FROM `ma` where city='Newton Center' && SIC_code='8299'DB:business_master_new
loadtime:1.5869472026825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Highlands' limit 1
loadtime:1.5870339870453 / seconds
Query Executed:select id FROM `ma` where city='Newton Highlands' && SIC_code='8299'DB:business_master_new
loadtime:1.5918111801147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Falls' limit 1
loadtime:1.5918810367584 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Falls' && SIC_code='8299'DB:business_master_new
loadtime:1.5937061309814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Lower Fls' limit 1
loadtime:1.5937612056732 / seconds
Query Executed:select id FROM `ma` where city='Newton Lower Fls' && SIC_code='8299'DB:business_master_new
loadtime:1.5941522121429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Falls' limit 1
loadtime:1.5942130088806 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Falls' && SIC_code='8299'DB:business_master_new
loadtime:1.5987441539764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Upper Fls' limit 1
loadtime:1.598815202713 / seconds
Query Executed:select id FROM `ma` where city='Newton Upper Fls' && SIC_code='8299'DB:business_master_new
loadtime:1.5992410182953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:1.5992951393127 / seconds
Query Executed:select id FROM `ma` where city='Newtonville' && SIC_code='8299'DB:business_master_new
loadtime:1.6044731140137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nonantum' limit 1
loadtime:1.6045432090759 / seconds
Query Executed:select id FROM `ma` where city='Nonantum' && SIC_code='8299'DB:business_master_new
loadtime:1.6049292087555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:1.6049821376801 / seconds
Query Executed:select id FROM `ma` where city='Norfolk' && SIC_code='8299'DB:business_master_new
loadtime:1.608983039856 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Adams' limit 1
loadtime:1.6090371608734 / seconds
Query Executed:select id FROM `ma` where city='North Adams' && SIC_code='8299'DB:business_master_new
loadtime:1.6159842014313 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Amherst' limit 1
loadtime:1.6160521507263 / seconds
Query Executed:select id FROM `ma` where city='North Amherst' && SIC_code='8299'DB:business_master_new
loadtime:1.6165730953217 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Andover' limit 1
loadtime:1.6166391372681 / seconds
Query Executed:select id FROM `ma` where city='North Andover' && SIC_code='8299'DB:business_master_new
loadtime:1.6282651424408 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Attleboro' limit 1
loadtime:1.6283450126648 / seconds
Query Executed:select id FROM `ma` where city='North Attleboro' && SIC_code='8299'DB:business_master_new
loadtime:1.6379129886627 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Billerica' limit 1
loadtime:1.6379849910736 / seconds
Query Executed:select id FROM `ma` where city='North Billerica' && SIC_code='8299'DB:business_master_new
loadtime:1.6436190605164 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brookfield' limit 1
loadtime:1.6436860561371 / seconds
Query Executed:select id FROM `ma` where city='North Brookfield' && SIC_code='8299'DB:business_master_new
loadtime:1.6465611457825 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cambridge' limit 1
loadtime:1.6466271877289 / seconds
Query Executed:select id FROM `ma` where city='North Cambridge' && SIC_code='8299'DB:business_master_new
loadtime:1.6470119953156 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carver' limit 1
loadtime:1.6470670700073 / seconds
Query Executed:select id FROM `ma` where city='North Carver' && SIC_code='8299'DB:business_master_new
loadtime:1.6475431919098 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chatham' limit 1
loadtime:1.6475961208344 / seconds
Query Executed:select id FROM `ma` where city='North Chatham' && SIC_code='8299'DB:business_master_new
loadtime:1.6484181880951 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Chelmsford' limit 1
loadtime:1.6484711170197 / seconds
Query Executed:select id FROM `ma` where city='North Chelmsford' && SIC_code='8299'DB:business_master_new
loadtime:1.6532051563263 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dartmouth' limit 1
loadtime:1.6532711982727 / seconds
Query Executed:select id FROM `ma` where city='North Dartmouth' && SIC_code='8299'DB:business_master_new
loadtime:1.6619441509247 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Dighton' limit 1
loadtime:1.6620171070099 / seconds
Query Executed:select id FROM `ma` where city='North Dighton' && SIC_code='8299'DB:business_master_new
loadtime:1.6633951663971 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Eastham' limit 1
loadtime:1.6634511947632 / seconds
Query Executed:select id FROM `ma` where city='North Eastham' && SIC_code='8299'DB:business_master_new
loadtime:1.6645760536194 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Easton' limit 1
loadtime:1.6646301746368 / seconds
Query Executed:select id FROM `ma` where city='North Easton' && SIC_code='8299'DB:business_master_new
loadtime:1.6695461273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Egremont' limit 1
loadtime:1.6696000099182 / seconds
Query Executed:select id FROM `ma` where city='North Egremont' && SIC_code='8299'DB:business_master_new
loadtime:1.6700630187988 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Falmouth' limit 1
loadtime:1.6701140403748 / seconds
Query Executed:select id FROM `ma` where city='North Falmouth' && SIC_code='8299'DB:business_master_new
loadtime:1.6731991767883 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grafton' limit 1
loadtime:1.6732661724091 / seconds
Query Executed:select id FROM `ma` where city='North Grafton' && SIC_code='8299'DB:business_master_new
loadtime:1.6769750118256 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hatfield' limit 1
loadtime:1.6770431995392 / seconds
Query Executed:select id FROM `ma` where city='North Hatfield' && SIC_code='8299'DB:business_master_new
loadtime:1.6775109767914 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Marshfield' limit 1
loadtime:1.6775650978088 / seconds
Query Executed:select id FROM `ma` where city='North Marshfield' && SIC_code='8299'DB:business_master_new
loadtime:1.6779990196228 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Oxford' limit 1
loadtime:1.6780500411987 / seconds
Query Executed:select id FROM `ma` where city='North Oxford' && SIC_code='8299'DB:business_master_new
loadtime:1.6792721748352 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Pembroke' limit 1
loadtime:1.6793251037598 / seconds
Query Executed:select id FROM `ma` where city='North Pembroke' && SIC_code='8299'DB:business_master_new
loadtime:1.6797821521759 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Quincy' limit 1
loadtime:1.6798350811005 / seconds
Query Executed:select id FROM `ma` where city='North Quincy' && SIC_code='8299'DB:business_master_new
loadtime:1.680272102356 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Reading' limit 1
loadtime:1.6803240776062 / seconds
Query Executed:select id FROM `ma` where city='North Reading' && SIC_code='8299'DB:business_master_new
loadtime:1.6873421669006 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Scituate' limit 1
loadtime:1.6874151229858 / seconds
Query Executed:select id FROM `ma` where city='North Scituate' && SIC_code='8299'DB:business_master_new
loadtime:1.6878671646118 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Truro' limit 1
loadtime:1.6879210472107 / seconds
Query Executed:select id FROM `ma` where city='North Truro' && SIC_code='8299'DB:business_master_new
loadtime:1.6889951229095 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Uxbridge' limit 1
loadtime:1.6890590190887 / seconds
Query Executed:select id FROM `ma` where city='North Uxbridge' && SIC_code='8299'DB:business_master_new
loadtime:1.6897370815277 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Waltham' limit 1
loadtime:1.6897912025452 / seconds
Query Executed:select id FROM `ma` where city='North Waltham' && SIC_code='8299'DB:business_master_new
loadtime:1.6902070045471 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Weymouth' limit 1
loadtime:1.6902601718903 / seconds
Query Executed:select id FROM `ma` where city='North Weymouth' && SIC_code='8299'DB:business_master_new
loadtime:1.6925120353699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northampton' limit 1
loadtime:1.6925780773163 / seconds
Query Executed:select id FROM `ma` where city='Northampton' && SIC_code='8299'DB:business_master_new
loadtime:1.7064611911774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northborough' limit 1
loadtime:1.7065391540527 / seconds
Query Executed:select id FROM `ma` where city='Northborough' && SIC_code='8299'DB:business_master_new
loadtime:1.7152590751648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northbridge' limit 1
loadtime:1.71533203125 / seconds
Query Executed:select id FROM `ma` where city='Northbridge' && SIC_code='8299'DB:business_master_new
loadtime:1.7181360721588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:1.7182140350342 / seconds
Query Executed:select id FROM `ma` where city='Northfield' && SIC_code='8299'DB:business_master_new
loadtime:1.7196002006531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norton' limit 1
loadtime:1.719654083252 / seconds
Query Executed:select id FROM `ma` where city='Norton' && SIC_code='8299'DB:business_master_new
loadtime:1.7253751754761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwell' limit 1
loadtime:1.7254450321198 / seconds
Query Executed:select id FROM `ma` where city='Norwell' && SIC_code='8299'DB:business_master_new
loadtime:1.7328100204468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:1.7328810691833 / seconds
Query Executed:select id FROM `ma` where city='Norwood' && SIC_code='8299'DB:business_master_new
loadtime:1.7489981651306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutting Lake' limit 1
loadtime:1.7490751743317 / seconds
Query Executed:select id FROM `ma` where city='Nutting Lake' && SIC_code='8299'DB:business_master_new
loadtime:1.7495241165161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Bluffs' limit 1
loadtime:1.7495791912079 / seconds
Query Executed:select id FROM `ma` where city='Oak Bluffs' && SIC_code='8299'DB:business_master_new
loadtime:1.7541491985321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakham' limit 1
loadtime:1.7542111873627 / seconds
Query Executed:select id FROM `ma` where city='Oakham' && SIC_code='8299'DB:business_master_new
loadtime:1.7551560401917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Bluff' limit 1
loadtime:1.7552189826965 / seconds
Query Executed:select id FROM `ma` where city='Ocean Bluff' && SIC_code='8299'DB:business_master_new
loadtime:1.7556312084198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onset' limit 1
loadtime:1.7556841373444 / seconds
Query Executed:select id FROM `ma` where city='Onset' && SIC_code='8299'DB:business_master_new
loadtime:1.756578207016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:1.7566452026367 / seconds
Query Executed:select id FROM `ma` where city='Orange' && SIC_code='8299'DB:business_master_new
loadtime:1.7604901790619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orleans' limit 1
loadtime:1.7605581283569 / seconds
Query Executed:select id FROM `ma` where city='Orleans' && SIC_code='8299'DB:business_master_new
loadtime:1.7683990001678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osterville' limit 1
loadtime:1.7684721946716 / seconds
Query Executed:select id FROM `ma` where city='Osterville' && SIC_code='8299'DB:business_master_new
loadtime:1.773029088974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otis' limit 1
loadtime:1.7730960845947 / seconds
Query Executed:select id FROM `ma` where city='Otis' && SIC_code='8299'DB:business_master_new
loadtime:1.7740571498871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.774111032486 / seconds
Query Executed:select id FROM `ma` where city='Oxford' && SIC_code='8299'DB:business_master_new
loadtime:1.7789351940155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:1.7790031433105 / seconds
Query Executed:select id FROM `ma` where city='Palmer' && SIC_code='8299'DB:business_master_new
loadtime:1.7843949794769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paxton' limit 1
loadtime:1.7844631671906 / seconds
Query Executed:select id FROM `ma` where city='Paxton' && SIC_code='8299'DB:business_master_new
loadtime:1.7860519886017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peabody' limit 1
loadtime:1.7861061096191 / seconds
Query Executed:select id FROM `ma` where city='Peabody' && SIC_code='8299'DB:business_master_new
loadtime:1.8044700622559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.8045461177826 / seconds
Query Executed:select id FROM `ma` where city='Pelham' && SIC_code='8299'DB:business_master_new
loadtime:1.8049840927124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:1.805037021637 / seconds
Query Executed:select id FROM `ma` where city='Pembroke' && SIC_code='8299'DB:business_master_new
loadtime:1.8127951622009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepperell' limit 1
loadtime:1.8128662109375 / seconds
Query Executed:select id FROM `ma` where city='Pepperell' && SIC_code='8299'DB:business_master_new
loadtime:1.8177411556244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:1.8178071975708 / seconds
Query Executed:select id FROM `ma` where city='Peru' && SIC_code='8299'DB:business_master_new
loadtime:1.8182621002197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petersham' limit 1
loadtime:1.8183150291443 / seconds
Query Executed:select id FROM `ma` where city='Petersham' && SIC_code='8299'DB:business_master_new
loadtime:1.8193070888519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipston' limit 1
loadtime:1.8193771839142 / seconds
Query Executed:select id FROM `ma` where city='Phillipston' && SIC_code='8299'DB:business_master_new
loadtime:1.8198220729828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:1.819874048233 / seconds
Query Executed:select id FROM `ma` where city='Pinehurst' && SIC_code='8299'DB:business_master_new
loadtime:1.8203001022339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsfield' limit 1
loadtime:1.8203551769257 / seconds
Query Executed:select id FROM `ma` where city='Pittsfield' && SIC_code='8299'DB:business_master_new
loadtime:1.8390669822693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:1.839143037796 / seconds
Query Executed:select id FROM `ma` where city='Plainfield' && SIC_code='8299'DB:business_master_new
loadtime:1.8397750854492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:1.8398292064667 / seconds
Query Executed:select id FROM `ma` where city='Plainville' && SIC_code='8299'DB:business_master_new
loadtime:1.8442599773407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:1.8443131446838 / seconds
Query Executed:select id FROM `ma` where city='Plymouth' && SIC_code='8299'DB:business_master_new
loadtime:1.8652431964874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plympton' limit 1
loadtime:1.8653349876404 / seconds
Query Executed:select id FROM `ma` where city='Plympton' && SIC_code='8299'DB:business_master_new
loadtime:1.8669521808624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocasset' limit 1
loadtime:1.8670210838318 / seconds
Query Executed:select id FROM `ma` where city='Pocasset' && SIC_code='8299'DB:business_master_new
loadtime:1.8700351715088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prides Crossing' limit 1
loadtime:1.8700911998749 / seconds
Query Executed:select id FROM `ma` where city='Prides Crossing' && SIC_code='8299'DB:business_master_new
loadtime:1.8705589771271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.8706130981445 / seconds
Query Executed:select id FROM `ma` where city='Princeton' && SIC_code='8299'DB:business_master_new
loadtime:1.8722290992737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provincetown' limit 1
loadtime:1.8722951412201 / seconds
Query Executed:select id FROM `ma` where city='Provincetown' && SIC_code='8299'DB:business_master_new
loadtime:1.8804800510406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quincy' limit 1
loadtime:1.8805491924286 / seconds
Query Executed:select id FROM `ma` where city='Quincy' && SIC_code='8299'DB:business_master_new
loadtime:1.9087760448456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.9088680744171 / seconds
Query Executed:select id FROM `ma` where city='Randolph' && SIC_code='8299'DB:business_master_new
loadtime:1.9180071353912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham' limit 1
loadtime:1.9180800914764 / seconds
Query Executed:select id FROM `ma` where city='Raynham' && SIC_code='8299'DB:business_master_new
loadtime:1.9247550964355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raynham Center' limit 1
loadtime:1.9248251914978 / seconds
Query Executed:select id FROM `ma` where city='Raynham Center' && SIC_code='8299'DB:business_master_new
loadtime:1.9253361225128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reading' limit 1
loadtime:1.9253962039948 / seconds
Query Executed:select id FROM `ma` where city='Reading' && SIC_code='8299'DB:business_master_new
loadtime:1.9340109825134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readville' limit 1
loadtime:1.9340810775757 / seconds
Query Executed:select id FROM `ma` where city='Readville' && SIC_code='8299'DB:business_master_new
loadtime:1.9346301555634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehoboth' limit 1
loadtime:1.9346849918365 / seconds
Query Executed:select id FROM `ma` where city='Rehoboth' && SIC_code='8299'DB:business_master_new
loadtime:1.9395670890808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Revere' limit 1
loadtime:1.9396350383759 / seconds
Query Executed:select id FROM `ma` where city='Revere' && SIC_code='8299'DB:business_master_new
loadtime:1.9515421390533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:1.9516110420227 / seconds
Query Executed:select id FROM `ma` where city='Richmond' && SIC_code='8299'DB:business_master_new
loadtime:1.95259308815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochdale' limit 1
loadtime:1.9526472091675 / seconds
Query Executed:select id FROM `ma` where city='Rochdale' && SIC_code='8299'DB:business_master_new
loadtime:1.9536311626434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:1.9536991119385 / seconds
Query Executed:select id FROM `ma` where city='Rochester' && SIC_code='8299'DB:business_master_new
loadtime:1.9554851055145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockland' limit 1
loadtime:1.9555511474609 / seconds
Query Executed:select id FROM `ma` where city='Rockland' && SIC_code='8299'DB:business_master_new
loadtime:1.9630000591278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockport' limit 1
loadtime:1.9630680084229 / seconds
Query Executed:select id FROM `ma` where city='Rockport' && SIC_code='8299'DB:business_master_new
loadtime:1.9681880474091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roslindale' limit 1
loadtime:1.9682581424713 / seconds
Query Executed:select id FROM `ma` where city='Roslindale' && SIC_code='8299'DB:business_master_new
loadtime:1.9760110378265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowe' limit 1
loadtime:1.9760880470276 / seconds
Query Executed:select id FROM `ma` where city='Rowe' && SIC_code='8299'DB:business_master_new
loadtime:1.9766821861267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:1.9767370223999 / seconds
Query Executed:select id FROM `ma` where city='Rowley' && SIC_code='8299'DB:business_master_new
loadtime:1.9809951782227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:1.9810621738434 / seconds
Query Executed:select id FROM `ma` where city='Roxbury' && SIC_code='8299'DB:business_master_new
loadtime:1.9891769886017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury Crossing' limit 1
loadtime:1.9892520904541 / seconds
Query Executed:select id FROM `ma` where city='Roxbury Crossing' && SIC_code='8299'DB:business_master_new
loadtime:1.9918820858002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royalston' limit 1
loadtime:1.9919509887695 / seconds
Query Executed:select id FROM `ma` where city='Royalston' && SIC_code='8299'DB:business_master_new
loadtime:1.9926760196686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:1.9927411079407 / seconds
Query Executed:select id FROM `ma` where city='Russell' && SIC_code='8299'DB:business_master_new
loadtime:1.9935131072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:1.9935781955719 / seconds
Query Executed:select id FROM `ma` where city='Rutland' && SIC_code='8299'DB:business_master_new
loadtime:1.9957840442657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore' limit 1
loadtime:1.9958381652832 / seconds
Query Executed:select id FROM `ma` where city='Sagamore' && SIC_code='8299'DB:business_master_new
loadtime:1.9969251155853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sagamore Beach' limit 1
loadtime:1.9969780445099 / seconds
Query Executed:select id FROM `ma` where city='Sagamore Beach' && SIC_code='8299'DB:business_master_new
loadtime:1.9986281394958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.9986951351166 / seconds
Query Executed:select id FROM `ma` where city='Salem' && SIC_code='8299'DB:business_master_new
loadtime:2.0154821872711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:2.0155611038208 / seconds
Query Executed:select id FROM `ma` where city='Salisbury' && SIC_code='8299'DB:business_master_new
loadtime:2.0214359760284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury Beach' limit 1
loadtime:2.0215091705322 / seconds
Query Executed:select id FROM `ma` where city='Salisbury Beach' && SIC_code='8299'DB:business_master_new
loadtime:2.0219280719757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandisfield' limit 1
loadtime:2.021980047226 / seconds
Query Executed:select id FROM `ma` where city='Sandisfield' && SIC_code='8299'DB:business_master_new
loadtime:2.0227251052856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandwich' limit 1
loadtime:2.0227780342102 / seconds
Query Executed:select id FROM `ma` where city='Sandwich' && SIC_code='8299'DB:business_master_new
loadtime:2.0299751758575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saugus' limit 1
loadtime:2.0300440788269 / seconds
Query Executed:select id FROM `ma` where city='Saugus' && SIC_code='8299'DB:business_master_new
loadtime:2.0404200553894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savoy' limit 1
loadtime:2.0404901504517 / seconds
Query Executed:select id FROM `ma` where city='Savoy' && SIC_code='8299'DB:business_master_new
loadtime:2.0410380363464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scituate' limit 1
loadtime:2.0410912036896 / seconds
Query Executed:select id FROM `ma` where city='Scituate' && SIC_code='8299'DB:business_master_new
loadtime:2.0533401966095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seekonk' limit 1
loadtime:2.053414106369 / seconds
Query Executed:select id FROM `ma` where city='Seekonk' && SIC_code='8299'DB:business_master_new
loadtime:2.0605850219727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.0606541633606 / seconds
Query Executed:select id FROM `ma` where city='Sharon' && SIC_code='8299'DB:business_master_new
loadtime:2.0667560100555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:2.0668261051178 / seconds
Query Executed:select id FROM `ma` where city='Sheffield' && SIC_code='8299'DB:business_master_new
loadtime:2.0692269802094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelburne Falls' limit 1
loadtime:2.0692820549011 / seconds
Query Executed:select id FROM `ma` where city='Shelburne Falls' && SIC_code='8299'DB:business_master_new
loadtime:2.0725321769714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldonville' limit 1
loadtime:2.072585105896 / seconds
Query Executed:select id FROM `ma` where city='Sheldonville' && SIC_code='8299'DB:business_master_new
loadtime:2.073028087616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherborn' limit 1
loadtime:2.0730791091919 / seconds
Query Executed:select id FROM `ma` where city='Sherborn' && SIC_code='8299'DB:business_master_new
loadtime:2.0759210586548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley' limit 1
loadtime:2.0759739875793 / seconds
Query Executed:select id FROM `ma` where city='Shirley' && SIC_code='8299'DB:business_master_new
loadtime:2.0788941383362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:2.0789611339569 / seconds
Query Executed:select id FROM `ma` where city='Shrewsbury' && SIC_code='8299'DB:business_master_new
loadtime:2.0923500061035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shutesbury' limit 1
loadtime:2.0924251079559 / seconds
Query Executed:select id FROM `ma` where city='Shutesbury' && SIC_code='8299'DB:business_master_new
loadtime:2.0931451320648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siasconset' limit 1
loadtime:2.0932199954987 / seconds
Query Executed:select id FROM `ma` where city='Siasconset' && SIC_code='8299'DB:business_master_new
loadtime:2.0938620567322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Beach' limit 1
loadtime:2.0939149856567 / seconds
Query Executed:select id FROM `ma` where city='Silver Beach' && SIC_code='8299'DB:business_master_new
loadtime:2.0943031311035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:2.0943610668182 / seconds
Query Executed:select id FROM `ma` where city='Somerset' && SIC_code='8299'DB:business_master_new
loadtime:2.1000361442566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:2.100105047226 / seconds
Query Executed:select id FROM `ma` where city='Somerville' && SIC_code='8299'DB:business_master_new
loadtime:2.1206891536713 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Barre' limit 1
loadtime:2.120786190033 / seconds
Query Executed:select id FROM `ma` where city='South Barre' && SIC_code='8299'DB:business_master_new
loadtime:2.121383190155 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Boston' limit 1
loadtime:2.1214389801025 / seconds
Query Executed:select id FROM `ma` where city='South Boston' && SIC_code='8299'DB:business_master_new
loadtime:2.122120141983 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Carver' limit 1
loadtime:2.122171163559 / seconds
Query Executed:select id FROM `ma` where city='South Carver' && SIC_code='8299'DB:business_master_new
loadtime:2.1227540969849 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chatham' limit 1
loadtime:2.1228070259094 / seconds
Query Executed:select id FROM `ma` where city='South Chatham' && SIC_code='8299'DB:business_master_new
loadtime:2.12388920784 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Chelmsford' limit 1
loadtime:2.1239411830902 / seconds
Query Executed:select id FROM `ma` where city='South Chelmsford' && SIC_code='8299'DB:business_master_new
loadtime:2.1243321895599 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dartmouth' limit 1
loadtime:2.1243901252747 / seconds
Query Executed:select id FROM `ma` where city='South Dartmouth' && SIC_code='8299'DB:business_master_new
loadtime:2.1288440227509 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Deerfield' limit 1
loadtime:2.1288959980011 / seconds
Query Executed:select id FROM `ma` where city='South Deerfield' && SIC_code='8299'DB:business_master_new
loadtime:2.131628036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:2.1316812038422 / seconds
Query Executed:select id FROM `ma` where city='South Dennis' && SIC_code='8299'DB:business_master_new
loadtime:2.1362550258636 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Easton' limit 1
loadtime:2.1363210678101 / seconds
Query Executed:select id FROM `ma` where city='South Easton' && SIC_code='8299'DB:business_master_new
loadtime:2.14275598526 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Egremont' limit 1
loadtime:2.1428251266479 / seconds
Query Executed:select id FROM `ma` where city='South Egremont' && SIC_code='8299'DB:business_master_new
loadtime:2.1436359882355 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Grafton' limit 1
loadtime:2.1436910629272 / seconds
Query Executed:select id FROM `ma` where city='South Grafton' && SIC_code='8299'DB:business_master_new
loadtime:2.1448640823364 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hadley' limit 1
loadtime:2.144917011261 / seconds
Query Executed:select id FROM `ma` where city='South Hadley' && SIC_code='8299'DB:business_master_new
loadtime:2.1503601074219 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hamilton' limit 1
loadtime:2.1504302024841 / seconds
Query Executed:select id FROM `ma` where city='South Hamilton' && SIC_code='8299'DB:business_master_new
loadtime:2.1530950069427 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Harwich' limit 1
loadtime:2.153165102005 / seconds
Query Executed:select id FROM `ma` where city='South Harwich' && SIC_code='8299'DB:business_master_new
loadtime:2.1537170410156 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lancaster' limit 1
loadtime:2.1537711620331 / seconds
Query Executed:select id FROM `ma` where city='South Lancaster' && SIC_code='8299'DB:business_master_new
loadtime:2.1544251441956 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lee' limit 1
loadtime:2.154491186142 / seconds
Query Executed:select id FROM `ma` where city='South Lee' && SIC_code='8299'DB:business_master_new
loadtime:2.1550130844116 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orleans' limit 1
loadtime:2.1550650596619 / seconds
Query Executed:select id FROM `ma` where city='South Orleans' && SIC_code='8299'DB:business_master_new
loadtime:2.1557002067566 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Walpole' limit 1
loadtime:2.1557531356812 / seconds
Query Executed:select id FROM `ma` where city='South Walpole' && SIC_code='8299'DB:business_master_new
loadtime:2.1563131809235 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Wellfleet' limit 1
loadtime:2.1563711166382 / seconds
Query Executed:select id FROM `ma` where city='South Wellfleet' && SIC_code='8299'DB:business_master_new
loadtime:2.1570861339569 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Weymouth' limit 1
loadtime:2.1571371555328 / seconds
Query Executed:select id FROM `ma` where city='South Weymouth' && SIC_code='8299'DB:business_master_new
loadtime:2.1633961200714 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Yarmouth' limit 1
loadtime:2.1634640693665 / seconds
Query Executed:select id FROM `ma` where city='South Yarmouth' && SIC_code='8299'DB:business_master_new
loadtime:2.1699562072754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:2.1700241565704 / seconds
Query Executed:select id FROM `ma` where city='Southampton' && SIC_code='8299'DB:business_master_new
loadtime:2.1728641986847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southborough' limit 1
loadtime:2.1729180812836 / seconds
Query Executed:select id FROM `ma` where city='Southborough' && SIC_code='8299'DB:business_master_new
loadtime:2.1784670352936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbridge' limit 1
loadtime:2.17853307724 / seconds
Query Executed:select id FROM `ma` where city='Southbridge' && SIC_code='8299'DB:business_master_new
loadtime:2.1849031448364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southfield' limit 1
loadtime:2.1849720478058 / seconds
Query Executed:select id FROM `ma` where city='Southfield' && SIC_code='8299'DB:business_master_new
loadtime:2.1855840682983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southwick' limit 1
loadtime:2.1856381893158 / seconds
Query Executed:select id FROM `ma` where city='Southwick' && SIC_code='8299'DB:business_master_new
loadtime:2.1910212039948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:2.1910769939423 / seconds
Query Executed:select id FROM `ma` where city='Spencer' && SIC_code='8299'DB:business_master_new
loadtime:2.1978001594543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:2.1978530883789 / seconds
Query Executed:select id FROM `ma` where city='Springfield' && SIC_code='8299'DB:business_master_new
loadtime:2.2100811004639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:2.2101681232452 / seconds
Query Executed:select id FROM `ma` where city='Sterling' && SIC_code='8299'DB:business_master_new
loadtime:2.214380979538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Still River' limit 1
loadtime:2.2144501209259 / seconds
Query Executed:select id FROM `ma` where city='Still River' && SIC_code='8299'DB:business_master_new
loadtime:2.214958190918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockbridge' limit 1
loadtime:2.2150111198425 / seconds
Query Executed:select id FROM `ma` where city='Stockbridge' && SIC_code='8299'DB:business_master_new
loadtime:2.2167510986328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneham' limit 1
loadtime:2.2168171405792 / seconds
Query Executed:select id FROM `ma` where city='Stoneham' && SIC_code='8299'DB:business_master_new
loadtime:2.2261610031128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoughton' limit 1
loadtime:2.2262401580811 / seconds
Query Executed:select id FROM `ma` where city='Stoughton' && SIC_code='8299'DB:business_master_new
loadtime:2.2387001514435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stow' limit 1
loadtime:2.238774061203 / seconds
Query Executed:select id FROM `ma` where city='Stow' && SIC_code='8299'DB:business_master_new
loadtime:2.2429740428925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturbridge' limit 1
loadtime:2.2430410385132 / seconds
Query Executed:select id FROM `ma` where city='Sturbridge' && SIC_code='8299'DB:business_master_new
loadtime:2.2475640773773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sudbury' limit 1
loadtime:2.2476341724396 / seconds
Query Executed:select id FROM `ma` where city='Sudbury' && SIC_code='8299'DB:business_master_new
loadtime:2.2560510635376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunderland' limit 1
loadtime:2.2561311721802 / seconds
Query Executed:select id FROM `ma` where city='Sunderland' && SIC_code='8299'DB:business_master_new
loadtime:2.2575790882111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutton' limit 1
loadtime:2.2576479911804 / seconds
Query Executed:select id FROM `ma` where city='Sutton' && SIC_code='8299'DB:business_master_new
loadtime:2.2618579864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swampscott' limit 1
loadtime:2.2619261741638 / seconds
Query Executed:select id FROM `ma` where city='Swampscott' && SIC_code='8299'DB:business_master_new
loadtime:2.267685174942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansea' limit 1
loadtime:2.2677550315857 / seconds
Query Executed:select id FROM `ma` where city='Swansea' && SIC_code='8299'DB:business_master_new
loadtime:2.274316072464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taunton' limit 1
loadtime:2.2743899822235 / seconds
Query Executed:select id FROM `ma` where city='Taunton' && SIC_code='8299'DB:business_master_new
loadtime:2.2891280651093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaticket' limit 1
loadtime:2.2892141342163 / seconds
Query Executed:select id FROM `ma` where city='Teaticket' && SIC_code='8299'DB:business_master_new
loadtime:2.2896270751953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:2.2896831035614 / seconds
Query Executed:select id FROM `ma` where city='Templeton' && SIC_code='8299'DB:business_master_new
loadtime:2.2912030220032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tewksbury' limit 1
loadtime:2.2912681102753 / seconds
Query Executed:select id FROM `ma` where city='Tewksbury' && SIC_code='8299'DB:business_master_new
loadtime:2.3017511367798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorndike' limit 1
loadtime:2.3018250465393 / seconds
Query Executed:select id FROM `ma` where city='Thorndike' && SIC_code='8299'DB:business_master_new
loadtime:2.3024439811707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Rivers' limit 1
loadtime:2.3024990558624 / seconds
Query Executed:select id FROM `ma` where city='Three Rivers' && SIC_code='8299'DB:business_master_new
loadtime:2.3036592006683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:2.3037121295929 / seconds
Query Executed:select id FROM `ma` where city='Tolland' && SIC_code='8299'DB:business_master_new
loadtime:2.3040881156921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsfield' limit 1
loadtime:2.3041391372681 / seconds
Query Executed:select id FROM `ma` where city='Topsfield' && SIC_code='8299'DB:business_master_new
loadtime:2.3087620735168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsend' limit 1
loadtime:2.3088281154633 / seconds
Query Executed:select id FROM `ma` where city='Townsend' && SIC_code='8299'DB:business_master_new
loadtime:2.3113431930542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:2.3114151954651 / seconds
Query Executed:select id FROM `ma` where city='Truro' && SIC_code='8299'DB:business_master_new
loadtime:2.3127071857452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turners Falls' limit 1
loadtime:2.3127720355988 / seconds
Query Executed:select id FROM `ma` where city='Turners Falls' && SIC_code='8299'DB:business_master_new
loadtime:2.3158161640167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyngsboro' limit 1
loadtime:2.3158700466156 / seconds
Query Executed:select id FROM `ma` where city='Tyngsboro' && SIC_code='8299'DB:business_master_new
loadtime:2.3215761184692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyringham' limit 1
loadtime:2.3216440677643 / seconds
Query Executed:select id FROM `ma` where city='Tyringham' && SIC_code='8299'DB:business_master_new
loadtime:2.322151184082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:2.3222119808197 / seconds
Query Executed:select id FROM `ma` where city='Upton' && SIC_code='8299'DB:business_master_new
loadtime:2.3257071971893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uxbridge' limit 1
loadtime:2.3257730007172 / seconds
Query Executed:select id FROM `ma` where city='Uxbridge' && SIC_code='8299'DB:business_master_new
loadtime:2.3316760063171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Village Of Nagog Woods' limit 1
loadtime:2.3317461013794 / seconds
Query Executed:select id FROM `ma` where city='Village Of Nagog Woods' && SIC_code='8299'DB:business_master_new
loadtime:2.3321690559387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineyard Haven' limit 1
loadtime:2.3322310447693 / seconds
Query Executed:select id FROM `ma` where city='Vineyard Haven' && SIC_code='8299'DB:business_master_new
loadtime:2.3400800228119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vlg Of Nagog Wds' limit 1
loadtime:2.3401460647583 / seconds
Query Executed:select id FROM `ma` where city='Vlg Of Nagog Wds' && SIC_code='8299'DB:business_master_new
loadtime:2.3405621051788 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Chesterfield' limit 1
loadtime:2.3406150341034 / seconds
Query Executed:select id FROM `ma` where city='W Chesterfield' && SIC_code='8299'DB:business_master_new
loadtime:2.3410270214081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waban' limit 1
loadtime:2.3410789966583 / seconds
Query Executed:select id FROM `ma` where city='Waban' && SIC_code='8299'DB:business_master_new
loadtime:2.3431580066681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wakefield' limit 1
loadtime:2.3432400226593 / seconds
Query Executed:select id FROM `ma` where city='Wakefield' && SIC_code='8299'DB:business_master_new
loadtime:2.3559830188751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:2.3560609817505 / seconds
Query Executed:select id FROM `ma` where city='Wales' && SIC_code='8299'DB:business_master_new
loadtime:2.3569610118866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walpole' limit 1
loadtime:2.3570191860199 / seconds
Query Executed:select id FROM `ma` where city='Walpole' && SIC_code='8299'DB:business_master_new
loadtime:2.3660650253296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waltham' limit 1
loadtime:2.3661332130432 / seconds
Query Executed:select id FROM `ma` where city='Waltham' && SIC_code='8299'DB:business_master_new
loadtime:2.3784220218658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waquoit' limit 1
loadtime:2.378525018692 / seconds
Query Executed:select id FROM `ma` where city='Waquoit' && SIC_code='8299'DB:business_master_new
loadtime:2.3789691925049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward Hill' limit 1
loadtime:2.3790249824524 / seconds
Query Executed:select id FROM `ma` where city='Ward Hill' && SIC_code='8299'DB:business_master_new
loadtime:2.3794510364532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ware' limit 1
loadtime:2.3795030117035 / seconds
Query Executed:select id FROM `ma` where city='Ware' && SIC_code='8299'DB:business_master_new
loadtime:2.3838531970978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wareham' limit 1
loadtime:2.3839211463928 / seconds
Query Executed:select id FROM `ma` where city='Wareham' && SIC_code='8299'DB:business_master_new
loadtime:2.3905680179596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:2.3906381130219 / seconds
Query Executed:select id FROM `ma` where city='Warren' && SIC_code='8299'DB:business_master_new
loadtime:2.3919022083282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warwick' limit 1
loadtime:2.3919560909271 / seconds
Query Executed:select id FROM `ma` where city='Warwick' && SIC_code='8299'DB:business_master_new
loadtime:2.3925490379333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.3926031589508 / seconds
Query Executed:select id FROM `ma` where city='Washington' && SIC_code='8299'DB:business_master_new
loadtime:2.3930170536041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:2.3930811882019 / seconds
Query Executed:select id FROM `ma` where city='Watertown' && SIC_code='8299'DB:business_master_new
loadtime:2.4068591594696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverley' limit 1
loadtime:2.406937122345 / seconds
Query Executed:select id FROM `ma` where city='Waverley' && SIC_code='8299'DB:business_master_new
loadtime:2.4074070453644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:2.4074749946594 / seconds
Query Executed:select id FROM `ma` where city='Wayland' && SIC_code='8299'DB:business_master_new
loadtime:2.4134850502014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:2.4135551452637 / seconds
Query Executed:select id FROM `ma` where city='Webster' && SIC_code='8299'DB:business_master_new
loadtime:2.4204161167145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley' limit 1
loadtime:2.4204881191254 / seconds
Query Executed:select id FROM `ma` where city='Wellesley' && SIC_code='8299'DB:business_master_new
loadtime:2.4284961223602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellesley Hills' limit 1
loadtime:2.4285709857941 / seconds
Query Executed:select id FROM `ma` where city='Wellesley Hills' && SIC_code='8299'DB:business_master_new
loadtime:2.4393990039825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellfleet' limit 1
loadtime:2.4394781589508 / seconds
Query Executed:select id FROM `ma` where city='Wellfleet' && SIC_code='8299'DB:business_master_new
loadtime:2.4431960582733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:2.4432651996613 / seconds
Query Executed:select id FROM `ma` where city='Wendell' && SIC_code='8299'DB:business_master_new
loadtime:2.4439680576324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell Depot' limit 1
loadtime:2.4440221786499 / seconds
Query Executed:select id FROM `ma` where city='Wendell Depot' && SIC_code='8299'DB:business_master_new
loadtime:2.44447016716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenham' limit 1
loadtime:2.4445221424103 / seconds
Query Executed:select id FROM `ma` where city='Wenham' && SIC_code='8299'DB:business_master_new
loadtime:2.446081161499 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Barnstable' limit 1
loadtime:2.4461340904236 / seconds
Query Executed:select id FROM `ma` where city='West Barnstable' && SIC_code='8299'DB:business_master_new
loadtime:2.4492030143738 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boxford' limit 1
loadtime:2.4492700099945 / seconds
Query Executed:select id FROM `ma` where city='West Boxford' && SIC_code='8299'DB:business_master_new
loadtime:2.4497489929199 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Boylston' limit 1
loadtime:2.4498040676117 / seconds
Query Executed:select id FROM `ma` where city='West Boylston' && SIC_code='8299'DB:business_master_new
loadtime:2.4549360275269 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bridgewater' limit 1
loadtime:2.4550039768219 / seconds
Query Executed:select id FROM `ma` where city='West Bridgewater' && SIC_code='8299'DB:business_master_new
loadtime:2.4604589939117 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Brookfield' limit 1
loadtime:2.4605271816254 / seconds
Query Executed:select id FROM `ma` where city='West Brookfield' && SIC_code='8299'DB:business_master_new
loadtime:2.4623010158539 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chatham' limit 1
loadtime:2.4623591899872 / seconds
Query Executed:select id FROM `ma` where city='West Chatham' && SIC_code='8299'DB:business_master_new
loadtime:2.4630951881409 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chesterfield' limit 1
loadtime:2.4631471633911 / seconds
Query Executed:select id FROM `ma` where city='West Chesterfield' && SIC_code='8299'DB:business_master_new
loadtime:2.4635860919952 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chop' limit 1
loadtime:2.4636380672455 / seconds
Query Executed:select id FROM `ma` where city='West Chop' && SIC_code='8299'DB:business_master_new
loadtime:2.4640331268311 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Dennis' limit 1
loadtime:2.4640831947327 / seconds
Query Executed:select id FROM `ma` where city='West Dennis' && SIC_code='8299'DB:business_master_new
loadtime:2.4657549858093 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Falmouth' limit 1
loadtime:2.4658081531525 / seconds
Query Executed:select id FROM `ma` where city='West Falmouth' && SIC_code='8299'DB:business_master_new
loadtime:2.4666681289673 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Groton' limit 1
loadtime:2.4667210578918 / seconds
Query Executed:select id FROM `ma` where city='West Groton' && SIC_code='8299'DB:business_master_new
loadtime:2.4672720432281 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Harwich' limit 1
loadtime:2.4673261642456 / seconds
Query Executed:select id FROM `ma` where city='West Harwich' && SIC_code='8299'DB:business_master_new
loadtime:2.4686241149902 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hatfield' limit 1
loadtime:2.4686770439148 / seconds
Query Executed:select id FROM `ma` where city='West Hatfield' && SIC_code='8299'DB:business_master_new
loadtime:2.4695460796356 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hyannisport' limit 1
loadtime:2.4695990085602 / seconds
Query Executed:select id FROM `ma` where city='West Hyannisport' && SIC_code='8299'DB:business_master_new
loadtime:2.4700701236725 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Medford' limit 1
loadtime:2.4701211452484 / seconds
Query Executed:select id FROM `ma` where city='West Medford' && SIC_code='8299'DB:business_master_new
loadtime:2.4705522060394 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Millbury' limit 1
loadtime:2.4706041812897 / seconds
Query Executed:select id FROM `ma` where city='West Millbury' && SIC_code='8299'DB:business_master_new
loadtime:2.4709861278534 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newbury' limit 1
loadtime:2.471036195755 / seconds
Query Executed:select id FROM `ma` where city='West Newbury' && SIC_code='8299'DB:business_master_new
loadtime:2.4736700057983 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Newton' limit 1
loadtime:2.4737219810486 / seconds
Query Executed:select id FROM `ma` where city='West Newton' && SIC_code='8299'DB:business_master_new
loadtime:2.4787700176239 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Roxbury' limit 1
loadtime:2.478844165802 / seconds
Query Executed:select id FROM `ma` where city='West Roxbury' && SIC_code='8299'DB:business_master_new
loadtime:2.4870760440826 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Somerville' limit 1
loadtime:2.4871490001678 / seconds
Query Executed:select id FROM `ma` where city='West Somerville' && SIC_code='8299'DB:business_master_new
loadtime:2.4875340461731 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:2.4875900745392 / seconds
Query Executed:select id FROM `ma` where city='West Springfield' && SIC_code='8299'DB:business_master_new
loadtime:2.502552986145 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Stockbridge' limit 1
loadtime:2.5026261806488 / seconds
Query Executed:select id FROM `ma` where city='West Stockbridge' && SIC_code='8299'DB:business_master_new
loadtime:2.5037310123444 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Tisbury' limit 1
loadtime:2.5037870407104 / seconds
Query Executed:select id FROM `ma` where city='West Tisbury' && SIC_code='8299'DB:business_master_new
loadtime:2.5066480636597 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Townsend' limit 1
loadtime:2.5067009925842 / seconds
Query Executed:select id FROM `ma` where city='West Townsend' && SIC_code='8299'DB:business_master_new
loadtime:2.507618188858 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wareham' limit 1
loadtime:2.5076701641083 / seconds
Query Executed:select id FROM `ma` where city='West Wareham' && SIC_code='8299'DB:business_master_new
loadtime:2.5089061260223 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Warren' limit 1
loadtime:2.5089590549469 / seconds
Query Executed:select id FROM `ma` where city='West Warren' && SIC_code='8299'DB:business_master_new
loadtime:2.5096840858459 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Whately' limit 1
loadtime:2.5097360610962 / seconds
Query Executed:select id FROM `ma` where city='West Whately' && SIC_code='8299'DB:business_master_new
loadtime:2.5101380348206 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Yarmouth' limit 1
loadtime:2.5102000236511 / seconds
Query Executed:select id FROM `ma` where city='West Yarmouth' && SIC_code='8299'DB:business_master_new
loadtime:2.5148911476135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westborough' limit 1
loadtime:2.5149610042572 / seconds
Query Executed:select id FROM `ma` where city='Westborough' && SIC_code='8299'DB:business_master_new
loadtime:2.5281991958618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:2.5282771587372 / seconds
Query Executed:select id FROM `ma` where city='Westfield' && SIC_code='8299'DB:business_master_new
loadtime:2.542090177536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westford' limit 1
loadtime:2.5421731472015 / seconds
Query Executed:select id FROM `ma` where city='Westford' && SIC_code='8299'DB:business_master_new
loadtime:2.5513432025909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westhampton' limit 1
loadtime:2.5514249801636 / seconds
Query Executed:select id FROM `ma` where city='Westhampton' && SIC_code='8299'DB:business_master_new
loadtime:2.5518260002136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westminster' limit 1
loadtime:2.5518801212311 / seconds
Query Executed:select id FROM `ma` where city='Westminster' && SIC_code='8299'DB:business_master_new
loadtime:2.5554401874542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:2.555507183075 / seconds
Query Executed:select id FROM `ma` where city='Weston' && SIC_code='8299'DB:business_master_new
loadtime:2.5604200363159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:2.560487985611 / seconds
Query Executed:select id FROM `ma` where city='Westport' && SIC_code='8299'DB:business_master_new
loadtime:2.5671751499176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport Point' limit 1
loadtime:2.5672540664673 / seconds
Query Executed:select id FROM `ma` where city='Westport Point' && SIC_code='8299'DB:business_master_new
loadtime:2.5677540302277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:2.5678081512451 / seconds
Query Executed:select id FROM `ma` where city='Westwood' && SIC_code='8299'DB:business_master_new
loadtime:2.5746011734009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weymouth' limit 1
loadtime:2.5746531486511 / seconds
Query Executed:select id FROM `ma` where city='Weymouth' && SIC_code='8299'DB:business_master_new
loadtime:2.5802760124207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whately' limit 1
loadtime:2.5803430080414 / seconds
Query Executed:select id FROM `ma` where city='Whately' && SIC_code='8299'DB:business_master_new
loadtime:2.581258058548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheelwright' limit 1
loadtime:2.5813241004944 / seconds
Query Executed:select id FROM `ma` where city='Wheelwright' && SIC_code='8299'DB:business_master_new
loadtime:2.5817580223083 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Bch' limit 1
loadtime:2.5818130970001 / seconds
Query Executed:select id FROM `ma` where city='White Horse Bch' && SIC_code='8299'DB:business_master_new
loadtime:2.5822141170502 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Horse Beach' limit 1
loadtime:2.5822670459747 / seconds
Query Executed:select id FROM `ma` where city='White Horse Beach' && SIC_code='8299'DB:business_master_new
loadtime:2.5827209949493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitinsville' limit 1
loadtime:2.5827732086182 / seconds
Query Executed:select id FROM `ma` where city='Whitinsville' && SIC_code='8299'DB:business_master_new
loadtime:2.5871300697327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitman' limit 1
loadtime:2.5872111320496 / seconds
Query Executed:select id FROM `ma` where city='Whitman' && SIC_code='8299'DB:business_master_new
loadtime:2.5923800468445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbraham' limit 1
loadtime:2.5924501419067 / seconds
Query Executed:select id FROM `ma` where city='Wilbraham' && SIC_code='8299'DB:business_master_new
loadtime:2.5984380245209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkinsonville' limit 1
loadtime:2.5985071659088 / seconds
Query Executed:select id FROM `ma` where city='Wilkinsonville' && SIC_code='8299'DB:business_master_new
loadtime:2.598916053772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:2.5989680290222 / seconds
Query Executed:select id FROM `ma` where city='Williamsburg' && SIC_code='8299'DB:business_master_new
loadtime:2.6005661487579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:2.6006309986115 / seconds
Query Executed:select id FROM `ma` where city='Williamstown' && SIC_code='8299'DB:business_master_new
loadtime:2.6050641536713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:2.605131149292 / seconds
Query Executed:select id FROM `ma` where city='Wilmington' && SIC_code='8299'DB:business_master_new
loadtime:2.6147141456604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon' limit 1
loadtime:2.614785194397 / seconds
Query Executed:select id FROM `ma` where city='Winchendon' && SIC_code='8299'DB:business_master_new
loadtime:2.6187601089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Spgs' limit 1
loadtime:2.6188139915466 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Spgs' && SIC_code='8299'DB:business_master_new
loadtime:2.6192531585693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchendon Springs' limit 1
loadtime:2.6193060874939 / seconds
Query Executed:select id FROM `ma` where city='Winchendon Springs' && SIC_code='8299'DB:business_master_new
loadtime:2.6198120117188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:2.6198651790619 / seconds
Query Executed:select id FROM `ma` where city='Winchester' && SIC_code='8299'DB:business_master_new
loadtime:2.6288740634918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:2.6289460659027 / seconds
Query Executed:select id FROM `ma` where city='Windsor' && SIC_code='8299'DB:business_master_new
loadtime:2.6296150684357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:2.6296691894531 / seconds
Query Executed:select id FROM `ma` where city='Winthrop' && SIC_code='8299'DB:business_master_new
loadtime:2.6357851028442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woburn' limit 1
loadtime:2.6358580589294 / seconds
Query Executed:select id FROM `ma` where city='Woburn' && SIC_code='8299'DB:business_master_new
loadtime:2.6578850746155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wollaston' limit 1
loadtime:2.6579689979553 / seconds
Query Executed:select id FROM `ma` where city='Wollaston' && SIC_code='8299'DB:business_master_new
loadtime:2.6583700180054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Hole' limit 1
loadtime:2.6584250926971 / seconds
Query Executed:select id FROM `ma` where city='Woods Hole' && SIC_code='8299'DB:business_master_new
loadtime:2.6596720218658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:2.659725189209 / seconds
Query Executed:select id FROM `ma` where city='Woodville' && SIC_code='8299'DB:business_master_new
loadtime:2.6602051258087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worcester' limit 1
loadtime:2.660257101059 / seconds
Query Executed:select id FROM `ma` where city='Worcester' && SIC_code='8299'DB:business_master_new
loadtime:2.6724991798401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woronoco' limit 1
loadtime:2.6726140975952 / seconds
Query Executed:select id FROM `ma` where city='Woronoco' && SIC_code='8299'DB:business_master_new
loadtime:2.6730329990387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:2.6730880737305 / seconds
Query Executed:select id FROM `ma` where city='Worthington' && SIC_code='8299'DB:business_master_new
loadtime:2.6739990711212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrentham' limit 1
loadtime:2.6740531921387 / seconds
Query Executed:select id FROM `ma` where city='Wrentham' && SIC_code='8299'DB:business_master_new
loadtime:2.6801741123199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth Port' limit 1
loadtime:2.6802501678467 / seconds
Query Executed:select id FROM `ma` where city='Yarmouth Port' && SIC_code='8299'DB:business_master_new
loadtime:2.6844570636749 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:2.6846010684967 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:2.6850471496582 / seconds
Operation template executed (chunk cache operation)
loadtime:2.6852221488953 / seconds
template override:Default
loadtime:2.6852650642395 / 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.6864471435547 / seconds
Template Constructed, Array Rows:49
loadtime:2.6869730949402 / seconds
TOTAL EXECUTION TIME: 2.68653
loadtime:2.6898410320282 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => schools-and-educational-services-nec [stateURLid] => 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.6898519992828
TOTAL KEY ARRAYS: 69