DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00011181831359863 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00056600570678711 / seconds
host not found setting manual db connection
loadtime:0.0011529922485352 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0013759136199951 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.001572847366333 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0016229152679443 / seconds
zipcode:
loadtime:0.0016398429870605 / seconds
Query Executed:select * from search_referrer where page_hash='325ee012882ed84dcb54616872bc46f4' limit 10 DB:ezrox_toadli
loadtime:0.0018668174743652 / seconds
Operation header executed (non global)
loadtime:0.0018839836120605 / seconds
Operation leaderboard executed (non global)
loadtime:0.001924991607666 / seconds
Operation square executed (non global)
loadtime:0.0019397735595703 / seconds
Operation square_bottom executed (non global)
loadtime:0.0019528865814209 / seconds
Operation smallsquare executed (non global)
loadtime:0.001964807510376 / seconds
Operation headeradright executed (non global)
loadtime:0.0019779205322266 / seconds
Operation google_analytics executed (non global)
loadtime:0.0019879341125488 / seconds
Operation topstories executed (non global)
loadtime:0.0019989013671875 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0020108222961426 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0020217895507812 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0022509098052979 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0024049282073975 / seconds
Operation categories executed (global stored into APC)
loadtime:0.002443790435791 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0025088787078857 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0025458335876465 / seconds
Template key: archive_menu pushed
loadtime:0.0025508403778076 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0025568008422852 / seconds
Template key: get_gravatar pushed
loadtime:0.0025608539581299 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.002565860748291 / seconds
*10)-10)+1 | start:0
loadtime:0.0025877952575684 / seconds
DB connected to localhost business_master_new
loadtime:0.0028748512268066 / seconds
Query Executed:select * from categories where cat_URLid='family-clothing-stores'DB:business_master_new
loadtime:0.0034189224243164 / seconds
Query stored in cache : _QUERY_www.toadli.comd35d244c5d8ce207a18815b2c8225cc1
loadtime:0.0034527778625488 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.0034868717193604 / seconds
Query Executed:select * from `ia_catmap` where sic='5651' order by city ascDB:business_master_new
loadtime:0.095436811447144 / seconds
Query stored in cache : _QUERY_www.toadli.com3870c36c133da65b39da80a7e048bb58
loadtime:0.098165988922119 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='iowa'
loadtime:0.098233938217163 / seconds
Query Executed:select sum(totalcount) as totalsum from `ia_catmap` where sic='5651'DB:business_master_new
loadtime:0.10375881195068 / seconds
Query stored in cache : _QUERY_www.toadli.comdfb83b70a0437569420830305947a988
loadtime:0.10379600524902 / seconds
981 / 11
loadtime:0.10383987426758 / seconds
Query Executed:select * from geodata_geocity where city='Ackley' limit 1DB:business_master_new
loadtime:0.10418486595154 / seconds
Query stored in cache : _QUERY_www.toadli.com86f305d9b35d15e0681a7d0103a821c6
loadtime:0.10422682762146 / seconds
Query Executed:select id FROM `ia` where city='Ackley' && SIC_code='5651'DB:business_master_new
loadtime:0.10663485527039 / seconds
Query Executed:select * from geodata_geocity where city='Ackworth' limit 1DB:business_master_new
loadtime:0.10693287849426 / seconds
Query stored in cache : _QUERY_www.toadli.com59573b6a4f0043e2bdd21a0c4301d41b
loadtime:0.10696697235107 / seconds
Query Executed:select id FROM `ia` where city='Ackworth' && SIC_code='5651'DB:business_master_new
loadtime:0.11066079139709 / seconds
Query Executed:select * from geodata_geocity where city='Adair' limit 1DB:business_master_new
loadtime:0.11097097396851 / seconds
Query stored in cache : _QUERY_www.toadli.com398a9fd90bed175e56ca74f7977332cc
loadtime:0.11102080345154 / seconds
Query Executed:select id FROM `ia` where city='Adair' && SIC_code='5651'DB:business_master_new
loadtime:0.11150288581848 / seconds
Query Executed:select * from geodata_geocity where city='Adel' limit 1DB:business_master_new
loadtime:0.11177396774292 / seconds
Query stored in cache : _QUERY_www.toadli.com4cdf1452a04b52b6e540f7a41a8a511a
loadtime:0.11180686950684 / seconds
Query Executed:select id FROM `ia` where city='Adel' && SIC_code='5651'DB:business_master_new
loadtime:0.1404128074646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.14046788215637 / seconds
Query Executed:select id FROM `ia` where city='Afton' && SIC_code='5651'DB:business_master_new
loadtime:0.14086294174194 / seconds
Query Executed:select * from geodata_geocity where city='Agency' limit 1DB:business_master_new
loadtime:0.14126586914062 / seconds
Query stored in cache : _QUERY_www.toadli.com3d392867b301dc7e85cf5d42504caaa1
loadtime:0.14131379127502 / seconds
Query Executed:select id FROM `ia` where city='Agency' && SIC_code='5651'DB:business_master_new
loadtime:0.1419529914856 / seconds
Query Executed:select * from geodata_geocity where city='Ainsworth' limit 1DB:business_master_new
loadtime:0.14223790168762 / seconds
Query stored in cache : _QUERY_www.toadli.com57a791cdd05d88144a784f5a46cbfd01
loadtime:0.14227199554443 / seconds
Query Executed:select id FROM `ia` where city='Ainsworth' && SIC_code='5651'DB:business_master_new
loadtime:0.14294791221619 / seconds
Query Executed:select * from geodata_geocity where city='Akron' limit 1DB:business_master_new
loadtime:0.1432569026947 / seconds
Query stored in cache : _QUERY_www.toadli.com8aceaed622d3ed5ea677bcde0b9e8ebc
loadtime:0.14330387115479 / seconds
Query Executed:select id FROM `ia` where city='Akron' && SIC_code='5651'DB:business_master_new
loadtime:0.14372086524963 / seconds
Query Executed:select * from geodata_geocity where city='Albert City' limit 1DB:business_master_new
loadtime:0.14399385452271 / seconds
Query stored in cache : _QUERY_www.toadli.com606ce1c27a62d24fbfd6c30031beb671
loadtime:0.14403700828552 / seconds
Query Executed:select id FROM `ia` where city='Albert City' && SIC_code='5651'DB:business_master_new
loadtime:0.1444787979126 / seconds
Query Executed:select * from geodata_geocity where city='Albia' limit 1DB:business_master_new
loadtime:0.14474296569824 / seconds
Query stored in cache : _QUERY_www.toadli.com40ba5c6ee9e9de28cc321b8445fc975b
loadtime:0.14477586746216 / seconds
Query Executed:select id FROM `ia` where city='Albia' && SIC_code='5651'DB:business_master_new
loadtime:0.14595079421997 / seconds
Query Executed:select * from geodata_geocity where city='Albion' limit 1DB:business_master_new
loadtime:0.14624500274658 / seconds
Query stored in cache : _QUERY_www.toadli.com960cbbce97c6f5b98d545268a5f7926c
loadtime:0.14628982543945 / seconds
Query Executed:select id FROM `ia` where city='Albion' && SIC_code='5651'DB:business_master_new
loadtime:0.1467068195343 / seconds
Query Executed:select * from geodata_geocity where city='Alburnett' limit 1DB:business_master_new
loadtime:0.14698195457458 / seconds
Query stored in cache : _QUERY_www.toadli.comcb427761ca44f5998f7392dfdfb6d1e8
loadtime:0.14701581001282 / seconds
Query Executed:select id FROM `ia` where city='Alburnett' && SIC_code='5651'DB:business_master_new
loadtime:0.14746880531311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alden' limit 1
loadtime:0.14751887321472 / seconds
Query Executed:select id FROM `ia` where city='Alden' && SIC_code='5651'DB:business_master_new
loadtime:0.14791989326477 / seconds
Query Executed:select * from geodata_geocity where city='Alexander' limit 1DB:business_master_new
loadtime:0.14822793006897 / seconds
Query stored in cache : _QUERY_www.toadli.com8a5725f994f91c1e363db6e075575037
loadtime:0.14827179908752 / seconds
Query Executed:select id FROM `ia` where city='Alexander' && SIC_code='5651'DB:business_master_new
loadtime:0.14868092536926 / seconds
Query Executed:select * from geodata_geocity where city='Algona' limit 1DB:business_master_new
loadtime:0.14897990226746 / seconds
Query stored in cache : _QUERY_www.toadli.com3e8b2ae59e7d95dae7cf75c03eec7643
loadtime:0.14901399612427 / seconds
Query Executed:select id FROM `ia` where city='Algona' && SIC_code='5651'DB:business_master_new
loadtime:0.15011787414551 / seconds
Query Executed:select * from geodata_geocity where city='Alleman' limit 1DB:business_master_new
loadtime:0.15038681030273 / seconds
Query stored in cache : _QUERY_www.toadli.com7bb70ec851b1f5f2c0e23c297ba78a49
loadtime:0.15043377876282 / seconds
Query Executed:select id FROM `ia` where city='Alleman' && SIC_code='5651'DB:business_master_new
loadtime:0.15635681152344 / seconds
Query Executed:select * from geodata_geocity where city='Allendorf' limit 1DB:business_master_new
loadtime:0.15664792060852 / seconds
Query stored in cache : _QUERY_www.toadli.com0987e79843d7306a1e65e5be7b19e358
loadtime:0.15668392181396 / seconds
Query Executed:select id FROM `ia` where city='Allendorf' && SIC_code='5651'DB:business_master_new
loadtime:0.15695595741272 / seconds
Query Executed:select * from geodata_geocity where city='Allerton' limit 1DB:business_master_new
loadtime:0.15723085403442 / seconds
Query stored in cache : _QUERY_www.toadli.com384c5cc55d4bcd93e16af292b67bce44
loadtime:0.15727090835571 / seconds
Query Executed:select id FROM `ia` where city='Allerton' && SIC_code='5651'DB:business_master_new
loadtime:0.1576828956604 / seconds
Query Executed:select * from geodata_geocity where city='Allison' limit 1DB:business_master_new
loadtime:0.15795683860779 / seconds
Query stored in cache : _QUERY_www.toadli.coma199ed69c5524e9d9ed2851eff2df4fa
loadtime:0.15800094604492 / seconds
Query Executed:select id FROM `ia` where city='Allison' && SIC_code='5651'DB:business_master_new
loadtime:0.15846991539001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.1585168838501 / seconds
Query Executed:select id FROM `ia` where city='Alpha' && SIC_code='5651'DB:business_master_new
loadtime:0.15923380851746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.15927696228027 / seconds
Query Executed:select id FROM `ia` where city='Alta' && SIC_code='5651'DB:business_master_new
loadtime:0.15970897674561 / seconds
Query Executed:select * from geodata_geocity where city='Alta Vista' limit 1DB:business_master_new
loadtime:0.16000580787659 / seconds
Query stored in cache : _QUERY_www.toadli.com1afbc6f30c35c598c6bf2c51732e1edd
loadtime:0.16004395484924 / seconds
Query Executed:select id FROM `ia` where city='Alta Vista' && SIC_code='5651'DB:business_master_new
loadtime:0.16045093536377 / seconds
Query Executed:select * from geodata_geocity where city='Alton' limit 1DB:business_master_new
loadtime:0.16070294380188 / seconds
Query stored in cache : _QUERY_www.toadli.comeaf15aa99ca7ab9abe40612f344d7c4a
loadtime:0.1607518196106 / seconds
Query Executed:select id FROM `ia` where city='Alton' && SIC_code='5651'DB:business_master_new
loadtime:0.16115689277649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.16119480133057 / seconds
Query Executed:select id FROM `ia` where city='Altoona' && SIC_code='5651'DB:business_master_new
loadtime:0.16228699684143 / seconds
Query Executed:select * from geodata_geocity where city='Alvord' limit 1DB:business_master_new
loadtime:0.1625509262085 / seconds
Query stored in cache : _QUERY_www.toadli.comcdc6343d4d897f4fa675c3e00b4f0c5c
loadtime:0.16258382797241 / seconds
Query Executed:select id FROM `ia` where city='Alvord' && SIC_code='5651'DB:business_master_new
loadtime:0.16295480728149 / seconds
Query Executed:select * from geodata_geocity where city='Amana' limit 1DB:business_master_new
loadtime:0.16325688362122 / seconds
Query stored in cache : _QUERY_www.toadli.comb5cd00ab2e774863b8f7059c6e411aa7
loadtime:0.16329884529114 / seconds
Query Executed:select id FROM `ia` where city='Amana' && SIC_code='5651'DB:business_master_new
loadtime:0.16370391845703 / seconds
Query Executed:select * from geodata_geocity where city='Ames' limit 1DB:business_master_new
loadtime:0.1639678478241 / seconds
Query stored in cache : _QUERY_www.toadli.comdd780b0afb3d95a80bdd6e98bcc7defc
loadtime:0.16399598121643 / seconds
Query Executed:select id FROM `ia` where city='Ames' && SIC_code='5651'DB:business_master_new
loadtime:0.16510891914368 / seconds
Query Executed:select * from geodata_geocity where city='Anamosa' limit 1DB:business_master_new
loadtime:0.16540098190308 / seconds
Query stored in cache : _QUERY_www.toadli.comb9fa18f5dd24052c8d9f5e045668bb0e
loadtime:0.165442943573 / seconds
Query Executed:select id FROM `ia` where city='Anamosa' && SIC_code='5651'DB:business_master_new
loadtime:0.16657590866089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.1666259765625 / seconds
Query Executed:select id FROM `ia` where city='Andover' && SIC_code='5651'DB:business_master_new
loadtime:0.17089295387268 / seconds
Query Executed:select * from geodata_geocity where city='Andrew' limit 1DB:business_master_new
loadtime:0.17119884490967 / seconds
Query stored in cache : _QUERY_www.toadli.com1c3d927cb1c0ef805b9cc3baa7cf13e6
loadtime:0.17124581336975 / seconds
Query Executed:select id FROM `ia` where city='Andrew' && SIC_code='5651'DB:business_master_new
loadtime:0.17770600318909 / seconds
Query Executed:select * from geodata_geocity where city='Anita' limit 1DB:business_master_new
loadtime:0.17800498008728 / seconds
Query stored in cache : _QUERY_www.toadli.com698b12bf2148e8f126999594340a2d63
loadtime:0.17803883552551 / seconds
Query Executed:select id FROM `ia` where city='Anita' && SIC_code='5651'DB:business_master_new
loadtime:0.17867398262024 / seconds
Query Executed:select * from geodata_geocity where city='Ankeny' limit 1DB:business_master_new
loadtime:0.17897582054138 / seconds
Query stored in cache : _QUERY_www.toadli.comb46daafd88331228c6d3f062d0b3638c
loadtime:0.17901682853699 / seconds
Query Executed:select id FROM `ia` where city='Ankeny' && SIC_code='5651'DB:business_master_new
loadtime:0.18129587173462 / seconds
Query Executed:select * from geodata_geocity where city='Anthon' limit 1DB:business_master_new
loadtime:0.18156099319458 / seconds
Query stored in cache : _QUERY_www.toadli.com27f8a6c91b25dd593a8bb49f481c15b2
loadtime:0.18160700798035 / seconds
Query Executed:select id FROM `ia` where city='Anthon' && SIC_code='5651'DB:business_master_new
loadtime:0.18215799331665 / seconds
Query Executed:select * from geodata_geocity where city='Aplington' limit 1DB:business_master_new
loadtime:0.18243288993835 / seconds
Query stored in cache : _QUERY_www.toadli.coma7c388851da56fbc233c548fe413f844
loadtime:0.18246984481812 / seconds
Query Executed:select id FROM `ia` where city='Aplington' && SIC_code='5651'DB:business_master_new
loadtime:0.18326592445374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arcadia' limit 1
loadtime:0.18330478668213 / seconds
Query Executed:select id FROM `ia` where city='Arcadia' && SIC_code='5651'DB:business_master_new
loadtime:0.18371391296387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archer' limit 1
loadtime:0.18375897407532 / seconds
Query Executed:select id FROM `ia` where city='Archer' && SIC_code='5651'DB:business_master_new
loadtime:0.19112300872803 / seconds
Query Executed:select * from geodata_geocity where city='Aredale' limit 1DB:business_master_new
loadtime:0.19142079353333 / seconds
Query stored in cache : _QUERY_www.toadli.coma11bd346c8f785301c00186da5865587
loadtime:0.19145679473877 / seconds
Query Executed:select id FROM `ia` where city='Aredale' && SIC_code='5651'DB:business_master_new
loadtime:0.19416785240173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Argyle' limit 1
loadtime:0.19421577453613 / seconds
Query Executed:select id FROM `ia` where city='Argyle' && SIC_code='5651'DB:business_master_new
loadtime:0.20203185081482 / seconds
Query Executed:select * from geodata_geocity where city='Arion' limit 1DB:business_master_new
loadtime:0.20232892036438 / seconds
Query stored in cache : _QUERY_www.toadli.com4dedd26da282a21441e539c1524b478c
loadtime:0.20237183570862 / seconds
Query Executed:select id FROM `ia` where city='Arion' && SIC_code='5651'DB:business_master_new
loadtime:0.20459485054016 / seconds
Query Executed:select * from geodata_geocity where city='Arispe' limit 1DB:business_master_new
loadtime:0.20486283302307 / seconds
Query stored in cache : _QUERY_www.toadli.com6c721a5382df436bdf8e683c153834fa
loadtime:0.20489692687988 / seconds
Query Executed:select id FROM `ia` where city='Arispe' && SIC_code='5651'DB:business_master_new
loadtime:0.20627593994141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.20632290840149 / seconds
Query Executed:select id FROM `ia` where city='Arlington' && SIC_code='5651'DB:business_master_new
loadtime:0.20673680305481 / seconds
Query Executed:select * from geodata_geocity where city='Armstrong' limit 1DB:business_master_new
loadtime:0.20703482627869 / seconds
Query stored in cache : _QUERY_www.toadli.comec4031fcf3d7dd38e60efeb4610cf5b0
loadtime:0.20709300041199 / seconds
Query Executed:select id FROM `ia` where city='Armstrong' && SIC_code='5651'DB:business_master_new
loadtime:0.20753192901611 / seconds
Query Executed:select * from geodata_geocity where city='Arnolds Park' limit 1DB:business_master_new
loadtime:0.20781683921814 / seconds
Query stored in cache : _QUERY_www.toadli.com42d1c4d96ebbed1046da669b995ae598
loadtime:0.20786094665527 / seconds
Query Executed:select id FROM `ia` where city='Arnolds Park' && SIC_code='5651'DB:business_master_new
loadtime:0.2083568572998 / seconds
Query Executed:select * from geodata_geocity where city='Arthur' limit 1DB:business_master_new
loadtime:0.20863485336304 / seconds
Query stored in cache : _QUERY_www.toadli.coma222fd396a3288af01c68217b94492df
loadtime:0.20866680145264 / seconds
Query Executed:select id FROM `ia` where city='Arthur' && SIC_code='5651'DB:business_master_new
loadtime:0.20906591415405 / seconds
Query Executed:select * from geodata_geocity where city='Ashton' limit 1DB:business_master_new
loadtime:0.20933389663696 / seconds
Query stored in cache : _QUERY_www.toadli.com396be887a02d9e836141812cf74788f8
loadtime:0.20937490463257 / seconds
Query Executed:select id FROM `ia` where city='Ashton' && SIC_code='5651'DB:business_master_new
loadtime:0.20980381965637 / seconds
Query Executed:select * from geodata_geocity where city='Aspinwall' limit 1DB:business_master_new
loadtime:0.2100977897644 / seconds
Query stored in cache : _QUERY_www.toadli.com7817f975d3aa2f5a164d70893b331f53
loadtime:0.2101309299469 / seconds
Query Executed:select id FROM `ia` where city='Aspinwall' && SIC_code='5651'DB:business_master_new
loadtime:0.21246194839478 / seconds
Query Executed:select * from geodata_geocity where city='Atalissa' limit 1DB:business_master_new
loadtime:0.21275591850281 / seconds
Query stored in cache : _QUERY_www.toadli.comf2e73641b879d6b805504b359484c4e7
loadtime:0.21279692649841 / seconds
Query Executed:select id FROM `ia` where city='Atalissa' && SIC_code='5651'DB:business_master_new
loadtime:0.21317791938782 / seconds
Query Executed:select * from geodata_geocity where city='Atkins' limit 1DB:business_master_new
loadtime:0.21343588829041 / seconds
Query stored in cache : _QUERY_www.toadli.com0888029435c25bafd5dc588bf7bbfd53
loadtime:0.21346497535706 / seconds
Query Executed:select id FROM `ia` where city='Atkins' && SIC_code='5651'DB:business_master_new
loadtime:0.21385383605957 / seconds
Query Executed:select * from geodata_geocity where city='Atlantic' limit 1DB:business_master_new
loadtime:0.21415996551514 / seconds
Query stored in cache : _QUERY_www.toadli.com5a7670c3a0a3a96f0bb8a7adfc30e514
loadtime:0.21419882774353 / seconds
Query Executed:select id FROM `ia` where city='Atlantic' && SIC_code='5651'DB:business_master_new
loadtime:0.21534585952759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.21539378166199 / seconds
Query Executed:select id FROM `ia` where city='Auburn' && SIC_code='5651'DB:business_master_new
loadtime:0.21580982208252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.2158579826355 / seconds
Query Executed:select id FROM `ia` where city='Audubon' && SIC_code='5651'DB:business_master_new
loadtime:0.21697688102722 / seconds
Query Executed:select * from geodata_geocity where city='Aurelia' limit 1DB:business_master_new
loadtime:0.21727395057678 / seconds
Query stored in cache : _QUERY_www.toadli.comf85363da679253c7e858e664a2e7d9db
loadtime:0.21730780601501 / seconds
Query Executed:select id FROM `ia` where city='Aurelia' && SIC_code='5651'DB:business_master_new
loadtime:0.21773600578308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.21777200698853 / seconds
Query Executed:select id FROM `ia` where city='Aurora' && SIC_code='5651'DB:business_master_new
loadtime:0.21817493438721 / seconds
Query Executed:select * from geodata_geocity where city='Austinville' limit 1DB:business_master_new
loadtime:0.21846580505371 / seconds
Query stored in cache : _QUERY_www.toadli.com26252d9ca767d54493148628766d99af
loadtime:0.21850681304932 / seconds
Query Executed:select id FROM `ia` where city='Austinville' && SIC_code='5651'DB:business_master_new
loadtime:0.2200939655304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avoca' limit 1
loadtime:0.22014188766479 / seconds
Query Executed:select id FROM `ia` where city='Avoca' && SIC_code='5651'DB:business_master_new
loadtime:0.22059988975525 / seconds
Query Executed:select * from geodata_geocity where city='Ayrshire' limit 1DB:business_master_new
loadtime:0.22087478637695 / seconds
Query stored in cache : _QUERY_www.toadli.come6c02f3efa7feeab9138e53318257066
loadtime:0.22091794013977 / seconds
Query Executed:select id FROM `ia` where city='Ayrshire' && SIC_code='5651'DB:business_master_new
loadtime:0.22625494003296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badger' limit 1
loadtime:0.22630596160889 / seconds
Query Executed:select id FROM `ia` where city='Badger' && SIC_code='5651'DB:business_master_new
loadtime:0.22704696655273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagley' limit 1
loadtime:0.22712993621826 / seconds
Query Executed:select id FROM `ia` where city='Bagley' && SIC_code='5651'DB:business_master_new
loadtime:0.22783493995667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baldwin' limit 1
loadtime:0.22797393798828 / seconds
Query Executed:select id FROM `ia` where city='Baldwin' && SIC_code='5651'DB:business_master_new
loadtime:0.23247194290161 / seconds
Query Executed:select * from geodata_geocity where city='Bancroft' limit 1DB:business_master_new
loadtime:0.23275279998779 / seconds
Query stored in cache : _QUERY_www.toadli.comd41dfc1403dc203fe3046a6a6490eaa0
loadtime:0.2327868938446 / seconds
Query Executed:select id FROM `ia` where city='Bancroft' && SIC_code='5651'DB:business_master_new
loadtime:0.2331919670105 / seconds
Query Executed:select * from geodata_geocity where city='Barnes City' limit 1DB:business_master_new
loadtime:0.23348188400269 / seconds
Query stored in cache : _QUERY_www.toadli.com9c11330d0c11dceeaee339a0759417f8
loadtime:0.23351883888245 / seconds
Query Executed:select id FROM `ia` where city='Barnes City' && SIC_code='5651'DB:business_master_new
loadtime:0.23942494392395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnum' limit 1
loadtime:0.23947286605835 / seconds
Query Executed:select id FROM `ia` where city='Barnum' && SIC_code='5651'DB:business_master_new
loadtime:0.2454309463501 / seconds
Query Executed:select * from geodata_geocity where city='Batavia' limit 1DB:business_master_new
loadtime:0.24571990966797 / seconds
Query stored in cache : _QUERY_www.toadli.com49b1d73490d0c0991e8a35b50ae8ace4
loadtime:0.24575996398926 / seconds
Query Executed:select id FROM `ia` where city='Batavia' && SIC_code='5651'DB:business_master_new
loadtime:0.24614882469177 / seconds
Query Executed:select * from geodata_geocity where city='Battle Creek' limit 1DB:business_master_new
loadtime:0.24642181396484 / seconds
Query stored in cache : _QUERY_www.toadli.com4798d89fb7cfb944b06b45e76a85c134
loadtime:0.24646282196045 / seconds
Query Executed:select id FROM `ia` where city='Battle Creek' && SIC_code='5651'DB:business_master_new
loadtime:0.24686694145203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baxter' limit 1
loadtime:0.24690389633179 / seconds
Query Executed:select id FROM `ia` where city='Baxter' && SIC_code='5651'DB:business_master_new
loadtime:0.24733996391296 / seconds
Query Executed:select * from geodata_geocity where city='Bayard' limit 1DB:business_master_new
loadtime:0.24759292602539 / seconds
Query stored in cache : _QUERY_www.toadli.com2efe61c11c62326ba03f5dc8b8a50b6f
loadtime:0.24763178825378 / seconds
Query Executed:select id FROM `ia` where city='Bayard' && SIC_code='5651'DB:business_master_new
loadtime:0.24801778793335 / seconds
Query Executed:select * from geodata_geocity where city='Beacon' limit 1DB:business_master_new
loadtime:0.24828195571899 / seconds
Query stored in cache : _QUERY_www.toadli.com3b01d3f1f1194d72a66ba4c6d6f3da34
loadtime:0.24831986427307 / seconds
Query Executed:select id FROM `ia` where city='Beacon' && SIC_code='5651'DB:business_master_new
loadtime:0.25192379951477 / seconds
Query Executed:select * from geodata_geocity where city='Beaconsfield' limit 1DB:business_master_new
loadtime:0.25220680236816 / seconds
Query stored in cache : _QUERY_www.toadli.com7dd26c473fe67ed13f99d78d5214a8fc
loadtime:0.25224089622498 / seconds
Query Executed:select id FROM `ia` where city='Beaconsfield' && SIC_code='5651'DB:business_master_new
loadtime:0.25254797935486 / seconds
Query Executed:select * from geodata_geocity where city='Beaman' limit 1DB:business_master_new
loadtime:0.25281500816345 / seconds
Query stored in cache : _QUERY_www.toadli.com7a353dc30a8f9b69e6c01dca45501e87
loadtime:0.25285983085632 / seconds
Query Executed:select id FROM `ia` where city='Beaman' && SIC_code='5651'DB:business_master_new
loadtime:0.25946879386902 / seconds
Query Executed:select * from geodata_geocity where city='Beaver' limit 1DB:business_master_new
loadtime:0.25973081588745 / seconds
Query stored in cache : _QUERY_www.toadli.comf9cd848b6ba352d8138c9adbc36fbb5a
loadtime:0.25978183746338 / seconds
Query Executed:select id FROM `ia` where city='Beaver' && SIC_code='5651'DB:business_master_new
loadtime:0.26103782653809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.26110100746155 / seconds
Query Executed:select id FROM `ia` where city='Bedford' && SIC_code='5651'DB:business_master_new
loadtime:0.2615659236908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Plaine' limit 1
loadtime:0.26161098480225 / seconds
Query Executed:select id FROM `ia` where city='Belle Plaine' && SIC_code='5651'DB:business_master_new
loadtime:0.26207089424133 / seconds
Query Executed:select * from geodata_geocity where city='Bellevue' limit 1DB:business_master_new
loadtime:0.26234078407288 / seconds
Query stored in cache : _QUERY_www.toadli.com3252468b34775100a7010bb8b830284b
loadtime:0.26237297058105 / seconds
Query Executed:select id FROM `ia` where city='Bellevue' && SIC_code='5651'DB:business_master_new
loadtime:0.26283192634583 / seconds
Query Executed:select * from geodata_geocity where city='Belmond' limit 1DB:business_master_new
loadtime:0.26315593719482 / seconds
Query stored in cache : _QUERY_www.toadli.comaa931c9a8a96fc6b80e8cb93b99d2af9
loadtime:0.26319599151611 / seconds
Query Executed:select id FROM `ia` where city='Belmond' && SIC_code='5651'DB:business_master_new
loadtime:0.26366400718689 / seconds
Query Executed:select * from geodata_geocity where city='Bennett' limit 1DB:business_master_new
loadtime:0.26394081115723 / seconds
Query stored in cache : _QUERY_www.toadli.comce7beb2009408abd4aabc9e8a3cb4fc0
loadtime:0.26397490501404 / seconds
Query Executed:select id FROM `ia` where city='Bennett' && SIC_code='5651'DB:business_master_new
loadtime:0.26439785957336 / seconds
Query Executed:select * from geodata_geocity where city='Benton' limit 1DB:business_master_new
loadtime:0.26469779014587 / seconds
Query stored in cache : _QUERY_www.toadli.comc525fa1189ff2ad873600009f8116d3a
loadtime:0.26473999023438 / seconds
Query Executed:select id FROM `ia` where city='Benton' && SIC_code='5651'DB:business_master_new
loadtime:0.26703000068665 / seconds
Query Executed:select * from geodata_geocity where city='Bernard' limit 1DB:business_master_new
loadtime:0.26742887496948 / seconds
Query stored in cache : _QUERY_www.toadli.com9e60d3c890dc8d14b0f0fbfb5dbc80dc
loadtime:0.26746892929077 / seconds
Query Executed:select id FROM `ia` where city='Bernard' && SIC_code='5651'DB:business_master_new
loadtime:0.26850485801697 / seconds
Query Executed:select * from geodata_geocity where city='Berwick' limit 1DB:business_master_new
loadtime:0.26913094520569 / seconds
Query stored in cache : _QUERY_www.toadli.com81549e61c74b34c2fa031ab3f4fad073
loadtime:0.26917600631714 / seconds
Query Executed:select id FROM `ia` where city='Berwick' && SIC_code='5651'DB:business_master_new
loadtime:0.27409291267395 / seconds
Query Executed:select * from geodata_geocity where city='Bettendorf' limit 1DB:business_master_new
loadtime:0.2743809223175 / seconds
Query stored in cache : _QUERY_www.toadli.com34f94d1e73092dfdb1ace134722a20bd
loadtime:0.27442789077759 / seconds
Query Executed:select id FROM `ia` where city='Bettendorf' && SIC_code='5651'DB:business_master_new
loadtime:0.27634692192078 / seconds
Query Executed:select * from geodata_geocity where city='Bevington' limit 1DB:business_master_new
loadtime:0.27662682533264 / seconds
Query stored in cache : _QUERY_www.toadli.coma5e7c40cc59e719358c44984d1959bda
loadtime:0.27666091918945 / seconds
Query Executed:select id FROM `ia` where city='Bevington' && SIC_code='5651'DB:business_master_new
loadtime:0.27898693084717 / seconds
Query Executed:select * from geodata_geocity where city='Big Rock' limit 1DB:business_master_new
loadtime:0.27928590774536 / seconds
Query stored in cache : _QUERY_www.toadli.com3950604a3457edeeb2ebe70db830c65f
loadtime:0.27933192253113 / seconds
Query Executed:select id FROM `ia` where city='Big Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.2796049118042 / seconds
Query Executed:select * from geodata_geocity where city='Birmingham' limit 1DB:business_master_new
loadtime:0.27987790107727 / seconds
Query stored in cache : _QUERY_www.toadli.comf3845dd98e3d4f98de21ca5c2c840507
loadtime:0.27990698814392 / seconds
Query Executed:select id FROM `ia` where city='Birmingham' && SIC_code='5651'DB:business_master_new
loadtime:0.28029799461365 / seconds
Query Executed:select * from geodata_geocity where city='Blairsburg' limit 1DB:business_master_new
loadtime:0.28057599067688 / seconds
Query stored in cache : _QUERY_www.toadli.com8d6aa92064b164065c654f4c05239312
loadtime:0.28061389923096 / seconds
Query Executed:select id FROM `ia` where city='Blairsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.28117895126343 / seconds
Query Executed:select * from geodata_geocity where city='Blairstown' limit 1DB:business_master_new
loadtime:0.28144097328186 / seconds
Query stored in cache : _QUERY_www.toadli.com8b8c625f03dcc4d7a3645714e74259f2
loadtime:0.28146886825562 / seconds
Query Executed:select id FROM `ia` where city='Blairstown' && SIC_code='5651'DB:business_master_new
loadtime:0.28212785720825 / seconds
Query Executed:select * from geodata_geocity where city='Blakesburg' limit 1DB:business_master_new
loadtime:0.28237581253052 / seconds
Query stored in cache : _QUERY_www.toadli.coma7861f64846f217342dc4be06a6ba0fd
loadtime:0.28241300582886 / seconds
Query Executed:select id FROM `ia` where city='Blakesburg' && SIC_code='5651'DB:business_master_new
loadtime:0.28301882743835 / seconds
Query Executed:select * from geodata_geocity where city='Blanchard' limit 1DB:business_master_new
loadtime:0.2832989692688 / seconds
Query stored in cache : _QUERY_www.toadli.com9fdd8b0e0867912e5a98f51788bfd4db
loadtime:0.28332591056824 / seconds
Query Executed:select id FROM `ia` where city='Blanchard' && SIC_code='5651'DB:business_master_new
loadtime:0.28682684898376 / seconds
Query Executed:select * from geodata_geocity where city='Blencoe' limit 1DB:business_master_new
loadtime:0.28715777397156 / seconds
Query stored in cache : _QUERY_www.toadli.com3cb954d6e840525328a37228d0029f00
loadtime:0.28720378875732 / seconds
Query Executed:select id FROM `ia` where city='Blencoe' && SIC_code='5651'DB:business_master_new
loadtime:0.29568600654602 / seconds
Query Executed:select * from geodata_geocity where city='Blockton' limit 1DB:business_master_new
loadtime:0.29596495628357 / seconds
Query stored in cache : _QUERY_www.toadli.comedbcb45647502842e244439c81a4be4f
loadtime:0.29600787162781 / seconds
Query Executed:select id FROM `ia` where city='Blockton' && SIC_code='5651'DB:business_master_new
loadtime:0.30425691604614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.30430483818054 / seconds
Query Executed:select id FROM `ia` where city='Bloomfield' && SIC_code='5651'DB:business_master_new
loadtime:0.3064239025116 / seconds
Query Executed:select * from geodata_geocity where city='Blue Grass' limit 1DB:business_master_new
loadtime:0.30668878555298 / seconds
Query stored in cache : _QUERY_www.toadli.com6f0996ceb912ffde352fe2efaf903864
loadtime:0.30672287940979 / seconds
Query Executed:select id FROM `ia` where city='Blue Grass' && SIC_code='5651'DB:business_master_new
loadtime:0.30724382400513 / seconds
Query Executed:select * from geodata_geocity where city='Bode' limit 1DB:business_master_new
loadtime:0.30751490592957 / seconds
Query stored in cache : _QUERY_www.toadli.com551bcdc48b0be4f02f10972cf6d5d675
loadtime:0.30755186080933 / seconds
Query Executed:select id FROM `ia` where city='Bode' && SIC_code='5651'DB:business_master_new
loadtime:0.30809879302979 / seconds
Query Executed:select * from geodata_geocity where city='Bonaparte' limit 1DB:business_master_new
loadtime:0.30837297439575 / seconds
Query stored in cache : _QUERY_www.toadli.comc34ad5642111598b26032de7d7ebc95f
loadtime:0.30840182304382 / seconds
Query Executed:select id FROM `ia` where city='Bonaparte' && SIC_code='5651'DB:business_master_new
loadtime:0.30877685546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondurant' limit 1
loadtime:0.30881595611572 / seconds
Query Executed:select id FROM `ia` where city='Bondurant' && SIC_code='5651'DB:business_master_new
loadtime:0.30975699424744 / seconds
Query Executed:select * from geodata_geocity where city='Boone' limit 1DB:business_master_new
loadtime:0.31023192405701 / seconds
Query stored in cache : _QUERY_www.toadli.comc3a6704bdf705ca1c76681edaa843f6a
loadtime:0.3102707862854 / seconds
Query Executed:select id FROM `ia` where city='Boone' && SIC_code='5651'DB:business_master_new
loadtime:0.31202793121338 / seconds
Query Executed:select * from geodata_geocity where city='Booneville' limit 1DB:business_master_new
loadtime:0.31232595443726 / seconds
Query stored in cache : _QUERY_www.toadli.comb4e52ea4f6ca53a6a418421531926612
loadtime:0.31235980987549 / seconds
Query Executed:select id FROM `ia` where city='Booneville' && SIC_code='5651'DB:business_master_new
loadtime:0.31455993652344 / seconds
Query Executed:select * from geodata_geocity where city='Bouton' limit 1DB:business_master_new
loadtime:0.31484198570251 / seconds
Query stored in cache : _QUERY_www.toadli.comfa1c54357fa911551fdadc36b7b4bafa
loadtime:0.3148889541626 / seconds
Query Executed:select id FROM `ia` where city='Bouton' && SIC_code='5651'DB:business_master_new
loadtime:0.31531691551208 / seconds
Query Executed:select * from geodata_geocity where city='Boxholm' limit 1DB:business_master_new
loadtime:0.31561088562012 / seconds
Query stored in cache : _QUERY_www.toadli.comec685c38b13809ee4bcc427dd0cbb428
loadtime:0.3156418800354 / seconds
Query Executed:select id FROM `ia` where city='Boxholm' && SIC_code='5651'DB:business_master_new
loadtime:0.32071590423584 / seconds
Query Executed:select * from geodata_geocity where city='Boyden' limit 1DB:business_master_new
loadtime:0.32117700576782 / seconds
Query stored in cache : _QUERY_www.toadli.comda6b3b09383fb11568c1e236bee7621a
loadtime:0.32121777534485 / seconds
Query Executed:select id FROM `ia` where city='Boyden' && SIC_code='5651'DB:business_master_new
loadtime:0.32185196876526 / seconds
Query Executed:select * from geodata_geocity where city='Braddyville' limit 1DB:business_master_new
loadtime:0.32214379310608 / seconds
Query stored in cache : _QUERY_www.toadli.com9c83f5b419ce11b3ab623483ecd1afc5
loadtime:0.32219099998474 / seconds
Query Executed:select id FROM `ia` where city='Braddyville' && SIC_code='5651'DB:business_master_new
loadtime:0.32957577705383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.32962489128113 / seconds
Query Executed:select id FROM `ia` where city='Bradford' && SIC_code='5651'DB:business_master_new
loadtime:0.33100295066833 / seconds
Query Executed:select * from geodata_geocity where city='Bradgate' limit 1DB:business_master_new
loadtime:0.33130288124084 / seconds
Query stored in cache : _QUERY_www.toadli.com9dad6908b9eef8e04e7fcfedf5427b25
loadtime:0.33133792877197 / seconds
Query Executed:select id FROM `ia` where city='Bradgate' && SIC_code='5651'DB:business_master_new
loadtime:0.33512687683105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brandon' limit 1
loadtime:0.33517479896545 / seconds
Query Executed:select id FROM `ia` where city='Brandon' && SIC_code='5651'DB:business_master_new
loadtime:0.3423798084259 / seconds
Query Executed:select * from geodata_geocity where city='Brayton' limit 1DB:business_master_new
loadtime:0.3426628112793 / seconds
Query stored in cache : _QUERY_www.toadli.comdb3122d78e26d3165b4250cb25ce211c
loadtime:0.34270787239075 / seconds
Query Executed:select id FROM `ia` where city='Brayton' && SIC_code='5651'DB:business_master_new
loadtime:0.34871482849121 / seconds
Query Executed:select * from geodata_geocity where city='Breda' limit 1DB:business_master_new
loadtime:0.34899282455444 / seconds
Query stored in cache : _QUERY_www.toadli.com57487e7cecc0aa035d7fdbf2a8521174
loadtime:0.34902691841125 / seconds
Query Executed:select id FROM `ia` where city='Breda' && SIC_code='5651'DB:business_master_new
loadtime:0.34944200515747 / seconds
Query Executed:select * from geodata_geocity where city='Bridgewater' limit 1DB:business_master_new
loadtime:0.3497359752655 / seconds
Query stored in cache : _QUERY_www.toadli.com8658faf09df22cec18f1cc32858c2a7a
loadtime:0.34977984428406 / seconds
Query Executed:select id FROM `ia` where city='Bridgewater' && SIC_code='5651'DB:business_master_new
loadtime:0.35781383514404 / seconds
Query Executed:select * from geodata_geocity where city='Brighton' limit 1DB:business_master_new
loadtime:0.35814881324768 / seconds
Query stored in cache : _QUERY_www.toadli.com511572989723f0c6f14b21fa0f1005a5
loadtime:0.35818386077881 / seconds
Query Executed:select id FROM `ia` where city='Brighton' && SIC_code='5651'DB:business_master_new
loadtime:0.35862994194031 / seconds
Query Executed:select * from geodata_geocity where city='Bristow' limit 1DB:business_master_new
loadtime:0.35892987251282 / seconds
Query stored in cache : _QUERY_www.toadli.com6fbe14c17265e725493f46deb1a2fe8c
loadtime:0.35897278785706 / seconds
Query Executed:select id FROM `ia` where city='Bristow' && SIC_code='5651'DB:business_master_new
loadtime:0.36523389816284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Britt' limit 1
loadtime:0.36528182029724 / seconds
Query Executed:select id FROM `ia` where city='Britt' && SIC_code='5651'DB:business_master_new
loadtime:0.36573886871338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bronson' limit 1
loadtime:0.36578297615051 / seconds
Query Executed:select id FROM `ia` where city='Bronson' && SIC_code='5651'DB:business_master_new
loadtime:0.37086296081543 / seconds
Query Executed:select * from geodata_geocity where city='Brooklyn' limit 1DB:business_master_new
loadtime:0.37118291854858 / seconds
Query stored in cache : _QUERY_www.toadli.com85808917a1b5582500e96b3b81de2ed6
loadtime:0.37122893333435 / seconds
Query Executed:select id FROM `ia` where city='Brooklyn' && SIC_code='5651'DB:business_master_new
loadtime:0.37168097496033 / seconds
Query Executed:select * from geodata_geocity where city='Brunsville' limit 1DB:business_master_new
loadtime:0.37196183204651 / seconds
Query stored in cache : _QUERY_www.toadli.com851960c25945ce6d6a3d3ed30cbd608e
loadtime:0.37200379371643 / seconds
Query Executed:select id FROM `ia` where city='Brunsville' && SIC_code='5651'DB:business_master_new
loadtime:0.37549591064453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.37554788589478 / seconds
Query Executed:select id FROM `ia` where city='Bryant' && SIC_code='5651'DB:business_master_new
loadtime:0.3827018737793 / seconds
Query Executed:select * from geodata_geocity where city='Buckeye' limit 1DB:business_master_new
loadtime:0.38300490379333 / seconds
Query stored in cache : _QUERY_www.toadli.com70e6c75c246444b9081090334ffddd0b
loadtime:0.38305997848511 / seconds
Query Executed:select id FROM `ia` where city='Buckeye' && SIC_code='5651'DB:business_master_new
loadtime:0.38396096229553 / seconds
Query Executed:select * from geodata_geocity where city='Buckingham' limit 1DB:business_master_new
loadtime:0.38424277305603 / seconds
Query stored in cache : _QUERY_www.toadli.com748159efa3b42bfb2c67d39524598b6f
loadtime:0.38427400588989 / seconds
Query Executed:select id FROM `ia` where city='Buckingham' && SIC_code='5651'DB:business_master_new
loadtime:0.38699293136597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.38703680038452 / seconds
Query Executed:select id FROM `ia` where city='Buffalo' && SIC_code='5651'DB:business_master_new
loadtime:0.38745999336243 / seconds
Query Executed:select * from geodata_geocity where city='Buffalo Center' limit 1DB:business_master_new
loadtime:0.38772678375244 / seconds
Query stored in cache : _QUERY_www.toadli.com15deab1dc595db15559006f42cc05fcf
loadtime:0.38776779174805 / seconds
Query Executed:select id FROM `ia` where city='Buffalo Center' && SIC_code='5651'DB:business_master_new
loadtime:0.38820791244507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.38824796676636 / seconds
Query Executed:select id FROM `ia` where city='Burlington' && SIC_code='5651'DB:business_master_new
loadtime:0.38940095901489 / seconds
Query Executed:select * from geodata_geocity where city='Burnside' limit 1DB:business_master_new
loadtime:0.38968086242676 / seconds
Query stored in cache : _QUERY_www.toadli.com36e9954896433fef18269b9ba269ba75
loadtime:0.38971495628357 / seconds
Query Executed:select id FROM `ia` where city='Burnside' && SIC_code='5651'DB:business_master_new
loadtime:0.39099383354187 / seconds
Query Executed:select * from geodata_geocity where city='Burt' limit 1DB:business_master_new
loadtime:0.39128994941711 / seconds
Query stored in cache : _QUERY_www.toadli.com89022bc8091c954edbd670e1be50a315
loadtime:0.39165878295898 / seconds
Query Executed:select id FROM `ia` where city='Burt' && SIC_code='5651'DB:business_master_new
loadtime:0.39213299751282 / seconds
Query Executed:select * from geodata_geocity where city='Bussey' limit 1DB:business_master_new
loadtime:0.39239883422852 / seconds
Query stored in cache : _QUERY_www.toadli.comabaec28a15e8c60cd5c32d940f01e821
loadtime:0.39243197441101 / seconds
Query Executed:select id FROM `ia` where city='Bussey' && SIC_code='5651'DB:business_master_new
loadtime:0.39280796051025 / seconds
Query Executed:select * from geodata_geocity where city='Calamus' limit 1DB:business_master_new
loadtime:0.39308381080627 / seconds
Query stored in cache : _QUERY_www.toadli.com2340892be8e96682b41bec15a7d60ccb
loadtime:0.3931257724762 / seconds
Query Executed:select id FROM `ia` where city='Calamus' && SIC_code='5651'DB:business_master_new
loadtime:0.39352679252625 / seconds
Query Executed:select * from geodata_geocity where city='Callender' limit 1DB:business_master_new
loadtime:0.39381885528564 / seconds
Query stored in cache : _QUERY_www.toadli.comdddb11fd45b2e62f5eb10e142b64b6af
loadtime:0.39386081695557 / seconds
Query Executed:select id FROM `ia` where city='Callender' && SIC_code='5651'DB:business_master_new
loadtime:0.39425683021545 / seconds
Query Executed:select * from geodata_geocity where city='Calmar' limit 1DB:business_master_new
loadtime:0.39453983306885 / seconds
Query stored in cache : _QUERY_www.toadli.comfff65e45644e33accc5ad50b80402bfc
loadtime:0.39457297325134 / seconds
Query Executed:select id FROM `ia` where city='Calmar' && SIC_code='5651'DB:business_master_new
loadtime:0.39513397216797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calumet' limit 1
loadtime:0.39517784118652 / seconds
Query Executed:select id FROM `ia` where city='Calumet' && SIC_code='5651'DB:business_master_new
loadtime:0.39850997924805 / seconds
Query Executed:select * from geodata_geocity where city='Camanche' limit 1DB:business_master_new
loadtime:0.39880180358887 / seconds
Query stored in cache : _QUERY_www.toadli.com6517fab58e61526bfc7b252af4c8e422
loadtime:0.39884281158447 / seconds
Query Executed:select id FROM `ia` where city='Camanche' && SIC_code='5651'DB:business_master_new
loadtime:0.39928984642029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cambridge' limit 1
loadtime:0.39931988716125 / seconds
Query Executed:select id FROM `ia` where city='Cambridge' && SIC_code='5651'DB:business_master_new
loadtime:0.39970278739929 / seconds
Query Executed:select * from geodata_geocity where city='Cantril' limit 1DB:business_master_new
loadtime:0.39997792243958 / seconds
Query stored in cache : _QUERY_www.toadli.com44effe0caded46ce915ee8793a8294eb
loadtime:0.40000796318054 / seconds
Query Executed:select id FROM `ia` where city='Cantril' && SIC_code='5651'DB:business_master_new
loadtime:0.40752983093262 / seconds
Query Executed:select * from geodata_geocity where city='Carbon' limit 1DB:business_master_new
loadtime:0.40780878067017 / seconds
Query stored in cache : _QUERY_www.toadli.comb82e06f8475a733d342dece23ffd4efb
loadtime:0.40785384178162 / seconds
Query Executed:select id FROM `ia` where city='Carbon' && SIC_code='5651'DB:business_master_new
loadtime:0.40870499610901 / seconds
Query Executed:select * from geodata_geocity where city='Carlisle' limit 1DB:business_master_new
loadtime:0.40898990631104 / seconds
Query stored in cache : _QUERY_www.toadli.coma377d6d838e9d98351a7abe0b2abad19
loadtime:0.40903687477112 / seconds
Query Executed:select id FROM `ia` where city='Carlisle' && SIC_code='5651'DB:business_master_new
loadtime:0.40951681137085 / seconds
Query Executed:select * from geodata_geocity where city='Carnarvon' limit 1DB:business_master_new
loadtime:0.40980291366577 / seconds
Query stored in cache : _QUERY_www.toadli.com23484b27f1db9834ed9f0bb5e3abf809
loadtime:0.40984892845154 / seconds
Query Executed:select id FROM `ia` where city='Carnarvon' && SIC_code='5651'DB:business_master_new
loadtime:0.41114282608032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.4111909866333 / seconds
Query Executed:select id FROM `ia` where city='Carpenter' && SIC_code='5651'DB:business_master_new
loadtime:0.41314482688904 / seconds
Query Executed:select * from geodata_geocity where city='Carroll' limit 1DB:business_master_new
loadtime:0.41343188285828 / seconds
Query stored in cache : _QUERY_www.toadli.com8eb41a21314b3a0012eb89bbd6844030
loadtime:0.41346597671509 / seconds
Query Executed:select id FROM `ia` where city='Carroll' && SIC_code='5651'DB:business_master_new
loadtime:0.41460299491882 / seconds
Query Executed:select * from geodata_geocity where city='Carson' limit 1DB:business_master_new
loadtime:0.41488194465637 / seconds
Query stored in cache : _QUERY_www.toadli.com55763b51d38592f1631e287c12126276
loadtime:0.41492795944214 / seconds
Query Executed:select id FROM `ia` where city='Carson' && SIC_code='5651'DB:business_master_new
loadtime:0.41538691520691 / seconds
Query Executed:select * from geodata_geocity where city='Carter Lake' limit 1DB:business_master_new
loadtime:0.4156768321991 / seconds
Query stored in cache : _QUERY_www.toadli.comd055cb4d6850f4da71a6c31636e18a81
loadtime:0.41571879386902 / seconds
Query Executed:select id FROM `ia` where city='Carter Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.4161479473114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cascade' limit 1
loadtime:0.41618990898132 / seconds
Query Executed:select id FROM `ia` where city='Cascade' && SIC_code='5651'DB:business_master_new
loadtime:0.41661500930786 / seconds
Query Executed:select * from geodata_geocity where city='Casey' limit 1DB:business_master_new
loadtime:0.41689777374268 / seconds
Query stored in cache : _QUERY_www.toadli.com56f856d7cc2e531fcaa888b9c88ed997
loadtime:0.41692686080933 / seconds
Query Executed:select id FROM `ia` where city='Casey' && SIC_code='5651'DB:business_master_new
loadtime:0.41736078262329 / seconds
Query Executed:select * from geodata_geocity where city='Castalia' limit 1DB:business_master_new
loadtime:0.41763997077942 / seconds
Query stored in cache : _QUERY_www.toadli.com8c0ff1c48cdadff855232ddd53c4873d
loadtime:0.41768097877502 / seconds
Query Executed:select id FROM `ia` where city='Castalia' && SIC_code='5651'DB:business_master_new
loadtime:0.42215299606323 / seconds
Query Executed:select * from geodata_geocity where city='Castana' limit 1DB:business_master_new
loadtime:0.42241978645325 / seconds
Query stored in cache : _QUERY_www.toadli.comf70f53f7d529556bc828cedfd57bfb8a
loadtime:0.42246699333191 / seconds
Query Executed:select id FROM `ia` where city='Castana' && SIC_code='5651'DB:business_master_new
loadtime:0.42288780212402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar' limit 1
loadtime:0.42292380332947 / seconds
Query Executed:select id FROM `ia` where city='Cedar' && SIC_code='5651'DB:business_master_new
loadtime:0.42677283287048 / seconds
Query Executed:select * from geodata_geocity where city='Cedar Falls' limit 1DB:business_master_new
loadtime:0.4270658493042 / seconds
Query stored in cache : _QUERY_www.toadli.comd2ecb8ece2cf16345102e389bef83550
loadtime:0.42712378501892 / seconds
Query Executed:select id FROM `ia` where city='Cedar Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.42824387550354 / seconds
Query Executed:select * from geodata_geocity where city='Cedar Rapids' limit 1DB:business_master_new
loadtime:0.42851877212524 / seconds
Query stored in cache : _QUERY_www.toadli.com1714bf159c5123400eaca2c8949482fa
loadtime:0.42855095863342 / seconds
Query Executed:select id FROM `ia` where city='Cedar Rapids' && SIC_code='5651'DB:business_master_new
loadtime:0.42969584465027 / seconds
Query Executed:select * from geodata_geocity where city='Center Junction' limit 1DB:business_master_new
loadtime:0.43000197410583 / seconds
Query stored in cache : _QUERY_www.toadli.com5779b340cbd7efa804d57ef86566887f
loadtime:0.43004393577576 / seconds
Query Executed:select id FROM `ia` where city='Center Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.4357738494873 / seconds
Query Executed:select * from geodata_geocity where city='Center Point' limit 1DB:business_master_new
loadtime:0.43606877326965 / seconds
Query stored in cache : _QUERY_www.toadli.com974bb69e9e90645ff84df07149ce672f
loadtime:0.43610286712646 / seconds
Query Executed:select id FROM `ia` where city='Center Point' && SIC_code='5651'DB:business_master_new
loadtime:0.43659090995789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.43664598464966 / seconds
Query Executed:select id FROM `ia` where city='Centerville' && SIC_code='5651'DB:business_master_new
loadtime:0.43779182434082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central City' limit 1
loadtime:0.43785095214844 / seconds
Query Executed:select id FROM `ia` where city='Central City' && SIC_code='5651'DB:business_master_new
loadtime:0.4383339881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapin' limit 1
loadtime:0.4383819103241 / seconds
Query Executed:select id FROM `ia` where city='Chapin' && SIC_code='5651'DB:business_master_new
loadtime:0.43873691558838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chariton' limit 1
loadtime:0.43877291679382 / seconds
Query Executed:select id FROM `ia` where city='Chariton' && SIC_code='5651'DB:business_master_new
loadtime:0.43990182876587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charles City' limit 1
loadtime:0.43995094299316 / seconds
Query Executed:select id FROM `ia` where city='Charles City' && SIC_code='5651'DB:business_master_new
loadtime:0.44108080863953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:0.44111800193787 / seconds
Query Executed:select id FROM `ia` where city='Charlotte' && SIC_code='5651'DB:business_master_new
loadtime:0.44154500961304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charter Oak' limit 1
loadtime:0.44159388542175 / seconds
Query Executed:select id FROM `ia` where city='Charter Oak' && SIC_code='5651'DB:business_master_new
loadtime:0.44202589988708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:0.44206786155701 / seconds
Query Executed:select id FROM `ia` where city='Chatsworth' && SIC_code='5651'DB:business_master_new
loadtime:0.44232082366943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.44235682487488 / seconds
Query Executed:select id FROM `ia` where city='Chelsea' && SIC_code='5651'DB:business_master_new
loadtime:0.44274377822876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.4427797794342 / seconds
Query Executed:select id FROM `ia` where city='Cherokee' && SIC_code='5651'DB:business_master_new
loadtime:0.44390678405762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.4439549446106 / seconds
Query Executed:select id FROM `ia` where city='Chester' && SIC_code='5651'DB:business_master_new
loadtime:0.44443488121033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chillicothe' limit 1
loadtime:0.44448280334473 / seconds
Query Executed:select id FROM `ia` where city='Chillicothe' && SIC_code='5651'DB:business_master_new
loadtime:0.44481587409973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Churdan' limit 1
loadtime:0.44485187530518 / seconds
Query Executed:select id FROM `ia` where city='Churdan' && SIC_code='5651'DB:business_master_new
loadtime:0.44525694847107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cincinnati' limit 1
loadtime:0.44528388977051 / seconds
Query Executed:select id FROM `ia` where city='Cincinnati' && SIC_code='5651'DB:business_master_new
loadtime:0.44574379920959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clare' limit 1
loadtime:0.44578099250793 / seconds
Query Executed:select id FROM `ia` where city='Clare' && SIC_code='5651'DB:business_master_new
loadtime:0.44615292549133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarence' limit 1
loadtime:0.44619393348694 / seconds
Query Executed:select id FROM `ia` where city='Clarence' && SIC_code='5651'DB:business_master_new
loadtime:0.44660377502441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarinda' limit 1
loadtime:0.44663882255554 / seconds
Query Executed:select id FROM `ia` where city='Clarinda' && SIC_code='5651'DB:business_master_new
loadtime:0.44777679443359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarion' limit 1
loadtime:0.44782495498657 / seconds
Query Executed:select id FROM `ia` where city='Clarion' && SIC_code='5651'DB:business_master_new
loadtime:0.44833898544312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.44837594032288 / seconds
Query Executed:select id FROM `ia` where city='Clarksville' && SIC_code='5651'DB:business_master_new
loadtime:0.44879388809204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clear Lake' limit 1
loadtime:0.44884181022644 / seconds
Query Executed:select id FROM `ia` where city='Clear Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.44996881484985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.45001578330994 / seconds
Query Executed:select id FROM `ia` where city='Clearfield' && SIC_code='5651'DB:business_master_new
loadtime:0.45045185089111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleghorn' limit 1
loadtime:0.45049977302551 / seconds
Query Executed:select id FROM `ia` where city='Cleghorn' && SIC_code='5651'DB:business_master_new
loadtime:0.45090985298157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemons' limit 1
loadtime:0.45093679428101 / seconds
Query Executed:select id FROM `ia` where city='Clemons' && SIC_code='5651'DB:business_master_new
loadtime:0.45143890380859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clermont' limit 1
loadtime:0.45148777961731 / seconds
Query Executed:select id FROM `ia` where city='Clermont' && SIC_code='5651'DB:business_master_new
loadtime:0.45187783241272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climbing Hill' limit 1
loadtime:0.45190477371216 / seconds
Query Executed:select id FROM `ia` where city='Climbing Hill' && SIC_code='5651'DB:business_master_new
loadtime:0.45224380493164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.45228290557861 / seconds
Query Executed:select id FROM `ia` where city='Clinton' && SIC_code='5651'DB:business_master_new
loadtime:0.45339584350586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.45345187187195 / seconds
Query Executed:select id FROM `ia` where city='Clio' && SIC_code='5651'DB:business_master_new
loadtime:0.4538037776947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clive' limit 1
loadtime:0.45383977890015 / seconds
Query Executed:select id FROM `ia` where city='Clive' && SIC_code='5651'DB:business_master_new
loadtime:0.45495796203613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clutier' limit 1
loadtime:0.45501589775085 / seconds
Query Executed:select id FROM `ia` where city='Clutier' && SIC_code='5651'DB:business_master_new
loadtime:0.45545077323914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coggon' limit 1
loadtime:0.45550179481506 / seconds
Query Executed:select id FROM `ia` where city='Coggon' && SIC_code='5651'DB:business_master_new
loadtime:0.45591998100281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coin' limit 1
loadtime:0.45594692230225 / seconds
Query Executed:select id FROM `ia` where city='Coin' && SIC_code='5651'DB:business_master_new
loadtime:0.48444080352783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colesburg' limit 1
loadtime:0.48448991775513 / seconds
Query Executed:select id FROM `ia` where city='Colesburg' && SIC_code='5651'DB:business_master_new
loadtime:0.48491477966309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:0.48495078086853 / seconds
Query Executed:select id FROM `ia` where city='Colfax' && SIC_code='5651'DB:business_master_new
loadtime:0.48541593551636 / seconds
Query loaded from cache:select * from geodata_geocity where city='College Springs' limit 1
loadtime:0.48546385765076 / seconds
Query Executed:select id FROM `ia` where city='College Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.48584890365601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collins' limit 1
loadtime:0.48588490486145 / seconds
Query Executed:select id FROM `ia` where city='Collins' && SIC_code='5651'DB:business_master_new
loadtime:0.48626780509949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colo' limit 1
loadtime:0.48630785942078 / seconds
Query Executed:select id FROM `ia` where city='Colo' && SIC_code='5651'DB:business_master_new
loadtime:0.48670887947083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.48674488067627 / seconds
Query Executed:select id FROM `ia` where city='Columbia' && SIC_code='5651'DB:business_master_new
loadtime:0.48713898658752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus City' limit 1
loadtime:0.48717880249023 / seconds
Query Executed:select id FROM `ia` where city='Columbus City' && SIC_code='5651'DB:business_master_new
loadtime:0.48759579658508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Jct' limit 1
loadtime:0.48763990402222 / seconds
Query Executed:select id FROM `ia` where city='Columbus Jct' && SIC_code='5651'DB:business_master_new
loadtime:0.48797583580017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus Junction' limit 1
loadtime:0.48800277709961 / seconds
Query Executed:select id FROM `ia` where city='Columbus Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.48843693733215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colwell' limit 1
loadtime:0.48848390579224 / seconds
Query Executed:select id FROM `ia` where city='Colwell' && SIC_code='5651'DB:business_master_new
loadtime:0.48879790306091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conesville' limit 1
loadtime:0.48882484436035 / seconds
Query Executed:select id FROM `ia` where city='Conesville' && SIC_code='5651'DB:business_master_new
loadtime:0.4892749786377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conrad' limit 1
loadtime:0.48931384086609 / seconds
Query Executed:select id FROM `ia` where city='Conrad' && SIC_code='5651'DB:business_master_new
loadtime:0.48975586891174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conroy' limit 1
loadtime:0.48979687690735 / seconds
Query Executed:select id FROM `ia` where city='Conroy' && SIC_code='5651'DB:business_master_new
loadtime:0.49018788337708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coon Rapids' limit 1
loadtime:0.49022889137268 / seconds
Query Executed:select id FROM `ia` where city='Coon Rapids' && SIC_code='5651'DB:business_master_new
loadtime:0.49065780639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooper' limit 1
loadtime:0.49070286750793 / seconds
Query Executed:select id FROM `ia` where city='Cooper' && SIC_code='5651'DB:business_master_new
loadtime:0.49100184440613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coralville' limit 1
loadtime:0.49102997779846 / seconds
Query Executed:select id FROM `ia` where city='Coralville' && SIC_code='5651'DB:business_master_new
loadtime:0.49214482307434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corning' limit 1
loadtime:0.49218893051147 / seconds
Query Executed:select id FROM `ia` where city='Corning' && SIC_code='5651'DB:business_master_new
loadtime:0.49269080162048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Correctionville' limit 1
loadtime:0.49273896217346 / seconds
Query Executed:select id FROM `ia` where city='Correctionville' && SIC_code='5651'DB:business_master_new
loadtime:0.49313282966614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corwith' limit 1
loadtime:0.49316191673279 / seconds
Query Executed:select id FROM `ia` where city='Corwith' && SIC_code='5651'DB:business_master_new
loadtime:0.49356198310852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corydon' limit 1
loadtime:0.49360990524292 / seconds
Query Executed:select id FROM `ia` where city='Corydon' && SIC_code='5651'DB:business_master_new
loadtime:0.49406886100769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coulter' limit 1
loadtime:0.49409794807434 / seconds
Query Executed:select id FROM `ia` where city='Coulter' && SIC_code='5651'DB:business_master_new
loadtime:0.49453186988831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council Bluffs' limit 1
loadtime:0.49457979202271 / seconds
Query Executed:select id FROM `ia` where city='Council Bluffs' && SIC_code='5651'DB:business_master_new
loadtime:0.49573397636414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crawfordsville' limit 1
loadtime:0.4957799911499 / seconds
Query Executed:select id FROM `ia` where city='Crawfordsville' && SIC_code='5651'DB:business_master_new
loadtime:0.4961998462677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crescent' limit 1
loadtime:0.49623990058899 / seconds
Query Executed:select id FROM `ia` where city='Crescent' && SIC_code='5651'DB:business_master_new
loadtime:0.49664378166199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresco' limit 1
loadtime:0.49668097496033 / seconds
Query Executed:select id FROM `ia` where city='Cresco' && SIC_code='5651'DB:business_master_new
loadtime:0.49779987335205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:0.49784684181213 / seconds
Query Executed:select id FROM `ia` where city='Creston' && SIC_code='5651'DB:business_master_new
loadtime:0.49897885322571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.4990348815918 / seconds
Query Executed:select id FROM `ia` where city='Cromwell' && SIC_code='5651'DB:business_master_new
loadtime:0.49940180778503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crystal Lake' limit 1
loadtime:0.49945092201233 / seconds
Query Executed:select id FROM `ia` where city='Crystal Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.49991083145142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:0.49994683265686 / seconds
Query Executed:select id FROM `ia` where city='Cumberland' && SIC_code='5651'DB:business_master_new
loadtime:0.5003559589386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumming' limit 1
loadtime:0.500403881073 / seconds
Query Executed:select id FROM `ia` where city='Cumming' && SIC_code='5651'DB:business_master_new
loadtime:0.50081396102905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Curlew' limit 1
loadtime:0.5008499622345 / seconds
Query Executed:select id FROM `ia` where city='Curlew' && SIC_code='5651'DB:business_master_new
loadtime:0.50127100944519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cushing' limit 1
loadtime:0.50131297111511 / seconds
Query Executed:select id FROM `ia` where city='Cushing' && SIC_code='5651'DB:business_master_new
loadtime:0.51128792762756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cylinder' limit 1
loadtime:0.51133799552917 / seconds
Query Executed:select id FROM `ia` where city='Cylinder' && SIC_code='5651'DB:business_master_new
loadtime:0.51178789138794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dakota City' limit 1
loadtime:0.51182985305786 / seconds
Query Executed:select id FROM `ia` where city='Dakota City' && SIC_code='5651'DB:business_master_new
loadtime:0.51223182678223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:0.51227188110352 / seconds
Query Executed:select id FROM `ia` where city='Dallas' && SIC_code='5651'DB:business_master_new
loadtime:0.51259994506836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas Center' limit 1
loadtime:0.51264381408691 / seconds
Query Executed:select id FROM `ia` where city='Dallas Center' && SIC_code='5651'DB:business_master_new
loadtime:0.51306891441345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:0.51309680938721 / seconds
Query Executed:select id FROM `ia` where city='Dana' && SIC_code='5651'DB:business_master_new
loadtime:0.51347899436951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.51352691650391 / seconds
Query Executed:select id FROM `ia` where city='Danbury' && SIC_code='5651'DB:business_master_new
loadtime:0.51395082473755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.51397895812988 / seconds
Query Executed:select id FROM `ia` where city='Danville' && SIC_code='5651'DB:business_master_new
loadtime:0.51440787315369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davenport' limit 1
loadtime:0.51445579528809 / seconds
Query Executed:select id FROM `ia` where city='Davenport' && SIC_code='5651'DB:business_master_new
loadtime:0.5156078338623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis City' limit 1
loadtime:0.51565384864807 / seconds
Query Executed:select id FROM `ia` where city='Davis City' && SIC_code='5651'DB:business_master_new
loadtime:0.51617693901062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:0.51622200012207 / seconds
Query Executed:select id FROM `ia` where city='Dawson' && SIC_code='5651'DB:business_master_new
loadtime:0.51662683486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.51666283607483 / seconds
Query Executed:select id FROM `ia` where city='Dayton' && SIC_code='5651'DB:business_master_new
loadtime:0.51710200309753 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Soto' limit 1
loadtime:0.51714181900024 / seconds
Query Executed:select id FROM `ia` where city='De Soto' && SIC_code='5651'DB:business_master_new
loadtime:0.51768684387207 / seconds
Query loaded from cache:select * from geodata_geocity where city='De Witt' limit 1
loadtime:0.51772284507751 / seconds
Query Executed:select id FROM `ia` where city='De Witt' && SIC_code='5651'DB:business_master_new
loadtime:0.51884078979492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.51887679100037 / seconds
Query Executed:select id FROM `ia` where city='Decatur' && SIC_code='5651'DB:business_master_new
loadtime:0.51937294006348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decorah' limit 1
loadtime:0.51942086219788 / seconds
Query Executed:select id FROM `ia` where city='Decorah' && SIC_code='5651'DB:business_master_new
loadtime:0.52053999900818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dedham' limit 1
loadtime:0.52058291435242 / seconds
Query Executed:select id FROM `ia` where city='Dedham' && SIC_code='5651'DB:business_master_new
loadtime:0.52108097076416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.52112197875977 / seconds
Query Executed:select id FROM `ia` where city='Deep River' && SIC_code='5651'DB:business_master_new
loadtime:0.52151989936829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Defiance' limit 1
loadtime:0.52155590057373 / seconds
Query Executed:select id FROM `ia` where city='Defiance' && SIC_code='5651'DB:business_master_new
loadtime:0.52195000648499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:0.52198600769043 / seconds
Query Executed:select id FROM `ia` where city='Delaware' && SIC_code='5651'DB:business_master_new
loadtime:0.52233481407166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delhi' limit 1
loadtime:0.52237200737 / seconds
Query Executed:select id FROM `ia` where city='Delhi' && SIC_code='5651'DB:business_master_new
loadtime:0.5228009223938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmar' limit 1
loadtime:0.5228488445282 / seconds
Query Executed:select id FROM `ia` where city='Delmar' && SIC_code='5651'DB:business_master_new
loadtime:0.52323389053345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deloit' limit 1
loadtime:0.5232617855072 / seconds
Query Executed:select id FROM `ia` where city='Deloit' && SIC_code='5651'DB:business_master_new
loadtime:0.52361989021301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.52366781234741 / seconds
Query Executed:select id FROM `ia` where city='Delta' && SIC_code='5651'DB:business_master_new
loadtime:0.52407288551331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denison' limit 1
loadtime:0.52411079406738 / seconds
Query Executed:select id FROM `ia` where city='Denison' && SIC_code='5651'DB:business_master_new
loadtime:0.5251989364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denmark' limit 1
loadtime:0.52524280548096 / seconds
Query Executed:select id FROM `ia` where city='Denmark' && SIC_code='5651'DB:business_master_new
loadtime:0.52565884590149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:0.52570796012878 / seconds
Query Executed:select id FROM `ia` where city='Denver' && SIC_code='5651'DB:business_master_new
loadtime:0.52611494064331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.52614283561707 / seconds
Query Executed:select id FROM `ia` where city='Derby' && SIC_code='5651'DB:business_master_new
loadtime:0.52652478218079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Des Moines' limit 1
loadtime:0.52657294273376 / seconds
Query Executed:select id FROM `ia` where city='Des Moines' && SIC_code='5651'DB:business_master_new
loadtime:0.52772498130798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewar' limit 1
loadtime:0.52777290344238 / seconds
Query Executed:select id FROM `ia` where city='Dewar' && SIC_code='5651'DB:business_master_new
loadtime:0.52815890312195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dexter' limit 1
loadtime:0.52819895744324 / seconds
Query Executed:select id FROM `ia` where city='Dexter' && SIC_code='5651'DB:business_master_new
loadtime:0.52861285209656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diagonal' limit 1
loadtime:0.52865695953369 / seconds
Query Executed:select id FROM `ia` where city='Diagonal' && SIC_code='5651'DB:business_master_new
loadtime:0.529217004776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickens' limit 1
loadtime:0.52924394607544 / seconds
Query Executed:select id FROM `ia` where city='Dickens' && SIC_code='5651'DB:business_master_new
loadtime:0.52980184555054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dike' limit 1
loadtime:0.52985000610352 / seconds
Query Executed:select id FROM `ia` where city='Dike' && SIC_code='5651'DB:business_master_new
loadtime:0.53023600578308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.53027391433716 / seconds
Query Executed:select id FROM `ia` where city='Dixon' && SIC_code='5651'DB:business_master_new
loadtime:0.53067684173584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolliver' limit 1
loadtime:0.5307137966156 / seconds
Query Executed:select id FROM `ia` where city='Dolliver' && SIC_code='5651'DB:business_master_new
loadtime:0.53107500076294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donahue' limit 1
loadtime:0.53112697601318 / seconds
Query Executed:select id FROM `ia` where city='Donahue' && SIC_code='5651'DB:business_master_new
loadtime:0.54863286018372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Donnellson' limit 1
loadtime:0.54867196083069 / seconds
Query Executed:select id FROM `ia` where city='Donnellson' && SIC_code='5651'DB:business_master_new
loadtime:0.54914879798889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Doon' limit 1
loadtime:0.54918885231018 / seconds
Query Executed:select id FROM `ia` where city='Doon' && SIC_code='5651'DB:business_master_new
loadtime:0.54961681365967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.5496518611908 / seconds
Query Executed:select id FROM `ia` where city='Dorchester' && SIC_code='5651'DB:business_master_new
loadtime:0.55535888671875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douds' limit 1
loadtime:0.55540680885315 / seconds
Query Executed:select id FROM `ia` where city='Douds' && SIC_code='5651'DB:business_master_new
loadtime:0.55584979057312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dougherty' limit 1
loadtime:0.55588579177856 / seconds
Query Executed:select id FROM `ia` where city='Dougherty' && SIC_code='5651'DB:business_master_new
loadtime:0.55640983581543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dow City' limit 1
loadtime:0.55645680427551 / seconds
Query Executed:select id FROM `ia` where city='Dow City' && SIC_code='5651'DB:business_master_new
loadtime:0.55687880516052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dows' limit 1
loadtime:0.55692291259766 / seconds
Query Executed:select id FROM `ia` where city='Dows' && SIC_code='5651'DB:business_master_new
loadtime:0.55738496780396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drakesville' limit 1
loadtime:0.5574209690094 / seconds
Query Executed:select id FROM `ia` where city='Drakesville' && SIC_code='5651'DB:business_master_new
loadtime:0.55790185928345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dubuque' limit 1
loadtime:0.55795097351074 / seconds
Query Executed:select id FROM `ia` where city='Dubuque' && SIC_code='5651'DB:business_master_new
loadtime:0.55909490585327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.55916380882263 / seconds
Query Executed:select id FROM `ia` where city='Dumont' && SIC_code='5651'DB:business_master_new
loadtime:0.55962085723877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncombe' limit 1
loadtime:0.55965685844421 / seconds
Query Executed:select id FROM `ia` where city='Duncombe' && SIC_code='5651'DB:business_master_new
loadtime:0.56005692481995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dundee' limit 1
loadtime:0.56009697914124 / seconds
Query Executed:select id FROM `ia` where city='Dundee' && SIC_code='5651'DB:business_master_new
loadtime:0.56057596206665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunkerton' limit 1
loadtime:0.56062078475952 / seconds
Query Executed:select id FROM `ia` where city='Dunkerton' && SIC_code='5651'DB:business_master_new
loadtime:0.56104397773743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunlap' limit 1
loadtime:0.56108283996582 / seconds
Query Executed:select id FROM `ia` where city='Dunlap' && SIC_code='5651'DB:business_master_new
loadtime:0.56149697303772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durango' limit 1
loadtime:0.56154680252075 / seconds
Query Executed:select id FROM `ia` where city='Durango' && SIC_code='5651'DB:business_master_new
loadtime:0.5619478225708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durant' limit 1
loadtime:0.56198191642761 / seconds
Query Executed:select id FROM `ia` where city='Durant' && SIC_code='5651'DB:business_master_new
loadtime:0.5624418258667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dyersville' limit 1
loadtime:0.56247782707214 / seconds
Query Executed:select id FROM `ia` where city='Dyersville' && SIC_code='5651'DB:business_master_new
loadtime:0.56297492980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dysart' limit 1
loadtime:0.56301593780518 / seconds
Query Executed:select id FROM `ia` where city='Dysart' && SIC_code='5651'DB:business_master_new
loadtime:0.56346678733826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Grove' limit 1
loadtime:0.56350183486938 / seconds
Query Executed:select id FROM `ia` where city='Eagle Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.56395697593689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlham' limit 1
loadtime:0.5639967918396 / seconds
Query Executed:select id FROM `ia` where city='Earlham' && SIC_code='5651'DB:business_master_new
loadtime:0.56445097923279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earling' limit 1
loadtime:0.56448698043823 / seconds
Query Executed:select id FROM `ia` where city='Earling' && SIC_code='5651'DB:business_master_new
loadtime:0.56487393379211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earlville' limit 1
loadtime:0.56491494178772 / seconds
Query Executed:select id FROM `ia` where city='Earlville' && SIC_code='5651'DB:business_master_new
loadtime:0.56534790992737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Early' limit 1
loadtime:0.56538891792297 / seconds
Query Executed:select id FROM `ia` where city='Early' && SIC_code='5651'DB:business_master_new
loadtime:0.56577086448669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eddyville' limit 1
loadtime:0.56580996513367 / seconds
Query Executed:select id FROM `ia` where city='Eddyville' && SIC_code='5651'DB:business_master_new
loadtime:0.56619477272034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewood' limit 1
loadtime:0.56623196601868 / seconds
Query Executed:select id FROM `ia` where city='Edgewood' && SIC_code='5651'DB:business_master_new
loadtime:0.56663489341736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberon' limit 1
loadtime:0.56667184829712 / seconds
Query Executed:select id FROM `ia` where city='Elberon' && SIC_code='5651'DB:business_master_new
loadtime:0.57071089744568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldon' limit 1
loadtime:0.57075881958008 / seconds
Query Executed:select id FROM `ia` where city='Eldon' && SIC_code='5651'DB:business_master_new
loadtime:0.57116293907166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldora' limit 1
loadtime:0.57119178771973 / seconds
Query Executed:select id FROM `ia` where city='Eldora' && SIC_code='5651'DB:business_master_new
loadtime:0.57165288925171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldorado' limit 1
loadtime:0.5717089176178 / seconds
Query Executed:select id FROM `ia` where city='Eldorado' && SIC_code='5651'DB:business_master_new
loadtime:0.57198596000671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldridge' limit 1
loadtime:0.57201290130615 / seconds
Query Executed:select id FROM `ia` where city='Eldridge' && SIC_code='5651'DB:business_master_new
loadtime:0.57313585281372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.57318592071533 / seconds
Query Executed:select id FROM `ia` where city='Elgin' && SIC_code='5651'DB:business_master_new
loadtime:0.57359600067139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Horn' limit 1
loadtime:0.57364082336426 / seconds
Query Executed:select id FROM `ia` where city='Elk Horn' && SIC_code='5651'DB:business_master_new
loadtime:0.57406997680664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Run Heights' limit 1
loadtime:0.57409691810608 / seconds
Query Executed:select id FROM `ia` where city='Elk Run Heights' && SIC_code='5651'DB:business_master_new
loadtime:0.57440185546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkader' limit 1
loadtime:0.57444977760315 / seconds
Query Executed:select id FROM `ia` where city='Elkader' && SIC_code='5651'DB:business_master_new
loadtime:0.57488894462585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkhart' limit 1
loadtime:0.57492399215698 / seconds
Query Executed:select id FROM `ia` where city='Elkhart' && SIC_code='5651'DB:business_master_new
loadtime:0.57534694671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkport' limit 1
loadtime:0.57538485527039 / seconds
Query Executed:select id FROM `ia` where city='Elkport' && SIC_code='5651'DB:business_master_new
loadtime:0.57574892044067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elliott' limit 1
loadtime:0.5757908821106 / seconds
Query Executed:select id FROM `ia` where city='Elliott' && SIC_code='5651'DB:business_master_new
loadtime:0.57618594169617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellston' limit 1
loadtime:0.57621192932129 / seconds
Query Executed:select id FROM `ia` where city='Ellston' && SIC_code='5651'DB:business_master_new
loadtime:0.57665085792542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.57669997215271 / seconds
Query Executed:select id FROM `ia` where city='Ellsworth' && SIC_code='5651'DB:business_master_new
loadtime:0.57707500457764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elma' limit 1
loadtime:0.57711291313171 / seconds
Query Executed:select id FROM `ia` where city='Elma' && SIC_code='5651'DB:business_master_new
loadtime:0.57751893997192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:0.57755494117737 / seconds
Query Executed:select id FROM `ia` where city='Elwood' && SIC_code='5651'DB:business_master_new
loadtime:0.57788181304932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ely' limit 1
loadtime:0.57791686058044 / seconds
Query Executed:select id FROM `ia` where city='Ely' && SIC_code='5651'DB:business_master_new
loadtime:0.57835388183594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:0.57840085029602 / seconds
Query Executed:select id FROM `ia` where city='Emerson' && SIC_code='5651'DB:business_master_new
loadtime:0.57879090309143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emmetsburg' limit 1
loadtime:0.57881784439087 / seconds
Query Executed:select id FROM `ia` where city='Emmetsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.57993984222412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epworth' limit 1
loadtime:0.5799880027771 / seconds
Query Executed:select id FROM `ia` where city='Epworth' && SIC_code='5651'DB:business_master_new
loadtime:0.58041787147522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.58046579360962 / seconds
Query Executed:select id FROM `ia` where city='Essex' && SIC_code='5651'DB:business_master_new
loadtime:0.58087396621704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estherville' limit 1
loadtime:0.5809018611908 / seconds
Query Executed:select id FROM `ia` where city='Estherville' && SIC_code='5651'DB:business_master_new
loadtime:0.58200693130493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansdale' limit 1
loadtime:0.58207082748413 / seconds
Query Executed:select id FROM `ia` where city='Evansdale' && SIC_code='5651'DB:business_master_new
loadtime:0.58252000808716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everly' limit 1
loadtime:0.58255481719971 / seconds
Query Executed:select id FROM `ia` where city='Everly' && SIC_code='5651'DB:business_master_new
loadtime:0.58293795585632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exira' limit 1
loadtime:0.58297681808472 / seconds
Query Executed:select id FROM `ia` where city='Exira' && SIC_code='5651'DB:business_master_new
loadtime:0.58341789245605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exline' limit 1
loadtime:0.58345484733582 / seconds
Query Executed:select id FROM `ia` where city='Exline' && SIC_code='5651'DB:business_master_new
loadtime:0.58383893966675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairbank' limit 1
loadtime:0.58388090133667 / seconds
Query Executed:select id FROM `ia` where city='Fairbank' && SIC_code='5651'DB:business_master_new
loadtime:0.58427095413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfax' limit 1
loadtime:0.58430790901184 / seconds
Query Executed:select id FROM `ia` where city='Fairfax' && SIC_code='5651'DB:business_master_new
loadtime:0.58473491668701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.58477878570557 / seconds
Query Executed:select id FROM `ia` where city='Fairfield' && SIC_code='5651'DB:business_master_new
loadtime:0.58590793609619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farley' limit 1
loadtime:0.58595180511475 / seconds
Query Executed:select id FROM `ia` where city='Farley' && SIC_code='5651'DB:business_master_new
loadtime:0.58641195297241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmersburg' limit 1
loadtime:0.58646082878113 / seconds
Query Executed:select id FROM `ia` where city='Farmersburg' && SIC_code='5651'DB:business_master_new
loadtime:0.58684396743774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.58687877655029 / seconds
Query Executed:select id FROM `ia` where city='Farmington' && SIC_code='5651'DB:business_master_new
loadtime:0.58728098869324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farnhamville' limit 1
loadtime:0.58730578422546 / seconds
Query Executed:select id FROM `ia` where city='Farnhamville' && SIC_code='5651'DB:business_master_new
loadtime:0.58771896362305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farragut' limit 1
loadtime:0.58776593208313 / seconds
Query Executed:select id FROM `ia` where city='Farragut' && SIC_code='5651'DB:business_master_new
loadtime:0.58813786506653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.58817195892334 / seconds
Query Executed:select id FROM `ia` where city='Fayette' && SIC_code='5651'DB:business_master_new
loadtime:0.58858180046082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fenton' limit 1
loadtime:0.58863091468811 / seconds
Query Executed:select id FROM `ia` where city='Fenton' && SIC_code='5651'DB:business_master_new
loadtime:0.58903789520264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:0.58907794952393 / seconds
Query Executed:select id FROM `ia` where city='Ferguson' && SIC_code='5651'DB:business_master_new
loadtime:0.58942484855652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fertile' limit 1
loadtime:0.58947682380676 / seconds
Query Executed:select id FROM `ia` where city='Fertile' && SIC_code='5651'DB:business_master_new
loadtime:0.58984780311584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Festina' limit 1
loadtime:0.58988189697266 / seconds
Query Executed:select id FROM `ia` where city='Festina' && SIC_code='5651'DB:business_master_new
loadtime:0.59015798568726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floris' limit 1
loadtime:0.5901927947998 / seconds
Query Executed:select id FROM `ia` where city='Floris' && SIC_code='5651'DB:business_master_new
loadtime:0.59061098098755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Floyd' limit 1
loadtime:0.5906457901001 / seconds
Query Executed:select id FROM `ia` where city='Floyd' && SIC_code='5651'DB:business_master_new
loadtime:0.59103083610535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fonda' limit 1
loadtime:0.59108090400696 / seconds
Query Executed:select id FROM `ia` where city='Fonda' && SIC_code='5651'DB:business_master_new
loadtime:0.59150290489197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontanelle' limit 1
loadtime:0.59153890609741 / seconds
Query Executed:select id FROM `ia` where city='Fontanelle' && SIC_code='5651'DB:business_master_new
loadtime:0.59192490577698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:0.59196090698242 / seconds
Query Executed:select id FROM `ia` where city='Forest City' && SIC_code='5651'DB:business_master_new
loadtime:0.59308886528015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Atkinson' limit 1
loadtime:0.5931248664856 / seconds
Query Executed:select id FROM `ia` where city='Fort Atkinson' && SIC_code='5651'DB:business_master_new
loadtime:0.59357595443726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dodge' limit 1
loadtime:0.59362697601318 / seconds
Query Executed:select id FROM `ia` where city='Fort Dodge' && SIC_code='5651'DB:business_master_new
loadtime:0.59476184844971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Madison' limit 1
loadtime:0.59480500221252 / seconds
Query Executed:select id FROM `ia` where city='Fort Madison' && SIC_code='5651'DB:business_master_new
loadtime:0.59607791900635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fostoria' limit 1
loadtime:0.59613394737244 / seconds
Query Executed:select id FROM `ia` where city='Fostoria' && SIC_code='5651'DB:business_master_new
loadtime:0.59652781486511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredericksburg' limit 1
loadtime:0.59657287597656 / seconds
Query Executed:select id FROM `ia` where city='Fredericksburg' && SIC_code='5651'DB:business_master_new
loadtime:0.59702396392822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frederika' limit 1
loadtime:0.59706497192383 / seconds
Query Executed:select id FROM `ia` where city='Frederika' && SIC_code='5651'DB:business_master_new
loadtime:0.59746599197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.59751582145691 / seconds
Query Executed:select id FROM `ia` where city='Fremont' && SIC_code='5651'DB:business_master_new
loadtime:0.59790778160095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.59793591499329 / seconds
Query Executed:select id FROM `ia` where city='Fruitland' && SIC_code='5651'DB:business_master_new
loadtime:0.59832692146301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galt' limit 1
loadtime:0.59837484359741 / seconds
Query Executed:select id FROM `ia` where city='Galt' && SIC_code='5651'DB:business_master_new
loadtime:0.59868884086609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galva' limit 1
loadtime:0.59872984886169 / seconds
Query Executed:select id FROM `ia` where city='Galva' && SIC_code='5651'DB:business_master_new
loadtime:0.59912896156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garber' limit 1
loadtime:0.59916496276855 / seconds
Query Executed:select id FROM `ia` where city='Garber' && SIC_code='5651'DB:business_master_new
loadtime:0.59962797164917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.59967494010925 / seconds
Query Executed:select id FROM `ia` where city='Garden City' && SIC_code='5651'DB:business_master_new
loadtime:0.60000777244568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden Grove' limit 1
loadtime:0.6000349521637 / seconds
Query Executed:select id FROM `ia` where city='Garden Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.60045790672302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garnavillo' limit 1
loadtime:0.60050487518311 / seconds
Query Executed:select id FROM `ia` where city='Garnavillo' && SIC_code='5651'DB:business_master_new
loadtime:0.60090780258179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:0.6009418964386 / seconds
Query Executed:select id FROM `ia` where city='Garner' && SIC_code='5651'DB:business_master_new
loadtime:0.6020839214325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.60214185714722 / seconds
Query Executed:select id FROM `ia` where city='Garrison' && SIC_code='5651'DB:business_master_new
loadtime:0.60257387161255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwin' limit 1
loadtime:0.60260891914368 / seconds
Query Executed:select id FROM `ia` where city='Garwin' && SIC_code='5651'DB:business_master_new
loadtime:0.60299277305603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneva' limit 1
loadtime:0.603031873703 / seconds
Query Executed:select id FROM `ia` where city='Geneva' && SIC_code='5651'DB:business_master_new
loadtime:0.60343980789185 / seconds
Query loaded from cache:select * from geodata_geocity where city='George' limit 1
loadtime:0.60348796844482 / seconds
Query Executed:select id FROM `ia` where city='George' && SIC_code='5651'DB:business_master_new
loadtime:0.60391497612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:0.60394382476807 / seconds
Query Executed:select id FROM `ia` where city='Gibson' && SIC_code='5651'DB:business_master_new
loadtime:0.6042788028717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gifford' limit 1
loadtime:0.60431480407715 / seconds
Query Executed:select id FROM `ia` where city='Gifford' && SIC_code='5651'DB:business_master_new
loadtime:0.60464882850647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.6046929359436 / seconds
Query Executed:select id FROM `ia` where city='Gilbert' && SIC_code='5651'DB:business_master_new
loadtime:0.60506796836853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertville' limit 1
loadtime:0.60509490966797 / seconds
Query Executed:select id FROM `ia` where city='Gilbertville' && SIC_code='5651'DB:business_master_new
loadtime:0.61072087287903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillett Grove' limit 1
loadtime:0.61076998710632 / seconds
Query Executed:select id FROM `ia` where city='Gillett Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.61118793487549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.61122584342957 / seconds
Query Executed:select id FROM `ia` where city='Gilman' && SIC_code='5651'DB:business_master_new
loadtime:0.61166977882385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilmore City' limit 1
loadtime:0.61171579360962 / seconds
Query Executed:select id FROM `ia` where city='Gilmore City' && SIC_code='5651'DB:business_master_new
loadtime:0.61210680007935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladbrook' limit 1
loadtime:0.61213397979736 / seconds
Query Executed:select id FROM `ia` where city='Gladbrook' && SIC_code='5651'DB:business_master_new
loadtime:0.61255693435669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.61260986328125 / seconds
Query Executed:select id FROM `ia` where city='Glenwood' && SIC_code='5651'DB:business_master_new
loadtime:0.61374688148499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glidden' limit 1
loadtime:0.61379480361938 / seconds
Query Executed:select id FROM `ia` where city='Glidden' && SIC_code='5651'DB:business_master_new
loadtime:0.61422181129456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldfield' limit 1
loadtime:0.61425590515137 / seconds
Query Executed:select id FROM `ia` where city='Goldfield' && SIC_code='5651'DB:business_master_new
loadtime:0.61466693878174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodell' limit 1
loadtime:0.61471390724182 / seconds
Query Executed:select id FROM `ia` where city='Goodell' && SIC_code='5651'DB:business_master_new
loadtime:0.61509490013123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goose Lake' limit 1
loadtime:0.6151328086853 / seconds
Query Executed:select id FROM `ia` where city='Goose Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.61553883552551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gowrie' limit 1
loadtime:0.61558794975281 / seconds
Query Executed:select id FROM `ia` where city='Gowrie' && SIC_code='5651'DB:business_master_new
loadtime:0.61602282524109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graettinger' limit 1
loadtime:0.61606287956238 / seconds
Query Executed:select id FROM `ia` where city='Graettinger' && SIC_code='5651'DB:business_master_new
loadtime:0.61647486686707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.61652278900146 / seconds
Query Executed:select id FROM `ia` where city='Grafton' && SIC_code='5651'DB:business_master_new
loadtime:0.61693692207336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Junction' limit 1
loadtime:0.61697196960449 / seconds
Query Executed:select id FROM `ia` where city='Grand Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.61738085746765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Mound' limit 1
loadtime:0.6174168586731 / seconds
Query Executed:select id FROM `ia` where city='Grand Mound' && SIC_code='5651'DB:business_master_new
loadtime:0.61781597137451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand River' limit 1
loadtime:0.61785578727722 / seconds
Query Executed:select id FROM `ia` where city='Grand River' && SIC_code='5651'DB:business_master_new
loadtime:0.61828088760376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandview' limit 1
loadtime:0.61830592155457 / seconds
Query Executed:select id FROM `ia` where city='Grandview' && SIC_code='5651'DB:business_master_new
loadtime:0.61875081062317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:0.61878681182861 / seconds
Query Executed:select id FROM `ia` where city='Granger' && SIC_code='5651'DB:business_master_new
loadtime:0.61922383308411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:0.61925077438354 / seconds
Query Executed:select id FROM `ia` where city='Grant' && SIC_code='5651'DB:business_master_new
loadtime:0.61960291862488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granville' limit 1
loadtime:0.61965084075928 / seconds
Query Executed:select id FROM `ia` where city='Granville' && SIC_code='5651'DB:business_master_new
loadtime:0.62005996704102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gravity' limit 1
loadtime:0.62008786201477 / seconds
Query Executed:select id FROM `ia` where city='Gravity' && SIC_code='5651'DB:business_master_new
loadtime:0.62049984931946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray' limit 1
loadtime:0.62054800987244 / seconds
Query Executed:select id FROM `ia` where city='Gray' && SIC_code='5651'DB:business_master_new
loadtime:0.62087678909302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greeley' limit 1
loadtime:0.62091088294983 / seconds
Query Executed:select id FROM `ia` where city='Greeley' && SIC_code='5651'DB:business_master_new
loadtime:0.62134480476379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:0.62138199806213 / seconds
Query Executed:select id FROM `ia` where city='Green Mountain' && SIC_code='5651'DB:business_master_new
loadtime:0.62165689468384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greene' limit 1
loadtime:0.62169599533081 / seconds
Query Executed:select id FROM `ia` where city='Greene' && SIC_code='5651'DB:business_master_new
loadtime:0.62210988998413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.62214279174805 / seconds
Query Executed:select id FROM `ia` where city='Greenfield' && SIC_code='5651'DB:business_master_new
loadtime:0.62261390686035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.62266182899475 / seconds
Query Executed:select id FROM `ia` where city='Greenville' && SIC_code='5651'DB:business_master_new
loadtime:0.62307381629944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimes' limit 1
loadtime:0.62310194969177 / seconds
Query Executed:select id FROM `ia` where city='Grimes' && SIC_code='5651'DB:business_master_new
loadtime:0.62421989440918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grinnell' limit 1
loadtime:0.62426996231079 / seconds
Query Executed:select id FROM `ia` where city='Grinnell' && SIC_code='5651'DB:business_master_new
loadtime:0.62538385391235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Griswold' limit 1
loadtime:0.6254198551178 / seconds
Query Executed:select id FROM `ia` where city='Griswold' && SIC_code='5651'DB:business_master_new
loadtime:0.62588095664978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grundy Center' limit 1
loadtime:0.62593078613281 / seconds
Query Executed:select id FROM `ia` where city='Grundy Center' && SIC_code='5651'DB:business_master_new
loadtime:0.62643384933472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gruver' limit 1
loadtime:0.62648892402649 / seconds
Query Executed:select id FROM `ia` where city='Gruver' && SIC_code='5651'DB:business_master_new
loadtime:0.62682390213013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guernsey' limit 1
loadtime:0.62685179710388 / seconds
Query Executed:select id FROM `ia` where city='Guernsey' && SIC_code='5651'DB:business_master_new
loadtime:0.62728786468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guthrie Center' limit 1
loadtime:0.62732577323914 / seconds
Query Executed:select id FROM `ia` where city='Guthrie Center' && SIC_code='5651'DB:business_master_new
loadtime:0.62778091430664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:0.62781691551208 / seconds
Query Executed:select id FROM `ia` where city='Guttenberg' && SIC_code='5651'DB:business_master_new
loadtime:0.62825393676758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halbur' limit 1
loadtime:0.62829685211182 / seconds
Query Executed:select id FROM `ia` where city='Halbur' && SIC_code='5651'DB:business_master_new
loadtime:0.62875294685364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:0.6287989616394 / seconds
Query Executed:select id FROM `ia` where city='Hamburg' && SIC_code='5651'DB:business_master_new
loadtime:0.62920880317688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:0.6292359828949 / seconds
Query Executed:select id FROM `ia` where city='Hamilton' && SIC_code='5651'DB:business_master_new
loadtime:0.62950587272644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlin' limit 1
loadtime:0.62954187393188 / seconds
Query Executed:select id FROM `ia` where city='Hamlin' && SIC_code='5651'DB:business_master_new
loadtime:0.62993288040161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.62996482849121 / seconds
Query Executed:select id FROM `ia` where city='Hampton' && SIC_code='5651'DB:business_master_new
loadtime:0.63107991218567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.63112497329712 / seconds
Query Executed:select id FROM `ia` where city='Hancock' && SIC_code='5651'DB:business_master_new
loadtime:0.63154697418213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanlontown' limit 1
loadtime:0.63159584999084 / seconds
Query Executed:select id FROM `ia` where city='Hanlontown' && SIC_code='5651'DB:business_master_new
loadtime:0.63197493553162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hansell' limit 1
loadtime:0.63200187683105 / seconds
Query Executed:select id FROM `ia` where city='Hansell' && SIC_code='5651'DB:business_master_new
loadtime:0.63228893280029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harcourt' limit 1
loadtime:0.63232588768005 / seconds
Query Executed:select id FROM `ia` where city='Harcourt' && SIC_code='5651'DB:business_master_new
loadtime:0.63271188735962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardy' limit 1
loadtime:0.63274788856506 / seconds
Query Executed:select id FROM `ia` where city='Hardy' && SIC_code='5651'DB:business_master_new
loadtime:0.63313889503479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harlan' limit 1
loadtime:0.63318085670471 / seconds
Query Executed:select id FROM `ia` where city='Harlan' && SIC_code='5651'DB:business_master_new
loadtime:0.63427782058716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harper' limit 1
loadtime:0.6343138217926 / seconds
Query Executed:select id FROM `ia` where city='Harper' && SIC_code='5651'DB:business_master_new
loadtime:0.63478398323059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpers Ferry' limit 1
loadtime:0.63483190536499 / seconds
Query Executed:select id FROM `ia` where city='Harpers Ferry' && SIC_code='5651'DB:business_master_new
loadtime:0.63523077964783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:0.63527178764343 / seconds
Query Executed:select id FROM `ia` where city='Harris' && SIC_code='5651'DB:business_master_new
loadtime:0.63574385643005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.63578581809998 / seconds
Query Executed:select id FROM `ia` where city='Hartford' && SIC_code='5651'DB:business_master_new
loadtime:0.63619184494019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartley' limit 1
loadtime:0.63622999191284 / seconds
Query Executed:select id FROM `ia` where city='Hartley' && SIC_code='5651'DB:business_master_new
loadtime:0.63667893409729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartwick' limit 1
loadtime:0.63672280311584 / seconds
Query Executed:select id FROM `ia` where city='Hartwick' && SIC_code='5651'DB:business_master_new
loadtime:0.63707494735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey' limit 1
loadtime:0.63710284233093 / seconds
Query Executed:select id FROM `ia` where city='Harvey' && SIC_code='5651'DB:business_master_new
loadtime:0.63751983642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hastings' limit 1
loadtime:0.63756680488586 / seconds
Query Executed:select id FROM `ia` where city='Hastings' && SIC_code='5651'DB:business_master_new
loadtime:0.63801789283752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:0.63806486129761 / seconds
Query Executed:select id FROM `ia` where city='Havelock' && SIC_code='5651'DB:business_master_new
loadtime:0.63847279548645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.63850879669189 / seconds
Query Executed:select id FROM `ia` where city='Haverhill' && SIC_code='5651'DB:business_master_new
loadtime:0.63892197608948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawarden' limit 1
loadtime:0.63896083831787 / seconds
Query Executed:select id FROM `ia` where city='Hawarden' && SIC_code='5651'DB:business_master_new
loadtime:0.63942098617554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawkeye' limit 1
loadtime:0.63945579528809 / seconds
Query Executed:select id FROM `ia` where city='Hawkeye' && SIC_code='5651'DB:business_master_new
loadtime:0.63983488082886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:0.6398777961731 / seconds
Query Executed:select id FROM `ia` where city='Hayesville' && SIC_code='5651'DB:business_master_new
loadtime:0.64017796516418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazleton' limit 1
loadtime:0.64020490646362 / seconds
Query Executed:select id FROM `ia` where city='Hazleton' && SIC_code='5651'DB:business_master_new
loadtime:0.6405987739563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hedrick' limit 1
loadtime:0.64064598083496 / seconds
Query Executed:select id FROM `ia` where city='Hedrick' && SIC_code='5651'DB:business_master_new
loadtime:0.6410608291626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:0.64109897613525 / seconds
Query Executed:select id FROM `ia` where city='Henderson' && SIC_code='5651'DB:business_master_new
loadtime:0.64809799194336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.64814591407776 / seconds
Query Executed:select id FROM `ia` where city='Hiawatha' && SIC_code='5651'DB:business_master_new
loadtime:0.649258852005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlandville' limit 1
loadtime:0.64929485321045 / seconds
Query Executed:select id FROM `ia` where city='Highlandville' && SIC_code='5651'DB:business_master_new
loadtime:0.64961791038513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hills' limit 1
loadtime:0.64966678619385 / seconds
Query Executed:select id FROM `ia` where city='Hills' && SIC_code='5651'DB:business_master_new
loadtime:0.65007591247559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.65011286735535 / seconds
Query Executed:select id FROM `ia` where city='Hillsboro' && SIC_code='5651'DB:business_master_new
loadtime:0.65057682991028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinton' limit 1
loadtime:0.65061187744141 / seconds
Query Executed:select id FROM `ia` where city='Hinton' && SIC_code='5651'DB:business_master_new
loadtime:0.65100288391113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holland' limit 1
loadtime:0.65104079246521 / seconds
Query Executed:select id FROM `ia` where city='Holland' && SIC_code='5651'DB:business_master_new
loadtime:0.65146279335022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holstein' limit 1
loadtime:0.6515109539032 / seconds
Query Executed:select id FROM `ia` where city='Holstein' && SIC_code='5651'DB:business_master_new
loadtime:0.65193796157837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holy Cross' limit 1
loadtime:0.65196490287781 / seconds
Query Executed:select id FROM `ia` where city='Holy Cross' && SIC_code='5651'DB:business_master_new
loadtime:0.65237879753113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homestead' limit 1
loadtime:0.65242695808411 / seconds
Query Executed:select id FROM `ia` where city='Homestead' && SIC_code='5651'DB:business_master_new
loadtime:0.65282988548279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honey Creek' limit 1
loadtime:0.65287184715271 / seconds
Query Executed:select id FROM `ia` where city='Honey Creek' && SIC_code='5651'DB:business_master_new
loadtime:0.65327191352844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.65331077575684 / seconds
Query Executed:select id FROM `ia` where city='Hopkinton' && SIC_code='5651'DB:business_master_new
loadtime:0.65370798110962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hornick' limit 1
loadtime:0.6537549495697 / seconds
Query Executed:select id FROM `ia` where city='Hornick' && SIC_code='5651'DB:business_master_new
loadtime:0.65414190292358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hospers' limit 1
loadtime:0.65416884422302 / seconds
Query Executed:select id FROM `ia` where city='Hospers' && SIC_code='5651'DB:business_master_new
loadtime:0.65459299087524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houghton' limit 1
loadtime:0.65463995933533 / seconds
Query Executed:select id FROM `ia` where city='Houghton' && SIC_code='5651'DB:business_master_new
loadtime:0.66197800636292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubbard' limit 1
loadtime:0.66201496124268 / seconds
Query Executed:select id FROM `ia` where city='Hubbard' && SIC_code='5651'DB:business_master_new
loadtime:0.66246390342712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.66251182556152 / seconds
Query Executed:select id FROM `ia` where city='Hudson' && SIC_code='5651'DB:business_master_new
loadtime:0.66297292709351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hull' limit 1
loadtime:0.66300892829895 / seconds
Query Executed:select id FROM `ia` where city='Hull' && SIC_code='5651'DB:business_master_new
loadtime:0.66348886489868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.66353988647461 / seconds
Query Executed:select id FROM `ia` where city='Humboldt' && SIC_code='5651'DB:business_master_new
loadtime:0.66467189788818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humeston' limit 1
loadtime:0.66472196578979 / seconds
Query Executed:select id FROM `ia` where city='Humeston' && SIC_code='5651'DB:business_master_new
loadtime:0.66512680053711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huxley' limit 1
loadtime:0.66515493392944 / seconds
Query Executed:select id FROM `ia` where city='Huxley' && SIC_code='5651'DB:business_master_new
loadtime:0.66557383537292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ida Grove' limit 1
loadtime:0.6656129360199 / seconds
Query Executed:select id FROM `ia` where city='Ida Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.66607689857483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imogene' limit 1
loadtime:0.6661229133606 / seconds
Query Executed:select id FROM `ia` where city='Imogene' && SIC_code='5651'DB:business_master_new
loadtime:0.66657996177673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Independence' limit 1
loadtime:0.66661691665649 / seconds
Query Executed:select id FROM `ia` where city='Independence' && SIC_code='5651'DB:business_master_new
loadtime:0.6677508354187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indianola' limit 1
loadtime:0.66780090332031 / seconds
Query Executed:select id FROM `ia` where city='Indianola' && SIC_code='5651'DB:business_master_new
loadtime:0.66892099380493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Inwood' limit 1
loadtime:0.66895794868469 / seconds
Query Executed:select id FROM `ia` where city='Inwood' && SIC_code='5651'DB:business_master_new
loadtime:0.66943693161011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ionia' limit 1
loadtime:0.66948485374451 / seconds
Query Executed:select id FROM `ia` where city='Ionia' && SIC_code='5651'DB:business_master_new
loadtime:0.66990280151367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa City' limit 1
loadtime:0.66993880271912 / seconds
Query Executed:select id FROM `ia` where city='Iowa City' && SIC_code='5651'DB:business_master_new
loadtime:0.67108488082886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iowa Falls' limit 1
loadtime:0.67114400863647 / seconds
Query Executed:select id FROM `ia` where city='Iowa Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.67224884033203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ira' limit 1
loadtime:0.67229700088501 / seconds
Query Executed:select id FROM `ia` where city='Ira' && SIC_code='5651'DB:business_master_new
loadtime:0.67269277572632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ireton' limit 1
loadtime:0.67272877693176 / seconds
Query Executed:select id FROM `ia` where city='Ireton' && SIC_code='5651'DB:business_master_new
loadtime:0.67312788963318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irwin' limit 1
loadtime:0.67316699028015 / seconds
Query Executed:select id FROM `ia` where city='Irwin' && SIC_code='5651'DB:business_master_new
loadtime:0.673583984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Junction' limit 1
loadtime:0.67361879348755 / seconds
Query Executed:select id FROM `ia` where city='Jackson Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.6739227771759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamaica' limit 1
loadtime:0.67395782470703 / seconds
Query Executed:select id FROM `ia` where city='Jamaica' && SIC_code='5651'DB:business_master_new
loadtime:0.67438077926636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Janesville' limit 1
loadtime:0.6744167804718 / seconds
Query Executed:select id FROM `ia` where city='Janesville' && SIC_code='5651'DB:business_master_new
loadtime:0.67485690116882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.67489194869995 / seconds
Query Executed:select id FROM `ia` where city='Jefferson' && SIC_code='5651'DB:business_master_new
loadtime:0.67603278160095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jesup' limit 1
loadtime:0.67609286308289 / seconds
Query Executed:select id FROM `ia` where city='Jesup' && SIC_code='5651'DB:business_master_new
loadtime:0.67657279968262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewell' limit 1
loadtime:0.67660880088806 / seconds
Query Executed:select id FROM `ia` where city='Jewell' && SIC_code='5651'DB:business_master_new
loadtime:0.6770339012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnston' limit 1
loadtime:0.67708992958069 / seconds
Query Executed:select id FROM `ia` where city='Johnston' && SIC_code='5651'DB:business_master_new
loadtime:0.67818784713745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joice' limit 1
loadtime:0.67823600769043 / seconds
Query Executed:select id FROM `ia` where city='Joice' && SIC_code='5651'DB:business_master_new
loadtime:0.67866897583008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jolley' limit 1
loadtime:0.67870497703552 / seconds
Query Executed:select id FROM `ia` where city='Jolley' && SIC_code='5651'DB:business_master_new
loadtime:0.67914390563965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalona' limit 1
loadtime:0.67918300628662 / seconds
Query Executed:select id FROM `ia` where city='Kalona' && SIC_code='5651'DB:business_master_new
loadtime:0.68027400970459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamrar' limit 1
loadtime:0.68030977249146 / seconds
Query Executed:select id FROM `ia` where city='Kamrar' && SIC_code='5651'DB:business_master_new
loadtime:0.68588590621948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanawha' limit 1
loadtime:0.68593287467957 / seconds
Query Executed:select id FROM `ia` where city='Kanawha' && SIC_code='5651'DB:business_master_new
loadtime:0.6863899230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellerton' limit 1
loadtime:0.68642687797546 / seconds
Query Executed:select id FROM `ia` where city='Kellerton' && SIC_code='5651'DB:business_master_new
loadtime:0.68682193756104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelley' limit 1
loadtime:0.68686985969543 / seconds
Query Executed:select id FROM `ia` where city='Kelley' && SIC_code='5651'DB:business_master_new
loadtime:0.68726992607117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellogg' limit 1
loadtime:0.68730878829956 / seconds
Query Executed:select id FROM `ia` where city='Kellogg' && SIC_code='5651'DB:business_master_new
loadtime:0.68773293495178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensett' limit 1
loadtime:0.68776893615723 / seconds
Query Executed:select id FROM `ia` where city='Kensett' && SIC_code='5651'DB:business_master_new
loadtime:0.68814182281494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.68818092346191 / seconds
Query Executed:select id FROM `ia` where city='Kent' && SIC_code='5651'DB:business_master_new
loadtime:0.68848896026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keokuk' limit 1
loadtime:0.68853378295898 / seconds
Query Executed:select id FROM `ia` where city='Keokuk' && SIC_code='5651'DB:business_master_new
loadtime:0.6896538734436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keosauqua' limit 1
loadtime:0.68970990180969 / seconds
Query Executed:select id FROM `ia` where city='Keosauqua' && SIC_code='5651'DB:business_master_new
loadtime:0.6901638507843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keota' limit 1
loadtime:0.69019198417664 / seconds
Query Executed:select id FROM `ia` where city='Keota' && SIC_code='5651'DB:business_master_new
loadtime:0.69062280654907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kesley' limit 1
loadtime:0.69066977500916 / seconds
Query Executed:select id FROM `ia` where city='Kesley' && SIC_code='5651'DB:business_master_new
loadtime:0.69100689888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keswick' limit 1
loadtime:0.69103479385376 / seconds
Query Executed:select id FROM `ia` where city='Keswick' && SIC_code='5651'DB:business_master_new
loadtime:0.69143581390381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keystone' limit 1
loadtime:0.6914849281311 / seconds
Query Executed:select id FROM `ia` where city='Keystone' && SIC_code='5651'DB:business_master_new
loadtime:0.69187879562378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killduff' limit 1
loadtime:0.6919059753418 / seconds
Query Executed:select id FROM `ia` where city='Killduff' && SIC_code='5651'DB:business_master_new
loadtime:0.69226288795471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimballton' limit 1
loadtime:0.69229984283447 / seconds
Query Executed:select id FROM `ia` where city='Kimballton' && SIC_code='5651'DB:business_master_new
loadtime:0.69271278381348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingsley' limit 1
loadtime:0.6927478313446 / seconds
Query Executed:select id FROM `ia` where city='Kingsley' && SIC_code='5651'DB:business_master_new
loadtime:0.69314789772034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinross' limit 1
loadtime:0.69318795204163 / seconds
Query Executed:select id FROM `ia` where city='Kinross' && SIC_code='5651'DB:business_master_new
loadtime:0.69350600242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkman' limit 1
loadtime:0.6935498714447 / seconds
Query Executed:select id FROM `ia` where city='Kirkman' && SIC_code='5651'DB:business_master_new
loadtime:0.69398498535156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkville' limit 1
loadtime:0.694011926651 / seconds
Query Executed:select id FROM `ia` where city='Kirkville' && SIC_code='5651'DB:business_master_new
loadtime:0.69434881210327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kiron' limit 1
loadtime:0.69439697265625 / seconds
Query Executed:select id FROM `ia` where city='Kiron' && SIC_code='5651'DB:business_master_new
loadtime:0.69477391242981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Klemme' limit 1
loadtime:0.69480180740356 / seconds
Query Executed:select id FROM `ia` where city='Klemme' && SIC_code='5651'DB:business_master_new
loadtime:0.69517683982849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knierim' limit 1
loadtime:0.69521284103394 / seconds
Query Executed:select id FROM `ia` where city='Knierim' && SIC_code='5651'DB:business_master_new
loadtime:0.69557499885559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knoxville' limit 1
loadtime:0.69561100006104 / seconds
Query Executed:select id FROM `ia` where city='Knoxville' && SIC_code='5651'DB:business_master_new
loadtime:0.69672894477844 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Motte' limit 1
loadtime:0.69677686691284 / seconds
Query Executed:select id FROM `ia` where city='La Motte' && SIC_code='5651'DB:business_master_new
loadtime:0.69718885421753 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Porte City' limit 1
loadtime:0.69722580909729 / seconds
Query Executed:select id FROM `ia` where city='La Porte City' && SIC_code='5651'DB:business_master_new
loadtime:0.69767189025879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lacona' limit 1
loadtime:0.69770789146423 / seconds
Query Executed:select id FROM `ia` where city='Lacona' && SIC_code='5651'DB:business_master_new
loadtime:0.69808077812195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ladora' limit 1
loadtime:0.69811987876892 / seconds
Query Executed:select id FROM `ia` where city='Ladora' && SIC_code='5651'DB:business_master_new
loadtime:0.69851684570312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake City' limit 1
loadtime:0.69856977462769 / seconds
Query Executed:select id FROM `ia` where city='Lake City' && SIC_code='5651'DB:business_master_new
loadtime:0.69899487495422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Mills' limit 1
loadtime:0.69902300834656 / seconds
Query Executed:select id FROM `ia` where city='Lake Mills' && SIC_code='5651'DB:business_master_new
loadtime:0.69948387145996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Park' limit 1
loadtime:0.69953393936157 / seconds
Query Executed:select id FROM `ia` where city='Lake Park' && SIC_code='5651'DB:business_master_new
loadtime:0.69993877410889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake View' limit 1
loadtime:0.69997477531433 / seconds
Query Executed:select id FROM `ia` where city='Lake View' && SIC_code='5651'DB:business_master_new
loadtime:0.70043277740479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakota' limit 1
loadtime:0.70046997070312 / seconds
Query Executed:select id FROM `ia` where city='Lakota' && SIC_code='5651'DB:business_master_new
loadtime:0.70085477828979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamoni' limit 1
loadtime:0.7008957862854 / seconds
Query Executed:select id FROM `ia` where city='Lamoni' && SIC_code='5651'DB:business_master_new
loadtime:0.70134496688843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lamont' limit 1
loadtime:0.70137977600098 / seconds
Query Executed:select id FROM `ia` where city='Lamont' && SIC_code='5651'DB:business_master_new
loadtime:0.70177483558655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanesboro' limit 1
loadtime:0.70182299613953 / seconds
Query Executed:select id FROM `ia` where city='Lanesboro' && SIC_code='5651'DB:business_master_new
loadtime:0.7021689414978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langworthy' limit 1
loadtime:0.70220685005188 / seconds
Query Executed:select id FROM `ia` where city='Langworthy' && SIC_code='5651'DB:business_master_new
loadtime:0.70251488685608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:0.70256185531616 / seconds
Query Executed:select id FROM `ia` where city='Lansing' && SIC_code='5651'DB:business_master_new
loadtime:0.70299482345581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larchwood' limit 1
loadtime:0.70303678512573 / seconds
Query Executed:select id FROM `ia` where city='Larchwood' && SIC_code='5651'DB:business_master_new
loadtime:0.70346879959106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Larrabee' limit 1
loadtime:0.70350694656372 / seconds
Query Executed:select id FROM `ia` where city='Larrabee' && SIC_code='5651'DB:business_master_new
loadtime:0.70397686958313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Latimer' limit 1
loadtime:0.70401692390442 / seconds
Query Executed:select id FROM `ia` where city='Latimer' && SIC_code='5651'DB:business_master_new
loadtime:0.70444679260254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel' limit 1
loadtime:0.70448279380798 / seconds
Query Executed:select id FROM `ia` where city='Laurel' && SIC_code='5651'DB:business_master_new
loadtime:0.70485997200012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurens' limit 1
loadtime:0.70489883422852 / seconds
Query Executed:select id FROM `ia` where city='Laurens' && SIC_code='5651'DB:business_master_new
loadtime:0.70534300804138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawler' limit 1
loadtime:0.70537781715393 / seconds
Query Executed:select id FROM `ia` where city='Lawler' && SIC_code='5651'DB:business_master_new
loadtime:0.70577478408813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawton' limit 1
loadtime:0.70582294464111 / seconds
Query Executed:select id FROM `ia` where city='Lawton' && SIC_code='5651'DB:business_master_new
loadtime:0.70621585845947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Claire' limit 1
loadtime:0.70624494552612 / seconds
Query Executed:select id FROM `ia` where city='Le Claire' && SIC_code='5651'DB:business_master_new
loadtime:0.70668792724609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Grand' limit 1
loadtime:0.70673680305481 / seconds
Query Executed:select id FROM `ia` where city='Le Grand' && SIC_code='5651'DB:business_master_new
loadtime:0.70712685585022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Le Mars' limit 1
loadtime:0.70716595649719 / seconds
Query Executed:select id FROM `ia` where city='Le Mars' && SIC_code='5651'DB:business_master_new
loadtime:0.70825886726379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.70829486846924 / seconds
Query Executed:select id FROM `ia` where city='Ledyard' && SIC_code='5651'DB:business_master_new
loadtime:0.70868277549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehigh' limit 1
loadtime:0.70873093605042 / seconds
Query Executed:select id FROM `ia` where city='Lehigh' && SIC_code='5651'DB:business_master_new
loadtime:0.70911478996277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leighton' limit 1
loadtime:0.70914196968079 / seconds
Query Executed:select id FROM `ia` where city='Leighton' && SIC_code='5651'DB:business_master_new
loadtime:0.7095308303833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:0.70957899093628 / seconds
Query Executed:select id FROM `ia` where city='Leland' && SIC_code='5651'DB:business_master_new
loadtime:0.70996499061584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenox' limit 1
loadtime:0.7099928855896 / seconds
Query Executed:select id FROM `ia` where city='Lenox' && SIC_code='5651'DB:business_master_new
loadtime:0.71044087409973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leon' limit 1
loadtime:0.71048879623413 / seconds
Query Executed:select id FROM `ia` where city='Leon' && SIC_code='5651'DB:business_master_new
loadtime:0.71091198921204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:0.71093893051147 / seconds
Query Executed:select id FROM `ia` where city='Lester' && SIC_code='5651'DB:business_master_new
loadtime:0.71135282516479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letts' limit 1
loadtime:0.71140289306641 / seconds
Query Executed:select id FROM `ia` where city='Letts' && SIC_code='5651'DB:business_master_new
loadtime:0.71178793907166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewis' limit 1
loadtime:0.71182489395142 / seconds
Query Executed:select id FROM `ia` where city='Lewis' && SIC_code='5651'DB:business_master_new
loadtime:0.71220779418945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Center' limit 1
loadtime:0.71223378181458 / seconds
Query Executed:select id FROM `ia` where city='Liberty Center' && SIC_code='5651'DB:business_master_new
loadtime:0.71256399154663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Libertyville' limit 1
loadtime:0.71261096000671 / seconds
Query Executed:select id FROM `ia` where city='Libertyville' && SIC_code='5651'DB:business_master_new
loadtime:0.71300983428955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lidderdale' limit 1
loadtime:0.71303796768188 / seconds
Query Executed:select id FROM `ia` where city='Lidderdale' && SIC_code='5651'DB:business_master_new
loadtime:0.71345186233521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lime Springs' limit 1
loadtime:0.7134997844696 / seconds
Query Executed:select id FROM `ia` where city='Lime Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.71389079093933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.71391797065735 / seconds
Query Executed:select id FROM `ia` where city='Lincoln' && SIC_code='5651'DB:business_master_new
loadtime:0.71437788009644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:0.71442580223083 / seconds
Query Executed:select id FROM `ia` where city='Linden' && SIC_code='5651'DB:business_master_new
loadtime:0.71487998962402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lineville' limit 1
loadtime:0.71491384506226 / seconds
Query Executed:select id FROM `ia` where city='Lineville' && SIC_code='5651'DB:business_master_new
loadtime:0.71533799171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linn Grove' limit 1
loadtime:0.71537280082703 / seconds
Query Executed:select id FROM `ia` where city='Linn Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.71574187278748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.71578097343445 / seconds
Query Executed:select id FROM `ia` where city='Lisbon' && SIC_code='5651'DB:business_master_new
loadtime:0.71617794036865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liscomb' limit 1
loadtime:0.71620392799377 / seconds
Query Executed:select id FROM `ia` where city='Liscomb' && SIC_code='5651'DB:business_master_new
loadtime:0.71666693687439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Cedar' limit 1
loadtime:0.71671485900879 / seconds
Query Executed:select id FROM `ia` where city='Little Cedar' && SIC_code='5651'DB:business_master_new
loadtime:0.71707487106323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Rock' limit 1
loadtime:0.71710300445557 / seconds
Query Executed:select id FROM `ia` where city='Little Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.71752381324768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Sioux' limit 1
loadtime:0.71757078170776 / seconds
Query Executed:select id FROM `ia` where city='Little Sioux' && SIC_code='5651'DB:business_master_new
loadtime:0.71795892715454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livermore' limit 1
loadtime:0.71798586845398 / seconds
Query Executed:select id FROM `ia` where city='Livermore' && SIC_code='5651'DB:business_master_new
loadtime:0.71839499473572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockridge' limit 1
loadtime:0.7184419631958 / seconds
Query Executed:select id FROM `ia` where city='Lockridge' && SIC_code='5651'DB:business_master_new
loadtime:0.71882891654968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.71886396408081 / seconds
Query Executed:select id FROM `ia` where city='Logan' && SIC_code='5651'DB:business_master_new
loadtime:0.71934080123901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lohrville' limit 1
loadtime:0.71937799453735 / seconds
Query Executed:select id FROM `ia` where city='Lohrville' && SIC_code='5651'DB:business_master_new
loadtime:0.71978783607483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Rock' limit 1
loadtime:0.71983599662781 / seconds
Query Executed:select id FROM `ia` where city='Lone Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.72024297714233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lone Tree' limit 1
loadtime:0.72027087211609 / seconds
Query Executed:select id FROM `ia` where city='Lone Tree' && SIC_code='5651'DB:business_master_new
loadtime:0.72067189216614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Grove' limit 1
loadtime:0.72071981430054 / seconds
Query Executed:select id FROM `ia` where city='Long Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.72113180160522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lorimor' limit 1
loadtime:0.72116088867188 / seconds
Query Executed:select id FROM `ia` where city='Lorimor' && SIC_code='5651'DB:business_master_new
loadtime:0.7215359210968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Nation' limit 1
loadtime:0.7215838432312 / seconds
Query Executed:select id FROM `ia` where city='Lost Nation' && SIC_code='5651'DB:business_master_new
loadtime:0.72197198867798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovilia' limit 1
loadtime:0.72199892997742 / seconds
Query Executed:select id FROM `ia` where city='Lovilia' && SIC_code='5651'DB:business_master_new
loadtime:0.7224018573761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Low Moor' limit 1
loadtime:0.72243690490723 / seconds
Query Executed:select id FROM `ia` where city='Low Moor' && SIC_code='5651'DB:business_master_new
loadtime:0.72282385826111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowden' limit 1
loadtime:0.7228639125824 / seconds
Query Executed:select id FROM `ia` where city='Lowden' && SIC_code='5651'DB:business_master_new
loadtime:0.72327899932861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lu Verne' limit 1
loadtime:0.72330498695374 / seconds
Query Executed:select id FROM `ia` where city='Lu Verne' && SIC_code='5651'DB:business_master_new
loadtime:0.7236909866333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luana' limit 1
loadtime:0.7237389087677 / seconds
Query Executed:select id FROM `ia` where city='Luana' && SIC_code='5651'DB:business_master_new
loadtime:0.72412395477295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucas' limit 1
loadtime:0.7241518497467 / seconds
Query Executed:select id FROM `ia` where city='Lucas' && SIC_code='5651'DB:business_master_new
loadtime:0.72455286979675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luther' limit 1
loadtime:0.72460079193115 / seconds
Query Executed:select id FROM `ia` where city='Luther' && SIC_code='5651'DB:business_master_new
loadtime:0.72493696212769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luxemburg' limit 1
loadtime:0.72496485710144 / seconds
Query Executed:select id FROM `ia` where city='Luxemburg' && SIC_code='5651'DB:business_master_new
loadtime:0.72537183761597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luzerne' limit 1
loadtime:0.72541999816895 / seconds
Query Executed:select id FROM `ia` where city='Luzerne' && SIC_code='5651'DB:business_master_new
loadtime:0.72583985328674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynnville' limit 1
loadtime:0.72586798667908 / seconds
Query Executed:select id FROM `ia` where city='Lynnville' && SIC_code='5651'DB:business_master_new
loadtime:0.72625398635864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lytton' limit 1
loadtime:0.72628998756409 / seconds
Query Executed:select id FROM `ia` where city='Lytton' && SIC_code='5651'DB:business_master_new
loadtime:0.72668981552124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macedonia' limit 1
loadtime:0.72673392295837 / seconds
Query Executed:select id FROM `ia` where city='Macedonia' && SIC_code='5651'DB:business_master_new
loadtime:0.72713184356689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macksburg' limit 1
loadtime:0.72716093063354 / seconds
Query Executed:select id FROM `ia` where city='Macksburg' && SIC_code='5651'DB:business_master_new
loadtime:0.72759079933167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madrid' limit 1
loadtime:0.72762799263 / seconds
Query Executed:select id FROM `ia` where city='Madrid' && SIC_code='5651'DB:business_master_new
loadtime:0.72803592681885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:0.72809386253357 / seconds
Query Executed:select id FROM `ia` where city='Magnolia' && SIC_code='5651'DB:business_master_new
loadtime:0.72845387458801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malcom' limit 1
loadtime:0.72849082946777 / seconds
Query Executed:select id FROM `ia` where city='Malcom' && SIC_code='5651'DB:business_master_new
loadtime:0.72890090942383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mallard' limit 1
loadtime:0.72893691062927 / seconds
Query Executed:select id FROM `ia` where city='Mallard' && SIC_code='5651'DB:business_master_new
loadtime:0.72934198379517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maloy' limit 1
loadtime:0.72937798500061 / seconds
Query Executed:select id FROM `ia` where city='Maloy' && SIC_code='5651'DB:business_master_new
loadtime:0.72963500022888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malvern' limit 1
loadtime:0.72967386245728 / seconds
Query Executed:select id FROM `ia` where city='Malvern' && SIC_code='5651'DB:business_master_new
loadtime:0.73005795478821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.73009586334229 / seconds
Query Executed:select id FROM `ia` where city='Manchester' && SIC_code='5651'DB:business_master_new
loadtime:0.73120188713074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manilla' limit 1
loadtime:0.73123693466187 / seconds
Query Executed:select id FROM `ia` where city='Manilla' && SIC_code='5651'DB:business_master_new
loadtime:0.73165488243103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manly' limit 1
loadtime:0.73170399665833 / seconds
Query Executed:select id FROM `ia` where city='Manly' && SIC_code='5651'DB:business_master_new
loadtime:0.73211789131165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manning' limit 1
loadtime:0.73215484619141 / seconds
Query Executed:select id FROM `ia` where city='Manning' && SIC_code='5651'DB:business_master_new
loadtime:0.73258996009827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:0.73262596130371 / seconds
Query Executed:select id FROM `ia` where city='Manson' && SIC_code='5651'DB:business_master_new
loadtime:0.73303294181824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.7330858707428 / seconds
Query Executed:select id FROM `ia` where city='Mapleton' && SIC_code='5651'DB:business_master_new
loadtime:0.73353290557861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maquoketa' limit 1
loadtime:0.73357796669006 / seconds
Query Executed:select id FROM `ia` where city='Maquoketa' && SIC_code='5651'DB:business_master_new
loadtime:0.73471593856812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marathon' limit 1
loadtime:0.73475980758667 / seconds
Query Executed:select id FROM `ia` where city='Marathon' && SIC_code='5651'DB:business_master_new
loadtime:0.73518800735474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Rock' limit 1
loadtime:0.73523378372192 / seconds
Query Executed:select id FROM `ia` where city='Marble Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.73562693595886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marcus' limit 1
loadtime:0.73566293716431 / seconds
Query Executed:select id FROM `ia` where city='Marcus' && SIC_code='5651'DB:business_master_new
loadtime:0.73607397079468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marengo' limit 1
loadtime:0.73611378669739 / seconds
Query Executed:select id FROM `ia` where city='Marengo' && SIC_code='5651'DB:business_master_new
loadtime:0.73657894134521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.73661184310913 / seconds
Query Executed:select id FROM `ia` where city='Marion' && SIC_code='5651'DB:business_master_new
loadtime:0.73773789405823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marne' limit 1
loadtime:0.73777484893799 / seconds
Query Executed:select id FROM `ia` where city='Marne' && SIC_code='5651'DB:business_master_new
loadtime:0.73824882507324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marquette' limit 1
loadtime:0.73828887939453 / seconds
Query Executed:select id FROM `ia` where city='Marquette' && SIC_code='5651'DB:business_master_new
loadtime:0.73866677284241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshalltown' limit 1
loadtime:0.73870277404785 / seconds
Query Executed:select id FROM `ia` where city='Marshalltown' && SIC_code='5651'DB:business_master_new
loadtime:0.73983097076416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martelle' limit 1
loadtime:0.73988699913025 / seconds
Query Executed:select id FROM `ia` where city='Martelle' && SIC_code='5651'DB:business_master_new
loadtime:0.74026989936829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martensdale' limit 1
loadtime:0.74029898643494 / seconds
Query Executed:select id FROM `ia` where city='Martensdale' && SIC_code='5651'DB:business_master_new
loadtime:0.74075388908386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsburg' limit 1
loadtime:0.74080181121826 / seconds
Query Executed:select id FROM `ia` where city='Martinsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.74111294746399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason City' limit 1
loadtime:0.74114084243774 / seconds
Query Executed:select id FROM `ia` where city='Mason City' && SIC_code='5651'DB:business_master_new
loadtime:0.74224090576172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Masonville' limit 1
loadtime:0.74230098724365 / seconds
Query Executed:select id FROM `ia` where city='Masonville' && SIC_code='5651'DB:business_master_new
loadtime:0.74273300170898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Massena' limit 1
loadtime:0.74277997016907 / seconds
Query Executed:select id FROM `ia` where city='Massena' && SIC_code='5651'DB:business_master_new
loadtime:0.74317383766174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matlock' limit 1
loadtime:0.74320197105408 / seconds
Query Executed:select id FROM `ia` where city='Matlock' && SIC_code='5651'DB:business_master_new
loadtime:0.74355697631836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maurice' limit 1
loadtime:0.74360489845276 / seconds
Query Executed:select id FROM `ia` where city='Maurice' && SIC_code='5651'DB:business_master_new
loadtime:0.74399495124817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell' limit 1
loadtime:0.74402284622192 / seconds
Query Executed:select id FROM `ia` where city='Maxwell' && SIC_code='5651'DB:business_master_new
loadtime:0.74445486068726 / seconds
Query loaded from cache:select * from geodata_geocity where city='May City' limit 1
loadtime:0.74450182914734 / seconds
Query Executed:select id FROM `ia` where city='May City' && SIC_code='5651'DB:business_master_new
loadtime:0.74475383758545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maynard' limit 1
loadtime:0.74478983879089 / seconds
Query Executed:select id FROM `ia` where city='Maynard' && SIC_code='5651'DB:business_master_new
loadtime:0.74515986442566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Callsburg' limit 1
loadtime:0.74518585205078 / seconds
Query Executed:select id FROM `ia` where city='Mc Callsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.74557495117188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Causland' limit 1
loadtime:0.74562287330627 / seconds
Query Executed:select id FROM `ia` where city='Mc Causland' && SIC_code='5651'DB:business_master_new
loadtime:0.74604296684265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Clelland' limit 1
loadtime:0.74608397483826 / seconds
Query Executed:select id FROM `ia` where city='Mc Clelland' && SIC_code='5651'DB:business_master_new
loadtime:0.75146698951721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Gregor' limit 1
loadtime:0.75151777267456 / seconds
Query Executed:select id FROM `ia` where city='Mc Gregor' && SIC_code='5651'DB:business_master_new
loadtime:0.75195097923279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intire' limit 1
loadtime:0.75198578834534 / seconds
Query Executed:select id FROM `ia` where city='Mc Intire' && SIC_code='5651'DB:business_master_new
loadtime:0.75239682197571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mechanicsville' limit 1
loadtime:0.75243186950684 / seconds
Query Executed:select id FROM `ia` where city='Mechanicsville' && SIC_code='5651'DB:business_master_new
loadtime:0.75284385681152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mediapolis' limit 1
loadtime:0.75288081169128 / seconds
Query Executed:select id FROM `ia` where city='Mediapolis' && SIC_code='5651'DB:business_master_new
loadtime:0.7533438205719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melbourne' limit 1
loadtime:0.75339198112488 / seconds
Query Executed:select id FROM `ia` where city='Melbourne' && SIC_code='5651'DB:business_master_new
loadtime:0.75379586219788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melcher' limit 1
loadtime:0.75383186340332 / seconds
Query Executed:select id FROM `ia` where city='Melcher' && SIC_code='5651'DB:business_master_new
loadtime:0.75418782234192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melrose' limit 1
loadtime:0.75422978401184 / seconds
Query Executed:select id FROM `ia` where city='Melrose' && SIC_code='5651'DB:business_master_new
loadtime:0.75469493865967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:0.75473999977112 / seconds
Query Executed:select id FROM `ia` where city='Melvin' && SIC_code='5651'DB:business_master_new
loadtime:0.75512599945068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Menlo' limit 1
loadtime:0.75515484809875 / seconds
Query Executed:select id FROM `ia` where city='Menlo' && SIC_code='5651'DB:business_master_new
loadtime:0.75554895401001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.75559687614441 / seconds
Query Executed:select id FROM `ia` where city='Meriden' && SIC_code='5651'DB:business_master_new
loadtime:0.75603795051575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merrill' limit 1
loadtime:0.75607895851135 / seconds
Query Executed:select id FROM `ia` where city='Merrill' && SIC_code='5651'DB:business_master_new
loadtime:0.75649785995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meservey' limit 1
loadtime:0.75654697418213 / seconds
Query Executed:select id FROM `ia` where city='Meservey' && SIC_code='5651'DB:business_master_new
loadtime:0.75691795349121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Amana' limit 1
loadtime:0.75695180892944 / seconds
Query Executed:select id FROM `ia` where city='Middle Amana' && SIC_code='5651'DB:business_master_new
loadtime:0.75735592842102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.75739288330078 / seconds
Query Executed:select id FROM `ia` where city='Middletown' && SIC_code='5651'DB:business_master_new
loadtime:0.75782990455627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miles' limit 1
loadtime:0.75786900520325 / seconds
Query Executed:select id FROM `ia` where city='Miles' && SIC_code='5651'DB:business_master_new
loadtime:0.75825977325439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.7582859992981 / seconds
Query Executed:select id FROM `ia` where city='Milford' && SIC_code='5651'DB:business_master_new
loadtime:0.75942492485046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millersburg' limit 1
loadtime:0.75947284698486 / seconds
Query Executed:select id FROM `ia` where city='Millersburg' && SIC_code='5651'DB:business_master_new
loadtime:0.75991892814636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millerton' limit 1
loadtime:0.7599458694458 / seconds
Query Executed:select id FROM `ia` where city='Millerton' && SIC_code='5651'DB:business_master_new
loadtime:0.76025390625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milo' limit 1
loadtime:0.76029086112976 / seconds
Query Executed:select id FROM `ia` where city='Milo' && SIC_code='5651'DB:business_master_new
loadtime:0.76069188117981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.76073598861694 / seconds
Query Executed:select id FROM `ia` where city='Milton' && SIC_code='5651'DB:business_master_new
loadtime:0.76112794876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minburn' limit 1
loadtime:0.76115489006042 / seconds
Query Executed:select id FROM `ia` where city='Minburn' && SIC_code='5651'DB:business_master_new
loadtime:0.76157283782959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minden' limit 1
loadtime:0.76162195205688 / seconds
Query Executed:select id FROM `ia` where city='Minden' && SIC_code='5651'DB:business_master_new
loadtime:0.76200699806213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineola' limit 1
loadtime:0.76203393936157 / seconds
Query Executed:select id FROM `ia` where city='Mineola' && SIC_code='5651'DB:business_master_new
loadtime:0.76241087913513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mingo' limit 1
loadtime:0.76245880126953 / seconds
Query Executed:select id FROM `ia` where city='Mingo' && SIC_code='5651'DB:business_master_new
loadtime:0.76285195350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Missouri Valley' limit 1
loadtime:0.76287889480591 / seconds
Query Executed:select id FROM `ia` where city='Missouri Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.76400089263916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchell' limit 1
loadtime:0.7640597820282 / seconds
Query Executed:select id FROM `ia` where city='Mitchell' && SIC_code='5651'DB:business_master_new
loadtime:0.76431798934937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mitchellville' limit 1
loadtime:0.76434683799744 / seconds
Query Executed:select id FROM `ia` where city='Mitchellville' && SIC_code='5651'DB:business_master_new
loadtime:0.76474690437317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modale' limit 1
loadtime:0.76479387283325 / seconds
Query Executed:select id FROM `ia` where city='Modale' && SIC_code='5651'DB:business_master_new
loadtime:0.76527094841003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mondamin' limit 1
loadtime:0.76530885696411 / seconds
Query Executed:select id FROM `ia` where city='Mondamin' && SIC_code='5651'DB:business_master_new
loadtime:0.76571989059448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth' limit 1
loadtime:0.76575589179993 / seconds
Query Executed:select id FROM `ia` where city='Monmouth' && SIC_code='5651'DB:business_master_new
loadtime:0.7719259262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monona' limit 1
loadtime:0.7719738483429 / seconds
Query Executed:select id FROM `ia` where city='Monona' && SIC_code='5651'DB:business_master_new
loadtime:0.77243685722351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.77247881889343 / seconds
Query Executed:select id FROM `ia` where city='Monroe' && SIC_code='5651'DB:business_master_new
loadtime:0.77292990684509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:0.77297782897949 / seconds
Query Executed:select id FROM `ia` where city='Montezuma' && SIC_code='5651'DB:business_master_new
loadtime:0.7734649181366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.77351498603821 / seconds
Query Executed:select id FROM `ia` where city='Monticello' && SIC_code='5651'DB:business_master_new
loadtime:0.77464485168457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montour' limit 1
loadtime:0.7746889591217 / seconds
Query Executed:select id FROM `ia` where city='Montour' && SIC_code='5651'DB:business_master_new
loadtime:0.7751247882843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montpelier' limit 1
loadtime:0.77516579627991 / seconds
Query Executed:select id FROM `ia` where city='Montpelier' && SIC_code='5651'DB:business_master_new
loadtime:0.77549982070923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:0.77553486824036 / seconds
Query Executed:select id FROM `ia` where city='Montrose' && SIC_code='5651'DB:business_master_new
loadtime:0.77593088150024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorhead' limit 1
loadtime:0.77596688270569 / seconds
Query Executed:select id FROM `ia` where city='Moorhead' && SIC_code='5651'DB:business_master_new
loadtime:0.77641177177429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorland' limit 1
loadtime:0.77644681930542 / seconds
Query Executed:select id FROM `ia` where city='Moorland' && SIC_code='5651'DB:business_master_new
loadtime:0.77682399749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravia' limit 1
loadtime:0.776850938797 / seconds
Query Executed:select id FROM `ia` where city='Moravia' && SIC_code='5651'DB:business_master_new
loadtime:0.77723598480225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morley' limit 1
loadtime:0.77727389335632 / seconds
Query Executed:select id FROM `ia` where city='Morley' && SIC_code='5651'DB:business_master_new
loadtime:0.77764391899109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morning Sun' limit 1
loadtime:0.77768087387085 / seconds
Query Executed:select id FROM `ia` where city='Morning Sun' && SIC_code='5651'DB:business_master_new
loadtime:0.77807879447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrison' limit 1
loadtime:0.77811884880066 / seconds
Query Executed:select id FROM `ia` where city='Morrison' && SIC_code='5651'DB:business_master_new
loadtime:0.77844977378845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moscow' limit 1
loadtime:0.7784857749939 / seconds
Query Executed:select id FROM `ia` where city='Moscow' && SIC_code='5651'DB:business_master_new
loadtime:0.77892899513245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moulton' limit 1
loadtime:0.7789568901062 / seconds
Query Executed:select id FROM `ia` where city='Moulton' && SIC_code='5651'DB:business_master_new
loadtime:0.77938199043274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Auburn' limit 1
loadtime:0.77941799163818 / seconds
Query Executed:select id FROM `ia` where city='Mount Auburn' && SIC_code='5651'DB:business_master_new
loadtime:0.77986288070679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ayr' limit 1
loadtime:0.77990293502808 / seconds
Query Executed:select id FROM `ia` where city='Mount Ayr' && SIC_code='5651'DB:business_master_new
loadtime:0.78038477897644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.7804229259491 / seconds
Query Executed:select id FROM `ia` where city='Mount Pleasant' && SIC_code='5651'DB:business_master_new
loadtime:0.78155493736267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Sterling' limit 1
loadtime:0.78160381317139 / seconds
Query Executed:select id FROM `ia` where city='Mount Sterling' && SIC_code='5651'DB:business_master_new
loadtime:0.78198885917664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Union' limit 1
loadtime:0.78202295303345 / seconds
Query Executed:select id FROM `ia` where city='Mount Union' && SIC_code='5651'DB:business_master_new
loadtime:0.78252696990967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:0.78256297111511 / seconds
Query Executed:select id FROM `ia` where city='Mount Vernon' && SIC_code='5651'DB:business_master_new
loadtime:0.78300595283508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moville' limit 1
loadtime:0.78304481506348 / seconds
Query Executed:select id FROM `ia` where city='Moville' && SIC_code='5651'DB:business_master_new
loadtime:0.78347897529602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Auburn' limit 1
loadtime:0.78351497650146 / seconds
Query Executed:select id FROM `ia` where city='Mt Auburn' && SIC_code='5651'DB:business_master_new
loadtime:0.7837929725647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ayr' limit 1
loadtime:0.78383183479309 / seconds
Query Executed:select id FROM `ia` where city='Mt Ayr' && SIC_code='5651'DB:business_master_new
loadtime:0.78412580490112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.78415298461914 / seconds
Query Executed:select id FROM `ia` where city='Mt Pleasant' && SIC_code='5651'DB:business_master_new
loadtime:0.78462290763855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Sterling' limit 1
loadtime:0.78467082977295 / seconds
Query Executed:select id FROM `ia` where city='Mt Sterling' && SIC_code='5651'DB:business_master_new
loadtime:0.78497886657715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Union' limit 1
loadtime:0.78500699996948 / seconds
Query Executed:select id FROM `ia` where city='Mt Union' && SIC_code='5651'DB:business_master_new
loadtime:0.78540086746216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:0.78544878959656 / seconds
Query Executed:select id FROM `ia` where city='Mt Vernon' && SIC_code='5651'DB:business_master_new
loadtime:0.78578591346741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.78582096099854 / seconds
Query Executed:select id FROM `ia` where city='Murray' && SIC_code='5651'DB:business_master_new
loadtime:0.78619480133057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscatine' limit 1
loadtime:0.78622078895569 / seconds
Query Executed:select id FROM `ia` where city='Muscatine' && SIC_code='5651'DB:business_master_new
loadtime:0.78734993934631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.78739786148071 / seconds
Query Executed:select id FROM `ia` where city='Mystic' && SIC_code='5651'DB:business_master_new
loadtime:0.7878999710083 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Buena Vista' limit 1
loadtime:0.78792691230774 / seconds
Query Executed:select id FROM `ia` where city='N Buena Vista' && SIC_code='5651'DB:business_master_new
loadtime:0.78822183609009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.78825998306274 / seconds
Query Executed:select id FROM `ia` where city='Nashua' && SIC_code='5651'DB:business_master_new
loadtime:0.78871393203735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nemaha' limit 1
loadtime:0.78875780105591 / seconds
Query Executed:select id FROM `ia` where city='Nemaha' && SIC_code='5651'DB:business_master_new
loadtime:0.79571199417114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.79574799537659 / seconds
Query Executed:select id FROM `ia` where city='Neola' && SIC_code='5651'DB:business_master_new
loadtime:0.79618883132935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nevada' limit 1
loadtime:0.79622888565063 / seconds
Query Executed:select id FROM `ia` where city='Nevada' && SIC_code='5651'DB:business_master_new
loadtime:0.79736185073853 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Albin' limit 1
loadtime:0.79741096496582 / seconds
Query Executed:select id FROM `ia` where city='New Albin' && SIC_code='5651'DB:business_master_new
loadtime:0.79783582687378 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:0.7978630065918 / seconds
Query Executed:select id FROM `ia` where city='New Hampton' && SIC_code='5651'DB:business_master_new
loadtime:0.79897379875183 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.79900789260864 / seconds
Query Executed:select id FROM `ia` where city='New Hartford' && SIC_code='5651'DB:business_master_new
loadtime:0.79947280883789 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Liberty' limit 1
loadtime:0.79950881004333 / seconds
Query Executed:select id FROM `ia` where city='New Liberty' && SIC_code='5651'DB:business_master_new
loadtime:0.79989099502563 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.79993081092834 / seconds
Query Executed:select id FROM `ia` where city='New London' && SIC_code='5651'DB:business_master_new
loadtime:0.80037379264832 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:0.80042195320129 / seconds
Query Executed:select id FROM `ia` where city='New Market' && SIC_code='5651'DB:business_master_new
loadtime:0.80083799362183 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:0.80087280273438 / seconds
Query Executed:select id FROM `ia` where city='New Providence' && SIC_code='5651'DB:business_master_new
loadtime:0.80125689506531 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Sharon' limit 1
loadtime:0.80128788948059 / seconds
Query Executed:select id FROM `ia` where city='New Sharon' && SIC_code='5651'DB:business_master_new
loadtime:0.80172491073608 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vienna' limit 1
loadtime:0.8017737865448 / seconds
Query Executed:select id FROM `ia` where city='New Vienna' && SIC_code='5651'DB:business_master_new
loadtime:0.80216193199158 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Virginia' limit 1
loadtime:0.80218982696533 / seconds
Query Executed:select id FROM `ia` where city='New Virginia' && SIC_code='5651'DB:business_master_new
loadtime:0.80258989334106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:0.80263686180115 / seconds
Query Executed:select id FROM `ia` where city='Newell' && SIC_code='5651'DB:business_master_new
loadtime:0.80306696891785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newhall' limit 1
loadtime:0.80309391021729 / seconds
Query Executed:select id FROM `ia` where city='Newhall' && SIC_code='5651'DB:business_master_new
loadtime:0.80350184440613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.80353879928589 / seconds
Query Executed:select id FROM `ia` where city='Newton' && SIC_code='5651'DB:business_master_new
loadtime:0.80466294288635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nichols' limit 1
loadtime:0.80471897125244 / seconds
Query Executed:select id FROM `ia` where city='Nichols' && SIC_code='5651'DB:business_master_new
loadtime:0.80511498451233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nodaway' limit 1
loadtime:0.80514287948608 / seconds
Query Executed:select id FROM `ia` where city='Nodaway' && SIC_code='5651'DB:business_master_new
loadtime:0.80561590194702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nora Springs' limit 1
loadtime:0.80566477775574 / seconds
Query Executed:select id FROM `ia` where city='Nora Springs' && SIC_code='5651'DB:business_master_new
loadtime:0.80609679222107 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Buena Vista' limit 1
loadtime:0.8061249256134 / seconds
Query Executed:select id FROM `ia` where city='North Buena Vista' && SIC_code='5651'DB:business_master_new
loadtime:0.80644297599792 / seconds
Query loaded from cache:select * from geodata_geocity where city='North English' limit 1
loadtime:0.80649185180664 / seconds
Query Executed:select id FROM `ia` where city='North English' && SIC_code='5651'DB:business_master_new
loadtime:0.80690979957581 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Liberty' limit 1
loadtime:0.80693697929382 / seconds
Query Executed:select id FROM `ia` where city='North Liberty' && SIC_code='5651'DB:business_master_new
loadtime:0.80806994438171 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Washington' limit 1
loadtime:0.80811786651611 / seconds
Query Executed:select id FROM `ia` where city='North Washington' && SIC_code='5651'DB:business_master_new
loadtime:0.80844688415527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northboro' limit 1
loadtime:0.80849099159241 / seconds
Query Executed:select id FROM `ia` where city='Northboro' && SIC_code='5651'DB:business_master_new
loadtime:0.80890679359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:0.80893492698669 / seconds
Query Executed:select id FROM `ia` where city='Northwood' && SIC_code='5651'DB:business_master_new
loadtime:0.80942988395691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.80947780609131 / seconds
Query Executed:select id FROM `ia` where city='Norwalk' && SIC_code='5651'DB:business_master_new
loadtime:0.81059885025024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norway' limit 1
loadtime:0.81063485145569 / seconds
Query Executed:select id FROM `ia` where city='Norway' && SIC_code='5651'DB:business_master_new
loadtime:0.81101894378662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Numa' limit 1
loadtime:0.81106996536255 / seconds
Query Executed:select id FROM `ia` where city='Numa' && SIC_code='5651'DB:business_master_new
loadtime:0.81138300895691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.81142997741699 / seconds
Query Executed:select id FROM `ia` where city='Oakdale' && SIC_code='5651'DB:business_master_new
loadtime:0.81176996231079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:0.81180381774902 / seconds
Query Executed:select id FROM `ia` where city='Oakland' && SIC_code='5651'DB:business_master_new
loadtime:0.81221985816956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.81224584579468 / seconds
Query Executed:select id FROM `ia` where city='Oakville' && SIC_code='5651'DB:business_master_new
loadtime:0.81262898445129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocheyedan' limit 1
loadtime:0.81267690658569 / seconds
Query Executed:select id FROM `ia` where city='Ocheyedan' && SIC_code='5651'DB:business_master_new
loadtime:0.81306195259094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odebolt' limit 1
loadtime:0.8130898475647 / seconds
Query Executed:select id FROM `ia` where city='Odebolt' && SIC_code='5651'DB:business_master_new
loadtime:0.81351900100708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oelwein' limit 1
loadtime:0.81356692314148 / seconds
Query Executed:select id FROM `ia` where city='Oelwein' && SIC_code='5651'DB:business_master_new
loadtime:0.81468081474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:0.81471681594849 / seconds
Query Executed:select id FROM `ia` where city='Ogden' && SIC_code='5651'DB:business_master_new
loadtime:0.81515192985535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Okoboji' limit 1
loadtime:0.8151798248291 / seconds
Query Executed:select id FROM `ia` where city='Okoboji' && SIC_code='5651'DB:business_master_new
loadtime:0.81557488441467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olds' limit 1
loadtime:0.81562185287476 / seconds
Query Executed:select id FROM `ia` where city='Olds' && SIC_code='5651'DB:business_master_new
loadtime:0.81602692604065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:0.81606984138489 / seconds
Query Executed:select id FROM `ia` where city='Olin' && SIC_code='5651'DB:business_master_new
loadtime:0.8164758682251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ollie' limit 1
loadtime:0.8165237903595 / seconds
Query Executed:select id FROM `ia` where city='Ollie' && SIC_code='5651'DB:business_master_new
loadtime:0.81692099571228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onawa' limit 1
loadtime:0.81694889068604 / seconds
Query Executed:select id FROM `ia` where city='Onawa' && SIC_code='5651'DB:business_master_new
loadtime:0.81806898117065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Onslow' limit 1
loadtime:0.81811690330505 / seconds
Query Executed:select id FROM `ia` where city='Onslow' && SIC_code='5651'DB:business_master_new
loadtime:0.81852197647095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oran' limit 1
loadtime:0.81856894493103 / seconds
Query Executed:select id FROM `ia` where city='Oran' && SIC_code='5651'DB:business_master_new
loadtime:0.81892585754395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange City' limit 1
loadtime:0.81895399093628 / seconds
Query Executed:select id FROM `ia` where city='Orange City' && SIC_code='5651'DB:business_master_new
loadtime:0.82008290290833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orchard' limit 1
loadtime:0.82013988494873 / seconds
Query Executed:select id FROM `ia` where city='Orchard' && SIC_code='5651'DB:business_master_new
loadtime:0.82057094573975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orient' limit 1
loadtime:0.82060694694519 / seconds
Query Executed:select id FROM `ia` where city='Orient' && SIC_code='5651'DB:business_master_new
loadtime:0.82100582122803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:0.82104682922363 / seconds
Query Executed:select id FROM `ia` where city='Osage' && SIC_code='5651'DB:business_master_new
loadtime:0.82215094566345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osceola' limit 1
loadtime:0.82219886779785 / seconds
Query Executed:select id FROM `ia` where city='Osceola' && SIC_code='5651'DB:business_master_new
loadtime:0.82330179214478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oskaloosa' limit 1
loadtime:0.82334494590759 / seconds
Query Executed:select id FROM `ia` where city='Oskaloosa' && SIC_code='5651'DB:business_master_new
loadtime:0.82445192337036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ossian' limit 1
loadtime:0.82450795173645 / seconds
Query Executed:select id FROM `ia` where city='Ossian' && SIC_code='5651'DB:business_master_new
loadtime:0.82492780685425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otho' limit 1
loadtime:0.82496380805969 / seconds
Query Executed:select id FROM `ia` where city='Otho' && SIC_code='5651'DB:business_master_new
loadtime:0.82538199424744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otley' limit 1
loadtime:0.82543087005615 / seconds
Query Executed:select id FROM `ia` where city='Otley' && SIC_code='5651'DB:business_master_new
loadtime:0.82583689689636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oto' limit 1
loadtime:0.82588195800781 / seconds
Query Executed:select id FROM `ia` where city='Oto' && SIC_code='5651'DB:business_master_new
loadtime:0.82636094093323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottosen' limit 1
loadtime:0.82639694213867 / seconds
Query Executed:select id FROM `ia` where city='Ottosen' && SIC_code='5651'DB:business_master_new
loadtime:0.82684683799744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ottumwa' limit 1
loadtime:0.82689499855042 / seconds
Query Executed:select id FROM `ia` where city='Ottumwa' && SIC_code='5651'DB:business_master_new
loadtime:0.82800793647766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.82804298400879 / seconds
Query Executed:select id FROM `ia` where city='Oxford' && SIC_code='5651'DB:business_master_new
loadtime:0.82845997810364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford Junction' limit 1
loadtime:0.82850790023804 / seconds
Query Executed:select id FROM `ia` where city='Oxford Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.82889986038208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oyens' limit 1
loadtime:0.82892680168152 / seconds
Query Executed:select id FROM `ia` where city='Oyens' && SIC_code='5651'DB:business_master_new
loadtime:0.82926297187805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pacific Junction' limit 1
loadtime:0.82929992675781 / seconds
Query Executed:select id FROM `ia` where city='Pacific Junction' && SIC_code='5651'DB:business_master_new
loadtime:0.82970786094666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Packwood' limit 1
loadtime:0.82974481582642 / seconds
Query Executed:select id FROM `ia` where city='Packwood' && SIC_code='5651'DB:business_master_new
loadtime:0.83014988899231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmer' limit 1
loadtime:0.83019089698792 / seconds
Query Executed:select id FROM `ia` where city='Palmer' && SIC_code='5651'DB:business_master_new
loadtime:0.83058500289917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo' limit 1
loadtime:0.83062100410461 / seconds
Query Executed:select id FROM `ia` where city='Palo' && SIC_code='5651'DB:business_master_new
loadtime:0.83101582527161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panama' limit 1
loadtime:0.83104300498962 / seconds
Query Executed:select id FROM `ia` where city='Panama' && SIC_code='5651'DB:business_master_new
loadtime:0.83147096633911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panora' limit 1
loadtime:0.83151888847351 / seconds
Query Executed:select id FROM `ia` where city='Panora' && SIC_code='5651'DB:business_master_new
loadtime:0.83195185661316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkersburg' limit 1
loadtime:0.83197999000549 / seconds
Query Executed:select id FROM `ia` where city='Parkersburg' && SIC_code='5651'DB:business_master_new
loadtime:0.8324089050293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parnell' limit 1
loadtime:0.83245587348938 / seconds
Query Executed:select id FROM `ia` where city='Parnell' && SIC_code='5651'DB:business_master_new
loadtime:0.83285784721375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paton' limit 1
loadtime:0.8328869342804 / seconds
Query Executed:select id FROM `ia` where city='Paton' && SIC_code='5651'DB:business_master_new
loadtime:0.83325886726379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:0.83329677581787 / seconds
Query Executed:select id FROM `ia` where city='Patterson' && SIC_code='5651'DB:business_master_new
loadtime:0.83360481262207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paullina' limit 1
loadtime:0.83364081382751 / seconds
Query Executed:select id FROM `ia` where city='Paullina' && SIC_code='5651'DB:business_master_new
loadtime:0.83406400680542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pella' limit 1
loadtime:0.83410382270813 / seconds
Query Executed:select id FROM `ia` where city='Pella' && SIC_code='5651'DB:business_master_new
loadtime:0.83547186851501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peosta' limit 1
loadtime:0.83552980422974 / seconds
Query Executed:select id FROM `ia` where city='Peosta' && SIC_code='5651'DB:business_master_new
loadtime:0.83597588539124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Percival' limit 1
loadtime:0.8360059261322 / seconds
Query Executed:select id FROM `ia` where city='Percival' && SIC_code='5651'DB:business_master_new
loadtime:0.83639979362488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perry' limit 1
loadtime:0.83643889427185 / seconds
Query Executed:select id FROM `ia` where city='Perry' && SIC_code='5651'DB:business_master_new
loadtime:0.83755683898926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Persia' limit 1
loadtime:0.8375928401947 / seconds
Query Executed:select id FROM `ia` where city='Persia' && SIC_code='5651'DB:business_master_new
loadtime:0.83798098564148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peru' limit 1
loadtime:0.83802080154419 / seconds
Query Executed:select id FROM `ia` where city='Peru' && SIC_code='5651'DB:business_master_new
loadtime:0.83848595619202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson' limit 1
loadtime:0.83853387832642 / seconds
Query Executed:select id FROM `ia` where city='Peterson' && SIC_code='5651'DB:business_master_new
loadtime:0.8389368057251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pierson' limit 1
loadtime:0.83896493911743 / seconds
Query Executed:select id FROM `ia` where city='Pierson' && SIC_code='5651'DB:business_master_new
loadtime:0.83940100669861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Grove' limit 1
loadtime:0.83943700790405 / seconds
Query Executed:select id FROM `ia` where city='Pilot Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.83976793289185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mound' limit 1
loadtime:0.83979296684265 / seconds
Query Executed:select id FROM `ia` where city='Pilot Mound' && SIC_code='5651'DB:business_master_new
loadtime:0.84019994735718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah' limit 1
loadtime:0.84023284912109 / seconds
Query Executed:select id FROM `ia` where city='Pisgah' && SIC_code='5651'DB:business_master_new
loadtime:0.8406298160553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.84067392349243 / seconds
Query Executed:select id FROM `ia` where city='Plainfield' && SIC_code='5651'DB:business_master_new
loadtime:0.8411009311676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plano' limit 1
loadtime:0.84113883972168 / seconds
Query Executed:select id FROM `ia` where city='Plano' && SIC_code='5651'DB:business_master_new
loadtime:0.84152579307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:0.84156489372253 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Hill' && SIC_code='5651'DB:business_master_new
loadtime:0.84201693534851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.84204292297363 / seconds
Query Executed:select id FROM `ia` where city='Pleasant Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.8425018787384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasanton' limit 1
loadtime:0.84255790710449 / seconds
Query Executed:select id FROM `ia` where city='Pleasanton' && SIC_code='5651'DB:business_master_new
loadtime:0.84283781051636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:0.84286594390869 / seconds
Query Executed:select id FROM `ia` where city='Pleasantville' && SIC_code='5651'DB:business_master_new
loadtime:0.84329581260681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plover' limit 1
loadtime:0.84333181381226 / seconds
Query Executed:select id FROM `ia` where city='Plover' && SIC_code='5651'DB:business_master_new
loadtime:0.84369683265686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.84372878074646 / seconds
Query Executed:select id FROM `ia` where city='Plymouth' && SIC_code='5651'DB:business_master_new
loadtime:0.84413480758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pocahontas' limit 1
loadtime:0.84417080879211 / seconds
Query Executed:select id FROM `ia` where city='Pocahontas' && SIC_code='5651'DB:business_master_new
loadtime:0.84463381767273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polk City' limit 1
loadtime:0.84468293190002 / seconds
Query Executed:select id FROM `ia` where city='Polk City' && SIC_code='5651'DB:business_master_new
loadtime:0.84508681297302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomeroy' limit 1
loadtime:0.84512686729431 / seconds
Query Executed:select id FROM `ia` where city='Pomeroy' && SIC_code='5651'DB:business_master_new
loadtime:0.8455548286438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Popejoy' limit 1
loadtime:0.84558987617493 / seconds
Query Executed:select id FROM `ia` where city='Popejoy' && SIC_code='5651'DB:business_master_new
loadtime:0.84590983390808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.84594583511353 / seconds
Query Executed:select id FROM `ia` where city='Portsmouth' && SIC_code='5651'DB:business_master_new
loadtime:0.84635186195374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Postville' limit 1
loadtime:0.8463888168335 / seconds
Query Executed:select id FROM `ia` where city='Postville' && SIC_code='5651'DB:business_master_new
loadtime:0.84683680534363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairie City' limit 1
loadtime:0.84688377380371 / seconds
Query Executed:select id FROM `ia` where city='Prairie City' && SIC_code='5651'DB:business_master_new
loadtime:0.84729695320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prairieburg' limit 1
loadtime:0.84732389450073 / seconds
Query Executed:select id FROM `ia` where city='Prairieburg' && SIC_code='5651'DB:business_master_new
loadtime:0.84782385826111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:0.84787178039551 / seconds
Query Executed:select id FROM `ia` where city='Prescott' && SIC_code='5651'DB:business_master_new
loadtime:0.84828090667725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.84832382202148 / seconds
Query Executed:select id FROM `ia` where city='Preston' && SIC_code='5651'DB:business_master_new
loadtime:0.84884977340698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Primghar' limit 1
loadtime:0.84888577461243 / seconds
Query Executed:select id FROM `ia` where city='Primghar' && SIC_code='5651'DB:business_master_new
loadtime:0.84939789772034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:0.8494348526001 / seconds
Query Executed:select id FROM `ia` where city='Princeton' && SIC_code='5651'DB:business_master_new
loadtime:0.84989285469055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prole' limit 1
loadtime:0.849928855896 / seconds
Query Executed:select id FROM `ia` where city='Prole' && SIC_code='5651'DB:business_master_new
loadtime:0.85040688514709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Promise City' limit 1
loadtime:0.85045480728149 / seconds
Query Executed:select id FROM `ia` where city='Promise City' && SIC_code='5651'DB:business_master_new
loadtime:0.85105991363525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Protivin' limit 1
loadtime:0.85109996795654 / seconds
Query Executed:select id FROM `ia` where city='Protivin' && SIC_code='5651'DB:business_master_new
loadtime:0.85191488265991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pulaski' limit 1
loadtime:0.85196280479431 / seconds
Query Executed:select id FROM `ia` where city='Pulaski' && SIC_code='5651'DB:business_master_new
loadtime:0.85274696350098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quasqueton' limit 1
loadtime:0.85278296470642 / seconds
Query Executed:select id FROM `ia` where city='Quasqueton' && SIC_code='5651'DB:business_master_new
loadtime:0.85819888114929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quimby' limit 1
loadtime:0.8582489490509 / seconds
Query Executed:select id FROM `ia` where city='Quimby' && SIC_code='5651'DB:business_master_new
loadtime:0.85866189002991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Radcliffe' limit 1
loadtime:0.85869693756104 / seconds
Query Executed:select id FROM `ia` where city='Radcliffe' && SIC_code='5651'DB:business_master_new
loadtime:0.85910081863403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rake' limit 1
loadtime:0.85915184020996 / seconds
Query Executed:select id FROM `ia` where city='Rake' && SIC_code='5651'DB:business_master_new
loadtime:0.85957598686218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralston' limit 1
loadtime:0.85962295532227 / seconds
Query Executed:select id FROM `ia` where city='Ralston' && SIC_code='5651'DB:business_master_new
loadtime:0.85995292663574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randalia' limit 1
loadtime:0.85998392105103 / seconds
Query Executed:select id FROM `ia` where city='Randalia' && SIC_code='5651'DB:business_master_new
loadtime:0.8604199886322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randall' limit 1
loadtime:0.8604588508606 / seconds
Query Executed:select id FROM `ia` where city='Randall' && SIC_code='5651'DB:business_master_new
loadtime:0.86081600189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.86084198951721 / seconds
Query Executed:select id FROM `ia` where city='Randolph' && SIC_code='5651'DB:business_master_new
loadtime:0.86125588417053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.8612949848175 / seconds
Query Executed:select id FROM `ia` where city='Raymond' && SIC_code='5651'DB:business_master_new
loadtime:0.86171984672546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readlyn' limit 1
loadtime:0.86175489425659 / seconds
Query Executed:select id FROM `ia` where city='Readlyn' && SIC_code='5651'DB:business_master_new
loadtime:0.86214995384216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reasnor' limit 1
loadtime:0.86217498779297 / seconds
Query Executed:select id FROM `ia` where city='Reasnor' && SIC_code='5651'DB:business_master_new
loadtime:0.86259078979492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:0.86263799667358 / seconds
Query Executed:select id FROM `ia` where city='Red Oak' && SIC_code='5651'DB:business_master_new
loadtime:0.86377000808716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.86381387710571 / seconds
Query Executed:select id FROM `ia` where city='Redding' && SIC_code='5651'DB:business_master_new
loadtime:0.86419296264648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redfield' limit 1
loadtime:0.86423397064209 / seconds
Query Executed:select id FROM `ia` where city='Redfield' && SIC_code='5651'DB:business_master_new
loadtime:0.86463093757629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reinbeck' limit 1
loadtime:0.86467599868774 / seconds
Query Executed:select id FROM `ia` where city='Reinbeck' && SIC_code='5651'DB:business_master_new
loadtime:0.86509585380554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rembrandt' limit 1
loadtime:0.86512398719788 / seconds
Query Executed:select id FROM `ia` where city='Rembrandt' && SIC_code='5651'DB:business_master_new
loadtime:0.86550879478455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remsen' limit 1
loadtime:0.86555695533752 / seconds
Query Executed:select id FROM `ia` where city='Remsen' && SIC_code='5651'DB:business_master_new
loadtime:0.86598992347717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Renwick' limit 1
loadtime:0.86601686477661 / seconds
Query Executed:select id FROM `ia` where city='Renwick' && SIC_code='5651'DB:business_master_new
loadtime:0.86641597747803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodes' limit 1
loadtime:0.86646294593811 / seconds
Query Executed:select id FROM `ia` where city='Rhodes' && SIC_code='5651'DB:business_master_new
loadtime:0.86691093444824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riceville' limit 1
loadtime:0.866938829422 / seconds
Query Executed:select id FROM `ia` where city='Riceville' && SIC_code='5651'DB:business_master_new
loadtime:0.86739587783813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:0.86744379997253 / seconds
Query Executed:select id FROM `ia` where city='Richland' && SIC_code='5651'DB:business_master_new
loadtime:0.86783790588379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ricketts' limit 1
loadtime:0.86786484718323 / seconds
Query Executed:select id FROM `ia` where city='Ricketts' && SIC_code='5651'DB:business_master_new
loadtime:0.86819100379944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:0.86822700500488 / seconds
Query Executed:select id FROM `ia` where city='Ridgeway' && SIC_code='5651'DB:business_master_new
loadtime:0.86864495277405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringsted' limit 1
loadtime:0.8686888217926 / seconds
Query Executed:select id FROM `ia` where city='Ringsted' && SIC_code='5651'DB:business_master_new
loadtime:0.86907386779785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rippey' limit 1
loadtime:0.86910080909729 / seconds
Query Executed:select id FROM `ia` where city='Rippey' && SIC_code='5651'DB:business_master_new
loadtime:0.86948180198669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:0.86952996253967 / seconds
Query Executed:select id FROM `ia` where city='Riverdale' && SIC_code='5651'DB:business_master_new
loadtime:0.86985182762146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.86987996101379 / seconds
Query Executed:select id FROM `ia` where city='Riverside' && SIC_code='5651'DB:business_master_new
loadtime:0.87029600143433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.87033700942993 / seconds
Query Executed:select id FROM `ia` where city='Riverton' && SIC_code='5651'DB:business_master_new
loadtime:0.87071895599365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robins' limit 1
loadtime:0.87076377868652 / seconds
Query Executed:select id FROM `ia` where city='Robins' && SIC_code='5651'DB:business_master_new
loadtime:0.87114381790161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Falls' limit 1
loadtime:0.87117195129395 / seconds
Query Executed:select id FROM `ia` where city='Rock Falls' && SIC_code='5651'DB:business_master_new
loadtime:0.87154698371887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Rapids' limit 1
loadtime:0.87159395217896 / seconds
Query Executed:select id FROM `ia` where city='Rock Rapids' && SIC_code='5651'DB:business_master_new
loadtime:0.87272191047668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Valley' limit 1
loadtime:0.87275791168213 / seconds
Query Executed:select id FROM `ia` where city='Rock Valley' && SIC_code='5651'DB:business_master_new
loadtime:0.87387490272522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:0.8739218711853 / seconds
Query Executed:select id FROM `ia` where city='Rockford' && SIC_code='5651'DB:business_master_new
loadtime:0.8743588924408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:0.87440800666809 / seconds
Query Executed:select id FROM `ia` where city='Rockwell' && SIC_code='5651'DB:business_master_new
loadtime:0.8748459815979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell City' limit 1
loadtime:0.87488985061646 / seconds
Query Executed:select id FROM `ia` where city='Rockwell City' && SIC_code='5651'DB:business_master_new
loadtime:0.87536692619324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodney' limit 1
loadtime:0.87540197372437 / seconds
Query Executed:select id FROM `ia` where city='Rodney' && SIC_code='5651'DB:business_master_new
loadtime:0.87575387954712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roland' limit 1
loadtime:0.87580180168152 / seconds
Query Executed:select id FROM `ia` where city='Roland' && SIC_code='5651'DB:business_master_new
loadtime:0.87618279457092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolfe' limit 1
loadtime:0.87621092796326 / seconds
Query Executed:select id FROM `ia` where city='Rolfe' && SIC_code='5651'DB:business_master_new
loadtime:0.87661600112915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rome' limit 1
loadtime:0.87666296958923 / seconds
Query Executed:select id FROM `ia` where city='Rome' && SIC_code='5651'DB:business_master_new
loadtime:0.87693881988525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:0.87696599960327 / seconds
Query Executed:select id FROM `ia` where city='Rose Hill' && SIC_code='5651'DB:business_master_new
loadtime:0.87743878364563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowan' limit 1
loadtime:0.87747478485107 / seconds
Query Executed:select id FROM `ia` where city='Rowan' && SIC_code='5651'DB:business_master_new
loadtime:0.87786889076233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowley' limit 1
loadtime:0.87789678573608 / seconds
Query Executed:select id FROM `ia` where city='Rowley' && SIC_code='5651'DB:business_master_new
loadtime:0.8782639503479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Royal' limit 1
loadtime:0.87830090522766 / seconds
Query Executed:select id FROM `ia` where city='Royal' && SIC_code='5651'DB:business_master_new
loadtime:0.8786928653717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rudd' limit 1
loadtime:0.87872886657715 / seconds
Query Executed:select id FROM `ia` where city='Rudd' && SIC_code='5651'DB:business_master_new
loadtime:0.87912678718567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnells' limit 1
loadtime:0.879154920578 / seconds
Query Executed:select id FROM `ia` where city='Runnells' && SIC_code='5651'DB:business_master_new
loadtime:0.87958192825317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russell' limit 1
loadtime:0.87963199615479 / seconds
Query Executed:select id FROM `ia` where city='Russell' && SIC_code='5651'DB:business_master_new
loadtime:0.88000178337097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruthven' limit 1
loadtime:0.88003587722778 / seconds
Query Executed:select id FROM `ia` where city='Ruthven' && SIC_code='5651'DB:business_master_new
loadtime:0.88047385215759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutland' limit 1
loadtime:0.88050985336304 / seconds
Query Executed:select id FROM `ia` where city='Rutland' && SIC_code='5651'DB:business_master_new
loadtime:0.88088297843933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryan' limit 1
loadtime:0.88092398643494 / seconds
Query Executed:select id FROM `ia` where city='Ryan' && SIC_code='5651'DB:business_master_new
loadtime:0.8813648223877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sabula' limit 1
loadtime:0.88144278526306 / seconds
Query Executed:select id FROM `ia` where city='Sabula' && SIC_code='5651'DB:business_master_new
loadtime:0.88254380226135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sac City' limit 1
loadtime:0.8826789855957 / seconds
Query Executed:select id FROM `ia` where city='Sac City' && SIC_code='5651'DB:business_master_new
loadtime:0.88550877571106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Ansgar' limit 1
loadtime:0.88565993309021 / seconds
Query Executed:select id FROM `ia` where city='Saint Ansgar' && SIC_code='5651'DB:business_master_new
loadtime:0.88687300682068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Anthony' limit 1
loadtime:0.88697099685669 / seconds
Query Executed:select id FROM `ia` where city='Saint Anthony' && SIC_code='5651'DB:business_master_new
loadtime:0.88769793510437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Charles' limit 1
loadtime:0.88774490356445 / seconds
Query Executed:select id FROM `ia` where city='Saint Charles' && SIC_code='5651'DB:business_master_new
loadtime:0.88817191123962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Donatus' limit 1
loadtime:0.8882098197937 / seconds
Query Executed:select id FROM `ia` where city='Saint Donatus' && SIC_code='5651'DB:business_master_new
loadtime:0.88882184028625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Marys' limit 1
loadtime:0.88885879516602 / seconds
Query Executed:select id FROM `ia` where city='Saint Marys' && SIC_code='5651'DB:business_master_new
loadtime:0.88924884796143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Olaf' limit 1
loadtime:0.88928890228271 / seconds
Query Executed:select id FROM `ia` where city='Saint Olaf' && SIC_code='5651'DB:business_master_new
loadtime:0.89887285232544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Paul' limit 1
loadtime:0.89892077445984 / seconds
Query Executed:select id FROM `ia` where city='Saint Paul' && SIC_code='5651'DB:business_master_new
loadtime:0.89935183525085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.89938879013062 / seconds
Query Executed:select id FROM `ia` where city='Salem' && SIC_code='5651'DB:business_master_new
loadtime:0.899817943573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salix' limit 1
loadtime:0.89986681938171 / seconds
Query Executed:select id FROM `ia` where city='Salix' && SIC_code='5651'DB:business_master_new
loadtime:0.90024995803833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanborn' limit 1
loadtime:0.90028882026672 / seconds
Query Executed:select id FROM `ia` where city='Sanborn' && SIC_code='5651'DB:business_master_new
loadtime:0.9007248878479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scarville' limit 1
loadtime:0.90076088905334 / seconds
Query Executed:select id FROM `ia` where city='Scarville' && SIC_code='5651'DB:business_master_new
loadtime:0.90119290351868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schaller' limit 1
loadtime:0.90123295783997 / seconds
Query Executed:select id FROM `ia` where city='Schaller' && SIC_code='5651'DB:business_master_new
loadtime:0.90164279937744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schleswig' limit 1
loadtime:0.90168881416321 / seconds
Query Executed:select id FROM `ia` where city='Schleswig' && SIC_code='5651'DB:business_master_new
loadtime:0.90209579467773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Grove' limit 1
loadtime:0.90212392807007 / seconds
Query Executed:select id FROM `ia` where city='Scotch Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.90237998962402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:0.90241694450378 / seconds
Query Executed:select id FROM `ia` where city='Scranton' && SIC_code='5651'DB:business_master_new
loadtime:0.90279698371887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Searsboro' limit 1
loadtime:0.90282082557678 / seconds
Query Executed:select id FROM `ia` where city='Searsboro' && SIC_code='5651'DB:business_master_new
loadtime:0.90328288078308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:0.90331792831421 / seconds
Query Executed:select id FROM `ia` where city='Selma' && SIC_code='5651'DB:business_master_new
loadtime:0.90366792678833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeant Bluff' limit 1
loadtime:0.90370392799377 / seconds
Query Executed:select id FROM `ia` where city='Sergeant Bluff' && SIC_code='5651'DB:business_master_new
loadtime:0.9041428565979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.90418291091919 / seconds
Query Executed:select id FROM `ia` where city='Seymour' && SIC_code='5651'DB:business_master_new
loadtime:0.9045889377594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shambaugh' limit 1
loadtime:0.90462398529053 / seconds
Query Executed:select id FROM `ia` where city='Shambaugh' && SIC_code='5651'DB:business_master_new
loadtime:0.90495300292969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon City' limit 1
loadtime:0.90498781204224 / seconds
Query Executed:select id FROM `ia` where city='Shannon City' && SIC_code='5651'DB:business_master_new
loadtime:0.90540790557861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:0.90545892715454 / seconds
Query Executed:select id FROM `ia` where city='Sharpsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.9057948589325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:0.90582680702209 / seconds
Query Executed:select id FROM `ia` where city='Sheffield' && SIC_code='5651'DB:business_master_new
loadtime:0.9062488079071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:0.90628600120544 / seconds
Query Executed:select id FROM `ia` where city='Shelby' && SIC_code='5651'DB:business_master_new
loadtime:0.90668797492981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldahl' limit 1
loadtime:0.90672397613525 / seconds
Query Executed:select id FROM `ia` where city='Sheldahl' && SIC_code='5651'DB:business_master_new
loadtime:0.9070098400116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheldon' limit 1
loadtime:0.90704584121704 / seconds
Query Executed:select id FROM `ia` where city='Sheldon' && SIC_code='5651'DB:business_master_new
loadtime:0.90815997123718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell Rock' limit 1
loadtime:0.90819597244263 / seconds
Query Executed:select id FROM `ia` where city='Shell Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.90864086151123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shellsburg' limit 1
loadtime:0.90868878364563 / seconds
Query Executed:select id FROM `ia` where city='Shellsburg' && SIC_code='5651'DB:business_master_new
loadtime:0.90908885002136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shenandoah' limit 1
loadtime:0.9091169834137 / seconds
Query Executed:select id FROM `ia` where city='Shenandoah' && SIC_code='5651'DB:business_master_new
loadtime:0.91021800041199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrill' limit 1
loadtime:0.91026592254639 / seconds
Query Executed:select id FROM `ia` where city='Sherrill' && SIC_code='5651'DB:business_master_new
loadtime:0.91070985794067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sibley' limit 1
loadtime:0.91075396537781 / seconds
Query Executed:select id FROM `ia` where city='Sibley' && SIC_code='5651'DB:business_master_new
loadtime:0.9112069606781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sidney' limit 1
loadtime:0.91123485565186 / seconds
Query Executed:select id FROM `ia` where city='Sidney' && SIC_code='5651'DB:business_master_new
loadtime:0.91165995597839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigourney' limit 1
loadtime:0.91170692443848 / seconds
Query Executed:select id FROM `ia` where city='Sigourney' && SIC_code='5651'DB:business_master_new
loadtime:0.91213989257812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver City' limit 1
loadtime:0.91216993331909 / seconds
Query Executed:select id FROM `ia` where city='Silver City' && SIC_code='5651'DB:business_master_new
loadtime:0.91264891624451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Center' limit 1
loadtime:0.91269779205322 / seconds
Query Executed:select id FROM `ia` where city='Sioux Center' && SIC_code='5651'DB:business_master_new
loadtime:0.91382789611816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux City' limit 1
loadtime:0.91386389732361 / seconds
Query Executed:select id FROM `ia` where city='Sioux City' && SIC_code='5651'DB:business_master_new
loadtime:0.91498684883118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sioux Rapids' limit 1
loadtime:0.9150447845459 / seconds
Query Executed:select id FROM `ia` where city='Sioux Rapids' && SIC_code='5651'DB:business_master_new
loadtime:0.91549181938171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slater' limit 1
loadtime:0.91552782058716 / seconds
Query Executed:select id FROM `ia` where city='Slater' && SIC_code='5651'DB:business_master_new
loadtime:0.91594481468201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sloan' limit 1
loadtime:0.9159848690033 / seconds
Query Executed:select id FROM `ia` where city='Sloan' && SIC_code='5651'DB:business_master_new
loadtime:0.91640496253967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithland' limit 1
loadtime:0.91645288467407 / seconds
Query Executed:select id FROM `ia` where city='Smithland' && SIC_code='5651'DB:business_master_new
loadtime:0.91685199737549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Soldier' limit 1
loadtime:0.91689300537109 / seconds
Query Executed:select id FROM `ia` where city='Soldier' && SIC_code='5651'DB:business_master_new
loadtime:0.91733598709106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solon' limit 1
loadtime:0.91739296913147 / seconds
Query Executed:select id FROM `ia` where city='Solon' && SIC_code='5651'DB:business_master_new
loadtime:0.91784596443176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.91788196563721 / seconds
Query Executed:select id FROM `ia` where city='Somers' && SIC_code='5651'DB:business_master_new
loadtime:0.91839480400085 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amana' limit 1
loadtime:0.91844296455383 / seconds
Query Executed:select id FROM `ia` where city='South Amana' && SIC_code='5651'DB:business_master_new
loadtime:0.91894388198853 / seconds
Query loaded from cache:select * from geodata_geocity where city='South English' limit 1
loadtime:0.91898083686829 / seconds
Query Executed:select id FROM `ia` where city='South English' && SIC_code='5651'DB:business_master_new
loadtime:0.91943383216858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:0.91948199272156 / seconds
Query Executed:select id FROM `ia` where city='Spencer' && SIC_code='5651'DB:business_master_new
loadtime:0.9206018447876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sperry' limit 1
loadtime:0.92065978050232 / seconds
Query Executed:select id FROM `ia` where city='Sperry' && SIC_code='5651'DB:business_master_new
loadtime:0.92106080055237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spillville' limit 1
loadtime:0.92108988761902 / seconds
Query Executed:select id FROM `ia` where city='Spillville' && SIC_code='5651'DB:business_master_new
loadtime:0.92157578468323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spirit Lake' limit 1
loadtime:0.92162489891052 / seconds
Query Executed:select id FROM `ia` where city='Spirit Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.9227499961853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spragueville' limit 1
loadtime:0.92279386520386 / seconds
Query Executed:select id FROM `ia` where city='Spragueville' && SIC_code='5651'DB:business_master_new
loadtime:0.92325878143311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springbrook' limit 1
loadtime:0.92329883575439 / seconds
Query Executed:select id FROM `ia` where city='Springbrook' && SIC_code='5651'DB:business_master_new
loadtime:0.92370891571045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:0.92374491691589 / seconds
Query Executed:select id FROM `ia` where city='Springville' && SIC_code='5651'DB:business_master_new
loadtime:0.92417192459106 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Ansgar' limit 1
loadtime:0.92421197891235 / seconds
Query Executed:select id FROM `ia` where city='St Ansgar' && SIC_code='5651'DB:business_master_new
loadtime:0.92451500892639 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Anthony' limit 1
loadtime:0.92454981803894 / seconds
Query Executed:select id FROM `ia` where city='St Anthony' && SIC_code='5651'DB:business_master_new
loadtime:0.92479586601257 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Charles' limit 1
loadtime:0.92483186721802 / seconds
Query Executed:select id FROM `ia` where city='St Charles' && SIC_code='5651'DB:business_master_new
loadtime:0.92510390281677 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Donatus' limit 1
loadtime:0.92514085769653 / seconds
Query Executed:select id FROM `ia` where city='St Donatus' && SIC_code='5651'DB:business_master_new
loadtime:0.92538785934448 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Lucas' limit 1
loadtime:0.92541885375977 / seconds
Query Executed:select id FROM `ia` where city='St Lucas' && SIC_code='5651'DB:business_master_new
loadtime:0.92565393447876 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Marys' limit 1
loadtime:0.92567896842957 / seconds
Query Executed:select id FROM `ia` where city='St Marys' && SIC_code='5651'DB:business_master_new
loadtime:0.92590999603271 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Olaf' limit 1
loadtime:0.92594194412231 / seconds
Query Executed:select id FROM `ia` where city='St Olaf' && SIC_code='5651'DB:business_master_new
loadtime:0.92620778083801 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Paul' limit 1
loadtime:0.92624187469482 / seconds
Query Executed:select id FROM `ia` where city='St Paul' && SIC_code='5651'DB:business_master_new
loadtime:0.92647385597229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacyville' limit 1
loadtime:0.92649793624878 / seconds
Query Executed:select id FROM `ia` where city='Stacyville' && SIC_code='5651'DB:business_master_new
loadtime:0.92686486244202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:0.9268958568573 / seconds
Query Executed:select id FROM `ia` where city='Stanhope' && SIC_code='5651'DB:business_master_new
loadtime:0.92727994918823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:0.92730379104614 / seconds
Query Executed:select id FROM `ia` where city='Stanley' && SIC_code='5651'DB:business_master_new
loadtime:0.92772889137268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:0.92777681350708 / seconds
Query Executed:select id FROM `ia` where city='Stanton' && SIC_code='5651'DB:business_master_new
loadtime:0.92818689346313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanwood' limit 1
loadtime:0.92821478843689 / seconds
Query Executed:select id FROM `ia` where city='Stanwood' && SIC_code='5651'DB:business_master_new
loadtime:0.92861199378967 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Center' limit 1
loadtime:0.92865991592407 / seconds
Query Executed:select id FROM `ia` where city='State Center' && SIC_code='5651'DB:business_master_new
loadtime:0.92906498908997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steamboat Rock' limit 1
loadtime:0.92910289764404 / seconds
Query Executed:select id FROM `ia` where city='Steamboat Rock' && SIC_code='5651'DB:business_master_new
loadtime:0.92948889732361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockport' limit 1
loadtime:0.92952489852905 / seconds
Query Executed:select id FROM `ia` where city='Stockport' && SIC_code='5651'DB:business_master_new
loadtime:0.92990183830261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:0.92993879318237 / seconds
Query Executed:select id FROM `ia` where city='Stockton' && SIC_code='5651'DB:business_master_new
loadtime:0.93035078048706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storm Lake' limit 1
loadtime:0.93039894104004 / seconds
Query Executed:select id FROM `ia` where city='Storm Lake' && SIC_code='5651'DB:business_master_new
loadtime:0.93173789978027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Story City' limit 1
loadtime:0.93178200721741 / seconds
Query Executed:select id FROM `ia` where city='Story City' && SIC_code='5651'DB:business_master_new
loadtime:0.93279194831848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stout' limit 1
loadtime:0.93284797668457 / seconds
Query Executed:select id FROM `ia` where city='Stout' && SIC_code='5651'DB:business_master_new
loadtime:0.9332869052887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.93334794044495 / seconds
Query Executed:select id FROM `ia` where city='Stratford' && SIC_code='5651'DB:business_master_new
loadtime:0.93409585952759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry Point' limit 1
loadtime:0.93414783477783 / seconds
Query Executed:select id FROM `ia` where city='Strawberry Point' && SIC_code='5651'DB:business_master_new
loadtime:0.93481397628784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stuart' limit 1
loadtime:0.93484997749329 / seconds
Query Executed:select id FROM `ia` where city='Stuart' && SIC_code='5651'DB:business_master_new
loadtime:0.93533277511597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sully' limit 1
loadtime:0.93538093566895 / seconds
Query Executed:select id FROM `ia` where city='Sully' && SIC_code='5651'DB:business_master_new
loadtime:0.93578886985779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumner' limit 1
loadtime:0.93583297729492 / seconds
Query Executed:select id FROM `ia` where city='Sumner' && SIC_code='5651'DB:business_master_new
loadtime:0.93627786636353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.93630695343018 / seconds
Query Executed:select id FROM `ia` where city='Superior' && SIC_code='5651'DB:business_master_new
loadtime:0.93671178817749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sutherland' limit 1
loadtime:0.93675899505615 / seconds
Query Executed:select id FROM `ia` where city='Sutherland' && SIC_code='5651'DB:business_master_new
loadtime:0.93717789649963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swaledale' limit 1
loadtime:0.93720698356628 / seconds
Query Executed:select id FROM `ia` where city='Swaledale' && SIC_code='5651'DB:business_master_new
loadtime:0.93764185905457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swan' limit 1
loadtime:0.93769097328186 / seconds
Query Executed:select id FROM `ia` where city='Swan' && SIC_code='5651'DB:business_master_new
loadtime:0.93801879882812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swea City' limit 1
loadtime:0.93806099891663 / seconds
Query Executed:select id FROM `ia` where city='Swea City' && SIC_code='5651'DB:business_master_new
loadtime:0.9384708404541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesburg' limit 1
loadtime:0.93852186203003 / seconds
Query Executed:select id FROM `ia` where city='Swedesburg' && SIC_code='5651'DB:business_master_new
loadtime:0.93889784812927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swisher' limit 1
loadtime:0.9389328956604 / seconds
Query Executed:select id FROM `ia` where city='Swisher' && SIC_code='5651'DB:business_master_new
loadtime:0.93936586380005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor' limit 1
loadtime:0.93940186500549 / seconds
Query Executed:select id FROM `ia` where city='Tabor' && SIC_code='5651'DB:business_master_new
loadtime:0.93979597091675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taintor' limit 1
loadtime:0.93983578681946 / seconds
Query Executed:select id FROM `ia` where city='Taintor' && SIC_code='5651'DB:business_master_new
loadtime:0.94011497497559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tama' limit 1
loadtime:0.94014096260071 / seconds
Query Executed:select id FROM `ia` where city='Tama' && SIC_code='5651'DB:business_master_new
loadtime:0.94058394432068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teeds Grove' limit 1
loadtime:0.94063186645508 / seconds
Query Executed:select id FROM `ia` where city='Teeds Grove' && SIC_code='5651'DB:business_master_new
loadtime:0.94094681739807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Templeton' limit 1
loadtime:0.94097399711609 / seconds
Query Executed:select id FROM `ia` where city='Templeton' && SIC_code='5651'DB:business_master_new
loadtime:0.94140791893005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennant' limit 1
loadtime:0.94145584106445 / seconds
Query Executed:select id FROM `ia` where city='Tennant' && SIC_code='5651'DB:business_master_new
loadtime:0.94174981117249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terril' limit 1
loadtime:0.94177794456482 / seconds
Query Executed:select id FROM `ia` where city='Terril' && SIC_code='5651'DB:business_master_new
loadtime:0.94214987754822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayer' limit 1
loadtime:0.94218587875366 / seconds
Query Executed:select id FROM `ia` where city='Thayer' && SIC_code='5651'DB:business_master_new
loadtime:0.9425950050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.94263982772827 / seconds
Query Executed:select id FROM `ia` where city='Thompson' && SIC_code='5651'DB:business_master_new
loadtime:0.94301891326904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thor' limit 1
loadtime:0.94304585456848 / seconds
Query Executed:select id FROM `ia` where city='Thor' && SIC_code='5651'DB:business_master_new
loadtime:0.94845581054688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornburg' limit 1
loadtime:0.94858694076538 / seconds
Query Executed:select id FROM `ia` where city='Thornburg' && SIC_code='5651'DB:business_master_new
loadtime:0.94953584671021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.94963383674622 / seconds
Query Executed:select id FROM `ia` where city='Thornton' && SIC_code='5651'DB:business_master_new
loadtime:0.9507908821106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurman' limit 1
loadtime:0.95092082023621 / seconds
Query Executed:select id FROM `ia` where city='Thurman' && SIC_code='5651'DB:business_master_new
loadtime:0.95192885398865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tiffin' limit 1
loadtime:0.95202779769897 / seconds
Query Executed:select id FROM `ia` where city='Tiffin' && SIC_code='5651'DB:business_master_new
loadtime:0.95315480232239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tingley' limit 1
loadtime:0.95328497886658 / seconds
Query Executed:select id FROM `ia` where city='Tingley' && SIC_code='5651'DB:business_master_new
loadtime:0.9545738697052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tipton' limit 1
loadtime:0.95466995239258 / seconds
Query Executed:select id FROM `ia` where city='Tipton' && SIC_code='5651'DB:business_master_new
loadtime:0.95787787437439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titonka' limit 1
loadtime:0.9580090045929 / seconds
Query Executed:select id FROM `ia` where city='Titonka' && SIC_code='5651'DB:business_master_new
loadtime:0.95918393135071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toddville' limit 1
loadtime:0.95921993255615 / seconds
Query Executed:select id FROM `ia` where city='Toddville' && SIC_code='5651'DB:business_master_new
loadtime:0.96010899543762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toeterville' limit 1
loadtime:0.96020698547363 / seconds
Query Executed:select id FROM `ia` where city='Toeterville' && SIC_code='5651'DB:business_master_new
loadtime:0.96091485023499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toledo' limit 1
loadtime:0.96101880073547 / seconds
Query Executed:select id FROM `ia` where city='Toledo' && SIC_code='5651'DB:business_master_new
loadtime:0.96220397949219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toronto' limit 1
loadtime:0.96224188804626 / seconds
Query Executed:select id FROM `ia` where city='Toronto' && SIC_code='5651'DB:business_master_new
loadtime:0.96266078948975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tracy' limit 1
loadtime:0.96276879310608 / seconds
Query Executed:select id FROM `ia` where city='Tracy' && SIC_code='5651'DB:business_master_new
loadtime:0.96356987953186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traer' limit 1
loadtime:0.96369886398315 / seconds
Query Executed:select id FROM `ia` where city='Traer' && SIC_code='5651'DB:business_master_new
loadtime:0.96498584747314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Treynor' limit 1
loadtime:0.96512579917908 / seconds
Query Executed:select id FROM `ia` where city='Treynor' && SIC_code='5651'DB:business_master_new
loadtime:0.96612286567688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripoli' limit 1
loadtime:0.9662389755249 / seconds
Query Executed:select id FROM `ia` where city='Tripoli' && SIC_code='5651'DB:business_master_new
loadtime:0.96722078323364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy Mills' limit 1
loadtime:0.96726179122925 / seconds
Query Executed:select id FROM `ia` where city='Troy Mills' && SIC_code='5651'DB:business_master_new
loadtime:0.96803879737854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truesdale' limit 1
loadtime:0.96820378303528 / seconds
Query Executed:select id FROM `ia` where city='Truesdale' && SIC_code='5651'DB:business_master_new
loadtime:0.9691469669342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Truro' limit 1
loadtime:0.9692759513855 / seconds
Query Executed:select id FROM `ia` where city='Truro' && SIC_code='5651'DB:business_master_new
loadtime:0.97055077552795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turin' limit 1
loadtime:0.97064900398254 / seconds
Query Executed:select id FROM `ia` where city='Turin' && SIC_code='5651'DB:business_master_new
loadtime:0.97160482406616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Udell' limit 1
loadtime:0.97173500061035 / seconds
Query Executed:select id FROM `ia` where city='Udell' && SIC_code='5651'DB:business_master_new
loadtime:0.97285485267639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Underwood' limit 1
loadtime:0.97298288345337 / seconds
Query Executed:select id FROM `ia` where city='Underwood' && SIC_code='5651'DB:business_master_new
loadtime:0.97411394119263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.97421097755432 / seconds
Query Executed:select id FROM `ia` where city='Union' && SIC_code='5651'DB:business_master_new
loadtime:0.97532486915588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.97545480728149 / seconds
Query Executed:select id FROM `ia` where city='Unionville' && SIC_code='5651'DB:business_master_new
loadtime:0.97662281990051 / seconds
Query loaded from cache:select * from geodata_geocity where city='University Park' limit 1
loadtime:0.97671985626221 / seconds
Query Executed:select id FROM `ia` where city='University Park' && SIC_code='5651'DB:business_master_new
loadtime:0.97772979736328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbana' limit 1
loadtime:0.97785997390747 / seconds
Query Executed:select id FROM `ia` where city='Urbana' && SIC_code='5651'DB:business_master_new
loadtime:0.97904396057129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Urbandale' limit 1
loadtime:0.97919297218323 / seconds
Query Executed:select id FROM `ia` where city='Urbandale' && SIC_code='5651'DB:business_master_new
loadtime:0.98095798492432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ute' limit 1
loadtime:0.98105478286743 / seconds
Query Executed:select id FROM `ia` where city='Ute' && SIC_code='5651'DB:business_master_new
loadtime:0.9818549156189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.98197484016418 / seconds
Query Executed:select id FROM `ia` where city='Vail' && SIC_code='5651'DB:business_master_new
loadtime:0.98282480239868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Horne' limit 1
loadtime:0.98286080360413 / seconds
Query Executed:select id FROM `ia` where city='Van Horne' && SIC_code='5651'DB:business_master_new
loadtime:0.98367786407471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Meter' limit 1
loadtime:0.98372793197632 / seconds
Query Executed:select id FROM `ia` where city='Van Meter' && SIC_code='5651'DB:business_master_new
loadtime:0.98462200164795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Wert' limit 1
loadtime:0.9846727848053 / seconds
Query Executed:select id FROM `ia` where city='Van Wert' && SIC_code='5651'DB:business_master_new
loadtime:0.98539781570435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Varina' limit 1
loadtime:0.98551082611084 / seconds
Query Executed:select id FROM `ia` where city='Varina' && SIC_code='5651'DB:business_master_new
loadtime:0.98649191856384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventura' limit 1
loadtime:0.98658895492554 / seconds
Query Executed:select id FROM `ia` where city='Ventura' && SIC_code='5651'DB:business_master_new
loadtime:0.98724579811096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Victor' limit 1
loadtime:0.98728489875793 / seconds
Query Executed:select id FROM `ia` where city='Victor' && SIC_code='5651'DB:business_master_new
loadtime:0.98826193809509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villisca' limit 1
loadtime:0.98839282989502 / seconds
Query Executed:select id FROM `ia` where city='Villisca' && SIC_code='5651'DB:business_master_new
loadtime:0.98966097831726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincent' limit 1
loadtime:0.98975992202759 / seconds
Query Executed:select id FROM `ia` where city='Vincent' && SIC_code='5651'DB:business_master_new
loadtime:0.99411582946777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vining' limit 1
loadtime:0.99416399002075 / seconds
Query Executed:select id FROM `ia` where city='Vining' && SIC_code='5651'DB:business_master_new
loadtime:0.99450993537903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinton' limit 1
loadtime:0.99455595016479 / seconds
Query Executed:select id FROM `ia` where city='Vinton' && SIC_code='5651'DB:business_master_new
loadtime:0.99629282951355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Viola' limit 1
loadtime:0.99638986587524 / seconds
Query Executed:select id FROM `ia` where city='Viola' && SIC_code='5651'DB:business_master_new
loadtime:0.99719882011414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volga' limit 1
loadtime:0.99730587005615 / seconds
Query Executed:select id FROM `ia` where city='Volga' && SIC_code='5651'DB:business_master_new
loadtime:0.99862098693848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadena' limit 1
loadtime:0.99874997138977 / seconds
Query Executed:select id FROM `ia` where city='Wadena' && SIC_code='5651'DB:business_master_new
loadtime:0.99968600273132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walcott' limit 1
loadtime:0.99978280067444 / seconds
Query Executed:select id FROM `ia` where city='Walcott' && SIC_code='5651'DB:business_master_new
loadtime:1.0010228157043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walford' limit 1
loadtime:1.0011839866638 / seconds
Query Executed:select id FROM `ia` where city='Walford' && SIC_code='5651'DB:business_master_new
loadtime:1.0018689632416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walker' limit 1
loadtime:1.0019989013672 / seconds
Query Executed:select id FROM `ia` where city='Walker' && SIC_code='5651'DB:business_master_new
loadtime:1.0031659603119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Lake' limit 1
loadtime:1.003201007843 / seconds
Query Executed:select id FROM `ia` where city='Wall Lake' && SIC_code='5651'DB:business_master_new
loadtime:1.0043129920959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:1.0044429302216 / seconds
Query Executed:select id FROM `ia` where city='Wallingford' && SIC_code='5651'DB:business_master_new
loadtime:1.009162902832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut' limit 1
loadtime:1.0092928409576 / seconds
Query Executed:select id FROM `ia` where city='Walnut' && SIC_code='5651'DB:business_master_new
loadtime:1.0106477737427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapello' limit 1
loadtime:1.0107448101044 / seconds
Query Executed:select id FROM `ia` where city='Wapello' && SIC_code='5651'DB:business_master_new
loadtime:1.0118618011475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washburn' limit 1
loadtime:1.0119450092316 / seconds
Query Executed:select id FROM `ia` where city='Washburn' && SIC_code='5651'DB:business_master_new
loadtime:1.0127558708191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.0127909183502 / seconds
Query Executed:select id FROM `ia` where city='Washington' && SIC_code='5651'DB:business_master_new
loadtime:1.0156610012054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washta' limit 1
loadtime:1.0157959461212 / seconds
Query Executed:select id FROM `ia` where city='Washta' && SIC_code='5651'DB:business_master_new
loadtime:1.0170199871063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:1.0171558856964 / seconds
Query Executed:select id FROM `ia` where city='Waterloo' && SIC_code='5651'DB:business_master_new
loadtime:1.0198228359222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterville' limit 1
loadtime:1.0199840068817 / seconds
Query Executed:select id FROM `ia` where city='Waterville' && SIC_code='5651'DB:business_master_new
loadtime:1.0211379528046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watkins' limit 1
loadtime:1.0212359428406 / seconds
Query Executed:select id FROM `ia` where city='Watkins' && SIC_code='5651'DB:business_master_new
loadtime:1.0226089954376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waucoma' limit 1
loadtime:1.0227398872375 / seconds
Query Executed:select id FROM `ia` where city='Waucoma' && SIC_code='5651'DB:business_master_new
loadtime:1.023952960968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukee' limit 1
loadtime:1.0240869522095 / seconds
Query Executed:select id FROM `ia` where city='Waukee' && SIC_code='5651'DB:business_master_new
loadtime:1.0271739959717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waukon' limit 1
loadtime:1.0273089408875 / seconds
Query Executed:select id FROM `ia` where city='Waukon' && SIC_code='5651'DB:business_master_new
loadtime:1.0297257900238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.0297758579254 / seconds
Query Executed:select id FROM `ia` where city='Waverly' && SIC_code='5651'DB:business_master_new
loadtime:1.0317049026489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayland' limit 1
loadtime:1.0317528247833 / seconds
Query Executed:select id FROM `ia` where city='Wayland' && SIC_code='5651'DB:business_master_new
loadtime:1.0326788425446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:1.03271484375 / seconds
Query Executed:select id FROM `ia` where city='Webb' && SIC_code='5651'DB:business_master_new
loadtime:1.0335869789124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:1.0336740016937 / seconds
Query Executed:select id FROM `ia` where city='Webster' && SIC_code='5651'DB:business_master_new
loadtime:1.0345327854156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster City' limit 1
loadtime:1.0346519947052 / seconds
Query Executed:select id FROM `ia` where city='Webster City' && SIC_code='5651'DB:business_master_new
loadtime:1.0358059406281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:1.0358428955078 / seconds
Query Executed:select id FROM `ia` where city='Weldon' && SIC_code='5651'DB:business_master_new
loadtime:1.0362269878387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellman' limit 1
loadtime:1.0362668037415 / seconds
Query Executed:select id FROM `ia` where city='Wellman' && SIC_code='5651'DB:business_master_new
loadtime:1.0373828411102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsburg' limit 1
loadtime:1.0374188423157 / seconds
Query Executed:select id FROM `ia` where city='Wellsburg' && SIC_code='5651'DB:business_master_new
loadtime:1.037829875946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welton' limit 1
loadtime:1.0378777980804 / seconds
Query Executed:select id FROM `ia` where city='Welton' && SIC_code='5651'DB:business_master_new
loadtime:1.0382390022278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wesley' limit 1
loadtime:1.0382668972015 / seconds
Query Executed:select id FROM `ia` where city='Wesley' && SIC_code='5651'DB:business_master_new
loadtime:1.0386798381805 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Amana' limit 1
loadtime:1.0387279987335 / seconds
Query Executed:select id FROM `ia` where city='West Amana' && SIC_code='5651'DB:business_master_new
loadtime:1.0389769077301 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Bend' limit 1
loadtime:1.0390119552612 / seconds
Query Executed:select id FROM `ia` where city='West Bend' && SIC_code='5651'DB:business_master_new
loadtime:1.0394549369812 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Branch' limit 1
loadtime:1.0394909381866 / seconds
Query Executed:select id FROM `ia` where city='West Branch' && SIC_code='5651'DB:business_master_new
loadtime:1.0406188964844 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Burlington' limit 1
loadtime:1.040668964386 / seconds
Query Executed:select id FROM `ia` where city='West Burlington' && SIC_code='5651'DB:business_master_new
loadtime:1.0417969226837 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Chester' limit 1
loadtime:1.0418419837952 / seconds
Query Executed:select id FROM `ia` where city='West Chester' && SIC_code='5651'DB:business_master_new
loadtime:1.0422267913818 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Des Moines' limit 1
loadtime:1.0422668457031 / seconds
Query Executed:select id FROM `ia` where city='West Des Moines' && SIC_code='5651'DB:business_master_new
loadtime:1.0434169769287 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Grove' limit 1
loadtime:1.0434730052948 / seconds
Query Executed:select id FROM `ia` where city='West Grove' && SIC_code='5651'DB:business_master_new
loadtime:1.0437848567963 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Liberty' limit 1
loadtime:1.0438339710236 / seconds
Query Executed:select id FROM `ia` where city='West Liberty' && SIC_code='5651'DB:business_master_new
loadtime:1.0449538230896 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Point' limit 1
loadtime:1.044989824295 / seconds
Query Executed:select id FROM `ia` where city='West Point' && SIC_code='5651'DB:business_master_new
loadtime:1.0454459190369 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Union' limit 1
loadtime:1.0454938411713 / seconds
Query Executed:select id FROM `ia` where city='West Union' && SIC_code='5651'DB:business_master_new
loadtime:1.0466229915619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:1.0466668605804 / seconds
Query Executed:select id FROM `ia` where city='Westfield' && SIC_code='5651'DB:business_master_new
loadtime:1.0470597743988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westgate' limit 1
loadtime:1.0470998287201 / seconds
Query Executed:select id FROM `ia` where city='Westgate' && SIC_code='5651'DB:business_master_new
loadtime:1.0475068092346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westphalia' limit 1
loadtime:1.0475428104401 / seconds
Query Executed:select id FROM `ia` where city='Westphalia' && SIC_code='5651'DB:business_master_new
loadtime:1.0479028224945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westside' limit 1
loadtime:1.0479419231415 / seconds
Query Executed:select id FROM `ia` where city='Westside' && SIC_code='5651'DB:business_master_new
loadtime:1.0483758449554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wever' limit 1
loadtime:1.0484108924866 / seconds
Query Executed:select id FROM `ia` where city='Wever' && SIC_code='5651'DB:business_master_new
loadtime:1.048800945282 / seconds
Query loaded from cache:select * from geodata_geocity where city='What Cheer' limit 1
loadtime:1.0488488674164 / seconds
Query Executed:select id FROM `ia` where city='What Cheer' && SIC_code='5651'DB:business_master_new
loadtime:1.0492248535156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheatland' limit 1
loadtime:1.0492517948151 / seconds
Query Executed:select id FROM `ia` where city='Wheatland' && SIC_code='5651'DB:business_master_new
loadtime:1.0496599674225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:1.0497078895569 / seconds
Query Executed:select id FROM `ia` where city='Whiting' && SIC_code='5651'DB:business_master_new
loadtime:1.0501089096069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittemore' limit 1
loadtime:1.0501489639282 / seconds
Query Executed:select id FROM `ia` where city='Whittemore' && SIC_code='5651'DB:business_master_new
loadtime:1.0505409240723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitten' limit 1
loadtime:1.050577878952 / seconds
Query Executed:select id FROM `ia` where city='Whitten' && SIC_code='5651'DB:business_master_new
loadtime:1.050940990448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:1.0509808063507 / seconds
Query Executed:select id FROM `ia` where city='Williams' && SIC_code='5651'DB:business_master_new
loadtime:1.0514049530029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamsburg' limit 1
loadtime:1.0514528751373 / seconds
Query Executed:select id FROM `ia` where city='Williamsburg' && SIC_code='5651'DB:business_master_new
loadtime:1.0525817871094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamson' limit 1
loadtime:1.0526299476624 / seconds
Query Executed:select id FROM `ia` where city='Williamson' && SIC_code='5651'DB:business_master_new
loadtime:1.0529367923737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.0529789924622 / seconds
Query Executed:select id FROM `ia` where city='Wilton' && SIC_code='5651'DB:business_master_new
loadtime:1.0540897846222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Heights' limit 1
loadtime:1.0541379451752 / seconds
Query Executed:select id FROM `ia` where city='Windsor Heights' && SIC_code='5651'DB:business_master_new
loadtime:1.0552368164062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:1.0552728176117 / seconds
Query Executed:select id FROM `ia` where city='Winfield' && SIC_code='5651'DB:business_master_new
loadtime:1.0557148456573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterset' limit 1
loadtime:1.0557658672333 / seconds
Query Executed:select id FROM `ia` where city='Winterset' && SIC_code='5651'DB:business_master_new
loadtime:1.0568759441376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winthrop' limit 1
loadtime:1.0569307804108 / seconds
Query Executed:select id FROM `ia` where city='Winthrop' && SIC_code='5651'DB:business_master_new
loadtime:1.0573649406433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wiota' limit 1
loadtime:1.0574018955231 / seconds
Query Executed:select id FROM `ia` where city='Wiota' && SIC_code='5651'DB:business_master_new
loadtime:1.0578098297119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woden' limit 1
loadtime:1.057856798172 / seconds
Query Executed:select id FROM `ia` where city='Woden' && SIC_code='5651'DB:business_master_new
loadtime:1.0582668781281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:1.0583038330078 / seconds
Query Executed:select id FROM `ia` where city='Woodbine' && SIC_code='5651'DB:business_master_new
loadtime:1.0587208271027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodburn' limit 1
loadtime:1.0587558746338 / seconds
Query Executed:select id FROM `ia` where city='Woodburn' && SIC_code='5651'DB:business_master_new
loadtime:1.0591628551483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodward' limit 1
loadtime:1.0592038631439 / seconds
Query Executed:select id FROM `ia` where city='Woodward' && SIC_code='5651'DB:business_master_new
loadtime:1.0596008300781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woolstock' limit 1
loadtime:1.0596368312836 / seconds
Query Executed:select id FROM `ia` where city='Woolstock' && SIC_code='5651'DB:business_master_new
loadtime:1.0600209236145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worthington' limit 1
loadtime:1.0600688457489 / seconds
Query Executed:select id FROM `ia` where city='Worthington' && SIC_code='5651'DB:business_master_new
loadtime:1.0604748725891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyoming' limit 1
loadtime:1.060525894165 / seconds
Query Executed:select id FROM `ia` where city='Wyoming' && SIC_code='5651'DB:business_master_new
loadtime:1.0609419345856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yale' limit 1
loadtime:1.0609757900238 / seconds
Query Executed:select id FROM `ia` where city='Yale' && SIC_code='5651'DB:business_master_new
loadtime:1.0613780021667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarmouth' limit 1
loadtime:1.0614140033722 / seconds
Query Executed:select id FROM `ia` where city='Yarmouth' && SIC_code='5651'DB:business_master_new
loadtime:1.0617899894714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yorktown' limit 1
loadtime:1.0618288516998 / seconds
Query Executed:select id FROM `ia` where city='Yorktown' && SIC_code='5651'DB:business_master_new
loadtime:1.062127828598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zearing' limit 1
loadtime:1.062155008316 / seconds
Query Executed:select id FROM `ia` where city='Zearing' && SIC_code='5651'DB:business_master_new
loadtime:1.0625638961792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zwingle' limit 1
loadtime:1.0626118183136 / seconds
Query Executed:select id FROM `ia` where city='Zwingle' && SIC_code='5651'DB:business_master_new
loadtime:1.0637209415436 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.063807964325 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.0642409324646 / seconds
Operation template executed (chunk cache operation)
loadtime:1.064435005188 / seconds
template override:Default
loadtime:1.0644829273224 / 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:1.0663828849792 / seconds
Template Constructed, Array Rows:49
loadtime:1.0669918060303 / seconds
TOTAL EXECUTION TIME: 1.06651
loadtime:1.0671939849854 / 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] => family-clothing-stores [stateURLid] => iowa )


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