DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.413459777832E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018219947814941 / seconds
host not found setting manual db connection
loadtime:0.0098590850830078 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010135173797607 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010313034057617 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010375022888184 / seconds
zipcode:
loadtime:0.010406017303467 / seconds
Query Executed:select * from search_referrer where page_hash='c315b0182f6f9fe972aefd1a06dc1b6d' limit 10 DB:ezrox_toadli
loadtime:0.010637044906616 / seconds
Operation header executed (non global)
loadtime:0.010666131973267 / seconds
Operation leaderboard executed (non global)
loadtime:0.010718107223511 / seconds
Operation square executed (non global)
loadtime:0.010746955871582 / seconds
Operation square_bottom executed (non global)
loadtime:0.010775089263916 / seconds
Operation smallsquare executed (non global)
loadtime:0.010800123214722 / seconds
Operation headeradright executed (non global)
loadtime:0.010825157165527 / seconds
Operation google_analytics executed (non global)
loadtime:0.010849952697754 / seconds
Operation topstories executed (non global)
loadtime:0.01087498664856 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010900974273682 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010926008224487 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01115608215332 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011337041854858 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011378049850464 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011437177658081 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.01148509979248 / seconds
Template key: archive_menu pushed
loadtime:0.011495113372803 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.01150918006897 / seconds
Template key: get_gravatar pushed
loadtime:0.011516094207764 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.01152515411377 / seconds
*10)-10)+1 | start:0
loadtime:0.011567115783691 / seconds
DB connected to localhost business_master_new
loadtime:0.011837959289551 / seconds
Query Executed:select * from categories where cat_URLid='bands-orchestras-actors-and-other-entertainers-entertainment-groups'DB:business_master_new
loadtime:0.012837171554565 / seconds
Query stored in cache : _QUERY_www.toadli.comc2519c04d1f8baeae44699a7477451c2
loadtime:0.012907981872559 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.012959957122803 / seconds
Query Executed:select * from `az_catmap` where sic='7929' order by city ascDB:business_master_new
loadtime:0.14477300643921 / seconds
Query stored in cache : _QUERY_www.toadli.comb001c57bb4d3a02fb437f4026bea9dde
loadtime:0.14595699310303 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.14600896835327 / seconds
Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='7929'DB:business_master_new
loadtime:0.14770007133484 / seconds
Query stored in cache : _QUERY_www.toadli.comda1eee4fae600f3a2039fac461d329f6
loadtime:0.14773511886597 / seconds
287 / 11
loadtime:0.14779996871948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1
loadtime:0.14786815643311 / seconds
Query Executed:select id FROM `az` where city='Aguila' && SIC_code='7929'DB:business_master_new
loadtime:0.15588808059692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1
loadtime:0.15594410896301 / seconds
Query Executed:select id FROM `az` where city='Ajo' && SIC_code='7929'DB:business_master_new
loadtime:0.15894317626953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.15899801254272 / seconds
Query Executed:select id FROM `az` where city='Alpine' && SIC_code='7929'DB:business_master_new
loadtime:0.16006016731262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1
loadtime:0.1601231098175 / seconds
Query Executed:select id FROM `az` where city='Amado' && SIC_code='7929'DB:business_master_new
loadtime:0.16104817390442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1
loadtime:0.16110897064209 / seconds
Query Executed:select id FROM `az` where city='Anthem' && SIC_code='7929'DB:business_master_new
loadtime:0.16178607940674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1
loadtime:0.16183805465698 / seconds
Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='7929'DB:business_master_new
loadtime:0.16613006591797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1
loadtime:0.16618299484253 / seconds
Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='7929'DB:business_master_new
loadtime:0.16703200340271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1
loadtime:0.16708397865295 / seconds
Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='7929'DB:business_master_new
loadtime:0.16805601119995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.1681170463562 / seconds
Query Executed:select id FROM `az` where city='Arlington' && SIC_code='7929'DB:business_master_new
loadtime:0.16887497901917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1
loadtime:0.1689281463623 / seconds
Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='7929'DB:business_master_new
loadtime:0.16998100280762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.17003297805786 / seconds
Query Executed:select id FROM `az` where city='Avondale' && SIC_code='7929'DB:business_master_new
loadtime:0.17401003837585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1
loadtime:0.17406296730042 / seconds
Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='7929'DB:business_master_new
loadtime:0.17504715919495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1
loadtime:0.17510795593262 / seconds
Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='7929'DB:business_master_new
loadtime:0.17561316490173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1
loadtime:0.17566514015198 / seconds
Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='7929'DB:business_master_new
loadtime:0.17640399932861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.17645716667175 / seconds
Query Executed:select id FROM `az` where city='Benson' && SIC_code='7929'DB:business_master_new
loadtime:0.18042397499084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1
loadtime:0.18049502372742 / seconds
Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='7929'DB:business_master_new
loadtime:0.184494972229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1
loadtime:0.18454909324646 / seconds
Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='7929'DB:business_master_new
loadtime:0.18647408485413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1
loadtime:0.18652701377869 / seconds
Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='7929'DB:business_master_new
loadtime:0.18705606460571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1
loadtime:0.18711805343628 / seconds
Query Executed:select id FROM `az` where city='Blue' && SIC_code='7929'DB:business_master_new
loadtime:0.18767499923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1
loadtime:0.1877269744873 / seconds
Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='7929'DB:business_master_new
loadtime:0.18825197219849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1
loadtime:0.18831014633179 / seconds
Query Executed:select id FROM `az` where city='Bouse' && SIC_code='7929'DB:business_master_new
loadtime:0.18912196159363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1
loadtime:0.18917417526245 / seconds
Query Executed:select id FROM `az` where city='Bowie' && SIC_code='7929'DB:business_master_new
loadtime:0.1900839805603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.19014501571655 / seconds
Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='7929'DB:business_master_new
loadtime:0.19412398338318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1
loadtime:0.19419503211975 / seconds
Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='7929'DB:business_master_new
loadtime:0.19815516471863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1
loadtime:0.1982250213623 / seconds
Query Executed:select id FROM `az` where city='Bylas' && SIC_code='7929'DB:business_master_new
loadtime:0.1988320350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.19888496398926 / seconds
Query Executed:select id FROM `az` where city='Cameron' && SIC_code='7929'DB:business_master_new
loadtime:0.19960308074951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1
loadtime:0.19965505599976 / seconds
Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='7929'DB:business_master_new
loadtime:0.20598697662354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1
loadtime:0.20604205131531 / seconds
Query Executed:select id FROM `az` where city='Carefree' && SIC_code='7929'DB:business_master_new
loadtime:0.20999097824097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1
loadtime:0.21005797386169 / seconds
Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='7929'DB:business_master_new
loadtime:0.2140851020813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1
loadtime:0.21414709091187 / seconds
Query Executed:select id FROM `az` where city='Cashion' && SIC_code='7929'DB:business_master_new
loadtime:0.21503615379333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1
loadtime:0.21509003639221 / seconds
Query Executed:select id FROM `az` where city='Catalina' && SIC_code='7929'DB:business_master_new
loadtime:0.21601104736328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1
loadtime:0.21607708930969 / seconds
Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='7929'DB:business_master_new
loadtime:0.22003507614136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.22011017799377 / seconds
Query Executed:select id FROM `az` where city='Central' && SIC_code='7929'DB:business_master_new
loadtime:0.22079515457153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1
loadtime:0.22084712982178 / seconds
Query Executed:select id FROM `az` where city='Chambers' && SIC_code='7929'DB:business_master_new
loadtime:0.22161817550659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1
loadtime:0.22167110443115 / seconds
Query Executed:select id FROM `az` where city='Chandler' && SIC_code='7929'DB:business_master_new
loadtime:0.22567796707153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1
loadtime:0.22576308250427 / seconds
Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='7929'DB:business_master_new
loadtime:0.2265260219574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1
loadtime:0.22658109664917 / seconds
Query Executed:select id FROM `az` where city='Chinle' && SIC_code='7929'DB:business_master_new
loadtime:0.2296359539032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1
loadtime:0.22968816757202 / seconds
Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.23364996910095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1
loadtime:0.23370313644409 / seconds
Query Executed:select id FROM `az` where city='Chloride' && SIC_code='7929'DB:business_master_new
loadtime:0.23437404632568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1
loadtime:0.23442602157593 / seconds
Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='7929'DB:business_master_new
loadtime:0.23496699333191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1
loadtime:0.23501801490784 / seconds
Query Executed:select id FROM `az` where city='Cibola' && SIC_code='7929'DB:business_master_new
loadtime:0.2356071472168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1
loadtime:0.23565912246704 / seconds
Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='7929'DB:business_master_new
loadtime:0.23794317245483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1
loadtime:0.23799610137939 / seconds
Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.23863506317139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1
loadtime:0.23868703842163 / seconds
Query Executed:select id FROM `az` where city='Claypool' && SIC_code='7929'DB:business_master_new
loadtime:0.24001312255859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.24006605148315 / seconds
Query Executed:select id FROM `az` where city='Clifton' && SIC_code='7929'DB:business_master_new
loadtime:0.24150800704956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1
loadtime:0.2415599822998 / seconds
Query Executed:select id FROM `az` where city='Cochise' && SIC_code='7929'DB:business_master_new
loadtime:0.24256014823914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.24261116981506 / seconds
Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='7929'DB:business_master_new
loadtime:0.2444121837616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1
loadtime:0.24446415901184 / seconds
Query Executed:select id FROM `az` where city='Concho' && SIC_code='7929'DB:business_master_new
loadtime:0.2453031539917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1
loadtime:0.24535608291626 / seconds
Query Executed:select id FROM `az` where city='Congress' && SIC_code='7929'DB:business_master_new
loadtime:0.24637317657471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:0.24642610549927 / seconds
Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='7929'DB:business_master_new
loadtime:0.2488009929657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1
loadtime:0.24885416030884 / seconds
Query Executed:select id FROM `az` where city='Cornville' && SIC_code='7929'DB:business_master_new
loadtime:0.25120210647583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1
loadtime:0.25125408172607 / seconds
Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='7929'DB:business_master_new
loadtime:0.25233197212219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.25238394737244 / seconds
Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='7929'DB:business_master_new
loadtime:0.25637817382812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1
loadtime:0.256432056427 / seconds
Query Executed:select id FROM `az` where city='Crown King' && SIC_code='7929'DB:business_master_new
loadtime:0.25702214241028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1
loadtime:0.25707316398621 / seconds
Query Executed:select id FROM `az` where city='Dateland' && SIC_code='7929'DB:business_master_new
loadtime:0.25767111778259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1
loadtime:0.25772309303284 / seconds
Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='7929'DB:business_master_new
loadtime:0.25832200050354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1
loadtime:0.25837397575378 / seconds
Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='7929'DB:business_master_new
loadtime:0.25897002220154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1
loadtime:0.25902009010315 / seconds
Query Executed:select id FROM `az` where city='Dewey' && SIC_code='7929'DB:business_master_new
loadtime:0.26242613792419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1
loadtime:0.26247906684875 / seconds
Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.2634871006012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.26354002952576 / seconds
Query Executed:select id FROM `az` where city='Douglas' && SIC_code='7929'DB:business_master_new
loadtime:0.27034211158752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1
loadtime:0.2704131603241 / seconds
Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='7929'DB:business_master_new
loadtime:0.27108907699585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.27116298675537 / seconds
Query Executed:select id FROM `az` where city='Duncan' && SIC_code='7929'DB:business_master_new
loadtime:0.27294206619263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1
loadtime:0.2729959487915 / seconds
Query Executed:select id FROM `az` where city='Eagar' && SIC_code='7929'DB:business_master_new
loadtime:0.27572011947632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.27577304840088 / seconds
Query Executed:select id FROM `az` where city='Eden' && SIC_code='7929'DB:business_master_new
loadtime:0.27629208564758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1
loadtime:0.27634501457214 / seconds
Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='7929'DB:business_master_new
loadtime:0.27804803848267 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1
loadtime:0.27811002731323 / seconds
Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='7929'DB:business_master_new
loadtime:0.28255105018616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1
loadtime:0.28260517120361 / seconds
Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='7929'DB:business_master_new
loadtime:0.28399705886841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.28404998779297 / seconds
Query Executed:select id FROM `az` where city='Elgin' && SIC_code='7929'DB:business_master_new
loadtime:0.28476810455322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1
loadtime:0.28482007980347 / seconds
Query Executed:select id FROM `az` where city='Eloy' && SIC_code='7929'DB:business_master_new
loadtime:0.28660798072815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1
loadtime:0.28665995597839 / seconds
Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='7929'DB:business_master_new
loadtime:0.29068803787231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.290766954422 / seconds
Query Executed:select id FROM `az` where city='Florence' && SIC_code='7929'DB:business_master_new
loadtime:0.2921290397644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1
loadtime:0.29218411445618 / seconds
Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='7929'DB:business_master_new
loadtime:0.29285717010498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1
loadtime:0.29290914535522 / seconds
Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='7929'DB:business_master_new
loadtime:0.29345798492432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.29351115226746 / seconds
Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='7929'DB:business_master_new
loadtime:0.29538798332214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1
loadtime:0.29543995857239 / seconds
Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='7929'DB:business_master_new
loadtime:0.29747009277344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1
loadtime:0.297523021698 / seconds
Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='7929'DB:business_master_new
loadtime:0.29834008216858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1
loadtime:0.29839205741882 / seconds
Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='7929'DB:business_master_new
loadtime:0.30359101295471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1
loadtime:0.30365896224976 / seconds
Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='7929'DB:business_master_new
loadtime:0.30445408821106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1
loadtime:0.30450797080994 / seconds
Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='7929'DB:business_master_new
loadtime:0.30847406387329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:0.3085470199585 / seconds
Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='7929'DB:business_master_new
loadtime:0.30996799468994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.3100221157074 / seconds
Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='7929'DB:business_master_new
loadtime:0.31054711341858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1
loadtime:0.31059908866882 / seconds
Query Executed:select id FROM `az` where city='Ganado' && SIC_code='7929'DB:business_master_new
loadtime:0.31235313415527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1
loadtime:0.31240606307983 / seconds
Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='7929'DB:business_master_new
loadtime:0.31456017494202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.31461310386658 / seconds
Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='7929'DB:business_master_new
loadtime:0.31860494613647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.31868195533752 / seconds
Query Executed:select id FROM `az` where city='Glendale' && SIC_code='7929'DB:business_master_new
loadtime:0.32267713546753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1
loadtime:0.32277202606201 / seconds
Query Executed:select id FROM `az` where city='Globe' && SIC_code='7929'DB:business_master_new
loadtime:0.32674717903137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1
loadtime:0.32680416107178 / seconds
Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.32960104942322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1
loadtime:0.32966303825378 / seconds
Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='7929'DB:business_master_new
loadtime:0.33363199234009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1
loadtime:0.33369898796082 / seconds
Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.33574604988098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1
loadtime:0.33581304550171 / seconds
Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='7929'DB:business_master_new
loadtime:0.33635711669922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:0.33641004562378 / seconds
Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.34035301208496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1
loadtime:0.34040498733521 / seconds
Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='7929'DB:business_master_new
loadtime:0.34093403816223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.34098505973816 / seconds
Query Executed:select id FROM `az` where city='Greer' && SIC_code='7929'DB:business_master_new
loadtime:0.34206104278564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1
loadtime:0.34212207794189 / seconds
Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='7929'DB:business_master_new
loadtime:0.34273815155029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1
loadtime:0.34279012680054 / seconds
Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='7929'DB:business_master_new
loadtime:0.34331011772156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1
loadtime:0.3433620929718 / seconds
Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='7929'DB:business_master_new
loadtime:0.34412097930908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.34417295455933 / seconds
Query Executed:select id FROM `az` where city='Hayden' && SIC_code='7929'DB:business_master_new
loadtime:0.34516096115112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1
loadtime:0.34521317481995 / seconds
Query Executed:select id FROM `az` where city='Heber' && SIC_code='7929'DB:business_master_new
loadtime:0.3461811542511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:0.34623408317566 / seconds
Query Executed:select id FROM `az` where city='Hereford' && SIC_code='7929'DB:business_master_new
loadtime:0.34936118125916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1
loadtime:0.34941506385803 / seconds
Query Executed:select id FROM `az` where city='Higley' && SIC_code='7929'DB:business_master_new
loadtime:0.35340213775635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:0.35347199440002 / seconds
Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='7929'DB:business_master_new
loadtime:0.35718512535095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1
loadtime:0.35723805427551 / seconds
Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='7929'DB:business_master_new
loadtime:0.35780811309814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1
loadtime:0.35786008834839 / seconds
Query Executed:select id FROM `az` where city='Houck' && SIC_code='7929'DB:business_master_new
loadtime:0.35852599143982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1
loadtime:0.35857915878296 / seconds
Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='7929'DB:business_master_new
loadtime:0.36135816574097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1
loadtime:0.3614239692688 / seconds
Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='7929'DB:business_master_new
loadtime:0.36198902130127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.3620400428772 / seconds
Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='7929'DB:business_master_new
loadtime:0.36308097839355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1
loadtime:0.36314511299133 / seconds
Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='7929'DB:business_master_new
loadtime:0.36371898651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1
loadtime:0.36377096176147 / seconds
Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.36431503295898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:0.36436796188354 / seconds
Query Executed:select id FROM `az` where city='Jerome' && SIC_code='7929'DB:business_master_new
loadtime:0.36605906486511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1
loadtime:0.36612105369568 / seconds
Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='7929'DB:business_master_new
loadtime:0.36705899238586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1
loadtime:0.3671190738678 / seconds
Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='7929'DB:business_master_new
loadtime:0.36774110794067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1
loadtime:0.3677921295166 / seconds
Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='7929'DB:business_master_new
loadtime:0.36835503578186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1
loadtime:0.36840796470642 / seconds
Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='7929'DB:business_master_new
loadtime:0.37035012245178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1
loadtime:0.37040305137634 / seconds
Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.37131214141846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:0.37136507034302 / seconds
Query Executed:select id FROM `az` where city='Kearny' && SIC_code='7929'DB:business_master_new
loadtime:0.37219905853271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:0.37225198745728 / seconds
Query Executed:select id FROM `az` where city='Kingman' && SIC_code='7929'DB:business_master_new
loadtime:0.3762640953064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:0.37633609771729 / seconds
Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='7929'DB:business_master_new
loadtime:0.3772439956665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1
loadtime:0.37730312347412 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='7929'DB:business_master_new
loadtime:0.37812113761902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1
loadtime:0.37817311286926 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='7929'DB:business_master_new
loadtime:0.37874317169189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1
loadtime:0.37879514694214 / seconds
Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='7929'DB:business_master_new
loadtime:0.38274717330933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1
loadtime:0.38281798362732 / seconds
Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='7929'DB:business_master_new
loadtime:0.38356614112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.38362002372742 / seconds
Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='7929'DB:business_master_new
loadtime:0.38757395744324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1
loadtime:0.38762712478638 / seconds
Query Executed:select id FROM `az` where city='Laveen' && SIC_code='7929'DB:business_master_new
loadtime:0.39115500450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1
loadtime:0.39122200012207 / seconds
Query Executed:select id FROM `az` where city='Leupp' && SIC_code='7929'DB:business_master_new
loadtime:0.39187407493591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1
loadtime:0.39192795753479 / seconds
Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='7929'DB:business_master_new
loadtime:0.39765501022339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1
loadtime:0.39772295951843 / seconds
Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='7929'DB:business_master_new
loadtime:0.39863395690918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1
loadtime:0.39868712425232 / seconds
Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='7929'DB:business_master_new
loadtime:0.39928007125854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1
loadtime:0.39933395385742 / seconds
Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='7929'DB:business_master_new
loadtime:0.40021800994873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1
loadtime:0.4002730846405 / seconds
Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='7929'DB:business_master_new
loadtime:0.40088200569153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:0.40093302726746 / seconds
Query Executed:select id FROM `az` where city='Lupton' && SIC_code='7929'DB:business_master_new
loadtime:0.40173411369324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1
loadtime:0.4017870426178 / seconds
Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.40228414535522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:0.40233612060547 / seconds
Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='7929'DB:business_master_new
loadtime:0.40296101570129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1
loadtime:0.40301203727722 / seconds
Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='7929'DB:business_master_new
loadtime:0.4036660194397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1
loadtime:0.40371799468994 / seconds
Query Executed:select id FROM `az` where city='Marana' && SIC_code='7929'DB:business_master_new
loadtime:0.40822815895081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1
loadtime:0.40830397605896 / seconds
Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.40894508361816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1
loadtime:0.40899801254272 / seconds
Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='7929'DB:business_master_new
loadtime:0.41109204292297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1
loadtime:0.41115212440491 / seconds
Query Executed:select id FROM `az` where city='Mayer' && SIC_code='7929'DB:business_master_new
loadtime:0.41374206542969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1
loadtime:0.41379499435425 / seconds
Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='7929'DB:business_master_new
loadtime:0.41433811187744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1
loadtime:0.41439008712769 / seconds
Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='7929'DB:business_master_new
loadtime:0.41522908210754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1
loadtime:0.41528701782227 / seconds
Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='7929'DB:business_master_new
loadtime:0.41591215133667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1
loadtime:0.4159631729126 / seconds
Query Executed:select id FROM `az` where city='Meadview' && SIC_code='7929'DB:business_master_new
loadtime:0.41686701774597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:0.41691899299622 / seconds
Query Executed:select id FROM `az` where city='Mesa' && SIC_code='7929'DB:business_master_new
loadtime:0.42095518112183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.42105913162231 / seconds
Query Executed:select id FROM `az` where city='Miami' && SIC_code='7929'DB:business_master_new
loadtime:0.42359805107117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1
loadtime:0.42365503311157 / seconds
Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.42706108093262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:0.42712306976318 / seconds
Query Executed:select id FROM `az` where city='Morenci' && SIC_code='7929'DB:business_master_new
loadtime:0.42825412750244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1
loadtime:0.42831110954285 / seconds
Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='7929'DB:business_master_new
loadtime:0.42894601821899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.42899608612061 / seconds
Query Executed:select id FROM `az` where city='Morristown' && SIC_code='7929'DB:business_master_new
loadtime:0.43001413345337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1
loadtime:0.43006610870361 / seconds
Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='7929'DB:business_master_new
loadtime:0.43076300621033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1
loadtime:0.43081498146057 / seconds
Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='7929'DB:business_master_new
loadtime:0.43134999275208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1
loadtime:0.43140411376953 / seconds
Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='7929'DB:business_master_new
loadtime:0.43249416351318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1
loadtime:0.43254613876343 / seconds
Query Executed:select id FROM `az` where city='Naco' && SIC_code='7929'DB:business_master_new
loadtime:0.43333411216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1
loadtime:0.43338704109192 / seconds
Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='7929'DB:business_master_new
loadtime:0.43392300605774 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:0.43397402763367 / seconds
Query Executed:select id FROM `az` where city='New River' && SIC_code='7929'DB:business_master_new
loadtime:0.43634295463562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1
loadtime:0.43640899658203 / seconds
Query Executed:select id FROM `az` where city='Nogales' && SIC_code='7929'DB:business_master_new
loadtime:0.44039106369019 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1
loadtime:0.44044399261475 / seconds
Query Executed:select id FROM `az` where city='North Rim' && SIC_code='7929'DB:business_master_new
loadtime:0.44101595878601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1
loadtime:0.44106698036194 / seconds
Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='7929'DB:business_master_new
loadtime:0.44174695014954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1
loadtime:0.44179916381836 / seconds
Query Executed:select id FROM `az` where city='Oatman' && SIC_code='7929'DB:business_master_new
loadtime:0.44269299507141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1
loadtime:0.44274497032166 / seconds
Query Executed:select id FROM `az` where city='Oracle' && SIC_code='7929'DB:business_master_new
loadtime:0.4437530040741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1
loadtime:0.44380497932434 / seconds
Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.44536018371582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1
loadtime:0.4454140663147 / seconds
Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='7929'DB:business_master_new
loadtime:0.4467921257019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:0.44684505462646 / seconds
Query Executed:select id FROM `az` where city='Page' && SIC_code='7929'DB:business_master_new
loadtime:0.45233798027039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1
loadtime:0.45239210128784 / seconds
Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='7929'DB:business_master_new
loadtime:0.45303106307983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1
loadtime:0.45308208465576 / seconds
Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.45705914497375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.45713710784912 / seconds
Query Executed:select id FROM `az` where city='Parker' && SIC_code='7929'DB:business_master_new
loadtime:0.4610960483551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1
loadtime:0.46115612983704 / seconds
Query Executed:select id FROM `az` where city='Parks' && SIC_code='7929'DB:business_master_new
loadtime:0.46200203895569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1
loadtime:0.46205496788025 / seconds
Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='7929'DB:business_master_new
loadtime:0.46252608299255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1
loadtime:0.4625780582428 / seconds
Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='7929'DB:business_master_new
loadtime:0.46384596824646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1
loadtime:0.46389818191528 / seconds
Query Executed:select id FROM `az` where city='Paulden' && SIC_code='7929'DB:business_master_new
loadtime:0.46523714065552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.46529412269592 / seconds
Query Executed:select id FROM `az` where city='Payson' && SIC_code='7929'DB:business_master_new
loadtime:0.46922397613525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1
loadtime:0.46928215026855 / seconds
Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.47026014328003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1
loadtime:0.47031903266907 / seconds
Query Executed:select id FROM `az` where city='Pearce' && SIC_code='7929'DB:business_master_new
loadtime:0.47238898277283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1
loadtime:0.47244215011597 / seconds
Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.4729790687561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1
loadtime:0.47303104400635 / seconds
Query Executed:select id FROM `az` where city='Peoria' && SIC_code='7929'DB:business_master_new
loadtime:0.47723197937012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1
loadtime:0.47731614112854 / seconds
Query Executed:select id FROM `az` where city='Peridot' && SIC_code='7929'DB:business_master_new
loadtime:0.47809314727783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1
loadtime:0.47815608978271 / seconds
Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='7929'DB:business_master_new
loadtime:0.47868895530701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1
loadtime:0.47874116897583 / seconds
Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='7929'DB:business_master_new
loadtime:0.47933602333069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:0.47938895225525 / seconds
Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='7929'DB:business_master_new
loadtime:0.48346209526062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.4837110042572 / seconds
Query Executed:select id FROM `az` where city='Picacho' && SIC_code='7929'DB:business_master_new
loadtime:0.48434901237488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1
loadtime:0.48441505432129 / seconds
Query Executed:select id FROM `az` where city='Pima' && SIC_code='7929'DB:business_master_new
loadtime:0.48608803749084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:0.48614907264709 / seconds
Query Executed:select id FROM `az` where city='Pine' && SIC_code='7929'DB:business_master_new
loadtime:0.48848509788513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:0.48853802680969 / seconds
Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='7929'DB:business_master_new
loadtime:0.48914909362793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1
loadtime:0.48920202255249 / seconds
Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='7929'DB:business_master_new
loadtime:0.49298214912415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.49303507804871 / seconds
Query Executed:select id FROM `az` where city='Pinon' && SIC_code='7929'DB:business_master_new
loadtime:0.49379396438599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1
loadtime:0.49384617805481 / seconds
Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='7929'DB:business_master_new
loadtime:0.49452900886536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1
loadtime:0.4945809841156 / seconds
Query Executed:select id FROM `az` where city='Polacca' && SIC_code='7929'DB:business_master_new
loadtime:0.49531698226929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1
loadtime:0.49537014961243 / seconds
Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='7929'DB:business_master_new
loadtime:0.49594807624817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1
loadtime:0.4959990978241 / seconds
Query Executed:select id FROM `az` where city='Portal' && SIC_code='7929'DB:business_master_new
loadtime:0.49658799171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1
loadtime:0.49663996696472 / seconds
Query Executed:select id FROM `az` where city='Poston' && SIC_code='7929'DB:business_master_new
loadtime:0.49739503860474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:0.49744701385498 / seconds
Query Executed:select id FROM `az` where city='Prescott' && SIC_code='7929'DB:business_master_new
loadtime:0.50143814086914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1
loadtime:0.50151014328003 / seconds
Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.50552296638489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1
loadtime:0.50559306144714 / seconds
Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='7929'DB:business_master_new
loadtime:0.50976610183716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1
loadtime:0.50982117652893 / seconds
Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='7929'DB:business_master_new
loadtime:0.51385307312012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1
loadtime:0.51392316818237 / seconds
Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='7929'DB:business_master_new
loadtime:0.51458311080933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1
loadtime:0.5146369934082 / seconds
Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.51533198356628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1
loadtime:0.51538515090942 / seconds
Query Executed:select id FROM `az` where city='Rillito' && SIC_code='7929'DB:business_master_new
loadtime:0.51615500450134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1
loadtime:0.51620602607727 / seconds
Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='7929'DB:business_master_new
loadtime:0.51802396774292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1
loadtime:0.51807713508606 / seconds
Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='7929'DB:business_master_new
loadtime:0.52168798446655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1
loadtime:0.52174115180969 / seconds
Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='7929'DB:business_master_new
loadtime:0.52274703979492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1
loadtime:0.52279901504517 / seconds
Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='7929'DB:business_master_new
loadtime:0.52346396446228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1
loadtime:0.52351713180542 / seconds
Query Executed:select id FROM `az` where city='Roll' && SIC_code='7929'DB:business_master_new
loadtime:0.52426505088806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.52432107925415 / seconds
Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='7929'DB:business_master_new
loadtime:0.5252890586853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1
loadtime:0.52534198760986 / seconds
Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='7929'DB:business_master_new
loadtime:0.52588796615601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1
loadtime:0.52593803405762 / seconds
Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='7929'DB:business_master_new
loadtime:0.52676105499268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:0.52681303024292 / seconds
Query Executed:select id FROM `az` where city='Safford' && SIC_code='7929'DB:business_master_new
loadtime:0.53075313568115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1
loadtime:0.5308051109314 / seconds
Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='7929'DB:business_master_new
loadtime:0.53355002403259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1
loadtime:0.53360295295715 / seconds
Query Executed:select id FROM `az` where city='Saint David' && SIC_code='7929'DB:business_master_new
loadtime:0.53487396240234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:0.53492617607117 / seconds
Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='7929'DB:business_master_new
loadtime:0.53798604011536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1
loadtime:0.53803896903992 / seconds
Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='7929'DB:business_master_new
loadtime:0.53883409500122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1
loadtime:0.53888607025146 / seconds
Query Executed:select id FROM `az` where city='Salome' && SIC_code='7929'DB:business_master_new
loadtime:0.54101896286011 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1
loadtime:0.54107117652893 / seconds
Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='7929'DB:business_master_new
loadtime:0.54281210899353 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:0.54286408424377 / seconds
Query Executed:select id FROM `az` where city='San Luis' && SIC_code='7929'DB:business_master_new
loadtime:0.54439997673035 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1
loadtime:0.54445314407349 / seconds
Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='7929'DB:business_master_new
loadtime:0.54541516304016 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1
loadtime:0.54546713829041 / seconds
Query Executed:select id FROM `az` where city='San Simon' && SIC_code='7929'DB:business_master_new
loadtime:0.54654002189636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1
loadtime:0.54659295082092 / seconds
Query Executed:select id FROM `az` where city='Sanders' && SIC_code='7929'DB:business_master_new
loadtime:0.54831504821777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1
loadtime:0.54836797714233 / seconds
Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='7929'DB:business_master_new
loadtime:0.54909515380859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1
loadtime:0.54915595054626 / seconds
Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='7929'DB:business_master_new
loadtime:0.55318117141724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1
loadtime:0.55331301689148 / seconds
Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='7929'DB:business_master_new
loadtime:0.55415010452271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1
loadtime:0.55420899391174 / seconds
Query Executed:select id FROM `az` where city='Sedona' && SIC_code='7929'DB:business_master_new
loadtime:0.55816197395325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1
loadtime:0.55822896957397 / seconds
Query Executed:select id FROM `az` where city='Seligman' && SIC_code='7929'DB:business_master_new
loadtime:0.55969405174255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1
loadtime:0.55974817276001 / seconds
Query Executed:select id FROM `az` where city='Sells' && SIC_code='7929'DB:business_master_new
loadtime:0.56185102462769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1
loadtime:0.56190514564514 / seconds
Query Executed:select id FROM `az` where city='Shonto' && SIC_code='7929'DB:business_master_new
loadtime:0.56253910064697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1
loadtime:0.56259107589722 / seconds
Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='7929'DB:business_master_new
loadtime:0.56311702728271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1
loadtime:0.56316995620728 / seconds
Query Executed:select id FROM `az` where city='Show Low' && SIC_code='7929'DB:business_master_new
loadtime:0.56713604927063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1
loadtime:0.56718897819519 / seconds
Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='7929'DB:business_master_new
loadtime:0.57117199897766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1
loadtime:0.57124495506287 / seconds
Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.5720751285553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1
loadtime:0.57213807106018 / seconds
Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='7929'DB:business_master_new
loadtime:0.57549500465393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:0.57554912567139 / seconds
Query Executed:select id FROM `az` where city='Solomon' && SIC_code='7929'DB:business_master_new
loadtime:0.57623410224915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1
loadtime:0.57629013061523 / seconds
Query Executed:select id FROM `az` where city='Somerton' && SIC_code='7929'DB:business_master_new
loadtime:0.57775712013245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1
loadtime:0.57781004905701 / seconds
Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='7929'DB:business_master_new
loadtime:0.5797860622406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1
loadtime:0.57983899116516 / seconds
Query Executed:select id FROM `az` where city='Springerville' && SIC_code='7929'DB:business_master_new
loadtime:0.58308601379395 / seconds
Query loaded from cache:select * from geodata_geocity where city='St David' limit 1
loadtime:0.58314800262451 / seconds
Query Executed:select id FROM `az` where city='St David' && SIC_code='7929'DB:business_master_new
loadtime:0.58364415168762 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:0.58369612693787 / seconds
Query Executed:select id FROM `az` where city='St Johns' && SIC_code='7929'DB:business_master_new
loadtime:0.58424401283264 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1
loadtime:0.58430004119873 / seconds
Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='7929'DB:business_master_new
loadtime:0.58496999740601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:0.58502101898193 / seconds
Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='7929'DB:business_master_new
loadtime:0.58580613136292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1
loadtime:0.58586001396179 / seconds
Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='7929'DB:business_master_new
loadtime:0.58654499053955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:0.58659696578979 / seconds
Query Executed:select id FROM `az` where city='Sun City' && SIC_code='7929'DB:business_master_new
loadtime:0.59055304527283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1
loadtime:0.59062314033508 / seconds
Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='7929'DB:business_master_new
loadtime:0.59459900856018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1
loadtime:0.59465312957764 / seconds
Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='7929'DB:business_master_new
loadtime:0.59524011611938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1
loadtime:0.59529709815979 / seconds
Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.59587597846985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1
loadtime:0.59592795372009 / seconds
Query Executed:select id FROM `az` where city='Supai' && SIC_code='7929'DB:business_master_new
loadtime:0.59655809402466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.59661102294922 / seconds
Query Executed:select id FROM `az` where city='Superior' && SIC_code='7929'DB:business_master_new
loadtime:0.59747314453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1
loadtime:0.59752607345581 / seconds
Query Executed:select id FROM `az` where city='Surprise' && SIC_code='7929'DB:business_master_new
loadtime:0.60153007507324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1
loadtime:0.6015989780426 / seconds
Query Executed:select id FROM `az` where city='Tacna' && SIC_code='7929'DB:business_master_new
loadtime:0.60231900215149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:0.60237312316895 / seconds
Query Executed:select id FROM `az` where city='Taylor' && SIC_code='7929'DB:business_master_new
loadtime:0.60415005683899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1
loadtime:0.60420298576355 / seconds
Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='7929'DB:business_master_new
loadtime:0.6050341129303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1
loadtime:0.60508704185486 / seconds
Query Executed:select id FROM `az` where city='Tempe' && SIC_code='7929'DB:business_master_new
loadtime:0.6091411113739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1
loadtime:0.60924816131592 / seconds
Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='7929'DB:business_master_new
loadtime:0.60990214347839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1
loadtime:0.6099591255188 / seconds
Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='7929'DB:business_master_new
loadtime:0.61291909217834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1
loadtime:0.61298704147339 / seconds
Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='7929'DB:business_master_new
loadtime:0.61781406402588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1
loadtime:0.61786794662476 / seconds
Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='7929'DB:business_master_new
loadtime:0.62150406837463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1
loadtime:0.62157201766968 / seconds
Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='7929'DB:business_master_new
loadtime:0.62223196029663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1
loadtime:0.62228918075562 / seconds
Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='7929'DB:business_master_new
loadtime:0.62362813949585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1
loadtime:0.62368106842041 / seconds
Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='7929'DB:business_master_new
loadtime:0.62512302398682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1
loadtime:0.62517499923706 / seconds
Query Executed:select id FROM `az` where city='Topawa' && SIC_code='7929'DB:business_master_new
loadtime:0.62569808959961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1
loadtime:0.62575006484985 / seconds
Query Executed:select id FROM `az` where city='Topock' && SIC_code='7929'DB:business_master_new
loadtime:0.62686896324158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1
loadtime:0.6269211769104 / seconds
Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='7929'DB:business_master_new
loadtime:0.62747716903687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1
loadtime:0.62753105163574 / seconds
Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='7929'DB:business_master_new
loadtime:0.62818813323975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1
loadtime:0.62824010848999 / seconds
Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='7929'DB:business_master_new
loadtime:0.63077902793884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1
loadtime:0.6308319568634 / seconds
Query Executed:select id FROM `az` where city='Tubac' && SIC_code='7929'DB:business_master_new
loadtime:0.6324770450592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1
loadtime:0.63252997398376 / seconds
Query Executed:select id FROM `az` where city='Tucson' && SIC_code='7929'DB:business_master_new
loadtime:0.63658308982849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1
loadtime:0.63674807548523 / seconds
Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='7929'DB:business_master_new
loadtime:0.63773512840271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.63779616355896 / seconds
Query Executed:select id FROM `az` where city='Vail' && SIC_code='7929'DB:business_master_new
loadtime:0.64035797119141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1
loadtime:0.64042401313782 / seconds
Query Executed:select id FROM `az` where city='Valentine' && SIC_code='7929'DB:business_master_new
loadtime:0.64093613624573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1
loadtime:0.64098715782166 / seconds
Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='7929'DB:business_master_new
loadtime:0.6415331363678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.64158606529236 / seconds
Query Executed:select id FROM `az` where city='Vernon' && SIC_code='7929'DB:business_master_new
loadtime:0.64241194725037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1
loadtime:0.64246511459351 / seconds
Query Executed:select id FROM `az` where city='Waddell' && SIC_code='7929'DB:business_master_new
loadtime:0.64492106437683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1
loadtime:0.64497399330139 / seconds
Query Executed:select id FROM `az` where city='Wellton' && SIC_code='7929'DB:business_master_new
loadtime:0.64593911170959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1
loadtime:0.64599299430847 / seconds
Query Executed:select id FROM `az` where city='Wenden' && SIC_code='7929'DB:business_master_new
loadtime:0.64673900604248 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1
loadtime:0.64679217338562 / seconds
Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='7929'DB:business_master_new
loadtime:0.64737296104431 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1
loadtime:0.64742612838745 / seconds
Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='7929'DB:business_master_new
loadtime:0.64792203903198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1
loadtime:0.64797210693359 / seconds
Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='7929'DB:business_master_new
loadtime:0.64903903007507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Why' limit 1
loadtime:0.64909100532532 / seconds
Query Executed:select id FROM `az` where city='Why' && SIC_code='7929'DB:business_master_new
loadtime:0.64960908889771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1
loadtime:0.64966201782227 / seconds
Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='7929'DB:business_master_new
loadtime:0.65641307830811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1
loadtime:0.65648198127747 / seconds
Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='7929'DB:business_master_new
loadtime:0.65719699859619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1
loadtime:0.65725016593933 / seconds
Query Executed:select id FROM `az` where city='Willcox' && SIC_code='7929'DB:business_master_new
loadtime:0.66303014755249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.66309714317322 / seconds
Query Executed:select id FROM `az` where city='Williams' && SIC_code='7929'DB:business_master_new
loadtime:0.66716814041138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1
loadtime:0.66722202301025 / seconds
Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='7929'DB:business_master_new
loadtime:0.66780710220337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1
loadtime:0.66786003112793 / seconds
Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='7929'DB:business_master_new
loadtime:0.67198514938354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1
loadtime:0.67203903198242 / seconds
Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='7929'DB:business_master_new
loadtime:0.6731231212616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:0.67317509651184 / seconds
Query Executed:select id FROM `az` where city='Winslow' && SIC_code='7929'DB:business_master_new
loadtime:0.67821216583252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1
loadtime:0.67826700210571 / seconds
Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='7929'DB:business_master_new
loadtime:0.6793839931488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.67943716049194 / seconds
Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='7929'DB:business_master_new
loadtime:0.68000912666321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1
loadtime:0.68005895614624 / seconds
Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='7929'DB:business_master_new
loadtime:0.6810290813446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Young' limit 1
loadtime:0.68108105659485 / seconds
Query Executed:select id FROM `az` where city='Young' && SIC_code='7929'DB:business_master_new
loadtime:0.6821141242981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1
loadtime:0.68216705322266 / seconds
Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='7929'DB:business_master_new
loadtime:0.68454909324646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1
loadtime:0.68460202217102 / seconds
Query Executed:select id FROM `az` where city='Yucca' && SIC_code='7929'DB:business_master_new
loadtime:0.68525314331055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:0.68531107902527 / seconds
Query Executed:select id FROM `az` where city='Yuma' && SIC_code='7929'DB:business_master_new
loadtime:0.68938016891479 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.68952608108521 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.68991804122925 / seconds
Operation template executed (chunk cache operation)
loadtime:0.69008111953735 / seconds
template override:Default
loadtime:0.69013404846191 / 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.69142699241638 / seconds
Template Constructed, Array Rows:49
loadtime:0.69194412231445 / seconds
TOTAL EXECUTION TIME: 0.69152
loadtime:0.69333410263062 / 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] => bands-orchestras-actors-and-other-entertainers-entertainment-groups [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.69334697723389
TOTAL KEY ARRAYS: 69