DEVELOPER MODE ENABLED |
OPERATIONS DATA/LOADTIME cache not set compiling loadtime:4.1007995605469E-5 / seconds DB connected to localhost ezrox_toadli loadtime:0.00036311149597168 / seconds host not found setting manual db connection loadtime:0.00079011917114258 / seconds DB connected to localhost ezrox_toadli loadtime:0.00098395347595215 / seconds Query Executed:select * from general_settings where id=1DB:ezrox_toadli loadtime:0.0011379718780518 / seconds Query loaded from cache:select * from image_settings where id=1 loadtime:0.0012071132659912 / seconds zipcode: loadtime:0.0012919902801514 / seconds Query Executed:select * from search_referrer where page_hash='d346b6b496161812ebbf527735dc2dcd' limit 10 DB:ezrox_toadli loadtime:0.0015480518341064 / seconds Operation header executed (non global) loadtime:0.0015909671783447 / seconds Operation leaderboard executed (non global) loadtime:0.0016591548919678 / seconds Operation square executed (non global) loadtime:0.0016939640045166 / seconds Operation square_bottom executed (non global) loadtime:0.0017340183258057 / seconds Operation smallsquare executed (non global) loadtime:0.0017690658569336 / seconds Operation headeradright executed (non global) loadtime:0.0018031597137451 / seconds Operation google_analytics executed (non global) loadtime:0.0018351078033447 / seconds Operation topstories executed (non global) loadtime:0.0018680095672607 / seconds Operation businessnearyou executed (non global) loadtime:0.0019011497497559 / seconds Operation memberbuscount executed (non global) loadtime:0.0019321441650391 / seconds DB connected to localhost ezrox_toadli loadtime:0.0021660327911377 / seconds Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli loadtime:0.0023071765899658 / seconds Operation categories executed (global stored into APC) loadtime:0.0023691654205322 / seconds Operation categories_menu executed (global stored into APC) loadtime:0.0024621486663818 / seconds Operation archive_menu using avail. global APC cache loadtime:0.002514123916626 / seconds Template key: archive_menu pushed loadtime:0.0025191307067871 / seconds Operation get_gravatar using avail. global APC cache loadtime:0.0025250911712646 / seconds Template key: get_gravatar pushed loadtime:0.0025291442871094 / seconds Operation directorystate executed (chunk cache operation) loadtime:0.0025320053100586 / seconds *10)-10)+1 | start:0 loadtime:0.0026421546936035 / seconds Query loaded from cache:select * from categories where cat_URLid='general-contractors-single-family-houses' loadtime:0.0026769638061523 / seconds Query loaded from cache:select * from geodata_usstates where url_id='arizona' loadtime:0.0027260780334473 / seconds DB connected to localhost business_master_new loadtime:0.0030100345611572 / seconds Query Executed:select * from `az_catmap` where sic='1521' order by city ascDB:business_master_new loadtime:0.090868949890137 / seconds Query stored in cache : _QUERY_www.toadli.coma561af56f7665e4e496159f0f455b8f9 loadtime:0.092144966125488 / seconds Query loaded from cache:select * from geodata_usstates where url_id='arizona' loadtime:0.092234134674072 / seconds Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='1521'DB:business_master_new loadtime:0.096968173980713 / seconds Query stored in cache : _QUERY_www.toadli.com2da1afbc116d97ca57e9a54cee87332c loadtime:0.097053050994873 / seconds 287 / 11 loadtime:0.097866058349609 / seconds Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1 loadtime:0.098497152328491 / seconds Query Executed:select id FROM `az` where city='Aguila' && SIC_code='1521'DB:business_master_new loadtime:0.11770701408386 / seconds Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1 loadtime:0.1178560256958 / seconds Query Executed:select id FROM `az` where city='Ajo' && SIC_code='1521'DB:business_master_new loadtime:0.1226601600647 / seconds Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1 loadtime:0.12278509140015 / seconds Query Executed:select id FROM `az` where city='Alpine' && SIC_code='1521'DB:business_master_new loadtime:0.13647794723511 / seconds Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1 loadtime:0.13660597801208 / seconds Query Executed:select id FROM `az` where city='Amado' && SIC_code='1521'DB:business_master_new loadtime:0.15068817138672 / seconds Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1 loadtime:0.15081214904785 / seconds Query Executed:select id FROM `az` where city='Anthem' && SIC_code='1521'DB:business_master_new loadtime:0.15533709526062 / seconds Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1 loadtime:0.15546894073486 / seconds Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='1521'DB:business_master_new loadtime:0.16972303390503 / seconds Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1 loadtime:0.17016410827637 / seconds Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='1521'DB:business_master_new loadtime:0.18107008934021 / seconds Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1 loadtime:0.18115496635437 / seconds Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='1521'DB:business_master_new loadtime:0.19597315788269 / seconds Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1 loadtime:0.19612598419189 / seconds Query Executed:select id FROM `az` where city='Arlington' && SIC_code='1521'DB:business_master_new loadtime:0.2060079574585 / seconds Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1 loadtime:0.20614194869995 / seconds Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='1521'DB:business_master_new loadtime:0.22361612319946 / seconds Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1 loadtime:0.22369599342346 / seconds Query Executed:select id FROM `az` where city='Avondale' && SIC_code='1521'DB:business_master_new loadtime:0.23993611335754 / seconds Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1 loadtime:0.24006700515747 / seconds Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='1521'DB:business_master_new loadtime:0.25462412834167 / seconds Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1 loadtime:0.25487399101257 / seconds Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='1521'DB:business_master_new loadtime:0.25613808631897 / seconds Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1 loadtime:0.25659894943237 / seconds Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='1521'DB:business_master_new loadtime:0.26530814170837 / seconds Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1 loadtime:0.2655930519104 / seconds Query Executed:select id FROM `az` where city='Benson' && SIC_code='1521'DB:business_master_new loadtime:0.27653694152832 / seconds Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1 loadtime:0.27669501304626 / seconds Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='1521'DB:business_master_new loadtime:0.28220915794373 / seconds Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1 loadtime:0.28236508369446 / seconds Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='1521'DB:business_master_new loadtime:0.3086211681366 / seconds Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1 loadtime:0.308758020401 / seconds Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='1521'DB:business_master_new loadtime:0.3097939491272 / seconds Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1 loadtime:0.30985713005066 / seconds Query Executed:select id FROM `az` where city='Blue' && SIC_code='1521'DB:business_master_new loadtime:0.31230616569519 / seconds Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1 loadtime:0.31239414215088 / seconds Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='1521'DB:business_master_new loadtime:0.31360507011414 / seconds Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1 loadtime:0.31367611885071 / seconds Query Executed:select id FROM `az` where city='Bouse' && SIC_code='1521'DB:business_master_new loadtime:0.32154011726379 / seconds Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1 loadtime:0.32163500785828 / seconds Query Executed:select id FROM `az` where city='Bowie' && SIC_code='1521'DB:business_master_new loadtime:0.333829164505 / seconds Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1 loadtime:0.33391308784485 / seconds Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='1521'DB:business_master_new loadtime:0.34197807312012 / seconds Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1 loadtime:0.34211111068726 / seconds Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='1521'DB:business_master_new loadtime:0.3598301410675 / seconds Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1 loadtime:0.36001515388489 / seconds Query Executed:select id FROM `az` where city='Bylas' && SIC_code='1521'DB:business_master_new loadtime:0.3634660243988 / seconds Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1 loadtime:0.3635470867157 / seconds Query Executed:select id FROM `az` where city='Cameron' && SIC_code='1521'DB:business_master_new loadtime:0.37207412719727 / seconds Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1 loadtime:0.37215805053711 / seconds Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='1521'DB:business_master_new loadtime:0.38647508621216 / seconds Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1 loadtime:0.38662505149841 / seconds Query Executed:select id FROM `az` where city='Carefree' && SIC_code='1521'DB:business_master_new loadtime:0.40000295639038 / seconds Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1 loadtime:0.40014410018921 / seconds Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='1521'DB:business_master_new loadtime:0.41035103797913 / seconds Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1 loadtime:0.41053104400635 / seconds Query Executed:select id FROM `az` where city='Cashion' && SIC_code='1521'DB:business_master_new loadtime:0.42179608345032 / seconds Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1 loadtime:0.42188405990601 / seconds Query Executed:select id FROM `az` where city='Catalina' && SIC_code='1521'DB:business_master_new loadtime:0.4318540096283 / seconds Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1 loadtime:0.43198609352112 / seconds Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='1521'DB:business_master_new loadtime:0.45248603820801 / seconds Query loaded from cache:select * from geodata_geocity where city='Central' limit 1 loadtime:0.45265007019043 / seconds Query Executed:select id FROM `az` where city='Central' && SIC_code='1521'DB:business_master_new loadtime:0.45706009864807 / seconds Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1 loadtime:0.45714902877808 / seconds Query Executed:select id FROM `az` where city='Chambers' && SIC_code='1521'DB:business_master_new loadtime:0.46554112434387 / seconds Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1 loadtime:0.46565699577332 / seconds Query Executed:select id FROM `az` where city='Chandler' && SIC_code='1521'DB:business_master_new loadtime:0.53894710540771 / seconds Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1 loadtime:0.53920698165894 / seconds Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='1521'DB:business_master_new loadtime:0.54680299758911 / seconds Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1 loadtime:0.54721903800964 / seconds Query Executed:select id FROM `az` where city='Chinle' && SIC_code='1521'DB:business_master_new loadtime:0.55128812789917 / seconds Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1 loadtime:0.55144214630127 / seconds Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='1521'DB:business_master_new loadtime:0.58031105995178 / seconds Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1 loadtime:0.58052897453308 / seconds Query Executed:select id FROM `az` where city='Chloride' && SIC_code='1521'DB:business_master_new loadtime:0.58448100090027 / seconds Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1 loadtime:0.58455300331116 / seconds Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='1521'DB:business_master_new loadtime:0.58710408210754 / seconds Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1 loadtime:0.58718609809875 / seconds Query Executed:select id FROM `az` where city='Cibola' && SIC_code='1521'DB:business_master_new loadtime:0.58973217010498 / seconds Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1 loadtime:0.58980512619019 / seconds Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='1521'DB:business_master_new loadtime:0.6328501701355 / seconds Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1 loadtime:0.63324403762817 / seconds Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='1521'DB:business_master_new loadtime:0.63772797584534 / seconds Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1 loadtime:0.6378321647644 / seconds Query Executed:select id FROM `az` where city='Claypool' && SIC_code='1521'DB:business_master_new loadtime:0.6682391166687 / seconds Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1 loadtime:0.66833400726318 / seconds Query Executed:select id FROM `az` where city='Clifton' && SIC_code='1521'DB:business_master_new loadtime:0.70291113853455 / seconds Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1 loadtime:0.70309209823608 / seconds Query Executed:select id FROM `az` where city='Cochise' && SIC_code='1521'DB:business_master_new loadtime:0.72581601142883 / seconds Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1 loadtime:0.7261700630188 / seconds Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='1521'DB:business_master_new loadtime:0.75639700889587 / seconds Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1 loadtime:0.75691795349121 / seconds Query Executed:select id FROM `az` where city='Concho' && SIC_code='1521'DB:business_master_new loadtime:0.76479196548462 / seconds Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1 loadtime:0.76488208770752 / seconds Query Executed:select id FROM `az` where city='Congress' && SIC_code='1521'DB:business_master_new loadtime:0.7752411365509 / seconds Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1 loadtime:0.77566814422607 / seconds Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='1521'DB:business_master_new loadtime:0.81934309005737 / seconds Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1 loadtime:0.81972813606262 / seconds Query Executed:select id FROM `az` where city='Cornville' && SIC_code='1521'DB:business_master_new loadtime:0.85948395729065 / seconds Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1 loadtime:0.8596351146698 / seconds Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='1521'DB:business_master_new loadtime:0.87177896499634 / seconds Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1 loadtime:0.87191700935364 / seconds Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='1521'DB:business_master_new loadtime:0.88549613952637 / seconds Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1 loadtime:0.88566112518311 / seconds Query Executed:select id FROM `az` where city='Crown King' && SIC_code='1521'DB:business_master_new loadtime:0.8879771232605 / seconds Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1 loadtime:0.88811111450195 / seconds Query Executed:select id FROM `az` where city='Dateland' && SIC_code='1521'DB:business_master_new loadtime:0.89092898368835 / seconds Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1 loadtime:0.89101600646973 / seconds Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='1521'DB:business_master_new loadtime:0.8920521736145 / seconds Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1 loadtime:0.89213609695435 / seconds Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='1521'DB:business_master_new loadtime:0.8937771320343 / seconds Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1 loadtime:0.89386105537415 / seconds Query Executed:select id FROM `az` where city='Dewey' && SIC_code='1521'DB:business_master_new loadtime:0.90196895599365 / seconds Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1 loadtime:0.90209603309631 / seconds Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='1521'DB:business_master_new loadtime:0.910973072052 / seconds Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1 loadtime:0.91110610961914 / seconds Query Executed:select id FROM `az` where city='Douglas' && SIC_code='1521'DB:business_master_new loadtime:0.91758513450623 / seconds Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1 loadtime:0.91770815849304 / seconds Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='1521'DB:business_master_new loadtime:0.92496013641357 / seconds Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1 loadtime:0.92504906654358 / seconds Query Executed:select id FROM `az` where city='Duncan' && SIC_code='1521'DB:business_master_new loadtime:0.95113801956177 / seconds Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1 loadtime:0.9512779712677 / seconds Query Executed:select id FROM `az` where city='Eagar' && SIC_code='1521'DB:business_master_new loadtime:0.99755001068115 / seconds Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1 loadtime:0.9979350566864 / seconds Query Executed:select id FROM `az` where city='Eden' && SIC_code='1521'DB:business_master_new loadtime:0.99965596199036 / seconds Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1 loadtime:0.99986696243286 / seconds Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='1521'DB:business_master_new loadtime:1.0257740020752 / seconds Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1 loadtime:1.0259871482849 / seconds Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='1521'DB:business_master_new loadtime:1.034285068512 / seconds Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1 loadtime:1.0344791412354 / seconds Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='1521'DB:business_master_new loadtime:1.0592470169067 / seconds Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1 loadtime:1.059326171875 / seconds Query Executed:select id FROM `az` where city='Elgin' && SIC_code='1521'DB:business_master_new loadtime:1.0644080638885 / seconds Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1 loadtime:1.0645589828491 / seconds Query Executed:select id FROM `az` where city='Eloy' && SIC_code='1521'DB:business_master_new loadtime:1.0849900245667 / seconds Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1 loadtime:1.0851211547852 / seconds Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='1521'DB:business_master_new loadtime:1.1284019947052 / seconds Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1 loadtime:1.1290099620819 / seconds Query Executed:select id FROM `az` where city='Florence' && SIC_code='1521'DB:business_master_new loadtime:1.1439981460571 / seconds Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1 loadtime:1.1441860198975 / seconds Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='1521'DB:business_master_new loadtime:1.1478550434113 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1 loadtime:1.1479361057281 / seconds Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='1521'DB:business_master_new loadtime:1.1498291492462 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1 loadtime:1.1499080657959 / seconds Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='1521'DB:business_master_new loadtime:1.1669330596924 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1 loadtime:1.1670610904694 / seconds Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='1521'DB:business_master_new loadtime:1.1901450157166 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1 loadtime:1.1906931400299 / seconds Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='1521'DB:business_master_new loadtime:1.1972789764404 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1 loadtime:1.1977691650391 / seconds Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='1521'DB:business_master_new loadtime:1.2068519592285 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1 loadtime:1.2072551250458 / seconds Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='1521'DB:business_master_new loadtime:1.2118389606476 / seconds Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1 loadtime:1.2121200561523 / seconds Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='1521'DB:business_master_new loadtime:1.2368700504303 / seconds Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1 loadtime:1.2370829582214 / seconds Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='1521'DB:business_master_new loadtime:1.2549130916595 / seconds Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1 loadtime:1.2554020881653 / seconds Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='1521'DB:business_master_new loadtime:1.2567479610443 / seconds Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1 loadtime:1.2568571567535 / seconds Query Executed:select id FROM `az` where city='Ganado' && SIC_code='1521'DB:business_master_new loadtime:1.2746419906616 / seconds Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1 loadtime:1.2747330665588 / seconds Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='1521'DB:business_master_new loadtime:1.3024439811707 / seconds Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1 loadtime:1.3025870323181 / seconds Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='1521'DB:business_master_new loadtime:1.3468160629272 / seconds Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1 loadtime:1.3471021652222 / seconds Query Executed:select id FROM `az` where city='Glendale' && SIC_code='1521'DB:business_master_new loadtime:1.4101350307465 / seconds Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1 loadtime:1.4104771614075 / seconds Query Executed:select id FROM `az` where city='Globe' && SIC_code='1521'DB:business_master_new loadtime:1.4169130325317 / seconds Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1 loadtime:1.4175391197205 / seconds Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='1521'DB:business_master_new loadtime:1.4208810329437 / seconds Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1 loadtime:1.4213850498199 / seconds Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='1521'DB:business_master_new loadtime:1.4302899837494 / seconds Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1 loadtime:1.430673122406 / seconds Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='1521'DB:business_master_new loadtime:1.446799993515 / seconds Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1 loadtime:1.4471709728241 / seconds Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='1521'DB:business_master_new loadtime:1.4490880966187 / seconds Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1 loadtime:1.4493191242218 / seconds Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='1521'DB:business_master_new loadtime:1.4618430137634 / seconds Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1 loadtime:1.462249994278 / seconds Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='1521'DB:business_master_new loadtime:1.4640710353851 / seconds Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1 loadtime:1.4643321037292 / seconds Query Executed:select id FROM `az` where city='Greer' && SIC_code='1521'DB:business_master_new loadtime:1.4751441478729 / seconds Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1 loadtime:1.475396156311 / seconds Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='1521'DB:business_master_new loadtime:1.4779059886932 / seconds Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1 loadtime:1.4779920578003 / seconds Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='1521'DB:business_master_new loadtime:1.4788410663605 / seconds Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1 loadtime:1.4789099693298 / seconds Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='1521'DB:business_master_new loadtime:1.4837090969086 / seconds Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1 loadtime:1.4838361740112 / seconds Query Executed:select id FROM `az` where city='Hayden' && SIC_code='1521'DB:business_master_new loadtime:1.4908871650696 / seconds Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1 loadtime:1.4910280704498 / seconds Query Executed:select id FROM `az` where city='Heber' && SIC_code='1521'DB:business_master_new loadtime:1.500167131424 / seconds Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1 loadtime:1.500293970108 / seconds Query Executed:select id FROM `az` where city='Hereford' && SIC_code='1521'DB:business_master_new loadtime:1.5067970752716 / seconds Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1 loadtime:1.5069439411163 / seconds Query Executed:select id FROM `az` where city='Higley' && SIC_code='1521'DB:business_master_new loadtime:1.514436006546 / seconds Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1 loadtime:1.5145921707153 / seconds Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='1521'DB:business_master_new loadtime:1.5187449455261 / seconds Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1 loadtime:1.5188810825348 / seconds Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='1521'DB:business_master_new loadtime:1.5194880962372 / seconds Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1 loadtime:1.5195679664612 / seconds Query Executed:select id FROM `az` where city='Houck' && SIC_code='1521'DB:business_master_new loadtime:1.5215010643005 / seconds Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1 loadtime:1.5216281414032 / seconds Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='1521'DB:business_master_new loadtime:1.525829076767 / seconds Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1 loadtime:1.5259671211243 / seconds Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='1521'DB:business_master_new loadtime:1.5279550552368 / seconds Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1 loadtime:1.5280539989471 / seconds Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='1521'DB:business_master_new loadtime:1.5372400283813 / seconds Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1 loadtime:1.537367105484 / seconds Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='1521'DB:business_master_new loadtime:1.5384039878845 / seconds Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1 loadtime:1.5385081768036 / seconds Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='1521'DB:business_master_new loadtime:1.5388469696045 / seconds Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1 loadtime:1.5389280319214 / seconds Query Executed:select id FROM `az` where city='Jerome' && SIC_code='1521'DB:business_master_new loadtime:1.557718038559 / seconds Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1 loadtime:1.5578460693359 / seconds Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='1521'DB:business_master_new loadtime:1.5620069503784 / seconds Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1 loadtime:1.5621449947357 / seconds Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='1521'DB:business_master_new loadtime:1.563157081604 / seconds Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1 loadtime:1.5632309913635 / seconds Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='1521'DB:business_master_new loadtime:1.5635600090027 / seconds Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1 loadtime:1.5636210441589 / seconds Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='1521'DB:business_master_new loadtime:1.5797030925751 / seconds Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1 loadtime:1.5798420906067 / seconds Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='1521'DB:business_master_new loadtime:1.5845470428467 / seconds Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1 loadtime:1.5846829414368 / seconds Query Executed:select id FROM `az` where city='Kearny' && SIC_code='1521'DB:business_master_new loadtime:1.5885751247406 / seconds Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1 loadtime:1.588711977005 / seconds Query Executed:select id FROM `az` where city='Kingman' && SIC_code='1521'DB:business_master_new loadtime:1.6024131774902 / seconds Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1 loadtime:1.6028890609741 / seconds Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='1521'DB:business_master_new loadtime:1.6092801094055 / seconds Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1 loadtime:1.609678030014 / seconds Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='1521'DB:business_master_new loadtime:1.6170589923859 / seconds Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1 loadtime:1.6173360347748 / seconds Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='1521'DB:business_master_new loadtime:1.6189560890198 / seconds Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1 loadtime:1.6192531585693 / seconds Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='1521'DB:business_master_new loadtime:1.6567080020905 / seconds Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1 loadtime:1.6572630405426 / seconds Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='1521'DB:business_master_new loadtime:1.6638841629028 / seconds Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1 loadtime:1.664263010025 / seconds Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='1521'DB:business_master_new loadtime:1.6748790740967 / seconds Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1 loadtime:1.6752700805664 / seconds Query Executed:select id FROM `az` where city='Laveen' && SIC_code='1521'DB:business_master_new loadtime:1.6849989891052 / seconds Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1 loadtime:1.685467004776 / seconds Query Executed:select id FROM `az` where city='Leupp' && SIC_code='1521'DB:business_master_new loadtime:1.6928639411926 / seconds Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1 loadtime:1.6932239532471 / seconds Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='1521'DB:business_master_new loadtime:1.7068901062012 / seconds Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1 loadtime:1.70720911026 / seconds Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='1521'DB:business_master_new loadtime:1.7181751728058 / seconds Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1 loadtime:1.7184920310974 / seconds Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='1521'DB:business_master_new loadtime:1.7214910984039 / seconds Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1 loadtime:1.7217390537262 / seconds Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='1521'DB:business_master_new loadtime:1.7314910888672 / seconds Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1 loadtime:1.7319719791412 / seconds Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='1521'DB:business_master_new loadtime:1.7346651554108 / seconds Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1 loadtime:1.7349030971527 / seconds Query Executed:select id FROM `az` where city='Lupton' && SIC_code='1521'DB:business_master_new loadtime:1.7453601360321 / seconds Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1 loadtime:1.7457499504089 / seconds Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='1521'DB:business_master_new loadtime:1.7469439506531 / seconds Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1 loadtime:1.747162103653 / seconds Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='1521'DB:business_master_new loadtime:1.750125169754 / seconds Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1 loadtime:1.7503600120544 / seconds Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='1521'DB:business_master_new loadtime:1.7546491622925 / seconds Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1 loadtime:1.7549960613251 / seconds Query Executed:select id FROM `az` where city='Marana' && SIC_code='1521'DB:business_master_new loadtime:1.7656979560852 / seconds Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1 loadtime:1.7661080360413 / seconds Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='1521'DB:business_master_new loadtime:1.7681939601898 / seconds Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1 loadtime:1.7684149742126 / seconds Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='1521'DB:business_master_new loadtime:1.7759959697723 / seconds Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1 loadtime:1.7761831283569 / seconds Query Executed:select id FROM `az` where city='Mayer' && SIC_code='1521'DB:business_master_new loadtime:1.8036391735077 / seconds Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1 loadtime:1.8039951324463 / seconds Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='1521'DB:business_master_new loadtime:1.8050539493561 / seconds Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1 loadtime:1.8053171634674 / seconds Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='1521'DB:business_master_new loadtime:1.8123631477356 / seconds Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1 loadtime:1.8126530647278 / seconds Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='1521'DB:business_master_new loadtime:1.815906047821 / seconds Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1 loadtime:1.8161699771881 / seconds Query Executed:select id FROM `az` where city='Meadview' && SIC_code='1521'DB:business_master_new loadtime:1.8217830657959 / seconds Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1 loadtime:1.8221070766449 / seconds Query Executed:select id FROM `az` where city='Mesa' && SIC_code='1521'DB:business_master_new loadtime:1.9152030944824 / seconds Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1 loadtime:1.9163589477539 / seconds Query Executed:select id FROM `az` where city='Miami' && SIC_code='1521'DB:business_master_new loadtime:1.9332981109619 / seconds Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1 loadtime:1.933758020401 / seconds Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='1521'DB:business_master_new loadtime:1.943568944931 / seconds Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1 loadtime:1.9439361095428 / seconds Query Executed:select id FROM `az` where city='Morenci' && SIC_code='1521'DB:business_master_new loadtime:1.9555079936981 / seconds Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1 loadtime:1.9558589458466 / seconds Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='1521'DB:business_master_new loadtime:1.9596121311188 / seconds Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1 loadtime:1.9599900245667 / seconds Query Executed:select id FROM `az` where city='Morristown' && SIC_code='1521'DB:business_master_new loadtime:1.9662351608276 / seconds Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1 loadtime:1.9666609764099 / seconds Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='1521'DB:business_master_new loadtime:1.9709451198578 / seconds Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1 loadtime:1.9711780548096 / seconds Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='1521'DB:business_master_new loadtime:1.9724769592285 / seconds Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1 loadtime:1.9727210998535 / seconds Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='1521'DB:business_master_new loadtime:1.9785590171814 / seconds Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1 loadtime:1.9789161682129 / seconds Query Executed:select id FROM `az` where city='Naco' && SIC_code='1521'DB:business_master_new loadtime:1.9818241596222 / seconds Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1 loadtime:1.9820611476898 / seconds Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='1521'DB:business_master_new loadtime:1.9834129810333 / seconds Query loaded from cache:select * from geodata_geocity where city='New River' limit 1 loadtime:1.9837040901184 / seconds Query Executed:select id FROM `az` where city='New River' && SIC_code='1521'DB:business_master_new loadtime:2.0019860267639 / seconds Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1 loadtime:2.002357006073 / seconds Query Executed:select id FROM `az` where city='Nogales' && SIC_code='1521'DB:business_master_new loadtime:2.0139701366425 / seconds Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1 loadtime:2.0143301486969 / seconds Query Executed:select id FROM `az` where city='North Rim' && SIC_code='1521'DB:business_master_new loadtime:2.015613079071 / seconds Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1 loadtime:2.0158669948578 / seconds Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='1521'DB:business_master_new loadtime:2.0181529521942 / seconds Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1 loadtime:2.0185220241547 / seconds Query Executed:select id FROM `az` where city='Oatman' && SIC_code='1521'DB:business_master_new loadtime:2.0252721309662 / seconds Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1 loadtime:2.0255529880524 / seconds Query Executed:select id FROM `az` where city='Oracle' && SIC_code='1521'DB:business_master_new loadtime:2.033126115799 / seconds Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1 loadtime:2.0335471630096 / seconds Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='1521'DB:business_master_new loadtime:2.0409331321716 / seconds Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1 loadtime:2.04132604599 / seconds Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='1521'DB:business_master_new loadtime:2.0490820407867 / seconds Query loaded from cache:select * from geodata_geocity where city='Page' limit 1 loadtime:2.0495200157166 / seconds Query Executed:select id FROM `az` where city='Page' && SIC_code='1521'DB:business_master_new loadtime:2.0575590133667 / seconds Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1 loadtime:2.0579261779785 / seconds Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='1521'DB:business_master_new loadtime:2.0601160526276 / seconds Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1 loadtime:2.060357093811 / seconds Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='1521'DB:business_master_new loadtime:2.0755231380463 / seconds Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1 loadtime:2.0759689807892 / seconds Query Executed:select id FROM `az` where city='Parker' && SIC_code='1521'DB:business_master_new loadtime:2.0840420722961 / seconds Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1 loadtime:2.084498167038 / seconds Query Executed:select id FROM `az` where city='Parks' && SIC_code='1521'DB:business_master_new loadtime:2.0878701210022 / seconds Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1 loadtime:2.0882661342621 / seconds Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='1521'DB:business_master_new loadtime:2.0892729759216 / seconds Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1 loadtime:2.08957695961 / seconds Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='1521'DB:business_master_new loadtime:2.0963261127472 / seconds Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1 loadtime:2.0967719554901 / seconds Query Executed:select id FROM `az` where city='Paulden' && SIC_code='1521'DB:business_master_new loadtime:2.1043810844421 / seconds Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1 loadtime:2.1047630310059 / seconds Query Executed:select id FROM `az` where city='Payson' && SIC_code='1521'DB:business_master_new loadtime:2.1187281608582 / seconds Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1 loadtime:2.1191921234131 / seconds Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='1521'DB:business_master_new loadtime:2.1252889633179 / seconds Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1 loadtime:2.1257631778717 / seconds Query Executed:select id FROM `az` where city='Pearce' && SIC_code='1521'DB:business_master_new loadtime:2.1404061317444 / seconds Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1 loadtime:2.1408071517944 / seconds Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='1521'DB:business_master_new loadtime:2.1419100761414 / seconds Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1 loadtime:2.1421611309052 / seconds Query Executed:select id FROM `az` where city='Peoria' && SIC_code='1521'DB:business_master_new loadtime:2.1642589569092 / seconds Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1 loadtime:2.164803981781 / seconds Query Executed:select id FROM `az` where city='Peridot' && SIC_code='1521'DB:business_master_new loadtime:2.1666240692139 / seconds Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1 loadtime:2.1667220592499 / seconds Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='1521'DB:business_master_new loadtime:2.1675751209259 / seconds Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1 loadtime:2.1678850650787 / seconds Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='1521'DB:business_master_new loadtime:2.1689889431 / seconds Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1 loadtime:2.1692550182343 / seconds Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='1521'DB:business_master_new loadtime:2.3865880966187 / seconds Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1 loadtime:2.3889541625977 / seconds Query Executed:select id FROM `az` where city='Picacho' && SIC_code='1521'DB:business_master_new loadtime:2.3904621601105 / seconds Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1 loadtime:2.3908331394196 / seconds Query Executed:select id FROM `az` where city='Pima' && SIC_code='1521'DB:business_master_new loadtime:2.394739151001 / seconds Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1 loadtime:2.3951070308685 / seconds Query Executed:select id FROM `az` where city='Pine' && SIC_code='1521'DB:business_master_new loadtime:2.4019050598145 / seconds Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1 loadtime:2.4025051593781 / seconds Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='1521'DB:business_master_new loadtime:2.4037320613861 / seconds Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1 loadtime:2.4040811061859 / seconds Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='1521'DB:business_master_new loadtime:2.4116261005402 / seconds Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1 loadtime:2.4120199680328 / seconds Query Executed:select id FROM `az` where city='Pinon' && SIC_code='1521'DB:business_master_new loadtime:2.4137101173401 / seconds Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1 loadtime:2.4139649868011 / seconds Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='1521'DB:business_master_new loadtime:2.4160661697388 / seconds Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1 loadtime:2.4164111614227 / seconds Query Executed:select id FROM `az` where city='Polacca' && SIC_code='1521'DB:business_master_new loadtime:2.4180080890656 / seconds Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1 loadtime:2.4185230731964 / seconds Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='1521'DB:business_master_new loadtime:2.4197361469269 / seconds Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1 loadtime:2.4199891090393 / seconds Query Executed:select id FROM `az` where city='Portal' && SIC_code='1521'DB:business_master_new loadtime:2.4212181568146 / seconds Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1 loadtime:2.4213380813599 / seconds Query Executed:select id FROM `az` where city='Poston' && SIC_code='1521'DB:business_master_new loadtime:2.4225859642029 / seconds Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1 loadtime:2.4228250980377 / seconds Query Executed:select id FROM `az` where city='Prescott' && SIC_code='1521'DB:business_master_new loadtime:2.4397280216217 / seconds Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1 loadtime:2.4403619766235 / seconds Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='1521'DB:business_master_new loadtime:2.4509761333466 / seconds Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1 loadtime:2.4515731334686 / seconds Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='1521'DB:business_master_new loadtime:2.4590830802917 / seconds Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1 loadtime:2.4594709873199 / seconds Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='1521'DB:business_master_new loadtime:2.4685111045837 / seconds Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1 loadtime:2.4689409732819 / seconds Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='1521'DB:business_master_new loadtime:2.470242023468 / seconds Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1 loadtime:2.4705159664154 / seconds Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='1521'DB:business_master_new loadtime:2.4718849658966 / seconds Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1 loadtime:2.4721400737762 / seconds Query Executed:select id FROM `az` where city='Rillito' && SIC_code='1521'DB:business_master_new loadtime:2.4735820293427 / seconds Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1 loadtime:2.4736630916595 / seconds Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='1521'DB:business_master_new loadtime:2.4773261547089 / seconds Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1 loadtime:2.477655172348 / seconds Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='1521'DB:business_master_new loadtime:2.4810650348663 / seconds Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1 loadtime:2.4812331199646 / seconds Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='1521'DB:business_master_new loadtime:2.4820930957794 / seconds Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1 loadtime:2.4822170734406 / seconds Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='1521'DB:business_master_new loadtime:2.4827239513397 / seconds Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1 loadtime:2.4828190803528 / seconds Query Executed:select id FROM `az` where city='Roll' && SIC_code='1521'DB:business_master_new loadtime:2.4833199977875 / seconds Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1 loadtime:2.4834020137787 / seconds Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='1521'DB:business_master_new loadtime:2.4851109981537 / seconds Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1 loadtime:2.4852559566498 / seconds Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='1521'DB:business_master_new loadtime:2.4863231182098 / seconds Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1 loadtime:2.4866199493408 / seconds Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='1521'DB:business_master_new loadtime:2.4884719848633 / seconds Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1 loadtime:2.4887201786041 / seconds Query Executed:select id FROM `az` where city='Safford' && SIC_code='1521'DB:business_master_new loadtime:2.496649980545 / seconds Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1 loadtime:2.497013092041 / seconds Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='1521'DB:business_master_new loadtime:2.5026590824127 / seconds Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1 loadtime:2.5030541419983 / seconds Query Executed:select id FROM `az` where city='Saint David' && SIC_code='1521'DB:business_master_new loadtime:2.5058381557465 / seconds Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1 loadtime:2.5062019824982 / seconds Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='1521'DB:business_master_new loadtime:2.5138030052185 / seconds Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1 loadtime:2.5139310359955 / seconds Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='1521'DB:business_master_new loadtime:2.5145189762115 / seconds Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1 loadtime:2.5146110057831 / seconds Query Executed:select id FROM `az` where city='Salome' && SIC_code='1521'DB:business_master_new loadtime:2.5172171592712 / seconds Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1 loadtime:2.5173571109772 / seconds Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='1521'DB:business_master_new loadtime:2.5192761421204 / seconds Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1 loadtime:2.5194530487061 / seconds Query Executed:select id FROM `az` where city='San Luis' && SIC_code='1521'DB:business_master_new loadtime:2.5207691192627 / seconds Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1 loadtime:2.5209040641785 / seconds Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='1521'DB:business_master_new loadtime:2.5217671394348 / seconds Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1 loadtime:2.5218980312347 / seconds Query Executed:select id FROM `az` where city='San Simon' && SIC_code='1521'DB:business_master_new loadtime:2.5228660106659 / seconds Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1 loadtime:2.5229921340942 / seconds Query Executed:select id FROM `az` where city='Sanders' && SIC_code='1521'DB:business_master_new loadtime:2.5250401496887 / seconds Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1 loadtime:2.5251741409302 / seconds Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='1521'DB:business_master_new loadtime:2.5264091491699 / seconds Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1 loadtime:2.5268070697784 / seconds Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='1521'DB:business_master_new loadtime:2.5697331428528 / seconds Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1 loadtime:2.5710470676422 / seconds Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='1521'DB:business_master_new loadtime:2.5727610588074 / seconds Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1 loadtime:2.5730741024017 / seconds Query Executed:select id FROM `az` where city='Sedona' && SIC_code='1521'DB:business_master_new loadtime:2.5845170021057 / seconds Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1 loadtime:2.585000038147 / seconds Query Executed:select id FROM `az` where city='Seligman' && SIC_code='1521'DB:business_master_new loadtime:2.5889070034027 / seconds Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1 loadtime:2.5893161296844 / seconds Query Executed:select id FROM `az` where city='Sells' && SIC_code='1521'DB:business_master_new loadtime:2.5943820476532 / seconds Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1 loadtime:2.5946390628815 / seconds Query Executed:select id FROM `az` where city='Shonto' && SIC_code='1521'DB:business_master_new loadtime:2.596095085144 / seconds Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1 loadtime:2.5963490009308 / seconds Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='1521'DB:business_master_new loadtime:2.5974631309509 / seconds Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1 loadtime:2.5977761745453 / seconds Query Executed:select id FROM `az` where city='Show Low' && SIC_code='1521'DB:business_master_new loadtime:2.6062049865723 / seconds Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1 loadtime:2.6067090034485 / seconds Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='1521'DB:business_master_new loadtime:2.611405134201 / seconds Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1 loadtime:2.6119160652161 / seconds Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='1521'DB:business_master_new loadtime:2.6135611534119 / seconds Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1 loadtime:2.6139571666718 / seconds Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='1521'DB:business_master_new loadtime:2.6175711154938 / seconds Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1 loadtime:2.6179461479187 / seconds Query Executed:select id FROM `az` where city='Solomon' && SIC_code='1521'DB:business_master_new loadtime:2.6197090148926 / seconds Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1 loadtime:2.6200881004333 / seconds Query Executed:select id FROM `az` where city='Somerton' && SIC_code='1521'DB:business_master_new loadtime:2.6237721443176 / seconds Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1 loadtime:2.6241290569305 / seconds Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='1521'DB:business_master_new loadtime:2.6285910606384 / seconds Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1 loadtime:2.6287310123444 / seconds Query Executed:select id FROM `az` where city='Springerville' && SIC_code='1521'DB:business_master_new loadtime:2.6355111598969 / seconds Query loaded from cache:select * from geodata_geocity where city='St David' limit 1 loadtime:2.6358840465546 / seconds Query Executed:select id FROM `az` where city='St David' && SIC_code='1521'DB:business_master_new loadtime:2.6363780498505 / seconds Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1 loadtime:2.6364891529083 / seconds Query Executed:select id FROM `az` where city='St Johns' && SIC_code='1521'DB:business_master_new loadtime:2.6373660564423 / seconds Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1 loadtime:2.637463092804 / seconds Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='1521'DB:business_master_new loadtime:2.6384971141815 / seconds Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1 loadtime:2.6385769844055 / seconds Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='1521'DB:business_master_new loadtime:2.6391351222992 / seconds Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1 loadtime:2.6392090320587 / seconds Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='1521'DB:business_master_new loadtime:2.6397249698639 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1 loadtime:2.6398031711578 / seconds Query Executed:select id FROM `az` where city='Sun City' && SIC_code='1521'DB:business_master_new loadtime:2.6431591510773 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1 loadtime:2.6435930728912 / seconds Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='1521'DB:business_master_new loadtime:2.6475281715393 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1 loadtime:2.6477091312408 / seconds Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='1521'DB:business_master_new loadtime:2.6493179798126 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1 loadtime:2.6494109630585 / seconds Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='1521'DB:business_master_new loadtime:2.6512250900269 / seconds Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1 loadtime:2.6514830589294 / seconds Query Executed:select id FROM `az` where city='Supai' && SIC_code='1521'DB:business_master_new loadtime:2.6528151035309 / seconds Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1 loadtime:2.6530539989471 / seconds Query Executed:select id FROM `az` where city='Superior' && SIC_code='1521'DB:business_master_new loadtime:2.6550781726837 / seconds Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1 loadtime:2.6552650928497 / seconds Query Executed:select id FROM `az` where city='Surprise' && SIC_code='1521'DB:business_master_new loadtime:2.6657810211182 / seconds Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1 loadtime:2.6662430763245 / seconds Query Executed:select id FROM `az` where city='Tacna' && SIC_code='1521'DB:business_master_new loadtime:2.6676189899445 / seconds Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1 loadtime:2.6677930355072 / seconds Query Executed:select id FROM `az` where city='Taylor' && SIC_code='1521'DB:business_master_new loadtime:2.6701810359955 / seconds Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1 loadtime:2.6706311702728 / seconds Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='1521'DB:business_master_new loadtime:2.6726450920105 / seconds Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1 loadtime:2.6728789806366 / seconds Query Executed:select id FROM `az` where city='Tempe' && SIC_code='1521'DB:business_master_new loadtime:2.6824190616608 / seconds Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1 loadtime:2.6831841468811 / seconds Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='1521'DB:business_master_new loadtime:2.68434715271 / seconds Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1 loadtime:2.684662103653 / seconds Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='1521'DB:business_master_new loadtime:2.6875760555267 / seconds Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1 loadtime:2.6879861354828 / seconds Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='1521'DB:business_master_new loadtime:2.6917960643768 / seconds Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1 loadtime:2.6922631263733 / seconds Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='1521'DB:business_master_new loadtime:2.6956210136414 / seconds Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1 loadtime:2.6959881782532 / seconds Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='1521'DB:business_master_new loadtime:2.6967241764069 / seconds Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1 loadtime:2.6969521045685 / seconds Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='1521'DB:business_master_new loadtime:2.7070400714874 / seconds Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1 loadtime:2.7072269916534 / seconds Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='1521'DB:business_master_new loadtime:2.7124271392822 / seconds Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1 loadtime:2.7126271724701 / seconds Query Executed:select id FROM `az` where city='Topawa' && SIC_code='1521'DB:business_master_new loadtime:2.7140030860901 / seconds Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1 loadtime:2.7142870426178 / seconds Query Executed:select id FROM `az` where city='Topock' && SIC_code='1521'DB:business_master_new loadtime:2.7170910835266 / seconds Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1 loadtime:2.7172541618347 / seconds Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='1521'DB:business_master_new loadtime:2.718327999115 / seconds Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1 loadtime:2.7184109687805 / seconds Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='1521'DB:business_master_new loadtime:2.7191109657288 / seconds Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1 loadtime:2.7193231582642 / seconds Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='1521'DB:business_master_new loadtime:2.7217700481415 / seconds Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1 loadtime:2.7223689556122 / seconds Query Executed:select id FROM `az` where city='Tubac' && SIC_code='1521'DB:business_master_new loadtime:2.7449550628662 / seconds Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1 loadtime:2.7453470230103 / seconds Query Executed:select id FROM `az` where city='Tucson' && SIC_code='1521'DB:business_master_new loadtime:2.8039989471436 / seconds Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1 loadtime:2.8055770397186 / seconds Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='1521'DB:business_master_new loadtime:2.8066041469574 / seconds Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1 loadtime:2.8070600032806 / seconds Query Executed:select id FROM `az` where city='Vail' && SIC_code='1521'DB:business_master_new loadtime:2.8102309703827 / seconds Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1 loadtime:2.8106889724731 / seconds Query Executed:select id FROM `az` where city='Valentine' && SIC_code='1521'DB:business_master_new loadtime:2.8117821216583 / seconds Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1 loadtime:2.8119201660156 / seconds Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='1521'DB:business_master_new loadtime:2.8129210472107 / seconds Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1 loadtime:2.8130121231079 / seconds Query Executed:select id FROM `az` where city='Vernon' && SIC_code='1521'DB:business_master_new loadtime:2.8146321773529 / seconds Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1 loadtime:2.8147830963135 / seconds Query Executed:select id FROM `az` where city='Waddell' && SIC_code='1521'DB:business_master_new loadtime:2.8218259811401 / seconds Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1 loadtime:2.8219680786133 / seconds Query Executed:select id FROM `az` where city='Wellton' && SIC_code='1521'DB:business_master_new loadtime:2.8239741325378 / seconds Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1 loadtime:2.8240599632263 / seconds Query Executed:select id FROM `az` where city='Wenden' && SIC_code='1521'DB:business_master_new loadtime:2.8253800868988 / seconds Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1 loadtime:2.8254890441895 / seconds Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='1521'DB:business_master_new loadtime:2.8265180587769 / seconds Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1 loadtime:2.8266041278839 / seconds Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='1521'DB:business_master_new loadtime:2.8273811340332 / seconds Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1 loadtime:2.827486038208 / seconds Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='1521'DB:business_master_new loadtime:2.8297920227051 / seconds Query loaded from cache:select * from geodata_geocity where city='Why' limit 1 loadtime:2.8298771381378 / seconds Query Executed:select id FROM `az` where city='Why' && SIC_code='1521'DB:business_master_new loadtime:2.8312230110168 / seconds Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1 loadtime:2.8313140869141 / seconds Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='1521'DB:business_master_new loadtime:2.8393700122833 / seconds Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1 loadtime:2.8395240306854 / seconds Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='1521'DB:business_master_new loadtime:2.8408091068268 / seconds Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1 loadtime:2.8409039974213 / seconds Query Executed:select id FROM `az` where city='Willcox' && SIC_code='1521'DB:business_master_new loadtime:2.8482701778412 / seconds Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1 loadtime:2.8484020233154 / seconds Query Executed:select id FROM `az` where city='Williams' && SIC_code='1521'DB:business_master_new loadtime:2.8553719520569 / seconds Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1 loadtime:2.8555431365967 / seconds Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='1521'DB:business_master_new loadtime:2.8565101623535 / seconds Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1 loadtime:2.8566360473633 / seconds Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='1521'DB:business_master_new loadtime:2.8637969493866 / seconds Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1 loadtime:2.8639349937439 / seconds Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='1521'DB:business_master_new loadtime:2.8661391735077 / seconds Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1 loadtime:2.8662309646606 / seconds Query Executed:select id FROM `az` where city='Winslow' && SIC_code='1521'DB:business_master_new loadtime:2.8731000423431 / seconds Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1 loadtime:2.8732421398163 / seconds Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='1521'DB:business_master_new loadtime:2.8757021427155 / seconds Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1 loadtime:2.8758471012115 / seconds Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='1521'DB:business_master_new loadtime:2.8767590522766 / seconds Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1 loadtime:2.8768520355225 / seconds Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='1521'DB:business_master_new loadtime:2.8791799545288 / seconds Query loaded from cache:select * from geodata_geocity where city='Young' limit 1 loadtime:2.8792650699615 / seconds Query Executed:select id FROM `az` where city='Young' && SIC_code='1521'DB:business_master_new loadtime:2.8812301158905 / seconds Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1 loadtime:2.881364107132 / seconds Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='1521'DB:business_master_new loadtime:2.8880100250244 / seconds Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1 loadtime:2.8881499767303 / seconds Query Executed:select id FROM `az` where city='Yucca' && SIC_code='1521'DB:business_master_new loadtime:2.8893840312958 / seconds Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1 loadtime:2.8895471096039 / seconds Query Executed:select id FROM `az` where city='Yuma' && SIC_code='1521'DB:business_master_new loadtime:2.8993730545044 / seconds Query loaded from cache:select * from geodata_usstates order by statetitle asc loadtime:2.8996021747589 / seconds Operation directorystatepages executed (chunk cache operation) loadtime:2.9020919799805 / seconds Operation template executed (chunk cache operation) loadtime:2.9026980400085 / seconds template override:Default loadtime:2.902764081955 / 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:2.9048399925232 / seconds Template Constructed, Array Rows:49 loadtime:2.905121088028 / seconds TOTAL EXECUTION TIME: 2.90496 loadtime:2.9052109718323 / seconds THIS PAGE CACHED ON: THIS PAGE COMPRESSION: HITS TO THIS PAGE/CACHE: PAGES STORED: DATASIZE: Bytes Compression: PAGE OBJECT DATA Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/directory/source.ezrox.com/public_html/configs/www.toadli.com/classloader_platform.php on line 572 Key: page; subKey: directorystate; subKey: directorystatepages; subKey: template; _GET Array ( [cat_URLid] => general-contractors-single-family-houses [stateURLid] => arizona ) _COOKIES Array ( ) PAGES IN CACHE CLASS OBJECT Warning: Use of undefined constant output - assumed 'output' (this will throw an Error in a future version of PHP) in /home/directory/source.ezrox.com/public_html/configs/www.toadli.com/classloader_platform.php on line 589 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:2.9052159786224 TOTAL KEY ARRAYS: 69 |