DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00018811225891113 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010969638824463 / seconds
host not found setting manual db connection
loadtime:0.0020120143890381 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0024521350860596 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0028119087219238 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0029029846191406 / seconds
zipcode:
loadtime:0.0029330253601074 / seconds
Query Executed:select * from search_referrer where page_hash='c315b0182f6f9fe972aefd1a06dc1b6d' limit 10 DB:ezrox_toadli
loadtime:0.0032699108123779 / seconds
Operation header executed (non global)
loadtime:0.0032989978790283 / seconds
Operation leaderboard executed (non global)
loadtime:0.0033600330352783 / seconds
Operation square executed (non global)
loadtime:0.0033841133117676 / seconds
Operation square_bottom executed (non global)
loadtime:0.0034060478210449 / seconds
Operation smallsquare executed (non global)
loadtime:0.003425121307373 / seconds
Operation headeradright executed (non global)
loadtime:0.0034439563751221 / seconds
Operation google_analytics executed (non global)
loadtime:0.0034620761871338 / seconds
Operation topstories executed (non global)
loadtime:0.0034999847412109 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0035319328308105 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0035591125488281 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0039961338043213 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0042529106140137 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0043270587921143 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0044369697570801 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0045061111450195 / seconds
Template key: archive_menu pushed
loadtime:0.0045139789581299 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0045249462127686 / seconds
Template key: get_gravatar pushed
loadtime:0.0045311450958252 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0045380592346191 / seconds
*10)-10)+1 | start:0
loadtime:0.0045750141143799 / seconds
DB connected to localhost business_master_new
loadtime:0.0049960613250732 / seconds
Query Executed:select * from categories where cat_URLid='bands-orchestras-actors-and-other-entertainers-entertainment-groups'DB:business_master_new
loadtime:0.0059139728546143 / seconds
Query stored in cache : _QUERY_www.toadli.comc2519c04d1f8baeae44699a7477451c2
loadtime:0.0060150623321533 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.0060780048370361 / seconds
Query Executed:select * from `az_catmap` where sic='7929' order by city ascDB:business_master_new
loadtime:0.08791708946228 / seconds
Query stored in cache : _QUERY_www.toadli.comb001c57bb4d3a02fb437f4026bea9dde
loadtime:0.088823080062866 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.088871955871582 / seconds
Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='7929'DB:business_master_new
loadtime:0.091804981231689 / seconds
Query stored in cache : _QUERY_www.toadli.comda1eee4fae600f3a2039fac461d329f6
loadtime:0.091874122619629 / seconds
287 / 11
loadtime:0.091929912567139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1
loadtime:0.0920090675354 / seconds
Query Executed:select id FROM `az` where city='Aguila' && SIC_code='7929'DB:business_master_new
loadtime:0.11261606216431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1
loadtime:0.11267900466919 / seconds
Query Executed:select id FROM `az` where city='Ajo' && SIC_code='7929'DB:business_master_new
loadtime:0.11366605758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.11371898651123 / seconds
Query Executed:select id FROM `az` where city='Alpine' && SIC_code='7929'DB:business_master_new
loadtime:0.11479210853577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1
loadtime:0.11487412452698 / seconds
Query Executed:select id FROM `az` where city='Amado' && SIC_code='7929'DB:business_master_new
loadtime:0.1156849861145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1
loadtime:0.1157341003418 / seconds
Query Executed:select id FROM `az` where city='Anthem' && SIC_code='7929'DB:business_master_new
loadtime:0.12309598922729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1
loadtime:0.12314510345459 / seconds
Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='7929'DB:business_master_new
loadtime:0.12439107894897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1
loadtime:0.12444090843201 / seconds
Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='7929'DB:business_master_new
loadtime:0.13739991188049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1
loadtime:0.13744592666626 / seconds
Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='7929'DB:business_master_new
loadtime:0.13796901702881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.13800692558289 / seconds
Query Executed:select id FROM `az` where city='Arlington' && SIC_code='7929'DB:business_master_new
loadtime:0.14607501029968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1
loadtime:0.14610910415649 / seconds
Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='7929'DB:business_master_new
loadtime:0.14663004875183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.14666891098022 / seconds
Query Executed:select id FROM `az` where city='Avondale' && SIC_code='7929'DB:business_master_new
loadtime:0.14752292633057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1
loadtime:0.14755606651306 / seconds
Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='7929'DB:business_master_new
loadtime:0.14817309379578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1
loadtime:0.1482310295105 / seconds
Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='7929'DB:business_master_new
loadtime:0.14925599098206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1
loadtime:0.14930510520935 / seconds
Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='7929'DB:business_master_new
loadtime:0.15723299980164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.1572859287262 / seconds
Query Executed:select id FROM `az` where city='Benson' && SIC_code='7929'DB:business_master_new
loadtime:0.15846300125122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1
loadtime:0.1585419178009 / seconds
Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='7929'DB:business_master_new
loadtime:0.15968894958496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1
loadtime:0.15973210334778 / seconds
Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='7929'DB:business_master_new
loadtime:0.16051912307739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1
loadtime:0.1605749130249 / seconds
Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='7929'DB:business_master_new
loadtime:0.16313600540161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1
loadtime:0.16318702697754 / seconds
Query Executed:select id FROM `az` where city='Blue' && SIC_code='7929'DB:business_master_new
loadtime:0.16691398620605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1
loadtime:0.16696000099182 / seconds
Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='7929'DB:business_master_new
loadtime:0.16909694671631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1
loadtime:0.16915512084961 / seconds
Query Executed:select id FROM `az` where city='Bouse' && SIC_code='7929'DB:business_master_new
loadtime:0.18181800842285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1
loadtime:0.1819019317627 / seconds
Query Executed:select id FROM `az` where city='Bowie' && SIC_code='7929'DB:business_master_new
loadtime:0.19976997375488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.1998119354248 / seconds
Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='7929'DB:business_master_new
loadtime:0.20140099525452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1
loadtime:0.2014479637146 / seconds
Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='7929'DB:business_master_new
loadtime:0.20404195785522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1
loadtime:0.20414710044861 / seconds
Query Executed:select id FROM `az` where city='Bylas' && SIC_code='7929'DB:business_master_new
loadtime:0.20899891853333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.20907711982727 / seconds
Query Executed:select id FROM `az` where city='Cameron' && SIC_code='7929'DB:business_master_new
loadtime:0.21704912185669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1
loadtime:0.21708202362061 / seconds
Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='7929'DB:business_master_new
loadtime:0.21840000152588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1
loadtime:0.21846008300781 / seconds
Query Executed:select id FROM `az` where city='Carefree' && SIC_code='7929'DB:business_master_new
loadtime:0.22014594078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1
loadtime:0.22020101547241 / seconds
Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='7929'DB:business_master_new
loadtime:0.22163200378418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1
loadtime:0.22169804573059 / seconds
Query Executed:select id FROM `az` where city='Cashion' && SIC_code='7929'DB:business_master_new
loadtime:0.23574495315552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1
loadtime:0.23579502105713 / seconds
Query Executed:select id FROM `az` where city='Catalina' && SIC_code='7929'DB:business_master_new
loadtime:0.25048995018005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1
loadtime:0.25053906440735 / seconds
Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='7929'DB:business_master_new
loadtime:0.2519850730896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.25204396247864 / seconds
Query Executed:select id FROM `az` where city='Central' && SIC_code='7929'DB:business_master_new
loadtime:0.25861406326294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1
loadtime:0.25868606567383 / seconds
Query Executed:select id FROM `az` where city='Chambers' && SIC_code='7929'DB:business_master_new
loadtime:0.27222204208374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1
loadtime:0.27227997779846 / seconds
Query Executed:select id FROM `az` where city='Chandler' && SIC_code='7929'DB:business_master_new
loadtime:0.41024899482727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1
loadtime:0.41031002998352 / seconds
Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='7929'DB:business_master_new
loadtime:0.41622114181519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1
loadtime:0.41627812385559 / seconds
Query Executed:select id FROM `az` where city='Chinle' && SIC_code='7929'DB:business_master_new
loadtime:0.41690802574158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1
loadtime:0.41694498062134 / seconds
Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.41767191886902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1
loadtime:0.41772413253784 / seconds
Query Executed:select id FROM `az` where city='Chloride' && SIC_code='7929'DB:business_master_new
loadtime:0.42246198654175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1
loadtime:0.42251110076904 / seconds
Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='7929'DB:business_master_new
loadtime:0.42579102516174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1
loadtime:0.42582607269287 / seconds
Query Executed:select id FROM `az` where city='Cibola' && SIC_code='7929'DB:business_master_new
loadtime:0.42987394332886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1
loadtime:0.42992210388184 / seconds
Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='7929'DB:business_master_new
loadtime:0.43069195747375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1
loadtime:0.43075704574585 / seconds
Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.43584394454956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1
loadtime:0.43589210510254 / seconds
Query Executed:select id FROM `az` where city='Claypool' && SIC_code='7929'DB:business_master_new
loadtime:0.43669199943542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.43677997589111 / seconds
Query Executed:select id FROM `az` where city='Clifton' && SIC_code='7929'DB:business_master_new
loadtime:0.43767309188843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1
loadtime:0.43773508071899 / seconds
Query Executed:select id FROM `az` where city='Cochise' && SIC_code='7929'DB:business_master_new
loadtime:0.43862295150757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.43867707252502 / seconds
Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='7929'DB:business_master_new
loadtime:0.43945503234863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1
loadtime:0.43951511383057 / seconds
Query Executed:select id FROM `az` where city='Concho' && SIC_code='7929'DB:business_master_new
loadtime:0.45140504837036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1
loadtime:0.45145201683044 / seconds
Query Executed:select id FROM `az` where city='Congress' && SIC_code='7929'DB:business_master_new
loadtime:0.45232105255127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:0.45236802101135 / seconds
Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='7929'DB:business_master_new
loadtime:0.45334911346436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1
loadtime:0.45345997810364 / seconds
Query Executed:select id FROM `az` where city='Cornville' && SIC_code='7929'DB:business_master_new
loadtime:0.4543890953064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1
loadtime:0.45451998710632 / seconds
Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='7929'DB:business_master_new
loadtime:0.45547103881836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.45555710792542 / seconds
Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='7929'DB:business_master_new
loadtime:0.45705699920654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1
loadtime:0.4571270942688 / seconds
Query Executed:select id FROM `az` where city='Crown King' && SIC_code='7929'DB:business_master_new
loadtime:0.46079301834106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1
loadtime:0.46084594726562 / seconds
Query Executed:select id FROM `az` where city='Dateland' && SIC_code='7929'DB:business_master_new
loadtime:0.46541309356689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1
loadtime:0.46545100212097 / seconds
Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='7929'DB:business_master_new
loadtime:0.46672797203064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1
loadtime:0.46677803993225 / seconds
Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='7929'DB:business_master_new
loadtime:0.47028207778931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1
loadtime:0.47031903266907 / seconds
Query Executed:select id FROM `az` where city='Dewey' && SIC_code='7929'DB:business_master_new
loadtime:0.47092199325562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1
loadtime:0.47097110748291 / seconds
Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.47149705886841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.47154211997986 / seconds
Query Executed:select id FROM `az` where city='Douglas' && SIC_code='7929'DB:business_master_new
loadtime:0.47228503227234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1
loadtime:0.47233700752258 / seconds
Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='7929'DB:business_master_new
loadtime:0.47985792160034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.4799211025238 / seconds
Query Executed:select id FROM `az` where city='Duncan' && SIC_code='7929'DB:business_master_new
loadtime:0.48047304153442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1
loadtime:0.48051404953003 / seconds
Query Executed:select id FROM `az` where city='Eagar' && SIC_code='7929'DB:business_master_new
loadtime:0.48108911514282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.4811429977417 / seconds
Query Executed:select id FROM `az` where city='Eden' && SIC_code='7929'DB:business_master_new
loadtime:0.48273205757141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1
loadtime:0.48278498649597 / seconds
Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='7929'DB:business_master_new
loadtime:0.48365092277527 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1
loadtime:0.48372197151184 / seconds
Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='7929'DB:business_master_new
loadtime:0.48467111587524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1
loadtime:0.48476004600525 / seconds
Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='7929'DB:business_master_new
loadtime:0.48564100265503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.48572707176208 / seconds
Query Executed:select id FROM `az` where city='Elgin' && SIC_code='7929'DB:business_master_new
loadtime:0.49416899681091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1
loadtime:0.49421191215515 / seconds
Query Executed:select id FROM `az` where city='Eloy' && SIC_code='7929'DB:business_master_new
loadtime:0.49472904205322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1
loadtime:0.49477291107178 / seconds
Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='7929'DB:business_master_new
loadtime:0.49988913536072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.49999403953552 / seconds
Query Executed:select id FROM `az` where city='Florence' && SIC_code='7929'DB:business_master_new
loadtime:0.50093293190002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1
loadtime:0.50098490715027 / seconds
Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='7929'DB:business_master_new
loadtime:0.50710105895996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1
loadtime:0.50714206695557 / seconds
Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='7929'DB:business_master_new
loadtime:0.50824999809265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.50829792022705 / seconds
Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='7929'DB:business_master_new
loadtime:0.50914096832275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1
loadtime:0.50927996635437 / seconds
Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='7929'DB:business_master_new
loadtime:0.51020693778992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1
loadtime:0.51030397415161 / seconds
Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='7929'DB:business_master_new
loadtime:0.52030301094055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1
loadtime:0.52035808563232 / seconds
Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='7929'DB:business_master_new
loadtime:0.52126502990723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1
loadtime:0.52139902114868 / seconds
Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='7929'DB:business_master_new
loadtime:0.52847099304199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1
loadtime:0.52852201461792 / seconds
Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='7929'DB:business_master_new
loadtime:0.53025102615356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:0.53035306930542 / seconds
Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='7929'DB:business_master_new
loadtime:0.53141498565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.53155207633972 / seconds
Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='7929'DB:business_master_new
loadtime:0.53409695625305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1
loadtime:0.53414607048035 / seconds
Query Executed:select id FROM `az` where city='Ganado' && SIC_code='7929'DB:business_master_new
loadtime:0.53467297554016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1
loadtime:0.5346999168396 / seconds
Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='7929'DB:business_master_new
loadtime:0.53524994850159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.5353000164032 / seconds
Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='7929'DB:business_master_new
loadtime:0.53863000869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.53869199752808 / seconds
Query Executed:select id FROM `az` where city='Glendale' && SIC_code='7929'DB:business_master_new
loadtime:0.54202699661255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1
loadtime:0.54208302497864 / seconds
Query Executed:select id FROM `az` where city='Globe' && SIC_code='7929'DB:business_master_new
loadtime:0.54282307624817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1
loadtime:0.54287695884705 / seconds
Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.54344701766968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1
loadtime:0.54348492622375 / seconds
Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='7929'DB:business_master_new
loadtime:0.54678106307983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1
loadtime:0.54684209823608 / seconds
Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.5473780632019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1
loadtime:0.5474169254303 / seconds
Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='7929'DB:business_master_new
loadtime:0.54884791374207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:0.54889893531799 / seconds
Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.54961514472961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1
loadtime:0.54966306686401 / seconds
Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='7929'DB:business_master_new
loadtime:0.55130505561829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.55135297775269 / seconds
Query Executed:select id FROM `az` where city='Greer' && SIC_code='7929'DB:business_master_new
loadtime:0.55186295509338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1
loadtime:0.551913022995 / seconds
Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='7929'DB:business_master_new
loadtime:0.55441403388977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1
loadtime:0.5544581413269 / seconds
Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='7929'DB:business_master_new
loadtime:0.55584001541138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1
loadtime:0.55589008331299 / seconds
Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='7929'DB:business_master_new
loadtime:0.56494092941284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.56497597694397 / seconds
Query Executed:select id FROM `az` where city='Hayden' && SIC_code='7929'DB:business_master_new
loadtime:0.56548595428467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1
loadtime:0.56553602218628 / seconds
Query Executed:select id FROM `az` where city='Heber' && SIC_code='7929'DB:business_master_new
loadtime:0.56604695320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:0.56609892845154 / seconds
Query Executed:select id FROM `az` where city='Hereford' && SIC_code='7929'DB:business_master_new
loadtime:0.56665706634521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1
loadtime:0.56669902801514 / seconds
Query Executed:select id FROM `az` where city='Higley' && SIC_code='7929'DB:business_master_new
loadtime:0.56733393669128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:0.56737995147705 / seconds
Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='7929'DB:business_master_new
loadtime:0.56800293922424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1
loadtime:0.56805396080017 / seconds
Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='7929'DB:business_master_new
loadtime:0.57097411155701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1
loadtime:0.57101106643677 / seconds
Query Executed:select id FROM `az` where city='Houck' && SIC_code='7929'DB:business_master_new
loadtime:0.57636904716492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1
loadtime:0.57642102241516 / seconds
Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='7929'DB:business_master_new
loadtime:0.57702612876892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1
loadtime:0.57708191871643 / seconds
Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='7929'DB:business_master_new
loadtime:0.57914710044861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.57919812202454 / seconds
Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='7929'DB:business_master_new
loadtime:0.57972407341003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1
loadtime:0.57976698875427 / seconds
Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='7929'DB:business_master_new
loadtime:0.58250093460083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1
loadtime:0.58253598213196 / seconds
Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.5835599899292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:0.58362293243408 / seconds
Query Executed:select id FROM `az` where city='Jerome' && SIC_code='7929'DB:business_master_new
loadtime:0.5841429233551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1
loadtime:0.58419108390808 / seconds
Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='7929'DB:business_master_new
loadtime:0.5846951007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1
loadtime:0.58472990989685 / seconds
Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='7929'DB:business_master_new
loadtime:0.58699107170105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1
loadtime:0.58703994750977 / seconds
Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='7929'DB:business_master_new
loadtime:0.5873110294342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1
loadtime:0.58734703063965 / seconds
Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='7929'DB:business_master_new
loadtime:0.5878369808197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1
loadtime:0.58787608146667 / seconds
Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.5883800983429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:0.58842396736145 / seconds
Query Executed:select id FROM `az` where city='Kearny' && SIC_code='7929'DB:business_master_new
loadtime:0.59925103187561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:0.59928703308105 / seconds
Query Executed:select id FROM `az` where city='Kingman' && SIC_code='7929'DB:business_master_new
loadtime:0.60261106491089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:0.60266709327698 / seconds
Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='7929'DB:business_master_new
loadtime:0.60317206382751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1
loadtime:0.60322213172913 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='7929'DB:business_master_new
loadtime:0.61410999298096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1
loadtime:0.61415791511536 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='7929'DB:business_master_new
loadtime:0.61571598052979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1
loadtime:0.61575794219971 / seconds
Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='7929'DB:business_master_new
loadtime:0.61916613578796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1
loadtime:0.619225025177 / seconds
Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='7929'DB:business_master_new
loadtime:0.62977004051208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.6298189163208 / seconds
Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='7929'DB:business_master_new
loadtime:0.63045001029968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1
loadtime:0.63048601150513 / seconds
Query Executed:select id FROM `az` where city='Laveen' && SIC_code='7929'DB:business_master_new
loadtime:0.6311559677124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1
loadtime:0.63121509552002 / seconds
Query Executed:select id FROM `az` where city='Leupp' && SIC_code='7929'DB:business_master_new
loadtime:0.6363410949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1
loadtime:0.63638305664062 / seconds
Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='7929'DB:business_master_new
loadtime:0.63712692260742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1
loadtime:0.63718795776367 / seconds
Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='7929'DB:business_master_new
loadtime:0.63769006729126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1
loadtime:0.63772296905518 / seconds
Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='7929'DB:business_master_new
loadtime:0.6405770778656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1
loadtime:0.64064002037048 / seconds
Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='7929'DB:business_master_new
loadtime:0.64143013954163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1
loadtime:0.6415069103241 / seconds
Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='7929'DB:business_master_new
loadtime:0.64688801765442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:0.64692497253418 / seconds
Query Executed:select id FROM `az` where city='Lupton' && SIC_code='7929'DB:business_master_new
loadtime:0.65712213516235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1
loadtime:0.65717005729675 / seconds
Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.65749502182007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:0.65753102302551 / seconds
Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='7929'DB:business_master_new
loadtime:0.66224598884583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1
loadtime:0.66229510307312 / seconds
Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='7929'DB:business_master_new
loadtime:0.6679310798645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1
loadtime:0.66797208786011 / seconds
Query Executed:select id FROM `az` where city='Marana' && SIC_code='7929'DB:business_master_new
loadtime:0.66867208480835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1
loadtime:0.6687331199646 / seconds
Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='7929'DB:business_master_new
loadtime:0.67444801330566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1
loadtime:0.67449808120728 / seconds
Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='7929'DB:business_master_new
loadtime:0.67507696151733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1
loadtime:0.67513012886047 / seconds
Query Executed:select id FROM `az` where city='Mayer' && SIC_code='7929'DB:business_master_new
loadtime:0.67567992210388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1
loadtime:0.67571592330933 / seconds
Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='7929'DB:business_master_new
loadtime:0.676029920578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1
loadtime:0.67607998847961 / seconds
Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='7929'DB:business_master_new
loadtime:0.68813896179199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1
loadtime:0.68817496299744 / seconds
Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='7929'DB:business_master_new
loadtime:0.6923611164093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1
loadtime:0.69241213798523 / seconds
Query Executed:select id FROM `az` where city='Meadview' && SIC_code='7929'DB:business_master_new
loadtime:0.70508813858032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:0.70513510704041 / seconds
Query Executed:select id FROM `az` where city='Mesa' && SIC_code='7929'DB:business_master_new
loadtime:0.71050095558167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.71060800552368 / seconds
Query Executed:select id FROM `az` where city='Miami' && SIC_code='7929'DB:business_master_new
loadtime:0.71161007881165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1
loadtime:0.71167612075806 / seconds
Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.71261191368103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:0.7126989364624 / seconds
Query Executed:select id FROM `az` where city='Morenci' && SIC_code='7929'DB:business_master_new
loadtime:0.71355605125427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1
loadtime:0.71360611915588 / seconds
Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='7929'DB:business_master_new
loadtime:0.71955800056458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.71962308883667 / seconds
Query Executed:select id FROM `az` where city='Morristown' && SIC_code='7929'DB:business_master_new
loadtime:0.7201521396637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1
loadtime:0.72019910812378 / seconds
Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='7929'DB:business_master_new
loadtime:0.72650194168091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1
loadtime:0.72655200958252 / seconds
Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='7929'DB:business_master_new
loadtime:0.72713804244995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1
loadtime:0.7271740436554 / seconds
Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='7929'DB:business_master_new
loadtime:0.72770404815674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1
loadtime:0.72774696350098 / seconds
Query Executed:select id FROM `az` where city='Naco' && SIC_code='7929'DB:business_master_new
loadtime:0.73775005340576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1
loadtime:0.73779296875 / seconds
Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='7929'DB:business_master_new
loadtime:0.73900604248047 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:0.73905801773071 / seconds
Query Executed:select id FROM `az` where city='New River' && SIC_code='7929'DB:business_master_new
loadtime:0.73960614204407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1
loadtime:0.7396559715271 / seconds
Query Executed:select id FROM `az` where city='Nogales' && SIC_code='7929'DB:business_master_new
loadtime:0.7406120300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1
loadtime:0.74064898490906 / seconds
Query Executed:select id FROM `az` where city='North Rim' && SIC_code='7929'DB:business_master_new
loadtime:0.74196195602417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1
loadtime:0.7420129776001 / seconds
Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='7929'DB:business_master_new
loadtime:0.74988293647766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1
loadtime:0.74992108345032 / seconds
Query Executed:select id FROM `az` where city='Oatman' && SIC_code='7929'DB:business_master_new
loadtime:0.76214814186096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1
loadtime:0.76219892501831 / seconds
Query Executed:select id FROM `az` where city='Oracle' && SIC_code='7929'DB:business_master_new
loadtime:0.76269292831421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1
loadtime:0.76273703575134 / seconds
Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.76321911811829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1
loadtime:0.76325511932373 / seconds
Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='7929'DB:business_master_new
loadtime:0.76375007629395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:0.76379299163818 / seconds
Query Executed:select id FROM `az` where city='Page' && SIC_code='7929'DB:business_master_new
loadtime:0.76446199417114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1
loadtime:0.76450800895691 / seconds
Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='7929'DB:business_master_new
loadtime:0.770024061203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1
loadtime:0.77006697654724 / seconds
Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.77101802825928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.77108001708984 / seconds
Query Executed:select id FROM `az` where city='Parker' && SIC_code='7929'DB:business_master_new
loadtime:0.77181196212769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1
loadtime:0.77185010910034 / seconds
Query Executed:select id FROM `az` where city='Parks' && SIC_code='7929'DB:business_master_new
loadtime:0.78166007995605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1
loadtime:0.78169703483582 / seconds
Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='7929'DB:business_master_new
loadtime:0.78203797340393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1
loadtime:0.78208994865417 / seconds
Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='7929'DB:business_master_new
loadtime:0.7826099395752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1
loadtime:0.7826509475708 / seconds
Query Executed:select id FROM `az` where city='Paulden' && SIC_code='7929'DB:business_master_new
loadtime:0.78315091133118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.78319501876831 / seconds
Query Executed:select id FROM `az` where city='Payson' && SIC_code='7929'DB:business_master_new
loadtime:0.78421592712402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1
loadtime:0.784264087677 / seconds
Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='7929'DB:business_master_new
loadtime:0.78477001190186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1
loadtime:0.78480505943298 / seconds
Query Executed:select id FROM `az` where city='Pearce' && SIC_code='7929'DB:business_master_new
loadtime:0.78532695770264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1
loadtime:0.78538012504578 / seconds
Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.78566312789917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1
loadtime:0.78569197654724 / seconds
Query Executed:select id FROM `az` where city='Peoria' && SIC_code='7929'DB:business_master_new
loadtime:0.7890031337738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1
loadtime:0.78906512260437 / seconds
Query Executed:select id FROM `az` where city='Peridot' && SIC_code='7929'DB:business_master_new
loadtime:0.79930806159973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1
loadtime:0.79935097694397 / seconds
Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='7929'DB:business_master_new
loadtime:0.79967403411865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1
loadtime:0.7997190952301 / seconds
Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='7929'DB:business_master_new
loadtime:0.80171608924866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:0.80176305770874 / seconds
Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='7929'DB:business_master_new
loadtime:0.80523204803467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.80536913871765 / seconds
Query Executed:select id FROM `az` where city='Picacho' && SIC_code='7929'DB:business_master_new
loadtime:0.80794095993042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1
loadtime:0.80798196792603 / seconds
Query Executed:select id FROM `az` where city='Pima' && SIC_code='7929'DB:business_master_new
loadtime:0.80869913101196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:0.80878710746765 / seconds
Query Executed:select id FROM `az` where city='Pine' && SIC_code='7929'DB:business_master_new
loadtime:0.80971312522888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:0.80976390838623 / seconds
Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='7929'DB:business_master_new
loadtime:0.81368708610535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1
loadtime:0.81372904777527 / seconds
Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='7929'DB:business_master_new
loadtime:0.81436109542847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.81441211700439 / seconds
Query Executed:select id FROM `az` where city='Pinon' && SIC_code='7929'DB:business_master_new
loadtime:0.82157111167908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1
loadtime:0.82162499427795 / seconds
Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='7929'DB:business_master_new
loadtime:0.82770895957947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1
loadtime:0.8277599811554 / seconds
Query Executed:select id FROM `az` where city='Polacca' && SIC_code='7929'DB:business_master_new
loadtime:0.83493208885193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1
loadtime:0.83496809005737 / seconds
Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='7929'DB:business_master_new
loadtime:0.8377799987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1
loadtime:0.83783102035522 / seconds
Query Executed:select id FROM `az` where city='Portal' && SIC_code='7929'DB:business_master_new
loadtime:0.84087204933167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1
loadtime:0.84092307090759 / seconds
Query Executed:select id FROM `az` where city='Poston' && SIC_code='7929'DB:business_master_new
loadtime:0.84805011749268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:0.84810996055603 / seconds
Query Executed:select id FROM `az` where city='Prescott' && SIC_code='7929'DB:business_master_new
loadtime:0.851478099823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1
loadtime:0.85152912139893 / seconds
Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.85260796546936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1
loadtime:0.85266613960266 / seconds
Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='7929'DB:business_master_new
loadtime:0.85331606864929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1
loadtime:0.85336208343506 / seconds
Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='7929'DB:business_master_new
loadtime:0.85420298576355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1
loadtime:0.85425996780396 / seconds
Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='7929'DB:business_master_new
loadtime:0.85695505142212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1
loadtime:0.85700702667236 / seconds
Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.86187791824341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1
loadtime:0.86192107200623 / seconds
Query Executed:select id FROM `az` where city='Rillito' && SIC_code='7929'DB:business_master_new
loadtime:0.87291312217712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1
loadtime:0.87296104431152 / seconds
Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='7929'DB:business_master_new
loadtime:0.8735179901123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1
loadtime:0.87355494499207 / seconds
Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='7929'DB:business_master_new
loadtime:0.87417507171631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1
loadtime:0.87422394752502 / seconds
Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='7929'DB:business_master_new
loadtime:0.89176106452942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1
loadtime:0.89180994033813 / seconds
Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='7929'DB:business_master_new
loadtime:0.89548110961914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1
loadtime:0.89552211761475 / seconds
Query Executed:select id FROM `az` where city='Roll' && SIC_code='7929'DB:business_master_new
loadtime:0.90340900421143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.90345907211304 / seconds
Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='7929'DB:business_master_new
loadtime:0.90399408340454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1
loadtime:0.90404391288757 / seconds
Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='7929'DB:business_master_new
loadtime:0.90579795837402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1
loadtime:0.90584897994995 / seconds
Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='7929'DB:business_master_new
loadtime:0.91697406768799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:0.91701793670654 / seconds
Query Executed:select id FROM `az` where city='Safford' && SIC_code='7929'DB:business_master_new
loadtime:0.91780710220337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1
loadtime:0.9178581237793 / seconds
Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='7929'DB:business_master_new
loadtime:0.91842913627625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1
loadtime:0.9184730052948 / seconds
Query Executed:select id FROM `az` where city='Saint David' && SIC_code='7929'DB:business_master_new
loadtime:0.91901206970215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:0.91906213760376 / seconds
Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='7929'DB:business_master_new
loadtime:0.91964411735535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1
loadtime:0.91969394683838 / seconds
Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='7929'DB:business_master_new
loadtime:0.92721700668335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1
loadtime:0.92725801467896 / seconds
Query Executed:select id FROM `az` where city='Salome' && SIC_code='7929'DB:business_master_new
loadtime:0.92779612541199 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1
loadtime:0.92784309387207 / seconds
Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='7929'DB:business_master_new
loadtime:0.9283721446991 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:0.92841911315918 / seconds
Query Executed:select id FROM `az` where city='San Luis' && SIC_code='7929'DB:business_master_new
loadtime:0.92897796630859 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1
loadtime:0.92902994155884 / seconds
Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='7929'DB:business_master_new
loadtime:0.9454870223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1
loadtime:0.94552206993103 / seconds
Query Executed:select id FROM `az` where city='San Simon' && SIC_code='7929'DB:business_master_new
loadtime:0.94605708122253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1
loadtime:0.94609808921814 / seconds
Query Executed:select id FROM `az` where city='Sanders' && SIC_code='7929'DB:business_master_new
loadtime:0.946622133255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1
loadtime:0.94665598869324 / seconds
Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='7929'DB:business_master_new
loadtime:0.95271897315979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1
loadtime:0.95277094841003 / seconds
Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='7929'DB:business_master_new
loadtime:0.95899105072021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1
loadtime:0.95906805992126 / seconds
Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='7929'DB:business_master_new
loadtime:0.97072291374207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1
loadtime:0.97077703475952 / seconds
Query Executed:select id FROM `az` where city='Sedona' && SIC_code='7929'DB:business_master_new
loadtime:0.97412395477295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1
loadtime:0.97418713569641 / seconds
Query Executed:select id FROM `az` where city='Seligman' && SIC_code='7929'DB:business_master_new
loadtime:0.97472095489502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1
loadtime:0.97476196289062 / seconds
Query Executed:select id FROM `az` where city='Sells' && SIC_code='7929'DB:business_master_new
loadtime:0.97529911994934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1
loadtime:0.9753360748291 / seconds
Query Executed:select id FROM `az` where city='Shonto' && SIC_code='7929'DB:business_master_new
loadtime:0.97932195663452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1
loadtime:0.97937202453613 / seconds
Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='7929'DB:business_master_new
loadtime:0.97968792915344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1
loadtime:0.97971606254578 / seconds
Query Executed:select id FROM `az` where city='Show Low' && SIC_code='7929'DB:business_master_new
loadtime:0.98051309585571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1
loadtime:0.98056197166443 / seconds
Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='7929'DB:business_master_new
loadtime:0.98394799232483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1
loadtime:0.98400211334229 / seconds
Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='7929'DB:business_master_new
loadtime:0.99292612075806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1
loadtime:0.99297714233398 / seconds
Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='7929'DB:business_master_new
loadtime:0.99357104301453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:0.99363112449646 / seconds
Query Executed:select id FROM `az` where city='Solomon' && SIC_code='7929'DB:business_master_new
loadtime:1.0000069141388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1
loadtime:1.0000579357147 / seconds
Query Executed:select id FROM `az` where city='Somerton' && SIC_code='7929'DB:business_master_new
loadtime:1.0006110668182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1
loadtime:1.0006611347198 / seconds
Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='7929'DB:business_master_new
loadtime:1.0011811256409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1
loadtime:1.0012180805206 / seconds
Query Executed:select id FROM `az` where city='Springerville' && SIC_code='7929'DB:business_master_new
loadtime:1.0018129348755 / seconds
Query loaded from cache:select * from geodata_geocity where city='St David' limit 1
loadtime:1.0018570423126 / seconds
Query Executed:select id FROM `az` where city='St David' && SIC_code='7929'DB:business_master_new
loadtime:1.0023279190063 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:1.0024070739746 / seconds
Query Executed:select id FROM `az` where city='St Johns' && SIC_code='7929'DB:business_master_new
loadtime:1.0045669078827 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1
loadtime:1.0046229362488 / seconds
Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='7929'DB:business_master_new
loadtime:1.0111911296844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:1.0112400054932 / seconds
Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='7929'DB:business_master_new
loadtime:1.0204410552979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1
loadtime:1.0204930305481 / seconds
Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='7929'DB:business_master_new
loadtime:1.027312040329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:1.0273599624634 / seconds
Query Executed:select id FROM `az` where city='Sun City' && SIC_code='7929'DB:business_master_new
loadtime:1.0288999080658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1
loadtime:1.0290031433105 / seconds
Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='7929'DB:business_master_new
loadtime:1.0300841331482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1
loadtime:1.0301280021667 / seconds
Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='7929'DB:business_master_new
loadtime:1.0341670513153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1
loadtime:1.0342490673065 / seconds
Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='7929'DB:business_master_new
loadtime:1.037929058075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1
loadtime:1.0379900932312 / seconds
Query Executed:select id FROM `az` where city='Supai' && SIC_code='7929'DB:business_master_new
loadtime:1.0457639694214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:1.0458171367645 / seconds
Query Executed:select id FROM `az` where city='Superior' && SIC_code='7929'DB:business_master_new
loadtime:1.0554099082947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1
loadtime:1.0554449558258 / seconds
Query Executed:select id FROM `az` where city='Surprise' && SIC_code='7929'DB:business_master_new
loadtime:1.0609860420227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1
loadtime:1.0610909461975 / seconds
Query Executed:select id FROM `az` where city='Tacna' && SIC_code='7929'DB:business_master_new
loadtime:1.0691421031952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:1.0691909790039 / seconds
Query Executed:select id FROM `az` where city='Taylor' && SIC_code='7929'DB:business_master_new
loadtime:1.0699610710144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1
loadtime:1.0700581073761 / seconds
Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='7929'DB:business_master_new
loadtime:1.0814809799194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1
loadtime:1.0815169811249 / seconds
Query Executed:select id FROM `az` where city='Tempe' && SIC_code='7929'DB:business_master_new
loadtime:1.0848751068115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1
loadtime:1.0849530696869 / seconds
Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='7929'DB:business_master_new
loadtime:1.0857830047607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1
loadtime:1.085813999176 / seconds
Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='7929'DB:business_master_new
loadtime:1.0866029262543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1
loadtime:1.0867009162903 / seconds
Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='7929'DB:business_master_new
loadtime:1.0878019332886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1
loadtime:1.0878660678864 / seconds
Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='7929'DB:business_master_new
loadtime:1.0889830589294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1
loadtime:1.0890839099884 / seconds
Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='7929'DB:business_master_new
loadtime:1.0947549343109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1
loadtime:1.0947971343994 / seconds
Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='7929'DB:business_master_new
loadtime:1.0953290462494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1
loadtime:1.0953769683838 / seconds
Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='7929'DB:business_master_new
loadtime:1.0959041118622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1
loadtime:1.0959539413452 / seconds
Query Executed:select id FROM `az` where city='Topawa' && SIC_code='7929'DB:business_master_new
loadtime:1.0966989994049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1
loadtime:1.0967359542847 / seconds
Query Executed:select id FROM `az` where city='Topock' && SIC_code='7929'DB:business_master_new
loadtime:1.0972409248352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1
loadtime:1.0972950458527 / seconds
Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='7929'DB:business_master_new
loadtime:1.0990090370178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1
loadtime:1.0990459918976 / seconds
Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='7929'DB:business_master_new
loadtime:1.1046459674835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1
loadtime:1.1046960353851 / seconds
Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='7929'DB:business_master_new
loadtime:1.1052529811859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1
loadtime:1.1052889823914 / seconds
Query Executed:select id FROM `az` where city='Tubac' && SIC_code='7929'DB:business_master_new
loadtime:1.1057929992676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1
loadtime:1.1058330535889 / seconds
Query Executed:select id FROM `az` where city='Tucson' && SIC_code='7929'DB:business_master_new
loadtime:1.110955953598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1
loadtime:1.1110551357269 / seconds
Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='7929'DB:business_master_new
loadtime:1.1115710735321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:1.1116240024567 / seconds
Query Executed:select id FROM `az` where city='Vail' && SIC_code='7929'DB:business_master_new
loadtime:1.1122190952301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1
loadtime:1.1122789382935 / seconds
Query Executed:select id FROM `az` where city='Valentine' && SIC_code='7929'DB:business_master_new
loadtime:1.1136059761047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1
loadtime:1.1136600971222 / seconds
Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='7929'DB:business_master_new
loadtime:1.1154420375824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:1.1155319213867 / seconds
Query Executed:select id FROM `az` where city='Vernon' && SIC_code='7929'DB:business_master_new
loadtime:1.1163709163666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1
loadtime:1.1164350509644 / seconds
Query Executed:select id FROM `az` where city='Waddell' && SIC_code='7929'DB:business_master_new
loadtime:1.1173849105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1
loadtime:1.1174719333649 / seconds
Query Executed:select id FROM `az` where city='Wellton' && SIC_code='7929'DB:business_master_new
loadtime:1.1183559894562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1
loadtime:1.1184260845184 / seconds
Query Executed:select id FROM `az` where city='Wenden' && SIC_code='7929'DB:business_master_new
loadtime:1.1192860603333 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1
loadtime:1.1193759441376 / seconds
Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='7929'DB:business_master_new
loadtime:1.1238350868225 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1
loadtime:1.1238830089569 / seconds
Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='7929'DB:business_master_new
loadtime:1.1242160797119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1
loadtime:1.1242680549622 / seconds
Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='7929'DB:business_master_new
loadtime:1.1247780323029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Why' limit 1
loadtime:1.1248199939728 / seconds
Query Executed:select id FROM `az` where city='Why' && SIC_code='7929'DB:business_master_new
loadtime:1.1254100799561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1
loadtime:1.1254529953003 / seconds
Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='7929'DB:business_master_new
loadtime:1.1262049674988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1
loadtime:1.1262619495392 / seconds
Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='7929'DB:business_master_new
loadtime:1.1321671009064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1
loadtime:1.1322040557861 / seconds
Query Executed:select id FROM `az` where city='Willcox' && SIC_code='7929'DB:business_master_new
loadtime:1.1329190731049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:1.1329779624939 / seconds
Query Executed:select id FROM `az` where city='Williams' && SIC_code='7929'DB:business_master_new
loadtime:1.1336050033569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1
loadtime:1.1336541175842 / seconds
Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='7929'DB:business_master_new
loadtime:1.1356439590454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1
loadtime:1.1356790065765 / seconds
Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='7929'DB:business_master_new
loadtime:1.1363089084625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1
loadtime:1.1363620758057 / seconds
Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='7929'DB:business_master_new
loadtime:1.136883020401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:1.1369340419769 / seconds
Query Executed:select id FROM `az` where city='Winslow' && SIC_code='7929'DB:business_master_new
loadtime:1.1376121044159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1
loadtime:1.1376490592957 / seconds
Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='7929'DB:business_master_new
loadtime:1.1381590366364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:1.1382100582123 / seconds
Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='7929'DB:business_master_new
loadtime:1.1396141052246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1
loadtime:1.1398940086365 / seconds
Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='7929'DB:business_master_new
loadtime:1.1404321193695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Young' limit 1
loadtime:1.1404781341553 / seconds
Query Executed:select id FROM `az` where city='Young' && SIC_code='7929'DB:business_master_new
loadtime:1.1409869194031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1
loadtime:1.1410229206085 / seconds
Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='7929'DB:business_master_new
loadtime:1.1415939331055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1
loadtime:1.1416449546814 / seconds
Query Executed:select id FROM `az` where city='Yucca' && SIC_code='7929'DB:business_master_new
loadtime:1.1454749107361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:1.1455230712891 / seconds
Query Executed:select id FROM `az` where city='Yuma' && SIC_code='7929'DB:business_master_new
loadtime:1.1488010883331 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.1488890647888 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.1490650177002 / seconds
Operation template executed (chunk cache operation)
loadtime:1.1491460800171 / seconds
template override:Default
loadtime:1.1491649150848 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.1500189304352 / seconds
Template Constructed, Array Rows:49
loadtime:1.15025806427 / seconds
TOTAL EXECUTION TIME: 1.15007
loadtime:1.1503620147705 / 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:1.1503670215607
TOTAL KEY ARRAYS: 69