Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.8902969360352E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018270015716553 / seconds
host not found setting manual db connection
loadtime:0.0098710060119629 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010124921798706 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010308027267456 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010379791259766 / seconds
zipcode:
loadtime:0.010408878326416 / seconds
Query Executed:select * from search_referrer where page_hash='5a747366a7e106866ad724a02b8fd532' limit 10 DB:ezrox_toadli
loadtime:0.010636806488037 / seconds
Operation header executed (non global)
loadtime:0.01066780090332 / seconds
Operation leaderboard executed (non global)
loadtime:0.010718822479248 / seconds
Operation square executed (non global)
loadtime:0.010748863220215 / seconds
Operation square_bottom executed (non global)
loadtime:0.010775804519653 / seconds
Operation smallsquare executed (non global)
loadtime:0.010801792144775 / seconds
Operation headeradright executed (non global)
loadtime:0.010828018188477 / seconds
Operation google_analytics executed (non global)
loadtime:0.010852813720703 / seconds
Operation topstories executed (non global)
loadtime:0.010877847671509 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010905027389526 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010929822921753 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011173963546753 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011346817016602 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011384010314941 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011443853378296 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011497020721436 / seconds
Template key: archive_menu pushed
loadtime:0.011507987976074 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011523008346558 / seconds
Template key: get_gravatar pushed
loadtime:0.011529922485352 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011538982391357 / seconds
*10)-10)+1 | start:0
loadtime:0.011581897735596 / seconds
Query loaded from cache:select * from categories where cat_URLid='hotels-and-motels'
loadtime:0.011626005172729 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.011664867401123 / seconds
DB connected to localhost business_master_new
loadtime:0.011928796768188 / seconds
Query Executed:select * from `az_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.021215915679932 / seconds
Query stored in cache : _QUERY_www.toadli.com38b319568acac0aab281d284e0e205ea
loadtime:0.022390842437744 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.022441864013672 / seconds
Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='7011'DB:business_master_new
loadtime:0.024044990539551 / seconds
Query stored in cache : _QUERY_www.toadli.com54d52afb764b3df94cb08206f2fa6a0f
loadtime:0.024081945419312 / seconds
287 / 11
loadtime:0.024138927459717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1
loadtime:0.024204015731812 / seconds
Query Executed:select id FROM `az` where city='Aguila' && SIC_code='7011'DB:business_master_new
loadtime:0.030515909194946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1
loadtime:0.030589818954468 / seconds
Query Executed:select id FROM `az` where city='Ajo' && SIC_code='7011'DB:business_master_new
loadtime:0.034993886947632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.035064935684204 / seconds
Query Executed:select id FROM `az` where city='Alpine' && SIC_code='7011'DB:business_master_new
loadtime:0.036110877990723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1
loadtime:0.036181926727295 / seconds
Query Executed:select id FROM `az` where city='Amado' && SIC_code='7011'DB:business_master_new
loadtime:0.037088871002197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1
loadtime:0.037158012390137 / seconds
Query Executed:select id FROM `az` where city='Anthem' && SIC_code='7011'DB:business_master_new
loadtime:0.037823915481567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1
loadtime:0.037877798080444 / seconds
Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='7011'DB:business_master_new
loadtime:0.045715808868408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1
loadtime:0.045781850814819 / seconds
Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='7011'DB:business_master_new
loadtime:0.046624898910522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1
loadtime:0.046679019927979 / seconds
Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='7011'DB:business_master_new
loadtime:0.047624826431274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.047677993774414 / seconds
Query Executed:select id FROM `az` where city='Arlington' && SIC_code='7011'DB:business_master_new
loadtime:0.048415899276733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1
loadtime:0.048468828201294 / seconds
Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='7011'DB:business_master_new
loadtime:0.049504995346069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.049570798873901 / seconds
Query Executed:select id FROM `az` where city='Avondale' && SIC_code='7011'DB:business_master_new
loadtime:0.060531854629517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1
loadtime:0.060586929321289 / seconds
Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='7011'DB:business_master_new
loadtime:0.061682939529419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1
loadtime:0.061734914779663 / seconds
Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='7011'DB:business_master_new
loadtime:0.062202930450439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1
loadtime:0.062252998352051 / seconds
Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='7011'DB:business_master_new
loadtime:0.062970876693726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.06303596496582 / seconds
Query Executed:select id FROM `az` where city='Benson' && SIC_code='7011'DB:business_master_new
loadtime:0.069589853286743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1
loadtime:0.069665908813477 / seconds
Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='7011'DB:business_master_new
loadtime:0.077072858810425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1
loadtime:0.077171802520752 / seconds
Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='7011'DB:business_master_new
loadtime:0.079725980758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1
loadtime:0.079793930053711 / seconds
Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='7011'DB:business_master_new
loadtime:0.080294847488403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1
loadtime:0.08035683631897 / seconds
Query Executed:select id FROM `az` where city='Blue' && SIC_code='7011'DB:business_master_new
loadtime:0.080883026123047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1
loadtime:0.080935001373291 / seconds
Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='7011'DB:business_master_new
loadtime:0.081431865692139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1
loadtime:0.081485986709595 / seconds
Query Executed:select id FROM `az` where city='Bouse' && SIC_code='7011'DB:business_master_new
loadtime:0.082266807556152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1
loadtime:0.082342863082886 / seconds
Query Executed:select id FROM `az` where city='Bowie' && SIC_code='7011'DB:business_master_new
loadtime:0.083236932754517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.083290815353394 / seconds
Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='7011'DB:business_master_new
loadtime:0.091404914855957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1
loadtime:0.091472864151001 / seconds
Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='7011'DB:business_master_new
loadtime:0.10579180717468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1
loadtime:0.10589289665222 / seconds
Query Executed:select id FROM `az` where city='Bylas' && SIC_code='7011'DB:business_master_new
loadtime:0.10649585723877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.10655188560486 / seconds
Query Executed:select id FROM `az` where city='Cameron' && SIC_code='7011'DB:business_master_new
loadtime:0.10722780227661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1
loadtime:0.10729193687439 / seconds
Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='7011'DB:business_master_new
loadtime:0.1144278049469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1
loadtime:0.11450791358948 / seconds
Query Executed:select id FROM `az` where city='Carefree' && SIC_code='7011'DB:business_master_new
loadtime:0.12173795700073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1
loadtime:0.1218318939209 / seconds
Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='7011'DB:business_master_new
loadtime:0.12986898422241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1
loadtime:0.12994194030762 / seconds
Query Executed:select id FROM `az` where city='Cashion' && SIC_code='7011'DB:business_master_new
loadtime:0.13082385063171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1
loadtime:0.13087892532349 / seconds
Query Executed:select id FROM `az` where city='Catalina' && SIC_code='7011'DB:business_master_new
loadtime:0.13177180290222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1
loadtime:0.13182401657104 / seconds
Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.14541792869568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.14550185203552 / seconds
Query Executed:select id FROM `az` where city='Central' && SIC_code='7011'DB:business_master_new
loadtime:0.14616394042969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1
loadtime:0.14621686935425 / seconds
Query Executed:select id FROM `az` where city='Chambers' && SIC_code='7011'DB:business_master_new
loadtime:0.14696383476257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1
loadtime:0.1470320224762 / seconds
Query Executed:select id FROM `az` where city='Chandler' && SIC_code='7011'DB:business_master_new
loadtime:0.16081190109253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1
loadtime:0.16092085838318 / seconds
Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='7011'DB:business_master_new
loadtime:0.16166400909424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1
loadtime:0.16172099113464 / seconds
Query Executed:select id FROM `az` where city='Chinle' && SIC_code='7011'DB:business_master_new
loadtime:0.16546988487244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1
loadtime:0.16554999351501 / seconds
Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.17375993728638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1
loadtime:0.17383289337158 / seconds
Query Executed:select id FROM `az` where city='Chloride' && SIC_code='7011'DB:business_master_new
loadtime:0.17447185516357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1
loadtime:0.17454099655151 / seconds
Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='7011'DB:business_master_new
loadtime:0.17505788803101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1
loadtime:0.17511081695557 / seconds
Query Executed:select id FROM `az` where city='Cibola' && SIC_code='7011'DB:business_master_new
loadtime:0.17566800117493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1
loadtime:0.17571997642517 / seconds
Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='7011'DB:business_master_new
loadtime:0.17863893508911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1
loadtime:0.17870497703552 / seconds
Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.17930197715759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1
loadtime:0.17936491966248 / seconds
Query Executed:select id FROM `az` where city='Claypool' && SIC_code='7011'DB:business_master_new
loadtime:0.18067288398743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.18072700500488 / seconds
Query Executed:select id FROM `az` where city='Clifton' && SIC_code='7011'DB:business_master_new
loadtime:0.18213295936584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1
loadtime:0.18219780921936 / seconds
Query Executed:select id FROM `az` where city='Cochise' && SIC_code='7011'DB:business_master_new
loadtime:0.18317484855652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.18324279785156 / seconds
Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='7011'DB:business_master_new
loadtime:0.18501782417297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1
loadtime:0.18507099151611 / seconds
Query Executed:select id FROM `az` where city='Concho' && SIC_code='7011'DB:business_master_new
loadtime:0.18587779998779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1
loadtime:0.18593096733093 / seconds
Query Executed:select id FROM `az` where city='Congress' && SIC_code='7011'DB:business_master_new
loadtime:0.18692183494568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:0.18698787689209 / seconds
Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='7011'DB:business_master_new
loadtime:0.18999600410461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1
loadtime:0.19005179405212 / seconds
Query Executed:select id FROM `az` where city='Cornville' && SIC_code='7011'DB:business_master_new
loadtime:0.19304585456848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1
loadtime:0.19311094284058 / seconds
Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='7011'DB:business_master_new
loadtime:0.19415187835693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.19420599937439 / seconds
Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='7011'DB:business_master_new
loadtime:0.20780301094055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1
loadtime:0.2078800201416 / seconds
Query Executed:select id FROM `az` where city='Crown King' && SIC_code='7011'DB:business_master_new
loadtime:0.20845890045166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1
loadtime:0.20853185653687 / seconds
Query Executed:select id FROM `az` where city='Dateland' && SIC_code='7011'DB:business_master_new
loadtime:0.20909094810486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1
loadtime:0.20914387702942 / seconds
Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='7011'DB:business_master_new
loadtime:0.20971202850342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1
loadtime:0.20976495742798 / seconds
Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='7011'DB:business_master_new
loadtime:0.21033596992493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1
loadtime:0.21038794517517 / seconds
Query Executed:select id FROM `az` where city='Dewey' && SIC_code='7011'DB:business_master_new
loadtime:0.214439868927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1
loadtime:0.21451091766357 / seconds
Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.21548080444336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.21555280685425 / seconds
Query Executed:select id FROM `az` where city='Douglas' && SIC_code='7011'DB:business_master_new
loadtime:0.22308683395386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1
loadtime:0.22316288948059 / seconds
Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='7011'DB:business_master_new
loadtime:0.22382783889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.22390079498291 / seconds
Query Executed:select id FROM `az` where city='Duncan' && SIC_code='7011'DB:business_master_new
loadtime:0.22526884078979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1
loadtime:0.22534680366516 / seconds
Query Executed:select id FROM `az` where city='Eagar' && SIC_code='7011'DB:business_master_new
loadtime:0.22871088981628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.22877788543701 / seconds
Query Executed:select id FROM `az` where city='Eden' && SIC_code='7011'DB:business_master_new
loadtime:0.22925186157227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1
loadtime:0.22930598258972 / seconds
Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='7011'DB:business_master_new
loadtime:0.23067188262939 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1
loadtime:0.23074197769165 / seconds
Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='7011'DB:business_master_new
loadtime:0.2358558177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1
loadtime:0.23591184616089 / seconds
Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='7011'DB:business_master_new
loadtime:0.23726892471313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.23734593391418 / seconds
Query Executed:select id FROM `az` where city='Elgin' && SIC_code='7011'DB:business_master_new
loadtime:0.23803782463074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1
loadtime:0.23809099197388 / seconds
Query Executed:select id FROM `az` where city='Eloy' && SIC_code='7011'DB:business_master_new
loadtime:0.23958587646484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1
loadtime:0.2396388053894 / seconds
Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='7011'DB:business_master_new
loadtime:0.25332593917847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.25349998474121 / seconds
Query Executed:select id FROM `az` where city='Florence' && SIC_code='7011'DB:business_master_new
loadtime:0.25484299659729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1
loadtime:0.25490379333496 / seconds
Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='7011'DB:business_master_new
loadtime:0.25556302070618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1
loadtime:0.25563097000122 / seconds
Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='7011'DB:business_master_new
loadtime:0.25613379478455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.25618696212769 / seconds
Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='7011'DB:business_master_new
loadtime:0.25869584083557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1
loadtime:0.25875091552734 / seconds
Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='7011'DB:business_master_new
loadtime:0.26142001152039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1
loadtime:0.26149082183838 / seconds
Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='7011'DB:business_master_new
loadtime:0.26226997375488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1
loadtime:0.26234602928162 / seconds
Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='7011'DB:business_master_new
loadtime:0.2682249546051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1
loadtime:0.26829600334167 / seconds
Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='7011'DB:business_master_new
loadtime:0.2690589427948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1
loadtime:0.26911401748657 / seconds
Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='7011'DB:business_master_new
loadtime:0.28390502929688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:0.28398394584656 / seconds
Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='7011'DB:business_master_new
loadtime:0.28540897369385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.28547883033752 / seconds
Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='7011'DB:business_master_new
loadtime:0.28596687316895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1
loadtime:0.2860209941864 / seconds
Query Executed:select id FROM `az` where city='Ganado' && SIC_code='7011'DB:business_master_new
loadtime:0.28729891777039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1
loadtime:0.28736090660095 / seconds
Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='7011'DB:business_master_new
loadtime:0.290198802948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.29027390480042 / seconds
Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='7011'DB:business_master_new
loadtime:0.30358791351318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.30365800857544 / seconds
Query Executed:select id FROM `az` where city='Glendale' && SIC_code='7011'DB:business_master_new
loadtime:0.31663489341736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1
loadtime:0.31671380996704 / seconds
Query Executed:select id FROM `az` where city='Globe' && SIC_code='7011'DB:business_master_new
loadtime:0.32556581497192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1
loadtime:0.32565379142761 / seconds
Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.32907891273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1
loadtime:0.32913589477539 / seconds
Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='7011'DB:business_master_new
loadtime:0.33995890617371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1
loadtime:0.34004187583923 / seconds
Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='7011'DB:business_master_new
loadtime:0.34275984764099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1
loadtime:0.34283590316772 / seconds
Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='7011'DB:business_master_new
loadtime:0.34333992004395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:0.34340596199036 / seconds
Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.35158681869507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1
loadtime:0.35166001319885 / seconds
Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='7011'DB:business_master_new
loadtime:0.35216379165649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.35221695899963 / seconds
Query Executed:select id FROM `az` where city='Greer' && SIC_code='7011'DB:business_master_new
loadtime:0.353276014328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1
loadtime:0.35337901115417 / seconds
Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='7011'DB:business_master_new
loadtime:0.35396790504456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1
loadtime:0.35402393341064 / seconds
Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='7011'DB:business_master_new
loadtime:0.35451197624207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1
loadtime:0.35456585884094 / seconds
Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='7011'DB:business_master_new
loadtime:0.3552839756012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.35535883903503 / seconds
Query Executed:select id FROM `az` where city='Hayden' && SIC_code='7011'DB:business_master_new
loadtime:0.35632681846619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1
loadtime:0.35638093948364 / seconds
Query Executed:select id FROM `az` where city='Heber' && SIC_code='7011'DB:business_master_new
loadtime:0.35732293128967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:0.35738897323608 / seconds
Query Executed:select id FROM `az` where city='Hereford' && SIC_code='7011'DB:business_master_new
loadtime:0.36124897003174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1
loadtime:0.3613338470459 / seconds
Query Executed:select id FROM `az` where city='Higley' && SIC_code='7011'DB:business_master_new
loadtime:0.36597681045532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:0.36603283882141 / seconds
Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='7011'DB:business_master_new
loadtime:0.37051200866699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1
loadtime:0.37059879302979 / seconds
Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='7011'DB:business_master_new
loadtime:0.37113785743713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1
loadtime:0.37119293212891 / seconds
Query Executed:select id FROM `az` where city='Houck' && SIC_code='7011'DB:business_master_new
loadtime:0.37183380126953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1
loadtime:0.37188792228699 / seconds
Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='7011'DB:business_master_new
loadtime:0.37533092498779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1
loadtime:0.37539601325989 / seconds
Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='7011'DB:business_master_new
loadtime:0.37593984603882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.37599182128906 / seconds
Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='7011'DB:business_master_new
loadtime:0.37701082229614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1
loadtime:0.37706398963928 / seconds
Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='7011'DB:business_master_new
loadtime:0.37761688232422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1
loadtime:0.37766790390015 / seconds
Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.37815189361572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:0.37820482254028 / seconds
Query Executed:select id FROM `az` where city='Jerome' && SIC_code='7011'DB:business_master_new
loadtime:0.37988996505737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1
loadtime:0.37996292114258 / seconds
Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='7011'DB:business_master_new
loadtime:0.38088297843933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1
loadtime:0.38093781471252 / seconds
Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='7011'DB:business_master_new
loadtime:0.38153195381165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1
loadtime:0.38158488273621 / seconds
Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='7011'DB:business_master_new
loadtime:0.38210082054138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1
loadtime:0.38215184211731 / seconds
Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='7011'DB:business_master_new
loadtime:0.38476300239563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1
loadtime:0.38483595848083 / seconds
Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='7011'DB:business_master_new
loadtime:0.38572382926941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:0.38577890396118 / seconds
Query Executed:select id FROM `az` where city='Kearny' && SIC_code='7011'DB:business_master_new
loadtime:0.38659882545471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:0.38666486740112 / seconds
Query Executed:select id FROM `az` where city='Kingman' && SIC_code='7011'DB:business_master_new
loadtime:0.40618586540222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:0.4062979221344 / seconds
Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='7011'DB:business_master_new
loadtime:0.40720391273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1
loadtime:0.40726184844971 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='7011'DB:business_master_new
loadtime:0.40805792808533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1
loadtime:0.4081118106842 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='7011'DB:business_master_new
loadtime:0.40867185592651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1
loadtime:0.40872693061829 / seconds
Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='7011'DB:business_master_new
loadtime:0.42235684394836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1
loadtime:0.42245984077454 / seconds
Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='7011'DB:business_master_new
loadtime:0.42318296432495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.42325091362 / seconds
Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='7011'DB:business_master_new
loadtime:0.42797780036926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1
loadtime:0.42805480957031 / seconds
Query Executed:select id FROM `az` where city='Laveen' && SIC_code='7011'DB:business_master_new
loadtime:0.43221187591553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1
loadtime:0.43226790428162 / seconds
Query Executed:select id FROM `az` where city='Leupp' && SIC_code='7011'DB:business_master_new
loadtime:0.43290400505066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1
loadtime:0.4329559803009 / seconds
Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='7011'DB:business_master_new
loadtime:0.43935298919678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1
loadtime:0.43942093849182 / seconds
Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='7011'DB:business_master_new
loadtime:0.44029402732849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1
loadtime:0.44036793708801 / seconds
Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='7011'DB:business_master_new
loadtime:0.44092488288879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1
loadtime:0.44097995758057 / seconds
Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='7011'DB:business_master_new
loadtime:0.44184184074402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1
loadtime:0.44189500808716 / seconds
Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='7011'DB:business_master_new
loadtime:0.44247984886169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:0.442538022995 / seconds
Query Executed:select id FROM `az` where city='Lupton' && SIC_code='7011'DB:business_master_new
loadtime:0.44329786300659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1
loadtime:0.44337391853333 / seconds
Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='7011'DB:business_master_new
loadtime:0.44383502006531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:0.44388794898987 / seconds
Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='7011'DB:business_master_new
loadtime:0.44449996948242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1
loadtime:0.44455289840698 / seconds
Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='7011'DB:business_master_new
loadtime:0.44515895843506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1
loadtime:0.44520783424377 / seconds
Query Executed:select id FROM `az` where city='Marana' && SIC_code='7011'DB:business_master_new
loadtime:0.45041298866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1
loadtime:0.4504828453064 / seconds
Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='7011'DB:business_master_new
loadtime:0.45109701156616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1
loadtime:0.45116591453552 / seconds
Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='7011'DB:business_master_new
loadtime:0.45389080047607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1
loadtime:0.45394587516785 / seconds
Query Executed:select id FROM `az` where city='Mayer' && SIC_code='7011'DB:business_master_new
loadtime:0.45715999603271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1
loadtime:0.45722889900208 / seconds
Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='7011'DB:business_master_new
loadtime:0.45771598815918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1
loadtime:0.45777082443237 / seconds
Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='7011'DB:business_master_new
loadtime:0.45858693122864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1
loadtime:0.4586398601532 / seconds
Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='7011'DB:business_master_new
loadtime:0.45923280715942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1
loadtime:0.4592969417572 / seconds
Query Executed:select id FROM `az` where city='Meadview' && SIC_code='7011'DB:business_master_new
loadtime:0.4601719379425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:0.46023988723755 / seconds
Query Executed:select id FROM `az` where city='Mesa' && SIC_code='7011'DB:business_master_new
loadtime:0.47348880767822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.47366881370544 / seconds
Query Executed:select id FROM `az` where city='Miami' && SIC_code='7011'DB:business_master_new
loadtime:0.47685384750366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1
loadtime:0.47692680358887 / seconds
Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.48096299171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:0.48101782798767 / seconds
Query Executed:select id FROM `az` where city='Morenci' && SIC_code='7011'DB:business_master_new
loadtime:0.48212099075317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1
loadtime:0.48218488693237 / seconds
Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.48280501365662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.48287200927734 / seconds
Query Executed:select id FROM `az` where city='Morristown' && SIC_code='7011'DB:business_master_new
loadtime:0.48386788368225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1
loadtime:0.48393201828003 / seconds
Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='7011'DB:business_master_new
loadtime:0.48459386825562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1
loadtime:0.48466300964355 / seconds
Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='7011'DB:business_master_new
loadtime:0.48515200614929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1
loadtime:0.48520493507385 / seconds
Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='7011'DB:business_master_new
loadtime:0.48627185821533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1
loadtime:0.48634481430054 / seconds
Query Executed:select id FROM `az` where city='Naco' && SIC_code='7011'DB:business_master_new
loadtime:0.48708987236023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1
loadtime:0.48714399337769 / seconds
Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='7011'DB:business_master_new
loadtime:0.48766684532166 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:0.48772192001343 / seconds
Query Executed:select id FROM `az` where city='New River' && SIC_code='7011'DB:business_master_new
loadtime:0.49069094657898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1
loadtime:0.49074387550354 / seconds
Query Executed:select id FROM `az` where city='Nogales' && SIC_code='7011'DB:business_master_new
loadtime:0.50619697570801 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1
loadtime:0.50628280639648 / seconds
Query Executed:select id FROM `az` where city='North Rim' && SIC_code='7011'DB:business_master_new
loadtime:0.5068519115448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1
loadtime:0.50691890716553 / seconds
Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='7011'DB:business_master_new
loadtime:0.50757884979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1
loadtime:0.50764584541321 / seconds
Query Executed:select id FROM `az` where city='Oatman' && SIC_code='7011'DB:business_master_new
loadtime:0.50851392745972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1
loadtime:0.50858592987061 / seconds
Query Executed:select id FROM `az` where city='Oracle' && SIC_code='7011'DB:business_master_new
loadtime:0.50956583023071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1
loadtime:0.50962090492249 / seconds
Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.51113080978394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1
loadtime:0.51118397712708 / seconds
Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='7011'DB:business_master_new
loadtime:0.51254487037659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:0.51261401176453 / seconds
Query Executed:select id FROM `az` where city='Page' && SIC_code='7011'DB:business_master_new
loadtime:0.51891279220581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1
loadtime:0.51900291442871 / seconds
Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='7011'DB:business_master_new
loadtime:0.51962494850159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1
loadtime:0.51968097686768 / seconds
Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.53298997879028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.53308486938477 / seconds
Query Executed:select id FROM `az` where city='Parker' && SIC_code='7011'DB:business_master_new
loadtime:0.54182195663452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1
loadtime:0.54191589355469 / seconds
Query Executed:select id FROM `az` where city='Parks' && SIC_code='7011'DB:business_master_new
loadtime:0.54274988174438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1
loadtime:0.54280686378479 / seconds
Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='7011'DB:business_master_new
loadtime:0.54323887825012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1
loadtime:0.54328989982605 / seconds
Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='7011'DB:business_master_new
loadtime:0.5445659160614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1
loadtime:0.54463601112366 / seconds
Query Executed:select id FROM `az` where city='Paulden' && SIC_code='7011'DB:business_master_new
loadtime:0.54593896865845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.54599189758301 / seconds
Query Executed:select id FROM `az` where city='Payson' && SIC_code='7011'DB:business_master_new
loadtime:0.56230497360229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1
loadtime:0.5624098777771 / seconds
Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='7011'DB:business_master_new
loadtime:0.56338000297546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1
loadtime:0.56345391273499 / seconds
Query Executed:select id FROM `az` where city='Pearce' && SIC_code='7011'DB:business_master_new
loadtime:0.56551384925842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1
loadtime:0.56558680534363 / seconds
Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.56609487533569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1
loadtime:0.56614899635315 / seconds
Query Executed:select id FROM `az` where city='Peoria' && SIC_code='7011'DB:business_master_new
loadtime:0.57982683181763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1
loadtime:0.57991099357605 / seconds
Query Executed:select id FROM `az` where city='Peridot' && SIC_code='7011'DB:business_master_new
loadtime:0.5806679725647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1
loadtime:0.58072280883789 / seconds
Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='7011'DB:business_master_new
loadtime:0.581218957901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1
loadtime:0.58127093315125 / seconds
Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='7011'DB:business_master_new
loadtime:0.58183598518372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:0.58188796043396 / seconds
Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='7011'DB:business_master_new
loadtime:0.59496784210205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.59537696838379 / seconds
Query Executed:select id FROM `az` where city='Picacho' && SIC_code='7011'DB:business_master_new
loadtime:0.59597682952881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1
loadtime:0.59605097770691 / seconds
Query Executed:select id FROM `az` where city='Pima' && SIC_code='7011'DB:business_master_new
loadtime:0.59769892692566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:0.5977509021759 / seconds
Query Executed:select id FROM `az` where city='Pine' && SIC_code='7011'DB:business_master_new
loadtime:0.60005784034729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:0.60012698173523 / seconds
Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='7011'DB:business_master_new
loadtime:0.60071492195129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1
loadtime:0.60076999664307 / seconds
Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='7011'DB:business_master_new
loadtime:0.6053478717804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.60543298721313 / seconds
Query Executed:select id FROM `az` where city='Pinon' && SIC_code='7011'DB:business_master_new
loadtime:0.60614395141602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1
loadtime:0.6061999797821 / seconds
Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='7011'DB:business_master_new
loadtime:0.60685086250305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1
loadtime:0.60690379142761 / seconds
Query Executed:select id FROM `az` where city='Polacca' && SIC_code='7011'DB:business_master_new
loadtime:0.60758781433105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1
loadtime:0.60764193534851 / seconds
Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='7011'DB:business_master_new
loadtime:0.60818791389465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1
loadtime:0.60823893547058 / seconds
Query Executed:select id FROM `az` where city='Portal' && SIC_code='7011'DB:business_master_new
loadtime:0.60879683494568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1
loadtime:0.60884881019592 / seconds
Query Executed:select id FROM `az` where city='Poston' && SIC_code='7011'DB:business_master_new
loadtime:0.60956287384033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:0.60961699485779 / seconds
Query Executed:select id FROM `az` where city='Prescott' && SIC_code='7011'DB:business_master_new
loadtime:0.62257885932922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1
loadtime:0.62271499633789 / seconds
Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.6380569934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1
loadtime:0.63813591003418 / seconds
Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='7011'DB:business_master_new
loadtime:0.64302492141724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1
loadtime:0.64309501647949 / seconds
Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='7011'DB:business_master_new
loadtime:0.65102100372314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1
loadtime:0.65107488632202 / seconds
Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.65170288085938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1
loadtime:0.65175700187683 / seconds
Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.65240097045898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1
loadtime:0.65245485305786 / seconds
Query Executed:select id FROM `az` where city='Rillito' && SIC_code='7011'DB:business_master_new
loadtime:0.6531867980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1
loadtime:0.65323901176453 / seconds
Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='7011'DB:business_master_new
loadtime:0.6546778678894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1
loadtime:0.65474486351013 / seconds
Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='7011'DB:business_master_new
loadtime:0.65901184082031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1
loadtime:0.65907692909241 / seconds
Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='7011'DB:business_master_new
loadtime:0.66004085540771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1
loadtime:0.66009497642517 / seconds
Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='7011'DB:business_master_new
loadtime:0.660728931427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1
loadtime:0.66078281402588 / seconds
Query Executed:select id FROM `az` where city='Roll' && SIC_code='7011'DB:business_master_new
loadtime:0.66149592399597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.66154885292053 / seconds
Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='7011'DB:business_master_new
loadtime:0.66248202323914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1
loadtime:0.66255497932434 / seconds
Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.66307282447815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1
loadtime:0.66312599182129 / seconds
Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='7011'DB:business_master_new
loadtime:0.66390681266785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:0.66395902633667 / seconds
Query Executed:select id FROM `az` where city='Safford' && SIC_code='7011'DB:business_master_new
loadtime:0.67311596870422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1
loadtime:0.67319297790527 / seconds
Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='7011'DB:business_master_new
loadtime:0.67657995223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1
loadtime:0.67664790153503 / seconds
Query Executed:select id FROM `az` where city='Saint David' && SIC_code='7011'DB:business_master_new
loadtime:0.67790794372559 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:0.6779727935791 / seconds
Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='7011'DB:business_master_new
loadtime:0.68168997764587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1
loadtime:0.68175792694092 / seconds
Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='7011'DB:business_master_new
loadtime:0.68251395225525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1
loadtime:0.68258500099182 / seconds
Query Executed:select id FROM `az` where city='Salome' && SIC_code='7011'DB:business_master_new
loadtime:0.68537187576294 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1
loadtime:0.68544292449951 / seconds
Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='7011'DB:business_master_new
loadtime:0.68715190887451 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:0.68721985816956 / seconds
Query Executed:select id FROM `az` where city='San Luis' && SIC_code='7011'DB:business_master_new
loadtime:0.68873596191406 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1
loadtime:0.68878984451294 / seconds
Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='7011'DB:business_master_new
loadtime:0.68971681594849 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1
loadtime:0.68976998329163 / seconds
Query Executed:select id FROM `az` where city='San Simon' && SIC_code='7011'DB:business_master_new
loadtime:0.69082188606262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1
loadtime:0.69088983535767 / seconds
Query Executed:select id FROM `az` where city='Sanders' && SIC_code='7011'DB:business_master_new
loadtime:0.69259285926819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1
loadtime:0.6926589012146 / seconds
Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='7011'DB:business_master_new
loadtime:0.69336795806885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1
loadtime:0.69343280792236 / seconds
Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='7011'DB:business_master_new
loadtime:0.7070620059967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1
loadtime:0.70728492736816 / seconds
Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='7011'DB:business_master_new
loadtime:0.70809888839722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1
loadtime:0.70817589759827 / seconds
Query Executed:select id FROM `az` where city='Sedona' && SIC_code='7011'DB:business_master_new
loadtime:0.7302098274231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1
loadtime:0.730388879776 / seconds
Query Executed:select id FROM `az` where city='Seligman' && SIC_code='7011'DB:business_master_new
loadtime:0.73183679580688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1
loadtime:0.73192191123962 / seconds
Query Executed:select id FROM `az` where city='Sells' && SIC_code='7011'DB:business_master_new
loadtime:0.73401188850403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1
loadtime:0.7340669631958 / seconds
Query Executed:select id FROM `az` where city='Shonto' && SIC_code='7011'DB:business_master_new
loadtime:0.73467302322388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1
loadtime:0.73472499847412 / seconds
Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='7011'DB:business_master_new
loadtime:0.73520493507385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1
loadtime:0.7352569103241 / seconds
Query Executed:select id FROM `az` where city='Show Low' && SIC_code='7011'DB:business_master_new
loadtime:0.74486994743347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1
loadtime:0.74494886398315 / seconds
Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='7011'DB:business_master_new
loadtime:0.76605701446533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1
loadtime:0.7661509513855 / seconds
Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.76697683334351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1
loadtime:0.76704502105713 / seconds
Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='7011'DB:business_master_new
loadtime:0.77106189727783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:0.77112984657288 / seconds
Query Executed:select id FROM `az` where city='Solomon' && SIC_code='7011'DB:business_master_new
loadtime:0.77179002761841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1
loadtime:0.77184391021729 / seconds
Query Executed:select id FROM `az` where city='Somerton' && SIC_code='7011'DB:business_master_new
loadtime:0.77329897880554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1
loadtime:0.77336096763611 / seconds
Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='7011'DB:business_master_new
loadtime:0.77492094039917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1
loadtime:0.7749879360199 / seconds
Query Executed:select id FROM `az` where city='Springerville' && SIC_code='7011'DB:business_master_new
loadtime:0.77895283699036 / seconds
Query loaded from cache:select * from geodata_geocity where city='St David' limit 1
loadtime:0.77902793884277 / seconds
Query Executed:select id FROM `az` where city='St David' && SIC_code='7011'DB:business_master_new
loadtime:0.77949786186218 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:0.77955293655396 / seconds
Query Executed:select id FROM `az` where city='St Johns' && SIC_code='7011'DB:business_master_new
loadtime:0.78005790710449 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1
loadtime:0.78010988235474 / seconds
Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='7011'DB:business_master_new
loadtime:0.78075790405273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:0.78082299232483 / seconds
Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='7011'DB:business_master_new
loadtime:0.78157496452332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1
loadtime:0.78162884712219 / seconds
Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='7011'DB:business_master_new
loadtime:0.78225994110107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:0.78233885765076 / seconds
Query Executed:select id FROM `az` where city='Sun City' && SIC_code='7011'DB:business_master_new
loadtime:0.79483389854431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1
loadtime:0.79488897323608 / seconds
Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='7011'DB:business_master_new
loadtime:0.80163097381592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1
loadtime:0.80169796943665 / seconds
Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='7011'DB:business_master_new
loadtime:0.80225396156311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1
loadtime:0.80230593681335 / seconds
Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='7011'DB:business_master_new
loadtime:0.80286002159119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1
loadtime:0.80292582511902 / seconds
Query Executed:select id FROM `az` where city='Supai' && SIC_code='7011'DB:business_master_new
loadtime:0.80352401733398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.80357789993286 / seconds
Query Executed:select id FROM `az` where city='Superior' && SIC_code='7011'DB:business_master_new
loadtime:0.80439782142639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1
loadtime:0.80445098876953 / seconds
Query Executed:select id FROM `az` where city='Surprise' && SIC_code='7011'DB:business_master_new
loadtime:0.81827402114868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1
loadtime:0.818354845047 / seconds
Query Executed:select id FROM `az` where city='Tacna' && SIC_code='7011'DB:business_master_new
loadtime:0.81905198097229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:0.81910681724548 / seconds
Query Executed:select id FROM `az` where city='Taylor' && SIC_code='7011'DB:business_master_new
loadtime:0.82050395011902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1
loadtime:0.82057094573975 / seconds
Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='7011'DB:business_master_new
loadtime:0.82135200500488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1
loadtime:0.82140493392944 / seconds
Query Executed:select id FROM `az` where city='Tempe' && SIC_code='7011'DB:business_master_new
loadtime:0.83516788482666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1
loadtime:0.83534002304077 / seconds
Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='7011'DB:business_master_new
loadtime:0.83596897125244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1
loadtime:0.83602786064148 / seconds
Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='7011'DB:business_master_new
loadtime:0.83960390090942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1
loadtime:0.83967089653015 / seconds
Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='7011'DB:business_master_new
loadtime:0.84518980979919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1
loadtime:0.84525799751282 / seconds
Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='7011'DB:business_master_new
loadtime:0.84973788261414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1
loadtime:0.84983491897583 / seconds
Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='7011'DB:business_master_new
loadtime:0.85044884681702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1
loadtime:0.85050988197327 / seconds
Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='7011'DB:business_master_new
loadtime:0.85182285308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1
loadtime:0.85188794136047 / seconds
Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='7011'DB:business_master_new
loadtime:0.8533079624176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1
loadtime:0.85338687896729 / seconds
Query Executed:select id FROM `az` where city='Topawa' && SIC_code='7011'DB:business_master_new
loadtime:0.85388398170471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1
loadtime:0.85393786430359 / seconds
Query Executed:select id FROM `az` where city='Topock' && SIC_code='7011'DB:business_master_new
loadtime:0.85503101348877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1
loadtime:0.85508394241333 / seconds
Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='7011'DB:business_master_new
loadtime:0.85560894012451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1
loadtime:0.85566282272339 / seconds
Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='7011'DB:business_master_new
loadtime:0.85628294944763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1
loadtime:0.85634398460388 / seconds
Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='7011'DB:business_master_new
loadtime:0.85856199264526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1
loadtime:0.85862994194031 / seconds
Query Executed:select id FROM `az` where city='Tubac' && SIC_code='7011'DB:business_master_new
loadtime:0.86021685600281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1
loadtime:0.86028480529785 / seconds
Query Executed:select id FROM `az` where city='Tucson' && SIC_code='7011'DB:business_master_new
loadtime:0.8735020160675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1
loadtime:0.87383794784546 / seconds
Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='7011'DB:business_master_new
loadtime:0.87480282783508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.87488698959351 / seconds
Query Executed:select id FROM `az` where city='Vail' && SIC_code='7011'DB:business_master_new
loadtime:0.87744688987732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1
loadtime:0.87751793861389 / seconds
Query Executed:select id FROM `az` where city='Valentine' && SIC_code='7011'DB:business_master_new
loadtime:0.87800192832947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1
loadtime:0.8780529499054 / seconds
Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='7011'DB:business_master_new
loadtime:0.87856984138489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.87862396240234 / seconds
Query Executed:select id FROM `az` where city='Vernon' && SIC_code='7011'DB:business_master_new
loadtime:0.8794219493866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1
loadtime:0.87949299812317 / seconds
Query Executed:select id FROM `az` where city='Waddell' && SIC_code='7011'DB:business_master_new
loadtime:0.88259387016296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1
loadtime:0.88264894485474 / seconds
Query Executed:select id FROM `az` where city='Wellton' && SIC_code='7011'DB:business_master_new
loadtime:0.8835768699646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1
loadtime:0.88362979888916 / seconds
Query Executed:select id FROM `az` where city='Wenden' && SIC_code='7011'DB:business_master_new
loadtime:0.88433694839478 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1
loadtime:0.88439083099365 / seconds
Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.88493180274963 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1
loadtime:0.88498401641846 / seconds
Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.88546180725098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1
loadtime:0.88551902770996 / seconds
Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='7011'DB:business_master_new
loadtime:0.88656497001648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Why' limit 1
loadtime:0.88661694526672 / seconds
Query Executed:select id FROM `az` where city='Why' && SIC_code='7011'DB:business_master_new
loadtime:0.88708400726318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1
loadtime:0.88713502883911 / seconds
Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='7011'DB:business_master_new
loadtime:0.89458584785461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1
loadtime:0.89466691017151 / seconds
Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='7011'DB:business_master_new
loadtime:0.89534687995911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1
loadtime:0.89540100097656 / seconds
Query Executed:select id FROM `az` where city='Willcox' && SIC_code='7011'DB:business_master_new
loadtime:0.90196490287781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.90204286575317 / seconds
Query Executed:select id FROM `az` where city='Williams' && SIC_code='7011'DB:business_master_new
loadtime:0.90701079368591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1
loadtime:0.90712094306946 / seconds
Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='7011'DB:business_master_new
loadtime:0.90768980979919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1
loadtime:0.9077479839325 / seconds
Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='7011'DB:business_master_new
loadtime:0.9125669002533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1
loadtime:0.91263389587402 / seconds
Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='7011'DB:business_master_new
loadtime:0.91368293762207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:0.91373801231384 / seconds
Query Executed:select id FROM `az` where city='Winslow' && SIC_code='7011'DB:business_master_new
loadtime:0.91958284378052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1
loadtime:0.91966700553894 / seconds
Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='7011'DB:business_master_new
loadtime:0.92075300216675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.92080879211426 / seconds
Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='7011'DB:business_master_new
loadtime:0.92135095596313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1
loadtime:0.92140579223633 / seconds
Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='7011'DB:business_master_new
loadtime:0.92235088348389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Young' limit 1
loadtime:0.92241597175598 / seconds
Query Executed:select id FROM `az` where city='Young' && SIC_code='7011'DB:business_master_new
loadtime:0.92341089248657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1
loadtime:0.9234778881073 / seconds
Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='7011'DB:business_master_new
loadtime:0.9258599281311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1
loadtime:0.92592787742615 / seconds
Query Executed:select id FROM `az` where city='Yucca' && SIC_code='7011'DB:business_master_new
loadtime:0.92655992507935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:0.92661499977112 / seconds
Query Executed:select id FROM `az` where city='Yuma' && SIC_code='7011'DB:business_master_new
loadtime:0.9446918964386 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.94486379623413 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.94527387619019 / seconds
Operation template executed (chunk cache operation)
loadtime:0.94545698165894 / seconds
template override:Default
loadtime:0.94550585746765 / 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.94678282737732 / seconds
Template Constructed, Array Rows:49
loadtime:0.94731283187866 / seconds
TOTAL EXECUTION TIME: 0.94687
loadtime:0.9489848613739 / 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] => hotels-and-motels [stateURLid] => arizona )


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