DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.2942504882812E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017340183258057 / seconds
host not found setting manual db connection
loadtime:0.0095038414001465 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0097129344940186 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0098400115966797 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0099020004272461 / seconds
zipcode:
loadtime:0.0099289417266846 / seconds
Query Executed:select * from search_referrer where page_hash='dfc92bd205e9a04248e5037840a9490e' limit 10 DB:ezrox_toadli
loadtime:0.010167837142944 / seconds
Operation header executed (non global)
loadtime:0.010196924209595 / seconds
Operation leaderboard executed (non global)
loadtime:0.010244846343994 / seconds
Operation square executed (non global)
loadtime:0.010273933410645 / seconds
Operation square_bottom executed (non global)
loadtime:0.010300874710083 / seconds
Operation smallsquare executed (non global)
loadtime:0.010326862335205 / seconds
Operation headeradright executed (non global)
loadtime:0.010351896286011 / seconds
Operation google_analytics executed (non global)
loadtime:0.0103759765625 / seconds
Operation topstories executed (non global)
loadtime:0.010401964187622 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010427951812744 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010452032089233 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01070499420166 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010908842086792 / seconds
Operation categories executed (global stored into APC)
loadtime:0.010948896408081 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011005878448486 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011066913604736 / seconds
Template key: archive_menu pushed
loadtime:0.011075973510742 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011088848114014 / seconds
Template key: get_gravatar pushed
loadtime:0.011096000671387 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011103868484497 / seconds
*10)-10)+1 | start:0
loadtime:0.011144876480103 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.011186838150024 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wyoming'
loadtime:0.011221885681152 / seconds
DB connected to localhost business_master_new
loadtime:0.011443853378296 / seconds
Query Executed:select * from `wy_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.08227801322937 / seconds
Query stored in cache : _QUERY_www.toadli.com8521a6b34480a8dc864c60f2edf583c0
loadtime:0.083060026168823 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='wyoming'
loadtime:0.083110809326172 / seconds
Query Executed:select sum(totalcount) as totalsum from `wy_catmap` where sic='6021'DB:business_master_new
loadtime:0.084322929382324 / seconds
Query stored in cache : _QUERY_www.toadli.com81b41c969796e6b304d63c348ae15ef9
loadtime:0.084362983703613 / seconds
190 / 11
loadtime:0.084419965744019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Afton' limit 1
loadtime:0.08448600769043 / seconds
Query Executed:select id FROM `wy` where city='Afton' && SIC_code='6021'DB:business_master_new
loadtime:0.095361948013306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aladdin' limit 1
loadtime:0.095444917678833 / seconds
Query Executed:select id FROM `wy` where city='Aladdin' && SIC_code='6021'DB:business_master_new
loadtime:0.095980882644653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albin' limit 1
loadtime:0.096055030822754 / seconds
Query Executed:select id FROM `wy` where city='Albin' && SIC_code='6021'DB:business_master_new
loadtime:0.096812963485718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alcova' limit 1
loadtime:0.096879005432129 / seconds
Query Executed:select id FROM `wy` where city='Alcova' && SIC_code='6021'DB:business_master_new
loadtime:0.09751296043396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.097573041915894 / seconds
Query Executed:select id FROM `wy` where city='Alpine' && SIC_code='6021'DB:business_master_new
loadtime:0.09943699836731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.099514961242676 / seconds
Query Executed:select id FROM `wy` where city='Alta' && SIC_code='6021'DB:business_master_new
loadtime:0.10004782676697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alva' limit 1
loadtime:0.10010981559753 / seconds
Query Executed:select id FROM `wy` where city='Alva' && SIC_code='6021'DB:business_master_new
loadtime:0.10056900978088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.10062885284424 / seconds
Query Executed:select id FROM `wy` where city='Arapahoe' && SIC_code='6021'DB:business_master_new
loadtime:0.10130381584167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arminto' limit 1
loadtime:0.10136604309082 / seconds
Query Executed:select id FROM `wy` where city='Arminto' && SIC_code='6021'DB:business_master_new
loadtime:0.10177087783813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arvada' limit 1
loadtime:0.10183191299438 / seconds
Query Executed:select id FROM `wy` where city='Arvada' && SIC_code='6021'DB:business_master_new
loadtime:0.10246682167053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic City' limit 1
loadtime:0.10252785682678 / seconds
Query Executed:select id FROM `wy` where city='Atlantic City' && SIC_code='6021'DB:business_master_new
loadtime:0.10293483734131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.10299682617188 / seconds
Query Executed:select id FROM `wy` where city='Auburn' && SIC_code='6021'DB:business_master_new
loadtime:0.10349297523499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baggs' limit 1
loadtime:0.10355401039124 / seconds
Query Executed:select id FROM `wy` where city='Baggs' && SIC_code='6021'DB:business_master_new
loadtime:0.10501289367676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bairoil' limit 1
loadtime:0.10510897636414 / seconds
Query Executed:select id FROM `wy` where city='Bairoil' && SIC_code='6021'DB:business_master_new
loadtime:0.10565590858459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner' limit 1
loadtime:0.10571694374084 / seconds
Query Executed:select id FROM `wy` where city='Banner' && SIC_code='6021'DB:business_master_new
loadtime:0.10639595985413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bar Nunn' limit 1
loadtime:0.10645604133606 / seconds
Query Executed:select id FROM `wy` where city='Bar Nunn' && SIC_code='6021'DB:business_master_new
loadtime:0.10685586929321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basin' limit 1
loadtime:0.10693097114563 / seconds
Query Executed:select id FROM `wy` where city='Basin' && SIC_code='6021'DB:business_master_new
loadtime:0.10920095443726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear River' limit 1
loadtime:0.10927700996399 / seconds
Query Executed:select id FROM `wy` where city='Bear River' && SIC_code='6021'DB:business_master_new
loadtime:0.1096658706665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.10972595214844 / seconds
Query Executed:select id FROM `wy` where city='Bedford' && SIC_code='6021'DB:business_master_new
loadtime:0.11039781570435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulah' limit 1
loadtime:0.11045789718628 / seconds
Query Executed:select id FROM `wy` where city='Beulah' && SIC_code='6021'DB:business_master_new
loadtime:0.11096096038818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Horn' limit 1
loadtime:0.11103296279907 / seconds
Query Executed:select id FROM `wy` where city='Big Horn' && SIC_code='6021'DB:business_master_new
loadtime:0.1119270324707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Piney' limit 1
loadtime:0.11198687553406 / seconds
Query Executed:select id FROM `wy` where city='Big Piney' && SIC_code='6021'DB:business_master_new
loadtime:0.11446404457092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bondurant' limit 1
loadtime:0.11454200744629 / seconds
Query Executed:select id FROM `wy` where city='Bondurant' && SIC_code='6021'DB:business_master_new
loadtime:0.11516785621643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bosler' limit 1
loadtime:0.11522889137268 / seconds
Query Executed:select id FROM `wy` where city='Bosler' && SIC_code='6021'DB:business_master_new
loadtime:0.11563992500305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.11570501327515 / seconds
Query Executed:select id FROM `wy` where city='Boulder' && SIC_code='6021'DB:business_master_new
loadtime:0.11660289764404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buffalo' limit 1
loadtime:0.11666393280029 / seconds
Query Executed:select id FROM `wy` where city='Buffalo' && SIC_code='6021'DB:business_master_new
loadtime:0.12335181236267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buford' limit 1
loadtime:0.12343382835388 / seconds
Query Executed:select id FROM `wy` where city='Buford' && SIC_code='6021'DB:business_master_new
loadtime:0.12394690513611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.12400794029236 / seconds
Query Executed:select id FROM `wy` where city='Burlington' && SIC_code='6021'DB:business_master_new
loadtime:0.12490296363831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burns' limit 1
loadtime:0.12496304512024 / seconds
Query Executed:select id FROM `wy` where city='Burns' && SIC_code='6021'DB:business_master_new
loadtime:0.12629699707031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Byron' limit 1
loadtime:0.12637281417847 / seconds
Query Executed:select id FROM `wy` where city='Byron' && SIC_code='6021'DB:business_master_new
loadtime:0.12705898284912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlile' limit 1
loadtime:0.12712001800537 / seconds
Query Executed:select id FROM `wy` where city='Carlile' && SIC_code='6021'DB:business_master_new
loadtime:0.12750887870789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carpenter' limit 1
loadtime:0.12756991386414 / seconds
Query Executed:select id FROM `wy` where city='Carpenter' && SIC_code='6021'DB:business_master_new
loadtime:0.12835001945496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casper' limit 1
loadtime:0.12841081619263 / seconds
Query Executed:select id FROM `wy` where city='Casper' && SIC_code='6021'DB:business_master_new
loadtime:0.13286590576172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centennial' limit 1
loadtime:0.13296294212341 / seconds
Query Executed:select id FROM `wy` where city='Centennial' && SIC_code='6021'DB:business_master_new
loadtime:0.13373994827271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheyenne' limit 1
loadtime:0.1338050365448 / seconds
Query Executed:select id FROM `wy` where city='Cheyenne' && SIC_code='6021'DB:business_master_new
loadtime:0.13613700866699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chugwater' limit 1
loadtime:0.13625192642212 / seconds
Query Executed:select id FROM `wy` where city='Chugwater' && SIC_code='6021'DB:business_master_new
loadtime:0.13846397399902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearmont' limit 1
loadtime:0.13852381706238 / seconds
Query Executed:select id FROM `wy` where city='Clearmont' && SIC_code='6021'DB:business_master_new
loadtime:0.13915491104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cody' limit 1
loadtime:0.13920998573303 / seconds
Query Executed:select id FROM `wy` where city='Cody' && SIC_code='6021'DB:business_master_new
loadtime:0.14148092269897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cokeville' limit 1
loadtime:0.14155983924866 / seconds
Query Executed:select id FROM `wy` where city='Cokeville' && SIC_code='6021'DB:business_master_new
loadtime:0.14257192611694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cora' limit 1
loadtime:0.14262700080872 / seconds
Query Executed:select id FROM `wy` where city='Cora' && SIC_code='6021'DB:business_master_new
loadtime:0.14322280883789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowley' limit 1
loadtime:0.14327692985535 / seconds
Query Executed:select id FROM `wy` where city='Cowley' && SIC_code='6021'DB:business_master_new
loadtime:0.14417886734009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crowheart' limit 1
loadtime:0.14423084259033 / seconds
Query Executed:select id FROM `wy` where city='Crowheart' && SIC_code='6021'DB:business_master_new
loadtime:0.1447958946228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daniel' limit 1
loadtime:0.14484691619873 / seconds
Query Executed:select id FROM `wy` where city='Daniel' && SIC_code='6021'DB:business_master_new
loadtime:0.14568495750427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.14573788642883 / seconds
Query Executed:select id FROM `wy` where city='Dayton' && SIC_code='6021'DB:business_master_new
loadtime:0.14661288261414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deaver' limit 1
loadtime:0.14666485786438 / seconds
Query Executed:select id FROM `wy` where city='Deaver' && SIC_code='6021'DB:business_master_new
loadtime:0.14732885360718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Devils Tower' limit 1
loadtime:0.14738082885742 / seconds
Query Executed:select id FROM `wy` where city='Devils Tower' && SIC_code='6021'DB:business_master_new
loadtime:0.14781498908997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Diamondville' limit 1
loadtime:0.14786601066589 / seconds
Query Executed:select id FROM `wy` where city='Diamondville' && SIC_code='6021'DB:business_master_new
loadtime:0.14875888824463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixon' limit 1
loadtime:0.14881086349487 / seconds
Query Executed:select id FROM `wy` where city='Dixon' && SIC_code='6021'DB:business_master_new
loadtime:0.1493079662323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.14936184883118 / seconds
Query Executed:select id FROM `wy` where city='Douglas' && SIC_code='6021'DB:business_master_new
loadtime:0.15594792366028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dubois' limit 1
loadtime:0.1560230255127 / seconds
Query Executed:select id FROM `wy` where city='Dubois' && SIC_code='6021'DB:business_master_new
loadtime:0.15998101234436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgerton' limit 1
loadtime:0.16005396842957 / seconds
Query Executed:select id FROM `wy` where city='Edgerton' && SIC_code='6021'DB:business_master_new
loadtime:0.16065382957458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Mountain' limit 1
loadtime:0.16070795059204 / seconds
Query Executed:select id FROM `wy` where city='Elk Mountain' && SIC_code='6021'DB:business_master_new
loadtime:0.16139483451843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emblem' limit 1
loadtime:0.16144800186157 / seconds
Query Executed:select id FROM `wy` where city='Emblem' && SIC_code='6021'DB:business_master_new
loadtime:0.1619188785553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Encampment' limit 1
loadtime:0.16197180747986 / seconds
Query Executed:select id FROM `wy` where city='Encampment' && SIC_code='6021'DB:business_master_new
loadtime:0.16338896751404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethete' limit 1
loadtime:0.1634418964386 / seconds
Query Executed:select id FROM `wy` where city='Ethete' && SIC_code='6021'DB:business_master_new
loadtime:0.16385388374329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.16391396522522 / seconds
Query Executed:select id FROM `wy` where city='Etna' && SIC_code='6021'DB:business_master_new
loadtime:0.16472792625427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evanston' limit 1
loadtime:0.16477990150452 / seconds
Query Executed:select id FROM `wy` where city='Evanston' && SIC_code='6021'DB:business_master_new
loadtime:0.16709899902344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evansville' limit 1
loadtime:0.16717481613159 / seconds
Query Executed:select id FROM `wy` where city='Evansville' && SIC_code='6021'DB:business_master_new
loadtime:0.16921591758728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.16928386688232 / seconds
Query Executed:select id FROM `wy` where city='Fairview' && SIC_code='6021'DB:business_master_new
loadtime:0.16965889930725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farson' limit 1
loadtime:0.1697108745575 / seconds
Query Executed:select id FROM `wy` where city='Farson' && SIC_code='6021'DB:business_master_new
loadtime:0.1706109046936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fe Warren Afb' limit 1
loadtime:0.17066383361816 / seconds
Query Executed:select id FROM `wy` where city='Fe Warren Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.17139887809753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bridger' limit 1
loadtime:0.17145180702209 / seconds
Query Executed:select id FROM `wy` where city='Fort Bridger' && SIC_code='6021'DB:business_master_new
loadtime:0.17252492904663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Laramie' limit 1
loadtime:0.17257690429688 / seconds
Query Executed:select id FROM `wy` where city='Fort Laramie' && SIC_code='6021'DB:business_master_new
loadtime:0.17319083213806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Washakie' limit 1
loadtime:0.17324280738831 / seconds
Query Executed:select id FROM `wy` where city='Fort Washakie' && SIC_code='6021'DB:business_master_new
loadtime:0.17466187477112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four Corners' limit 1
loadtime:0.17471385002136 / seconds
Query Executed:select id FROM `wy` where city='Four Corners' && SIC_code='6021'DB:business_master_new
loadtime:0.17511487007141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frannie' limit 1
loadtime:0.17516803741455 / seconds
Query Executed:select id FROM `wy` where city='Frannie' && SIC_code='6021'DB:business_master_new
loadtime:0.17578601837158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.17583584785461 / seconds
Query Executed:select id FROM `wy` where city='Freedom' && SIC_code='6021'DB:business_master_new
loadtime:0.17804789543152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frontier' limit 1
loadtime:0.17810082435608 / seconds
Query Executed:select id FROM `wy` where city='Frontier' && SIC_code='6021'DB:business_master_new
loadtime:0.17845392227173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrett' limit 1
loadtime:0.17850494384766 / seconds
Query Executed:select id FROM `wy` where city='Garrett' && SIC_code='6021'DB:business_master_new
loadtime:0.17886090278625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillette' limit 1
loadtime:0.17892384529114 / seconds
Query Executed:select id FROM `wy` where city='Gillette' && SIC_code='6021'DB:business_master_new
loadtime:0.18120884895325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendo' limit 1
loadtime:0.18128991127014 / seconds
Query Executed:select id FROM `wy` where city='Glendo' && SIC_code='6021'DB:business_master_new
loadtime:0.18238401412964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenrock' limit 1
loadtime:0.18243885040283 / seconds
Query Executed:select id FROM `wy` where city='Glenrock' && SIC_code='6021'DB:business_master_new
loadtime:0.18510484695435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granger' limit 1
loadtime:0.18517303466797 / seconds
Query Executed:select id FROM `wy` where city='Granger' && SIC_code='6021'DB:business_master_new
loadtime:0.18565797805786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Canon' limit 1
loadtime:0.18570995330811 / seconds
Query Executed:select id FROM `wy` where city='Granite Canon' && SIC_code='6021'DB:business_master_new
loadtime:0.18617701530457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green River' limit 1
loadtime:0.18622994422913 / seconds
Query Executed:select id FROM `wy` where city='Green River' && SIC_code='6021'DB:business_master_new
loadtime:0.18851184844971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greybull' limit 1
loadtime:0.18858289718628 / seconds
Query Executed:select id FROM `wy` where city='Greybull' && SIC_code='6021'DB:business_master_new
loadtime:0.19158792495728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:0.191654920578 / seconds
Query Executed:select id FROM `wy` where city='Grover' && SIC_code='6021'DB:business_master_new
loadtime:0.19213581085205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guernsey' limit 1
loadtime:0.19218993186951 / seconds
Query Executed:select id FROM `wy` where city='Guernsey' && SIC_code='6021'DB:business_master_new
loadtime:0.19366502761841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanna' limit 1
loadtime:0.19371795654297 / seconds
Query Executed:select id FROM `wy` where city='Hanna' && SIC_code='6021'DB:business_master_new
loadtime:0.1948299407959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartville' limit 1
loadtime:0.19490599632263 / seconds
Query Executed:select id FROM `wy` where city='Hartville' && SIC_code='6021'DB:business_master_new
loadtime:0.19535183906555 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawk Springs' limit 1
loadtime:0.19540500640869 / seconds
Query Executed:select id FROM `wy` where city='Hawk Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.19594693183899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiland' limit 1
loadtime:0.19599986076355 / seconds
Query Executed:select id FROM `wy` where city='Hiland' && SIC_code='6021'DB:business_master_new
loadtime:0.19639492034912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:0.19644689559937 / seconds
Query Executed:select id FROM `wy` where city='Hillsdale' && SIC_code='6021'DB:business_master_new
loadtime:0.19699883460999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horse Creek' limit 1
loadtime:0.19705581665039 / seconds
Query Executed:select id FROM `wy` where city='Horse Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.19739699363708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.19744896888733 / seconds
Query Executed:select id FROM `wy` where city='Hudson' && SIC_code='6021'DB:business_master_new
loadtime:0.19796299934387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hulett' limit 1
loadtime:0.1980140209198 / seconds
Query Executed:select id FROM `wy` where city='Hulett' && SIC_code='6021'DB:business_master_new
loadtime:0.19952392578125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntley' limit 1
loadtime:0.19958901405334 / seconds
Query Executed:select id FROM `wy` where city='Huntley' && SIC_code='6021'DB:business_master_new
loadtime:0.20002102851868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyattville' limit 1
loadtime:0.20007801055908 / seconds
Query Executed:select id FROM `wy` where city='Hyattville' && SIC_code='6021'DB:business_master_new
loadtime:0.20061302185059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Mountain' limit 1
loadtime:0.20066404342651 / seconds
Query Executed:select id FROM `wy` where city='Iron Mountain' && SIC_code='6021'DB:business_master_new
loadtime:0.20105290412903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.20110392570496 / seconds
Query Executed:select id FROM `wy` where city='Jackson' && SIC_code='6021'DB:business_master_new
loadtime:0.20336484909058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jay Em' limit 1
loadtime:0.20344090461731 / seconds
Query Executed:select id FROM `wy` where city='Jay Em' && SIC_code='6021'DB:business_master_new
loadtime:0.20379090309143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jeffrey City' limit 1
loadtime:0.20384287834167 / seconds
Query Executed:select id FROM `wy` where city='Jeffrey City' && SIC_code='6021'DB:business_master_new
loadtime:0.2060079574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jelm' limit 1
loadtime:0.20606398582458 / seconds
Query Executed:select id FROM `wy` where city='Jelm' && SIC_code='6021'DB:business_master_new
loadtime:0.20647287368774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaycee' limit 1
loadtime:0.20652294158936 / seconds
Query Executed:select id FROM `wy` where city='Kaycee' && SIC_code='6021'DB:business_master_new
loadtime:0.20797085762024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelly' limit 1
loadtime:0.20802283287048 / seconds
Query Executed:select id FROM `wy` where city='Kelly' && SIC_code='6021'DB:business_master_new
loadtime:0.21021485328674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kemmerer' limit 1
loadtime:0.21027588844299 / seconds
Query Executed:select id FROM `wy` where city='Kemmerer' && SIC_code='6021'DB:business_master_new
loadtime:0.21313285827637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinnear' limit 1
loadtime:0.21320390701294 / seconds
Query Executed:select id FROM `wy` where city='Kinnear' && SIC_code='6021'DB:business_master_new
loadtime:0.21538090705872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirby' limit 1
loadtime:0.21543502807617 / seconds
Query Executed:select id FROM `wy` where city='Kirby' && SIC_code='6021'DB:business_master_new
loadtime:0.21589088439941 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Barge' limit 1
loadtime:0.21594285964966 / seconds
Query Executed:select id FROM `wy` where city='La Barge' && SIC_code='6021'DB:business_master_new
loadtime:0.21735596656799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lagrange' limit 1
loadtime:0.21740794181824 / seconds
Query Executed:select id FROM `wy` where city='Lagrange' && SIC_code='6021'DB:business_master_new
loadtime:0.21839284896851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lance Creek' limit 1
loadtime:0.21844601631165 / seconds
Query Executed:select id FROM `wy` where city='Lance Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.21891498565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lander' limit 1
loadtime:0.21896696090698 / seconds
Query Executed:select id FROM `wy` where city='Lander' && SIC_code='6021'DB:business_master_new
loadtime:0.22124695777893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laramie' limit 1
loadtime:0.22132182121277 / seconds
Query Executed:select id FROM `wy` where city='Laramie' && SIC_code='6021'DB:business_master_new
loadtime:0.2236168384552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leiter' limit 1
loadtime:0.22369790077209 / seconds
Query Executed:select id FROM `wy` where city='Leiter' && SIC_code='6021'DB:business_master_new
loadtime:0.22415089607239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linch' limit 1
loadtime:0.22420692443848 / seconds
Query Executed:select id FROM `wy` where city='Linch' && SIC_code='6021'DB:business_master_new
loadtime:0.22462201118469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lingle' limit 1
loadtime:0.22467303276062 / seconds
Query Executed:select id FROM `wy` where city='Lingle' && SIC_code='6021'DB:business_master_new
loadtime:0.22602200508118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little America' limit 1
loadtime:0.22609186172485 / seconds
Query Executed:select id FROM `wy` where city='Little America' && SIC_code='6021'DB:business_master_new
loadtime:0.22646403312683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lonetree' limit 1
loadtime:0.22651600837708 / seconds
Query Executed:select id FROM `wy` where city='Lonetree' && SIC_code='6021'DB:business_master_new
loadtime:0.2268660068512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lost Springs' limit 1
loadtime:0.22692584991455 / seconds
Query Executed:select id FROM `wy` where city='Lost Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.2272789478302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lovell' limit 1
loadtime:0.22733092308044 / seconds
Query Executed:select id FROM `wy` where city='Lovell' && SIC_code='6021'DB:business_master_new
loadtime:0.23071098327637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lusk' limit 1
loadtime:0.2307870388031 / seconds
Query Executed:select id FROM `wy` where city='Lusk' && SIC_code='6021'DB:business_master_new
loadtime:0.23338294029236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.2334508895874 / seconds
Query Executed:select id FROM `wy` where city='Lyman' && SIC_code='6021'DB:business_master_new
loadtime:0.23578596115112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lysite' limit 1
loadtime:0.23585081100464 / seconds
Query Executed:select id FROM `wy` where city='Lysite' && SIC_code='6021'DB:business_master_new
loadtime:0.23640489578247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manderson' limit 1
loadtime:0.23645901679993 / seconds
Query Executed:select id FROM `wy` where city='Manderson' && SIC_code='6021'DB:business_master_new
loadtime:0.23711180686951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manville' limit 1
loadtime:0.23716497421265 / seconds
Query Executed:select id FROM `wy` where city='Manville' && SIC_code='6021'DB:business_master_new
loadtime:0.23756980895996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marbleton' limit 1
loadtime:0.23762083053589 / seconds
Query Executed:select id FROM `wy` where city='Marbleton' && SIC_code='6021'DB:business_master_new
loadtime:0.23860788345337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kinnon' limit 1
loadtime:0.23865985870361 / seconds
Query Executed:select id FROM `wy` where city='Mc Kinnon' && SIC_code='6021'DB:business_master_new
loadtime:0.23906588554382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcfadden' limit 1
loadtime:0.23911786079407 / seconds
Query Executed:select id FROM `wy` where city='Mcfadden' && SIC_code='6021'DB:business_master_new
loadtime:0.23950695991516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medicine Bow' limit 1
loadtime:0.23955702781677 / seconds
Query Executed:select id FROM `wy` where city='Medicine Bow' && SIC_code='6021'DB:business_master_new
loadtime:0.24057602882385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meeteetse' limit 1
loadtime:0.2406280040741 / seconds
Query Executed:select id FROM `wy` where city='Meeteetse' && SIC_code='6021'DB:business_master_new
loadtime:0.24224090576172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.24230885505676 / seconds
Query Executed:select id FROM `wy` where city='Meriden' && SIC_code='6021'DB:business_master_new
loadtime:0.2426769733429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midwest' limit 1
loadtime:0.24272799491882 / seconds
Query Executed:select id FROM `wy` where city='Midwest' && SIC_code='6021'DB:business_master_new
loadtime:0.24342083930969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills' limit 1
loadtime:0.24347281455994 / seconds
Query Executed:select id FROM `wy` where city='Mills' && SIC_code='6021'DB:business_master_new
loadtime:0.24656891822815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorcroft' limit 1
loadtime:0.24662184715271 / seconds
Query Executed:select id FROM `wy` where city='Moorcroft' && SIC_code='6021'DB:business_master_new
loadtime:0.24878692626953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moose' limit 1
loadtime:0.24885201454163 / seconds
Query Executed:select id FROM `wy` where city='Moose' && SIC_code='6021'DB:business_master_new
loadtime:0.25114488601685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moran' limit 1
loadtime:0.2511990070343 / seconds
Query Executed:select id FROM `wy` where city='Moran' && SIC_code='6021'DB:business_master_new
loadtime:0.25216102600098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain View' limit 1
loadtime:0.25221395492554 / seconds
Query Executed:select id FROM `wy` where city='Mountain View' && SIC_code='6021'DB:business_master_new
loadtime:0.25402998924255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Natrona' limit 1
loadtime:0.25409984588623 / seconds
Query Executed:select id FROM `wy` where city='Natrona' && SIC_code='6021'DB:business_master_new
loadtime:0.25448703765869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcastle' limit 1
loadtime:0.25453901290894 / seconds
Query Executed:select id FROM `wy` where city='Newcastle' && SIC_code='6021'DB:business_master_new
loadtime:0.25918483734131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opal' limit 1
loadtime:0.2592499256134 / seconds
Query Executed:select id FROM `wy` where city='Opal' && SIC_code='6021'DB:business_master_new
loadtime:0.25965690612793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osage' limit 1
loadtime:0.25970983505249 / seconds
Query Executed:select id FROM `wy` where city='Osage' && SIC_code='6021'DB:business_master_new
loadtime:0.26023697853088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oshoto' limit 1
loadtime:0.26028895378113 / seconds
Query Executed:select id FROM `wy` where city='Oshoto' && SIC_code='6021'DB:business_master_new
loadtime:0.26061487197876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otto' limit 1
loadtime:0.26066589355469 / seconds
Query Executed:select id FROM `wy` where city='Otto' && SIC_code='6021'DB:business_master_new
loadtime:0.26109004020691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkman' limit 1
loadtime:0.26114201545715 / seconds
Query Executed:select id FROM `wy` where city='Parkman' && SIC_code='6021'DB:business_master_new
loadtime:0.26160788536072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pavillion' limit 1
loadtime:0.26165795326233 / seconds
Query Executed:select id FROM `wy` where city='Pavillion' && SIC_code='6021'DB:business_master_new
loadtime:0.2627580165863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Bluffs' limit 1
loadtime:0.26280903816223 / seconds
Query Executed:select id FROM `wy` where city='Pine Bluffs' && SIC_code='6021'DB:business_master_new
loadtime:0.26489591598511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Haven' limit 1
loadtime:0.26496386528015 / seconds
Query Executed:select id FROM `wy` where city='Pine Haven' && SIC_code='6021'DB:business_master_new
loadtime:0.26533699035645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:0.26539087295532 / seconds
Query Executed:select id FROM `wy` where city='Pinedale' && SIC_code='6021'DB:business_master_new
loadtime:0.26766490936279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Of Rocks' limit 1
loadtime:0.26773190498352 / seconds
Query Executed:select id FROM `wy` where city='Point Of Rocks' && SIC_code='6021'DB:business_master_new
loadtime:0.26822400093079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powder River' limit 1
loadtime:0.26827788352966 / seconds
Query Executed:select id FROM `wy` where city='Powder River' && SIC_code='6021'DB:business_master_new
loadtime:0.26872491836548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powell' limit 1
loadtime:0.26877593994141 / seconds
Query Executed:select id FROM `wy` where city='Powell' && SIC_code='6021'DB:business_master_new
loadtime:0.27104997634888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralston' limit 1
loadtime:0.27112293243408 / seconds
Query Executed:select id FROM `wy` where city='Ralston' && SIC_code='6021'DB:business_master_new
loadtime:0.27163982391357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranchester' limit 1
loadtime:0.27169299125671 / seconds
Query Executed:select id FROM `wy` where city='Ranchester' && SIC_code='6021'DB:business_master_new
loadtime:0.27305889129639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rawlins' limit 1
loadtime:0.27312397956848 / seconds
Query Executed:select id FROM `wy` where city='Rawlins' && SIC_code='6021'DB:business_master_new
loadtime:0.2754168510437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Recluse' limit 1
loadtime:0.27548885345459 / seconds
Query Executed:select id FROM `wy` where city='Recluse' && SIC_code='6021'DB:business_master_new
loadtime:0.2759838104248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reliance' limit 1
loadtime:0.27603793144226 / seconds
Query Executed:select id FROM `wy` where city='Reliance' && SIC_code='6021'DB:business_master_new
loadtime:0.27668190002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.27673292160034 / seconds
Query Executed:select id FROM `wy` where city='Riverton' && SIC_code='6021'DB:business_master_new
loadtime:0.2790060043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robertson' limit 1
loadtime:0.27908802032471 / seconds
Query Executed:select id FROM `wy` where city='Robertson' && SIC_code='6021'DB:business_master_new
loadtime:0.27947902679443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock River' limit 1
loadtime:0.27953100204468 / seconds
Query Executed:select id FROM `wy` where city='Rock River' && SIC_code='6021'DB:business_master_new
loadtime:0.28021001815796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Springs' limit 1
loadtime:0.2802619934082 / seconds
Query Executed:select id FROM `wy` where city='Rock Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.28255987167358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolling Hills' limit 1
loadtime:0.28263783454895 / seconds
Query Executed:select id FROM `wy` where city='Rolling Hills' && SIC_code='6021'DB:business_master_new
loadtime:0.28306484222412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rozet' limit 1
loadtime:0.28311991691589 / seconds
Query Executed:select id FROM `wy` where city='Rozet' && SIC_code='6021'DB:business_master_new
loadtime:0.28389692306519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddlestring' limit 1
loadtime:0.28394794464111 / seconds
Query Executed:select id FROM `wy` where city='Saddlestring' && SIC_code='6021'DB:business_master_new
loadtime:0.28427290916443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens' limit 1
loadtime:0.28432488441467 / seconds
Query Executed:select id FROM `wy` where city='Saint Stephens' && SIC_code='6021'DB:business_master_new
loadtime:0.28473687171936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga' limit 1
loadtime:0.28478598594666 / seconds
Query Executed:select id FROM `wy` where city='Saratoga' && SIC_code='6021'DB:business_master_new
loadtime:0.28788900375366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Savery' limit 1
loadtime:0.28795790672302 / seconds
Query Executed:select id FROM `wy` where city='Savery' && SIC_code='6021'DB:business_master_new
loadtime:0.28850102424622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawnee' limit 1
loadtime:0.28855395317078 / seconds
Query Executed:select id FROM `wy` where city='Shawnee' && SIC_code='6021'DB:business_master_new
loadtime:0.28899693489075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shell' limit 1
loadtime:0.28905487060547 / seconds
Query Executed:select id FROM `wy` where city='Shell' && SIC_code='6021'DB:business_master_new
loadtime:0.28976392745972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheridan' limit 1
loadtime:0.28981494903564 / seconds
Query Executed:select id FROM `wy` where city='Sheridan' && SIC_code='6021'DB:business_master_new
loadtime:0.29209780693054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shirley Basin' limit 1
loadtime:0.29217481613159 / seconds
Query Executed:select id FROM `wy` where city='Shirley Basin' && SIC_code='6021'DB:business_master_new
loadtime:0.29255986213684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoshoni' limit 1
loadtime:0.29261302947998 / seconds
Query Executed:select id FROM `wy` where city='Shoshoni' && SIC_code='6021'DB:business_master_new
loadtime:0.29413890838623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sinclair' limit 1
loadtime:0.29420590400696 / seconds
Query Executed:select id FROM `wy` where city='Sinclair' && SIC_code='6021'DB:business_master_new
loadtime:0.29482793807983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smoot' limit 1
loadtime:0.2948899269104 / seconds
Query Executed:select id FROM `wy` where city='Smoot' && SIC_code='6021'DB:business_master_new
loadtime:0.29535984992981 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Pass City' limit 1
loadtime:0.29541182518005 / seconds
Query Executed:select id FROM `wy` where city='South Pass City' && SIC_code='6021'DB:business_master_new
loadtime:0.29574084281921 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Stephens' limit 1
loadtime:0.29579281806946 / seconds
Query Executed:select id FROM `wy` where city='St Stephens' && SIC_code='6021'DB:business_master_new
loadtime:0.29615592956543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Story' limit 1
loadtime:0.29620790481567 / seconds
Query Executed:select id FROM `wy` where city='Story' && SIC_code='6021'DB:business_master_new
loadtime:0.2972629070282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sundance' limit 1
loadtime:0.29731488227844 / seconds
Query Executed:select id FROM `wy` where city='Sundance' && SIC_code='6021'DB:business_master_new
loadtime:0.29995799064636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.30002284049988 / seconds
Query Executed:select id FROM `wy` where city='Superior' && SIC_code='6021'DB:business_master_new
loadtime:0.3005678653717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ten Sleep' limit 1
loadtime:0.30062103271484 / seconds
Query Executed:select id FROM `wy` where city='Ten Sleep' && SIC_code='6021'DB:business_master_new
loadtime:0.30231690406799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teton Village' limit 1
loadtime:0.30238199234009 / seconds
Query Executed:select id FROM `wy` where city='Teton Village' && SIC_code='6021'DB:business_master_new
loadtime:0.30377388000488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thayne' limit 1
loadtime:0.30383896827698 / seconds
Query Executed:select id FROM `wy` where city='Thayne' && SIC_code='6021'DB:business_master_new
loadtime:0.30618500709534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thermopolis' limit 1
loadtime:0.30625200271606 / seconds
Query Executed:select id FROM `wy` where city='Thermopolis' && SIC_code='6021'DB:business_master_new
loadtime:0.31127285957336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tie Siding' limit 1
loadtime:0.31133985519409 / seconds
Query Executed:select id FROM `wy` where city='Tie Siding' && SIC_code='6021'DB:business_master_new
loadtime:0.31178188323975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.31183481216431 / seconds
Query Executed:select id FROM `wy` where city='Torrington' && SIC_code='6021'DB:business_master_new
loadtime:0.31412196159363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upton' limit 1
loadtime:0.3141918182373 / seconds
Query Executed:select id FROM `wy` where city='Upton' && SIC_code='6021'DB:business_master_new
loadtime:0.31579804420471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Van Tassell' limit 1
loadtime:0.31586289405823 / seconds
Query Executed:select id FROM `wy` where city='Van Tassell' && SIC_code='6021'DB:business_master_new
loadtime:0.31624388694763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veteran' limit 1
loadtime:0.31629681587219 / seconds
Query Executed:select id FROM `wy` where city='Veteran' && SIC_code='6021'DB:business_master_new
loadtime:0.31673097610474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walcott' limit 1
loadtime:0.31678104400635 / seconds
Query Executed:select id FROM `wy` where city='Walcott' && SIC_code='6021'DB:business_master_new
loadtime:0.31715798377991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wamsutter' limit 1
loadtime:0.31720995903015 / seconds
Query Executed:select id FROM `wy` where city='Wamsutter' && SIC_code='6021'DB:business_master_new
loadtime:0.31832981109619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wapiti' limit 1
loadtime:0.31838202476501 / seconds
Query Executed:select id FROM `wy` where city='Wapiti' && SIC_code='6021'DB:business_master_new
loadtime:0.3189959526062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.31905388832092 / seconds
Query Executed:select id FROM `wy` where city='Weston' && SIC_code='6021'DB:business_master_new
loadtime:0.3195538520813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheatland' limit 1
loadtime:0.31960391998291 / seconds
Query Executed:select id FROM `wy` where city='Wheatland' && SIC_code='6021'DB:business_master_new
loadtime:0.32554292678833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:0.32561683654785 / seconds
Query Executed:select id FROM `wy` where city='Wilson' && SIC_code='6021'DB:business_master_new
loadtime:0.32837891578674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolf' limit 1
loadtime:0.32844686508179 / seconds
Query Executed:select id FROM `wy` where city='Wolf' && SIC_code='6021'DB:business_master_new
loadtime:0.32886004447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Worland' limit 1
loadtime:0.32892203330994 / seconds
Query Executed:select id FROM `wy` where city='Worland' && SIC_code='6021'DB:business_master_new
loadtime:0.33121681213379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wright' limit 1
loadtime:0.33128881454468 / seconds
Query Executed:select id FROM `wy` where city='Wright' && SIC_code='6021'DB:business_master_new
loadtime:0.33275985717773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyarno' limit 1
loadtime:0.33281302452087 / seconds
Query Executed:select id FROM `wy` where city='Wyarno' && SIC_code='6021'DB:business_master_new
loadtime:0.33329296112061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yellowstn Ntl Pk' limit 1
loadtime:0.33334493637085 / seconds
Query Executed:select id FROM `wy` where city='Yellowstn Ntl Pk' && SIC_code='6021'DB:business_master_new
loadtime:0.33378481864929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yellowstone National Park' limit 1
loadtime:0.33383584022522 / seconds
Query Executed:select id FROM `wy` where city='Yellowstone National Park' && SIC_code='6021'DB:business_master_new
loadtime:0.33479404449463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yoder' limit 1
loadtime:0.33484482765198 / seconds
Query Executed:select id FROM `wy` where city='Yoder' && SIC_code='6021'DB:business_master_new
loadtime:0.33569192886353 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.3358359336853 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.33622193336487 / seconds
Operation template executed (chunk cache operation)
loadtime:0.33638381958008 / seconds
template override:Default
loadtime:0.33642387390137 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.33782696723938 / seconds
Template Constructed, Array Rows:49
loadtime:0.33835887908936 / seconds
TOTAL EXECUTION TIME: 0.33793
loadtime:0.33963298797607 / 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] => national-commercial-banks [stateURLid] => wyoming )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.3396430015564
TOTAL KEY ARRAYS: 69