Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00016999244689941 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011370182037354 / seconds
host not found setting manual db connection
loadtime:0.0020008087158203 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0027589797973633 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0032129287719727 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0033450126647949 / seconds
zipcode:
loadtime:0.0033638477325439 / seconds
Query Executed:select * from search_referrer where page_hash='da23cb41657e7858ce37b1e70b605370' limit 10 DB:ezrox_toadli
loadtime:0.0036139488220215 / seconds
Operation header executed (non global)
loadtime:0.0036308765411377 / seconds
Operation leaderboard executed (non global)
loadtime:0.0036728382110596 / seconds
Operation square executed (non global)
loadtime:0.0036869049072266 / seconds
Operation square_bottom executed (non global)
loadtime:0.0037000179290771 / seconds
Operation smallsquare executed (non global)
loadtime:0.0037119388580322 / seconds
Operation headeradright executed (non global)
loadtime:0.0037229061126709 / seconds
Operation google_analytics executed (non global)
loadtime:0.0037329196929932 / seconds
Operation topstories executed (non global)
loadtime:0.0037448406219482 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0037558078765869 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0037658214569092 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0040688514709473 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0042829513549805 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0043888092041016 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0045549869537354 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0046548843383789 / seconds
Template key: archive_menu pushed
loadtime:0.0046679973602295 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0046839714050293 / seconds
Template key: get_gravatar pushed
loadtime:0.0046930313110352 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0047028064727783 / seconds
*10)-10)+1 | start:0
loadtime:0.0047588348388672 / seconds
DB connected to localhost business_master_new
loadtime:0.0053408145904541 / seconds
Query Executed:select * from categories where cat_URLid='eating-places'DB:business_master_new
loadtime:0.0059199333190918 / seconds
Query stored in cache : _QUERY_www.toadli.combda0232d5ec280163e8d47a1f1db204b
loadtime:0.0059828758239746 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.0060138702392578 / seconds
Query Executed:select * from `az_catmap` where sic='5812' order by city ascDB:business_master_new
loadtime:0.026304006576538 / seconds
Query stored in cache : _QUERY_www.toadli.com790cdd835e12fa775330d3ce30ad5b4f
loadtime:0.026777982711792 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.026814937591553 / seconds
Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='5812'DB:business_master_new
loadtime:0.028491973876953 / seconds
Query stored in cache : _QUERY_www.toadli.comf8ebbc2c735e002f5365899162b9d04a
loadtime:0.02852201461792 / seconds
287 / 11
loadtime:0.028560876846313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1
loadtime:0.028611898422241 / seconds
Query Executed:select id FROM `az` where city='Aguila' && SIC_code='5812'DB:business_master_new
loadtime:0.044075012207031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1
loadtime:0.044122934341431 / seconds
Query Executed:select id FROM `az` where city='Ajo' && SIC_code='5812'DB:business_master_new
loadtime:0.2978048324585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.29807901382446 / seconds
Query Executed:select id FROM `az` where city='Alpine' && SIC_code='5812'DB:business_master_new
loadtime:0.33844399452209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1
loadtime:0.33849787712097 / seconds
Query Executed:select id FROM `az` where city='Amado' && SIC_code='5812'DB:business_master_new
loadtime:0.35439896583557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1
loadtime:0.35446190834045 / seconds
Query Executed:select id FROM `az` where city='Anthem' && SIC_code='5812'DB:business_master_new
loadtime:0.35906600952148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1
loadtime:0.35911583900452 / seconds
Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='5812'DB:business_master_new
loadtime:0.39123582839966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1
loadtime:0.39133596420288 / seconds
Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='5812'DB:business_master_new
loadtime:0.40606689453125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1
loadtime:0.40612888336182 / seconds
Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='5812'DB:business_master_new
loadtime:0.45753693580627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.45758581161499 / seconds
Query Executed:select id FROM `az` where city='Arlington' && SIC_code='5812'DB:business_master_new
loadtime:0.46839880943298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1
loadtime:0.46845197677612 / seconds
Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='5812'DB:business_master_new
loadtime:0.51958203315735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.51963496208191 / seconds
Query Executed:select id FROM `az` where city='Avondale' && SIC_code='5812'DB:business_master_new
loadtime:0.60670185089111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1
loadtime:0.60704493522644 / seconds
Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='5812'DB:business_master_new
loadtime:0.62681698799133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1
loadtime:0.62686681747437 / seconds
Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='5812'DB:business_master_new
loadtime:0.62786388397217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1
loadtime:0.62791395187378 / seconds
Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='5812'DB:business_master_new
loadtime:0.6383650302887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.63842296600342 / seconds
Query Executed:select id FROM `az` where city='Benson' && SIC_code='5812'DB:business_master_new
loadtime:0.66401982307434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1
loadtime:0.6640830039978 / seconds
Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='5812'DB:business_master_new
loadtime:0.71290993690491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1
loadtime:0.71302700042725 / seconds
Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='5812'DB:business_master_new
loadtime:0.79893589019775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1
loadtime:0.79902195930481 / seconds
Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='5812'DB:business_master_new
loadtime:0.80054688453674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1
loadtime:0.80060291290283 / seconds
Query Executed:select id FROM `az` where city='Blue' && SIC_code='5812'DB:business_master_new
loadtime:0.80370593070984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1
loadtime:0.80374097824097 / seconds
Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='5812'DB:business_master_new
loadtime:0.80556893348694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1
loadtime:0.80561685562134 / seconds
Query Executed:select id FROM `az` where city='Bouse' && SIC_code='5812'DB:business_master_new
loadtime:0.81532001495361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1
loadtime:0.81537890434265 / seconds
Query Executed:select id FROM `az` where city='Bowie' && SIC_code='5812'DB:business_master_new
loadtime:0.83526992797852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.83535695075989 / seconds
Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='5812'DB:business_master_new
loadtime:0.8553318977356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1
loadtime:0.85540699958801 / seconds
Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='5812'DB:business_master_new
loadtime:0.91059398651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1
loadtime:0.91068696975708 / seconds
Query Executed:select id FROM `az` where city='Bylas' && SIC_code='5812'DB:business_master_new
loadtime:0.91612696647644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.91618394851685 / seconds
Query Executed:select id FROM `az` where city='Cameron' && SIC_code='5812'DB:business_master_new
loadtime:0.92558002471924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1
loadtime:0.92567586898804 / seconds
Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='5812'DB:business_master_new
loadtime:0.94565296173096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1
loadtime:0.94581890106201 / seconds
Query Executed:select id FROM `az` where city='Carefree' && SIC_code='5812'DB:business_master_new
loadtime:0.97689199447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1
loadtime:0.97709584236145 / seconds
Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='5812'DB:business_master_new
loadtime:1.0145528316498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1
loadtime:1.0146958827972 / seconds
Query Executed:select id FROM `az` where city='Cashion' && SIC_code='5812'DB:business_master_new
loadtime:1.0273649692535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1
loadtime:1.0274229049683 / seconds
Query Executed:select id FROM `az` where city='Catalina' && SIC_code='5812'DB:business_master_new
loadtime:1.0395369529724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1
loadtime:1.0395729541779 / seconds
Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='5812'DB:business_master_new
loadtime:1.0702238082886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:1.0704038143158 / seconds
Query Executed:select id FROM `az` where city='Central' && SIC_code='5812'DB:business_master_new
loadtime:1.0763688087463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1
loadtime:1.0764079093933 / seconds
Query Executed:select id FROM `az` where city='Chambers' && SIC_code='5812'DB:business_master_new
loadtime:1.1015357971191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1
loadtime:1.1016008853912 / seconds
Query Executed:select id FROM `az` where city='Chandler' && SIC_code='5812'DB:business_master_new
loadtime:1.3959100246429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1
loadtime:1.3966019153595 / seconds
Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='5812'DB:business_master_new
loadtime:1.4032049179077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1
loadtime:1.4033029079437 / seconds
Query Executed:select id FROM `az` where city='Chinle' && SIC_code='5812'DB:business_master_new
loadtime:1.4922578334808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1
loadtime:1.4924118518829 / seconds
Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='5812'DB:business_master_new
loadtime:1.5099229812622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1
loadtime:1.5102050304413 / seconds
Query Executed:select id FROM `az` where city='Chloride' && SIC_code='5812'DB:business_master_new
loadtime:1.515273809433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1
loadtime:1.5153357982635 / seconds
Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='5812'DB:business_master_new
loadtime:1.5181169509888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1
loadtime:1.5181529521942 / seconds
Query Executed:select id FROM `az` where city='Cibola' && SIC_code='5812'DB:business_master_new
loadtime:1.5224158763885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1
loadtime:1.5224678516388 / seconds
Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='5812'DB:business_master_new
loadtime:1.6243858337402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1
loadtime:1.6245348453522 / seconds
Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='5812'DB:business_master_new
loadtime:1.6319789886475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1
loadtime:1.6320419311523 / seconds
Query Executed:select id FROM `az` where city='Claypool' && SIC_code='5812'DB:business_master_new
loadtime:1.676787853241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.6769189834595 / seconds
Query Executed:select id FROM `az` where city='Clifton' && SIC_code='5812'DB:business_master_new
loadtime:1.7351698875427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1
loadtime:1.7352609634399 / seconds
Query Executed:select id FROM `az` where city='Cochise' && SIC_code='5812'DB:business_master_new
loadtime:1.7522559165955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:1.7523069381714 / seconds
Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='5812'DB:business_master_new
loadtime:1.8125448226929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1
loadtime:1.8126308917999 / seconds
Query Executed:select id FROM `az` where city='Concho' && SIC_code='5812'DB:business_master_new
loadtime:1.8263850212097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1
loadtime:1.8264448642731 / seconds
Query Executed:select id FROM `az` where city='Congress' && SIC_code='5812'DB:business_master_new
loadtime:1.8590188026428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:1.8590648174286 / seconds
Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='5812'DB:business_master_new
loadtime:1.9491620063782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1
loadtime:1.9492788314819 / seconds
Query Executed:select id FROM `az` where city='Cornville' && SIC_code='5812'DB:business_master_new
loadtime:2.0266408920288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1
loadtime:2.0268468856812 / seconds
Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='5812'DB:business_master_new
loadtime:2.0535628795624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:2.0536398887634 / seconds
Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='5812'DB:business_master_new
loadtime:2.0799360275269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1
loadtime:2.080039024353 / seconds
Query Executed:select id FROM `az` where city='Crown King' && SIC_code='5812'DB:business_master_new
loadtime:2.0832958221436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1
loadtime:2.0833508968353 / seconds
Query Executed:select id FROM `az` where city='Dateland' && SIC_code='5812'DB:business_master_new
loadtime:2.0867879390717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1
loadtime:2.0868239402771 / seconds
Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='5812'DB:business_master_new
loadtime:2.0877499580383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1
loadtime:2.0877909660339 / seconds
Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='5812'DB:business_master_new
loadtime:2.0895729064941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1
loadtime:2.0896139144897 / seconds
Query Executed:select id FROM `az` where city='Dewey' && SIC_code='5812'DB:business_master_new
loadtime:2.20774102211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1
loadtime:2.2078349590302 / seconds
Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='5812'DB:business_master_new
loadtime:2.2206928730011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:2.2207658290863 / seconds
Query Executed:select id FROM `az` where city='Douglas' && SIC_code='5812'DB:business_master_new
loadtime:2.2386639118195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1
loadtime:2.2387359142303 / seconds
Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='5812'DB:business_master_new
loadtime:2.2452998161316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:2.2453508377075 / seconds
Query Executed:select id FROM `az` where city='Duncan' && SIC_code='5812'DB:business_master_new
loadtime:2.2877428531647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1
loadtime:2.2878320217133 / seconds
Query Executed:select id FROM `az` where city='Eagar' && SIC_code='5812'DB:business_master_new
loadtime:2.3423478603363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:2.3424408435822 / seconds
Query Executed:select id FROM `az` where city='Eden' && SIC_code='5812'DB:business_master_new
loadtime:2.3434338569641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1
loadtime:2.3434779644012 / seconds
Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='5812'DB:business_master_new
loadtime:2.3678958415985 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1
loadtime:2.3679428100586 / seconds
Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='5812'DB:business_master_new
loadtime:2.3764908313751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1
loadtime:2.3765549659729 / seconds
Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='5812'DB:business_master_new
loadtime:2.4046759605408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:2.4047269821167 / seconds
Query Executed:select id FROM `az` where city='Elgin' && SIC_code='5812'DB:business_master_new
loadtime:2.4105358123779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1
loadtime:2.4105849266052 / seconds
Query Executed:select id FROM `az` where city='Eloy' && SIC_code='5812'DB:business_master_new
loadtime:2.450122833252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1
loadtime:2.4501888751984 / seconds
Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='5812'DB:business_master_new
loadtime:2.5374808311462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:2.5377478599548 / seconds
Query Executed:select id FROM `az` where city='Florence' && SIC_code='5812'DB:business_master_new
loadtime:2.5641088485718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1
loadtime:2.5641670227051 / seconds
Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='5812'DB:business_master_new
loadtime:2.5670328140259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1
loadtime:2.567088842392 / seconds
Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='5812'DB:business_master_new
loadtime:2.5679650306702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:2.5680069923401 / seconds
Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='5812'DB:business_master_new
loadtime:2.6129817962646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1
loadtime:2.6130738258362 / seconds
Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='5812'DB:business_master_new
loadtime:2.6621840000153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1
loadtime:2.6622669696808 / seconds
Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='5812'DB:business_master_new
loadtime:2.6712779998779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1
loadtime:2.671324968338 / seconds
Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='5812'DB:business_master_new
loadtime:2.6872229576111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1
loadtime:2.6873049736023 / seconds
Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='5812'DB:business_master_new
loadtime:2.6931049823761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1
loadtime:2.6931419372559 / seconds
Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='5812'DB:business_master_new
loadtime:2.7241928577423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:2.7243230342865 / seconds
Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='5812'DB:business_master_new
loadtime:2.7494878768921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:2.749538898468 / seconds
Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='5812'DB:business_master_new
loadtime:2.7510759830475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1
loadtime:2.7511188983917 / seconds
Query Executed:select id FROM `az` where city='Ganado' && SIC_code='5812'DB:business_master_new
loadtime:2.7709197998047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1
loadtime:2.7709908485413 / seconds
Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='5812'DB:business_master_new
loadtime:2.8047578334808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:2.8048069477081 / seconds
Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='5812'DB:business_master_new
loadtime:2.8924498558044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:2.8926849365234 / seconds
Query Executed:select id FROM `az` where city='Glendale' && SIC_code='5812'DB:business_master_new
loadtime:3.027706861496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1
loadtime:3.0282180309296 / seconds
Query Executed:select id FROM `az` where city='Globe' && SIC_code='5812'DB:business_master_new
loadtime:3.047159910202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1
loadtime:3.0472958087921 / seconds
Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='5812'DB:business_master_new
loadtime:3.0957498550415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1
loadtime:3.0958218574524 / seconds
Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='5812'DB:business_master_new
loadtime:3.1438210010529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1
loadtime:3.1440329551697 / seconds
Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='5812'DB:business_master_new
loadtime:3.1720759868622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1
loadtime:3.1721489429474 / seconds
Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='5812'DB:business_master_new
loadtime:3.1729300022125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:3.1730120182037 / seconds
Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='5812'DB:business_master_new
loadtime:3.1854889392853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1
loadtime:3.1855700016022 / seconds
Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='5812'DB:business_master_new
loadtime:3.1858940124512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:3.1859228610992 / seconds
Query Executed:select id FROM `az` where city='Greer' && SIC_code='5812'DB:business_master_new
loadtime:3.2118649482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1
loadtime:3.211993932724 / seconds
Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='5812'DB:business_master_new
loadtime:3.2136800289154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1
loadtime:3.2137110233307 / seconds
Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='5812'DB:business_master_new
loadtime:3.2172808647156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1
loadtime:3.2173428535461 / seconds
Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='5812'DB:business_master_new
loadtime:3.2208898067474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:3.2209320068359 / seconds
Query Executed:select id FROM `az` where city='Hayden' && SIC_code='5812'DB:business_master_new
loadtime:3.2282249927521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1
loadtime:3.2282979488373 / seconds
Query Executed:select id FROM `az` where city='Heber' && SIC_code='5812'DB:business_master_new
loadtime:3.2374119758606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:3.2374789714813 / seconds
Query Executed:select id FROM `az` where city='Hereford' && SIC_code='5812'DB:business_master_new
loadtime:3.2858698368073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1
loadtime:3.2859668731689 / seconds
Query Executed:select id FROM `az` where city='Higley' && SIC_code='5812'DB:business_master_new
loadtime:3.2904407978058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:3.2905168533325 / seconds
Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='5812'DB:business_master_new
loadtime:3.2998678684235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1
loadtime:3.2999749183655 / seconds
Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='5812'DB:business_master_new
loadtime:3.3040158748627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1
loadtime:3.3040800094604 / seconds
Query Executed:select id FROM `az` where city='Houck' && SIC_code='5812'DB:business_master_new
loadtime:3.3063378334045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1
loadtime:3.3063750267029 / seconds
Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='5812'DB:business_master_new
loadtime:3.3425459861755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1
loadtime:3.3426609039307 / seconds
Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='5812'DB:business_master_new
loadtime:3.3457210063934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:3.3457608222961 / seconds
Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='5812'DB:business_master_new
loadtime:3.3539209365845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1
loadtime:3.3539898395538 / seconds
Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='5812'DB:business_master_new
loadtime:3.3557758331299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1
loadtime:3.3558168411255 / seconds
Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='5812'DB:business_master_new
loadtime:3.3566648960114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:3.3567008972168 / seconds
Query Executed:select id FROM `az` where city='Jerome' && SIC_code='5812'DB:business_master_new
loadtime:3.3838629722595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1
loadtime:3.383927822113 / seconds
Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='5812'DB:business_master_new
loadtime:3.3909738063812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1
loadtime:3.391019821167 / seconds
Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='5812'DB:business_master_new
loadtime:3.3923399448395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1
loadtime:3.3923888206482 / seconds
Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='5812'DB:business_master_new
loadtime:3.3926589488983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1
loadtime:3.3926849365234 / seconds
Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='5812'DB:business_master_new
loadtime:3.404639005661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1
loadtime:3.4047169685364 / seconds
Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='5812'DB:business_master_new
loadtime:3.4094669818878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:3.4095149040222 / seconds
Query Executed:select id FROM `az` where city='Kearny' && SIC_code='5812'DB:business_master_new
loadtime:3.4132039546967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:3.4132668972015 / seconds
Query Executed:select id FROM `az` where city='Kingman' && SIC_code='5812'DB:business_master_new
loadtime:3.4302179813385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:3.4303338527679 / seconds
Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='5812'DB:business_master_new
loadtime:3.4386749267578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1
loadtime:3.4387269020081 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='5812'DB:business_master_new
loadtime:3.4437599182129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1
loadtime:3.4438238143921 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='5812'DB:business_master_new
loadtime:3.4450190067291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1
loadtime:3.4450578689575 / seconds
Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='5812'DB:business_master_new
loadtime:3.4739258289337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1
loadtime:3.4742238521576 / seconds
Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='5812'DB:business_master_new
loadtime:3.4792640209198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:3.4793248176575 / seconds
Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='5812'DB:business_master_new
loadtime:3.4846029281616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1
loadtime:3.4846739768982 / seconds
Query Executed:select id FROM `az` where city='Laveen' && SIC_code='5812'DB:business_master_new
loadtime:3.4896569252014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1
loadtime:3.4897029399872 / seconds
Query Executed:select id FROM `az` where city='Leupp' && SIC_code='5812'DB:business_master_new
loadtime:3.4920699596405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1
loadtime:3.4921200275421 / seconds
Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='5812'DB:business_master_new
loadtime:3.4989838600159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1
loadtime:3.4990530014038 / seconds
Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='5812'DB:business_master_new
loadtime:3.5027589797974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1
loadtime:3.5028038024902 / seconds
Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='5812'DB:business_master_new
loadtime:3.5036449432373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1
loadtime:3.503693819046 / seconds
Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='5812'DB:business_master_new
loadtime:3.5084118843079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1
loadtime:3.508446931839 / seconds
Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='5812'DB:business_master_new
loadtime:3.5147259235382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:3.5147879123688 / seconds
Query Executed:select id FROM `az` where city='Lupton' && SIC_code='5812'DB:business_master_new
loadtime:3.5187158584595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1
loadtime:3.5187509059906 / seconds
Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='5812'DB:business_master_new
loadtime:3.5190658569336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:3.5191059112549 / seconds
Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='5812'DB:business_master_new
loadtime:3.5204570293427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1
loadtime:3.5205328464508 / seconds
Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='5812'DB:business_master_new
loadtime:3.522145986557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1
loadtime:3.522176027298 / seconds
Query Executed:select id FROM `az` where city='Marana' && SIC_code='5812'DB:business_master_new
loadtime:3.5274488925934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1
loadtime:3.5275249481201 / seconds
Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='5812'DB:business_master_new
loadtime:3.5289258956909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1
loadtime:3.5289838314056 / seconds
Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='5812'DB:business_master_new
loadtime:3.5704929828644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1
loadtime:3.5705718994141 / seconds
Query Executed:select id FROM `az` where city='Mayer' && SIC_code='5812'DB:business_master_new
loadtime:3.5885410308838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1
loadtime:3.588593006134 / seconds
Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='5812'DB:business_master_new
loadtime:3.5889019966125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1
loadtime:3.5889458656311 / seconds
Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='5812'DB:business_master_new
loadtime:3.5925529003143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1
loadtime:3.5925979614258 / seconds
Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='5812'DB:business_master_new
loadtime:3.5941298007965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1
loadtime:3.594183921814 / seconds
Query Executed:select id FROM `az` where city='Meadview' && SIC_code='5812'DB:business_master_new
loadtime:3.5974378585815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:3.5975008010864 / seconds
Query Executed:select id FROM `az` where city='Mesa' && SIC_code='5812'DB:business_master_new
loadtime:3.7106459140778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:3.7119159698486 / seconds
Query Executed:select id FROM `az` where city='Miami' && SIC_code='5812'DB:business_master_new
loadtime:3.7377648353577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1
loadtime:3.7379519939423 / seconds
Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='5812'DB:business_master_new
loadtime:3.7519099712372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:3.7519779205322 / seconds
Query Executed:select id FROM `az` where city='Morenci' && SIC_code='5812'DB:business_master_new
loadtime:3.7555589675903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1
loadtime:3.7556388378143 / seconds
Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='5812'DB:business_master_new
loadtime:3.7567608356476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:3.7568089962006 / seconds
Query Executed:select id FROM `az` where city='Morristown' && SIC_code='5812'DB:business_master_new
loadtime:3.7614488601685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1
loadtime:3.7615230083466 / seconds
Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='5812'DB:business_master_new
loadtime:3.7634909152985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1
loadtime:3.7635350227356 / seconds
Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='5812'DB:business_master_new
loadtime:3.763876914978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1
loadtime:3.7639269828796 / seconds
Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='5812'DB:business_master_new
loadtime:3.7658200263977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1
loadtime:3.7658948898315 / seconds
Query Executed:select id FROM `az` where city='Naco' && SIC_code='5812'DB:business_master_new
loadtime:3.7686078548431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1
loadtime:3.7686588764191 / seconds
Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='5812'DB:business_master_new
loadtime:3.7691910266876 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:3.7692430019379 / seconds
Query Executed:select id FROM `az` where city='New River' && SIC_code='5812'DB:business_master_new
loadtime:3.779394865036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1
loadtime:3.7794508934021 / seconds
Query Executed:select id FROM `az` where city='Nogales' && SIC_code='5812'DB:business_master_new
loadtime:3.7884819507599 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1
loadtime:3.7886338233948 / seconds
Query Executed:select id FROM `az` where city='North Rim' && SIC_code='5812'DB:business_master_new
loadtime:3.7890520095825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1
loadtime:3.7890939712524 / seconds
Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='5812'DB:business_master_new
loadtime:3.7898778915405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1
loadtime:3.7899389266968 / seconds
Query Executed:select id FROM `az` where city='Oatman' && SIC_code='5812'DB:business_master_new
loadtime:3.7909078598022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1
loadtime:3.7909770011902 / seconds
Query Executed:select id FROM `az` where city='Oracle' && SIC_code='5812'DB:business_master_new
loadtime:3.7936618328094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1
loadtime:3.7937388420105 / seconds
Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='5812'DB:business_master_new
loadtime:3.7950189113617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1
loadtime:3.7950739860535 / seconds
Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='5812'DB:business_master_new
loadtime:3.7995038032532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:3.7995619773865 / seconds
Query Executed:select id FROM `az` where city='Page' && SIC_code='5812'DB:business_master_new
loadtime:3.8047349452972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1
loadtime:3.8048439025879 / seconds
Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='5812'DB:business_master_new
loadtime:3.8074598312378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1
loadtime:3.8074958324432 / seconds
Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='5812'DB:business_master_new
loadtime:3.8172769546509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:3.8173749446869 / seconds
Query Executed:select id FROM `az` where city='Parker' && SIC_code='5812'DB:business_master_new
loadtime:3.8249938488007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1
loadtime:3.8250830173492 / seconds
Query Executed:select id FROM `az` where city='Parks' && SIC_code='5812'DB:business_master_new
loadtime:3.8265879154205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1
loadtime:3.8266589641571 / seconds
Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='5812'DB:business_master_new
loadtime:3.8269979953766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1
loadtime:3.8270478248596 / seconds
Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='5812'DB:business_master_new
loadtime:3.8314628601074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1
loadtime:3.8315088748932 / seconds
Query Executed:select id FROM `az` where city='Paulden' && SIC_code='5812'DB:business_master_new
loadtime:3.8347709178925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:3.8348369598389 / seconds
Query Executed:select id FROM `az` where city='Payson' && SIC_code='5812'DB:business_master_new
loadtime:3.8437600135803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1
loadtime:3.8438818454742 / seconds
Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='5812'DB:business_master_new
loadtime:3.8456017971039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1
loadtime:3.8456678390503 / seconds
Query Executed:select id FROM `az` where city='Pearce' && SIC_code='5812'DB:business_master_new
loadtime:3.8505589962006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1
loadtime:3.8506028652191 / seconds
Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='5812'DB:business_master_new
loadtime:3.8508758544922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1
loadtime:3.8509178161621 / seconds
Query Executed:select id FROM `az` where city='Peoria' && SIC_code='5812'DB:business_master_new
loadtime:3.8660748004913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1
loadtime:3.866397857666 / seconds
Query Executed:select id FROM `az` where city='Peridot' && SIC_code='5812'DB:business_master_new
loadtime:3.867075920105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1
loadtime:3.8671329021454 / seconds
Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='5812'DB:business_master_new
loadtime:3.8674509525299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1
loadtime:3.8674938678741 / seconds
Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='5812'DB:business_master_new
loadtime:3.8678488731384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:3.8678839206696 / seconds
Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='5812'DB:business_master_new
loadtime:4.0329129695892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:4.0356378555298 / seconds
Query Executed:select id FROM `az` where city='Picacho' && SIC_code='5812'DB:business_master_new
loadtime:4.0361728668213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1
loadtime:4.036358833313 / seconds
Query Executed:select id FROM `az` where city='Pima' && SIC_code='5812'DB:business_master_new
loadtime:4.0378139019012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:4.0378849506378 / seconds
Query Executed:select id FROM `az` where city='Pine' && SIC_code='5812'DB:business_master_new
loadtime:4.0400378704071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:4.0400838851929 / seconds
Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='5812'DB:business_master_new
loadtime:4.0404758453369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1
loadtime:4.0405240058899 / seconds
Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='5812'DB:business_master_new
loadtime:4.0446209907532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:4.0446779727936 / seconds
Query Executed:select id FROM `az` where city='Pinon' && SIC_code='5812'DB:business_master_new
loadtime:4.0451648235321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1
loadtime:4.0452129840851 / seconds
Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='5812'DB:business_master_new
loadtime:4.0457179546356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1
loadtime:4.0457630157471 / seconds
Query Executed:select id FROM `az` where city='Polacca' && SIC_code='5812'DB:business_master_new
loadtime:4.0462749004364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1
loadtime:4.0463099479675 / seconds
Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='5812'DB:business_master_new
loadtime:4.0466868877411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1
loadtime:4.0467329025269 / seconds
Query Executed:select id FROM `az` where city='Portal' && SIC_code='5812'DB:business_master_new
loadtime:4.047091960907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1
loadtime:4.0471189022064 / seconds
Query Executed:select id FROM `az` where city='Poston' && SIC_code='5812'DB:business_master_new
loadtime:4.0475959777832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:4.0476360321045 / seconds
Query Executed:select id FROM `az` where city='Prescott' && SIC_code='5812'DB:business_master_new
loadtime:4.0549418926239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1
loadtime:4.0551788806915 / seconds
Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='5812'DB:business_master_new
loadtime:4.0604310035706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1
loadtime:4.0605728626251 / seconds
Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='5812'DB:business_master_new
loadtime:4.064836025238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1
loadtime:4.0648930072784 / seconds
Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='5812'DB:business_master_new
loadtime:4.0693600177765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1
loadtime:4.0694329738617 / seconds
Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='5812'DB:business_master_new
loadtime:4.0697989463806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1
loadtime:4.0698540210724 / seconds
Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='5812'DB:business_master_new
loadtime:4.0702819824219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1
loadtime:4.070317029953 / seconds
Query Executed:select id FROM `az` where city='Rillito' && SIC_code='5812'DB:business_master_new
loadtime:4.0708148479462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1
loadtime:4.0708630084991 / seconds
Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='5812'DB:business_master_new
loadtime:4.0719850063324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1
loadtime:4.0720279216766 / seconds
Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='5812'DB:business_master_new
loadtime:4.0749979019165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1
loadtime:4.0750570297241 / seconds
Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='5812'DB:business_master_new
loadtime:4.075838804245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1
loadtime:4.0758738517761 / seconds
Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='5812'DB:business_master_new
loadtime:4.0763218402863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1
loadtime:4.0763688087463 / seconds
Query Executed:select id FROM `az` where city='Roll' && SIC_code='5812'DB:business_master_new
loadtime:4.0768039226532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:4.0768399238586 / seconds
Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='5812'DB:business_master_new
loadtime:4.077586889267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1
loadtime:4.0776298046112 / seconds
Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='5812'DB:business_master_new
loadtime:4.0779747962952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1
loadtime:4.078017950058 / seconds
Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='5812'DB:business_master_new
loadtime:4.0786409378052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:4.0786759853363 / seconds
Query Executed:select id FROM `az` where city='Safford' && SIC_code='5812'DB:business_master_new
loadtime:4.0832359790802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1
loadtime:4.0833518505096 / seconds
Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='5812'DB:business_master_new
loadtime:4.08598279953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1
loadtime:4.086040019989 / seconds
Query Executed:select id FROM `az` where city='Saint David' && SIC_code='5812'DB:business_master_new
loadtime:4.0871000289917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:4.0871639251709 / seconds
Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='5812'DB:business_master_new
loadtime:4.0896859169006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1
loadtime:4.0897378921509 / seconds
Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='5812'DB:business_master_new
loadtime:4.0902349948883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1
loadtime:4.090292930603 / seconds
Query Executed:select id FROM `az` where city='Salome' && SIC_code='5812'DB:business_master_new
loadtime:4.0918588638306 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1
loadtime:4.0919299125671 / seconds
Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='5812'DB:business_master_new
loadtime:4.0933449268341 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:4.0933918952942 / seconds
Query Executed:select id FROM `az` where city='San Luis' && SIC_code='5812'DB:business_master_new
loadtime:4.0949108600616 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1
loadtime:4.0949828624725 / seconds
Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='5812'DB:business_master_new
loadtime:4.0956709384918 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1
loadtime:4.0957219600677 / seconds
Query Executed:select id FROM `az` where city='San Simon' && SIC_code='5812'DB:business_master_new
loadtime:4.0965929031372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1
loadtime:4.0966439247131 / seconds
Query Executed:select id FROM `az` where city='Sanders' && SIC_code='5812'DB:business_master_new
loadtime:4.098140001297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1
loadtime:4.0981748104095 / seconds
Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='5812'DB:business_master_new
loadtime:4.0986390113831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1
loadtime:4.0986878871918 / seconds
Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='5812'DB:business_master_new
loadtime:4.1204929351807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1
loadtime:4.1216869354248 / seconds
Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='5812'DB:business_master_new
loadtime:4.1222670078278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1
loadtime:4.1223809719086 / seconds
Query Executed:select id FROM `az` where city='Sedona' && SIC_code='5812'DB:business_master_new
loadtime:4.1285688877106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1
loadtime:4.1287670135498 / seconds
Query Executed:select id FROM `az` where city='Seligman' && SIC_code='5812'DB:business_master_new
loadtime:4.1299188137054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1
loadtime:4.1299979686737 / seconds
Query Executed:select id FROM `az` where city='Sells' && SIC_code='5812'DB:business_master_new
loadtime:4.132269859314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1
loadtime:4.1323339939117 / seconds
Query Executed:select id FROM `az` where city='Shonto' && SIC_code='5812'DB:business_master_new
loadtime:4.1327188014984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1
loadtime:4.1327559947968 / seconds
Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='5812'DB:business_master_new
loadtime:4.1330528259277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1
loadtime:4.1331009864807 / seconds
Query Executed:select id FROM `az` where city='Show Low' && SIC_code='5812'DB:business_master_new
loadtime:4.1377458572388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1
loadtime:4.1378409862518 / seconds
Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='5812'DB:business_master_new
loadtime:4.1438858509064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1
loadtime:4.144021987915 / seconds
Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='5812'DB:business_master_new
loadtime:4.1446199417114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1
loadtime:4.1446678638458 / seconds
Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='5812'DB:business_master_new
loadtime:4.1474277973175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:4.1475088596344 / seconds
Query Executed:select id FROM `az` where city='Solomon' && SIC_code='5812'DB:business_master_new
loadtime:4.1480009555817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1
loadtime:4.1480669975281 / seconds
Query Executed:select id FROM `az` where city='Somerton' && SIC_code='5812'DB:business_master_new
loadtime:4.1493799686432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1
loadtime:4.1494250297546 / seconds
Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='5812'DB:business_master_new
loadtime:4.1513178348541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1
loadtime:4.1513788700104 / seconds
Query Executed:select id FROM `az` where city='Springerville' && SIC_code='5812'DB:business_master_new
loadtime:4.1552138328552 / seconds
Query loaded from cache:select * from geodata_geocity where city='St David' limit 1
loadtime:4.1552999019623 / seconds
Query Executed:select id FROM `az` where city='St David' && SIC_code='5812'DB:business_master_new
loadtime:4.1556010246277 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:4.1556599140167 / seconds
Query Executed:select id FROM `az` where city='St Johns' && SIC_code='5812'DB:business_master_new
loadtime:4.1560029983521 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1
loadtime:4.1560318470001 / seconds
Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='5812'DB:business_master_new
loadtime:4.1565098762512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:4.1565589904785 / seconds
Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='5812'DB:business_master_new
loadtime:4.1570718288422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1
loadtime:4.1571068763733 / seconds
Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='5812'DB:business_master_new
loadtime:4.1575939655304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:4.1576678752899 / seconds
Query Executed:select id FROM `az` where city='Sun City' && SIC_code='5812'DB:business_master_new
loadtime:4.1626379489899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1
loadtime:4.1627249717712 / seconds
Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='5812'DB:business_master_new
loadtime:4.1670339107513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1
loadtime:4.1670899391174 / seconds
Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='5812'DB:business_master_new
loadtime:4.1674950122833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1
loadtime:4.1675519943237 / seconds
Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='5812'DB:business_master_new
loadtime:4.1682739257812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1
loadtime:4.1683049201965 / seconds
Query Executed:select id FROM `az` where city='Supai' && SIC_code='5812'DB:business_master_new
loadtime:4.1687018871307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:4.1687588691711 / seconds
Query Executed:select id FROM `az` where city='Superior' && SIC_code='5812'DB:business_master_new
loadtime:4.1694078445435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1
loadtime:4.1694509983063 / seconds
Query Executed:select id FROM `az` where city='Surprise' && SIC_code='5812'DB:business_master_new
loadtime:4.1786019802094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1
loadtime:4.1787118911743 / seconds
Query Executed:select id FROM `az` where city='Tacna' && SIC_code='5812'DB:business_master_new
loadtime:4.1791498661041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:4.1791980266571 / seconds
Query Executed:select id FROM `az` where city='Taylor' && SIC_code='5812'DB:business_master_new
loadtime:4.180389881134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1
loadtime:4.1804339885712 / seconds
Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='5812'DB:business_master_new
loadtime:4.1810638904572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1
loadtime:4.1811089515686 / seconds
Query Executed:select id FROM `az` where city='Tempe' && SIC_code='5812'DB:business_master_new
loadtime:4.1959710121155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1
loadtime:4.1964209079742 / seconds
Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='5812'DB:business_master_new
loadtime:4.196751832962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1
loadtime:4.1968228816986 / seconds
Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='5812'DB:business_master_new
loadtime:4.1991958618164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1
loadtime:4.1992559432983 / seconds
Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='5812'DB:business_master_new
loadtime:4.2034568786621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1
loadtime:4.2035219669342 / seconds
Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='5812'DB:business_master_new
loadtime:4.2076458930969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1
loadtime:4.2076978683472 / seconds
Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='5812'DB:business_master_new
loadtime:4.2081379890442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1
loadtime:4.2081799507141 / seconds
Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='5812'DB:business_master_new
loadtime:4.2092728614807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1
loadtime:4.2093307971954 / seconds
Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='5812'DB:business_master_new
loadtime:4.2105138301849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1
loadtime:4.2105579376221 / seconds
Query Executed:select id FROM `az` where city='Topawa' && SIC_code='5812'DB:business_master_new
loadtime:4.2108688354492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1
loadtime:4.2109279632568 / seconds
Query Executed:select id FROM `az` where city='Topock' && SIC_code='5812'DB:business_master_new
loadtime:4.2118618488312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1
loadtime:4.2119069099426 / seconds
Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='5812'DB:business_master_new
loadtime:4.2122509479523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1
loadtime:4.212308883667 / seconds
Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='5812'DB:business_master_new
loadtime:4.2127959728241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1
loadtime:4.2128310203552 / seconds
Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='5812'DB:business_master_new
loadtime:4.2148659229279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1
loadtime:4.2149288654327 / seconds
Query Executed:select id FROM `az` where city='Tubac' && SIC_code='5812'DB:business_master_new
loadtime:4.2163100242615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1
loadtime:4.2163548469543 / seconds
Query Executed:select id FROM `az` where city='Tucson' && SIC_code='5812'DB:business_master_new
loadtime:4.247848033905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1
loadtime:4.2491068840027 / seconds
Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='5812'DB:business_master_new
loadtime:4.249853849411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:4.2499768733978 / seconds
Query Executed:select id FROM `az` where city='Vail' && SIC_code='5812'DB:business_master_new
loadtime:4.2540249824524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1
loadtime:4.2540929317474 / seconds
Query Executed:select id FROM `az` where city='Valentine' && SIC_code='5812'DB:business_master_new
loadtime:4.2544248104095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1
loadtime:4.2544739246368 / seconds
Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='5812'DB:business_master_new
loadtime:4.2548079490662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:4.2548429965973 / seconds
Query Executed:select id FROM `az` where city='Vernon' && SIC_code='5812'DB:business_master_new
loadtime:4.2554938793182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1
loadtime:4.2555468082428 / seconds
Query Executed:select id FROM `az` where city='Waddell' && SIC_code='5812'DB:business_master_new
loadtime:4.2595009803772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1
loadtime:4.2595639228821 / seconds
Query Executed:select id FROM `az` where city='Wellton' && SIC_code='5812'DB:business_master_new
loadtime:4.2602968215942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1
loadtime:4.2603538036346 / seconds
Query Executed:select id FROM `az` where city='Wenden' && SIC_code='5812'DB:business_master_new
loadtime:4.2608418464661 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1
loadtime:4.2608950138092 / seconds
Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='5812'DB:business_master_new
loadtime:4.2613089084625 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1
loadtime:4.2613589763641 / seconds
Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='5812'DB:business_master_new
loadtime:4.2616698741913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1
loadtime:4.2617149353027 / seconds
Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='5812'DB:business_master_new
loadtime:4.2625420093536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Why' limit 1
loadtime:4.2625849246979 / seconds
Query Executed:select id FROM `az` where city='Why' && SIC_code='5812'DB:business_master_new
loadtime:4.2628798484802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1
loadtime:4.2629208564758 / seconds
Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='5812'DB:business_master_new
loadtime:4.2674958705902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1
loadtime:4.2675619125366 / seconds
Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='5812'DB:business_master_new
loadtime:4.2680728435516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1
loadtime:4.2681210041046 / seconds
Query Executed:select id FROM `az` where city='Willcox' && SIC_code='5812'DB:business_master_new
loadtime:4.2723188400269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:4.2723679542542 / seconds
Query Executed:select id FROM `az` where city='Williams' && SIC_code='5812'DB:business_master_new
loadtime:4.2766819000244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1
loadtime:4.2767558097839 / seconds
Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='5812'DB:business_master_new
loadtime:4.2771089076996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1
loadtime:4.2771558761597 / seconds
Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='5812'DB:business_master_new
loadtime:4.2812809944153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1
loadtime:4.2813308238983 / seconds
Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='5812'DB:business_master_new
loadtime:4.2821259498596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:4.2821898460388 / seconds
Query Executed:select id FROM `az` where city='Winslow' && SIC_code='5812'DB:business_master_new
loadtime:4.2866199016571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1
loadtime:4.286682844162 / seconds
Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='5812'DB:business_master_new
loadtime:4.2879819869995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:4.2880308628082 / seconds
Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='5812'DB:business_master_new
loadtime:4.2883539199829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1
loadtime:4.2883968353271 / seconds
Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='5812'DB:business_master_new
loadtime:4.2891979217529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Young' limit 1
loadtime:4.2892668247223 / seconds
Query Executed:select id FROM `az` where city='Young' && SIC_code='5812'DB:business_master_new
loadtime:4.2900350093842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1
loadtime:4.2900810241699 / seconds
Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='5812'DB:business_master_new
loadtime:4.2940428256989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1
loadtime:4.2941119670868 / seconds
Query Executed:select id FROM `az` where city='Yucca' && SIC_code='5812'DB:business_master_new
loadtime:4.2945308685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:4.2945809364319 / seconds
Query Executed:select id FROM `az` where city='Yuma' && SIC_code='5812'DB:business_master_new
loadtime:4.3004879951477 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.3007519245148 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.3010578155518 / seconds
Operation template executed (chunk cache operation)
loadtime:4.3011770248413 / seconds
template override:Default
loadtime:4.3012039661407 / 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:4.302031993866 / seconds
Template Constructed, Array Rows:49
loadtime:4.302414894104 / seconds
TOTAL EXECUTION TIME: 4.30208
loadtime:4.3025488853455 / 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] => eating-places [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:4.3025548458099
TOTAL KEY ARRAYS: 69