| DEVELOPER MODE ENABLED |
|
OPERATIONS DATA/LOADTIME cache not set compiling loadtime:0.00021219253540039 / seconds DB connected to localhost ezrox_toadli loadtime:0.0015730857849121 / seconds host not found setting manual db connection loadtime:0.0027601718902588 / seconds DB connected to localhost ezrox_toadli loadtime:0.0037050247192383 / seconds Query Executed:select * from general_settings where id=1DB:ezrox_toadli loadtime:0.0042111873626709 / seconds Query loaded from cache:select * from image_settings where id=1 loadtime:0.0044870376586914 / seconds zipcode: loadtime:0.0047130584716797 / seconds Query Executed:select * from search_referrer where page_hash='d346b6b496161812ebbf527735dc2dcd' limit 10 DB:ezrox_toadli loadtime:0.0055742263793945 / seconds Operation header executed (non global) loadtime:0.005681037902832 / seconds Operation leaderboard executed (non global) loadtime:0.0058321952819824 / seconds Operation square executed (non global) loadtime:0.005925178527832 / seconds Operation square_bottom executed (non global) loadtime:0.006026029586792 / seconds Operation smallsquare executed (non global) loadtime:0.0061120986938477 / seconds Operation headeradright executed (non global) loadtime:0.0061960220336914 / seconds Operation google_analytics executed (non global) loadtime:0.0063130855560303 / seconds Operation topstories executed (non global) loadtime:0.0064160823822021 / seconds Operation businessnearyou executed (non global) loadtime:0.0065081119537354 / seconds Operation memberbuscount executed (non global) loadtime:0.0065901279449463 / seconds DB connected to localhost ezrox_toadli loadtime:0.0074751377105713 / seconds Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli loadtime:0.0079741477966309 / seconds Operation categories executed (global stored into APC) loadtime:0.0081591606140137 / seconds Operation categories_menu executed (global stored into APC) loadtime:0.0084371566772461 / seconds Operation archive_menu using avail. global APC cache loadtime:0.0085990428924561 / seconds Template key: archive_menu pushed loadtime:0.0086171627044678 / seconds Operation get_gravatar using avail. global APC cache loadtime:0.0086460113525391 / seconds Template key: get_gravatar pushed loadtime:0.0086572170257568 / seconds Operation directorystate executed (chunk cache operation) loadtime:0.0086681842803955 / seconds *10)-10)+1 | start:0 loadtime:0.0089890956878662 / seconds Query loaded from cache:select * from categories where cat_URLid='general-contractors-single-family-houses' loadtime:0.0091111660003662 / seconds Query loaded from cache:select * from geodata_usstates where url_id='arizona' loadtime:0.009249210357666 / seconds DB connected to localhost business_master_new loadtime:0.010240077972412 / seconds Query Executed:select * from `az_catmap` where sic='1521' order by city ascDB:business_master_new loadtime:0.18756723403931 / seconds Query stored in cache : _QUERY_www.toadli.coma561af56f7665e4e496159f0f455b8f9 loadtime:0.18895721435547 / seconds Query loaded from cache:select * from geodata_usstates where url_id='arizona' loadtime:0.18909406661987 / seconds Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='1521'DB:business_master_new loadtime:0.19403100013733 / seconds Query stored in cache : _QUERY_www.toadli.com2da1afbc116d97ca57e9a54cee87332c loadtime:0.1941602230072 / seconds 287 / 11 loadtime:0.19493412971497 / seconds Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1 loadtime:0.19561100006104 / seconds Query Executed:select id FROM `az` where city='Aguila' && SIC_code='1521'DB:business_master_new loadtime:0.19998502731323 / seconds Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1 loadtime:0.20038509368896 / seconds Query Executed:select id FROM `az` where city='Ajo' && SIC_code='1521'DB:business_master_new loadtime:0.21004915237427 / seconds Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1 loadtime:0.21047115325928 / seconds Query Executed:select id FROM `az` where city='Alpine' && SIC_code='1521'DB:business_master_new loadtime:0.21295213699341 / seconds Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1 loadtime:0.21341419219971 / seconds Query Executed:select id FROM `az` where city='Amado' && SIC_code='1521'DB:business_master_new loadtime:0.21558713912964 / seconds Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1 loadtime:0.2159321308136 / seconds Query Executed:select id FROM `az` where city='Anthem' && SIC_code='1521'DB:business_master_new loadtime:0.21747016906738 / seconds Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1 loadtime:0.21782422065735 / seconds Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='1521'DB:business_master_new loadtime:0.22648811340332 / seconds Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1 loadtime:0.22689914703369 / seconds Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='1521'DB:business_master_new loadtime:0.22885513305664 / seconds Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1 loadtime:0.22913312911987 / seconds Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='1521'DB:business_master_new loadtime:0.23147416114807 / seconds Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1 loadtime:0.23192310333252 / seconds Query Executed:select id FROM `az` where city='Arlington' && SIC_code='1521'DB:business_master_new loadtime:0.23367214202881 / seconds Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1 loadtime:0.23405909538269 / seconds Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='1521'DB:business_master_new loadtime:0.23666214942932 / seconds Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1 loadtime:0.23690819740295 / seconds Query Executed:select id FROM `az` where city='Avondale' && SIC_code='1521'DB:business_master_new loadtime:0.2460560798645 / seconds Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1 loadtime:0.24654817581177 / seconds Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='1521'DB:business_master_new loadtime:0.24881815910339 / seconds Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1 loadtime:0.24910020828247 / seconds Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='1521'DB:business_master_new loadtime:0.2502110004425 / seconds Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1 loadtime:0.25070309638977 / seconds Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='1521'DB:business_master_new loadtime:0.25239014625549 / seconds Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1 loadtime:0.25264000892639 / seconds Query Executed:select id FROM `az` where city='Benson' && SIC_code='1521'DB:business_master_new loadtime:0.26065301895142 / seconds Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1 loadtime:0.26108622550964 / seconds Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='1521'DB:business_master_new loadtime:0.26887011528015 / seconds Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1 loadtime:0.26934003829956 / seconds Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='1521'DB:business_master_new loadtime:0.27285408973694 / seconds Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1 loadtime:0.27332615852356 / seconds Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='1521'DB:business_master_new loadtime:0.27459216117859 / seconds Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1 loadtime:0.27481317520142 / seconds Query Executed:select id FROM `az` where city='Blue' && SIC_code='1521'DB:business_master_new loadtime:0.27616906166077 / seconds Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1 loadtime:0.27645301818848 / seconds Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='1521'DB:business_master_new loadtime:0.27777910232544 / seconds Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1 loadtime:0.27803206443787 / seconds Query Executed:select id FROM `az` where city='Bouse' && SIC_code='1521'DB:business_master_new loadtime:0.27996802330017 / seconds Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1 loadtime:0.28020310401917 / seconds Query Executed:select id FROM `az` where city='Bowie' && SIC_code='1521'DB:business_master_new loadtime:0.28231716156006 / seconds Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1 loadtime:0.28257417678833 / seconds Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='1521'DB:business_master_new loadtime:0.2908341884613 / seconds Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1 loadtime:0.29123020172119 / seconds Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='1521'DB:business_master_new loadtime:0.30211400985718 / seconds Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1 loadtime:0.30266618728638 / seconds Query Executed:select id FROM `az` where city='Bylas' && SIC_code='1521'DB:business_master_new loadtime:0.30406403541565 / seconds Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1 loadtime:0.30435419082642 / seconds Query Executed:select id FROM `az` where city='Cameron' && SIC_code='1521'DB:business_master_new loadtime:0.30593800544739 / seconds Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1 loadtime:0.30618000030518 / seconds Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='1521'DB:business_master_new loadtime:0.31445503234863 / seconds Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1 loadtime:0.3148410320282 / seconds Query Executed:select id FROM `az` where city='Carefree' && SIC_code='1521'DB:business_master_new loadtime:0.32361817359924 / seconds Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1 loadtime:0.32404613494873 / seconds Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='1521'DB:business_master_new loadtime:0.33253908157349 / seconds Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1 loadtime:0.3329541683197 / seconds Query Executed:select id FROM `az` where city='Cashion' && SIC_code='1521'DB:business_master_new loadtime:0.33505010604858 / seconds Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1 loadtime:0.33535718917847 / seconds Query Executed:select id FROM `az` where city='Catalina' && SIC_code='1521'DB:business_master_new loadtime:0.3374080657959 / seconds Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1 loadtime:0.33776021003723 / seconds Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='1521'DB:business_master_new loadtime:0.34932017326355 / seconds Query loaded from cache:select * from geodata_geocity where city='Central' limit 1 loadtime:0.34976816177368 / seconds Query Executed:select id FROM `az` where city='Central' && SIC_code='1521'DB:business_master_new loadtime:0.35120320320129 / seconds Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1 loadtime:0.35151100158691 / seconds Query Executed:select id FROM `az` where city='Chambers' && SIC_code='1521'DB:business_master_new loadtime:0.35339903831482 / seconds Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1 loadtime:0.35365915298462 / seconds Query Executed:select id FROM `az` where city='Chandler' && SIC_code='1521'DB:business_master_new loadtime:0.37558221817017 / seconds Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1 loadtime:0.37622022628784 / seconds Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='1521'DB:business_master_new loadtime:0.37782621383667 / seconds Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1 loadtime:0.37821507453918 / seconds Query Executed:select id FROM `az` where city='Chinle' && SIC_code='1521'DB:business_master_new loadtime:0.38535809516907 / seconds Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1 loadtime:0.38570713996887 / seconds Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='1521'DB:business_master_new loadtime:0.39530420303345 / seconds Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1 loadtime:0.39573812484741 / seconds Query Executed:select id FROM `az` where city='Chloride' && SIC_code='1521'DB:business_master_new loadtime:0.39727210998535 / seconds Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1 loadtime:0.39754414558411 / seconds Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='1521'DB:business_master_new loadtime:0.39878010749817 / seconds Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1 loadtime:0.39902710914612 / seconds Query Executed:select id FROM `az` where city='Cibola' && SIC_code='1521'DB:business_master_new loadtime:0.4003381729126 / seconds Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1 loadtime:0.40058207511902 / seconds Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='1521'DB:business_master_new loadtime:0.40577006340027 / seconds Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1 loadtime:0.4061062335968 / seconds Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='1521'DB:business_master_new loadtime:0.40746212005615 / seconds Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1 loadtime:0.40771102905273 / seconds Query Executed:select id FROM `az` where city='Claypool' && SIC_code='1521'DB:business_master_new loadtime:0.41087913513184 / seconds Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1 loadtime:0.41112017631531 / seconds Query Executed:select id FROM `az` where city='Clifton' && SIC_code='1521'DB:business_master_new loadtime:0.41455006599426 / seconds Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1 loadtime:0.41476321220398 / seconds Query Executed:select id FROM `az` where city='Cochise' && SIC_code='1521'DB:business_master_new loadtime:0.41708612442017 / seconds Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1 loadtime:0.4175271987915 / seconds Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='1521'DB:business_master_new loadtime:0.42183303833008 / seconds Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1 loadtime:0.42222714424133 / seconds Query Executed:select id FROM `az` where city='Concho' && SIC_code='1521'DB:business_master_new loadtime:0.42460107803345 / seconds Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1 loadtime:0.42484402656555 / seconds Query Executed:select id FROM `az` where city='Congress' && SIC_code='1521'DB:business_master_new loadtime:0.42718911170959 / seconds Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1 loadtime:0.42761421203613 / seconds Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='1521'DB:business_master_new loadtime:0.43296122550964 / seconds Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1 loadtime:0.43338012695312 / seconds Query Executed:select id FROM `az` where city='Cornville' && SIC_code='1521'DB:business_master_new loadtime:0.43922305107117 / seconds Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1 loadtime:0.4396960735321 / seconds Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='1521'DB:business_master_new loadtime:0.44238615036011 / seconds Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1 loadtime:0.44274711608887 / seconds Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='1521'DB:business_master_new loadtime:0.45274710655212 / seconds Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1 loadtime:0.45317816734314 / seconds Query Executed:select id FROM `az` where city='Crown King' && SIC_code='1521'DB:business_master_new loadtime:0.45452117919922 / seconds Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1 loadtime:0.4549241065979 / seconds Query Executed:select id FROM `az` where city='Dateland' && SIC_code='1521'DB:business_master_new loadtime:0.45619201660156 / seconds Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1 loadtime:0.45649218559265 / seconds Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='1521'DB:business_master_new loadtime:0.45784401893616 / seconds Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1 loadtime:0.45809006690979 / seconds Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='1521'DB:business_master_new loadtime:0.4593710899353 / seconds Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1 loadtime:0.45962119102478 / seconds Query Executed:select id FROM `az` where city='Dewey' && SIC_code='1521'DB:business_master_new loadtime:0.46726107597351 / seconds Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1 loadtime:0.4677050113678 / seconds Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='1521'DB:business_master_new loadtime:0.47008109092712 / seconds Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1 loadtime:0.47050714492798 / seconds Query Executed:select id FROM `az` where city='Douglas' && SIC_code='1521'DB:business_master_new loadtime:0.47821521759033 / seconds Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1 loadtime:0.47858619689941 / seconds Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='1521'DB:business_master_new loadtime:0.4801881313324 / seconds Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1 loadtime:0.48048520088196 / seconds Query Executed:select id FROM `az` where city='Duncan' && SIC_code='1521'DB:business_master_new loadtime:0.48383402824402 / seconds Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1 loadtime:0.48419404029846 / seconds Query Executed:select id FROM `az` where city='Eagar' && SIC_code='1521'DB:business_master_new loadtime:0.48996114730835 / seconds Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1 loadtime:0.49039816856384 / seconds Query Executed:select id FROM `az` where city='Eden' && SIC_code='1521'DB:business_master_new loadtime:0.49155402183533 / seconds Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1 loadtime:0.49178814888 / seconds Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='1521'DB:business_master_new loadtime:0.49519515037537 / seconds Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1 loadtime:0.49550414085388 / seconds Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='1521'DB:business_master_new loadtime:0.50323605537415 / seconds Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1 loadtime:0.50366806983948 / seconds Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='1521'DB:business_master_new loadtime:0.50698518753052 / seconds Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1 loadtime:0.50722622871399 / seconds Query Executed:select id FROM `az` where city='Elgin' && SIC_code='1521'DB:business_master_new loadtime:0.50894713401794 / seconds Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1 loadtime:0.50938701629639 / seconds Query Executed:select id FROM `az` where city='Eloy' && SIC_code='1521'DB:business_master_new loadtime:0.51298022270203 / seconds Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1 loadtime:0.51341605186462 / seconds Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='1521'DB:business_master_new loadtime:0.53237223625183 / seconds Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1 loadtime:0.5329442024231 / seconds Query Executed:select id FROM `az` where city='Florence' && SIC_code='1521'DB:business_master_new loadtime:0.53620100021362 / seconds Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1 loadtime:0.53661203384399 / seconds Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='1521'DB:business_master_new loadtime:0.53816914558411 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1 loadtime:0.53849601745605 / seconds Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='1521'DB:business_master_new loadtime:0.53961300849915 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1 loadtime:0.53985023498535 / seconds Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='1521'DB:business_master_new loadtime:0.54382920265198 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1 loadtime:0.54417419433594 / seconds Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='1521'DB:business_master_new loadtime:0.54907321929932 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1 loadtime:0.54948616027832 / seconds Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='1521'DB:business_master_new loadtime:0.55134201049805 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1 loadtime:0.55170321464539 / seconds Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='1521'DB:business_master_new loadtime:0.55983400344849 / seconds Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1 loadtime:0.56021523475647 / seconds Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='1521'DB:business_master_new loadtime:0.56189203262329 / seconds Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1 loadtime:0.5621612071991 / seconds Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='1521'DB:business_master_new loadtime:0.57348823547363 / seconds Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1 loadtime:0.57396101951599 / seconds Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='1521'DB:business_master_new loadtime:0.57750511169434 / seconds Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1 loadtime:0.57790017127991 / seconds Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='1521'DB:business_master_new loadtime:0.57911014556885 / seconds Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1 loadtime:0.57943511009216 / seconds Query Executed:select id FROM `az` where city='Ganado' && SIC_code='1521'DB:business_master_new loadtime:0.58255219459534 / seconds Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1 loadtime:0.58276700973511 / seconds Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='1521'DB:business_master_new loadtime:0.5873601436615 / seconds Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1 loadtime:0.58773303031921 / seconds Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='1521'DB:business_master_new loadtime:0.60649919509888 / seconds Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1 loadtime:0.60713720321655 / seconds Query Executed:select id FROM `az` where city='Glendale' && SIC_code='1521'DB:business_master_new loadtime:0.63055419921875 / seconds Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1 loadtime:0.63132810592651 / seconds Query Executed:select id FROM `az` where city='Globe' && SIC_code='1521'DB:business_master_new loadtime:0.63946413993835 / seconds Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1 loadtime:0.63993501663208 / seconds Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='1521'DB:business_master_new loadtime:0.64695405960083 / seconds Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1 loadtime:0.64735722541809 / seconds Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='1521'DB:business_master_new loadtime:0.65670323371887 / seconds Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1 loadtime:0.65713715553284 / seconds Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='1521'DB:business_master_new loadtime:0.66109704971313 / seconds Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1 loadtime:0.66150712966919 / seconds Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='1521'DB:business_master_new loadtime:0.66265201568604 / seconds Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1 loadtime:0.66291117668152 / seconds Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='1521'DB:business_master_new loadtime:0.67143511772156 / seconds Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1 loadtime:0.67182922363281 / seconds Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='1521'DB:business_master_new loadtime:0.67340612411499 / seconds Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1 loadtime:0.67366719245911 / seconds Query Executed:select id FROM `az` where city='Greer' && SIC_code='1521'DB:business_master_new loadtime:0.67612409591675 / seconds Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1 loadtime:0.67641019821167 / seconds Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='1521'DB:business_master_new loadtime:0.67789101600647 / seconds Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1 loadtime:0.6781370639801 / seconds Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='1521'DB:business_master_new loadtime:0.67923212051392 / seconds Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1 loadtime:0.67951917648315 / seconds Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='1521'DB:business_master_new loadtime:0.68137812614441 / seconds Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1 loadtime:0.68175506591797 / seconds Query Executed:select id FROM `az` where city='Hayden' && SIC_code='1521'DB:business_master_new loadtime:0.68408608436584 / seconds Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1 loadtime:0.68450021743774 / seconds Query Executed:select id FROM `az` where city='Heber' && SIC_code='1521'DB:business_master_new loadtime:0.68678212165833 / seconds Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1 loadtime:0.68714118003845 / seconds Query Executed:select id FROM `az` where city='Hereford' && SIC_code='1521'DB:business_master_new loadtime:0.69486021995544 / seconds Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1 loadtime:0.69531011581421 / seconds Query Executed:select id FROM `az` where city='Higley' && SIC_code='1521'DB:business_master_new loadtime:0.70313906669617 / seconds Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1 loadtime:0.70358920097351 / seconds Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='1521'DB:business_master_new loadtime:0.71093201637268 / seconds Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1 loadtime:0.71133303642273 / seconds Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='1521'DB:business_master_new loadtime:0.71244716644287 / seconds Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1 loadtime:0.71269202232361 / seconds Query Executed:select id FROM `az` where city='Houck' && SIC_code='1521'DB:business_master_new loadtime:0.71421718597412 / seconds Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1 loadtime:0.71461200714111 / seconds Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='1521'DB:business_master_new loadtime:0.72186303138733 / seconds Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1 loadtime:0.72224020957947 / seconds Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='1521'DB:business_master_new loadtime:0.7234251499176 / seconds Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1 loadtime:0.72366309165955 / seconds Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='1521'DB:business_master_new loadtime:0.72632217407227 / seconds Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1 loadtime:0.72667717933655 / seconds Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='1521'DB:business_master_new loadtime:0.72792220115662 / seconds Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1 loadtime:0.72817516326904 / seconds Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='1521'DB:business_master_new loadtime:0.7292320728302 / seconds Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1 loadtime:0.72959899902344 / seconds Query Executed:select id FROM `az` where city='Jerome' && SIC_code='1521'DB:business_master_new loadtime:0.73363018035889 / seconds Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1 loadtime:0.73400521278381 / seconds Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='1521'DB:business_master_new loadtime:0.73615622520447 / seconds Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1 loadtime:0.73654818534851 / seconds Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='1521'DB:business_master_new loadtime:0.73781323432922 / seconds Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1 loadtime:0.73805809020996 / seconds Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='1521'DB:business_master_new loadtime:0.73910212516785 / seconds Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1 loadtime:0.73939323425293 / seconds Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='1521'DB:business_master_new loadtime:0.74298620223999 / seconds Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1 loadtime:0.74338912963867 / seconds Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='1521'DB:business_master_new loadtime:0.74559903144836 / seconds Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1 loadtime:0.74595904350281 / seconds Query Executed:select id FROM `az` where city='Kearny' && SIC_code='1521'DB:business_master_new loadtime:0.74783205986023 / seconds Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1 loadtime:0.74819803237915 / seconds Query Executed:select id FROM `az` where city='Kingman' && SIC_code='1521'DB:business_master_new loadtime:0.75970220565796 / seconds Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1 loadtime:0.7601420879364 / seconds Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='1521'DB:business_master_new loadtime:0.76215219497681 / seconds Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1 loadtime:0.76259517669678 / seconds Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='1521'DB:business_master_new loadtime:0.76444101333618 / seconds Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1 loadtime:0.7647020816803 / seconds Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='1521'DB:business_master_new loadtime:0.76597714424133 / seconds Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1 loadtime:0.76622009277344 / seconds Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='1521'DB:business_master_new loadtime:0.78084206581116 / seconds Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1 loadtime:0.78147721290588 / seconds Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='1521'DB:business_master_new loadtime:0.78333210945129 / seconds Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1 loadtime:0.78370404243469 / seconds Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='1521'DB:business_master_new loadtime:0.79141902923584 / seconds Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1 loadtime:0.79179716110229 / seconds Query Executed:select id FROM `az` where city='Laveen' && SIC_code='1521'DB:business_master_new loadtime:0.80003809928894 / seconds Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1 loadtime:0.80045700073242 / seconds Query Executed:select id FROM `az` where city='Leupp' && SIC_code='1521'DB:business_master_new loadtime:0.80202913284302 / seconds Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1 loadtime:0.80231523513794 / seconds Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='1521'DB:business_master_new loadtime:0.81044220924377 / seconds Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1 loadtime:0.81081509590149 / seconds Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='1521'DB:business_master_new loadtime:0.81299304962158 / seconds Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1 loadtime:0.81333208084106 / seconds Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='1521'DB:business_master_new loadtime:0.81458616256714 / seconds Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1 loadtime:0.8148181438446 / seconds Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='1521'DB:business_master_new loadtime:0.8168351650238 / seconds Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1 loadtime:0.81740021705627 / seconds Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='1521'DB:business_master_new loadtime:0.81873607635498 / seconds Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1 loadtime:0.81898021697998 / seconds Query Executed:select id FROM `az` where city='Lupton' && SIC_code='1521'DB:business_master_new loadtime:0.82082319259644 / seconds Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1 loadtime:0.82124519348145 / seconds Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='1521'DB:business_master_new loadtime:0.82233905792236 / seconds Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1 loadtime:0.82257914543152 / seconds Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='1521'DB:business_master_new loadtime:0.82408905029297 / seconds Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1 loadtime:0.82435607910156 / seconds Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='1521'DB:business_master_new loadtime:0.82583618164062 / seconds Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1 loadtime:0.82621812820435 / seconds Query Executed:select id FROM `az` where city='Marana' && SIC_code='1521'DB:business_master_new loadtime:0.83439302444458 / seconds Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1 loadtime:0.83479022979736 / seconds Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='1521'DB:business_master_new loadtime:0.83623504638672 / seconds Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1 loadtime:0.83649301528931 / seconds Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='1521'DB:business_master_new loadtime:0.84352803230286 / seconds Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1 loadtime:0.84388518333435 / seconds Query Executed:select id FROM `az` where city='Mayer' && SIC_code='1521'DB:business_master_new loadtime:0.84922003746033 / seconds Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1 loadtime:0.84963822364807 / seconds Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='1521'DB:business_master_new loadtime:0.85073804855347 / seconds Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1 loadtime:0.85097217559814 / seconds Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='1521'DB:business_master_new loadtime:0.85287117958069 / seconds Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1 loadtime:0.85316300392151 / seconds Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='1521'DB:business_master_new loadtime:0.85454511642456 / seconds Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1 loadtime:0.85477209091187 / seconds Query Executed:select id FROM `az` where city='Meadview' && SIC_code='1521'DB:business_master_new loadtime:0.85684013366699 / seconds Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1 loadtime:0.857262134552 / seconds Query Executed:select id FROM `az` where city='Mesa' && SIC_code='1521'DB:business_master_new loadtime:0.89612007141113 / seconds Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1 loadtime:0.89725208282471 / seconds Query Executed:select id FROM `az` where city='Miami' && SIC_code='1521'DB:business_master_new loadtime:0.90258717536926 / seconds Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1 loadtime:0.90302109718323 / seconds Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='1521'DB:business_master_new loadtime:0.91048121452332 / seconds Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1 loadtime:0.91082811355591 / seconds Query Executed:select id FROM `az` where city='Morenci' && SIC_code='1521'DB:business_master_new loadtime:0.91355204582214 / seconds Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1 loadtime:0.91393423080444 / seconds Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='1521'DB:business_master_new loadtime:0.91539812088013 / seconds Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1 loadtime:0.91574621200562 / seconds Query Executed:select id FROM `az` where city='Morristown' && SIC_code='1521'DB:business_master_new loadtime:0.91814613342285 / seconds Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1 loadtime:0.91857814788818 / seconds Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='1521'DB:business_master_new loadtime:0.92015504837036 / seconds Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1 loadtime:0.92043709754944 / seconds Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='1521'DB:business_master_new loadtime:0.92160701751709 / seconds Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1 loadtime:0.92184710502625 / seconds Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='1521'DB:business_master_new loadtime:0.924889087677 / seconds Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1 loadtime:0.92532515525818 / seconds Query Executed:select id FROM `az` where city='Naco' && SIC_code='1521'DB:business_master_new loadtime:0.92705416679382 / seconds Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1 loadtime:0.92735004425049 / seconds Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='1521'DB:business_master_new loadtime:0.92841219902039 / seconds Query loaded from cache:select * from geodata_geocity where city='New River' limit 1 loadtime:0.92872023582458 / seconds Query Executed:select id FROM `az` where city='New River' && SIC_code='1521'DB:business_master_new loadtime:0.9338321685791 / seconds Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1 loadtime:0.93418717384338 / seconds Query Executed:select id FROM `az` where city='Nogales' && SIC_code='1521'DB:business_master_new loadtime:0.9434220790863 / seconds Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1 loadtime:0.94380021095276 / seconds Query Executed:select id FROM `az` where city='North Rim' && SIC_code='1521'DB:business_master_new loadtime:0.9450740814209 / seconds Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1 loadtime:0.94534611701965 / seconds Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='1521'DB:business_master_new loadtime:0.94673204421997 / seconds Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1 loadtime:0.94709515571594 / seconds Query Executed:select id FROM `az` where city='Oatman' && SIC_code='1521'DB:business_master_new loadtime:0.94913411140442 / seconds Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1 loadtime:0.9494571685791 / seconds Query Executed:select id FROM `az` where city='Oracle' && SIC_code='1521'DB:business_master_new loadtime:0.95173907279968 / seconds Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1 loadtime:0.95209121704102 / seconds Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='1521'DB:business_master_new loadtime:0.95582818984985 / seconds Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1 loadtime:0.95618319511414 / seconds Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='1521'DB:business_master_new loadtime:0.95937705039978 / seconds Query loaded from cache:select * from geodata_geocity where city='Page' limit 1 loadtime:0.95974707603455 / seconds Query Executed:select id FROM `az` where city='Page' && SIC_code='1521'DB:business_master_new loadtime:0.96743011474609 / seconds Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1 loadtime:0.9677791595459 / seconds Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='1521'DB:business_master_new loadtime:0.96926712989807 / seconds Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1 loadtime:0.96956706047058 / seconds Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='1521'DB:business_master_new loadtime:0.97952318191528 / seconds Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1 loadtime:0.97995710372925 / seconds Query Executed:select id FROM `az` where city='Parker' && SIC_code='1521'DB:business_master_new loadtime:0.98808217048645 / seconds Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1 loadtime:0.98854303359985 / seconds Query Executed:select id FROM `az` where city='Parks' && SIC_code='1521'DB:business_master_new loadtime:0.99047112464905 / seconds Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1 loadtime:0.99083018302917 / seconds Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='1521'DB:business_master_new loadtime:0.99194502830505 / seconds Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1 loadtime:0.9921932220459 / seconds Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='1521'DB:business_master_new loadtime:0.99533414840698 / seconds Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1 loadtime:0.9957070350647 / seconds Query Executed:select id FROM `az` where city='Paulden' && SIC_code='1521'DB:business_master_new loadtime:0.99895119667053 / seconds Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1 loadtime:0.99939918518066 / seconds Query Executed:select id FROM `az` where city='Payson' && SIC_code='1521'DB:business_master_new loadtime:1.0107941627502 / seconds Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1 loadtime:1.0112421512604 / seconds Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='1521'DB:business_master_new loadtime:1.013610124588 / seconds Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1 loadtime:1.0140051841736 / seconds Query Executed:select id FROM `az` where city='Pearce' && SIC_code='1521'DB:business_master_new loadtime:1.0189599990845 / seconds Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1 loadtime:1.0193421840668 / seconds Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='1521'DB:business_master_new loadtime:1.0203402042389 / seconds Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1 loadtime:1.0205821990967 / seconds Query Executed:select id FROM `az` where city='Peoria' && SIC_code='1521'DB:business_master_new loadtime:1.0353832244873 / seconds Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1 loadtime:1.0359230041504 / seconds Query Executed:select id FROM `az` where city='Peridot' && SIC_code='1521'DB:business_master_new loadtime:1.0376381874084 / seconds Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1 loadtime:1.0378720760345 / seconds Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='1521'DB:business_master_new loadtime:1.0390200614929 / seconds Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1 loadtime:1.0393221378326 / seconds Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='1521'DB:business_master_new loadtime:1.0404660701752 / seconds Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1 loadtime:1.040717124939 / seconds Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='1521'DB:business_master_new loadtime:1.1862020492554 / seconds Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1 loadtime:1.1879761219025 / seconds Query Executed:select id FROM `az` where city='Picacho' && SIC_code='1521'DB:business_master_new loadtime:1.1886382102966 / seconds Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1 loadtime:1.1887631416321 / seconds Query Executed:select id FROM `az` where city='Pima' && SIC_code='1521'DB:business_master_new loadtime:1.1902871131897 / seconds Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1 loadtime:1.1904180049896 / seconds Query Executed:select id FROM `az` where city='Pine' && SIC_code='1521'DB:business_master_new loadtime:1.1924271583557 / seconds Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1 loadtime:1.1926031112671 / seconds Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='1521'DB:business_master_new loadtime:1.1931231021881 / seconds Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1 loadtime:1.1934061050415 / seconds Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='1521'DB:business_master_new loadtime:1.1962060928345 / seconds Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1 loadtime:1.1964330673218 / seconds Query Executed:select id FROM `az` where city='Pinon' && SIC_code='1521'DB:business_master_new loadtime:1.1969730854034 / seconds Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1 loadtime:1.1970751285553 / seconds Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='1521'DB:business_master_new loadtime:1.1976120471954 / seconds Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1 loadtime:1.1977360248566 / seconds Query Executed:select id FROM `az` where city='Polacca' && SIC_code='1521'DB:business_master_new loadtime:1.1983652114868 / seconds Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1 loadtime:1.1985170841217 / seconds Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='1521'DB:business_master_new loadtime:1.1991760730743 / seconds Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1 loadtime:1.1992650032043 / seconds Query Executed:select id FROM `az` where city='Portal' && SIC_code='1521'DB:business_master_new loadtime:1.1999051570892 / seconds Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1 loadtime:1.1999871730804 / seconds Query Executed:select id FROM `az` where city='Poston' && SIC_code='1521'DB:business_master_new loadtime:1.2009620666504 / seconds Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1 loadtime:1.2010610103607 / seconds Query Executed:select id FROM `az` where city='Prescott' && SIC_code='1521'DB:business_master_new loadtime:1.2135162353516 / seconds Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1 loadtime:1.2139382362366 / seconds Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='1521'DB:business_master_new loadtime:1.2178180217743 / seconds Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1 loadtime:1.2180211544037 / seconds Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='1521'DB:business_master_new loadtime:1.2208552360535 / seconds Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1 loadtime:1.2209930419922 / seconds Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='1521'DB:business_master_new loadtime:1.2243721485138 / seconds Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1 loadtime:1.2245240211487 / seconds Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='1521'DB:business_master_new loadtime:1.2251870632172 / seconds Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1 loadtime:1.2253720760345 / seconds Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='1521'DB:business_master_new loadtime:1.2258322238922 / seconds Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1 loadtime:1.2259180545807 / seconds Query Executed:select id FROM `az` where city='Rillito' && SIC_code='1521'DB:business_master_new loadtime:1.2264351844788 / seconds Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1 loadtime:1.2265071868896 / seconds Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='1521'DB:business_master_new loadtime:1.2276830673218 / seconds Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1 loadtime:1.2278141975403 / seconds Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='1521'DB:business_master_new loadtime:1.2305850982666 / seconds Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1 loadtime:1.2307231426239 / seconds Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='1521'DB:business_master_new loadtime:1.2316942214966 / seconds Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1 loadtime:1.2318251132965 / seconds Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='1521'DB:business_master_new loadtime:1.2323591709137 / seconds Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1 loadtime:1.2324330806732 / seconds Query Executed:select id FROM `az` where city='Roll' && SIC_code='1521'DB:business_master_new loadtime:1.2330031394958 / seconds Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1 loadtime:1.2333211898804 / seconds Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='1521'DB:business_master_new loadtime:1.2341661453247 / seconds Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1 loadtime:1.234414100647 / seconds Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='1521'DB:business_master_new loadtime:1.2348201274872 / seconds Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1 loadtime:1.2349112033844 / seconds Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='1521'DB:business_master_new loadtime:1.2355141639709 / seconds Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1 loadtime:1.2355861663818 / seconds Query Executed:select id FROM `az` where city='Safford' && SIC_code='1521'DB:business_master_new loadtime:1.2385611534119 / seconds Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1 loadtime:1.2387030124664 / seconds Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='1521'DB:business_master_new loadtime:1.2410821914673 / seconds Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1 loadtime:1.2414050102234 / seconds Query Executed:select id FROM `az` where city='Saint David' && SIC_code='1521'DB:business_master_new loadtime:1.2424631118774 / seconds Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1 loadtime:1.2425971031189 / seconds Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='1521'DB:business_master_new loadtime:1.2451012134552 / seconds Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1 loadtime:1.2452211380005 / seconds Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='1521'DB:business_master_new loadtime:1.2457880973816 / seconds Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1 loadtime:1.2458741664886 / seconds Query Executed:select id FROM `az` where city='Salome' && SIC_code='1521'DB:business_master_new loadtime:1.2473981380463 / seconds Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1 loadtime:1.2475171089172 / seconds Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='1521'DB:business_master_new loadtime:1.2490200996399 / seconds Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1 loadtime:1.2493841648102 / seconds Query Executed:select id FROM `az` where city='San Luis' && SIC_code='1521'DB:business_master_new loadtime:1.2506852149963 / seconds Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1 loadtime:1.2508211135864 / seconds Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='1521'DB:business_master_new loadtime:1.2516951560974 / seconds Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1 loadtime:1.2518200874329 / seconds Query Executed:select id FROM `az` where city='San Simon' && SIC_code='1521'DB:business_master_new loadtime:1.2527940273285 / seconds Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1 loadtime:1.2529230117798 / seconds Query Executed:select id FROM `az` where city='Sanders' && SIC_code='1521'DB:business_master_new loadtime:1.2544560432434 / seconds Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1 loadtime:1.2545921802521 / seconds Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='1521'DB:business_master_new loadtime:1.2552011013031 / seconds Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1 loadtime:1.2553780078888 / seconds Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='1521'DB:business_master_new loadtime:1.2721621990204 / seconds Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1 loadtime:1.273097038269 / seconds Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='1521'DB:business_master_new loadtime:1.2738800048828 / seconds Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1 loadtime:1.2739970684052 / seconds Query Executed:select id FROM `az` where city='Sedona' && SIC_code='1521'DB:business_master_new loadtime:1.2783691883087 / seconds Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1 loadtime:1.2785432338715 / seconds Query Executed:select id FROM `az` where city='Seligman' && SIC_code='1521'DB:business_master_new loadtime:1.2797911167145 / seconds Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1 loadtime:1.2799220085144 / seconds Query Executed:select id FROM `az` where city='Sells' && SIC_code='1521'DB:business_master_new loadtime:1.2818291187286 / seconds Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1 loadtime:1.281919002533 / seconds Query Executed:select id FROM `az` where city='Shonto' && SIC_code='1521'DB:business_master_new loadtime:1.28235912323 / seconds Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1 loadtime:1.2824292182922 / seconds Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='1521'DB:business_master_new loadtime:1.2827861309052 / seconds Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1 loadtime:1.2828841209412 / seconds Query Executed:select id FROM `az` where city='Show Low' && SIC_code='1521'DB:business_master_new loadtime:1.2861220836639 / seconds Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1 loadtime:1.2862691879272 / seconds Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='1521'DB:business_master_new loadtime:1.2903730869293 / seconds Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1 loadtime:1.2905671596527 / seconds Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='1521'DB:business_master_new loadtime:1.2913801670074 / seconds Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1 loadtime:1.2915191650391 / seconds Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='1521'DB:business_master_new loadtime:1.2941942214966 / seconds Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1 loadtime:1.2943511009216 / seconds Query Executed:select id FROM `az` where city='Solomon' && SIC_code='1521'DB:business_master_new loadtime:1.2949340343475 / seconds Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1 loadtime:1.2951672077179 / seconds Query Executed:select id FROM `az` where city='Somerton' && SIC_code='1521'DB:business_master_new loadtime:1.2965030670166 / seconds Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1 loadtime:1.2966392040253 / seconds Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='1521'DB:business_master_new loadtime:1.2985332012177 / seconds Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1 loadtime:1.2986900806427 / seconds Query Executed:select id FROM `az` where city='Springerville' && SIC_code='1521'DB:business_master_new loadtime:1.3020331859589 / seconds Query loaded from cache:select * from geodata_geocity where city='St David' limit 1 loadtime:1.3023791313171 / seconds Query Executed:select id FROM `az` where city='St David' && SIC_code='1521'DB:business_master_new loadtime:1.3028340339661 / seconds Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1 loadtime:1.3029370307922 / seconds Query Executed:select id FROM `az` where city='St Johns' && SIC_code='1521'DB:business_master_new loadtime:1.3035161495209 / seconds Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1 loadtime:1.3036000728607 / seconds Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='1521'DB:business_master_new loadtime:1.3042461872101 / seconds Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1 loadtime:1.3043842315674 / seconds Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='1521'DB:business_master_new loadtime:1.3051252365112 / seconds Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1 loadtime:1.3052260875702 / seconds Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='1521'DB:business_master_new loadtime:1.3059751987457 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1 loadtime:1.3062081336975 / seconds Query Executed:select id FROM `az` where city='Sun City' && SIC_code='1521'DB:business_master_new loadtime:1.310268163681 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1 loadtime:1.3104660511017 / seconds Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='1521'DB:business_master_new loadtime:1.3141160011292 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1 loadtime:1.3144280910492 / seconds Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='1521'DB:business_master_new loadtime:1.3150370121002 / seconds Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1 loadtime:1.3152761459351 / seconds Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='1521'DB:business_master_new loadtime:1.3158621788025 / seconds Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1 loadtime:1.3159770965576 / seconds Query Executed:select id FROM `az` where city='Supai' && SIC_code='1521'DB:business_master_new loadtime:1.3166830539703 / seconds Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1 loadtime:1.316792011261 / seconds Query Executed:select id FROM `az` where city='Superior' && SIC_code='1521'DB:business_master_new loadtime:1.317752122879 / seconds Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1 loadtime:1.3178670406342 / seconds Query Executed:select id FROM `az` where city='Surprise' && SIC_code='1521'DB:business_master_new loadtime:1.3226761817932 / seconds Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1 loadtime:1.3229780197144 / seconds Query Executed:select id FROM `az` where city='Tacna' && SIC_code='1521'DB:business_master_new loadtime:1.3237490653992 / seconds Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1 loadtime:1.3238670825958 / seconds Query Executed:select id FROM `az` where city='Taylor' && SIC_code='1521'DB:business_master_new loadtime:1.3254971504211 / seconds Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1 loadtime:1.3256721496582 / seconds Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='1521'DB:business_master_new loadtime:1.3267312049866 / seconds Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1 loadtime:1.32683801651 / seconds Query Executed:select id FROM `az` where city='Tempe' && SIC_code='1521'DB:business_master_new loadtime:1.3379502296448 / seconds Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1 loadtime:1.3384640216827 / seconds Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='1521'DB:business_master_new loadtime:1.3389530181885 / seconds Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1 loadtime:1.3390672206879 / seconds Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='1521'DB:business_master_new loadtime:1.3419330120087 / seconds Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1 loadtime:1.342098236084 / seconds Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='1521'DB:business_master_new loadtime:1.3457541465759 / seconds Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1 loadtime:1.3459181785583 / seconds Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='1521'DB:business_master_new loadtime:1.3493831157684 / seconds Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1 loadtime:1.3495490550995 / seconds Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='1521'DB:business_master_new loadtime:1.3503310680389 / seconds Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1 loadtime:1.3504462242126 / seconds Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='1521'DB:business_master_new loadtime:1.3518850803375 / seconds Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1 loadtime:1.3520750999451 / seconds Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='1521'DB:business_master_new loadtime:1.3537631034851 / seconds Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1 loadtime:1.3539390563965 / seconds Query Executed:select id FROM `az` where city='Topawa' && SIC_code='1521'DB:business_master_new loadtime:1.3545920848846 / seconds Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1 loadtime:1.3547070026398 / seconds Query Executed:select id FROM `az` where city='Topock' && SIC_code='1521'DB:business_master_new loadtime:1.3559861183167 / seconds Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1 loadtime:1.3561551570892 / seconds Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='1521'DB:business_master_new loadtime:1.3567600250244 / seconds Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1 loadtime:1.3568630218506 / seconds Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='1521'DB:business_master_new loadtime:1.3575191497803 / seconds Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1 loadtime:1.3576231002808 / seconds Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='1521'DB:business_master_new loadtime:1.3600921630859 / seconds Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1 loadtime:1.3603990077972 / seconds Query Executed:select id FROM `az` where city='Tubac' && SIC_code='1521'DB:business_master_new loadtime:1.3634181022644 / seconds Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1 loadtime:1.3635971546173 / seconds Query Executed:select id FROM `az` where city='Tucson' && SIC_code='1521'DB:business_master_new loadtime:1.5136110782623 / seconds Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1 loadtime:1.5150511264801 / seconds Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='1521'DB:business_master_new loadtime:1.5173861980438 / seconds Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1 loadtime:1.5178020000458 / seconds Query Executed:select id FROM `az` where city='Vail' && SIC_code='1521'DB:business_master_new loadtime:1.5256361961365 / seconds Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1 loadtime:1.5259680747986 / seconds Query Executed:select id FROM `az` where city='Valentine' && SIC_code='1521'DB:business_master_new loadtime:1.5269992351532 / seconds Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1 loadtime:1.5272550582886 / seconds Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='1521'DB:business_master_new loadtime:1.5283241271973 / seconds Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1 loadtime:1.5285432338715 / seconds Query Executed:select id FROM `az` where city='Vernon' && SIC_code='1521'DB:business_master_new loadtime:1.5304780006409 / seconds Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1 loadtime:1.5308270454407 / seconds Query Executed:select id FROM `az` where city='Waddell' && SIC_code='1521'DB:business_master_new loadtime:1.5377531051636 / seconds Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1 loadtime:1.5381450653076 / seconds Query Executed:select id FROM `az` where city='Wellton' && SIC_code='1521'DB:business_master_new loadtime:1.5401091575623 / seconds Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1 loadtime:1.5403821468353 / seconds Query Executed:select id FROM `az` where city='Wenden' && SIC_code='1521'DB:business_master_new loadtime:1.5417931079865 / seconds Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1 loadtime:1.5420382022858 / seconds Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='1521'DB:business_master_new loadtime:1.5433270931244 / seconds Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1 loadtime:1.543576002121 / seconds Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='1521'DB:business_master_new loadtime:1.5446071624756 / seconds Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1 loadtime:1.5448501110077 / seconds Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='1521'DB:business_master_new loadtime:1.5472021102905 / seconds Query loaded from cache:select * from geodata_geocity where city='Why' limit 1 loadtime:1.5474720001221 / seconds Query Executed:select id FROM `az` where city='Why' && SIC_code='1521'DB:business_master_new loadtime:1.5490071773529 / seconds Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1 loadtime:1.5493102073669 / seconds Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='1521'DB:business_master_new loadtime:1.5576541423798 / seconds Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1 loadtime:1.5580480098724 / seconds Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='1521'DB:business_master_new loadtime:1.5595791339874 / seconds Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1 loadtime:1.5598142147064 / seconds Query Executed:select id FROM `az` where city='Willcox' && SIC_code='1521'DB:business_master_new loadtime:1.5675110816956 / seconds Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1 loadtime:1.5678770542145 / seconds Query Executed:select id FROM `az` where city='Williams' && SIC_code='1521'DB:business_master_new loadtime:1.5753540992737 / seconds Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1 loadtime:1.5757241249084 / seconds Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='1521'DB:business_master_new loadtime:1.5770630836487 / seconds Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1 loadtime:1.5774672031403 / seconds Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='1521'DB:business_master_new loadtime:1.5847702026367 / seconds Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1 loadtime:1.5851671695709 / seconds Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='1521'DB:business_master_new loadtime:1.5875580310822 / seconds Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1 loadtime:1.5878031253815 / seconds Query Executed:select id FROM `az` where city='Winslow' && SIC_code='1521'DB:business_master_new loadtime:1.5954830646515 / seconds Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1 loadtime:1.5958530902863 / seconds Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='1521'DB:business_master_new loadtime:1.5986092090607 / seconds Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1 loadtime:1.5989952087402 / seconds Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='1521'DB:business_master_new loadtime:1.6001100540161 / seconds Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1 loadtime:1.6003890037537 / seconds Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='1521'DB:business_master_new loadtime:1.6026480197906 / seconds Query loaded from cache:select * from geodata_geocity where city='Young' limit 1 loadtime:1.6028611660004 / seconds Query Executed:select id FROM `az` where city='Young' && SIC_code='1521'DB:business_master_new loadtime:1.604926109314 / seconds Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1 loadtime:1.6053321361542 / seconds Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='1521'DB:business_master_new loadtime:1.6129441261292 / seconds Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1 loadtime:1.6133742332458 / seconds Query Executed:select id FROM `az` where city='Yucca' && SIC_code='1521'DB:business_master_new loadtime:1.6147592067719 / seconds Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1 loadtime:1.6151471138 / seconds Query Executed:select id FROM `az` where city='Yuma' && SIC_code='1521'DB:business_master_new loadtime:1.6250190734863 / seconds Query loaded from cache:select * from geodata_usstates order by statetitle asc loadtime:1.6256101131439 / seconds Operation directorystatepages executed (chunk cache operation) loadtime:1.6326172351837 / seconds Operation template executed (chunk cache operation) loadtime:1.6343882083893 / seconds template override:Default loadtime:1.6345570087433 / 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.6366341114044 / seconds Template Constructed, Array Rows:49 loadtime:1.6374180316925 / seconds TOTAL EXECUTION TIME: 1.63693 loadtime:1.6376020908356 / 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:1.6376140117645 TOTAL KEY ARRAYS: 69 |
