DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.5074691772461E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00036406517028809 / seconds
host not found setting manual db connection
loadtime:0.00063395500183105 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0008549690246582 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.00096797943115234 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0010089874267578 / seconds
zipcode:
loadtime:0.0010261535644531 / seconds
Query Executed:select * from search_referrer where page_hash='d997e3d6bfd8dd135dd0bde47aaf5841' limit 10 DB:ezrox_toadli
loadtime:0.0011920928955078 / seconds
Operation header executed (non global)
loadtime:0.0012080669403076 / seconds
Operation leaderboard executed (non global)
loadtime:0.0012340545654297 / seconds
Operation square executed (non global)
loadtime:0.0012481212615967 / seconds
Operation square_bottom executed (non global)
loadtime:0.0012609958648682 / seconds
Operation smallsquare executed (non global)
loadtime:0.0012731552124023 / seconds
Operation headeradright executed (non global)
loadtime:0.0012850761413574 / seconds
Operation google_analytics executed (non global)
loadtime:0.0012950897216797 / seconds
Operation topstories executed (non global)
loadtime:0.0013060569763184 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0013179779052734 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0013279914855957 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001554012298584 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0016980171203613 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0017361640930176 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0017940998077393 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0018279552459717 / seconds
Template key: archive_menu pushed
loadtime:0.0018329620361328 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0018391609191895 / seconds
Template key: get_gravatar pushed
loadtime:0.0018429756164551 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0018470287322998 / seconds
*10)-10)+1 | start:0
loadtime:0.0018680095672607 / seconds
DB connected to localhost business_master_new
loadtime:0.002094030380249 / seconds
Query Executed:select * from categories where cat_URLid='laundry-and-garment-services-nec'DB:business_master_new
loadtime:0.0026171207427979 / seconds
Query stored in cache : _QUERY_www.toadli.com37ffabd5182986d214904f494594cd40
loadtime:0.0026481151580811 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.0026800632476807 / seconds
Query Executed:select * from `ms_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.11668109893799 / seconds
Query stored in cache : _QUERY_www.toadli.comd6bfb997a4f36f735b2c095be619118a
loadtime:0.11740517616272 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='mississippi'
loadtime:0.1174590587616 / seconds
Query Executed:select sum(totalcount) as totalsum from `ms_catmap` where sic='7219'DB:business_master_new
loadtime:0.12003517150879 / seconds
Query stored in cache : _QUERY_www.toadli.coma9c949af383a5e1836c757ce7dfe7999
loadtime:0.12006115913391 / seconds
463 / 11
loadtime:0.12009811401367 / seconds
Query Executed:select * from geodata_geocity where city='Abbeville' limit 1DB:business_master_new
loadtime:0.12040400505066 / seconds
Query stored in cache : _QUERY_www.toadli.comae1aeeaf54fdd625f0ef987226ed1291
loadtime:0.12044405937195 / seconds
Query Executed:select id FROM `ms` where city='Abbeville' && SIC_code='7219'DB:business_master_new
loadtime:0.12272810935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.1228301525116 / seconds
Query Executed:select id FROM `ms` where city='Aberdeen' && SIC_code='7219'DB:business_master_new
loadtime:0.14334511756897 / seconds
Query Executed:select * from geodata_geocity where city='Ackerman' limit 1DB:business_master_new
loadtime:0.14364314079285 / seconds
Query stored in cache : _QUERY_www.toadli.comea51db89861669dcef164b4e77af393e
loadtime:0.1436870098114 / seconds
Query Executed:select id FROM `ms` where city='Ackerman' && SIC_code='7219'DB:business_master_new
loadtime:0.14436411857605 / seconds
Query Executed:select * from geodata_geocity where city='Agricola' limit 1DB:business_master_new
loadtime:0.14465999603271 / seconds
Query stored in cache : _QUERY_www.toadli.com2ac4485e49b588ac6345f6fa44f9f908
loadtime:0.14470314979553 / seconds
Query Executed:select id FROM `ms` where city='Agricola' && SIC_code='7219'DB:business_master_new
loadtime:0.14493703842163 / seconds
Query Executed:select * from geodata_geocity where city='Alcorn State' limit 1DB:business_master_new
loadtime:0.14520907402039 / seconds
Query stored in cache : _QUERY_www.toadli.com63c18bf0d4efa32b785a47ff068c37d2
loadtime:0.14524412155151 / seconds
Query Executed:select id FROM `ms` where city='Alcorn State' && SIC_code='7219'DB:business_master_new
loadtime:0.14548397064209 / seconds
Query Executed:select * from geodata_geocity where city='Algoma' limit 1DB:business_master_new
loadtime:0.14576506614685 / seconds
Query stored in cache : _QUERY_www.toadli.com6339ce11c5530b7761278753c06575ed
loadtime:0.14580607414246 / seconds
Query Executed:select id FROM `ms` where city='Algoma' && SIC_code='7219'DB:business_master_new
loadtime:0.14787411689758 / seconds
Query Executed:select * from geodata_geocity where city='Alligator' limit 1DB:business_master_new
loadtime:0.14813899993896 / seconds
Query stored in cache : _QUERY_www.toadli.com08007e9006fc017461391c9bb3176cc2
loadtime:0.14817714691162 / seconds
Query Executed:select id FROM `ms` where city='Alligator' && SIC_code='7219'DB:business_master_new
loadtime:0.1527271270752 / seconds
Query Executed:select * from geodata_geocity where city='Amory' limit 1DB:business_master_new
loadtime:0.15303802490234 / seconds
Query stored in cache : _QUERY_www.toadli.com102de72e7fdb7bc5ca9bc0ba5a3ece15
loadtime:0.15308213233948 / seconds
Query Executed:select id FROM `ms` where city='Amory' && SIC_code='7219'DB:business_master_new
loadtime:0.15378403663635 / seconds
Query Executed:select * from geodata_geocity where city='Anguilla' limit 1DB:business_master_new
loadtime:0.15408205986023 / seconds
Query stored in cache : _QUERY_www.toadli.com8c042c4e888db3c4787ba12a87084440
loadtime:0.15411806106567 / seconds
Query Executed:select id FROM `ms` where city='Anguilla' && SIC_code='7219'DB:business_master_new
loadtime:0.15452814102173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcola' limit 1
loadtime:0.15457105636597 / seconds
Query Executed:select id FROM `ms` where city='Arcola' && SIC_code='7219'DB:business_master_new
loadtime:0.16077899932861 / seconds
Query Executed:select * from geodata_geocity where city='Arkabutla' limit 1DB:business_master_new
loadtime:0.16105198860168 / seconds
Query stored in cache : _QUERY_www.toadli.com39f7e8726fe7959d77f490dc7c2102f7
loadtime:0.1610860824585 / seconds
Query Executed:select id FROM `ms` where city='Arkabutla' && SIC_code='7219'DB:business_master_new
loadtime:0.16324210166931 / seconds
Query Executed:select * from geodata_geocity where city='Artesia' limit 1DB:business_master_new
loadtime:0.16351914405823 / seconds
Query stored in cache : _QUERY_www.toadli.comd2107a70790b80ae5465a86b43bbfed3
loadtime:0.16355800628662 / seconds
Query Executed:select id FROM `ms` where city='Artesia' && SIC_code='7219'DB:business_master_new
loadtime:0.16395807266235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.1639940738678 / seconds
Query Executed:select id FROM `ms` where city='Ashland' && SIC_code='7219'DB:business_master_new
loadtime:0.16437101364136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.16440796852112 / seconds
Query Executed:select id FROM `ms` where city='Avalon' && SIC_code='7219'DB:business_master_new
loadtime:0.16465497016907 / seconds
Query Executed:select * from geodata_geocity where city='Avon' limit 1DB:business_master_new
loadtime:0.16494297981262 / seconds
Query stored in cache : _QUERY_www.toadli.com40418d049752aec0f2130763354972d1
loadtime:0.16497302055359 / seconds
Query Executed:select id FROM `ms` where city='Avon' && SIC_code='7219'DB:business_master_new
loadtime:0.16532206535339 / seconds
Query Executed:select * from geodata_geocity where city='Bailey' limit 1DB:business_master_new
loadtime:0.16558599472046 / seconds
Query stored in cache : _QUERY_www.toadli.com5fb57e35156034b0edc8a2fb6573891b
loadtime:0.16562914848328 / seconds
Query Executed:select id FROM `ms` where city='Bailey' && SIC_code='7219'DB:business_master_new
loadtime:0.1659619808197 / seconds
Query Executed:select * from geodata_geocity where city='Baldwyn' limit 1DB:business_master_new
loadtime:0.1662449836731 / seconds
Query stored in cache : _QUERY_www.toadli.comd6a51e1c0052d51648de413bfba8357a
loadtime:0.16627407073975 / seconds
Query Executed:select id FROM `ms` where city='Baldwyn' && SIC_code='7219'DB:business_master_new
loadtime:0.16694498062134 / seconds
Query Executed:select * from geodata_geocity where city='Banner' limit 1DB:business_master_new
loadtime:0.16721701622009 / seconds
Query stored in cache : _QUERY_www.toadli.comb8ac745d1ce05f58338f59a76544bba4
loadtime:0.16725707054138 / seconds
Query Executed:select id FROM `ms` where city='Banner' && SIC_code='7219'DB:business_master_new
loadtime:0.16756010055542 / seconds
Query Executed:select * from geodata_geocity where city='Bassfield' limit 1DB:business_master_new
loadtime:0.16782712936401 / seconds
Query stored in cache : _QUERY_www.toadli.come843756c981162ad25c6142f0d09a1c3
loadtime:0.16785502433777 / seconds
Query Executed:select id FROM `ms` where city='Bassfield' && SIC_code='7219'DB:business_master_new
loadtime:0.16820597648621 / seconds
Query Executed:select * from geodata_geocity where city='Batesville' limit 1DB:business_master_new
loadtime:0.16847515106201 / seconds
Query stored in cache : _QUERY_www.toadli.come77b13af4b726f51ab911d8783411f7c
loadtime:0.16851496696472 / seconds
Query Executed:select id FROM `ms` where city='Batesville' && SIC_code='7219'DB:business_master_new
loadtime:0.16917896270752 / seconds
Query Executed:select * from geodata_geocity where city='Bay Saint Louis' limit 1DB:business_master_new
loadtime:0.16944408416748 / seconds
Query stored in cache : _QUERY_www.toadli.com8eb25a803b4d5c6716a9f2a8afd897f9
loadtime:0.16949009895325 / seconds
Query Executed:select id FROM `ms` where city='Bay Saint Louis' && SIC_code='7219'DB:business_master_new
loadtime:0.17015504837036 / seconds
Query Executed:select * from geodata_geocity where city='Bay Springs' limit 1DB:business_master_new
loadtime:0.1704261302948 / seconds
Query stored in cache : _QUERY_www.toadli.comf878480bb838a144c540d9df0195cde2
loadtime:0.17046904563904 / seconds
Query Executed:select id FROM `ms` where city='Bay Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.17113208770752 / seconds
Query Executed:select * from geodata_geocity where city='Bay St Louis' limit 1DB:business_master_new
loadtime:0.17140698432922 / seconds
Query stored in cache : _QUERY_www.toadli.com24124304fda144c4d26d2e3992e4d26e
loadtime:0.17144203186035 / seconds
Query Executed:select id FROM `ms` where city='Bay St Louis' && SIC_code='7219'DB:business_master_new
loadtime:0.171795129776 / seconds
Query Executed:select * from geodata_geocity where city='Beaumont' limit 1DB:business_master_new
loadtime:0.17205715179443 / seconds
Query stored in cache : _QUERY_www.toadli.com0343b0ee2e2cd4cf21415ad678f7f531
loadtime:0.17208409309387 / seconds
Query Executed:select id FROM `ms` where city='Beaumont' && SIC_code='7219'DB:business_master_new
loadtime:0.17243599891663 / seconds
Query Executed:select * from geodata_geocity where city='Becker' limit 1DB:business_master_new
loadtime:0.17270398139954 / seconds
Query stored in cache : _QUERY_www.toadli.come1452c539e3e587a789fd8c60ba57413
loadtime:0.17274117469788 / seconds
Query Executed:select id FROM `ms` where city='Becker' && SIC_code='7219'DB:business_master_new
loadtime:0.17304301261902 / seconds
Query Executed:select * from geodata_geocity where city='Belden' limit 1DB:business_master_new
loadtime:0.17331004142761 / seconds
Query stored in cache : _QUERY_www.toadli.com95d65f8c62d3a997cf4fd54ecbc63bcd
loadtime:0.17333602905273 / seconds
Query Executed:select id FROM `ms` where city='Belden' && SIC_code='7219'DB:business_master_new
loadtime:0.17373108863831 / seconds
Query Executed:select * from geodata_geocity where city='Belen' limit 1DB:business_master_new
loadtime:0.17400002479553 / seconds
Query stored in cache : _QUERY_www.toadli.comed3a2237f1e2eeb50b4ac526c10e4716
loadtime:0.17403316497803 / seconds
Query Executed:select id FROM `ms` where city='Belen' && SIC_code='7219'DB:business_master_new
loadtime:0.1742901802063 / seconds
Query Executed:select * from geodata_geocity where city='Bellefontaine' limit 1DB:business_master_new
loadtime:0.17456912994385 / seconds
Query stored in cache : _QUERY_www.toadli.com2a593eb2da1902cbe1b44e359131b627
loadtime:0.17459607124329 / seconds
Query Executed:select id FROM `ms` where city='Bellefontaine' && SIC_code='7219'DB:business_master_new
loadtime:0.17487096786499 / seconds
Query Executed:select * from geodata_geocity where city='Belmont' limit 1DB:business_master_new
loadtime:0.17515397071838 / seconds
Query stored in cache : _QUERY_www.toadli.comd50b48a202816f1b1bf32476d64d48c2
loadtime:0.17518711090088 / seconds
Query Executed:select id FROM `ms` where city='Belmont' && SIC_code='7219'DB:business_master_new
loadtime:0.17560601234436 / seconds
Query Executed:select * from geodata_geocity where city='Belzoni' limit 1DB:business_master_new
loadtime:0.17586517333984 / seconds
Query stored in cache : _QUERY_www.toadli.com1cfe5225148999492ba35f94fbe089d9
loadtime:0.17589998245239 / seconds
Query Executed:select id FROM `ms` where city='Belzoni' && SIC_code='7219'DB:business_master_new
loadtime:0.17656397819519 / seconds
Query Executed:select * from geodata_geocity where city='Benoit' limit 1DB:business_master_new
loadtime:0.17682695388794 / seconds
Query stored in cache : _QUERY_www.toadli.com3cf009111079719d50ffa368f9803964
loadtime:0.17685508728027 / seconds
Query Executed:select id FROM `ms` where city='Benoit' && SIC_code='7219'DB:business_master_new
loadtime:0.17719602584839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.17722916603088 / seconds
Query Executed:select id FROM `ms` where city='Benton' && SIC_code='7219'DB:business_master_new
loadtime:0.17759013175964 / seconds
Query Executed:select * from geodata_geocity where city='Bentonia' limit 1DB:business_master_new
loadtime:0.17785096168518 / seconds
Query stored in cache : _QUERY_www.toadli.com678be2ba2fdf71324ca4a8290d13a502
loadtime:0.17788314819336 / seconds
Query Executed:select id FROM `ms` where city='Bentonia' && SIC_code='7219'DB:business_master_new
loadtime:0.17826294898987 / seconds
Query Executed:select * from geodata_geocity where city='Beulah' limit 1DB:business_master_new
loadtime:0.17855095863342 / seconds
Query stored in cache : _QUERY_www.toadli.com90a72cb17d1aec875ab06bb85648ca59
loadtime:0.17857813835144 / seconds
Query Executed:select id FROM `ms` where city='Beulah' && SIC_code='7219'DB:business_master_new
loadtime:0.17887997627258 / seconds
Query Executed:select * from geodata_geocity where city='Big Creek' limit 1DB:business_master_new
loadtime:0.17912197113037 / seconds
Query stored in cache : _QUERY_www.toadli.coma1af5cc962291336fd95a8849f813b73
loadtime:0.1791570186615 / seconds
Query Executed:select id FROM `ms` where city='Big Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.17951202392578 / seconds
Query Executed:select * from geodata_geocity where city='Biloxi' limit 1DB:business_master_new
loadtime:0.17976117134094 / seconds
Query stored in cache : _QUERY_www.toadli.com61fe2ccdcc585c2e433b1c854fded47c
loadtime:0.17978811264038 / seconds
Query Executed:select id FROM `ms` where city='Biloxi' && SIC_code='7219'DB:business_master_new
loadtime:0.18045401573181 / seconds
Query Executed:select * from geodata_geocity where city='Blue Mountain' limit 1DB:business_master_new
loadtime:0.18070316314697 / seconds
Query stored in cache : _QUERY_www.toadli.come15dae1aad94499898d1c3ef61a6a971
loadtime:0.18073916435242 / seconds
Query Executed:select id FROM `ms` where city='Blue Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.1811089515686 / seconds
Query Executed:select * from geodata_geocity where city='Blue Springs' limit 1DB:business_master_new
loadtime:0.18135714530945 / seconds
Query stored in cache : _QUERY_www.toadli.com5baebab0d6501f9c381479bdcfaf5954
loadtime:0.18138313293457 / seconds
Query Executed:select id FROM `ms` where city='Blue Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.18173408508301 / seconds
Query Executed:select * from geodata_geocity where city='Bogue Chitto' limit 1DB:business_master_new
loadtime:0.18200016021729 / seconds
Query stored in cache : _QUERY_www.toadli.com2c4b233458c84bba8bc92d4d0e5f9c31
loadtime:0.18203711509705 / seconds
Query Executed:select id FROM `ms` where city='Bogue Chitto' && SIC_code='7219'DB:business_master_new
loadtime:0.18240904808044 / seconds
Query Executed:select * from geodata_geocity where city='Bolton' limit 1DB:business_master_new
loadtime:0.18268203735352 / seconds
Query stored in cache : _QUERY_www.toadli.comd0a35365458e8495812d3193805615dd
loadtime:0.18271803855896 / seconds
Query Executed:select id FROM `ms` where city='Bolton' && SIC_code='7219'DB:business_master_new
loadtime:0.18306016921997 / seconds
Query Executed:select * from geodata_geocity where city='Booneville' limit 1DB:business_master_new
loadtime:0.18331909179688 / seconds
Query stored in cache : _QUERY_www.toadli.comb4e52ea4f6ca53a6a418421531926612
loadtime:0.18334698677063 / seconds
Query Executed:select id FROM `ms` where city='Booneville' && SIC_code='7219'DB:business_master_new
loadtime:0.18402600288391 / seconds
Query Executed:select * from geodata_geocity where city='Boyle' limit 1DB:business_master_new
loadtime:0.18429517745972 / seconds
Query stored in cache : _QUERY_www.toadli.comacf99eb635808cbb65ea51a58273e367
loadtime:0.18432998657227 / seconds
Query Executed:select id FROM `ms` where city='Boyle' && SIC_code='7219'DB:business_master_new
loadtime:0.18472003936768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.18476104736328 / seconds
Query Executed:select id FROM `ms` where city='Brandon' && SIC_code='7219'DB:business_master_new
loadtime:0.18542313575745 / seconds
Query Executed:select * from geodata_geocity where city='Braxton' limit 1DB:business_master_new
loadtime:0.18570804595947 / seconds
Query stored in cache : _QUERY_www.toadli.com4c060aac94c4dd23fe9cae2716ded5df
loadtime:0.18573498725891 / seconds
Query Executed:select id FROM `ms` where city='Braxton' && SIC_code='7219'DB:business_master_new
loadtime:0.18609714508057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookhaven' limit 1
loadtime:0.18613600730896 / seconds
Query Executed:select id FROM `ms` where city='Brookhaven' && SIC_code='7219'DB:business_master_new
loadtime:0.18680906295776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.18684005737305 / seconds
Query Executed:select id FROM `ms` where city='Brooklyn' && SIC_code='7219'DB:business_master_new
loadtime:0.18718504905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooksville' limit 1
loadtime:0.18722009658813 / seconds
Query Executed:select id FROM `ms` where city='Brooksville' && SIC_code='7219'DB:business_master_new
loadtime:0.18759918212891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bruce' limit 1
loadtime:0.18762397766113 / seconds
Query Executed:select id FROM `ms` where city='Bruce' && SIC_code='7219'DB:business_master_new
loadtime:0.18826103210449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckatunna' limit 1
loadtime:0.18829607963562 / seconds
Query Executed:select id FROM `ms` where city='Buckatunna' && SIC_code='7219'DB:business_master_new
loadtime:0.18864607810974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bude' limit 1
loadtime:0.18867015838623 / seconds
Query Executed:select id FROM `ms` where city='Bude' && SIC_code='7219'DB:business_master_new
loadtime:0.18901515007019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.18904900550842 / seconds
Query Executed:select id FROM `ms` where city='Burnsville' && SIC_code='7219'DB:business_master_new
loadtime:0.18937611579895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byhalia' limit 1
loadtime:0.18940711021423 / seconds
Query Executed:select id FROM `ms` where city='Byhalia' && SIC_code='7219'DB:business_master_new
loadtime:0.19006109237671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byram' limit 1
loadtime:0.1900851726532 / seconds
Query Executed:select id FROM `ms` where city='Byram' && SIC_code='7219'DB:business_master_new
loadtime:0.19075703620911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caledonia' limit 1
loadtime:0.1907970905304 / seconds
Query Executed:select id FROM `ms` where city='Caledonia' && SIC_code='7219'DB:business_master_new
loadtime:0.19116401672363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calhoun City' limit 1
loadtime:0.19118714332581 / seconds
Query Executed:select id FROM `ms` where city='Calhoun City' && SIC_code='7219'DB:business_master_new
loadtime:0.19185018539429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.1918830871582 / seconds
Query Executed:select id FROM `ms` where city='Camden' && SIC_code='7219'DB:business_master_new
loadtime:0.19226503372192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.1922881603241 / seconds
Query Executed:select id FROM `ms` where city='Canton' && SIC_code='7219'DB:business_master_new
loadtime:0.19293212890625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carriere' limit 1
loadtime:0.19296717643738 / seconds
Query Executed:select id FROM `ms` where city='Carriere' && SIC_code='7219'DB:business_master_new
loadtime:0.19362497329712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.19365310668945 / seconds
Query Executed:select id FROM `ms` where city='Carrollton' && SIC_code='7219'DB:business_master_new
loadtime:0.1940131187439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carson' limit 1
loadtime:0.1940450668335 / seconds
Query Executed:select id FROM `ms` where city='Carson' && SIC_code='7219'DB:business_master_new
loadtime:0.19443106651306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:0.1944751739502 / seconds
Query Executed:select id FROM `ms` where city='Carthage' && SIC_code='7219'DB:business_master_new
loadtime:0.19511318206787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:0.19513702392578 / seconds
Query Executed:select id FROM `ms` where city='Cary' && SIC_code='7219'DB:business_master_new
loadtime:0.19554114341736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascilla' limit 1
loadtime:0.19557404518127 / seconds
Query Executed:select id FROM `ms` where city='Cascilla' && SIC_code='7219'DB:business_master_new
loadtime:0.19591212272644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarbluff' limit 1
loadtime:0.19593501091003 / seconds
Query Executed:select id FROM `ms` where city='Cedarbluff' && SIC_code='7219'DB:business_master_new
loadtime:0.19630813598633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.19633913040161 / seconds
Query Executed:select id FROM `ms` where city='Centreville' && SIC_code='7219'DB:business_master_new
loadtime:0.19673204421997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charleston' limit 1
loadtime:0.19676113128662 / seconds
Query Executed:select id FROM `ms` where city='Charleston' && SIC_code='7219'DB:business_master_new
loadtime:0.19740605354309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatawa' limit 1
loadtime:0.1974401473999 / seconds
Query Executed:select id FROM `ms` where city='Chatawa' && SIC_code='7219'DB:business_master_new
loadtime:0.19774699211121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.1977801322937 / seconds
Query Executed:select id FROM `ms` where city='Chatham' && SIC_code='7219'DB:business_master_new
loadtime:0.19809699058533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Choctaw' limit 1
loadtime:0.1981201171875 / seconds
Query Executed:select id FROM `ms` where city='Choctaw' && SIC_code='7219'DB:business_master_new
loadtime:0.19837808609009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chunky' limit 1
loadtime:0.19840908050537 / seconds
Query Executed:select id FROM `ms` where city='Chunky' && SIC_code='7219'DB:business_master_new
loadtime:0.19883894920349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clara' limit 1
loadtime:0.19886803627014 / seconds
Query Executed:select id FROM `ms` where city='Clara' && SIC_code='7219'DB:business_master_new
loadtime:0.19921803474426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksdale' limit 1
loadtime:0.19925212860107 / seconds
Query Executed:select id FROM `ms` where city='Clarksdale' && SIC_code='7219'DB:business_master_new
loadtime:0.19990301132202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.19992613792419 / seconds
Query Executed:select id FROM `ms` where city='Cleveland' && SIC_code='7219'DB:business_master_new
loadtime:0.20058703422546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.20062017440796 / seconds
Query Executed:select id FROM `ms` where city='Clinton' && SIC_code='7219'DB:business_master_new
loadtime:0.2012779712677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coahoma' limit 1
loadtime:0.20130705833435 / seconds
Query Executed:select id FROM `ms` where city='Coahoma' && SIC_code='7219'DB:business_master_new
loadtime:0.20169615745544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffeeville' limit 1
loadtime:0.20173001289368 / seconds
Query Executed:select id FROM `ms` where city='Coffeeville' && SIC_code='7219'DB:business_master_new
loadtime:0.20208501815796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coila' limit 1
loadtime:0.20211410522461 / seconds
Query Executed:select id FROM `ms` where city='Coila' && SIC_code='7219'DB:business_master_new
loadtime:0.20248007774353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coldwater' limit 1
loadtime:0.20250415802002 / seconds
Query Executed:select id FROM `ms` where city='Coldwater' && SIC_code='7219'DB:business_master_new
loadtime:0.20315217971802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.20318508148193 / seconds
Query Executed:select id FROM `ms` where city='Collins' && SIC_code='7219'DB:business_master_new
loadtime:0.20384907722473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.20387315750122 / seconds
Query Executed:select id FROM `ms` where city='Collinsville' && SIC_code='7219'DB:business_master_new
loadtime:0.20426917076111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.20430898666382 / seconds
Query Executed:select id FROM `ms` where city='Columbia' && SIC_code='7219'DB:business_master_new
loadtime:0.20496916770935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.20499897003174 / seconds
Query Executed:select id FROM `ms` where city='Columbus' && SIC_code='7219'DB:business_master_new
loadtime:0.20566296577454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Afb' limit 1
loadtime:0.20570516586304 / seconds
Query Executed:select id FROM `ms` where city='Columbus Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.20605397224426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:0.20607709884644 / seconds
Query Executed:select id FROM `ms` where city='Como' && SIC_code='7219'DB:business_master_new
loadtime:0.20646595954895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conehatta' limit 1
loadtime:0.20649909973145 / seconds
Query Executed:select id FROM `ms` where city='Conehatta' && SIC_code='7219'DB:business_master_new
loadtime:0.20692300796509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinth' limit 1
loadtime:0.20695400238037 / seconds
Query Executed:select id FROM `ms` where city='Corinth' && SIC_code='7219'DB:business_master_new
loadtime:0.20761513710022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.20764517784119 / seconds
Query Executed:select id FROM `ms` where city='Courtland' && SIC_code='7219'DB:business_master_new
loadtime:0.20796895027161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawford' limit 1
loadtime:0.20800304412842 / seconds
Query Executed:select id FROM `ms` where city='Crawford' && SIC_code='7219'DB:business_master_new
loadtime:0.20833706855774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crenshaw' limit 1
loadtime:0.20835995674133 / seconds
Query Executed:select id FROM `ms` where city='Crenshaw' && SIC_code='7219'DB:business_master_new
loadtime:0.20871901512146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosby' limit 1
loadtime:0.20875310897827 / seconds
Query Executed:select id FROM `ms` where city='Crosby' && SIC_code='7219'DB:business_master_new
loadtime:0.20906496047974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowder' limit 1
loadtime:0.20908808708191 / seconds
Query Executed:select id FROM `ms` where city='Crowder' && SIC_code='7219'DB:business_master_new
loadtime:0.20942401885986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cruger' limit 1
loadtime:0.20946502685547 / seconds
Query Executed:select id FROM `ms` where city='Cruger' && SIC_code='7219'DB:business_master_new
loadtime:0.20981311798096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Springs' limit 1
loadtime:0.2098400592804 / seconds
Query Executed:select id FROM `ms` where city='Crystal Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.21050715446472 / seconds
Query loaded from cache:select * from geodata_geocity where city='D Lo' limit 1
loadtime:0.21054005622864 / seconds
Query Executed:select id FROM `ms` where city='D Lo' && SIC_code='7219'DB:business_master_new
loadtime:0.21094012260437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.21097016334534 / seconds
Query Executed:select id FROM `ms` where city='Daleville' && SIC_code='7219'DB:business_master_new
loadtime:0.21133804321289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darling' limit 1
loadtime:0.21136116981506 / seconds
Query Executed:select id FROM `ms` where city='Darling' && SIC_code='7219'DB:business_master_new
loadtime:0.21164608001709 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Kalb' limit 1
loadtime:0.21167898178101 / seconds
Query Executed:select id FROM `ms` where city='De Kalb' && SIC_code='7219'DB:business_master_new
loadtime:0.21232104301453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.21234512329102 / seconds
Query Executed:select id FROM `ms` where city='Decatur' && SIC_code='7219'DB:business_master_new
loadtime:0.21269917488098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta City' limit 1
loadtime:0.21273112297058 / seconds
Query Executed:select id FROM `ms` where city='Delta City' && SIC_code='7219'DB:business_master_new
loadtime:0.21298217773438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennis' limit 1
loadtime:0.21300506591797 / seconds
Query Executed:select id FROM `ms` where city='Dennis' && SIC_code='7219'DB:business_master_new
loadtime:0.21334004402161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derma' limit 1
loadtime:0.21337008476257 / seconds
Query Executed:select id FROM `ms` where city='Derma' && SIC_code='7219'DB:business_master_new
loadtime:0.21375513076782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamondhead' limit 1
loadtime:0.21378898620605 / seconds
Query Executed:select id FROM `ms` where city='Diamondhead' && SIC_code='7219'DB:business_master_new
loadtime:0.21445417404175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diberville' limit 1
loadtime:0.21447801589966 / seconds
Query Executed:select id FROM `ms` where city='Diberville' && SIC_code='7219'DB:business_master_new
loadtime:0.21512007713318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doddsville' limit 1
loadtime:0.21516013145447 / seconds
Query Executed:select id FROM `ms` where city='Doddsville' && SIC_code='7219'DB:business_master_new
loadtime:0.21552610397339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drew' limit 1
loadtime:0.21555018424988 / seconds
Query Executed:select id FROM `ms` where city='Drew' && SIC_code='7219'DB:business_master_new
loadtime:0.21590304374695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.21593713760376 / seconds
Query Executed:select id FROM `ms` where city='Dublin' && SIC_code='7219'DB:business_master_new
loadtime:0.21623611450195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Hill' limit 1
loadtime:0.21625900268555 / seconds
Query Executed:select id FROM `ms` where city='Duck Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.21659207344055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumas' limit 1
loadtime:0.21662616729736 / seconds
Query Executed:select id FROM `ms` where city='Dumas' && SIC_code='7219'DB:business_master_new
loadtime:0.21699404716492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.21701598167419 / seconds
Query Executed:select id FROM `ms` where city='Duncan' && SIC_code='7219'DB:business_master_new
loadtime:0.21733617782593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.21736598014832 / seconds
Query Executed:select id FROM `ms` where city='Dundee' && SIC_code='7219'DB:business_master_new
loadtime:0.21770906448364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.21774196624756 / seconds
Query Executed:select id FROM `ms` where city='Durant' && SIC_code='7219'DB:business_master_new
loadtime:0.21840214729309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastabuchie' limit 1
loadtime:0.21842503547668 / seconds
Query Executed:select id FROM `ms` where city='Eastabuchie' && SIC_code='7219'DB:business_master_new
loadtime:0.21869397163391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ecru' limit 1
loadtime:0.21872806549072 / seconds
Query Executed:select id FROM `ms` where city='Ecru' && SIC_code='7219'DB:business_master_new
loadtime:0.21908116340637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edinburg' limit 1
loadtime:0.21910405158997 / seconds
Query Executed:select id FROM `ms` where city='Edinburg' && SIC_code='7219'DB:business_master_new
loadtime:0.21931600570679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwards' limit 1
loadtime:0.21934700012207 / seconds
Query Executed:select id FROM `ms` where city='Edwards' && SIC_code='7219'DB:business_master_new
loadtime:0.2197060585022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.21972918510437 / seconds
Query Executed:select id FROM `ms` where city='Elliott' && SIC_code='7219'DB:business_master_new
loadtime:0.21999716758728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellisville' limit 1
loadtime:0.2200300693512 / seconds
Query Executed:select id FROM `ms` where city='Ellisville' && SIC_code='7219'DB:business_master_new
loadtime:0.22068500518799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enid' limit 1
loadtime:0.22070813179016 / seconds
Query Executed:select id FROM `ms` where city='Enid' && SIC_code='7219'DB:business_master_new
loadtime:0.22105097770691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.2210841178894 / seconds
Query Executed:select id FROM `ms` where city='Enterprise' && SIC_code='7219'DB:business_master_new
loadtime:0.22141814231873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escatawpa' limit 1
loadtime:0.22146010398865 / seconds
Query Executed:select id FROM `ms` where city='Escatawpa' && SIC_code='7219'DB:business_master_new
loadtime:0.22180414199829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethel' limit 1
loadtime:0.22182703018188 / seconds
Query Executed:select id FROM `ms` where city='Ethel' && SIC_code='7219'DB:business_master_new
loadtime:0.22213315963745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etta' limit 1
loadtime:0.22216606140137 / seconds
Query Executed:select id FROM `ms` where city='Etta' && SIC_code='7219'DB:business_master_new
loadtime:0.22249507904053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eupora' limit 1
loadtime:0.22251915931702 / seconds
Query Executed:select id FROM `ms` where city='Eupora' && SIC_code='7219'DB:business_master_new
loadtime:0.22316408157349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:0.2231981754303 / seconds
Query Executed:select id FROM `ms` where city='Falcon' && SIC_code='7219'DB:business_master_new
loadtime:0.22345614433289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkner' limit 1
loadtime:0.2234799861908 / seconds
Query Executed:select id FROM `ms` where city='Falkner' && SIC_code='7219'DB:business_master_new
loadtime:0.22382307052612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farrell' limit 1
loadtime:0.22385597229004 / seconds
Query Executed:select id FROM `ms` where city='Farrell' && SIC_code='7219'DB:business_master_new
loadtime:0.22410917282104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.22413301467896 / seconds
Query Executed:select id FROM `ms` where city='Fayette' && SIC_code='7219'DB:business_master_new
loadtime:0.22478795051575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fernwood' limit 1
loadtime:0.22482299804688 / seconds
Query Executed:select id FROM `ms` where city='Fernwood' && SIC_code='7219'DB:business_master_new
loadtime:0.2251410484314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flora' limit 1
loadtime:0.22517013549805 / seconds
Query Executed:select id FROM `ms` where city='Flora' && SIC_code='7219'DB:business_master_new
loadtime:0.22582507133484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.22584795951843 / seconds
Query Executed:select id FROM `ms` where city='Florence' && SIC_code='7219'DB:business_master_new
loadtime:0.22651600837708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flowood' limit 1
loadtime:0.22655701637268 / seconds
Query Executed:select id FROM `ms` where city='Flowood' && SIC_code='7219'DB:business_master_new
loadtime:0.22719812393188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest' limit 1
loadtime:0.22722911834717 / seconds
Query Executed:select id FROM `ms` where city='Forest' && SIC_code='7219'DB:business_master_new
loadtime:0.2278881072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foxworth' limit 1
loadtime:0.22792196273804 / seconds
Query Executed:select id FROM `ms` where city='Foxworth' && SIC_code='7219'DB:business_master_new
loadtime:0.22829413414001 / seconds
Query loaded from cache:select * from geodata_geocity where city='French Camp' limit 1
loadtime:0.22831702232361 / seconds
Query Executed:select id FROM `ms` where city='French Camp' && SIC_code='7219'DB:business_master_new
loadtime:0.22865009307861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Friars Point' limit 1
loadtime:0.22868514060974 / seconds
Query Executed:select id FROM `ms` where city='Friars Point' && SIC_code='7219'DB:business_master_new
loadtime:0.22901296615601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:0.22904396057129 / seconds
Query Executed:select id FROM `ms` where city='Fulton' && SIC_code='7219'DB:business_master_new
loadtime:0.22971606254578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallman' limit 1
loadtime:0.22974014282227 / seconds
Query Executed:select id FROM `ms` where city='Gallman' && SIC_code='7219'DB:business_master_new
loadtime:0.23012208938599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gattman' limit 1
loadtime:0.23015403747559 / seconds
Query Executed:select id FROM `ms` where city='Gattman' && SIC_code='7219'DB:business_master_new
loadtime:0.2304790019989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gautier' limit 1
loadtime:0.23050308227539 / seconds
Query Executed:select id FROM `ms` where city='Gautier' && SIC_code='7219'DB:business_master_new
loadtime:0.23114395141602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.23117804527283 / seconds
Query Executed:select id FROM `ms` where city='Georgetown' && SIC_code='7219'DB:business_master_new
loadtime:0.23152613639832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.23154902458191 / seconds
Query Executed:select id FROM `ms` where city='Glen' && SIC_code='7219'DB:business_master_new
loadtime:0.23190307617188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allan' limit 1
loadtime:0.23193907737732 / seconds
Query Executed:select id FROM `ms` where city='Glen Allan' && SIC_code='7219'DB:business_master_new
loadtime:0.232262134552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:0.23228597640991 / seconds
Query Executed:select id FROM `ms` where city='Glendora' && SIC_code='7219'DB:business_master_new
loadtime:0.23265910148621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloster' limit 1
loadtime:0.23269200325012 / seconds
Query Executed:select id FROM `ms` where city='Gloster' && SIC_code='7219'DB:business_master_new
loadtime:0.23306107521057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden' limit 1
loadtime:0.23309206962585 / seconds
Query Executed:select id FROM `ms` where city='Golden' && SIC_code='7219'DB:business_master_new
loadtime:0.23342704772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodman' limit 1
loadtime:0.23346209526062 / seconds
Query Executed:select id FROM `ms` where city='Goodman' && SIC_code='7219'DB:business_master_new
loadtime:0.23380708694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gore Springs' limit 1
loadtime:0.2338399887085 / seconds
Query Executed:select id FROM `ms` where city='Gore Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.23416996002197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grace' limit 1
loadtime:0.23419404029846 / seconds
Query Executed:select id FROM `ms` where city='Grace' && SIC_code='7219'DB:business_master_new
loadtime:0.23451495170593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.23454904556274 / seconds
Query Executed:select id FROM `ms` where city='Greenville' && SIC_code='7219'DB:business_master_new
loadtime:0.23520398139954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood' limit 1
loadtime:0.23522806167603 / seconds
Query Executed:select id FROM `ms` where city='Greenwood' && SIC_code='7219'DB:business_master_new
loadtime:0.23589706420898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Spgs' limit 1
loadtime:0.2359311580658 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Spgs' && SIC_code='7219'DB:business_master_new
loadtime:0.23618102073669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwood Springs' limit 1
loadtime:0.23620414733887 / seconds
Query Executed:select id FROM `ms` where city='Greenwood Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.23659110069275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenada' limit 1
loadtime:0.23662400245667 / seconds
Query Executed:select id FROM `ms` where city='Grenada' && SIC_code='7219'DB:business_master_new
loadtime:0.23727703094482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulfport' limit 1
loadtime:0.23730897903442 / seconds
Query Executed:select id FROM `ms` where city='Gulfport' && SIC_code='7219'DB:business_master_new
loadtime:0.2379629611969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.23799610137939 / seconds
Query Executed:select id FROM `ms` where city='Gunnison' && SIC_code='7219'DB:business_master_new
loadtime:0.23840117454529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guntown' limit 1
loadtime:0.2384340763092 / seconds
Query Executed:select id FROM `ms` where city='Guntown' && SIC_code='7219'DB:business_master_new
loadtime:0.23878407478333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.23880815505981 / seconds
Query Executed:select id FROM `ms` where city='Hamilton' && SIC_code='7219'DB:business_master_new
loadtime:0.23917102813721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harperville' limit 1
loadtime:0.2392041683197 / seconds
Query Executed:select id FROM `ms` where city='Harperville' && SIC_code='7219'DB:business_master_new
loadtime:0.23958301544189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harriston' limit 1
loadtime:0.23960614204407 / seconds
Query Executed:select id FROM `ms` where city='Harriston' && SIC_code='7219'DB:business_master_new
loadtime:0.23982715606689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.23986101150513 / seconds
Query Executed:select id FROM `ms` where city='Harrisville' && SIC_code='7219'DB:business_master_new
loadtime:0.24021697044373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hattiesburg' limit 1
loadtime:0.2402400970459 / seconds
Query Executed:select id FROM `ms` where city='Hattiesburg' && SIC_code='7219'DB:business_master_new
loadtime:0.24090313911438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlehurst' limit 1
loadtime:0.24094295501709 / seconds
Query Executed:select id FROM `ms` where city='Hazlehurst' && SIC_code='7219'DB:business_master_new
loadtime:0.24161505699158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heidelberg' limit 1
loadtime:0.24165415763855 / seconds
Query Executed:select id FROM `ms` where city='Heidelberg' && SIC_code='7219'DB:business_master_new
loadtime:0.24204516410828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hermanville' limit 1
loadtime:0.24206900596619 / seconds
Query Executed:select id FROM `ms` where city='Hermanville' && SIC_code='7219'DB:business_master_new
loadtime:0.242427110672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hernando' limit 1
loadtime:0.24246597290039 / seconds
Query Executed:select id FROM `ms` where city='Hernando' && SIC_code='7219'DB:business_master_new
loadtime:0.24310898780823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:0.2431321144104 / seconds
Query Executed:select id FROM `ms` where city='Hickory' && SIC_code='7219'DB:business_master_new
loadtime:0.24346899986267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory Flat' limit 1
loadtime:0.24350309371948 / seconds
Query Executed:select id FROM `ms` where city='Hickory Flat' && SIC_code='7219'DB:business_master_new
loadtime:0.24383807182312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.24386215209961 / seconds
Query Executed:select id FROM `ms` where city='Hillsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.24412703514099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holcomb' limit 1
loadtime:0.24415707588196 / seconds
Query Executed:select id FROM `ms` where city='Holcomb' && SIC_code='7219'DB:business_master_new
loadtime:0.24450898170471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollandale' limit 1
loadtime:0.24454116821289 / seconds
Query Executed:select id FROM `ms` where city='Hollandale' && SIC_code='7219'DB:business_master_new
loadtime:0.24493598937988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Bluff' limit 1
loadtime:0.24495911598206 / seconds
Query Executed:select id FROM `ms` where city='Holly Bluff' && SIC_code='7219'DB:business_master_new
loadtime:0.24531412124634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:0.2453441619873 / seconds
Query Executed:select id FROM `ms` where city='Holly Ridge' && SIC_code='7219'DB:business_master_new
loadtime:0.24559807777405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:0.24562096595764 / seconds
Query Executed:select id FROM `ms` where city='Holly Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.24628615379333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horn Lake' limit 1
loadtime:0.24632096290588 / seconds
Query Executed:select id FROM `ms` where city='Horn Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.24698209762573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houlka' limit 1
loadtime:0.24700617790222 / seconds
Query Executed:select id FROM `ms` where city='Houlka' && SIC_code='7219'DB:business_master_new
loadtime:0.24735498428345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houston' limit 1
loadtime:0.24738812446594 / seconds
Query Executed:select id FROM `ms` where city='Houston' && SIC_code='7219'DB:business_master_new
loadtime:0.24805903434753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurley' limit 1
loadtime:0.24808406829834 / seconds
Query Executed:select id FROM `ms` where city='Hurley' && SIC_code='7219'DB:business_master_new
loadtime:0.24843907356262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.24848318099976 / seconds
Query Executed:select id FROM `ms` where city='Independence' && SIC_code='7219'DB:business_master_new
loadtime:0.24888205528259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:0.24891304969788 / seconds
Query Executed:select id FROM `ms` where city='Indianola' && SIC_code='7219'DB:business_master_new
loadtime:0.24957203865051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inverness' limit 1
loadtime:0.24959516525269 / seconds
Query Executed:select id FROM `ms` where city='Inverness' && SIC_code='7219'DB:business_master_new
loadtime:0.24996113777161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Isola' limit 1
loadtime:0.24999308586121 / seconds
Query Executed:select id FROM `ms` where city='Isola' && SIC_code='7219'DB:business_master_new
loadtime:0.25034117698669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Itta Bena' limit 1
loadtime:0.25036406517029 / seconds
Query Executed:select id FROM `ms` where city='Itta Bena' && SIC_code='7219'DB:business_master_new
loadtime:0.25074815750122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iuka' limit 1
loadtime:0.25078010559082 / seconds
Query Executed:select id FROM `ms` where city='Iuka' && SIC_code='7219'DB:business_master_new
loadtime:0.25143003463745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.2514660358429 / seconds
Query Executed:select id FROM `ms` where city='Jackson' && SIC_code='7219'DB:business_master_new
loadtime:0.25211405754089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jayess' limit 1
loadtime:0.25216007232666 / seconds
Query Executed:select id FROM `ms` where city='Jayess' && SIC_code='7219'DB:business_master_new
loadtime:0.25250601768494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonestown' limit 1
loadtime:0.25253009796143 / seconds
Query Executed:select id FROM `ms` where city='Jonestown' && SIC_code='7219'DB:business_master_new
loadtime:0.25285601615906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keesler Afb' limit 1
loadtime:0.25288796424866 / seconds
Query Executed:select id FROM `ms` where city='Keesler Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.2532970905304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilmichael' limit 1
loadtime:0.25332498550415 / seconds
Query Executed:select id FROM `ms` where city='Kilmichael' && SIC_code='7219'DB:business_master_new
loadtime:0.25369095802307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiln' limit 1
loadtime:0.25372314453125 / seconds
Query Executed:select id FROM `ms` where city='Kiln' && SIC_code='7219'DB:business_master_new
loadtime:0.2540910243988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kokomo' limit 1
loadtime:0.25412106513977 / seconds
Query Executed:select id FROM `ms` where city='Kokomo' && SIC_code='7219'DB:business_master_new
loadtime:0.25459098815918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kosciusko' limit 1
loadtime:0.25461411476135 / seconds
Query Executed:select id FROM `ms` where city='Kosciusko' && SIC_code='7219'DB:business_master_new
loadtime:0.25525212287903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kossuth' limit 1
loadtime:0.25528597831726 / seconds
Query Executed:select id FROM `ms` where city='Kossuth' && SIC_code='7219'DB:business_master_new
loadtime:0.25552797317505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kreole' limit 1
loadtime:0.25555205345154 / seconds
Query Executed:select id FROM `ms` where city='Kreole' && SIC_code='7219'DB:business_master_new
loadtime:0.25578808784485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake' limit 1
loadtime:0.25582098960876 / seconds
Query Executed:select id FROM `ms` where city='Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.25615000724792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Cormorant' limit 1
loadtime:0.2561731338501 / seconds
Query Executed:select id FROM `ms` where city='Lake Cormorant' && SIC_code='7219'DB:business_master_new
loadtime:0.25652718544006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeshore' limit 1
loadtime:0.25656008720398 / seconds
Query Executed:select id FROM `ms` where city='Lakeshore' && SIC_code='7219'DB:business_master_new
loadtime:0.25696301460266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamar' limit 1
loadtime:0.25699305534363 / seconds
Query Executed:select id FROM `ms` where city='Lamar' && SIC_code='7219'DB:business_master_new
loadtime:0.25746703147888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambert' limit 1
loadtime:0.25749015808105 / seconds
Query Executed:select id FROM `ms` where city='Lambert' && SIC_code='7219'DB:business_master_new
loadtime:0.257817029953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lauderdale' limit 1
loadtime:0.2578489780426 / seconds
Query Executed:select id FROM `ms` where city='Lauderdale' && SIC_code='7219'DB:business_master_new
loadtime:0.25818514823914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:0.25821614265442 / seconds
Query Executed:select id FROM `ms` where city='Laurel' && SIC_code='7219'DB:business_master_new
loadtime:0.25889110565186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrence' limit 1
loadtime:0.25893211364746 / seconds
Query Executed:select id FROM `ms` where city='Lawrence' && SIC_code='7219'DB:business_master_new
loadtime:0.25937509536743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leakesville' limit 1
loadtime:0.2594051361084 / seconds
Query Executed:select id FROM `ms` where city='Leakesville' && SIC_code='7219'DB:business_master_new
loadtime:0.26006197929382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Learned' limit 1
loadtime:0.26009511947632 / seconds
Query Executed:select id FROM `ms` where city='Learned' && SIC_code='7219'DB:business_master_new
loadtime:0.26034116744995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.26037096977234 / seconds
Query Executed:select id FROM `ms` where city='Leland' && SIC_code='7219'DB:business_master_new
loadtime:0.26102900505066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lena' limit 1
loadtime:0.26105308532715 / seconds
Query Executed:select id FROM `ms` where city='Lena' && SIC_code='7219'DB:business_master_new
loadtime:0.26138305664062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:0.26141595840454 / seconds
Query Executed:select id FROM `ms` where city='Lexington' && SIC_code='7219'DB:business_master_new
loadtime:0.26207208633423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:0.26210117340088 / seconds
Query Executed:select id FROM `ms` where city='Liberty' && SIC_code='7219'DB:business_master_new
loadtime:0.26276612281799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.26280117034912 / seconds
Query Executed:select id FROM `ms` where city='Little Rock' && SIC_code='7219'DB:business_master_new
loadtime:0.26320815086365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:0.26323103904724 / seconds
Query Executed:select id FROM `ms` where city='Long Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.26389217376709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorman' limit 1
loadtime:0.26392507553101 / seconds
Query Executed:select id FROM `ms` where city='Lorman' && SIC_code='7219'DB:business_master_new
loadtime:0.26426410675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louin' limit 1
loadtime:0.26429414749146 / seconds
Query Executed:select id FROM `ms` where city='Louin' && SIC_code='7219'DB:business_master_new
loadtime:0.26464700698853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louise' limit 1
loadtime:0.2646701335907 / seconds
Query Executed:select id FROM `ms` where city='Louise' && SIC_code='7219'DB:business_master_new
loadtime:0.26502203941345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:0.26505398750305 / seconds
Query Executed:select id FROM `ms` where city='Louisville' && SIC_code='7219'DB:business_master_new
loadtime:0.26572513580322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucedale' limit 1
loadtime:0.26575303077698 / seconds
Query Executed:select id FROM `ms` where city='Lucedale' && SIC_code='7219'DB:business_master_new
loadtime:0.26640510559082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ludlow' limit 1
loadtime:0.26643705368042 / seconds
Query Executed:select id FROM `ms` where city='Ludlow' && SIC_code='7219'DB:business_master_new
loadtime:0.26668095588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lula' limit 1
loadtime:0.26670408248901 / seconds
Query Executed:select id FROM `ms` where city='Lula' && SIC_code='7219'DB:business_master_new
loadtime:0.26701211929321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:0.26704597473145 / seconds
Query Executed:select id FROM `ms` where city='Lumberton' && SIC_code='7219'DB:business_master_new
loadtime:0.26769995689392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyon' limit 1
loadtime:0.26772308349609 / seconds
Query Executed:select id FROM `ms` where city='Lyon' && SIC_code='7219'DB:business_master_new
loadtime:0.26804900169373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maben' limit 1
loadtime:0.26807999610901 / seconds
Query Executed:select id FROM `ms` where city='Maben' && SIC_code='7219'DB:business_master_new
loadtime:0.26842904090881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:0.26847100257874 / seconds
Query Executed:select id FROM `ms` where city='Macon' && SIC_code='7219'DB:business_master_new
loadtime:0.26911211013794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madden' limit 1
loadtime:0.26913499832153 / seconds
Query Executed:select id FROM `ms` where city='Madden' && SIC_code='7219'DB:business_master_new
loadtime:0.26944208145142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.26948404312134 / seconds
Query Executed:select id FROM `ms` where city='Madison' && SIC_code='7219'DB:business_master_new
loadtime:0.2701301574707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magee' limit 1
loadtime:0.27015995979309 / seconds
Query Executed:select id FROM `ms` where city='Magee' && SIC_code='7219'DB:business_master_new
loadtime:0.27082705497742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.27086114883423 / seconds
Query Executed:select id FROM `ms` where city='Magnolia' && SIC_code='7219'DB:business_master_new
loadtime:0.27152514457703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantachie' limit 1
loadtime:0.27154898643494 / seconds
Query Executed:select id FROM `ms` where city='Mantachie' && SIC_code='7219'DB:business_master_new
loadtime:0.27191400527954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantee' limit 1
loadtime:0.27194714546204 / seconds
Query Executed:select id FROM `ms` where city='Mantee' && SIC_code='7219'DB:business_master_new
loadtime:0.27226305007935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:0.27228617668152 / seconds
Query Executed:select id FROM `ms` where city='Marietta' && SIC_code='7219'DB:business_master_new
loadtime:0.27262401580811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.27265596389771 / seconds
Query Executed:select id FROM `ms` where city='Marion' && SIC_code='7219'DB:business_master_new
loadtime:0.27299213409424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marks' limit 1
loadtime:0.27302217483521 / seconds
Query Executed:select id FROM `ms` where city='Marks' && SIC_code='7219'DB:business_master_new
loadtime:0.273686170578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathiston' limit 1
loadtime:0.2737090587616 / seconds
Query Executed:select id FROM `ms` where city='Mathiston' && SIC_code='7219'DB:business_master_new
loadtime:0.27403998374939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mattson' limit 1
loadtime:0.27407312393188 / seconds
Query Executed:select id FROM `ms` where city='Mattson' && SIC_code='7219'DB:business_master_new
loadtime:0.27432513237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayersville' limit 1
loadtime:0.27434897422791 / seconds
Query Executed:select id FROM `ms` where city='Mayersville' && SIC_code='7219'DB:business_master_new
loadtime:0.27469611167908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayhew' limit 1
loadtime:0.27472901344299 / seconds
Query Executed:select id FROM `ms` where city='Mayhew' && SIC_code='7219'DB:business_master_new
loadtime:0.27507615089417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adams' limit 1
loadtime:0.27509903907776 / seconds
Query Executed:select id FROM `ms` where city='Mc Adams' && SIC_code='7219'DB:business_master_new
loadtime:0.27539896965027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Call Creek' limit 1
loadtime:0.27542805671692 / seconds
Query Executed:select id FROM `ms` where city='Mc Call Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.27574896812439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Carley' limit 1
loadtime:0.27577209472656 / seconds
Query Executed:select id FROM `ms` where city='Mc Carley' && SIC_code='7219'DB:business_master_new
loadtime:0.27602410316467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Comb' limit 1
loadtime:0.27605509757996 / seconds
Query Executed:select id FROM `ms` where city='Mc Comb' && SIC_code='7219'DB:business_master_new
loadtime:0.27636694908142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Cool' limit 1
loadtime:0.27639603614807 / seconds
Query Executed:select id FROM `ms` where city='Mc Cool' && SIC_code='7219'DB:business_master_new
loadtime:0.27672600746155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Henry' limit 1
loadtime:0.27675008773804 / seconds
Query Executed:select id FROM `ms` where city='Mc Henry' && SIC_code='7219'DB:business_master_new
loadtime:0.27707195281982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Lain' limit 1
loadtime:0.277104139328 / seconds
Query Executed:select id FROM `ms` where city='Mc Lain' && SIC_code='7219'DB:business_master_new
loadtime:0.27743411064148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neill' limit 1
loadtime:0.27746915817261 / seconds
Query Executed:select id FROM `ms` where city='Mc Neill' && SIC_code='7219'DB:business_master_new
loadtime:0.27790403366089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccomb' limit 1
loadtime:0.2779381275177 / seconds
Query Executed:select id FROM `ms` where city='Mccomb' && SIC_code='7219'DB:business_master_new
loadtime:0.27860808372498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadville' limit 1
loadtime:0.27863097190857 / seconds
Query Executed:select id FROM `ms` where city='Meadville' && SIC_code='7219'DB:business_master_new
loadtime:0.2792820930481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendenhall' limit 1
loadtime:0.27931499481201 / seconds
Query Executed:select id FROM `ms` where city='Mendenhall' && SIC_code='7219'DB:business_master_new
loadtime:0.27998208999634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meridian' limit 1
loadtime:0.28000617027283 / seconds
Query Executed:select id FROM `ms` where city='Meridian' && SIC_code='7219'DB:business_master_new
loadtime:0.2806670665741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merigold' limit 1
loadtime:0.28070616722107 / seconds
Query Executed:select id FROM `ms` where city='Merigold' && SIC_code='7219'DB:business_master_new
loadtime:0.28103399276733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metcalfe' limit 1
loadtime:0.2810640335083 / seconds
Query Executed:select id FROM `ms` where city='Metcalfe' && SIC_code='7219'DB:business_master_new
loadtime:0.28143405914307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Michigan City' limit 1
loadtime:0.28146910667419 / seconds
Query Executed:select id FROM `ms` where city='Michigan City' && SIC_code='7219'DB:business_master_new
loadtime:0.28179907798767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midnight' limit 1
loadtime:0.28183102607727 / seconds
Query Executed:select id FROM `ms` where city='Midnight' && SIC_code='7219'DB:business_master_new
loadtime:0.28210997581482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Wells' limit 1
loadtime:0.28213310241699 / seconds
Query Executed:select id FROM `ms` where city='Mineral Wells' && SIC_code='7219'DB:business_master_new
loadtime:0.28238201141357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minter City' limit 1
loadtime:0.28241109848022 / seconds
Query Executed:select id FROM `ms` where city='Minter City' && SIC_code='7219'DB:business_master_new
loadtime:0.2827479839325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miss State' limit 1
loadtime:0.28277206420898 / seconds
Query Executed:select id FROM `ms` where city='Miss State' && SIC_code='7219'DB:business_master_new
loadtime:0.28299999237061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mississippi State' limit 1
loadtime:0.2830331325531 / seconds
Query Executed:select id FROM `ms` where city='Mississippi State' && SIC_code='7219'DB:business_master_new
loadtime:0.28341603279114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mize' limit 1
loadtime:0.28345608711243 / seconds
Query Executed:select id FROM `ms` where city='Mize' && SIC_code='7219'DB:business_master_new
loadtime:0.28381896018982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Money' limit 1
loadtime:0.28384208679199 / seconds
Query Executed:select id FROM `ms` where city='Money' && SIC_code='7219'DB:business_master_new
loadtime:0.28408408164978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.28411507606506 / seconds
Query Executed:select id FROM `ms` where city='Monticello' && SIC_code='7219'DB:business_master_new
loadtime:0.28477597236633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.28479909896851 / seconds
Query Executed:select id FROM `ms` where city='Montpelier' && SIC_code='7219'DB:business_master_new
loadtime:0.28506016731262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooreville' limit 1
loadtime:0.28509211540222 / seconds
Query Executed:select id FROM `ms` where city='Mooreville' && SIC_code='7219'DB:business_master_new
loadtime:0.2854540348053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:0.28547811508179 / seconds
Query Executed:select id FROM `ms` where city='Moorhead' && SIC_code='7219'DB:business_master_new
loadtime:0.28580713272095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan City' limit 1
loadtime:0.28584003448486 / seconds
Query Executed:select id FROM `ms` where city='Morgan City' && SIC_code='7219'DB:business_master_new
loadtime:0.28618407249451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morton' limit 1
loadtime:0.28621697425842 / seconds
Query Executed:select id FROM `ms` where city='Morton' && SIC_code='7219'DB:business_master_new
loadtime:0.28687214851379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moselle' limit 1
loadtime:0.28690505027771 / seconds
Query Executed:select id FROM `ms` where city='Moselle' && SIC_code='7219'DB:business_master_new
loadtime:0.28723502159119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss' limit 1
loadtime:0.28726410865784 / seconds
Query Executed:select id FROM `ms` where city='Moss' && SIC_code='7219'DB:business_master_new
loadtime:0.28754115104675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moss Point' limit 1
loadtime:0.28756403923035 / seconds
Query Executed:select id FROM `ms` where city='Moss Point' && SIC_code='7219'DB:business_master_new
loadtime:0.28821706771851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mound Bayou' limit 1
loadtime:0.28824901580811 / seconds
Query Executed:select id FROM `ms` where city='Mound Bayou' && SIC_code='7219'DB:business_master_new
loadtime:0.28863406181335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:0.28865694999695 / seconds
Query Executed:select id FROM `ms` where city='Mount Olive' && SIC_code='7219'DB:business_master_new
loadtime:0.2890191078186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.2890510559082 / seconds
Query Executed:select id FROM `ms` where city='Mount Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:0.28935503959656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:0.28937816619873 / seconds
Query Executed:select id FROM `ms` where city='Mt Olive' && SIC_code='7219'DB:business_master_new
loadtime:0.28961300849915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.28964614868164 / seconds
Query Executed:select id FROM `ms` where city='Mt Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:0.28986001014709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtle' limit 1
loadtime:0.28988409042358 / seconds
Query Executed:select id FROM `ms` where city='Myrtle' && SIC_code='7219'DB:business_master_new
loadtime:0.29021501541138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nas Meridian' limit 1
loadtime:0.29024600982666 / seconds
Query Executed:select id FROM `ms` where city='Nas Meridian' && SIC_code='7219'DB:business_master_new
loadtime:0.29049706459045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natchez' limit 1
loadtime:0.29052996635437 / seconds
Query Executed:select id FROM `ms` where city='Natchez' && SIC_code='7219'DB:business_master_new
loadtime:0.29117798805237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neely' limit 1
loadtime:0.29120802879333 / seconds
Query Executed:select id FROM `ms` where city='Neely' && SIC_code='7219'DB:business_master_new
loadtime:0.29153800010681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nesbit' limit 1
loadtime:0.29157114028931 / seconds
Query Executed:select id FROM `ms` where city='Nesbit' && SIC_code='7219'DB:business_master_new
loadtime:0.29194498062134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nettleton' limit 1
loadtime:0.29196810722351 / seconds
Query Executed:select id FROM `ms` where city='Nettleton' && SIC_code='7219'DB:business_master_new
loadtime:0.29233908653259 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albany' limit 1
loadtime:0.29236817359924 / seconds
Query Executed:select id FROM `ms` where city='New Albany' && SIC_code='7219'DB:business_master_new
loadtime:0.29303503036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Augusta' limit 1
loadtime:0.2930600643158 / seconds
Query Executed:select id FROM `ms` where city='New Augusta' && SIC_code='7219'DB:business_master_new
loadtime:0.29343199729919 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Site' limit 1
loadtime:0.2934730052948 / seconds
Query Executed:select id FROM `ms` where city='New Site' && SIC_code='7219'DB:business_master_new
loadtime:0.29387307167053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhebron' limit 1
loadtime:0.29389715194702 / seconds
Query Executed:select id FROM `ms` where city='Newhebron' && SIC_code='7219'DB:business_master_new
loadtime:0.29426097869873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.29429006576538 / seconds
Query Executed:select id FROM `ms` where city='Newton' && SIC_code='7219'DB:business_master_new
loadtime:0.29495000839233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nicholson' limit 1
loadtime:0.29498195648193 / seconds
Query Executed:select id FROM `ms` where city='Nicholson' && SIC_code='7219'DB:business_master_new
loadtime:0.29538416862488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nitta Yuma' limit 1
loadtime:0.29540705680847 / seconds
Query Executed:select id FROM `ms` where city='Nitta Yuma' && SIC_code='7219'DB:business_master_new
loadtime:0.2956600189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Carrollton' limit 1
loadtime:0.2956919670105 / seconds
Query Executed:select id FROM `ms` where city='North Carrollton' && SIC_code='7219'DB:business_master_new
loadtime:0.29740595817566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Noxapater' limit 1
loadtime:0.29743599891663 / seconds
Query Executed:select id FROM `ms` where city='Noxapater' && SIC_code='7219'DB:business_master_new
loadtime:0.29780507087708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Vale' limit 1
loadtime:0.29784798622131 / seconds
Query Executed:select id FROM `ms` where city='Oak Vale' && SIC_code='7219'DB:business_master_new
loadtime:0.29825711250305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:0.29828095436096 / seconds
Query Executed:select id FROM `ms` where city='Oakland' && SIC_code='7219'DB:business_master_new
loadtime:0.29864406585693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Springs' limit 1
loadtime:0.29867696762085 / seconds
Query Executed:select id FROM `ms` where city='Ocean Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.29935002326965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okolona' limit 1
loadtime:0.2993791103363 / seconds
Query Executed:select id FROM `ms` where city='Okolona' && SIC_code='7219'DB:business_master_new
loadtime:0.30005097389221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olive Branch' limit 1
loadtime:0.3000750541687 / seconds
Query Executed:select id FROM `ms` where city='Olive Branch' && SIC_code='7219'DB:business_master_new
loadtime:0.30074214935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osyka' limit 1
loadtime:0.30078101158142 / seconds
Query Executed:select id FROM `ms` where city='Osyka' && SIC_code='7219'DB:business_master_new
loadtime:0.30114316940308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ovett' limit 1
loadtime:0.30116605758667 / seconds
Query Executed:select id FROM `ms` where city='Ovett' && SIC_code='7219'DB:business_master_new
loadtime:0.3014931678772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.30152606964111 / seconds
Query Executed:select id FROM `ms` where city='Oxford' && SIC_code='7219'DB:business_master_new
loadtime:0.30217099189758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pace' limit 1
loadtime:0.30221009254456 / seconds
Query Executed:select id FROM `ms` where city='Pace' && SIC_code='7219'DB:business_master_new
loadtime:0.30258297920227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pachuta' limit 1
loadtime:0.30261611938477 / seconds
Query Executed:select id FROM `ms` where city='Pachuta' && SIC_code='7219'DB:business_master_new
loadtime:0.30295205116272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panther Burn' limit 1
loadtime:0.30297613143921 / seconds
Query Executed:select id FROM `ms` where city='Panther Burn' && SIC_code='7219'DB:business_master_new
loadtime:0.30321407318115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parchman' limit 1
loadtime:0.30324506759644 / seconds
Query Executed:select id FROM `ms` where city='Parchman' && SIC_code='7219'DB:business_master_new
loadtime:0.30351901054382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paris' limit 1
loadtime:0.30355310440063 / seconds
Query Executed:select id FROM `ms` where city='Paris' && SIC_code='7219'DB:business_master_new
loadtime:0.30379199981689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pascagoula' limit 1
loadtime:0.30381512641907 / seconds
Query Executed:select id FROM `ms` where city='Pascagoula' && SIC_code='7219'DB:business_master_new
loadtime:0.30447316169739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pass Christian' limit 1
loadtime:0.30450701713562 / seconds
Query Executed:select id FROM `ms` where city='Pass Christian' && SIC_code='7219'DB:business_master_new
loadtime:0.3051540851593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pattison' limit 1
loadtime:0.30517816543579 / seconds
Query Executed:select id FROM `ms` where city='Pattison' && SIC_code='7219'DB:business_master_new
loadtime:0.30559301376343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulding' limit 1
loadtime:0.30562496185303 / seconds
Query Executed:select id FROM `ms` where city='Paulding' && SIC_code='7219'DB:business_master_new
loadtime:0.30591702461243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl' limit 1
loadtime:0.3059401512146 / seconds
Query Executed:select id FROM `ms` where city='Pearl' && SIC_code='7219'DB:business_master_new
loadtime:0.30660915374756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearlington' limit 1
loadtime:0.30664300918579 / seconds
Query Executed:select id FROM `ms` where city='Pearlington' && SIC_code='7219'DB:business_master_new
loadtime:0.30698394775391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelahatchie' limit 1
loadtime:0.30700612068176 / seconds
Query Executed:select id FROM `ms` where city='Pelahatchie' && SIC_code='7219'DB:business_master_new
loadtime:0.30768299102783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perkinston' limit 1
loadtime:0.30771613121033 / seconds
Query Executed:select id FROM `ms` where city='Perkinston' && SIC_code='7219'DB:business_master_new
loadtime:0.3080940246582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petal' limit 1
loadtime:0.30812406539917 / seconds
Query Executed:select id FROM `ms` where city='Petal' && SIC_code='7219'DB:business_master_new
loadtime:0.3087899684906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pheba' limit 1
loadtime:0.30882000923157 / seconds
Query Executed:select id FROM `ms` where city='Pheba' && SIC_code='7219'DB:business_master_new
loadtime:0.30926895141602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philadelphia' limit 1
loadtime:0.30930805206299 / seconds
Query Executed:select id FROM `ms` where city='Philadelphia' && SIC_code='7219'DB:business_master_new
loadtime:0.30998396873474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Philipp' limit 1
loadtime:0.31001400947571 / seconds
Query Executed:select id FROM `ms` where city='Philipp' && SIC_code='7219'DB:business_master_new
loadtime:0.31035494804382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picayune' limit 1
loadtime:0.310387134552 / seconds
Query Executed:select id FROM `ms` where city='Picayune' && SIC_code='7219'DB:business_master_new
loadtime:0.31106996536255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pickens' limit 1
loadtime:0.31109404563904 / seconds
Query Executed:select id FROM `ms` where city='Pickens' && SIC_code='7219'DB:business_master_new
loadtime:0.31146311759949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Woods' limit 1
loadtime:0.31150507926941 / seconds
Query Executed:select id FROM `ms` where city='Piney Woods' && SIC_code='7219'DB:business_master_new
loadtime:0.31175518035889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinola' limit 1
loadtime:0.31177806854248 / seconds
Query Executed:select id FROM `ms` where city='Pinola' && SIC_code='7219'DB:business_master_new
loadtime:0.31210017204285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:0.31213116645813 / seconds
Query Executed:select id FROM `ms` where city='Pittsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.3124680519104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantersville' limit 1
loadtime:0.31250095367432 / seconds
Query Executed:select id FROM `ms` where city='Plantersville' && SIC_code='7219'DB:business_master_new
loadtime:0.31284999847412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:0.31287407875061 / seconds
Query Executed:select id FROM `ms` where city='Pocahontas' && SIC_code='7219'DB:business_master_new
loadtime:0.31309604644775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pontotoc' limit 1
loadtime:0.3131251335144 / seconds
Query Executed:select id FROM `ms` where city='Pontotoc' && SIC_code='7219'DB:business_master_new
loadtime:0.31378102302551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope' limit 1
loadtime:0.31381011009216 / seconds
Query Executed:select id FROM `ms` where city='Pope' && SIC_code='7219'DB:business_master_new
loadtime:0.31414103507996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplarville' limit 1
loadtime:0.31417417526245 / seconds
Query Executed:select id FROM `ms` where city='Poplarville' && SIC_code='7219'DB:business_master_new
loadtime:0.31483817100525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Gibson' limit 1
loadtime:0.31486201286316 / seconds
Query Executed:select id FROM `ms` where city='Port Gibson' && SIC_code='7219'DB:business_master_new
loadtime:0.31552410125732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Porterville' limit 1
loadtime:0.31555914878845 / seconds
Query Executed:select id FROM `ms` where city='Porterville' && SIC_code='7219'DB:business_master_new
loadtime:0.31584501266479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potts Camp' limit 1
loadtime:0.31587600708008 / seconds
Query Executed:select id FROM `ms` where city='Potts Camp' && SIC_code='7219'DB:business_master_new
loadtime:0.31620597839355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie' limit 1
loadtime:0.31622910499573 / seconds
Query Executed:select id FROM `ms` where city='Prairie' && SIC_code='7219'DB:business_master_new
loadtime:0.31656908988953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prentiss' limit 1
loadtime:0.31660914421082 / seconds
Query Executed:select id FROM `ms` where city='Prentiss' && SIC_code='7219'DB:business_master_new
loadtime:0.31725716590881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.31728005409241 / seconds
Query Executed:select id FROM `ms` where city='Preston' && SIC_code='7219'DB:business_master_new
loadtime:0.31761598587036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puckett' limit 1
loadtime:0.31764817237854 / seconds
Query Executed:select id FROM `ms` where city='Puckett' && SIC_code='7219'DB:business_master_new
loadtime:0.31797099113464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:0.31799411773682 / seconds
Query Executed:select id FROM `ms` where city='Pulaski' && SIC_code='7219'DB:business_master_new
loadtime:0.31835913658142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purvis' limit 1
loadtime:0.31838798522949 / seconds
Query Executed:select id FROM `ms` where city='Purvis' && SIC_code='7219'DB:business_master_new
loadtime:0.31905508041382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quitman' limit 1
loadtime:0.31908011436462 / seconds
Query Executed:select id FROM `ms` where city='Quitman' && SIC_code='7219'DB:business_master_new
loadtime:0.31973910331726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:0.31977200508118 / seconds
Query Executed:select id FROM `ms` where city='Raleigh' && SIC_code='7219'DB:business_master_new
loadtime:0.32041907310486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.32045912742615 / seconds
Query Executed:select id FROM `ms` where city='Randolph' && SIC_code='7219'DB:business_master_new
loadtime:0.32079005241394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.32081317901611 / seconds
Query Executed:select id FROM `ms` where city='Raymond' && SIC_code='7219'DB:business_master_new
loadtime:0.32146596908569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Banks' limit 1
loadtime:0.32149910926819 / seconds
Query Executed:select id FROM `ms` where city='Red Banks' && SIC_code='7219'DB:business_master_new
loadtime:0.32184195518494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redwood' limit 1
loadtime:0.32186603546143 / seconds
Query Executed:select id FROM `ms` where city='Redwood' && SIC_code='7219'DB:business_master_new
loadtime:0.32220196723938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rena Lara' limit 1
loadtime:0.32223200798035 / seconds
Query Executed:select id FROM `ms` where city='Rena Lara' && SIC_code='7219'DB:business_master_new
loadtime:0.3226170539856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.32264018058777 / seconds
Query Executed:select id FROM `ms` where city='Richland' && SIC_code='7219'DB:business_master_new
loadtime:0.32328200340271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richton' limit 1
loadtime:0.32331609725952 / seconds
Query Executed:select id FROM `ms` where city='Richton' && SIC_code='7219'DB:business_master_new
loadtime:0.32399010658264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeland' limit 1
loadtime:0.32401299476624 / seconds
Query Executed:select id FROM `ms` where city='Ridgeland' && SIC_code='7219'DB:business_master_new
loadtime:0.3246750831604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rienzi' limit 1
loadtime:0.32471609115601 / seconds
Query Executed:select id FROM `ms` where city='Rienzi' && SIC_code='7219'DB:business_master_new
loadtime:0.3250560760498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ripley' limit 1
loadtime:0.32508611679077 / seconds
Query Executed:select id FROM `ms` where city='Ripley' && SIC_code='7219'DB:business_master_new
loadtime:0.32575011253357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robinsonville' limit 1
loadtime:0.32577395439148 / seconds
Query Executed:select id FROM `ms` where city='Robinsonville' && SIC_code='7219'DB:business_master_new
loadtime:0.32644200325012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolling Fork' limit 1
loadtime:0.32648396492004 / seconds
Query Executed:select id FROM `ms` where city='Rolling Fork' && SIC_code='7219'DB:business_master_new
loadtime:0.32713198661804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:0.32715702056885 / seconds
Query Executed:select id FROM `ms` where city='Rome' && SIC_code='7219'DB:business_master_new
loadtime:0.32739496231079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:0.32742500305176 / seconds
Query Executed:select id FROM `ms` where city='Rose Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.32783317565918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosedale' limit 1
loadtime:0.32785606384277 / seconds
Query Executed:select id FROM `ms` where city='Rosedale' && SIC_code='7219'DB:business_master_new
loadtime:0.32820105552673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxie' limit 1
loadtime:0.32824206352234 / seconds
Query Executed:select id FROM `ms` where city='Roxie' && SIC_code='7219'DB:business_master_new
loadtime:0.32860517501831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruleville' limit 1
loadtime:0.32862901687622 / seconds
Query Executed:select id FROM `ms` where city='Ruleville' && SIC_code='7219'DB:business_master_new
loadtime:0.32897901535034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruth' limit 1
loadtime:0.32901096343994 / seconds
Query Executed:select id FROM `ms` where city='Ruth' && SIC_code='7219'DB:business_master_new
loadtime:0.32935810089111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sallis' limit 1
loadtime:0.32938814163208 / seconds
Query Executed:select id FROM `ms` where city='Sallis' && SIC_code='7219'DB:business_master_new
loadtime:0.3297221660614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saltillo' limit 1
loadtime:0.32974600791931 / seconds
Query Executed:select id FROM `ms` where city='Saltillo' && SIC_code='7219'DB:business_master_new
loadtime:0.33040499687195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanatorium' limit 1
loadtime:0.33045601844788 / seconds
Query Executed:select id FROM `ms` where city='Sanatorium' && SIC_code='7219'DB:business_master_new
loadtime:0.33070397377014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandersville' limit 1
loadtime:0.33072805404663 / seconds
Query Executed:select id FROM `ms` where city='Sandersville' && SIC_code='7219'DB:business_master_new
loadtime:0.33107614517212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandhill' limit 1
loadtime:0.33110809326172 / seconds
Query Executed:select id FROM `ms` where city='Sandhill' && SIC_code='7219'DB:business_master_new
loadtime:0.3313889503479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.33141207695007 / seconds
Query Executed:select id FROM `ms` where city='Sandy Hook' && SIC_code='7219'DB:business_master_new
loadtime:0.33174014091492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanitorium' limit 1
loadtime:0.33177304267883 / seconds
Query Executed:select id FROM `ms` where city='Sanitorium' && SIC_code='7219'DB:business_master_new
loadtime:0.33199214935303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sarah' limit 1
loadtime:0.33201599121094 / seconds
Query Executed:select id FROM `ms` where city='Sarah' && SIC_code='7219'DB:business_master_new
loadtime:0.33233499526978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardis' limit 1
loadtime:0.33236408233643 / seconds
Query Executed:select id FROM `ms` where city='Sardis' && SIC_code='7219'DB:business_master_new
loadtime:0.33302998542786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satartia' limit 1
loadtime:0.33306407928467 / seconds
Query Executed:select id FROM `ms` where city='Satartia' && SIC_code='7219'DB:business_master_new
loadtime:0.33340811729431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saucier' limit 1
loadtime:0.33343195915222 / seconds
Query Executed:select id FROM `ms` where city='Saucier' && SIC_code='7219'DB:business_master_new
loadtime:0.33408713340759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schlater' limit 1
loadtime:0.33412003517151 / seconds
Query Executed:select id FROM `ms` where city='Schlater' && SIC_code='7219'DB:business_master_new
loadtime:0.33448600769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scobey' limit 1
loadtime:0.33451795578003 / seconds
Query Executed:select id FROM `ms` where city='Scobey' && SIC_code='7219'DB:business_master_new
loadtime:0.33489513397217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scooba' limit 1
loadtime:0.33492803573608 / seconds
Query Executed:select id FROM `ms` where city='Scooba' && SIC_code='7219'DB:business_master_new
loadtime:0.33526706695557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scott' limit 1
loadtime:0.33528995513916 / seconds
Query Executed:select id FROM `ms` where city='Scott' && SIC_code='7219'DB:business_master_new
loadtime:0.33569407463074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sebastopol' limit 1
loadtime:0.33572697639465 / seconds
Query Executed:select id FROM `ms` where city='Sebastopol' && SIC_code='7219'DB:business_master_new
loadtime:0.33608818054199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seminary' limit 1
loadtime:0.33611798286438 / seconds
Query Executed:select id FROM `ms` where city='Seminary' && SIC_code='7219'DB:business_master_new
loadtime:0.33649611473083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Senatobia' limit 1
loadtime:0.33651995658875 / seconds
Query Executed:select id FROM `ms` where city='Senatobia' && SIC_code='7219'DB:business_master_new
loadtime:0.33716797828674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:0.33720016479492 / seconds
Query Executed:select id FROM `ms` where city='Shannon' && SIC_code='7219'DB:business_master_new
loadtime:0.33759713172913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.33762097358704 / seconds
Query Executed:select id FROM `ms` where city='Sharon' && SIC_code='7219'DB:business_master_new
loadtime:0.33790302276611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shaw' limit 1
loadtime:0.33793497085571 / seconds
Query Executed:select id FROM `ms` where city='Shaw' && SIC_code='7219'DB:business_master_new
loadtime:0.33830714225769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:0.33833003044128 / seconds
Query Executed:select id FROM `ms` where city='Shelby' && SIC_code='7219'DB:business_master_new
loadtime:0.33867907524109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherard' limit 1
loadtime:0.338711977005 / seconds
Query Executed:select id FROM `ms` where city='Sherard' && SIC_code='7219'DB:business_master_new
loadtime:0.33899998664856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.33902311325073 / seconds
Query Executed:select id FROM `ms` where city='Sherman' && SIC_code='7219'DB:business_master_new
loadtime:0.33935618400574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shubuta' limit 1
loadtime:0.33938717842102 / seconds
Query Executed:select id FROM `ms` where city='Shubuta' && SIC_code='7219'DB:business_master_new
loadtime:0.33972811698914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shuqualak' limit 1
loadtime:0.33976006507874 / seconds
Query Executed:select id FROM `ms` where city='Shuqualak' && SIC_code='7219'DB:business_master_new
loadtime:0.34008502960205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:0.34010910987854 / seconds
Query Executed:select id FROM `ms` where city='Sibley' && SIC_code='7219'DB:business_master_new
loadtime:0.34039115905762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidon' limit 1
loadtime:0.34042000770569 / seconds
Query Executed:select id FROM `ms` where city='Sidon' && SIC_code='7219'DB:business_master_new
loadtime:0.3408100605011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.34083414077759 / seconds
Query Executed:select id FROM `ms` where city='Silver City' && SIC_code='7219'DB:business_master_new
loadtime:0.34119606018066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Creek' limit 1
loadtime:0.34122800827026 / seconds
Query Executed:select id FROM `ms` where city='Silver Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.34156703948975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slate Spring' limit 1
loadtime:0.34159111976624 / seconds
Query Executed:select id FROM `ms` where city='Slate Spring' && SIC_code='7219'DB:business_master_new
loadtime:0.34182214736938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sledge' limit 1
loadtime:0.3418550491333 / seconds
Query Executed:select id FROM `ms` where city='Sledge' && SIC_code='7219'DB:business_master_new
loadtime:0.34217309951782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithdale' limit 1
loadtime:0.34220409393311 / seconds
Query Executed:select id FROM `ms` where city='Smithdale' && SIC_code='7219'DB:business_master_new
loadtime:0.34254908561707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:0.34258198738098 / seconds
Query Executed:select id FROM `ms` where city='Smithville' && SIC_code='7219'DB:business_master_new
loadtime:0.34293818473816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sontag' limit 1
loadtime:0.34296798706055 / seconds
Query Executed:select id FROM `ms` where city='Sontag' && SIC_code='7219'DB:business_master_new
loadtime:0.34329295158386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soso' limit 1
loadtime:0.34331607818604 / seconds
Query Executed:select id FROM `ms` where city='Soso' && SIC_code='7219'DB:business_master_new
loadtime:0.34366512298584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southaven' limit 1
loadtime:0.34370613098145 / seconds
Query Executed:select id FROM `ms` where city='Southaven' && SIC_code='7219'DB:business_master_new
loadtime:0.34436106681824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:0.34438395500183 / seconds
Query Executed:select id FROM `ms` where city='Star' && SIC_code='7219'DB:business_master_new
loadtime:0.34478497505188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Starkville' limit 1
loadtime:0.34481716156006 / seconds
Query Executed:select id FROM `ms` where city='Starkville' && SIC_code='7219'DB:business_master_new
loadtime:0.34546899795532 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Line' limit 1
loadtime:0.34549903869629 / seconds
Query Executed:select id FROM `ms` where city='State Line' && SIC_code='7219'DB:business_master_new
loadtime:0.34582805633545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steens' limit 1
loadtime:0.34586000442505 / seconds
Query Executed:select id FROM `ms` where city='Steens' && SIC_code='7219'DB:business_master_new
loadtime:0.34620213508606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Space Center' limit 1
loadtime:0.34623312950134 / seconds
Query Executed:select id FROM `ms` where city='Stennis Space Center' && SIC_code='7219'DB:business_master_new
loadtime:0.34668397903442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stennis Spc Ctr' limit 1
loadtime:0.34670805931091 / seconds
Query Executed:select id FROM `ms` where city='Stennis Spc Ctr' && SIC_code='7219'DB:business_master_new
loadtime:0.34694910049438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewart' limit 1
loadtime:0.3469820022583 / seconds
Query Executed:select id FROM `ms` where city='Stewart' && SIC_code='7219'DB:business_master_new
loadtime:0.34728312492371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:0.3473060131073 / seconds
Query Executed:select id FROM `ms` where city='Stoneville' && SIC_code='7219'DB:business_master_new
loadtime:0.34763813018799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:0.34767317771912 / seconds
Query Executed:select id FROM `ms` where city='Stonewall' && SIC_code='7219'DB:business_master_new
loadtime:0.34799408912659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stringer' limit 1
loadtime:0.34801697731018 / seconds
Query Executed:select id FROM `ms` where city='Stringer' && SIC_code='7219'DB:business_master_new
loadtime:0.34833908081055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sturgis' limit 1
loadtime:0.34836912155151 / seconds
Query Executed:select id FROM `ms` where city='Sturgis' && SIC_code='7219'DB:business_master_new
loadtime:0.34872817993164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.34875106811523 / seconds
Query Executed:select id FROM `ms` where city='Summit' && SIC_code='7219'DB:business_master_new
loadtime:0.34939312934875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:0.34942698478699 / seconds
Query Executed:select id FROM `ms` where city='Sumner' && SIC_code='7219'DB:business_master_new
loadtime:0.34979510307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumrall' limit 1
loadtime:0.34982895851135 / seconds
Query Executed:select id FROM `ms` where city='Sumrall' && SIC_code='7219'DB:business_master_new
loadtime:0.35048913955688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunflower' limit 1
loadtime:0.35051298141479 / seconds
Query Executed:select id FROM `ms` where city='Sunflower' && SIC_code='7219'DB:business_master_new
loadtime:0.35084414482117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan Lake' limit 1
loadtime:0.35087609291077 / seconds
Query Executed:select id FROM `ms` where city='Swan Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.3511209487915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swiftown' limit 1
loadtime:0.35114407539368 / seconds
Query Executed:select id FROM `ms` where city='Swiftown' && SIC_code='7219'DB:business_master_new
loadtime:0.35138511657715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:0.35141396522522 / seconds
Query Executed:select id FROM `ms` where city='Taylor' && SIC_code='7219'DB:business_master_new
loadtime:0.3517861366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:0.35180997848511 / seconds
Query Executed:select id FROM `ms` where city='Taylorsville' && SIC_code='7219'DB:business_master_new
loadtime:0.35219216346741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tchula' limit 1
loadtime:0.35222506523132 / seconds
Query Executed:select id FROM `ms` where city='Tchula' && SIC_code='7219'DB:business_master_new
loadtime:0.35259604454041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terry' limit 1
loadtime:0.35262012481689 / seconds
Query Executed:select id FROM `ms` where city='Terry' && SIC_code='7219'DB:business_master_new
loadtime:0.35326218605042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thaxton' limit 1
loadtime:0.35329604148865 / seconds
Query Executed:select id FROM `ms` where city='Thaxton' && SIC_code='7219'DB:business_master_new
loadtime:0.35363912582397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomastown' limit 1
loadtime:0.35367202758789 / seconds
Query Executed:select id FROM `ms` where city='Thomastown' && SIC_code='7219'DB:business_master_new
loadtime:0.35397100448608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tie Plant' limit 1
loadtime:0.35399413108826 / seconds
Query Executed:select id FROM `ms` where city='Tie Plant' && SIC_code='7219'DB:business_master_new
loadtime:0.35425400733948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillatoba' limit 1
loadtime:0.35428404808044 / seconds
Query Executed:select id FROM `ms` where city='Tillatoba' && SIC_code='7219'DB:business_master_new
loadtime:0.35466909408569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinsley' limit 1
loadtime:0.35469317436218 / seconds
Query Executed:select id FROM `ms` where city='Tinsley' && SIC_code='7219'DB:business_master_new
loadtime:0.354984998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiplersville' limit 1
loadtime:0.3550181388855 / seconds
Query Executed:select id FROM `ms` where city='Tiplersville' && SIC_code='7219'DB:business_master_new
loadtime:0.35538697242737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tippo' limit 1
loadtime:0.35541009902954 / seconds
Query Executed:select id FROM `ms` where city='Tippo' && SIC_code='7219'DB:business_master_new
loadtime:0.35569906234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tishomingo' limit 1
loadtime:0.35573101043701 / seconds
Query Executed:select id FROM `ms` where city='Tishomingo' && SIC_code='7219'DB:business_master_new
loadtime:0.35607004165649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toccopola' limit 1
loadtime:0.35609197616577 / seconds
Query Executed:select id FROM `ms` where city='Toccopola' && SIC_code='7219'DB:business_master_new
loadtime:0.35637903213501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toomsuba' limit 1
loadtime:0.35641503334045 / seconds
Query Executed:select id FROM `ms` where city='Toomsuba' && SIC_code='7219'DB:business_master_new
loadtime:0.35677313804626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tougaloo' limit 1
loadtime:0.35680508613586 / seconds
Query Executed:select id FROM `ms` where city='Tougaloo' && SIC_code='7219'DB:business_master_new
loadtime:0.35712003707886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trebloc' limit 1
loadtime:0.35714411735535 / seconds
Query Executed:select id FROM `ms` where city='Trebloc' && SIC_code='7219'DB:business_master_new
loadtime:0.35738110542297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremont' limit 1
loadtime:0.35740995407104 / seconds
Query Executed:select id FROM `ms` where city='Tremont' && SIC_code='7219'DB:business_master_new
loadtime:0.35774707794189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tula' limit 1
loadtime:0.35776996612549 / seconds
Query Executed:select id FROM `ms` where city='Tula' && SIC_code='7219'DB:business_master_new
loadtime:0.35799098014832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tunica' limit 1
loadtime:0.35802316665649 / seconds
Query Executed:select id FROM `ms` where city='Tunica' && SIC_code='7219'DB:business_master_new
loadtime:0.35870409011841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tupelo' limit 1
loadtime:0.358726978302 / seconds
Query Executed:select id FROM `ms` where city='Tupelo' && SIC_code='7219'DB:business_master_new
loadtime:0.35938096046448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tutwiler' limit 1
loadtime:0.35942316055298 / seconds
Query Executed:select id FROM `ms` where city='Tutwiler' && SIC_code='7219'DB:business_master_new
loadtime:0.35977602005005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tylertown' limit 1
loadtime:0.35980105400085 / seconds
Query Executed:select id FROM `ms` where city='Tylertown' && SIC_code='7219'DB:business_master_new
loadtime:0.36045598983765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.36048913002014 / seconds
Query Executed:select id FROM `ms` where city='Union' && SIC_code='7219'DB:business_master_new
loadtime:0.36112904548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Church' limit 1
loadtime:0.36115908622742 / seconds
Query Executed:select id FROM `ms` where city='Union Church' && SIC_code='7219'DB:business_master_new
loadtime:0.36149501800537 / seconds
Query loaded from cache:select * from geodata_geocity where city='University' limit 1
loadtime:0.36151814460754 / seconds
Query Executed:select id FROM `ms` where city='University' && SIC_code='7219'DB:business_master_new
loadtime:0.36185598373413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Utica' limit 1
loadtime:0.36189007759094 / seconds
Query Executed:select id FROM `ms` where city='Utica' && SIC_code='7219'DB:business_master_new
loadtime:0.36227416992188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaiden' limit 1
loadtime:0.36229801177979 / seconds
Query Executed:select id FROM `ms` where city='Vaiden' && SIC_code='7219'DB:business_master_new
loadtime:0.36267304420471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Park' limit 1
loadtime:0.36270713806152 / seconds
Query Executed:select id FROM `ms` where city='Valley Park' && SIC_code='7219'DB:business_master_new
loadtime:0.36299896240234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Vleet' limit 1
loadtime:0.36302208900452 / seconds
Query Executed:select id FROM `ms` where city='Van Vleet' && SIC_code='7219'DB:business_master_new
loadtime:0.36329197883606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:0.36332297325134 / seconds
Query Executed:select id FROM `ms` where city='Vance' && SIC_code='7219'DB:business_master_new
loadtime:0.36362409591675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vancleave' limit 1
loadtime:0.36366510391235 / seconds
Query Executed:select id FROM `ms` where city='Vancleave' && SIC_code='7219'DB:business_master_new
loadtime:0.3643159866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vardaman' limit 1
loadtime:0.36434006690979 / seconds
Query Executed:select id FROM `ms` where city='Vardaman' && SIC_code='7219'DB:business_master_new
loadtime:0.36473512649536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:0.36476707458496 / seconds
Query Executed:select id FROM `ms` where city='Vaughan' && SIC_code='7219'DB:business_master_new
loadtime:0.36514711380005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:0.36517000198364 / seconds
Query Executed:select id FROM `ms` where city='Verona' && SIC_code='7219'DB:business_master_new
loadtime:0.36555600166321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vicksburg' limit 1
loadtime:0.36558794975281 / seconds
Query Executed:select id FROM `ms` where city='Vicksburg' && SIC_code='7219'DB:business_master_new
loadtime:0.3662531375885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victoria' limit 1
loadtime:0.36628317832947 / seconds
Query Executed:select id FROM `ms` where city='Victoria' && SIC_code='7219'DB:business_master_new
loadtime:0.36661601066589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vossburg' limit 1
loadtime:0.36665010452271 / seconds
Query Executed:select id FROM `ms` where city='Vossburg' && SIC_code='7219'DB:business_master_new
loadtime:0.36696815490723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walls' limit 1
loadtime:0.36699104309082 / seconds
Query Executed:select id FROM `ms` where city='Walls' && SIC_code='7219'DB:business_master_new
loadtime:0.3676450252533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:0.3676769733429 / seconds
Query Executed:select id FROM `ms` where city='Walnut' && SIC_code='7219'DB:business_master_new
loadtime:0.36830902099609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Grove' limit 1
loadtime:0.36834716796875 / seconds
Query Executed:select id FROM `ms` where city='Walnut Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.3686900138855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walthall' limit 1
loadtime:0.36871409416199 / seconds
Query Executed:select id FROM `ms` where city='Walthall' && SIC_code='7219'DB:business_master_new
loadtime:0.36902809143066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.36906099319458 / seconds
Query Executed:select id FROM `ms` where city='Washington' && SIC_code='7219'DB:business_master_new
loadtime:0.36938095092773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Water Valley' limit 1
loadtime:0.36940407752991 / seconds
Query Executed:select id FROM `ms` where city='Water Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.37006211280823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.37009406089783 / seconds
Query Executed:select id FROM `ms` where city='Waterford' && SIC_code='7219'DB:business_master_new
loadtime:0.37042713165283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waveland' limit 1
loadtime:0.37046217918396 / seconds
Query Executed:select id FROM `ms` where city='Waveland' && SIC_code='7219'DB:business_master_new
loadtime:0.37111210823059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesboro' limit 1
loadtime:0.37114405632019 / seconds
Query Executed:select id FROM `ms` where city='Waynesboro' && SIC_code='7219'DB:business_master_new
loadtime:0.37180209159851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayside' limit 1
loadtime:0.37183117866516 / seconds
Query Executed:select id FROM `ms` where city='Wayside' && SIC_code='7219'DB:business_master_new
loadtime:0.37209916114807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:0.37213110923767 / seconds
Query Executed:select id FROM `ms` where city='Webb' && SIC_code='7219'DB:business_master_new
loadtime:0.37246608734131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weir' limit 1
loadtime:0.37249898910522 / seconds
Query Executed:select id FROM `ms` where city='Weir' && SIC_code='7219'DB:business_master_new
loadtime:0.37283396720886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesson' limit 1
loadtime:0.37285709381104 / seconds
Query Executed:select id FROM `ms` where city='Wesson' && SIC_code='7219'DB:business_master_new
loadtime:0.37351012229919 / seconds
Query loaded from cache:select * from geodata_geocity where city='West' limit 1
loadtime:0.37354207038879 / seconds
Query Executed:select id FROM `ms` where city='West' && SIC_code='7219'DB:business_master_new
loadtime:0.37387895584106 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:0.37390208244324 / seconds
Query Executed:select id FROM `ms` where city='West Point' && SIC_code='7219'DB:business_master_new
loadtime:0.37456202507019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler' limit 1
loadtime:0.3746030330658 / seconds
Query Executed:select id FROM `ms` where city='Wheeler' && SIC_code='7219'DB:business_master_new
loadtime:0.37490916252136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitfield' limit 1
loadtime:0.37493205070496 / seconds
Query Executed:select id FROM `ms` where city='Whitfield' && SIC_code='7219'DB:business_master_new
loadtime:0.37520313262939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiggins' limit 1
loadtime:0.37523412704468 / seconds
Query Executed:select id FROM `ms` where city='Wiggins' && SIC_code='7219'DB:business_master_new
loadtime:0.37590003013611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winona' limit 1
loadtime:0.3759241104126 / seconds
Query Executed:select id FROM `ms` where city='Winona' && SIC_code='7219'DB:business_master_new
loadtime:0.37658095359802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winstonville' limit 1
loadtime:0.37661409378052 / seconds
Query Executed:select id FROM `ms` where city='Winstonville' && SIC_code='7219'DB:business_master_new
loadtime:0.37687802314758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:0.37690806388855 / seconds
Query Executed:select id FROM `ms` where city='Winterville' && SIC_code='7219'DB:business_master_new
loadtime:0.37716317176819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:0.37718605995178 / seconds
Query Executed:select id FROM `ms` where city='Woodland' && SIC_code='7219'DB:business_master_new
loadtime:0.37752795219421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:0.37756013870239 / seconds
Query Executed:select id FROM `ms` where city='Woodville' && SIC_code='7219'DB:business_master_new
loadtime:0.3782160282135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yazoo City' limit 1
loadtime:0.3782479763031 / seconds
Query Executed:select id FROM `ms` where city='Yazoo City' && SIC_code='7219'DB:business_master_new
loadtime:0.3789050579071 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.37898802757263 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.37916016578674 / seconds
Operation template executed (chunk cache operation)
loadtime:0.37924003601074 / seconds
template override:Default
loadtime:0.37926006317139 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.38007116317749 / seconds
Template Constructed, Array Rows:49
loadtime:0.38029718399048 / seconds
TOTAL EXECUTION TIME: 0.38011
loadtime:0.38038110733032 / 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] => laundry-and-garment-services-nec [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:0.38038516044617
TOTAL KEY ARRAYS: 69