Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.7976455688477E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018839836120605 / seconds
host not found setting manual db connection
loadtime:0.009645938873291 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099248886108398 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010165929794312 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010231018066406 / seconds
zipcode:
loadtime:0.010258913040161 / seconds
Query Executed:select * from search_referrer where page_hash='a4e09f283a77d375b9043d4de22ffd7c' limit 10 DB:ezrox_toadli
loadtime:0.01059103012085 / seconds
Operation header executed (non global)
loadtime:0.010619878768921 / seconds
Operation leaderboard executed (non global)
loadtime:0.010671854019165 / seconds
Operation square executed (non global)
loadtime:0.010701894760132 / seconds
Operation square_bottom executed (non global)
loadtime:0.010730028152466 / seconds
Operation smallsquare executed (non global)
loadtime:0.010771989822388 / seconds
Operation headeradright executed (non global)
loadtime:0.010798931121826 / seconds
Operation google_analytics executed (non global)
loadtime:0.010824918746948 / seconds
Operation topstories executed (non global)
loadtime:0.010849952697754 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010876893997192 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010901927947998 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011185884475708 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011385917663574 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01142692565918 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011488914489746 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011536836624146 / seconds
Template key: archive_menu pushed
loadtime:0.011548042297363 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011560916900635 / seconds
Template key: get_gravatar pushed
loadtime:0.011567831039429 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011576890945435 / seconds
*10)-10)+1 | start:0
loadtime:0.01161789894104 / seconds
Query loaded from cache:select * from categories where cat_URLid='grocery-stores'
loadtime:0.011658906936646 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.01169490814209 / seconds
DB connected to localhost business_master_new
loadtime:0.011965036392212 / seconds
Query Executed:select * from `ms_catmap` where sic='5411' order by city ascDB:business_master_new
loadtime:0.028422832489014 / seconds
Query stored in cache : _QUERY_www.toadli.comb3932ceee4ef41b136e37bccba254bf8
loadtime:0.030252933502197 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.030312061309814 / seconds
Query Executed:select sum(totalcount) as totalsum from `ms_catmap` where sic='5411'DB:business_master_new
loadtime:0.032711029052734 / seconds
Query stored in cache : _QUERY_www.toadli.com651acfbdaccbcaa3c0bd344ece65e345
loadtime:0.032754898071289 / seconds
463 / 11
loadtime:0.032814025878906 / seconds
Query Executed:select * from geodata_geocity where city='Abbeville' limit 1DB:business_master_new
loadtime:0.033231973648071 / seconds
Query stored in cache : _QUERY_www.toadli.comae1aeeaf54fdd625f0ef987226ed1291
loadtime:0.033305883407593 / seconds
Query Executed:select id FROM `ms` where city='Abbeville' && SIC_code='5411'DB:business_master_new
loadtime:0.058394908905029 / seconds
Query Executed:select * from geodata_geocity where city='Aberdeen' limit 1DB:business_master_new
loadtime:0.058840036392212 / seconds
Query stored in cache : _QUERY_www.toadli.com42528276ef69831a9ccb5ee7e450002e
loadtime:0.058927059173584 / seconds
Query Executed:select id FROM `ms` where city='Aberdeen' && SIC_code='5411'DB:business_master_new
loadtime:0.067078828811646 / seconds
Query Executed:select * from geodata_geocity where city='Ackerman' limit 1DB:business_master_new
loadtime:0.067553997039795 / seconds
Query stored in cache : _QUERY_www.toadli.comea51db89861669dcef164b4e77af393e
loadtime:0.067626953125 / seconds
Query Executed:select id FROM `ms` where city='Ackerman' && SIC_code='5411'DB:business_master_new
loadtime:0.10225605964661 / seconds
Query Executed:select * from geodata_geocity where city='Agricola' limit 1DB:business_master_new
loadtime:0.10307192802429 / seconds
Query stored in cache : _QUERY_www.toadli.com2ac4485e49b588ac6345f6fa44f9f908
loadtime:0.10318183898926 / seconds
Query Executed:select id FROM `ms` where city='Agricola' && SIC_code='5411'DB:business_master_new
loadtime:0.10376000404358 / seconds
Query Executed:select * from geodata_geocity where city='Alcorn State' limit 1DB:business_master_new
loadtime:0.10435605049133 / seconds
Query stored in cache : _QUERY_www.toadli.com63c18bf0d4efa32b785a47ff068c37d2
loadtime:0.10445690155029 / seconds
Query Executed:select id FROM `ms` where city='Alcorn State' && SIC_code='5411'DB:business_master_new
loadtime:0.10505390167236 / seconds
Query Executed:select * from geodata_geocity where city='Algoma' limit 1DB:business_master_new
loadtime:0.10575699806213 / seconds
Query stored in cache : _QUERY_www.toadli.com6339ce11c5530b7761278753c06575ed
loadtime:0.10585784912109 / seconds
Query Executed:select id FROM `ms` where city='Algoma' && SIC_code='5411'DB:business_master_new
loadtime:0.10632491111755 / seconds
Query Executed:select * from geodata_geocity where city='Alligator' limit 1DB:business_master_new
loadtime:0.10676288604736 / seconds
Query stored in cache : _QUERY_www.toadli.com08007e9006fc017461391c9bb3176cc2
loadtime:0.10685992240906 / seconds
Query Executed:select id FROM `ms` where city='Alligator' && SIC_code='5411'DB:business_master_new
loadtime:0.10746598243713 / seconds
Query Executed:select * from geodata_geocity where city='Amory' limit 1DB:business_master_new
loadtime:0.10795187950134 / seconds
Query stored in cache : _QUERY_www.toadli.com102de72e7fdb7bc5ca9bc0ba5a3ece15
loadtime:0.10805702209473 / seconds
Query Executed:select id FROM `ms` where city='Amory' && SIC_code='5411'DB:business_master_new
loadtime:0.11646890640259 / seconds
Query Executed:select * from geodata_geocity where city='Anguilla' limit 1DB:business_master_new
loadtime:0.11703085899353 / seconds
Query stored in cache : _QUERY_www.toadli.com8c042c4e888db3c4787ba12a87084440
loadtime:0.11713099479675 / seconds
Query Executed:select id FROM `ms` where city='Anguilla' && SIC_code='5411'DB:business_master_new
loadtime:0.11790704727173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.11802387237549 / seconds
Query Executed:select id FROM `ms` where city='Arcola' && SIC_code='5411'DB:business_master_new
loadtime:0.11868405342102 / seconds
Query Executed:select * from geodata_geocity where city='Arkabutla' limit 1DB:business_master_new
loadtime:0.11917901039124 / seconds
Query stored in cache : _QUERY_www.toadli.com39f7e8726fe7959d77f490dc7c2102f7
loadtime:0.11928200721741 / seconds
Query Executed:select id FROM `ms` where city='Arkabutla' && SIC_code='5411'DB:business_master_new
loadtime:0.11972498893738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Artesia' limit 1
loadtime:0.11982297897339 / seconds
Query Executed:select id FROM `ms` where city='Artesia' && SIC_code='5411'DB:business_master_new
loadtime:0.12039995193481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.12048292160034 / seconds
Query Executed:select id FROM `ms` where city='Ashland' && SIC_code='5411'DB:business_master_new
loadtime:0.12689304351807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.12698698043823 / seconds
Query Executed:select id FROM `ms` where city='Avalon' && SIC_code='5411'DB:business_master_new
loadtime:0.12733697891235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.12739205360413 / seconds
Query Executed:select id FROM `ms` where city='Avon' && SIC_code='5411'DB:business_master_new
loadtime:0.12787294387817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.1279468536377 / seconds
Query Executed:select id FROM `ms` where city='Bailey' && SIC_code='5411'DB:business_master_new
loadtime:0.12863087654114 / seconds
Query Executed:select * from geodata_geocity where city='Baldwyn' limit 1DB:business_master_new
loadtime:0.12908697128296 / seconds
Query stored in cache : _QUERY_www.toadli.comd6a51e1c0052d51648de413bfba8357a
loadtime:0.12915992736816 / seconds
Query Executed:select id FROM `ms` where city='Baldwyn' && SIC_code='5411'DB:business_master_new
loadtime:0.1349618434906 / seconds
Query Executed:select * from geodata_geocity where city='Banner' limit 1DB:business_master_new
loadtime:0.13544702529907 / seconds
Query stored in cache : _QUERY_www.toadli.comb8ac745d1ce05f58338f59a76544bba4
loadtime:0.1355128288269 / seconds
Query Executed:select id FROM `ms` where city='Banner' && SIC_code='5411'DB:business_master_new
loadtime:0.13595700263977 / seconds
Query Executed:select * from geodata_geocity where city='Bassfield' limit 1DB:business_master_new
loadtime:0.13640785217285 / seconds
Query stored in cache : _QUERY_www.toadli.come843756c981162ad25c6142f0d09a1c3
loadtime:0.13647294044495 / seconds
Query Executed:select id FROM `ms` where city='Bassfield' && SIC_code='5411'DB:business_master_new
loadtime:0.13771891593933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Batesville' limit 1
loadtime:0.13780403137207 / seconds
Query Executed:select id FROM `ms` where city='Batesville' && SIC_code='5411'DB:business_master_new
loadtime:0.14934206008911 / seconds
Query Executed:select * from geodata_geocity where city='Bay Saint Louis' limit 1DB:business_master_new
loadtime:0.14986085891724 / seconds
Query stored in cache : _QUERY_www.toadli.com8eb25a803b4d5c6716a9f2a8afd897f9
loadtime:0.14993405342102 / seconds
Query Executed:select id FROM `ms` where city='Bay Saint Louis' && SIC_code='5411'DB:business_master_new
loadtime:0.17974495887756 / seconds
Query Executed:select * from geodata_geocity where city='Bay Springs' limit 1DB:business_master_new
loadtime:0.18024301528931 / seconds
Query stored in cache : _QUERY_www.toadli.comf878480bb838a144c540d9df0195cde2
loadtime:0.18031096458435 / seconds
Query Executed:select id FROM `ms` where city='Bay Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.21251893043518 / seconds
Query Executed:select * from geodata_geocity where city='Bay St Louis' limit 1DB:business_master_new
loadtime:0.21303987503052 / seconds
Query stored in cache : _QUERY_www.toadli.com24124304fda144c4d26d2e3992e4d26e
loadtime:0.21311688423157 / seconds
Query Executed:select id FROM `ms` where city='Bay St Louis' && SIC_code='5411'DB:business_master_new
loadtime:0.21405506134033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaumont' limit 1
loadtime:0.2141330242157 / seconds
Query Executed:select id FROM `ms` where city='Beaumont' && SIC_code='5411'DB:business_master_new
loadtime:0.22002387046814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Becker' limit 1
loadtime:0.22009992599487 / seconds
Query Executed:select id FROM `ms` where city='Becker' && SIC_code='5411'DB:business_master_new
loadtime:0.22052097320557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belden' limit 1
loadtime:0.22057390213013 / seconds
Query Executed:select id FROM `ms` where city='Belden' && SIC_code='5411'DB:business_master_new
loadtime:0.2510130405426 / seconds
Query Executed:select * from geodata_geocity where city='Belen' limit 1DB:business_master_new
loadtime:0.25147891044617 / seconds
Query stored in cache : _QUERY_www.toadli.comed3a2237f1e2eeb50b4ac526c10e4716
loadtime:0.25155091285706 / seconds
Query Executed:select id FROM `ms` where city='Belen' && SIC_code='5411'DB:business_master_new
loadtime:0.25195598602295 / seconds
Query Executed:select * from geodata_geocity where city='Bellefontaine' limit 1DB:business_master_new
loadtime:0.25236487388611 / seconds
Query stored in cache : _QUERY_www.toadli.com2a593eb2da1902cbe1b44e359131b627
loadtime:0.2524299621582 / seconds
Query Executed:select id FROM `ms` where city='Bellefontaine' && SIC_code='5411'DB:business_master_new
loadtime:0.25285601615906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.25292682647705 / seconds
Query Executed:select id FROM `ms` where city='Belmont' && SIC_code='5411'DB:business_master_new
loadtime:0.28300595283508 / seconds
Query Executed:select * from geodata_geocity where city='Belzoni' limit 1DB:business_master_new
loadtime:0.2834198474884 / seconds
Query stored in cache : _QUERY_www.toadli.com1cfe5225148999492ba35f94fbe089d9
loadtime:0.28348684310913 / seconds
Query Executed:select id FROM `ms` where city='Belzoni' && SIC_code='5411'DB:business_master_new
loadtime:0.31433796882629 / seconds
Query Executed:select * from geodata_geocity where city='Benoit' limit 1DB:business_master_new
loadtime:0.31483387947083 / seconds
Query stored in cache : _QUERY_www.toadli.com3cf009111079719d50ffa368f9803964
loadtime:0.31490993499756 / seconds
Query Executed:select id FROM `ms` where city='Benoit' && SIC_code='5411'DB:business_master_new
loadtime:0.3156909942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.31576991081238 / seconds
Query Executed:select id FROM `ms` where city='Benton' && SIC_code='5411'DB:business_master_new
loadtime:0.31674385070801 / seconds
Query Executed:select * from geodata_geocity where city='Bentonia' limit 1DB:business_master_new
loadtime:0.31717705726624 / seconds
Query stored in cache : _QUERY_www.toadli.com678be2ba2fdf71324ca4a8290d13a502
loadtime:0.31724190711975 / seconds
Query Executed:select id FROM `ms` where city='Bentonia' && SIC_code='5411'DB:business_master_new
loadtime:0.31840491294861 / seconds
Query Executed:select * from geodata_geocity where city='Beulah' limit 1DB:business_master_new
loadtime:0.31886792182922 / seconds
Query stored in cache : _QUERY_www.toadli.com90a72cb17d1aec875ab06bb85648ca59
loadtime:0.31893396377563 / seconds
Query Executed:select id FROM `ms` where city='Beulah' && SIC_code='5411'DB:business_master_new
loadtime:0.31939697265625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Creek' limit 1
loadtime:0.31946492195129 / seconds
Query Executed:select id FROM `ms` where city='Big Creek' && SIC_code='5411'DB:business_master_new
loadtime:0.31999397277832 / seconds
Query Executed:select * from geodata_geocity where city='Biloxi' limit 1DB:business_master_new
loadtime:0.32041501998901 / seconds
Query stored in cache : _QUERY_www.toadli.com61fe2ccdcc585c2e433b1c854fded47c
loadtime:0.32047891616821 / seconds
Query Executed:select id FROM `ms` where city='Biloxi' && SIC_code='5411'DB:business_master_new
loadtime:0.351637840271 / seconds
Query Executed:select * from geodata_geocity where city='Blue Mountain' limit 1DB:business_master_new
loadtime:0.35219192504883 / seconds
Query stored in cache : _QUERY_www.toadli.come15dae1aad94499898d1c3ef61a6a971
loadtime:0.35226202011108 / seconds
Query Executed:select id FROM `ms` where city='Blue Mountain' && SIC_code='5411'DB:business_master_new
loadtime:0.35333395004272 / seconds
Query Executed:select * from geodata_geocity where city='Blue Springs' limit 1DB:business_master_new
loadtime:0.3537540435791 / seconds
Query stored in cache : _QUERY_www.toadli.com5baebab0d6501f9c381479bdcfaf5954
loadtime:0.35382795333862 / seconds
Query Executed:select id FROM `ms` where city='Blue Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.35471105575562 / seconds
Query Executed:select * from geodata_geocity where city='Bogue Chitto' limit 1DB:business_master_new
loadtime:0.35516285896301 / seconds
Query stored in cache : _QUERY_www.toadli.com2c4b233458c84bba8bc92d4d0e5f9c31
loadtime:0.35522890090942 / seconds
Query Executed:select id FROM `ms` where city='Bogue Chitto' && SIC_code='5411'DB:business_master_new
loadtime:0.35644888877869 / seconds
Query Executed:select * from geodata_geocity where city='Bolton' limit 1DB:business_master_new
loadtime:0.35688304901123 / seconds
Query stored in cache : _QUERY_www.toadli.comd0a35365458e8495812d3193805615dd
loadtime:0.35694885253906 / seconds
Query Executed:select id FROM `ms` where city='Bolton' && SIC_code='5411'DB:business_master_new
loadtime:0.35835003852844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booneville' limit 1
loadtime:0.35842204093933 / seconds
Query Executed:select id FROM `ms` where city='Booneville' && SIC_code='5411'DB:business_master_new
loadtime:0.36873197555542 / seconds
Query Executed:select * from geodata_geocity where city='Boyle' limit 1DB:business_master_new
loadtime:0.36922693252563 / seconds
Query stored in cache : _QUERY_www.toadli.comacf99eb635808cbb65ea51a58273e367
loadtime:0.36929488182068 / seconds
Query Executed:select id FROM `ms` where city='Boyle' && SIC_code='5411'DB:business_master_new
loadtime:0.37040090560913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.37047386169434 / seconds
Query Executed:select id FROM `ms` where city='Brandon' && SIC_code='5411'DB:business_master_new
loadtime:0.3985710144043 / seconds
Query Executed:select * from geodata_geocity where city='Braxton' limit 1DB:business_master_new
loadtime:0.39910697937012 / seconds
Query stored in cache : _QUERY_www.toadli.com4c060aac94c4dd23fe9cae2716ded5df
loadtime:0.39917397499084 / seconds
Query Executed:select id FROM `ms` where city='Braxton' && SIC_code='5411'DB:business_master_new
loadtime:0.3999228477478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookhaven' limit 1
loadtime:0.40000486373901 / seconds
Query Executed:select id FROM `ms` where city='Brookhaven' && SIC_code='5411'DB:business_master_new
loadtime:0.41727685928345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.41741895675659 / seconds
Query Executed:select id FROM `ms` where city='Brooklyn' && SIC_code='5411'DB:business_master_new
loadtime:0.41832804679871 / seconds
Query Executed:select * from geodata_geocity where city='Brooksville' limit 1DB:business_master_new
loadtime:0.41883301734924 / seconds
Query stored in cache : _QUERY_www.toadli.comaa232f8219a9c619a84a5951b7199b84
loadtime:0.4189019203186 / seconds
Query Executed:select id FROM `ms` where city='Brooksville' && SIC_code='5411'DB:business_master_new
loadtime:0.42007303237915 / seconds
Query Executed:select * from geodata_geocity where city='Bruce' limit 1DB:business_master_new
loadtime:0.42055583000183 / seconds
Query stored in cache : _QUERY_www.toadli.com693bd0f5eecc65630801f0a00a346778
loadtime:0.42062187194824 / seconds
Query Executed:select id FROM `ms` where city='Bruce' && SIC_code='5411'DB:business_master_new
loadtime:0.45155501365662 / seconds
Query Executed:select * from geodata_geocity where city='Buckatunna' limit 1DB:business_master_new
loadtime:0.452064037323 / seconds
Query stored in cache : _QUERY_www.toadli.com2df616e8c0ea8315fab4c5026eb7e8d6
loadtime:0.4521369934082 / seconds
Query Executed:select id FROM `ms` where city='Buckatunna' && SIC_code='5411'DB:business_master_new
loadtime:0.45301294326782 / seconds
Query Executed:select * from geodata_geocity where city='Bude' limit 1DB:business_master_new
loadtime:0.453449010849 / seconds
Query stored in cache : _QUERY_www.toadli.com65dcaa915801f52a92a1cccea6ad3015
loadtime:0.45351386070251 / seconds
Query Executed:select id FROM `ms` where city='Bude' && SIC_code='5411'DB:business_master_new
loadtime:0.45460987091064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.45468902587891 / seconds
Query Executed:select id FROM `ms` where city='Burnsville' && SIC_code='5411'DB:business_master_new
loadtime:0.45580697059631 / seconds
Query Executed:select * from geodata_geocity where city='Byhalia' limit 1DB:business_master_new
loadtime:0.45624399185181 / seconds
Query stored in cache : _QUERY_www.toadli.com449d0999323769568685cc3f165f0955
loadtime:0.45631003379822 / seconds
Query Executed:select id FROM `ms` where city='Byhalia' && SIC_code='5411'DB:business_master_new
loadtime:0.46213603019714 / seconds
Query Executed:select * from geodata_geocity where city='Byram' limit 1DB:business_master_new
loadtime:0.46258902549744 / seconds
Query stored in cache : _QUERY_www.toadli.comda5aeecd56e3d39b511b192925db6c4d
loadtime:0.46265387535095 / seconds
Query Executed:select id FROM `ms` where city='Byram' && SIC_code='5411'DB:business_master_new
loadtime:0.47001194953918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.47008800506592 / seconds
Query Executed:select id FROM `ms` where city='Caledonia' && SIC_code='5411'DB:business_master_new
loadtime:0.47142100334167 / seconds
Query Executed:select * from geodata_geocity where city='Calhoun City' limit 1DB:business_master_new
loadtime:0.47185802459717 / seconds
Query stored in cache : _QUERY_www.toadli.com2521548c7a131a13e940c22066314445
loadtime:0.471923828125 / seconds
Query Executed:select id FROM `ms` where city='Calhoun City' && SIC_code='5411'DB:business_master_new
loadtime:0.50256395339966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.50266098976135 / seconds
Query Executed:select id FROM `ms` where city='Camden' && SIC_code='5411'DB:business_master_new
loadtime:0.50328183174133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.50335097312927 / seconds
Query Executed:select id FROM `ms` where city='Canton' && SIC_code='5411'DB:business_master_new
loadtime:0.51386189460754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carriere' limit 1
loadtime:0.51397085189819 / seconds
Query Executed:select id FROM `ms` where city='Carriere' && SIC_code='5411'DB:business_master_new
loadtime:0.5438928604126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.54398798942566 / seconds
Query Executed:select id FROM `ms` where city='Carrollton' && SIC_code='5411'DB:business_master_new
loadtime:0.54523205757141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.5453040599823 / seconds
Query Executed:select id FROM `ms` where city='Carson' && SIC_code='5411'DB:business_master_new
loadtime:0.54592895507812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.54598903656006 / seconds
Query Executed:select id FROM `ms` where city='Carthage' && SIC_code='5411'DB:business_master_new
loadtime:0.55388498306274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.55399084091187 / seconds
Query Executed:select id FROM `ms` where city='Cary' && SIC_code='5411'DB:business_master_new
loadtime:0.55463600158691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascilla' limit 1
loadtime:0.55470490455627 / seconds
Query Executed:select id FROM `ms` where city='Cascilla' && SIC_code='5411'DB:business_master_new
loadtime:0.55520701408386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarbluff' limit 1
loadtime:0.55527305603027 / seconds
Query Executed:select id FROM `ms` where city='Cedarbluff' && SIC_code='5411'DB:business_master_new
loadtime:0.55581283569336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.55587697029114 / seconds
Query Executed:select id FROM `ms` where city='Centreville' && SIC_code='5411'DB:business_master_new
loadtime:0.55758690834045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.55766296386719 / seconds
Query Executed:select id FROM `ms` where city='Charleston' && SIC_code='5411'DB:business_master_new
loadtime:0.58763289451599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatawa' limit 1
loadtime:0.58772301673889 / seconds
Query Executed:select id FROM `ms` where city='Chatawa' && SIC_code='5411'DB:business_master_new
loadtime:0.58815002441406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.58820605278015 / seconds
Query Executed:select id FROM `ms` where city='Chatham' && SIC_code='5411'DB:business_master_new
loadtime:0.58863687515259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Choctaw' limit 1
loadtime:0.58870100975037 / seconds
Query Executed:select id FROM `ms` where city='Choctaw' && SIC_code='5411'DB:business_master_new
loadtime:0.58907103538513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chunky' limit 1
loadtime:0.58912587165833 / seconds
Query Executed:select id FROM `ms` where city='Chunky' && SIC_code='5411'DB:business_master_new
loadtime:0.58967304229736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clara' limit 1
loadtime:0.58972501754761 / seconds
Query Executed:select id FROM `ms` where city='Clara' && SIC_code='5411'DB:business_master_new
loadtime:0.59020400047302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksdale' limit 1
loadtime:0.59027099609375 / seconds
Query Executed:select id FROM `ms` where city='Clarksdale' && SIC_code='5411'DB:business_master_new
loadtime:0.60439491271973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.6045069694519 / seconds
Query Executed:select id FROM `ms` where city='Cleveland' && SIC_code='5411'DB:business_master_new
loadtime:0.61744785308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.61755895614624 / seconds
Query Executed:select id FROM `ms` where city='Clinton' && SIC_code='5411'DB:business_master_new
loadtime:0.63373589515686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coahoma' limit 1
loadtime:0.63385701179504 / seconds
Query Executed:select id FROM `ms` where city='Coahoma' && SIC_code='5411'DB:business_master_new
loadtime:0.63444089889526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffeeville' limit 1
loadtime:0.63451099395752 / seconds
Query Executed:select id FROM `ms` where city='Coffeeville' && SIC_code='5411'DB:business_master_new
loadtime:0.63630890846252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coila' limit 1
loadtime:0.63638496398926 / seconds
Query Executed:select id FROM `ms` where city='Coila' && SIC_code='5411'DB:business_master_new
loadtime:0.63691306114197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.63698506355286 / seconds
Query Executed:select id FROM `ms` where city='Coldwater' && SIC_code='5411'DB:business_master_new
loadtime:0.66772890090942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.66782903671265 / seconds
Query Executed:select id FROM `ms` where city='Collins' && SIC_code='5411'DB:business_master_new
loadtime:0.6982479095459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.69834589958191 / seconds
Query Executed:select id FROM `ms` where city='Collinsville' && SIC_code='5411'DB:business_master_new
loadtime:0.6999659538269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.70003795623779 / seconds
Query Executed:select id FROM `ms` where city='Columbia' && SIC_code='5411'DB:business_master_new
loadtime:0.71199584007263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.71209692955017 / seconds
Query Executed:select id FROM `ms` where city='Columbus' && SIC_code='5411'DB:business_master_new
loadtime:0.74861001968384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Afb' limit 1
loadtime:0.74882793426514 / seconds
Query Executed:select id FROM `ms` where city='Columbus Afb' && SIC_code='5411'DB:business_master_new
loadtime:0.74945998191833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.74954605102539 / seconds
Query Executed:select id FROM `ms` where city='Como' && SIC_code='5411'DB:business_master_new
loadtime:0.75106692314148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conehatta' limit 1
loadtime:0.75115203857422 / seconds
Query Executed:select id FROM `ms` where city='Conehatta' && SIC_code='5411'DB:business_master_new
loadtime:0.75177383422852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.75185298919678 / seconds
Query Executed:select id FROM `ms` where city='Corinth' && SIC_code='5411'DB:business_master_new
loadtime:0.77427792549133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.77440905570984 / seconds
Query Executed:select id FROM `ms` where city='Courtland' && SIC_code='5411'DB:business_master_new
loadtime:0.77511787414551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.77519297599792 / seconds
Query Executed:select id FROM `ms` where city='Crawford' && SIC_code='5411'DB:business_master_new
loadtime:0.77610898017883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crenshaw' limit 1
loadtime:0.77618098258972 / seconds
Query Executed:select id FROM `ms` where city='Crenshaw' && SIC_code='5411'DB:business_master_new
loadtime:0.77699995040894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosby' limit 1
loadtime:0.77707099914551 / seconds
Query Executed:select id FROM `ms` where city='Crosby' && SIC_code='5411'DB:business_master_new
loadtime:0.77777600288391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowder' limit 1
loadtime:0.77784299850464 / seconds
Query Executed:select id FROM `ms` where city='Crowder' && SIC_code='5411'DB:business_master_new
loadtime:0.77835202217102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cruger' limit 1
loadtime:0.77841901779175 / seconds
Query Executed:select id FROM `ms` where city='Cruger' && SIC_code='5411'DB:business_master_new
loadtime:0.77894496917725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Springs' limit 1
loadtime:0.77901196479797 / seconds
Query Executed:select id FROM `ms` where city='Crystal Springs' && SIC_code='5411'DB:business_master_new
loadtime:0.7856810092926 / seconds
Query loaded from cache:select * from geodata_geocity where city='D Lo' limit 1
loadtime:0.78577303886414 / seconds
Query Executed:select id FROM `ms` where city='D Lo' && SIC_code='5411'DB:business_master_new
loadtime:0.78638100624084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.78645086288452 / seconds
Query Executed:select id FROM `ms` where city='Daleville' && SIC_code='5411'DB:business_master_new
loadtime:0.78696298599243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darling' limit 1
loadtime:0.78703093528748 / seconds
Query Executed:select id FROM `ms` where city='Darling' && SIC_code='5411'DB:business_master_new
loadtime:0.78741884231567 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Kalb' limit 1
loadtime:0.78748297691345 / seconds
Query Executed:select id FROM `ms` where city='De Kalb' && SIC_code='5411'DB:business_master_new
loadtime:0.81913089752197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.81921792030334 / seconds
Query Executed:select id FROM `ms` where city='Decatur' && SIC_code='5411'DB:business_master_new
loadtime:0.82091593742371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta City' limit 1
loadtime:0.8209969997406 / seconds
Query Executed:select id FROM `ms` where city='Delta City' && SIC_code='5411'DB:business_master_new
loadtime:0.82141184806824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.82146501541138 / seconds
Query Executed:select id FROM `ms` where city='Dennis' && SIC_code='5411'DB:business_master_new
loadtime:0.82225203514099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derma' limit 1
loadtime:0.8223249912262 / seconds
Query Executed:select id FROM `ms` where city='Derma' && SIC_code='5411'DB:business_master_new
loadtime:0.82293891906738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamondhead' limit 1
loadtime:0.82299399375916 / seconds
Query Executed:select id FROM `ms` where city='Diamondhead' && SIC_code='5411'DB:business_master_new
loadtime:0.85307192802429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diberville' limit 1
loadtime:0.85313987731934 / seconds
Query Executed:select id FROM `ms` where city='Diberville' && SIC_code='5411'DB:business_master_new
loadtime:0.86093783378601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doddsville' limit 1
loadtime:0.86101889610291 / seconds
Query Executed:select id FROM `ms` where city='Doddsville' && SIC_code='5411'DB:business_master_new
loadtime:0.86153292655945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drew' limit 1
loadtime:0.86159992218018 / seconds
Query Executed:select id FROM `ms` where city='Drew' && SIC_code='5411'DB:business_master_new
loadtime:0.89157295227051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.89164996147156 / seconds
Query Executed:select id FROM `ms` where city='Dublin' && SIC_code='5411'DB:business_master_new
loadtime:0.89215183258057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Hill' limit 1
loadtime:0.89221787452698 / seconds
Query Executed:select id FROM `ms` where city='Duck Hill' && SIC_code='5411'DB:business_master_new
loadtime:0.89312601089478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumas' limit 1
loadtime:0.89319801330566 / seconds
Query Executed:select id FROM `ms` where city='Dumas' && SIC_code='5411'DB:business_master_new
loadtime:0.89373803138733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.89380884170532 / seconds
Query Executed:select id FROM `ms` where city='Duncan' && SIC_code='5411'DB:business_master_new
loadtime:0.89430785179138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.89437294006348 / seconds
Query Executed:select id FROM `ms` where city='Dundee' && SIC_code='5411'DB:business_master_new
loadtime:0.8950788974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.89514589309692 / seconds
Query Executed:select id FROM `ms` where city='Durant' && SIC_code='5411'DB:business_master_new
loadtime:0.90057492256165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastabuchie' limit 1
loadtime:0.9006519317627 / seconds
Query Executed:select id FROM `ms` where city='Eastabuchie' && SIC_code='5411'DB:business_master_new
loadtime:0.90109395980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecru' limit 1
loadtime:0.90116095542908 / seconds
Query Executed:select id FROM `ms` where city='Ecru' && SIC_code='5411'DB:business_master_new
loadtime:0.90247201919556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:0.90254688262939 / seconds
Query Executed:select id FROM `ms` where city='Edinburg' && SIC_code='5411'DB:business_master_new
loadtime:0.90291500091553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:0.90297889709473 / seconds
Query Executed:select id FROM `ms` where city='Edwards' && SIC_code='5411'DB:business_master_new
loadtime:0.90444898605347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.90451788902283 / seconds
Query Executed:select id FROM `ms` where city='Elliott' && SIC_code='5411'DB:business_master_new
loadtime:0.90500783920288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellisville' limit 1
loadtime:0.90507292747498 / seconds
Query Executed:select id FROM `ms` where city='Ellisville' && SIC_code='5411'DB:business_master_new
loadtime:0.91168189048767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enid' limit 1
loadtime:0.91176986694336 / seconds
Query Executed:select id FROM `ms` where city='Enid' && SIC_code='5411'DB:business_master_new
loadtime:0.9123330116272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.9123899936676 / seconds
Query Executed:select id FROM `ms` where city='Enterprise' && SIC_code='5411'DB:business_master_new
loadtime:0.91348099708557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escatawpa' limit 1
loadtime:0.91355204582214 / seconds
Query Executed:select id FROM `ms` where city='Escatawpa' && SIC_code='5411'DB:business_master_new
loadtime:0.91448187828064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethel' limit 1
loadtime:0.91455101966858 / seconds
Query Executed:select id FROM `ms` where city='Ethel' && SIC_code='5411'DB:business_master_new
loadtime:0.91521000862122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etta' limit 1
loadtime:0.91527986526489 / seconds
Query Executed:select id FROM `ms` where city='Etta' && SIC_code='5411'DB:business_master_new
loadtime:0.91589784622192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eupora' limit 1
loadtime:0.91597390174866 / seconds
Query Executed:select id FROM `ms` where city='Eupora' && SIC_code='5411'DB:business_master_new
loadtime:0.94663906097412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:0.94671893119812 / seconds
Query Executed:select id FROM `ms` where city='Falcon' && SIC_code='5411'DB:business_master_new
loadtime:0.9471218585968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkner' limit 1
loadtime:0.94718885421753 / seconds
Query Executed:select id FROM `ms` where city='Falkner' && SIC_code='5411'DB:business_master_new
loadtime:0.94796299934387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farrell' limit 1
loadtime:0.94802784919739 / seconds
Query Executed:select id FROM `ms` where city='Farrell' && SIC_code='5411'DB:business_master_new
loadtime:0.94844484329224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.94849896430969 / seconds
Query Executed:select id FROM `ms` where city='Fayette' && SIC_code='5411'DB:business_master_new
loadtime:0.95078682899475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fernwood' limit 1
loadtime:0.95087385177612 / seconds
Query Executed:select id FROM `ms` where city='Fernwood' && SIC_code='5411'DB:business_master_new
loadtime:0.95146989822388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora' limit 1
loadtime:0.95153784751892 / seconds
Query Executed:select id FROM `ms` where city='Flora' && SIC_code='5411'DB:business_master_new
loadtime:0.9815080165863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.98158502578735 / seconds
Query Executed:select id FROM `ms` where city='Florence' && SIC_code='5411'DB:business_master_new
loadtime:0.98945283889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flowood' limit 1
loadtime:0.9895339012146 / seconds
Query Executed:select id FROM `ms` where city='Flowood' && SIC_code='5411'DB:business_master_new
loadtime:1.0014629364014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:1.0015349388123 / seconds
Query Executed:select id FROM `ms` where city='Forest' && SIC_code='5411'DB:business_master_new
loadtime:1.0105719566345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxworth' limit 1
loadtime:1.0106868743896 / seconds
Query Executed:select id FROM `ms` where city='Foxworth' && SIC_code='5411'DB:business_master_new
loadtime:1.0124008655548 / seconds
Query loaded from cache:select * from geodata_geocity where city='French Camp' limit 1
loadtime:1.0124878883362 / seconds
Query Executed:select id FROM `ms` where city='French Camp' && SIC_code='5411'DB:business_master_new
loadtime:1.0130820274353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friars Point' limit 1
loadtime:1.0131509304047 / seconds
Query Executed:select id FROM `ms` where city='Friars Point' && SIC_code='5411'DB:business_master_new
loadtime:1.0139219760895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:1.013995885849 / seconds
Query Executed:select id FROM `ms` where city='Fulton' && SIC_code='5411'DB:business_master_new
loadtime:1.02281498909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallman' limit 1
loadtime:1.0229048728943 / seconds
Query Executed:select id FROM `ms` where city='Gallman' && SIC_code='5411'DB:business_master_new
loadtime:1.0234799385071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gattman' limit 1
loadtime:1.0235488414764 / seconds
Query Executed:select id FROM `ms` where city='Gattman' && SIC_code='5411'DB:business_master_new
loadtime:1.0240778923035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gautier' limit 1
loadtime:1.0241439342499 / seconds
Query Executed:select id FROM `ms` where city='Gautier' && SIC_code='5411'DB:business_master_new
loadtime:1.0333368778229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:1.0334198474884 / seconds
Query Executed:select id FROM `ms` where city='Georgetown' && SIC_code='5411'DB:business_master_new
loadtime:1.0342149734497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:1.0342960357666 / seconds
Query Executed:select id FROM `ms` where city='Glen' && SIC_code='5411'DB:business_master_new
loadtime:1.0350618362427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allan' limit 1
loadtime:1.0351400375366 / seconds
Query Executed:select id FROM `ms` where city='Glen Allan' && SIC_code='5411'DB:business_master_new
loadtime:1.0359768867493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:1.036052942276 / seconds
Query Executed:select id FROM `ms` where city='Glendora' && SIC_code='5411'DB:business_master_new
loadtime:1.0366308689117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloster' limit 1
loadtime:1.0366940498352 / seconds
Query Executed:select id FROM `ms` where city='Gloster' && SIC_code='5411'DB:business_master_new
loadtime:1.0385129451752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:1.0385959148407 / seconds
Query Executed:select id FROM `ms` where city='Golden' && SIC_code='5411'DB:business_master_new
loadtime:1.0399160385132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:1.0400049686432 / seconds
Query Executed:select id FROM `ms` where city='Goodman' && SIC_code='5411'DB:business_master_new
loadtime:1.0408999919891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore Springs' limit 1
loadtime:1.0409879684448 / seconds
Query Executed:select id FROM `ms` where city='Gore Springs' && SIC_code='5411'DB:business_master_new
loadtime:1.0416538715363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grace' limit 1
loadtime:1.0417289733887 / seconds
Query Executed:select id FROM `ms` where city='Grace' && SIC_code='5411'DB:business_master_new
loadtime:1.0422470569611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.0423219203949 / seconds
Query Executed:select id FROM `ms` where city='Greenville' && SIC_code='5411'DB:business_master_new
loadtime:1.0674140453339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:1.0675959587097 / seconds
Query Executed:select id FROM `ms` where city='Greenwood' && SIC_code='5411'DB:business_master_new
loadtime:1.0842230319977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Spgs' limit 1
loadtime:1.0843889713287 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Spgs' && SIC_code='5411'DB:business_master_new
loadtime:1.0848548412323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Springs' limit 1
loadtime:1.0849230289459 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Springs' && SIC_code='5411'DB:business_master_new
loadtime:1.0855159759521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenada' limit 1
loadtime:1.0855798721313 / seconds
Query Executed:select id FROM `ms` where city='Grenada' && SIC_code='5411'DB:business_master_new
loadtime:1.1106908321381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulfport' limit 1
loadtime:1.1108100414276 / seconds
Query Executed:select id FROM `ms` where city='Gulfport' && SIC_code='5411'DB:business_master_new
loadtime:1.1612379550934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:1.1614739894867 / seconds
Query Executed:select id FROM `ms` where city='Gunnison' && SIC_code='5411'DB:business_master_new
loadtime:1.1622090339661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guntown' limit 1
loadtime:1.1622948646545 / seconds
Query Executed:select id FROM `ms` where city='Guntown' && SIC_code='5411'DB:business_master_new
loadtime:1.1637179851532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.1638059616089 / seconds
Query Executed:select id FROM `ms` where city='Hamilton' && SIC_code='5411'DB:business_master_new
loadtime:1.1651139259338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harperville' limit 1
loadtime:1.1651918888092 / seconds
Query Executed:select id FROM `ms` where city='Harperville' && SIC_code='5411'DB:business_master_new
loadtime:1.1657249927521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harriston' limit 1
loadtime:1.1658098697662 / seconds
Query Executed:select id FROM `ms` where city='Harriston' && SIC_code='5411'DB:business_master_new
loadtime:1.1661899089813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:1.1662518978119 / seconds
Query Executed:select id FROM `ms` where city='Harrisville' && SIC_code='5411'DB:business_master_new
loadtime:1.1667828559875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hattiesburg' limit 1
loadtime:1.1668469905853 / seconds
Query Executed:select id FROM `ms` where city='Hattiesburg' && SIC_code='5411'DB:business_master_new
loadtime:1.2128839492798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlehurst' limit 1
loadtime:1.2131729125977 / seconds
Query Executed:select id FROM `ms` where city='Hazlehurst' && SIC_code='5411'DB:business_master_new
loadtime:1.2206170558929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heidelberg' limit 1
loadtime:1.2207288742065 / seconds
Query Executed:select id FROM `ms` where city='Heidelberg' && SIC_code='5411'DB:business_master_new
loadtime:1.222601890564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermanville' limit 1
loadtime:1.2226839065552 / seconds
Query Executed:select id FROM `ms` where city='Hermanville' && SIC_code='5411'DB:business_master_new
loadtime:1.2234899997711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernando' limit 1
loadtime:1.2235598564148 / seconds
Query Executed:select id FROM `ms` where city='Hernando' && SIC_code='5411'DB:business_master_new
loadtime:1.2340779304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:1.2341759204865 / seconds
Query Executed:select id FROM `ms` where city='Hickory' && SIC_code='5411'DB:business_master_new
loadtime:1.2350039482117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Flat' limit 1
loadtime:1.2350618839264 / seconds
Query Executed:select id FROM `ms` where city='Hickory Flat' && SIC_code='5411'DB:business_master_new
loadtime:1.2358410358429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.2359089851379 / seconds
Query Executed:select id FROM `ms` where city='Hillsboro' && SIC_code='5411'DB:business_master_new
loadtime:1.2363309860229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcomb' limit 1
loadtime:1.236387014389 / seconds
Query Executed:select id FROM `ms` where city='Holcomb' && SIC_code='5411'DB:business_master_new
loadtime:1.2371430397034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:1.2372109889984 / seconds
Query Executed:select id FROM `ms` where city='Hollandale' && SIC_code='5411'DB:business_master_new
loadtime:1.2394020557404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Bluff' limit 1
loadtime:1.2394778728485 / seconds
Query Executed:select id FROM `ms` where city='Holly Bluff' && SIC_code='5411'DB:business_master_new
loadtime:1.2402448654175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:1.2403149604797 / seconds
Query Executed:select id FROM `ms` where city='Holly Ridge' && SIC_code='5411'DB:business_master_new
loadtime:1.2407448291779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:1.2408149242401 / seconds
Query Executed:select id FROM `ms` where city='Holly Springs' && SIC_code='5411'DB:business_master_new
loadtime:1.2497529983521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horn Lake' limit 1
loadtime:1.2498569488525 / seconds
Query Executed:select id FROM `ms` where city='Horn Lake' && SIC_code='5411'DB:business_master_new
loadtime:1.2576909065247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlka' limit 1
loadtime:1.2577879428864 / seconds
Query Executed:select id FROM `ms` where city='Houlka' && SIC_code='5411'DB:business_master_new
loadtime:1.2592170238495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houston' limit 1
loadtime:1.2592949867249 / seconds
Query Executed:select id FROM `ms` where city='Houston' && SIC_code='5411'DB:business_master_new
loadtime:1.267205953598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:1.2673020362854 / seconds
Query Executed:select id FROM `ms` where city='Hurley' && SIC_code='5411'DB:business_master_new
loadtime:1.2683470249176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:1.2684240341187 / seconds
Query Executed:select id FROM `ms` where city='Independence' && SIC_code='5411'DB:business_master_new
loadtime:1.2690010070801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:1.2690558433533 / seconds
Query Executed:select id FROM `ms` where city='Indianola' && SIC_code='5411'DB:business_master_new
loadtime:1.2783460617065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inverness' limit 1
loadtime:1.2784440517426 / seconds
Query Executed:select id FROM `ms` where city='Inverness' && SIC_code='5411'DB:business_master_new
loadtime:1.2797420024872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isola' limit 1
loadtime:1.2798209190369 / seconds
Query Executed:select id FROM `ms` where city='Isola' && SIC_code='5411'DB:business_master_new
loadtime:1.2809219360352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Itta Bena' limit 1
loadtime:1.2810029983521 / seconds
Query Executed:select id FROM `ms` where city='Itta Bena' && SIC_code='5411'DB:business_master_new
loadtime:1.2824640274048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iuka' limit 1
loadtime:1.2825388908386 / seconds
Query Executed:select id FROM `ms` where city='Iuka' && SIC_code='5411'DB:business_master_new
loadtime:1.2896299362183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.2897100448608 / seconds
Query Executed:select id FROM `ms` where city='Jackson' && SIC_code='5411'DB:business_master_new
loadtime:1.3253419399261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jayess' limit 1
loadtime:1.3257188796997 / seconds
Query Executed:select id FROM `ms` where city='Jayess' && SIC_code='5411'DB:business_master_new
loadtime:1.3269100189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonestown' limit 1
loadtime:1.3270418643951 / seconds
Query Executed:select id FROM `ms` where city='Jonestown' && SIC_code='5411'DB:business_master_new
loadtime:1.3277778625488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keesler Afb' limit 1
loadtime:1.3278589248657 / seconds
Query Executed:select id FROM `ms` where city='Keesler Afb' && SIC_code='5411'DB:business_master_new
loadtime:1.3284740447998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmichael' limit 1
loadtime:1.3285369873047 / seconds
Query Executed:select id FROM `ms` where city='Kilmichael' && SIC_code='5411'DB:business_master_new
loadtime:1.3294990062714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiln' limit 1
loadtime:1.3295798301697 / seconds
Query Executed:select id FROM `ms` where city='Kiln' && SIC_code='5411'DB:business_master_new
loadtime:1.3605558872223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kokomo' limit 1
loadtime:1.3606598377228 / seconds
Query Executed:select id FROM `ms` where city='Kokomo' && SIC_code='5411'DB:business_master_new
loadtime:1.3613710403442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kosciusko' limit 1
loadtime:1.3614499568939 / seconds
Query Executed:select id FROM `ms` where city='Kosciusko' && SIC_code='5411'DB:business_master_new
loadtime:1.3711838722229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kossuth' limit 1
loadtime:1.3712990283966 / seconds
Query Executed:select id FROM `ms` where city='Kossuth' && SIC_code='5411'DB:business_master_new
loadtime:1.3717188835144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kreole' limit 1
loadtime:1.3717868328094 / seconds
Query Executed:select id FROM `ms` where city='Kreole' && SIC_code='5411'DB:business_master_new
loadtime:1.3722219467163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:1.3722839355469 / seconds
Query Executed:select id FROM `ms` where city='Lake' && SIC_code='5411'DB:business_master_new
loadtime:1.373379945755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Cormorant' limit 1
loadtime:1.3734579086304 / seconds
Query Executed:select id FROM `ms` where city='Lake Cormorant' && SIC_code='5411'DB:business_master_new
loadtime:1.3743858337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeshore' limit 1
loadtime:1.3744609355927 / seconds
Query Executed:select id FROM `ms` where city='Lakeshore' && SIC_code='5411'DB:business_master_new
loadtime:1.3750450611115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:1.3751208782196 / seconds
Query Executed:select id FROM `ms` where city='Lamar' && SIC_code='5411'DB:business_master_new
loadtime:1.3757598400116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambert' limit 1
loadtime:1.3758409023285 / seconds
Query Executed:select id FROM `ms` where city='Lambert' && SIC_code='5411'DB:business_master_new
loadtime:1.3767828941345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lauderdale' limit 1
loadtime:1.3768620491028 / seconds
Query Executed:select id FROM `ms` where city='Lauderdale' && SIC_code='5411'DB:business_master_new
loadtime:1.3777618408203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:1.3778488636017 / seconds
Query Executed:select id FROM `ms` where city='Laurel' && SIC_code='5411'DB:business_master_new
loadtime:1.4005589485168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:1.4007189273834 / seconds
Query Executed:select id FROM `ms` where city='Lawrence' && SIC_code='5411'DB:business_master_new
loadtime:1.4013609886169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leakesville' limit 1
loadtime:1.4014248847961 / seconds
Query Executed:select id FROM `ms` where city='Leakesville' && SIC_code='5411'DB:business_master_new
loadtime:1.432226896286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Learned' limit 1
loadtime:1.4323089122772 / seconds
Query Executed:select id FROM `ms` where city='Learned' && SIC_code='5411'DB:business_master_new
loadtime:1.4326999187469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:1.4327549934387 / seconds
Query Executed:select id FROM `ms` where city='Leland' && SIC_code='5411'DB:business_master_new
loadtime:1.4389100074768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:1.4390008449554 / seconds
Query Executed:select id FROM `ms` where city='Lena' && SIC_code='5411'DB:business_master_new
loadtime:1.4398410320282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.439915895462 / seconds
Query Executed:select id FROM `ms` where city='Lexington' && SIC_code='5411'DB:business_master_new
loadtime:1.4702219963074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:1.4703078269958 / seconds
Query Executed:select id FROM `ms` where city='Liberty' && SIC_code='5411'DB:business_master_new
loadtime:1.4729020595551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:1.4729928970337 / seconds
Query Executed:select id FROM `ms` where city='Little Rock' && SIC_code='5411'DB:business_master_new
loadtime:1.4736149311066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:1.473680973053 / seconds
Query Executed:select id FROM `ms` where city='Long Beach' && SIC_code='5411'DB:business_master_new
loadtime:1.4835460186005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorman' limit 1
loadtime:1.4836268424988 / seconds
Query Executed:select id FROM `ms` where city='Lorman' && SIC_code='5411'DB:business_master_new
loadtime:1.4843208789825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louin' limit 1
loadtime:1.4843888282776 / seconds
Query Executed:select id FROM `ms` where city='Louin' && SIC_code='5411'DB:business_master_new
loadtime:1.485151052475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louise' limit 1
loadtime:1.4852230548859 / seconds
Query Executed:select id FROM `ms` where city='Louise' && SIC_code='5411'DB:business_master_new
loadtime:1.4860370159149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:1.48610496521 / seconds
Query Executed:select id FROM `ms` where city='Louisville' && SIC_code='5411'DB:business_master_new
loadtime:1.4958670139313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucedale' limit 1
loadtime:1.4959769248962 / seconds
Query Executed:select id FROM `ms` where city='Lucedale' && SIC_code='5411'DB:business_master_new
loadtime:1.5064070224762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:1.506520986557 / seconds
Query Executed:select id FROM `ms` where city='Ludlow' && SIC_code='5411'DB:business_master_new
loadtime:1.5070459842682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lula' limit 1
loadtime:1.5071039199829 / seconds
Query Executed:select id FROM `ms` where city='Lula' && SIC_code='5411'DB:business_master_new
loadtime:1.5077810287476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.5078518390656 / seconds
Query Executed:select id FROM `ms` where city='Lumberton' && SIC_code='5411'DB:business_master_new
loadtime:1.5387878417969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyon' limit 1
loadtime:1.5388660430908 / seconds
Query Executed:select id FROM `ms` where city='Lyon' && SIC_code='5411'DB:business_master_new
loadtime:1.5396649837494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maben' limit 1
loadtime:1.5397200584412 / seconds
Query Executed:select id FROM `ms` where city='Maben' && SIC_code='5411'DB:business_master_new
loadtime:1.5409319400787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:1.5409989356995 / seconds
Query Executed:select id FROM `ms` where city='Macon' && SIC_code='5411'DB:business_master_new
loadtime:1.5713248252869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madden' limit 1
loadtime:1.5714068412781 / seconds
Query Executed:select id FROM `ms` where city='Madden' && SIC_code='5411'DB:business_master_new
loadtime:1.5719180107117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.5719828605652 / seconds
Query Executed:select id FROM `ms` where city='Madison' && SIC_code='5411'DB:business_master_new
loadtime:1.5858209133148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magee' limit 1
loadtime:1.585902929306 / seconds
Query Executed:select id FROM `ms` where city='Magee' && SIC_code='5411'DB:business_master_new
loadtime:1.5938849449158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:1.5939919948578 / seconds
Query Executed:select id FROM `ms` where city='Magnolia' && SIC_code='5411'DB:business_master_new
loadtime:1.6245419979095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantachie' limit 1
loadtime:1.6246328353882 / seconds
Query Executed:select id FROM `ms` where city='Mantachie' && SIC_code='5411'DB:business_master_new
loadtime:1.6545059680939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantee' limit 1
loadtime:1.6545829772949 / seconds
Query Executed:select id FROM `ms` where city='Mantee' && SIC_code='5411'DB:business_master_new
loadtime:1.6552448272705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:1.6553139686584 / seconds
Query Executed:select id FROM `ms` where city='Marietta' && SIC_code='5411'DB:business_master_new
loadtime:1.656112909317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.6562049388885 / seconds
Query Executed:select id FROM `ms` where city='Marion' && SIC_code='5411'DB:business_master_new
loadtime:1.6571438312531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marks' limit 1
loadtime:1.6572198867798 / seconds
Query Executed:select id FROM `ms` where city='Marks' && SIC_code='5411'DB:business_master_new
loadtime:1.6872620582581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathiston' limit 1
loadtime:1.6873998641968 / seconds
Query Executed:select id FROM `ms` where city='Mathiston' && SIC_code='5411'DB:business_master_new
loadtime:1.6885149478912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattson' limit 1
loadtime:1.6886279582977 / seconds
Query Executed:select id FROM `ms` where city='Mattson' && SIC_code='5411'DB:business_master_new
loadtime:1.6890988349915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayersville' limit 1
loadtime:1.6891798973083 / seconds
Query Executed:select id FROM `ms` where city='Mayersville' && SIC_code='5411'DB:business_master_new
loadtime:1.6899478435516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhew' limit 1
loadtime:1.6900458335876 / seconds
Query Executed:select id FROM `ms` where city='Mayhew' && SIC_code='5411'DB:business_master_new
loadtime:1.6905429363251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adams' limit 1
loadtime:1.6906208992004 / seconds
Query Executed:select id FROM `ms` where city='Mc Adams' && SIC_code='5411'DB:business_master_new
loadtime:1.6910810470581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Call Creek' limit 1
loadtime:1.6911809444427 / seconds
Query Executed:select id FROM `ms` where city='Mc Call Creek' && SIC_code='5411'DB:business_master_new
loadtime:1.6917979717255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Carley' limit 1
loadtime:1.6919028759003 / seconds
Query Executed:select id FROM `ms` where city='Mc Carley' && SIC_code='5411'DB:business_master_new
loadtime:1.6923558712006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Comb' limit 1
loadtime:1.6924359798431 / seconds
Query Executed:select id FROM `ms` where city='Mc Comb' && SIC_code='5411'DB:business_master_new
loadtime:1.6930890083313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cool' limit 1
loadtime:1.693186044693 / seconds
Query Executed:select id FROM `ms` where city='Mc Cool' && SIC_code='5411'DB:business_master_new
loadtime:1.693874835968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Henry' limit 1
loadtime:1.6939899921417 / seconds
Query Executed:select id FROM `ms` where city='Mc Henry' && SIC_code='5411'DB:business_master_new
loadtime:1.6946768760681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lain' limit 1
loadtime:1.694776058197 / seconds
Query Executed:select id FROM `ms` where city='Mc Lain' && SIC_code='5411'DB:business_master_new
loadtime:1.6955528259277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neill' limit 1
loadtime:1.6956539154053 / seconds
Query Executed:select id FROM `ms` where city='Mc Neill' && SIC_code='5411'DB:business_master_new
loadtime:1.6962878704071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccomb' limit 1
loadtime:1.6963880062103 / seconds
Query Executed:select id FROM `ms` where city='Mccomb' && SIC_code='5411'DB:business_master_new
loadtime:1.7135310173035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadville' limit 1
loadtime:1.7137470245361 / seconds
Query Executed:select id FROM `ms` where city='Meadville' && SIC_code='5411'DB:business_master_new
loadtime:1.7443919181824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendenhall' limit 1
loadtime:1.7445199489594 / seconds
Query Executed:select id FROM `ms` where city='Mendenhall' && SIC_code='5411'DB:business_master_new
loadtime:1.7748680114746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meridian' limit 1
loadtime:1.7750039100647 / seconds
Query Executed:select id FROM `ms` where city='Meridian' && SIC_code='5411'DB:business_master_new
loadtime:1.8107318878174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merigold' limit 1
loadtime:1.8110709190369 / seconds
Query Executed:select id FROM `ms` where city='Merigold' && SIC_code='5411'DB:business_master_new
loadtime:1.8120398521423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metcalfe' limit 1
loadtime:1.812155008316 / seconds
Query Executed:select id FROM `ms` where city='Metcalfe' && SIC_code='5411'DB:business_master_new
loadtime:1.8127248287201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan City' limit 1
loadtime:1.8128278255463 / seconds
Query Executed:select id FROM `ms` where city='Michigan City' && SIC_code='5411'DB:business_master_new
loadtime:1.8133308887482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midnight' limit 1
loadtime:1.8134269714355 / seconds
Query Executed:select id FROM `ms` where city='Midnight' && SIC_code='5411'DB:business_master_new
loadtime:1.8138689994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Wells' limit 1
loadtime:1.8139770030975 / seconds
Query Executed:select id FROM `ms` where city='Mineral Wells' && SIC_code='5411'DB:business_master_new
loadtime:1.8143720626831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minter City' limit 1
loadtime:1.8144478797913 / seconds
Query Executed:select id FROM `ms` where city='Minter City' && SIC_code='5411'DB:business_master_new
loadtime:1.8150708675385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miss State' limit 1
loadtime:1.8151760101318 / seconds
Query Executed:select id FROM `ms` where city='Miss State' && SIC_code='5411'DB:business_master_new
loadtime:1.8155610561371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mississippi State' limit 1
loadtime:1.8156399726868 / seconds
Query Executed:select id FROM `ms` where city='Mississippi State' && SIC_code='5411'DB:business_master_new
loadtime:1.8175790309906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mize' limit 1
loadtime:1.817656993866 / seconds
Query Executed:select id FROM `ms` where city='Mize' && SIC_code='5411'DB:business_master_new
loadtime:1.8186948299408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Money' limit 1
loadtime:1.8187999725342 / seconds
Query Executed:select id FROM `ms` where city='Money' && SIC_code='5411'DB:business_master_new
loadtime:1.8192009925842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:1.8192820549011 / seconds
Query Executed:select id FROM `ms` where city='Monticello' && SIC_code='5411'DB:business_master_new
loadtime:1.8251218795776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:1.8252508640289 / seconds
Query Executed:select id FROM `ms` where city='Montpelier' && SIC_code='5411'DB:business_master_new
loadtime:1.8256750106812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooreville' limit 1
loadtime:1.8257570266724 / seconds
Query Executed:select id FROM `ms` where city='Mooreville' && SIC_code='5411'DB:business_master_new
loadtime:1.826719045639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:1.8268358707428 / seconds
Query Executed:select id FROM `ms` where city='Moorhead' && SIC_code='5411'DB:business_master_new
loadtime:1.8278698921204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan City' limit 1
loadtime:1.8279888629913 / seconds
Query Executed:select id FROM `ms` where city='Morgan City' && SIC_code='5411'DB:business_master_new
loadtime:1.8285279273987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morton' limit 1
loadtime:1.8286049365997 / seconds
Query Executed:select id FROM `ms` where city='Morton' && SIC_code='5411'DB:business_master_new
loadtime:1.860053062439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moselle' limit 1
loadtime:1.8601648807526 / seconds
Query Executed:select id FROM `ms` where city='Moselle' && SIC_code='5411'DB:business_master_new
loadtime:1.861212015152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss' limit 1
loadtime:1.8613128662109 / seconds
Query Executed:select id FROM `ms` where city='Moss' && SIC_code='5411'DB:business_master_new
loadtime:1.8617739677429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss Point' limit 1
loadtime:1.8618519306183 / seconds
Query Executed:select id FROM `ms` where city='Moss Point' && SIC_code='5411'DB:business_master_new
loadtime:1.8726758956909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound Bayou' limit 1
loadtime:1.8728399276733 / seconds
Query Executed:select id FROM `ms` where city='Mound Bayou' && SIC_code='5411'DB:business_master_new
loadtime:1.8742709159851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:1.8743929862976 / seconds
Query Executed:select id FROM `ms` where city='Mount Olive' && SIC_code='5411'DB:business_master_new
loadtime:1.8760759830475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:1.8761949539185 / seconds
Query Executed:select id FROM `ms` where city='Mount Pleasant' && SIC_code='5411'DB:business_master_new
loadtime:1.8766808509827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:1.8767809867859 / seconds
Query Executed:select id FROM `ms` where city='Mt Olive' && SIC_code='5411'DB:business_master_new
loadtime:1.8771889209747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:1.8772690296173 / seconds
Query Executed:select id FROM `ms` where city='Mt Pleasant' && SIC_code='5411'DB:business_master_new
loadtime:1.8776519298553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle' limit 1
loadtime:1.8777289390564 / seconds
Query Executed:select id FROM `ms` where city='Myrtle' && SIC_code='5411'DB:business_master_new
loadtime:1.8788878917694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nas Meridian' limit 1
loadtime:1.8790090084076 / seconds
Query Executed:select id FROM `ms` where city='Nas Meridian' && SIC_code='5411'DB:business_master_new
loadtime:1.8794379234314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natchez' limit 1
loadtime:1.8795168399811 / seconds
Query Executed:select id FROM `ms` where city='Natchez' && SIC_code='5411'DB:business_master_new
loadtime:1.9023220539093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neely' limit 1
loadtime:1.9025540351868 / seconds
Query Executed:select id FROM `ms` where city='Neely' && SIC_code='5411'DB:business_master_new
loadtime:1.9031188488007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesbit' limit 1
loadtime:1.9032299518585 / seconds
Query Executed:select id FROM `ms` where city='Nesbit' && SIC_code='5411'DB:business_master_new
loadtime:1.934298992157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nettleton' limit 1
loadtime:1.9343829154968 / seconds
Query Executed:select id FROM `ms` where city='Nettleton' && SIC_code='5411'DB:business_master_new
loadtime:1.9643499851227 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albany' limit 1
loadtime:1.9645130634308 / seconds
Query Executed:select id FROM `ms` where city='New Albany' && SIC_code='5411'DB:business_master_new
loadtime:1.9756188392639 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Augusta' limit 1
loadtime:1.9757289886475 / seconds
Query Executed:select id FROM `ms` where city='New Augusta' && SIC_code='5411'DB:business_master_new
loadtime:1.9771039485931 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Site' limit 1
loadtime:1.9771778583527 / seconds
Query Executed:select id FROM `ms` where city='New Site' && SIC_code='5411'DB:business_master_new
loadtime:1.9777638912201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhebron' limit 1
loadtime:1.9778189659119 / seconds
Query Executed:select id FROM `ms` where city='Newhebron' && SIC_code='5411'DB:business_master_new
loadtime:1.9790380001068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.9791119098663 / seconds
Query Executed:select id FROM `ms` where city='Newton' && SIC_code='5411'DB:business_master_new
loadtime:1.9847829341888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nicholson' limit 1
loadtime:1.9848749637604 / seconds
Query Executed:select id FROM `ms` where city='Nicholson' && SIC_code='5411'DB:business_master_new
loadtime:1.9854390621185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nitta Yuma' limit 1
loadtime:1.9855060577393 / seconds
Query Executed:select id FROM `ms` where city='Nitta Yuma' && SIC_code='5411'DB:business_master_new
loadtime:1.9858829975128 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carrollton' limit 1
loadtime:1.985937833786 / seconds
Query Executed:select id FROM `ms` where city='North Carrollton' && SIC_code='5411'DB:business_master_new
loadtime:1.986634016037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Noxapater' limit 1
loadtime:1.9867010116577 / seconds
Query Executed:select id FROM `ms` where city='Noxapater' && SIC_code='5411'DB:business_master_new
loadtime:1.9877328872681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Vale' limit 1
loadtime:1.9878029823303 / seconds
Query Executed:select id FROM `ms` where city='Oak Vale' && SIC_code='5411'DB:business_master_new
loadtime:1.9883680343628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:1.9884538650513 / seconds
Query Executed:select id FROM `ms` where city='Oakland' && SIC_code='5411'DB:business_master_new
loadtime:1.9894909858704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Springs' limit 1
loadtime:1.9895629882812 / seconds
Query Executed:select id FROM `ms` where city='Ocean Springs' && SIC_code='5411'DB:business_master_new
loadtime:2.005961894989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okolona' limit 1
loadtime:2.0060749053955 / seconds
Query Executed:select id FROM `ms` where city='Okolona' && SIC_code='5411'DB:business_master_new
loadtime:2.0114948749542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olive Branch' limit 1
loadtime:2.0115869045258 / seconds
Query Executed:select id FROM `ms` where city='Olive Branch' && SIC_code='5411'DB:business_master_new
loadtime:2.0276548862457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osyka' limit 1
loadtime:2.0277600288391 / seconds
Query Executed:select id FROM `ms` where city='Osyka' && SIC_code='5411'DB:business_master_new
loadtime:2.0289649963379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovett' limit 1
loadtime:2.0290410518646 / seconds
Query Executed:select id FROM `ms` where city='Ovett' && SIC_code='5411'DB:business_master_new
loadtime:2.0297739505768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.0298399925232 / seconds
Query Executed:select id FROM `ms` where city='Oxford' && SIC_code='5411'DB:business_master_new
loadtime:2.0475158691406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pace' limit 1
loadtime:2.0476288795471 / seconds
Query Executed:select id FROM `ms` where city='Pace' && SIC_code='5411'DB:business_master_new
loadtime:2.048192024231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pachuta' limit 1
loadtime:2.048262834549 / seconds
Query Executed:select id FROM `ms` where city='Pachuta' && SIC_code='5411'DB:business_master_new
loadtime:2.0489418506622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panther Burn' limit 1
loadtime:2.0490138530731 / seconds
Query Executed:select id FROM `ms` where city='Panther Burn' && SIC_code='5411'DB:business_master_new
loadtime:2.0493969917297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchman' limit 1
loadtime:2.0494518280029 / seconds
Query Executed:select id FROM `ms` where city='Parchman' && SIC_code='5411'DB:business_master_new
loadtime:2.0498640537262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:2.0499179363251 / seconds
Query Executed:select id FROM `ms` where city='Paris' && SIC_code='5411'DB:business_master_new
loadtime:2.05029296875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pascagoula' limit 1
loadtime:2.0503449440002 / seconds
Query Executed:select id FROM `ms` where city='Pascagoula' && SIC_code='5411'DB:business_master_new
loadtime:2.067666053772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pass Christian' limit 1
loadtime:2.0677700042725 / seconds
Query Executed:select id FROM `ms` where city='Pass Christian' && SIC_code='5411'DB:business_master_new
loadtime:2.0847589969635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pattison' limit 1
loadtime:2.0848679542542 / seconds
Query Executed:select id FROM `ms` where city='Pattison' && SIC_code='5411'DB:business_master_new
loadtime:2.0854549407959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulding' limit 1
loadtime:2.0855250358582 / seconds
Query Executed:select id FROM `ms` where city='Paulding' && SIC_code='5411'DB:business_master_new
loadtime:2.0859730243683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl' limit 1
loadtime:2.0860319137573 / seconds
Query Executed:select id FROM `ms` where city='Pearl' && SIC_code='5411'DB:business_master_new
loadtime:2.1016340255737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearlington' limit 1
loadtime:2.1017320156097 / seconds
Query Executed:select id FROM `ms` where city='Pearlington' && SIC_code='5411'DB:business_master_new
loadtime:2.1026158332825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelahatchie' limit 1
loadtime:2.1026849746704 / seconds
Query Executed:select id FROM `ms` where city='Pelahatchie' && SIC_code='5411'DB:business_master_new
loadtime:2.134330034256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinston' limit 1
loadtime:2.1344308853149 / seconds
Query Executed:select id FROM `ms` where city='Perkinston' && SIC_code='5411'DB:business_master_new
loadtime:2.1359519958496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petal' limit 1
loadtime:2.136029958725 / seconds
Query Executed:select id FROM `ms` where city='Petal' && SIC_code='5411'DB:business_master_new
loadtime:2.1448109149933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pheba' limit 1
loadtime:2.1449120044708 / seconds
Query Executed:select id FROM `ms` where city='Pheba' && SIC_code='5411'DB:business_master_new
loadtime:2.145544052124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philadelphia' limit 1
loadtime:2.145614862442 / seconds
Query Executed:select id FROM `ms` where city='Philadelphia' && SIC_code='5411'DB:business_master_new
loadtime:2.1575980186462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philipp' limit 1
loadtime:2.1577169895172 / seconds
Query Executed:select id FROM `ms` where city='Philipp' && SIC_code='5411'DB:business_master_new
loadtime:2.1582460403442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picayune' limit 1
loadtime:2.158303976059 / seconds
Query Executed:select id FROM `ms` where city='Picayune' && SIC_code='5411'DB:business_master_new
loadtime:2.1728708744049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:2.1729769706726 / seconds
Query Executed:select id FROM `ms` where city='Pickens' && SIC_code='5411'DB:business_master_new
loadtime:2.1740629673004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Woods' limit 1
loadtime:2.1741368770599 / seconds
Query Executed:select id FROM `ms` where city='Piney Woods' && SIC_code='5411'DB:business_master_new
loadtime:2.1745209693909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinola' limit 1
loadtime:2.1745738983154 / seconds
Query Executed:select id FROM `ms` where city='Pinola' && SIC_code='5411'DB:business_master_new
loadtime:2.1752450466156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:2.1753120422363 / seconds
Query Executed:select id FROM `ms` where city='Pittsboro' && SIC_code='5411'DB:business_master_new
loadtime:2.1761360168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantersville' limit 1
loadtime:2.1761908531189 / seconds
Query Executed:select id FROM `ms` where city='Plantersville' && SIC_code='5411'DB:business_master_new
loadtime:2.1771838665009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:2.1772549152374 / seconds
Query Executed:select id FROM `ms` where city='Pocahontas' && SIC_code='5411'DB:business_master_new
loadtime:2.1775898933411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontotoc' limit 1
loadtime:2.1776430606842 / seconds
Query Executed:select id FROM `ms` where city='Pontotoc' && SIC_code='5411'DB:business_master_new
loadtime:2.1883819103241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope' limit 1
loadtime:2.1884870529175 / seconds
Query Executed:select id FROM `ms` where city='Pope' && SIC_code='5411'DB:business_master_new
loadtime:2.1891648769379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplarville' limit 1
loadtime:2.1892399787903 / seconds
Query Executed:select id FROM `ms` where city='Poplarville' && SIC_code='5411'DB:business_master_new
loadtime:2.1965420246124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Gibson' limit 1
loadtime:2.1966290473938 / seconds
Query Executed:select id FROM `ms` where city='Port Gibson' && SIC_code='5411'DB:business_master_new
loadtime:2.2281918525696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterville' limit 1
loadtime:2.2282919883728 / seconds
Query Executed:select id FROM `ms` where city='Porterville' && SIC_code='5411'DB:business_master_new
loadtime:2.2287859916687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potts Camp' limit 1
loadtime:2.2288398742676 / seconds
Query Executed:select id FROM `ms` where city='Potts Camp' && SIC_code='5411'DB:business_master_new
loadtime:2.2299468517303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie' limit 1
loadtime:2.2300260066986 / seconds
Query Executed:select id FROM `ms` where city='Prairie' && SIC_code='5411'DB:business_master_new
loadtime:2.2307159900665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentiss' limit 1
loadtime:2.2307839393616 / seconds
Query Executed:select id FROM `ms` where city='Prentiss' && SIC_code='5411'DB:business_master_new
loadtime:2.2610518932343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:2.2611439228058 / seconds
Query Executed:select id FROM `ms` where city='Preston' && SIC_code='5411'DB:business_master_new
loadtime:2.2618598937988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puckett' limit 1
loadtime:2.2619299888611 / seconds
Query Executed:select id FROM `ms` where city='Puckett' && SIC_code='5411'DB:business_master_new
loadtime:2.2625360488892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:2.2626039981842 / seconds
Query Executed:select id FROM `ms` where city='Pulaski' && SIC_code='5411'DB:business_master_new
loadtime:2.2631349563599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purvis' limit 1
loadtime:2.2632019519806 / seconds
Query Executed:select id FROM `ms` where city='Purvis' && SIC_code='5411'DB:business_master_new
loadtime:2.2932980060577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quitman' limit 1
loadtime:2.2933838367462 / seconds
Query Executed:select id FROM `ms` where city='Quitman' && SIC_code='5411'DB:business_master_new
loadtime:2.323511838913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:2.3236088752747 / seconds
Query Executed:select id FROM `ms` where city='Raleigh' && SIC_code='5411'DB:business_master_new
loadtime:2.3257420063019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:2.3258149623871 / seconds
Query Executed:select id FROM `ms` where city='Randolph' && SIC_code='5411'DB:business_master_new
loadtime:2.3264150619507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:2.32648396492 / seconds
Query Executed:select id FROM `ms` where city='Raymond' && SIC_code='5411'DB:business_master_new
loadtime:2.3324348926544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Banks' limit 1
loadtime:2.332515001297 / seconds
Query Executed:select id FROM `ms` where city='Red Banks' && SIC_code='5411'DB:business_master_new
loadtime:2.3332149982452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:2.3332698345184 / seconds
Query Executed:select id FROM `ms` where city='Redwood' && SIC_code='5411'DB:business_master_new
loadtime:2.3338129520416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rena Lara' limit 1
loadtime:2.3338868618011 / seconds
Query Executed:select id FROM `ms` where city='Rena Lara' && SIC_code='5411'DB:business_master_new
loadtime:2.3343918323517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:2.3344449996948 / seconds
Query Executed:select id FROM `ms` where city='Richland' && SIC_code='5411'DB:business_master_new
loadtime:2.3417799472809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richton' limit 1
loadtime:2.3418719768524 / seconds
Query Executed:select id FROM `ms` where city='Richton' && SIC_code='5411'DB:business_master_new
loadtime:2.3724129199982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:2.372505903244 / seconds
Query Executed:select id FROM `ms` where city='Ridgeland' && SIC_code='5411'DB:business_master_new
loadtime:2.3930349349976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rienzi' limit 1
loadtime:2.3931448459625 / seconds
Query Executed:select id FROM `ms` where city='Rienzi' && SIC_code='5411'DB:business_master_new
loadtime:2.3943898677826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripley' limit 1
loadtime:2.3944659233093 / seconds
Query Executed:select id FROM `ms` where city='Ripley' && SIC_code='5411'DB:business_master_new
loadtime:2.4030718803406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robinsonville' limit 1
loadtime:2.4031610488892 / seconds
Query Executed:select id FROM `ms` where city='Robinsonville' && SIC_code='5411'DB:business_master_new
loadtime:2.4342360496521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolling Fork' limit 1
loadtime:2.4343199729919 / seconds
Query Executed:select id FROM `ms` where city='Rolling Fork' && SIC_code='5411'DB:business_master_new
loadtime:2.4642848968506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:2.4643700122833 / seconds
Query Executed:select id FROM `ms` where city='Rome' && SIC_code='5411'DB:business_master_new
loadtime:2.4648170471191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:2.4648809432983 / seconds
Query Executed:select id FROM `ms` where city='Rose Hill' && SIC_code='5411'DB:business_master_new
loadtime:2.4654920101166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:2.4655590057373 / seconds
Query Executed:select id FROM `ms` where city='Rosedale' && SIC_code='5411'DB:business_master_new
loadtime:2.4669940471649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxie' limit 1
loadtime:2.4670770168304 / seconds
Query Executed:select id FROM `ms` where city='Roxie' && SIC_code='5411'DB:business_master_new
loadtime:2.467875957489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruleville' limit 1
loadtime:2.4679439067841 / seconds
Query Executed:select id FROM `ms` where city='Ruleville' && SIC_code='5411'DB:business_master_new
loadtime:2.4697370529175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:2.4698140621185 / seconds
Query Executed:select id FROM `ms` where city='Ruth' && SIC_code='5411'DB:business_master_new
loadtime:2.4704730510712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sallis' limit 1
loadtime:2.4705419540405 / seconds
Query Executed:select id FROM `ms` where city='Sallis' && SIC_code='5411'DB:business_master_new
loadtime:2.4712378978729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltillo' limit 1
loadtime:2.4713070392609 / seconds
Query Executed:select id FROM `ms` where city='Saltillo' && SIC_code='5411'DB:business_master_new
loadtime:2.5017640590668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanatorium' limit 1
loadtime:2.5019390583038 / seconds
Query Executed:select id FROM `ms` where city='Sanatorium' && SIC_code='5411'DB:business_master_new
loadtime:2.502406835556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandersville' limit 1
loadtime:2.5024650096893 / seconds
Query Executed:select id FROM `ms` where city='Sandersville' && SIC_code='5411'DB:business_master_new
loadtime:2.5032889842987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandhill' limit 1
loadtime:2.5033578872681 / seconds
Query Executed:select id FROM `ms` where city='Sandhill' && SIC_code='5411'DB:business_master_new
loadtime:2.50377202034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:2.5038259029388 / seconds
Query Executed:select id FROM `ms` where city='Sandy Hook' && SIC_code='5411'DB:business_master_new
loadtime:2.504606962204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanitorium' limit 1
loadtime:2.5046758651733 / seconds
Query Executed:select id FROM `ms` where city='Sanitorium' && SIC_code='5411'DB:business_master_new
loadtime:2.5050559043884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarah' limit 1
loadtime:2.5051109790802 / seconds
Query Executed:select id FROM `ms` where city='Sarah' && SIC_code='5411'DB:business_master_new
loadtime:2.5057759284973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardis' limit 1
loadtime:2.5058529376984 / seconds
Query Executed:select id FROM `ms` where city='Sardis' && SIC_code='5411'DB:business_master_new
loadtime:2.5377240180969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satartia' limit 1
loadtime:2.5378370285034 / seconds
Query Executed:select id FROM `ms` where city='Satartia' && SIC_code='5411'DB:business_master_new
loadtime:2.538379907608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saucier' limit 1
loadtime:2.5384478569031 / seconds
Query Executed:select id FROM `ms` where city='Saucier' && SIC_code='5411'DB:business_master_new
loadtime:2.5686478614807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schlater' limit 1
loadtime:2.5687420368195 / seconds
Query Executed:select id FROM `ms` where city='Schlater' && SIC_code='5411'DB:business_master_new
loadtime:2.5694210529327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scobey' limit 1
loadtime:2.5694918632507 / seconds
Query Executed:select id FROM `ms` where city='Scobey' && SIC_code='5411'DB:business_master_new
loadtime:2.5699870586395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scooba' limit 1
loadtime:2.5700590610504 / seconds
Query Executed:select id FROM `ms` where city='Scooba' && SIC_code='5411'DB:business_master_new
loadtime:2.5708119869232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scott' limit 1
loadtime:2.5708858966827 / seconds
Query Executed:select id FROM `ms` where city='Scott' && SIC_code='5411'DB:business_master_new
loadtime:2.5714218616486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebastopol' limit 1
loadtime:2.5714900493622 / seconds
Query Executed:select id FROM `ms` where city='Sebastopol' && SIC_code='5411'DB:business_master_new
loadtime:2.5724020004272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seminary' limit 1
loadtime:2.5724740028381 / seconds
Query Executed:select id FROM `ms` where city='Seminary' && SIC_code='5411'DB:business_master_new
loadtime:2.5742249488831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Senatobia' limit 1
loadtime:2.5743010044098 / seconds
Query Executed:select id FROM `ms` where city='Senatobia' && SIC_code='5411'DB:business_master_new
loadtime:2.5834350585938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:2.5835249423981 / seconds
Query Executed:select id FROM `ms` where city='Shannon' && SIC_code='5411'DB:business_master_new
loadtime:2.5854258537292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:2.5855050086975 / seconds
Query Executed:select id FROM `ms` where city='Sharon' && SIC_code='5411'DB:business_master_new
loadtime:2.5859088897705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw' limit 1
loadtime:2.5859639644623 / seconds
Query Executed:select id FROM `ms` where city='Shaw' && SIC_code='5411'DB:business_master_new
loadtime:2.616180896759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:2.616269826889 / seconds
Query Executed:select id FROM `ms` where city='Shelby' && SIC_code='5411'DB:business_master_new
loadtime:2.6461100578308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherard' limit 1
loadtime:2.6461968421936 / seconds
Query Executed:select id FROM `ms` where city='Sherard' && SIC_code='5411'DB:business_master_new
loadtime:2.6466360092163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:2.6466908454895 / seconds
Query Executed:select id FROM `ms` where city='Sherman' && SIC_code='5411'DB:business_master_new
loadtime:2.6474368572235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shubuta' limit 1
loadtime:2.6475038528442 / seconds
Query Executed:select id FROM `ms` where city='Shubuta' && SIC_code='5411'DB:business_master_new
loadtime:2.6486859321594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shuqualak' limit 1
loadtime:2.6487648487091 / seconds
Query Executed:select id FROM `ms` where city='Shuqualak' && SIC_code='5411'DB:business_master_new
loadtime:2.6495649814606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:2.6496369838715 / seconds
Query Executed:select id FROM `ms` where city='Sibley' && SIC_code='5411'DB:business_master_new
loadtime:2.6500818729401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidon' limit 1
loadtime:2.6501488685608 / seconds
Query Executed:select id FROM `ms` where city='Sidon' && SIC_code='5411'DB:business_master_new
loadtime:2.6506938934326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:2.6507470607758 / seconds
Query Executed:select id FROM `ms` where city='Silver City' && SIC_code='5411'DB:business_master_new
loadtime:2.6512658596039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Creek' limit 1
loadtime:2.6513340473175 / seconds
Query Executed:select id FROM `ms` where city='Silver Creek' && SIC_code='5411'DB:business_master_new
loadtime:2.6522209644318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slate Spring' limit 1
loadtime:2.6522879600525 / seconds
Query Executed:select id FROM `ms` where city='Slate Spring' && SIC_code='5411'DB:business_master_new
loadtime:2.6526730060577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sledge' limit 1
loadtime:2.652724981308 / seconds
Query Executed:select id FROM `ms` where city='Sledge' && SIC_code='5411'DB:business_master_new
loadtime:2.6534600257874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithdale' limit 1
loadtime:2.6535258293152 / seconds
Query Executed:select id FROM `ms` where city='Smithdale' && SIC_code='5411'DB:business_master_new
loadtime:2.654237985611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:2.654305934906 / seconds
Query Executed:select id FROM `ms` where city='Smithville' && SIC_code='5411'DB:business_master_new
loadtime:2.6556580066681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sontag' limit 1
loadtime:2.6557269096375 / seconds
Query Executed:select id FROM `ms` where city='Sontag' && SIC_code='5411'DB:business_master_new
loadtime:2.6562938690186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soso' limit 1
loadtime:2.6563470363617 / seconds
Query Executed:select id FROM `ms` where city='Soso' && SIC_code='5411'DB:business_master_new
loadtime:2.6574399471283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southaven' limit 1
loadtime:2.657516002655 / seconds
Query Executed:select id FROM `ms` where city='Southaven' && SIC_code='5411'DB:business_master_new
loadtime:2.6759269237518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:2.6760399341583 / seconds
Query Executed:select id FROM `ms` where city='Star' && SIC_code='5411'DB:business_master_new
loadtime:2.6765730381012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starkville' limit 1
loadtime:2.6766300201416 / seconds
Query Executed:select id FROM `ms` where city='Starkville' && SIC_code='5411'DB:business_master_new
loadtime:2.6930859088898 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Line' limit 1
loadtime:2.6931939125061 / seconds
Query Executed:select id FROM `ms` where city='State Line' && SIC_code='5411'DB:business_master_new
loadtime:2.6944439411163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steens' limit 1
loadtime:2.6945219039917 / seconds
Query Executed:select id FROM `ms` where city='Steens' && SIC_code='5411'DB:business_master_new
loadtime:2.6955170631409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Space Center' limit 1
loadtime:2.6955878734589 / seconds
Query Executed:select id FROM `ms` where city='Stennis Space Center' && SIC_code='5411'DB:business_master_new
loadtime:2.6961929798126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Spc Ctr' limit 1
loadtime:2.6962468624115 / seconds
Query Executed:select id FROM `ms` where city='Stennis Spc Ctr' && SIC_code='5411'DB:business_master_new
loadtime:2.6966350078583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewart' limit 1
loadtime:2.6966869831085 / seconds
Query Executed:select id FROM `ms` where city='Stewart' && SIC_code='5411'DB:business_master_new
loadtime:2.6971909999847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:2.6972579956055 / seconds
Query Executed:select id FROM `ms` where city='Stoneville' && SIC_code='5411'DB:business_master_new
loadtime:2.6979420185089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:2.6979959011078 / seconds
Query Executed:select id FROM `ms` where city='Stonewall' && SIC_code='5411'DB:business_master_new
loadtime:2.698734998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stringer' limit 1
loadtime:2.6988060474396 / seconds
Query Executed:select id FROM `ms` where city='Stringer' && SIC_code='5411'DB:business_master_new
loadtime:2.7022838592529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:2.7023389339447 / seconds
Query Executed:select id FROM `ms` where city='Sturgis' && SIC_code='5411'DB:business_master_new
loadtime:2.7032759189606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:2.7033450603485 / seconds
Query Executed:select id FROM `ms` where city='Summit' && SIC_code='5411'DB:business_master_new
loadtime:2.7349369525909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:2.7350499629974 / seconds
Query Executed:select id FROM `ms` where city='Sumner' && SIC_code='5411'DB:business_master_new
loadtime:2.7361128330231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumrall' limit 1
loadtime:2.7361860275269 / seconds
Query Executed:select id FROM `ms` where city='Sumrall' && SIC_code='5411'DB:business_master_new
loadtime:2.7660999298096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunflower' limit 1
loadtime:2.7661888599396 / seconds
Query Executed:select id FROM `ms` where city='Sunflower' && SIC_code='5411'DB:business_master_new
loadtime:2.7672040462494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan Lake' limit 1
loadtime:2.7672770023346 / seconds
Query Executed:select id FROM `ms` where city='Swan Lake' && SIC_code='5411'DB:business_master_new
loadtime:2.7676458358765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swiftown' limit 1
loadtime:2.7676990032196 / seconds
Query Executed:select id FROM `ms` where city='Swiftown' && SIC_code='5411'DB:business_master_new
loadtime:2.7680819034576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:2.7681348323822 / seconds
Query Executed:select id FROM `ms` where city='Taylor' && SIC_code='5411'DB:business_master_new
loadtime:2.7686269283295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:2.768679857254 / seconds
Query Executed:select id FROM `ms` where city='Taylorsville' && SIC_code='5411'DB:business_master_new
loadtime:2.770751953125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tchula' limit 1
loadtime:2.7708308696747 / seconds
Query Executed:select id FROM `ms` where city='Tchula' && SIC_code='5411'DB:business_master_new
loadtime:2.77210688591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terry' limit 1
loadtime:2.7721810340881 / seconds
Query Executed:select id FROM `ms` where city='Terry' && SIC_code='5411'DB:business_master_new
loadtime:2.8022408485413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:2.802325963974 / seconds
Query Executed:select id FROM `ms` where city='Thaxton' && SIC_code='5411'DB:business_master_new
loadtime:2.8029289245605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomastown' limit 1
loadtime:2.8029959201813 / seconds
Query Executed:select id FROM `ms` where city='Thomastown' && SIC_code='5411'DB:business_master_new
loadtime:2.8034069538116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tie Plant' limit 1
loadtime:2.8034729957581 / seconds
Query Executed:select id FROM `ms` where city='Tie Plant' && SIC_code='5411'DB:business_master_new
loadtime:2.8038568496704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillatoba' limit 1
loadtime:2.8039109706879 / seconds
Query Executed:select id FROM `ms` where city='Tillatoba' && SIC_code='5411'DB:business_master_new
loadtime:2.8044219017029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinsley' limit 1
loadtime:2.8044879436493 / seconds
Query Executed:select id FROM `ms` where city='Tinsley' && SIC_code='5411'DB:business_master_new
loadtime:2.8049130439758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiplersville' limit 1
loadtime:2.8049659729004 / seconds
Query Executed:select id FROM `ms` where city='Tiplersville' && SIC_code='5411'DB:business_master_new
loadtime:2.8054540157318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tippo' limit 1
loadtime:2.8055059909821 / seconds
Query Executed:select id FROM `ms` where city='Tippo' && SIC_code='5411'DB:business_master_new
loadtime:2.8059649467468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tishomingo' limit 1
loadtime:2.8060350418091 / seconds
Query Executed:select id FROM `ms` where city='Tishomingo' && SIC_code='5411'DB:business_master_new
loadtime:2.8073420524597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toccopola' limit 1
loadtime:2.8074140548706 / seconds
Query Executed:select id FROM `ms` where city='Toccopola' && SIC_code='5411'DB:business_master_new
loadtime:2.8078148365021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toomsuba' limit 1
loadtime:2.8078889846802 / seconds
Query Executed:select id FROM `ms` where city='Toomsuba' && SIC_code='5411'DB:business_master_new
loadtime:2.8090538978577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tougaloo' limit 1
loadtime:2.8091189861298 / seconds
Query Executed:select id FROM `ms` where city='Tougaloo' && SIC_code='5411'DB:business_master_new
loadtime:2.8096969127655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trebloc' limit 1
loadtime:2.8097488880157 / seconds
Query Executed:select id FROM `ms` where city='Trebloc' && SIC_code='5411'DB:business_master_new
loadtime:2.8101329803467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremont' limit 1
loadtime:2.8101859092712 / seconds
Query Executed:select id FROM `ms` where city='Tremont' && SIC_code='5411'DB:business_master_new
loadtime:2.8108859062195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tula' limit 1
loadtime:2.8109509944916 / seconds
Query Executed:select id FROM `ms` where city='Tula' && SIC_code='5411'DB:business_master_new
loadtime:2.8113210201263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunica' limit 1
loadtime:2.8113739490509 / seconds
Query Executed:select id FROM `ms` where city='Tunica' && SIC_code='5411'DB:business_master_new
loadtime:2.818167924881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tupelo' limit 1
loadtime:2.818256855011 / seconds
Query Executed:select id FROM `ms` where city='Tupelo' && SIC_code='5411'DB:business_master_new
loadtime:2.8525099754333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tutwiler' limit 1
loadtime:2.8527050018311 / seconds
Query Executed:select id FROM `ms` where city='Tutwiler' && SIC_code='5411'DB:business_master_new
loadtime:2.8536338806152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tylertown' limit 1
loadtime:2.8537108898163 / seconds
Query Executed:select id FROM `ms` where city='Tylertown' && SIC_code='5411'DB:business_master_new
loadtime:2.8611218929291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:2.8612079620361 / seconds
Query Executed:select id FROM `ms` where city='Union' && SIC_code='5411'DB:business_master_new
loadtime:2.8634338378906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Church' limit 1
loadtime:2.8635158538818 / seconds
Query Executed:select id FROM `ms` where city='Union Church' && SIC_code='5411'DB:business_master_new
loadtime:2.8640470504761 / seconds
Query loaded from cache:select * from geodata_geocity where city='University' limit 1
loadtime:2.8641178607941 / seconds
Query Executed:select id FROM `ms` where city='University' && SIC_code='5411'DB:business_master_new
loadtime:2.8650848865509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:2.8651399612427 / seconds
Query Executed:select id FROM `ms` where city='Utica' && SIC_code='5411'DB:business_master_new
loadtime:2.8668279647827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaiden' limit 1
loadtime:2.8669219017029 / seconds
Query Executed:select id FROM `ms` where city='Vaiden' && SIC_code='5411'DB:business_master_new
loadtime:2.8682479858398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Park' limit 1
loadtime:2.8683228492737 / seconds
Query Executed:select id FROM `ms` where city='Valley Park' && SIC_code='5411'DB:business_master_new
loadtime:2.8687829971313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Vleet' limit 1
loadtime:2.8688390254974 / seconds
Query Executed:select id FROM `ms` where city='Van Vleet' && SIC_code='5411'DB:business_master_new
loadtime:2.8692970275879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:2.8693509101868 / seconds
Query Executed:select id FROM `ms` where city='Vance' && SIC_code='5411'DB:business_master_new
loadtime:2.869796037674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vancleave' limit 1
loadtime:2.8698568344116 / seconds
Query Executed:select id FROM `ms` where city='Vancleave' && SIC_code='5411'DB:business_master_new
loadtime:2.9014658927917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vardaman' limit 1
loadtime:2.901556968689 / seconds
Query Executed:select id FROM `ms` where city='Vardaman' && SIC_code='5411'DB:business_master_new
loadtime:2.902951002121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:2.9030299186707 / seconds
Query Executed:select id FROM `ms` where city='Vaughan' && SIC_code='5411'DB:business_master_new
loadtime:2.9036169052124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:2.9036710262299 / seconds
Query Executed:select id FROM `ms` where city='Verona' && SIC_code='5411'DB:business_master_new
loadtime:2.9055309295654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:2.905604839325 / seconds
Query Executed:select id FROM `ms` where city='Vicksburg' && SIC_code='5411'DB:business_master_new
loadtime:2.9323668479919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:2.9325339794159 / seconds
Query Executed:select id FROM `ms` where city='Victoria' && SIC_code='5411'DB:business_master_new
loadtime:2.9331250190735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vossburg' limit 1
loadtime:2.9331979751587 / seconds
Query Executed:select id FROM `ms` where city='Vossburg' && SIC_code='5411'DB:business_master_new
loadtime:2.9337408542633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walls' limit 1
loadtime:2.9337928295135 / seconds
Query Executed:select id FROM `ms` where city='Walls' && SIC_code='5411'DB:business_master_new
loadtime:2.9648139476776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:2.9649000167847 / seconds
Query Executed:select id FROM `ms` where city='Walnut' && SIC_code='5411'DB:business_master_new
loadtime:2.9948289394379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Grove' limit 1
loadtime:2.9949178695679 / seconds
Query Executed:select id FROM `ms` where city='Walnut Grove' && SIC_code='5411'DB:business_master_new
loadtime:2.9959769248962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walthall' limit 1
loadtime:2.9960570335388 / seconds
Query Executed:select id FROM `ms` where city='Walthall' && SIC_code='5411'DB:business_master_new
loadtime:2.9965848922729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:2.9966518878937 / seconds
Query Executed:select id FROM `ms` where city='Washington' && SIC_code='5411'DB:business_master_new
loadtime:2.9972820281982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water Valley' limit 1
loadtime:2.9973359107971 / seconds
Query Executed:select id FROM `ms` where city='Water Valley' && SIC_code='5411'DB:business_master_new
loadtime:3.0273590087891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:3.0274448394775 / seconds
Query Executed:select id FROM `ms` where city='Waterford' && SIC_code='5411'DB:business_master_new
loadtime:3.0281059741974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waveland' limit 1
loadtime:3.0281758308411 / seconds
Query Executed:select id FROM `ms` where city='Waveland' && SIC_code='5411'DB:business_master_new
loadtime:3.0344839096069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:3.0345590114594 / seconds
Query Executed:select id FROM `ms` where city='Waynesboro' && SIC_code='5411'DB:business_master_new
loadtime:3.0441689491272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayside' limit 1
loadtime:3.0442659854889 / seconds
Query Executed:select id FROM `ms` where city='Wayside' && SIC_code='5411'DB:business_master_new
loadtime:3.0446808338165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:3.0447359085083 / seconds
Query Executed:select id FROM `ms` where city='Webb' && SIC_code='5411'DB:business_master_new
loadtime:3.0454869270325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weir' limit 1
loadtime:3.0455558300018 / seconds
Query Executed:select id FROM `ms` where city='Weir' && SIC_code='5411'DB:business_master_new
loadtime:3.0462658405304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesson' limit 1
loadtime:3.0463359355927 / seconds
Query Executed:select id FROM `ms` where city='Wesson' && SIC_code='5411'DB:business_master_new
loadtime:3.0480220317841 / seconds
Query loaded from cache:select * from geodata_geocity where city='West' limit 1
loadtime:3.0480990409851 / seconds
Query Executed:select id FROM `ms` where city='West' && SIC_code='5411'DB:business_master_new
loadtime:3.0487718582153 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:3.048840045929 / seconds
Query Executed:select id FROM `ms` where city='West Point' && SIC_code='5411'DB:business_master_new
loadtime:3.0601329803467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:3.0602428913116 / seconds
Query Executed:select id FROM `ms` where city='Wheeler' && SIC_code='5411'DB:business_master_new
loadtime:3.0606958866119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitfield' limit 1
loadtime:3.0607540607452 / seconds
Query Executed:select id FROM `ms` where city='Whitfield' && SIC_code='5411'DB:business_master_new
loadtime:3.061185836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:3.0612418651581 / seconds
Query Executed:select id FROM `ms` where city='Wiggins' && SIC_code='5411'DB:business_master_new
loadtime:3.0689179897308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winona' limit 1
loadtime:3.0690338611603 / seconds
Query Executed:select id FROM `ms` where city='Winona' && SIC_code='5411'DB:business_master_new
loadtime:3.0755770206451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winstonville' limit 1
loadtime:3.075660943985 / seconds
Query Executed:select id FROM `ms` where city='Winstonville' && SIC_code='5411'DB:business_master_new
loadtime:3.0760860443115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:3.0761430263519 / seconds
Query Executed:select id FROM `ms` where city='Winterville' && SIC_code='5411'DB:business_master_new
loadtime:3.0765359401703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:3.0765879154205 / seconds
Query Executed:select id FROM `ms` where city='Woodland' && SIC_code='5411'DB:business_master_new
loadtime:3.0773890018463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:3.0774600505829 / seconds
Query Executed:select id FROM `ms` where city='Woodville' && SIC_code='5411'DB:business_master_new
loadtime:3.108649969101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yazoo City' limit 1
loadtime:3.1087548732758 / seconds
Query Executed:select id FROM `ms` where city='Yazoo City' && SIC_code='5411'DB:business_master_new
loadtime:3.11962890625 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:3.1198608875275 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:3.1203348636627 / seconds
Operation template executed (chunk cache operation)
loadtime:3.1205070018768 / seconds
template override:Default
loadtime:3.1205489635468 / 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:3.1220200061798 / seconds
Template Constructed, Array Rows:49
loadtime:3.1225619316101 / seconds
TOTAL EXECUTION TIME: 3.12211
loadtime:3.1255848407745 / 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] => grocery-stores [stateURLid] => mississippi )


_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:3.1255960464478
TOTAL KEY ARRAYS: 69