DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.8930130004883E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018348693847656 / seconds
host not found setting manual db connection
loadtime:0.009861946105957 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010125875473022 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010310888290405 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010378837585449 / seconds
zipcode:
loadtime:0.010417938232422 / seconds
Query Executed:select * from search_referrer where page_hash='d9ebff5fb546a3ff4b8ba2ab97fa7a28' limit 10 DB:ezrox_toadli
loadtime:0.010698795318604 / seconds
Operation header executed (non global)
loadtime:0.010734796524048 / seconds
Operation leaderboard executed (non global)
loadtime:0.010786771774292 / seconds
Operation square executed (non global)
loadtime:0.010816812515259 / seconds
Operation square_bottom executed (non global)
loadtime:0.010844945907593 / seconds
Operation smallsquare executed (non global)
loadtime:0.010869979858398 / seconds
Operation headeradright executed (non global)
loadtime:0.010894775390625 / seconds
Operation google_analytics executed (non global)
loadtime:0.010919809341431 / seconds
Operation topstories executed (non global)
loadtime:0.010944843292236 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010970830917358 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010994911193848 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011267900466919 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.01152777671814 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01157283782959 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.01164984703064 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011698961257935 / seconds
Template key: archive_menu pushed
loadtime:0.011708974838257 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011721849441528 / seconds
Template key: get_gravatar pushed
loadtime:0.011729001998901 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011737823486328 / seconds
*10)-10)+1 | start:0
loadtime:0.01177978515625 / seconds
DB connected to localhost business_master_new
loadtime:0.012036800384521 / seconds
Query Executed:select * from categories where cat_URLid='carwashes'DB:business_master_new
loadtime:0.01301097869873 / seconds
Query stored in cache : _QUERY_www.toadli.com43762a62581e33c46b987939486e4b95
loadtime:0.013080835342407 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.013131856918335 / seconds
Query Executed:select * from `az_catmap` where sic='7542' order by city ascDB:business_master_new
loadtime:0.028376817703247 / seconds
Query stored in cache : _QUERY_www.toadli.com8025e63fb9dd8fdc9c01afcb7d4b7e97
loadtime:0.029614925384521 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='arizona'
loadtime:0.029684782028198 / seconds
Query Executed:select sum(totalcount) as totalsum from `az_catmap` where sic='7542'DB:business_master_new
loadtime:0.031359910964966 / seconds
Query stored in cache : _QUERY_www.toadli.comb104e49fe6338dab7c47f4821c36ceae
loadtime:0.031400918960571 / seconds
287 / 11
loadtime:0.031466960906982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aguila' limit 1
loadtime:0.031547784805298 / seconds
Query Executed:select id FROM `az` where city='Aguila' && SIC_code='7542'DB:business_master_new
loadtime:0.050786972045898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ajo' limit 1
loadtime:0.050851821899414 / seconds
Query Executed:select id FROM `az` where city='Ajo' && SIC_code='7542'DB:business_master_new
loadtime:0.053691864013672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.053744792938232 / seconds
Query Executed:select id FROM `az` where city='Alpine' && SIC_code='7542'DB:business_master_new
loadtime:0.054789781570435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amado' limit 1
loadtime:0.054842948913574 / seconds
Query Executed:select id FROM `az` where city='Amado' && SIC_code='7542'DB:business_master_new
loadtime:0.055762767791748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anthem' limit 1
loadtime:0.055815935134888 / seconds
Query Executed:select id FROM `az` where city='Anthem' && SIC_code='7542'DB:business_master_new
loadtime:0.056480884552002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apache Junction' limit 1
loadtime:0.056538820266724 / seconds
Query Executed:select id FROM `az` where city='Apache Junction' && SIC_code='7542'DB:business_master_new
loadtime:0.060022830963135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arivaca' limit 1
loadtime:0.060093879699707 / seconds
Query Executed:select id FROM `az` where city='Arivaca' && SIC_code='7542'DB:business_master_new
loadtime:0.060939788818359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arizona City' limit 1
loadtime:0.060993909835815 / seconds
Query Executed:select id FROM `az` where city='Arizona City' && SIC_code='7542'DB:business_master_new
loadtime:0.061948776245117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.062007904052734 / seconds
Query Executed:select id FROM `az` where city='Arlington' && SIC_code='7542'DB:business_master_new
loadtime:0.062758922576904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash Fork' limit 1
loadtime:0.062811851501465 / seconds
Query Executed:select id FROM `az` where city='Ash Fork' && SIC_code='7542'DB:business_master_new
loadtime:0.063849925994873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avondale' limit 1
loadtime:0.063902854919434 / seconds
Query Executed:select id FROM `az` where city='Avondale' && SIC_code='7542'DB:business_master_new
loadtime:0.067184925079346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bagdad' limit 1
loadtime:0.067253828048706 / seconds
Query Executed:select id FROM `az` where city='Bagdad' && SIC_code='7542'DB:business_master_new
loadtime:0.068228960037231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bapchule' limit 1
loadtime:0.06828784942627 / seconds
Query Executed:select id FROM `az` where city='Bapchule' && SIC_code='7542'DB:business_master_new
loadtime:0.068774938583374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellemont' limit 1
loadtime:0.068832874298096 / seconds
Query Executed:select id FROM `az` where city='Bellemont' && SIC_code='7542'DB:business_master_new
loadtime:0.069555997848511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.069613933563232 / seconds
Query Executed:select id FROM `az` where city='Benson' && SIC_code='7542'DB:business_master_new
loadtime:0.072903871536255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bisbee' limit 1
loadtime:0.07296085357666 / seconds
Query Executed:select id FROM `az` where city='Bisbee' && SIC_code='7542'DB:business_master_new
loadtime:0.076221942901611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Canyon City' limit 1
loadtime:0.076279878616333 / seconds
Query Executed:select id FROM `az` where city='Black Canyon City' && SIC_code='7542'DB:business_master_new
loadtime:0.078050851821899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Cyn City' limit 1
loadtime:0.078108787536621 / seconds
Query Executed:select id FROM `az` where city='Black Cyn City' && SIC_code='7542'DB:business_master_new
loadtime:0.078634977340698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue' limit 1
loadtime:0.078688859939575 / seconds
Query Executed:select id FROM `az` where city='Blue' && SIC_code='7542'DB:business_master_new
loadtime:0.079211950302124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blue Gap' limit 1
loadtime:0.079263925552368 / seconds
Query Executed:select id FROM `az` where city='Blue Gap' && SIC_code='7542'DB:business_master_new
loadtime:0.079773902893066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bouse' limit 1
loadtime:0.079831838607788 / seconds
Query Executed:select id FROM `az` where city='Bouse' && SIC_code='7542'DB:business_master_new
loadtime:0.080635786056519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowie' limit 1
loadtime:0.080694913864136 / seconds
Query Executed:select id FROM `az` where city='Bowie' && SIC_code='7542'DB:business_master_new
loadtime:0.081612825393677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buckeye' limit 1
loadtime:0.081664800643921 / seconds
Query Executed:select id FROM `az` where city='Buckeye' && SIC_code='7542'DB:business_master_new
loadtime:0.084939956665039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullhead City' limit 1
loadtime:0.085013866424561 / seconds
Query Executed:select id FROM `az` where city='Bullhead City' && SIC_code='7542'DB:business_master_new
loadtime:0.088295936584473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bylas' limit 1
loadtime:0.088382959365845 / seconds
Query Executed:select id FROM `az` where city='Bylas' && SIC_code='7542'DB:business_master_new
loadtime:0.08897876739502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:0.089034795761108 / seconds
Query Executed:select id FROM `az` where city='Cameron' && SIC_code='7542'DB:business_master_new
loadtime:0.089839935302734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Verde' limit 1
loadtime:0.089897871017456 / seconds
Query Executed:select id FROM `az` where city='Camp Verde' && SIC_code='7542'DB:business_master_new
loadtime:0.093167781829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carefree' limit 1
loadtime:0.093235969543457 / seconds
Query Executed:select id FROM `az` where city='Carefree' && SIC_code='7542'DB:business_master_new
loadtime:0.096479892730713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casa Grande' limit 1
loadtime:0.096542835235596 / seconds
Query Executed:select id FROM `az` where city='Casa Grande' && SIC_code='7542'DB:business_master_new
loadtime:0.099870920181274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashion' limit 1
loadtime:0.099941968917847 / seconds
Query Executed:select id FROM `az` where city='Cashion' && SIC_code='7542'DB:business_master_new
loadtime:0.10082793235779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catalina' limit 1
loadtime:0.10088682174683 / seconds
Query Executed:select id FROM `az` where city='Catalina' && SIC_code='7542'DB:business_master_new
loadtime:0.10179281234741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cave Creek' limit 1
loadtime:0.10184597969055 / seconds
Query Executed:select id FROM `az` where city='Cave Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.10510683059692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.10517978668213 / seconds
Query Executed:select id FROM `az` where city='Central' && SIC_code='7542'DB:business_master_new
loadtime:0.10585284233093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chambers' limit 1
loadtime:0.10590791702271 / seconds
Query Executed:select id FROM `az` where city='Chambers' && SIC_code='7542'DB:business_master_new
loadtime:0.10666298866272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler' limit 1
loadtime:0.10672283172607 / seconds
Query Executed:select id FROM `az` where city='Chandler' && SIC_code='7542'DB:business_master_new
loadtime:0.11000800132751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chandler Heights' limit 1
loadtime:0.1100959777832 / seconds
Query Executed:select id FROM `az` where city='Chandler Heights' && SIC_code='7542'DB:business_master_new
loadtime:0.11083984375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinle' limit 1
loadtime:0.11090087890625 / seconds
Query Executed:select id FROM `az` where city='Chinle' && SIC_code='7542'DB:business_master_new
loadtime:0.11381983757019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chino Valley' limit 1
loadtime:0.11387491226196 / seconds
Query Executed:select id FROM `az` where city='Chino Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.1171498298645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chloride' limit 1
loadtime:0.11722779273987 / seconds
Query Executed:select id FROM `az` where city='Chloride' && SIC_code='7542'DB:business_master_new
loadtime:0.11787986755371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibecue' limit 1
loadtime:0.11794090270996 / seconds
Query Executed:select id FROM `az` where city='Cibecue' && SIC_code='7542'DB:business_master_new
loadtime:0.11847496032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cibola' limit 1
loadtime:0.11853981018066 / seconds
Query Executed:select id FROM `az` where city='Cibola' && SIC_code='7542'DB:business_master_new
loadtime:0.11909580230713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkdale' limit 1
loadtime:0.11914682388306 / seconds
Query Executed:select id FROM `az` where city='Clarkdale' && SIC_code='7542'DB:business_master_new
loadtime:0.12128496170044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay Springs' limit 1
loadtime:0.12135791778564 / seconds
Query Executed:select id FROM `az` where city='Clay Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.12197184562683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claypool' limit 1
loadtime:0.12203097343445 / seconds
Query Executed:select id FROM `az` where city='Claypool' && SIC_code='7542'DB:business_master_new
loadtime:0.12337183952332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.12342977523804 / seconds
Query Executed:select id FROM `az` where city='Clifton' && SIC_code='7542'DB:business_master_new
loadtime:0.12485694885254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cochise' limit 1
loadtime:0.12491488456726 / seconds
Query Executed:select id FROM `az` where city='Cochise' && SIC_code='7542'DB:business_master_new
loadtime:0.12590193748474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colorado City' limit 1
loadtime:0.12596082687378 / seconds
Query Executed:select id FROM `az` where city='Colorado City' && SIC_code='7542'DB:business_master_new
loadtime:0.12775278091431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concho' limit 1
loadtime:0.12781882286072 / seconds
Query Executed:select id FROM `az` where city='Concho' && SIC_code='7542'DB:business_master_new
loadtime:0.12864089012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Congress' limit 1
loadtime:0.1286997795105 / seconds
Query Executed:select id FROM `az` where city='Congress' && SIC_code='7542'DB:business_master_new
loadtime:0.12970590591431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coolidge' limit 1
loadtime:0.12976479530334 / seconds
Query Executed:select id FROM `az` where city='Coolidge' && SIC_code='7542'DB:business_master_new
loadtime:0.13199996948242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornville' limit 1
loadtime:0.13205289840698 / seconds
Query Executed:select id FROM `az` where city='Cornville' && SIC_code='7542'DB:business_master_new
loadtime:0.13423490524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cortaro' limit 1
loadtime:0.13429379463196 / seconds
Query Executed:select id FROM `az` where city='Cortaro' && SIC_code='7542'DB:business_master_new
loadtime:0.1353588104248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.13541483879089 / seconds
Query Executed:select id FROM `az` where city='Cottonwood' && SIC_code='7542'DB:business_master_new
loadtime:0.1387038230896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crown King' limit 1
loadtime:0.13877582550049 / seconds
Query Executed:select id FROM `az` where city='Crown King' && SIC_code='7542'DB:business_master_new
loadtime:0.13935685157776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dateland' limit 1
loadtime:0.13941788673401 / seconds
Query Executed:select id FROM `az` where city='Dateland' && SIC_code='7542'DB:business_master_new
loadtime:0.13998484611511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis Monthan' limit 1
loadtime:0.1400408744812 / seconds
Query Executed:select id FROM `az` where city='Davis Monthan' && SIC_code='7542'DB:business_master_new
loadtime:0.14061689376831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennehotso' limit 1
loadtime:0.14067387580872 / seconds
Query Executed:select id FROM `az` where city='Dennehotso' && SIC_code='7542'DB:business_master_new
loadtime:0.14124989509583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dewey' limit 1
loadtime:0.1413037776947 / seconds
Query Executed:select id FROM `az` where city='Dewey' && SIC_code='7542'DB:business_master_new
loadtime:0.14458394050598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolan Springs' limit 1
loadtime:0.14463686943054 / seconds
Query Executed:select id FROM `az` where city='Dolan Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.14561891555786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.14567279815674 / seconds
Query Executed:select id FROM `az` where city='Douglas' && SIC_code='7542'DB:business_master_new
loadtime:0.14895296096802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dragoon' limit 1
loadtime:0.14901280403137 / seconds
Query Executed:select id FROM `az` where city='Dragoon' && SIC_code='7542'DB:business_master_new
loadtime:0.14967799186707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncan' limit 1
loadtime:0.14973497390747 / seconds
Query Executed:select id FROM `az` where city='Duncan' && SIC_code='7542'DB:business_master_new
loadtime:0.1513819694519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagar' limit 1
loadtime:0.15144395828247 / seconds
Query Executed:select id FROM `az` where city='Eagar' && SIC_code='7542'DB:business_master_new
loadtime:0.15403079986572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.15408897399902 / seconds
Query Executed:select id FROM `az` where city='Eden' && SIC_code='7542'DB:business_master_new
loadtime:0.15458798408508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ehrenberg' limit 1
loadtime:0.15464782714844 / seconds
Query Executed:select id FROM `az` where city='Ehrenberg' && SIC_code='7542'DB:business_master_new
loadtime:0.15621399879456 / seconds
Query loaded from cache:select * from geodata_geocity where city='El Mirage' limit 1
loadtime:0.15627098083496 / seconds
Query Executed:select id FROM `az` where city='El Mirage' && SIC_code='7542'DB:business_master_new
loadtime:0.15956091880798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elfrida' limit 1
loadtime:0.15962386131287 / seconds
Query Executed:select id FROM `az` where city='Elfrida' && SIC_code='7542'DB:business_master_new
loadtime:0.16098499298096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elgin' limit 1
loadtime:0.16104197502136 / seconds
Query Executed:select id FROM `az` where city='Elgin' && SIC_code='7542'DB:business_master_new
loadtime:0.16174793243408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eloy' limit 1
loadtime:0.16180086135864 / seconds
Query Executed:select id FROM `az` where city='Eloy' && SIC_code='7542'DB:business_master_new
loadtime:0.16345596313477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagstaff' limit 1
loadtime:0.16351890563965 / seconds
Query Executed:select id FROM `az` where city='Flagstaff' && SIC_code='7542'DB:business_master_new
loadtime:0.16679692268372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:0.16687989234924 / seconds
Query Executed:select id FROM `az` where city='Florence' && SIC_code='7542'DB:business_master_new
loadtime:0.16822385787964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Lakes' limit 1
loadtime:0.16827893257141 / seconds
Query Executed:select id FROM `az` where city='Forest Lakes' && SIC_code='7542'DB:business_master_new
loadtime:0.16894698143005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Apache' limit 1
loadtime:0.16900277137756 / seconds
Query Executed:select id FROM `az` where city='Fort Apache' && SIC_code='7542'DB:business_master_new
loadtime:0.16954898834229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Defiance' limit 1
loadtime:0.16960382461548 / seconds
Query Executed:select id FROM `az` where city='Fort Defiance' && SIC_code='7542'DB:business_master_new
loadtime:0.17133283615112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Huachuca' limit 1
loadtime:0.17139792442322 / seconds
Query Executed:select id FROM `az` where city='Fort Huachuca' && SIC_code='7542'DB:business_master_new
loadtime:0.17329478263855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mcdowell' limit 1
loadtime:0.17336297035217 / seconds
Query Executed:select id FROM `az` where city='Fort Mcdowell' && SIC_code='7542'DB:business_master_new
loadtime:0.17415595054626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mohave' limit 1
loadtime:0.17421293258667 / seconds
Query Executed:select id FROM `az` where city='Fort Mohave' && SIC_code='7542'DB:business_master_new
loadtime:0.17753195762634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Thomas' limit 1
loadtime:0.17760491371155 / seconds
Query Executed:select id FROM `az` where city='Fort Thomas' && SIC_code='7542'DB:business_master_new
loadtime:0.17836380004883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Hills' limit 1
loadtime:0.17841792106628 / seconds
Query Executed:select id FROM `az` where city='Fountain Hills' && SIC_code='7542'DB:business_master_new
loadtime:0.18168091773987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredonia' limit 1
loadtime:0.18175387382507 / seconds
Query Executed:select id FROM `az` where city='Fredonia' && SIC_code='7542'DB:business_master_new
loadtime:0.18316388130188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:0.18322277069092 / seconds
Query Executed:select id FROM `az` where city='Gadsden' && SIC_code='7542'DB:business_master_new
loadtime:0.18372678756714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ganado' limit 1
loadtime:0.18378090858459 / seconds
Query Executed:select id FROM `az` where city='Ganado' && SIC_code='7542'DB:business_master_new
loadtime:0.18529677391052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gila Bend' limit 1
loadtime:0.18535780906677 / seconds
Query Executed:select id FROM `az` where city='Gila Bend' && SIC_code='7542'DB:business_master_new
loadtime:0.18735980987549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbert' limit 1
loadtime:0.18741297721863 / seconds
Query Executed:select id FROM `az` where city='Gilbert' && SIC_code='7542'DB:business_master_new
loadtime:0.19069194793701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.1907639503479 / seconds
Query Executed:select id FROM `az` where city='Glendale' && SIC_code='7542'DB:business_master_new
loadtime:0.19405698776245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Globe' limit 1
loadtime:0.19414377212524 / seconds
Query Executed:select id FROM `az` where city='Globe' && SIC_code='7542'DB:business_master_new
loadtime:0.19743394851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Golden Valley' limit 1
loadtime:0.19751381874084 / seconds
Query Executed:select id FROM `az` where city='Golden Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.20020079612732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodyear' limit 1
loadtime:0.20025682449341 / seconds
Query Executed:select id FROM `az` where city='Goodyear' && SIC_code='7542'DB:business_master_new
loadtime:0.20352482795715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Canyon' limit 1
loadtime:0.20358300209045 / seconds
Query Executed:select id FROM `az` where city='Grand Canyon' && SIC_code='7542'DB:business_master_new
loadtime:0.2054328918457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gray Mountain' limit 1
loadtime:0.20548582077026 / seconds
Query Executed:select id FROM `az` where city='Gray Mountain' && SIC_code='7542'DB:business_master_new
loadtime:0.2059919834137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Valley' limit 1
loadtime:0.20605087280273 / seconds
Query Executed:select id FROM `az` where city='Green Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.20930886268616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenehaven' limit 1
loadtime:0.20938777923584 / seconds
Query Executed:select id FROM `az` where city='Greenehaven' && SIC_code='7542'DB:business_master_new
loadtime:0.20990395545959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greer' limit 1
loadtime:0.2099609375 / seconds
Query Executed:select id FROM `az` where city='Greer' && SIC_code='7542'DB:business_master_new
loadtime:0.21102690696716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guadalupe' limit 1
loadtime:0.21107983589172 / seconds
Query Executed:select id FROM `az` where city='Guadalupe' && SIC_code='7542'DB:business_master_new
loadtime:0.21168184280396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackberry' limit 1
loadtime:0.21174287796021 / seconds
Query Executed:select id FROM `az` where city='Hackberry' && SIC_code='7542'DB:business_master_new
loadtime:0.21223187446594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Happy Jack' limit 1
loadtime:0.21228289604187 / seconds
Query Executed:select id FROM `az` where city='Happy Jack' && SIC_code='7542'DB:business_master_new
loadtime:0.21302580833435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:0.21308279037476 / seconds
Query Executed:select id FROM `az` where city='Hayden' && SIC_code='7542'DB:business_master_new
loadtime:0.21405386924744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber' limit 1
loadtime:0.214106798172 / seconds
Query Executed:select id FROM `az` where city='Heber' && SIC_code='7542'DB:business_master_new
loadtime:0.21506285667419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hereford' limit 1
loadtime:0.21512079238892 / seconds
Query Executed:select id FROM `az` where city='Hereford' && SIC_code='7542'DB:business_master_new
loadtime:0.21811485290527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higley' limit 1
loadtime:0.21817493438721 / seconds
Query Executed:select id FROM `az` where city='Higley' && SIC_code='7542'DB:business_master_new
loadtime:0.2214629650116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holbrook' limit 1
loadtime:0.22153496742249 / seconds
Query Executed:select id FROM `az` where city='Holbrook' && SIC_code='7542'DB:business_master_new
loadtime:0.22479891777039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hotevilla' limit 1
loadtime:0.22486996650696 / seconds
Query Executed:select id FROM `az` where city='Hotevilla' && SIC_code='7542'DB:business_master_new
loadtime:0.22541785240173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houck' limit 1
loadtime:0.22547197341919 / seconds
Query Executed:select id FROM `az` where city='Houck' && SIC_code='7542'DB:business_master_new
loadtime:0.2261049747467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huachuca City' limit 1
loadtime:0.22616195678711 / seconds
Query Executed:select id FROM `az` where city='Huachuca City' && SIC_code='7542'DB:business_master_new
loadtime:0.22944378852844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hualapai' limit 1
loadtime:0.22949695587158 / seconds
Query Executed:select id FROM `az` where city='Hualapai' && SIC_code='7542'DB:business_master_new
loadtime:0.23004293441772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Humboldt' limit 1
loadtime:0.23009490966797 / seconds
Query Executed:select id FROM `az` where city='Humboldt' && SIC_code='7542'DB:business_master_new
loadtime:0.23112297058105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Wells' limit 1
loadtime:0.2311749458313 / seconds
Query Executed:select id FROM `az` where city='Indian Wells' && SIC_code='7542'DB:business_master_new
loadtime:0.23173689842224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Springs' limit 1
loadtime:0.23178887367249 / seconds
Query Executed:select id FROM `az` where city='Iron Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.23228096961975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jerome' limit 1
loadtime:0.23233699798584 / seconds
Query Executed:select id FROM `az` where city='Jerome' && SIC_code='7542'DB:business_master_new
loadtime:0.23403382301331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph City' limit 1
loadtime:0.23409199714661 / seconds
Query Executed:select id FROM `az` where city='Joseph City' && SIC_code='7542'DB:business_master_new
loadtime:0.23502588272095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibeto' limit 1
loadtime:0.23507881164551 / seconds
Query Executed:select id FROM `az` where city='Kaibeto' && SIC_code='7542'DB:business_master_new
loadtime:0.2356858253479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaibito' limit 1
loadtime:0.23573780059814 / seconds
Query Executed:select id FROM `az` where city='Kaibito' && SIC_code='7542'DB:business_master_new
loadtime:0.23626279830933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kayenta' limit 1
loadtime:0.23631381988525 / seconds
Query Executed:select id FROM `az` where city='Kayenta' && SIC_code='7542'DB:business_master_new
loadtime:0.23811388015747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keams Canyon' limit 1
loadtime:0.23817086219788 / seconds
Query Executed:select id FROM `az` where city='Keams Canyon' && SIC_code='7542'DB:business_master_new
loadtime:0.23906588554382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:0.23911786079407 / seconds
Query Executed:select id FROM `az` where city='Kearny' && SIC_code='7542'DB:business_master_new
loadtime:0.23994278907776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingman' limit 1
loadtime:0.239994764328 / seconds
Query Executed:select id FROM `az` where city='Kingman' && SIC_code='7542'DB:business_master_new
loadtime:0.24326682090759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kirkland' limit 1
loadtime:0.24335598945618 / seconds
Query Executed:select id FROM `az` where city='Kirkland' && SIC_code='7542'DB:business_master_new
loadtime:0.24424481391907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Village' limit 1
loadtime:0.244304895401 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Village' && SIC_code='7542'DB:business_master_new
loadtime:0.24509882926941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kykotsmovi Vlg' limit 1
loadtime:0.24515080451965 / seconds
Query Executed:select id FROM `az` where city='Kykotsmovi Vlg' && SIC_code='7542'DB:business_master_new
loadtime:0.24571299552917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Havasu City' limit 1
loadtime:0.24577498435974 / seconds
Query Executed:select id FROM `az` where city='Lake Havasu City' && SIC_code='7542'DB:business_master_new
loadtime:0.24904799461365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Montezuma' limit 1
loadtime:0.24912595748901 / seconds
Query Executed:select id FROM `az` where city='Lake Montezuma' && SIC_code='7542'DB:business_master_new
loadtime:0.24985980987549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.24991488456726 / seconds
Query Executed:select id FROM `az` where city='Lakeside' && SIC_code='7542'DB:business_master_new
loadtime:0.25315380096436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laveen' limit 1
loadtime:0.2532069683075 / seconds
Query Executed:select id FROM `az` where city='Laveen' && SIC_code='7542'DB:business_master_new
loadtime:0.25646686553955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leupp' limit 1
loadtime:0.25652885437012 / seconds
Query Executed:select id FROM `az` where city='Leupp' && SIC_code='7542'DB:business_master_new
loadtime:0.25715398788452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield Park' limit 1
loadtime:0.25720977783203 / seconds
Query Executed:select id FROM `az` where city='Litchfield Park' && SIC_code='7542'DB:business_master_new
loadtime:0.26049900054932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littlefield' limit 1
loadtime:0.26057076454163 / seconds
Query Executed:select id FROM `az` where city='Littlefield' && SIC_code='7542'DB:business_master_new
loadtime:0.26145195960999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukachukai' limit 1
loadtime:0.26151084899902 / seconds
Query Executed:select id FROM `az` where city='Lukachukai' && SIC_code='7542'DB:business_master_new
loadtime:0.26207399368286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luke Afb' limit 1
loadtime:0.2621328830719 / seconds
Query Executed:select id FROM `az` where city='Luke Afb' && SIC_code='7542'DB:business_master_new
loadtime:0.26300692558289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lukeville' limit 1
loadtime:0.26305985450745 / seconds
Query Executed:select id FROM `az` where city='Lukeville' && SIC_code='7542'DB:business_master_new
loadtime:0.26366090774536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lupton' limit 1
loadtime:0.2637197971344 / seconds
Query Executed:select id FROM `az` where city='Lupton' && SIC_code='7542'DB:business_master_new
loadtime:0.26449990272522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madera Canyon' limit 1
loadtime:0.26455688476562 / seconds
Query Executed:select id FROM `az` where city='Madera Canyon' && SIC_code='7542'DB:business_master_new
loadtime:0.26501798629761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mammoth' limit 1
loadtime:0.26506876945496 / seconds
Query Executed:select id FROM `az` where city='Mammoth' && SIC_code='7542'DB:business_master_new
loadtime:0.26570892333984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Many Farms' limit 1
loadtime:0.26576590538025 / seconds
Query Executed:select id FROM `az` where city='Many Farms' && SIC_code='7542'DB:business_master_new
loadtime:0.26639890670776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marana' limit 1
loadtime:0.26645088195801 / seconds
Query Executed:select id FROM `az` where city='Marana' && SIC_code='7542'DB:business_master_new
loadtime:0.26972889900208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Canyon' limit 1
loadtime:0.26979088783264 / seconds
Query Executed:select id FROM `az` where city='Marble Canyon' && SIC_code='7542'DB:business_master_new
loadtime:0.27041077613831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maricopa' limit 1
loadtime:0.27046298980713 / seconds
Query Executed:select id FROM `az` where city='Maricopa' && SIC_code='7542'DB:business_master_new
loadtime:0.27373480796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayer' limit 1
loadtime:0.27378797531128 / seconds
Query Executed:select id FROM `az` where city='Mayer' && SIC_code='7542'DB:business_master_new
loadtime:0.27623391151428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Nary' limit 1
loadtime:0.27629089355469 / seconds
Query Executed:select id FROM `az` where city='Mc Nary' && SIC_code='7542'DB:business_master_new
loadtime:0.27677583694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Neal' limit 1
loadtime:0.2768337726593 / seconds
Query Executed:select id FROM `az` where city='Mc Neal' && SIC_code='7542'DB:business_master_new
loadtime:0.27765989303589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcnary' limit 1
loadtime:0.27771282196045 / seconds
Query Executed:select id FROM `az` where city='Mcnary' && SIC_code='7542'DB:business_master_new
loadtime:0.27831482887268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadview' limit 1
loadtime:0.27837681770325 / seconds
Query Executed:select id FROM `az` where city='Meadview' && SIC_code='7542'DB:business_master_new
loadtime:0.27925682067871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mesa' limit 1
loadtime:0.27931785583496 / seconds
Query Executed:select id FROM `az` where city='Mesa' && SIC_code='7542'DB:business_master_new
loadtime:0.28264594078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Miami' limit 1
loadtime:0.28275489807129 / seconds
Query Executed:select id FROM `az` where city='Miami' && SIC_code='7542'DB:business_master_new
loadtime:0.2851459980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mohave Valley' limit 1
loadtime:0.28520393371582 / seconds
Query Executed:select id FROM `az` where city='Mohave Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.2885308265686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morenci' limit 1
loadtime:0.28860282897949 / seconds
Query Executed:select id FROM `az` where city='Morenci' && SIC_code='7542'DB:business_master_new
loadtime:0.28972291946411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mormon Lake' limit 1
loadtime:0.28978085517883 / seconds
Query Executed:select id FROM `az` where city='Mormon Lake' && SIC_code='7542'DB:business_master_new
loadtime:0.29040288925171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:0.29045987129211 / seconds
Query Executed:select id FROM `az` where city='Morristown' && SIC_code='7542'DB:business_master_new
loadtime:0.29146385192871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Lemmon' limit 1
loadtime:0.29152584075928 / seconds
Query Executed:select id FROM `az` where city='Mount Lemmon' && SIC_code='7542'DB:business_master_new
loadtime:0.29218697547913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Lemmon' limit 1
loadtime:0.29224491119385 / seconds
Query Executed:select id FROM `az` where city='Mt Lemmon' && SIC_code='7542'DB:business_master_new
loadtime:0.29275679588318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munds Park' limit 1
loadtime:0.29281377792358 / seconds
Query Executed:select id FROM `az` where city='Munds Park' && SIC_code='7542'DB:business_master_new
loadtime:0.29389691352844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naco' limit 1
loadtime:0.29396295547485 / seconds
Query Executed:select id FROM `az` where city='Naco' && SIC_code='7542'DB:business_master_new
loadtime:0.29473495483398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nazlini' limit 1
loadtime:0.29479384422302 / seconds
Query Executed:select id FROM `az` where city='Nazlini' && SIC_code='7542'DB:business_master_new
loadtime:0.29531192779541 / seconds
Query loaded from cache:select * from geodata_geocity where city='New River' limit 1
loadtime:0.29537296295166 / seconds
Query Executed:select id FROM `az` where city='New River' && SIC_code='7542'DB:business_master_new
loadtime:0.29759097099304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nogales' limit 1
loadtime:0.29764294624329 / seconds
Query Executed:select id FROM `az` where city='Nogales' && SIC_code='7542'DB:business_master_new
loadtime:0.30099987983704 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Rim' limit 1
loadtime:0.30107498168945 / seconds
Query Executed:select id FROM `az` where city='North Rim' && SIC_code='7542'DB:business_master_new
loadtime:0.3016459941864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutrioso' limit 1
loadtime:0.30170488357544 / seconds
Query Executed:select id FROM `az` where city='Nutrioso' && SIC_code='7542'DB:business_master_new
loadtime:0.30236887931824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oatman' limit 1
loadtime:0.30242586135864 / seconds
Query Executed:select id FROM `az` where city='Oatman' && SIC_code='7542'DB:business_master_new
loadtime:0.30329394340515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oracle' limit 1
loadtime:0.30336093902588 / seconds
Query Executed:select id FROM `az` where city='Oracle' && SIC_code='7542'DB:business_master_new
loadtime:0.304358959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oro Valley' limit 1
loadtime:0.30441689491272 / seconds
Query Executed:select id FROM `az` where city='Oro Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.30593180656433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Overgaard' limit 1
loadtime:0.30598497390747 / seconds
Query Executed:select id FROM `az` where city='Overgaard' && SIC_code='7542'DB:business_master_new
loadtime:0.3073718547821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Page' limit 1
loadtime:0.30742478370667 / seconds
Query Executed:select id FROM `az` where city='Page' && SIC_code='7542'DB:business_master_new
loadtime:0.31069183349609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palo Verde' limit 1
loadtime:0.31074500083923 / seconds
Query Executed:select id FROM `az` where city='Palo Verde' && SIC_code='7542'DB:business_master_new
loadtime:0.3113648891449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise Valley' limit 1
loadtime:0.31141686439514 / seconds
Query Executed:select id FROM `az` where city='Paradise Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.31467986106873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parker' limit 1
loadtime:0.31473684310913 / seconds
Query Executed:select id FROM `az` where city='Parker' && SIC_code='7542'DB:business_master_new
loadtime:0.31800389289856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks' limit 1
loadtime:0.31806087493896 / seconds
Query Executed:select id FROM `az` where city='Parks' && SIC_code='7542'DB:business_master_new
loadtime:0.31889891624451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parks Community Post Office' limit 1
loadtime:0.31895089149475 / seconds
Query Executed:select id FROM `az` where city='Parks Community Post Office' && SIC_code='7542'DB:business_master_new
loadtime:0.31939888000488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patagonia' limit 1
loadtime:0.31945586204529 / seconds
Query Executed:select id FROM `az` where city='Patagonia' && SIC_code='7542'DB:business_master_new
loadtime:0.32071685791016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulden' limit 1
loadtime:0.32077479362488 / seconds
Query Executed:select id FROM `az` where city='Paulden' && SIC_code='7542'DB:business_master_new
loadtime:0.32208681106567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.32214498519897 / seconds
Query Executed:select id FROM `az` where city='Payson' && SIC_code='7542'DB:business_master_new
loadtime:0.32539582252502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peach Springs' limit 1
loadtime:0.32546281814575 / seconds
Query Executed:select id FROM `az` where city='Peach Springs' && SIC_code='7542'DB:business_master_new
loadtime:0.32642579078674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearce' limit 1
loadtime:0.32648396492004 / seconds
Query Executed:select id FROM `az` where city='Pearce' && SIC_code='7542'DB:business_master_new
loadtime:0.32855296134949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peeples Valley' limit 1
loadtime:0.32861089706421 / seconds
Query Executed:select id FROM `az` where city='Peeples Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.32912683486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoria' limit 1
loadtime:0.32918477058411 / seconds
Query Executed:select id FROM `az` where city='Peoria' && SIC_code='7542'DB:business_master_new
loadtime:0.33248090744019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peridot' limit 1
loadtime:0.33256697654724 / seconds
Query Executed:select id FROM `az` where city='Peridot' && SIC_code='7542'DB:business_master_new
loadtime:0.33331799507141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pet Frst Natl Pk' limit 1
loadtime:0.33338594436646 / seconds
Query Executed:select id FROM `az` where city='Pet Frst Natl Pk' && SIC_code='7542'DB:business_master_new
loadtime:0.333899974823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrified Forest Natl Pk' limit 1
loadtime:0.33396196365356 / seconds
Query Executed:select id FROM `az` where city='Petrified Forest Natl Pk' && SIC_code='7542'DB:business_master_new
loadtime:0.33453679084778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phoenix' limit 1
loadtime:0.33458995819092 / seconds
Query Executed:select id FROM `az` where city='Phoenix' && SIC_code='7542'DB:business_master_new
loadtime:0.33798885345459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picacho' limit 1
loadtime:0.33817887306213 / seconds
Query Executed:select id FROM `az` where city='Picacho' && SIC_code='7542'DB:business_master_new
loadtime:0.33879899978638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pima' limit 1
loadtime:0.33886981010437 / seconds
Query Executed:select id FROM `az` where city='Pima' && SIC_code='7542'DB:business_master_new
loadtime:0.34054088592529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine' limit 1
loadtime:0.34059882164001 / seconds
Query Executed:select id FROM `az` where city='Pine' && SIC_code='7542'DB:business_master_new
loadtime:0.34293389320374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinedale' limit 1
loadtime:0.34298777580261 / seconds
Query Executed:select id FROM `az` where city='Pinedale' && SIC_code='7542'DB:business_master_new
loadtime:0.34358477592468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetop' limit 1
loadtime:0.34363794326782 / seconds
Query Executed:select id FROM `az` where city='Pinetop' && SIC_code='7542'DB:business_master_new
loadtime:0.34733200073242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinon' limit 1
loadtime:0.3474109172821 / seconds
Query Executed:select id FROM `az` where city='Pinon' && SIC_code='7542'DB:business_master_new
loadtime:0.34813690185547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pirtleville' limit 1
loadtime:0.34819078445435 / seconds
Query Executed:select id FROM `az` where city='Pirtleville' && SIC_code='7542'DB:business_master_new
loadtime:0.34885382652283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polacca' limit 1
loadtime:0.34891080856323 / seconds
Query Executed:select id FROM `az` where city='Polacca' && SIC_code='7542'DB:business_master_new
loadtime:0.34961199760437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomerene' limit 1
loadtime:0.34966492652893 / seconds
Query Executed:select id FROM `az` where city='Pomerene' && SIC_code='7542'DB:business_master_new
loadtime:0.35021877288818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portal' limit 1
loadtime:0.35027480125427 / seconds
Query Executed:select id FROM `az` where city='Portal' && SIC_code='7542'DB:business_master_new
loadtime:0.35084295272827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poston' limit 1
loadtime:0.35089588165283 / seconds
Query Executed:select id FROM `az` where city='Poston' && SIC_code='7542'DB:business_master_new
loadtime:0.35162377357483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott' limit 1
loadtime:0.35167980194092 / seconds
Query Executed:select id FROM `az` where city='Prescott' && SIC_code='7542'DB:business_master_new
loadtime:0.35498094558716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prescott Valley' limit 1
loadtime:0.35505986213684 / seconds
Query Executed:select id FROM `az` where city='Prescott Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.35835886001587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quartzsite' limit 1
loadtime:0.35842895507812 / seconds
Query Executed:select id FROM `az` where city='Quartzsite' && SIC_code='7542'DB:business_master_new
loadtime:0.3616988658905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Queen Creek' limit 1
loadtime:0.36175799369812 / seconds
Query Executed:select id FROM `az` where city='Queen Creek' && SIC_code='7542'DB:business_master_new
loadtime:0.36504483222961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Rock' limit 1
loadtime:0.36511087417603 / seconds
Query Executed:select id FROM `az` where city='Red Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.36574292182922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Valley' limit 1
loadtime:0.3657968044281 / seconds
Query Executed:select id FROM `az` where city='Red Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.36644577980042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rillito' limit 1
loadtime:0.36651182174683 / seconds
Query Executed:select id FROM `az` where city='Rillito' && SIC_code='7542'DB:business_master_new
loadtime:0.36725378036499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rimrock' limit 1
loadtime:0.36730599403381 / seconds
Query Executed:select id FROM `az` where city='Rimrock' && SIC_code='7542'DB:business_master_new
loadtime:0.3689877986908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Rico' limit 1
loadtime:0.36904692649841 / seconds
Query Executed:select id FROM `az` where city='Rio Rico' && SIC_code='7542'DB:business_master_new
loadtime:0.37253999710083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Verde' limit 1
loadtime:0.37259793281555 / seconds
Query Executed:select id FROM `az` where city='Rio Verde' && SIC_code='7542'DB:business_master_new
loadtime:0.3735888004303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Point' limit 1
loadtime:0.3736469745636 / seconds
Query Executed:select id FROM `az` where city='Rock Point' && SIC_code='7542'DB:business_master_new
loadtime:0.37427282333374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roll' limit 1
loadtime:0.37432384490967 / seconds
Query Executed:select id FROM `az` where city='Roll' && SIC_code='7542'DB:business_master_new
loadtime:0.37505197525024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.37510895729065 / seconds
Query Executed:select id FROM `az` where city='Roosevelt' && SIC_code='7542'DB:business_master_new
loadtime:0.37605381011963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Round Rock' limit 1
loadtime:0.37611079216003 / seconds
Query Executed:select id FROM `az` where city='Round Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.37665295600891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sacaton' limit 1
loadtime:0.37670683860779 / seconds
Query Executed:select id FROM `az` where city='Sacaton' && SIC_code='7542'DB:business_master_new
loadtime:0.37749481201172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:0.37755298614502 / seconds
Query Executed:select id FROM `az` where city='Safford' && SIC_code='7542'DB:business_master_new
loadtime:0.3808228969574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sahuarita' limit 1
loadtime:0.3808958530426 / seconds
Query Executed:select id FROM `az` where city='Sahuarita' && SIC_code='7542'DB:business_master_new
loadtime:0.38415694236755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint David' limit 1
loadtime:0.38421177864075 / seconds
Query Executed:select id FROM `az` where city='Saint David' && SIC_code='7542'DB:business_master_new
loadtime:0.38548183441162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Johns' limit 1
loadtime:0.38554382324219 / seconds
Query Executed:select id FROM `az` where city='Saint Johns' && SIC_code='7542'DB:business_master_new
loadtime:0.38845181465149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Michaels' limit 1
loadtime:0.38851094245911 / seconds
Query Executed:select id FROM `az` where city='Saint Michaels' && SIC_code='7542'DB:business_master_new
loadtime:0.38927698135376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salome' limit 1
loadtime:0.38933277130127 / seconds
Query Executed:select id FROM `az` where city='Salome' && SIC_code='7542'DB:business_master_new
loadtime:0.39135479927063 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Carlos' limit 1
loadtime:0.39140892028809 / seconds
Query Executed:select id FROM `az` where city='San Carlos' && SIC_code='7542'DB:business_master_new
loadtime:0.39313292503357 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Luis' limit 1
loadtime:0.39318585395813 / seconds
Query Executed:select id FROM `az` where city='San Luis' && SIC_code='7542'DB:business_master_new
loadtime:0.39472579956055 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Manuel' limit 1
loadtime:0.39478397369385 / seconds
Query Executed:select id FROM `az` where city='San Manuel' && SIC_code='7542'DB:business_master_new
loadtime:0.39572691917419 / seconds
Query loaded from cache:select * from geodata_geocity where city='San Simon' limit 1
loadtime:0.39577984809875 / seconds
Query Executed:select id FROM `az` where city='San Simon' && SIC_code='7542'DB:business_master_new
loadtime:0.39684581756592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanders' limit 1
loadtime:0.39689993858337 / seconds
Query Executed:select id FROM `az` where city='Sanders' && SIC_code='7542'DB:business_master_new
loadtime:0.39865279197693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sasabe' limit 1
loadtime:0.39871382713318 / seconds
Query Executed:select id FROM `az` where city='Sasabe' && SIC_code='7542'DB:business_master_new
loadtime:0.39946985244751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsdale' limit 1
loadtime:0.39952898025513 / seconds
Query Executed:select id FROM `az` where city='Scottsdale' && SIC_code='7542'DB:business_master_new
loadtime:0.40286493301392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Second Mesa' limit 1
loadtime:0.40297389030457 / seconds
Query Executed:select id FROM `az` where city='Second Mesa' && SIC_code='7542'DB:business_master_new
loadtime:0.40379285812378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedona' limit 1
loadtime:0.40385484695435 / seconds
Query Executed:select id FROM `az` where city='Sedona' && SIC_code='7542'DB:business_master_new
loadtime:0.40711092948914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seligman' limit 1
loadtime:0.40717887878418 / seconds
Query Executed:select id FROM `az` where city='Seligman' && SIC_code='7542'DB:business_master_new
loadtime:0.4086217880249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sells' limit 1
loadtime:0.40867781639099 / seconds
Query Executed:select id FROM `az` where city='Sells' && SIC_code='7542'DB:business_master_new
loadtime:0.41077589988708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto' limit 1
loadtime:0.41083097457886 / seconds
Query Executed:select id FROM `az` where city='Shonto' && SIC_code='7542'DB:business_master_new
loadtime:0.41143393516541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shonto Community Post Office' limit 1
loadtime:0.41149187088013 / seconds
Query Executed:select id FROM `az` where city='Shonto Community Post Office' && SIC_code='7542'DB:business_master_new
loadtime:0.41198778152466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Show Low' limit 1
loadtime:0.41204500198364 / seconds
Query Executed:select id FROM `az` where city='Show Low' && SIC_code='7542'DB:business_master_new
loadtime:0.41532778739929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sierra Vista' limit 1
loadtime:0.41540598869324 / seconds
Query Executed:select id FROM `az` where city='Sierra Vista' && SIC_code='7542'DB:business_master_new
loadtime:0.4187068939209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skull Valley' limit 1
loadtime:0.41879081726074 / seconds
Query Executed:select id FROM `az` where city='Skull Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.41960692405701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowflake' limit 1
loadtime:0.41966581344604 / seconds
Query Executed:select id FROM `az` where city='Snowflake' && SIC_code='7542'DB:business_master_new
loadtime:0.42288899421692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Solomon' limit 1
loadtime:0.42294788360596 / seconds
Query Executed:select id FROM `az` where city='Solomon' && SIC_code='7542'DB:business_master_new
loadtime:0.42361378669739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerton' limit 1
loadtime:0.42367196083069 / seconds
Query Executed:select id FROM `az` where city='Somerton' && SIC_code='7542'DB:business_master_new
loadtime:0.42513489723206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sonoita' limit 1
loadtime:0.42518782615662 / seconds
Query Executed:select id FROM `az` where city='Sonoita' && SIC_code='7542'DB:business_master_new
loadtime:0.4270179271698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springerville' limit 1
loadtime:0.42707085609436 / seconds
Query Executed:select id FROM `az` where city='Springerville' && SIC_code='7542'DB:business_master_new
loadtime:0.43033790588379 / seconds
Query loaded from cache:select * from geodata_geocity where city='St David' limit 1
loadtime:0.43040490150452 / seconds
Query Executed:select id FROM `az` where city='St David' && SIC_code='7542'DB:business_master_new
loadtime:0.43087196350098 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Johns' limit 1
loadtime:0.43092489242554 / seconds
Query Executed:select id FROM `az` where city='St Johns' && SIC_code='7542'DB:business_master_new
loadtime:0.43144583702087 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Michaels' limit 1
loadtime:0.43150496482849 / seconds
Query Executed:select id FROM `az` where city='St Michaels' && SIC_code='7542'DB:business_master_new
loadtime:0.43215894699097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:0.43221187591553 / seconds
Query Executed:select id FROM `az` where city='Stanfield' && SIC_code='7542'DB:business_master_new
loadtime:0.43297100067139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strawberry' limit 1
loadtime:0.43302392959595 / seconds
Query Executed:select id FROM `az` where city='Strawberry' && SIC_code='7542'DB:business_master_new
loadtime:0.43368077278137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City' limit 1
loadtime:0.43373394012451 / seconds
Query Executed:select id FROM `az` where city='Sun City' && SIC_code='7542'DB:business_master_new
loadtime:0.43819999694824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun City West' limit 1
loadtime:0.43827891349792 / seconds
Query Executed:select id FROM `az` where city='Sun City West' && SIC_code='7542'DB:business_master_new
loadtime:0.44233083724976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Lakes' limit 1
loadtime:0.4424159526825 / seconds
Query Executed:select id FROM `az` where city='Sun Lakes' && SIC_code='7542'DB:business_master_new
loadtime:0.44301986694336 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sun Valley' limit 1
loadtime:0.44308686256409 / seconds
Query Executed:select id FROM `az` where city='Sun Valley' && SIC_code='7542'DB:business_master_new
loadtime:0.44368100166321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supai' limit 1
loadtime:0.44374680519104 / seconds
Query Executed:select id FROM `az` where city='Supai' && SIC_code='7542'DB:business_master_new
loadtime:0.44438695907593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Superior' limit 1
loadtime:0.44445300102234 / seconds
Query Executed:select id FROM `az` where city='Superior' && SIC_code='7542'DB:business_master_new
loadtime:0.44531393051147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surprise' limit 1
loadtime:0.44538688659668 / seconds
Query Executed:select id FROM `az` where city='Surprise' && SIC_code='7542'DB:business_master_new
loadtime:0.44874095916748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tacna' limit 1
loadtime:0.44880890846252 / seconds
Query Executed:select id FROM `az` where city='Tacna' && SIC_code='7542'DB:business_master_new
loadtime:0.44954180717468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:0.44961094856262 / seconds
Query Executed:select id FROM `az` where city='Taylor' && SIC_code='7542'DB:business_master_new
loadtime:0.45128393173218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teec Nos Pos' limit 1
loadtime:0.45134997367859 / seconds
Query Executed:select id FROM `az` where city='Teec Nos Pos' && SIC_code='7542'DB:business_master_new
loadtime:0.45219087600708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tempe' limit 1
loadtime:0.45226192474365 / seconds
Query Executed:select id FROM `az` where city='Tempe' && SIC_code='7542'DB:business_master_new
loadtime:0.45561480522156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple Bar Marina' limit 1
loadtime:0.45570588111877 / seconds
Query Executed:select id FROM `az` where city='Temple Bar Marina' && SIC_code='7542'DB:business_master_new
loadtime:0.45636487007141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thatcher' limit 1
loadtime:0.45642876625061 / seconds
Query Executed:select id FROM `az` where city='Thatcher' && SIC_code='7542'DB:business_master_new
loadtime:0.45923495292664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolleson' limit 1
loadtime:0.45931196212769 / seconds
Query Executed:select id FROM `az` where city='Tolleson' && SIC_code='7542'DB:business_master_new
loadtime:0.46263694763184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tombstone' limit 1
loadtime:0.46272397041321 / seconds
Query Executed:select id FROM `az` where city='Tombstone' && SIC_code='7542'DB:business_master_new
loadtime:0.46628499031067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonalea' limit 1
loadtime:0.46635293960571 / seconds
Query Executed:select id FROM `az` where city='Tonalea' && SIC_code='7542'DB:business_master_new
loadtime:0.46700191497803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonopah' limit 1
loadtime:0.46706795692444 / seconds
Query Executed:select id FROM `az` where city='Tonopah' && SIC_code='7542'DB:business_master_new
loadtime:0.46844077110291 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tonto Basin' limit 1
loadtime:0.46851897239685 / seconds
Query Executed:select id FROM `az` where city='Tonto Basin' && SIC_code='7542'DB:business_master_new
loadtime:0.46997880935669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topawa' limit 1
loadtime:0.47004699707031 / seconds
Query Executed:select id FROM `az` where city='Topawa' && SIC_code='7542'DB:business_master_new
loadtime:0.47059488296509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topock' limit 1
loadtime:0.47065997123718 / seconds
Query Executed:select id FROM `az` where city='Topock' && SIC_code='7542'DB:business_master_new
loadtime:0.47180676460266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tortilla Flat' limit 1
loadtime:0.47187280654907 / seconds
Query Executed:select id FROM `az` where city='Tortilla Flat' && SIC_code='7542'DB:business_master_new
loadtime:0.47243499755859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tsaile' limit 1
loadtime:0.47250390052795 / seconds
Query Executed:select id FROM `az` where city='Tsaile' && SIC_code='7542'DB:business_master_new
loadtime:0.47317385673523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuba City' limit 1
loadtime:0.47323489189148 / seconds
Query Executed:select id FROM `az` where city='Tuba City' && SIC_code='7542'DB:business_master_new
loadtime:0.4757068157196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tubac' limit 1
loadtime:0.47577595710754 / seconds
Query Executed:select id FROM `az` where city='Tubac' && SIC_code='7542'DB:business_master_new
loadtime:0.47743487358093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tucson' limit 1
loadtime:0.47750377655029 / seconds
Query Executed:select id FROM `az` where city='Tucson' && SIC_code='7542'DB:business_master_new
loadtime:0.48088788986206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tumacacori' limit 1
loadtime:0.48104381561279 / seconds
Query Executed:select id FROM `az` where city='Tumacacori' && SIC_code='7542'DB:business_master_new
loadtime:0.4820499420166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vail' limit 1
loadtime:0.48212480545044 / seconds
Query Executed:select id FROM `az` where city='Vail' && SIC_code='7542'DB:business_master_new
loadtime:0.48474287986755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valentine' limit 1
loadtime:0.48480987548828 / seconds
Query Executed:select id FROM `az` where city='Valentine' && SIC_code='7542'DB:business_master_new
loadtime:0.48533391952515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Farms' limit 1
loadtime:0.48540377616882 / seconds
Query Executed:select id FROM `az` where city='Valley Farms' && SIC_code='7542'DB:business_master_new
loadtime:0.48595094680786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.48601794242859 / seconds
Query Executed:select id FROM `az` where city='Vernon' && SIC_code='7542'DB:business_master_new
loadtime:0.4868688583374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waddell' limit 1
loadtime:0.48694181442261 / seconds
Query Executed:select id FROM `az` where city='Waddell' && SIC_code='7542'DB:business_master_new
loadtime:0.48932099342346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellton' limit 1
loadtime:0.48938894271851 / seconds
Query Executed:select id FROM `az` where city='Wellton' && SIC_code='7542'DB:business_master_new
loadtime:0.4903519153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenden' limit 1
loadtime:0.49041390419006 / seconds
Query Executed:select id FROM `az` where city='Wenden' && SIC_code='7542'DB:business_master_new
loadtime:0.49116182327271 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mountain Lake' limit 1
loadtime:0.49122977256775 / seconds
Query Executed:select id FROM `az` where city='White Mountain Lake' && SIC_code='7542'DB:business_master_new
loadtime:0.49182486534119 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Mtn Lake' limit 1
loadtime:0.49189281463623 / seconds
Query Executed:select id FROM `az` where city='White Mtn Lake' && SIC_code='7542'DB:business_master_new
loadtime:0.49241280555725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteriver' limit 1
loadtime:0.49248099327087 / seconds
Query Executed:select id FROM `az` where city='Whiteriver' && SIC_code='7542'DB:business_master_new
loadtime:0.49358582496643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Why' limit 1
loadtime:0.49364686012268 / seconds
Query Executed:select id FROM `az` where city='Why' && SIC_code='7542'DB:business_master_new
loadtime:0.49415683746338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickenburg' limit 1
loadtime:0.49422287940979 / seconds
Query Executed:select id FROM `az` where city='Wickenburg' && SIC_code='7542'DB:business_master_new
loadtime:0.4975438117981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wikieup' limit 1
loadtime:0.49762082099915 / seconds
Query Executed:select id FROM `az` where city='Wikieup' && SIC_code='7542'DB:business_master_new
loadtime:0.49833488464355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willcox' limit 1
loadtime:0.4984118938446 / seconds
Query Executed:select id FROM `az` where city='Willcox' && SIC_code='7542'DB:business_master_new
loadtime:0.50171685218811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williams' limit 1
loadtime:0.50179982185364 / seconds
Query Executed:select id FROM `az` where city='Williams' && SIC_code='7542'DB:business_master_new
loadtime:0.50583791732788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Beach' limit 1
loadtime:0.50590181350708 / seconds
Query Executed:select id FROM `az` where city='Willow Beach' && SIC_code='7542'DB:business_master_new
loadtime:0.50651693344116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Window Rock' limit 1
loadtime:0.50657987594604 / seconds
Query Executed:select id FROM `az` where city='Window Rock' && SIC_code='7542'DB:business_master_new
loadtime:0.51068091392517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winkelman' limit 1
loadtime:0.51074481010437 / seconds
Query Executed:select id FROM `az` where city='Winkelman' && SIC_code='7542'DB:business_master_new
loadtime:0.51184797286987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:0.5119149684906 / seconds
Query Executed:select id FROM `az` where city='Winslow' && SIC_code='7542'DB:business_master_new
loadtime:0.51692295074463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wittmann' limit 1
loadtime:0.51699995994568 / seconds
Query Executed:select id FROM `az` where city='Wittmann' && SIC_code='7542'DB:business_master_new
loadtime:0.51813983917236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.51820993423462 / seconds
Query Executed:select id FROM `az` where city='Woodruff' && SIC_code='7542'DB:business_master_new
loadtime:0.51881289482117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yarnell' limit 1
loadtime:0.51887989044189 / seconds
Query Executed:select id FROM `az` where city='Yarnell' && SIC_code='7542'DB:business_master_new
loadtime:0.51987886428833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Young' limit 1
loadtime:0.51994585990906 / seconds
Query Executed:select id FROM `az` where city='Young' && SIC_code='7542'DB:business_master_new
loadtime:0.52098798751831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngtown' limit 1
loadtime:0.52104878425598 / seconds
Query Executed:select id FROM `az` where city='Youngtown' && SIC_code='7542'DB:business_master_new
loadtime:0.52347493171692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yucca' limit 1
loadtime:0.52355098724365 / seconds
Query Executed:select id FROM `az` where city='Yucca' && SIC_code='7542'DB:business_master_new
loadtime:0.52420878410339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yuma' limit 1
loadtime:0.52426981925964 / seconds
Query Executed:select id FROM `az` where city='Yuma' && SIC_code='7542'DB:business_master_new
loadtime:0.52763795852661 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.52781391143799 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.52820777893066 / seconds
Operation template executed (chunk cache operation)
loadtime:0.52837586402893 / seconds
template override:Default
loadtime:0.52841877937317 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.53031778335571 / seconds
Template Constructed, Array Rows:49
loadtime:0.53085398674011 / seconds
TOTAL EXECUTION TIME: 0.53042
loadtime:0.53207087516785 / seconds

THIS PAGE CACHED ON:
THIS PAGE COMPRESSION:
HITS TO THIS PAGE/CACHE:
PAGES STORED:
DATASIZE: Bytes
Compression:


PAGE OBJECT DATA


Key: page;
subKey: directorystate;
subKey: directorystatepages;
subKey: template;



_GET


Array ( [cat_URLid] => carwashes [stateURLid] => arizona )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


Array ( [0] => cache [1] => query [2] => output [3] => session [4] => db [5] => db2 [6] => dbnew [7] => sphinxsearch [8] => sphinx [9] => dbConn [10] => functions [11] => sphinx_search [12] => template_operations [13] => buildtemplate [14] => syndication_handler [15] => directorystate )


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.53208184242249
TOTAL KEY ARRAYS: 69