Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.9168548583984E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00063109397888184 / seconds
host not found setting manual db connection
loadtime:0.00095915794372559 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0013470649719238 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0015201568603516 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0015690326690674 / seconds
zipcode:
loadtime:0.0015871524810791 / seconds
Query Executed:select * from search_referrer where page_hash='08cf5c1032bb2a222da82d6779c14964' limit 10 DB:ezrox_toadli
loadtime:0.0018441677093506 / seconds
Operation header executed (non global)
loadtime:0.0018610954284668 / seconds
Operation leaderboard executed (non global)
loadtime:0.00189208984375 / seconds
Operation square executed (non global)
loadtime:0.001906156539917 / seconds
Operation square_bottom executed (non global)
loadtime:0.0019190311431885 / seconds
Operation smallsquare executed (non global)
loadtime:0.0019299983978271 / seconds
Operation headeradright executed (non global)
loadtime:0.0019421577453613 / seconds
Operation google_analytics executed (non global)
loadtime:0.001953125 / seconds
Operation topstories executed (non global)
loadtime:0.0019650459289551 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0019850730895996 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0020060539245605 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0024161338806152 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.002561092376709 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0025990009307861 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0027010440826416 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0027611255645752 / seconds
Template key: archive_menu pushed
loadtime:0.0027701854705811 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0027801990509033 / seconds
Template key: get_gravatar pushed
loadtime:0.0027861595153809 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0027930736541748 / seconds
*10)-10)+1 | start:0
loadtime:0.0028281211853027 / seconds
Query loaded from cache:select * from categories where cat_URLid='retail-nurseries-lawn-and-garden-supply-stores'
loadtime:0.002892017364502 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.0029361248016357 / seconds
DB connected to localhost business_master_new
loadtime:0.0032961368560791 / seconds
Query Executed:select * from `ut_catmap` where sic='5261' order by city ascDB:business_master_new
loadtime:0.012479066848755 / seconds
Query stored in cache : _QUERY_www.toadli.com21961cfc9e1e7c025b56dbd615d8112f
loadtime:0.013104200363159 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.013154983520508 / seconds
Query Executed:select sum(totalcount) as totalsum from `ut_catmap` where sic='5261'DB:business_master_new
loadtime:0.015884160995483 / seconds
Query stored in cache : _QUERY_www.toadli.com9b5fc5511686b20e24dc5a06ab6309d7
loadtime:0.015932083129883 / seconds
279 / 11
loadtime:0.015963077545166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.016013145446777 / seconds
Query Executed:select id FROM `ut` where city='Alpine' && SIC_code='5261'DB:business_master_new
loadtime:0.018177032470703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.018232107162476 / seconds
Query Executed:select id FROM `ut` where city='Alta' && SIC_code='5261'DB:business_master_new
loadtime:0.018603086471558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.018643140792847 / seconds
Query Executed:select id FROM `ut` where city='Altamont' && SIC_code='5261'DB:business_master_new
loadtime:0.019082069396973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.019129037857056 / seconds
Query Executed:select id FROM `ut` where city='Alton' && SIC_code='5261'DB:business_master_new
loadtime:0.019481182098389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altonah' limit 1
loadtime:0.019517183303833 / seconds
Query Executed:select id FROM `ut` where city='Altonah' && SIC_code='5261'DB:business_master_new
loadtime:0.019869089126587 / seconds
Query loaded from cache:select * from geodata_geocity where city='American Fork' limit 1
loadtime:0.019922018051147 / seconds
Query Executed:select id FROM `ut` where city='American Fork' && SIC_code='5261'DB:business_master_new
loadtime:0.055390119552612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aneth' limit 1
loadtime:0.055453062057495 / seconds
Query Executed:select id FROM `ut` where city='Aneth' && SIC_code='5261'DB:business_master_new
loadtime:0.055759191513062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annabella' limit 1
loadtime:0.055805206298828 / seconds
Query Executed:select id FROM `ut` where city='Annabella' && SIC_code='5261'DB:business_master_new
loadtime:0.056327104568481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antimony' limit 1
loadtime:0.056377172470093 / seconds
Query Executed:select id FROM `ut` where city='Antimony' && SIC_code='5261'DB:business_master_new
loadtime:0.056877136230469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.056926012039185 / seconds
Query Executed:select id FROM `ut` where city='Aurora' && SIC_code='5261'DB:business_master_new
loadtime:0.057473182678223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axtell' limit 1
loadtime:0.057514190673828 / seconds
Query Executed:select id FROM `ut` where city='Axtell' && SIC_code='5261'DB:business_master_new
loadtime:0.057861089706421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear River City' limit 1
loadtime:0.057912111282349 / seconds
Query Executed:select id FROM `ut` where city='Bear River City' && SIC_code='5261'DB:business_master_new
loadtime:0.058324098587036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.058371067047119 / seconds
Query Executed:select id FROM `ut` where city='Beaver' && SIC_code='5261'DB:business_master_new
loadtime:0.058893203735352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beryl' limit 1
loadtime:0.058957099914551 / seconds
Query Executed:select id FROM `ut` where city='Beryl' && SIC_code='5261'DB:business_master_new
loadtime:0.059383153915405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bicknell' limit 1
loadtime:0.059415102005005 / seconds
Query Executed:select id FROM `ut` where city='Bicknell' && SIC_code='5261'DB:business_master_new
loadtime:0.059856176376343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Water' limit 1
loadtime:0.059905052185059 / seconds
Query Executed:select id FROM `ut` where city='Big Water' && SIC_code='5261'DB:business_master_new
loadtime:0.060218095779419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Canyon' limit 1
loadtime:0.060256004333496 / seconds
Query Executed:select id FROM `ut` where city='Bingham Canyon' && SIC_code='5261'DB:business_master_new
loadtime:0.06072211265564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanding' limit 1
loadtime:0.060772180557251 / seconds
Query Executed:select id FROM `ut` where city='Blanding' && SIC_code='5261'DB:business_master_new
loadtime:0.061346054077148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluebell' limit 1
loadtime:0.061390161514282 / seconds
Query Executed:select id FROM `ut` where city='Bluebell' && SIC_code='5261'DB:business_master_new
loadtime:0.061918973922729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluff' limit 1
loadtime:0.061971187591553 / seconds
Query Executed:select id FROM `ut` where city='Bluff' && SIC_code='5261'DB:business_master_new
loadtime:0.062541007995605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonanza' limit 1
loadtime:0.062583208084106 / seconds
Query Executed:select id FROM `ut` where city='Bonanza' && SIC_code='5261'DB:business_master_new
loadtime:0.062894105911255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.062940120697021 / seconds
Query Executed:select id FROM `ut` where city='Boulder' && SIC_code='5261'DB:business_master_new
loadtime:0.06338906288147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bountiful' limit 1
loadtime:0.063416004180908 / seconds
Query Executed:select id FROM `ut` where city='Bountiful' && SIC_code='5261'DB:business_master_new
loadtime:0.065811157226562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brian Head' limit 1
loadtime:0.065871000289917 / seconds
Query Executed:select id FROM `ut` where city='Brian Head' && SIC_code='5261'DB:business_master_new
loadtime:0.066298007965088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeland' limit 1
loadtime:0.066339015960693 / seconds
Query Executed:select id FROM `ut` where city='Bridgeland' && SIC_code='5261'DB:business_master_new
loadtime:0.066702127456665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brigham City' limit 1
loadtime:0.06674599647522 / seconds
Query Executed:select id FROM `ut` where city='Brigham City' && SIC_code='5261'DB:business_master_new
loadtime:0.067903995513916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.067962169647217 / seconds
Query Executed:select id FROM `ut` where city='Brighton' && SIC_code='5261'DB:business_master_new
loadtime:0.068308115005493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryce' limit 1
loadtime:0.068350076675415 / seconds
Query Executed:select id FROM `ut` where city='Bryce' && SIC_code='5261'DB:business_master_new
loadtime:0.06876802444458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryce Canyon' limit 1
loadtime:0.068808078765869 / seconds
Query Executed:select id FROM `ut` where city='Bryce Canyon' && SIC_code='5261'DB:business_master_new
loadtime:0.06917405128479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cache Junction' limit 1
loadtime:0.069218158721924 / seconds
Query Executed:select id FROM `ut` where city='Cache Junction' && SIC_code='5261'DB:business_master_new
loadtime:0.069492101669312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonville' limit 1
loadtime:0.069523096084595 / seconds
Query Executed:select id FROM `ut` where city='Cannonville' && SIC_code='5261'DB:business_master_new
loadtime:0.069921016693115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Dale' limit 1
loadtime:0.069972991943359 / seconds
Query Executed:select id FROM `ut` where city='Castle Dale' && SIC_code='5261'DB:business_master_new
loadtime:0.070479154586792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar City' limit 1
loadtime:0.070515155792236 / seconds
Query Executed:select id FROM `ut` where city='Cedar City' && SIC_code='5261'DB:business_master_new
loadtime:0.072909116744995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Valley' limit 1
loadtime:0.072968006134033 / seconds
Query Executed:select id FROM `ut` where city='Cedar Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.073536157608032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerfield' limit 1
loadtime:0.073577165603638 / seconds
Query Executed:select id FROM `ut` where city='Centerfield' && SIC_code='5261'DB:business_master_new
loadtime:0.074129104614258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.074181079864502 / seconds
Query Executed:select id FROM `ut` where city='Centerville' && SIC_code='5261'DB:business_master_new
loadtime:0.074901103973389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.074953079223633 / seconds
Query Executed:select id FROM `ut` where city='Central' && SIC_code='5261'DB:business_master_new
loadtime:0.075286149978638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Valley' limit 1
loadtime:0.07532000541687 / seconds
Query Executed:select id FROM `ut` where city='Central Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.075602054595947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.07564115524292 / seconds
Query Executed:select id FROM `ut` where city='Chester' && SIC_code='5261'DB:business_master_new
loadtime:0.075959205627441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Circleville' limit 1
loadtime:0.075998067855835 / seconds
Query Executed:select id FROM `ut` where city='Circleville' && SIC_code='5261'DB:business_master_new
loadtime:0.076415061950684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cisco' limit 1
loadtime:0.07645320892334 / seconds
Query Executed:select id FROM `ut` where city='Cisco' && SIC_code='5261'DB:business_master_new
loadtime:0.076708078384399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.076740026473999 / seconds
Query Executed:select id FROM `ut` where city='Clarkston' && SIC_code='5261'DB:business_master_new
loadtime:0.077148199081421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:0.077177047729492 / seconds
Query Executed:select id FROM `ut` where city='Clawson' && SIC_code='5261'DB:business_master_new
loadtime:0.077454090118408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.077486038208008 / seconds
Query Executed:select id FROM `ut` where city='Clearfield' && SIC_code='5261'DB:business_master_new
loadtime:0.079930067062378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.079987049102783 / seconds
Query Executed:select id FROM `ut` where city='Cleveland' && SIC_code='5261'DB:business_master_new
loadtime:0.080408096313477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalville' limit 1
loadtime:0.080450057983398 / seconds
Query Executed:select id FROM `ut` where city='Coalville' && SIC_code='5261'DB:business_master_new
loadtime:0.080958127975464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinston' limit 1
loadtime:0.080993175506592 / seconds
Query Executed:select id FROM `ut` where city='Collinston' && SIC_code='5261'DB:business_master_new
loadtime:0.081392049789429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinne' limit 1
loadtime:0.081446170806885 / seconds
Query Executed:select id FROM `ut` where city='Corinne' && SIC_code='5261'DB:business_master_new
loadtime:0.081911087036133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.081958055496216 / seconds
Query Executed:select id FROM `ut` where city='Cornish' && SIC_code='5261'DB:business_master_new
loadtime:0.082240104675293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.082276105880737 / seconds
Query Executed:select id FROM `ut` where city='Cottonwood' && SIC_code='5261'DB:business_master_new
loadtime:0.082521200180054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.082559108734131 / seconds
Query Executed:select id FROM `ut` where city='Croydon' && SIC_code='5261'DB:business_master_new
loadtime:0.082863092422485 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dammeron Valley' limit 1
loadtime:0.082910060882568 / seconds
Query Executed:select id FROM `ut` where city='Dammeron Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.083323001861572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.083357095718384 / seconds
Query Executed:select id FROM `ut` where city='Delta' && SIC_code='5261'DB:business_master_new
loadtime:0.083923101425171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deweyville' limit 1
loadtime:0.083978176116943 / seconds
Query Executed:select id FROM `ut` where city='Deweyville' && SIC_code='5261'DB:business_master_new
loadtime:0.08434009552002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.08439302444458 / seconds
Query Executed:select id FROM `ut` where city='Draper' && SIC_code='5261'DB:business_master_new
loadtime:0.086621046066284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duchesne' limit 1
loadtime:0.086668014526367 / seconds
Query Executed:select id FROM `ut` where city='Duchesne' && SIC_code='5261'DB:business_master_new
loadtime:0.087182998657227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village' limit 1
loadtime:0.087234020233154 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village' && SIC_code='5261'DB:business_master_new
loadtime:0.08769416809082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village Cpu' limit 1
loadtime:0.087728977203369 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village Cpu' && SIC_code='5261'DB:business_master_new
loadtime:0.087973117828369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Vlg' limit 1
loadtime:0.088015079498291 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Vlg' && SIC_code='5261'DB:business_master_new
loadtime:0.088268995285034 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugway' limit 1
loadtime:0.088304042816162 / seconds
Query Executed:select id FROM `ut` where city='Dugway' && SIC_code='5261'DB:business_master_new
loadtime:0.088760137557983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutch John' limit 1
loadtime:0.088801145553589 / seconds
Query Executed:select id FROM `ut` where city='Dutch John' && SIC_code='5261'DB:business_master_new
loadtime:0.089203119277954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Mountain' limit 1
loadtime:0.089243173599243 / seconds
Query Executed:select id FROM `ut` where city='Eagle Mountain' && SIC_code='5261'DB:business_master_new
loadtime:0.089722156524658 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Carbon' limit 1
loadtime:0.089769124984741 / seconds
Query Executed:select id FROM `ut` where city='East Carbon' && SIC_code='5261'DB:business_master_new
loadtime:0.090172052383423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Echo' limit 1
loadtime:0.090213060379028 / seconds
Query Executed:select id FROM `ut` where city='Echo' && SIC_code='5261'DB:business_master_new
loadtime:0.090478181838989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.090512990951538 / seconds
Query Executed:select id FROM `ut` where city='Eden' && SIC_code='5261'DB:business_master_new
loadtime:0.090993165969849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.091047048568726 / seconds
Query Executed:select id FROM `ut` where city='Elberta' && SIC_code='5261'DB:business_master_new
loadtime:0.091437101364136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmo' limit 1
loadtime:0.091477155685425 / seconds
Query Executed:select id FROM `ut` where city='Elmo' && SIC_code='5261'DB:business_master_new
loadtime:0.091876983642578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsinore' limit 1
loadtime:0.091929197311401 / seconds
Query Executed:select id FROM `ut` where city='Elsinore' && SIC_code='5261'DB:business_master_new
loadtime:0.092339992523193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.09240198135376 / seconds
Query Executed:select id FROM `ut` where city='Emery' && SIC_code='5261'DB:business_master_new
loadtime:0.092818021774292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.092867136001587 / seconds
Query Executed:select id FROM `ut` where city='Enterprise' && SIC_code='5261'DB:business_master_new
loadtime:0.093294143676758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:0.093326091766357 / seconds
Query Executed:select id FROM `ut` where city='Ephraim' && SIC_code='5261'DB:business_master_new
loadtime:0.093861103057861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escalante' limit 1
loadtime:0.093923091888428 / seconds
Query Executed:select id FROM `ut` where city='Escalante' && SIC_code='5261'DB:business_master_new
loadtime:0.094377040863037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.094423055648804 / seconds
Query Executed:select id FROM `ut` where city='Eureka' && SIC_code='5261'DB:business_master_new
loadtime:0.094865083694458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.094911098480225 / seconds
Query Executed:select id FROM `ut` where city='Fairview' && SIC_code='5261'DB:business_master_new
loadtime:0.095347166061401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.095412015914917 / seconds
Query Executed:select id FROM `ut` where city='Farmington' && SIC_code='5261'DB:business_master_new
loadtime:0.096028089523315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.09607720375061 / seconds
Query Executed:select id FROM `ut` where city='Fayette' && SIC_code='5261'DB:business_master_new
loadtime:0.09642505645752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferron' limit 1
loadtime:0.096466064453125 / seconds
Query Executed:select id FROM `ut` where city='Ferron' && SIC_code='5261'DB:business_master_new
loadtime:0.09692120552063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fielding' limit 1
loadtime:0.096970081329346 / seconds
Query Executed:select id FROM `ut` where city='Fielding' && SIC_code='5261'DB:business_master_new
loadtime:0.097344160079956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fillmore' limit 1
loadtime:0.097393035888672 / seconds
Query Executed:select id FROM `ut` where city='Fillmore' && SIC_code='5261'DB:business_master_new
loadtime:0.097931146621704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Duchesne' limit 1
loadtime:0.097976207733154 / seconds
Query Executed:select id FROM `ut` where city='Fort Duchesne' && SIC_code='5261'DB:business_master_new
loadtime:0.098389148712158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Green' limit 1
loadtime:0.098432064056396 / seconds
Query Executed:select id FROM `ut` where city='Fountain Green' && SIC_code='5261'DB:business_master_new
loadtime:0.098847150802612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.098896026611328 / seconds
Query Executed:select id FROM `ut` where city='Fruitland' && SIC_code='5261'DB:business_master_new
loadtime:0.099294185638428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.099327087402344 / seconds
Query Executed:select id FROM `ut` where city='Garden City' && SIC_code='5261'DB:business_master_new
loadtime:0.099781036376953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.099828004837036 / seconds
Query Executed:select id FROM `ut` where city='Garland' && SIC_code='5261'DB:business_master_new
loadtime:0.10028910636902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.10032320022583 / seconds
Query Executed:select id FROM `ut` where city='Garrison' && SIC_code='5261'DB:business_master_new
loadtime:0.10073113441467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genola' limit 1
loadtime:0.10077500343323 / seconds
Query Executed:select id FROM `ut` where city='Genola' && SIC_code='5261'DB:business_master_new
loadtime:0.10102605819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.10106706619263 / seconds
Query Executed:select id FROM `ut` where city='Glendale' && SIC_code='5261'DB:business_master_new
loadtime:0.10147404670715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.10151219367981 / seconds
Query Executed:select id FROM `ut` where city='Glenwood' && SIC_code='5261'DB:business_master_new
loadtime:0.10189414024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.10193800926208 / seconds
Query Executed:select id FROM `ut` where city='Goshen' && SIC_code='5261'DB:business_master_new
loadtime:0.10237717628479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsville' limit 1
loadtime:0.1024169921875 / seconds
Query Executed:select id FROM `ut` where city='Grantsville' && SIC_code='5261'DB:business_master_new
loadtime:0.10290908813477 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green River' limit 1
loadtime:0.10296010971069 / seconds
Query Executed:select id FROM `ut` where city='Green River' && SIC_code='5261'DB:business_master_new
loadtime:0.10340309143066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.10344099998474 / seconds
Query Executed:select id FROM `ut` where city='Greenville' && SIC_code='5261'DB:business_master_new
loadtime:0.10366320610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.10369515419006 / seconds
Query Executed:select id FROM `ut` where city='Greenwich' && SIC_code='5261'DB:business_master_new
loadtime:0.10391712188721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grouse Creek' limit 1
loadtime:0.10394215583801 / seconds
Query Executed:select id FROM `ut` where city='Grouse Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.10417509078979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunlock' limit 1
loadtime:0.10421204566956 / seconds
Query Executed:select id FROM `ut` where city='Gunlock' && SIC_code='5261'DB:business_master_new
loadtime:0.10445308685303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.10448718070984 / seconds
Query Executed:select id FROM `ut` where city='Gunnison' && SIC_code='5261'DB:business_master_new
loadtime:0.10493302345276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gusher' limit 1
loadtime:0.10497999191284 / seconds
Query Executed:select id FROM `ut` where city='Gusher' && SIC_code='5261'DB:business_master_new
loadtime:0.10523009300232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanksville' limit 1
loadtime:0.10526609420776 / seconds
Query Executed:select id FROM `ut` where city='Hanksville' && SIC_code='5261'DB:business_master_new
loadtime:0.10572218894958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanna' limit 1
loadtime:0.10578513145447 / seconds
Query Executed:select id FROM `ut` where city='Hanna' && SIC_code='5261'DB:business_master_new
loadtime:0.10611200332642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.10614705085754 / seconds
Query Executed:select id FROM `ut` where city='Hatch' && SIC_code='5261'DB:business_master_new
loadtime:0.10653614997864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber City' limit 1
loadtime:0.10656213760376 / seconds
Query Executed:select id FROM `ut` where city='Heber City' && SIC_code='5261'DB:business_master_new
loadtime:0.1071879863739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helper' limit 1
loadtime:0.1072461605072 / seconds
Query Executed:select id FROM `ut` where city='Helper' && SIC_code='5261'DB:business_master_new
loadtime:0.10775208473206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henefer' limit 1
loadtime:0.10779309272766 / seconds
Query Executed:select id FROM `ut` where city='Henefer' && SIC_code='5261'DB:business_master_new
loadtime:0.10820317268372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrieville' limit 1
loadtime:0.10824799537659 / seconds
Query Executed:select id FROM `ut` where city='Henrieville' && SIC_code='5261'DB:business_master_new
loadtime:0.10856008529663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herriman' limit 1
loadtime:0.10858607292175 / seconds
Query Executed:select id FROM `ut` where city='Herriman' && SIC_code='5261'DB:business_master_new
loadtime:0.10908818244934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.10913920402527 / seconds
Query Executed:select id FROM `ut` where city='Hiawatha' && SIC_code='5261'DB:business_master_new
loadtime:0.10940718650818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:0.10944414138794 / seconds
Query Executed:select id FROM `ut` where city='Highland' && SIC_code='5261'DB:business_master_new
loadtime:0.10977411270142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildale' limit 1
loadtime:0.10981917381287 / seconds
Query Executed:select id FROM `ut` where city='Hildale' && SIC_code='5261'DB:business_master_new
loadtime:0.11026906967163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Afb' limit 1
loadtime:0.11030602455139 / seconds
Query Executed:select id FROM `ut` where city='Hill Afb' && SIC_code='5261'DB:business_master_new
loadtime:0.11076807975769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Air Force Base' limit 1
loadtime:0.11081910133362 / seconds
Query Executed:select id FROM `ut` where city='Hill Air Force Base' && SIC_code='5261'DB:business_master_new
loadtime:0.11111998558044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinckley' limit 1
loadtime:0.11115503311157 / seconds
Query Executed:select id FROM `ut` where city='Hinckley' && SIC_code='5261'DB:business_master_new
loadtime:0.11155819892883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hite' limit 1
loadtime:0.11159205436707 / seconds
Query Executed:select id FROM `ut` where city='Hite' && SIC_code='5261'DB:business_master_new
loadtime:0.11180400848389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.11184501647949 / seconds
Query Executed:select id FROM `ut` where city='Holden' && SIC_code='5261'DB:business_master_new
loadtime:0.11224508285522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holladay' limit 1
loadtime:0.11228513717651 / seconds
Query Executed:select id FROM `ut` where city='Holladay' && SIC_code='5261'DB:business_master_new
loadtime:0.11272215843201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honeyville' limit 1
loadtime:0.11277508735657 / seconds
Query Executed:select id FROM `ut` where city='Honeyville' && SIC_code='5261'DB:business_master_new
loadtime:0.11319398880005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:0.11323118209839 / seconds
Query Executed:select id FROM `ut` where city='Hooper' && SIC_code='5261'DB:business_master_new
loadtime:0.11372017860413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:0.11378598213196 / seconds
Query Executed:select id FROM `ut` where city='Howell' && SIC_code='5261'DB:business_master_new
loadtime:0.11412310600281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.11416101455688 / seconds
Query Executed:select id FROM `ut` where city='Huntington' && SIC_code='5261'DB:business_master_new
loadtime:0.11465501785278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntsville' limit 1
loadtime:0.11471104621887 / seconds
Query Executed:select id FROM `ut` where city='Huntsville' && SIC_code='5261'DB:business_master_new
loadtime:0.11513900756836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurricane' limit 1
loadtime:0.11517715454102 / seconds
Query Executed:select id FROM `ut` where city='Hurricane' && SIC_code='5261'DB:business_master_new
loadtime:0.11576700210571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.11582398414612 / seconds
Query Executed:select id FROM `ut` where city='Hyde Park' && SIC_code='5261'DB:business_master_new
loadtime:0.11630606651306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyrum' limit 1
loadtime:0.11633801460266 / seconds
Query Executed:select id FROM `ut` where city='Hyrum' && SIC_code='5261'DB:business_master_new
loadtime:0.11686420440674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ibapah' limit 1
loadtime:0.1169261932373 / seconds
Query Executed:select id FROM `ut` where city='Ibapah' && SIC_code='5261'DB:business_master_new
loadtime:0.11730217933655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivins' limit 1
loadtime:0.11733102798462 / seconds
Query Executed:select id FROM `ut` where city='Ivins' && SIC_code='5261'DB:business_master_new
loadtime:0.11782598495483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jensen' limit 1
loadtime:0.11787819862366 / seconds
Query Executed:select id FROM `ut` where city='Jensen' && SIC_code='5261'DB:business_master_new
loadtime:0.11828899383545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph' limit 1
loadtime:0.11832904815674 / seconds
Query Executed:select id FROM `ut` where city='Joseph' && SIC_code='5261'DB:business_master_new
loadtime:0.11874413490295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction' limit 1
loadtime:0.11880016326904 / seconds
Query Executed:select id FROM `ut` where city='Junction' && SIC_code='5261'DB:business_master_new
loadtime:0.11920809745789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamas' limit 1
loadtime:0.11924409866333 / seconds
Query Executed:select id FROM `ut` where city='Kamas' && SIC_code='5261'DB:business_master_new
loadtime:0.11976718902588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanab' limit 1
loadtime:0.11982607841492 / seconds
Query Executed:select id FROM `ut` where city='Kanab' && SIC_code='5261'DB:business_master_new
loadtime:0.12044906616211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanarraville' limit 1
loadtime:0.12049698829651 / seconds
Query Executed:select id FROM `ut` where city='Kanarraville' && SIC_code='5261'DB:business_master_new
loadtime:0.12091708183289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanosh' limit 1
loadtime:0.12095999717712 / seconds
Query Executed:select id FROM `ut` where city='Kanosh' && SIC_code='5261'DB:business_master_new
loadtime:0.12139320373535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaysville' limit 1
loadtime:0.12143516540527 / seconds
Query Executed:select id FROM `ut` where city='Kaysville' && SIC_code='5261'DB:business_master_new
loadtime:0.12369203567505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearns' limit 1
loadtime:0.12373304367065 / seconds
Query Executed:select id FROM `ut` where city='Kearns' && SIC_code='5261'DB:business_master_new
loadtime:0.12427520751953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:0.12433314323425 / seconds
Query Executed:select id FROM `ut` where city='Kenilworth' && SIC_code='5261'DB:business_master_new
loadtime:0.1245801448822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.12461709976196 / seconds
Query Executed:select id FROM `ut` where city='Kingston' && SIC_code='5261'DB:business_master_new
loadtime:0.12493014335632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koosharem' limit 1
loadtime:0.12497615814209 / seconds
Query Executed:select id FROM `ut` where city='Koosharem' && SIC_code='5261'DB:business_master_new
loadtime:0.12534618377686 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Sal' limit 1
loadtime:0.12539219856262 / seconds
Query Executed:select id FROM `ut` where city='La Sal' && SIC_code='5261'DB:business_master_new
loadtime:0.12581014633179 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Verkin' limit 1
loadtime:0.12586212158203 / seconds
Query Executed:select id FROM `ut` where city='La Verkin' && SIC_code='5261'DB:business_master_new
loadtime:0.1262891292572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Powell' limit 1
loadtime:0.12632203102112 / seconds
Query Executed:select id FROM `ut` where city='Lake Powell' && SIC_code='5261'DB:business_master_new
loadtime:0.12676501274109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laketown' limit 1
loadtime:0.12682199478149 / seconds
Query Executed:select id FROM `ut` where city='Laketown' && SIC_code='5261'DB:business_master_new
loadtime:0.12726616859436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapoint' limit 1
loadtime:0.12731218338013 / seconds
Query Executed:select id FROM `ut` where city='Lapoint' && SIC_code='5261'DB:business_master_new
loadtime:0.12773704528809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:0.12778615951538 / seconds
Query Executed:select id FROM `ut` where city='Layton' && SIC_code='5261'DB:business_master_new
loadtime:0.13004302978516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leamington' limit 1
loadtime:0.13009810447693 / seconds
Query Executed:select id FROM `ut` where city='Leamington' && SIC_code='5261'DB:business_master_new
loadtime:0.13043117523193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:0.13047409057617 / seconds
Query Executed:select id FROM `ut` where city='Leeds' && SIC_code='5261'DB:business_master_new
loadtime:0.13089203834534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehi' limit 1
loadtime:0.13093900680542 / seconds
Query Executed:select id FROM `ut` where city='Lehi' && SIC_code='5261'DB:business_master_new
loadtime:0.13173317909241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levan' limit 1
loadtime:0.13178420066833 / seconds
Query Executed:select id FROM `ut` where city='Levan' && SIC_code='5261'DB:business_master_new
loadtime:0.13220715522766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:0.13224601745605 / seconds
Query Executed:select id FROM `ut` where city='Lewiston' && SIC_code='5261'DB:business_master_new
loadtime:0.1327121257782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:0.13275909423828 / seconds
Query Executed:select id FROM `ut` where city='Lindon' && SIC_code='5261'DB:business_master_new
loadtime:0.13340520858765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loa' limit 1
loadtime:0.13346099853516 / seconds
Query Executed:select id FROM `ut` where city='Loa' && SIC_code='5261'DB:business_master_new
loadtime:0.13389015197754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.13393616676331 / seconds
Query Executed:select id FROM `ut` where city='Logan' && SIC_code='5261'DB:business_master_new
loadtime:0.13618111610413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.13624501228333 / seconds
Query Executed:select id FROM `ut` where city='Lyman' && SIC_code='5261'DB:business_master_new
loadtime:0.13658118247986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynndyl' limit 1
loadtime:0.13662099838257 / seconds
Query Executed:select id FROM `ut` where city='Lynndyl' && SIC_code='5261'DB:business_master_new
loadtime:0.13696002960205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magna' limit 1
loadtime:0.13700103759766 / seconds
Query Executed:select id FROM `ut` where city='Magna' && SIC_code='5261'DB:business_master_new
loadtime:0.13759016990662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manila' limit 1
loadtime:0.13763999938965 / seconds
Query Executed:select id FROM `ut` where city='Manila' && SIC_code='5261'DB:business_master_new
loadtime:0.13808298110962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manti' limit 1
loadtime:0.13812613487244 / seconds
Query Executed:select id FROM `ut` where city='Manti' && SIC_code='5261'DB:business_master_new
loadtime:0.13866019248962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:0.13871717453003 / seconds
Query Executed:select id FROM `ut` where city='Mantua' && SIC_code='5261'DB:business_master_new
loadtime:0.13919615745544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.139240026474 / seconds
Query Executed:select id FROM `ut` where city='Mapleton' && SIC_code='5261'DB:business_master_new
loadtime:0.13978314399719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysvale' limit 1
loadtime:0.13983416557312 / seconds
Query Executed:select id FROM `ut` where city='Marysvale' && SIC_code='5261'DB:business_master_new
loadtime:0.1402440071106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:0.14027810096741 / seconds
Query Executed:select id FROM `ut` where city='Mayfield' && SIC_code='5261'DB:business_master_new
loadtime:0.14069104194641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.14074301719666 / seconds
Query Executed:select id FROM `ut` where city='Meadow' && SIC_code='5261'DB:business_master_new
loadtime:0.14110016822815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:0.14113402366638 / seconds
Query Executed:select id FROM `ut` where city='Mendon' && SIC_code='5261'DB:business_master_new
loadtime:0.14157199859619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Hat' limit 1
loadtime:0.14160704612732 / seconds
Query Executed:select id FROM `ut` where city='Mexican Hat' && SIC_code='5261'DB:business_master_new
loadtime:0.14200615882874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midvale' limit 1
loadtime:0.14205718040466 / seconds
Query Executed:select id FROM `ut` where city='Midvale' && SIC_code='5261'DB:business_master_new
loadtime:0.14427614212036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway' limit 1
loadtime:0.14433312416077 / seconds
Query Executed:select id FROM `ut` where city='Midway' && SIC_code='5261'DB:business_master_new
loadtime:0.14481210708618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.14486002922058 / seconds
Query Executed:select id FROM `ut` where city='Milford' && SIC_code='5261'DB:business_master_new
loadtime:0.14531803131104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:0.1453549861908 / seconds
Query Executed:select id FROM `ut` where city='Millville' && SIC_code='5261'DB:business_master_new
loadtime:0.14581918716431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minersville' limit 1
loadtime:0.14587903022766 / seconds
Query Executed:select id FROM `ut` where city='Minersville' && SIC_code='5261'DB:business_master_new
loadtime:0.1463041305542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moab' limit 1
loadtime:0.14634013175964 / seconds
Query Executed:select id FROM `ut` where city='Moab' && SIC_code='5261'DB:business_master_new
loadtime:0.14711499214172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:0.14714908599854 / seconds
Query Executed:select id FROM `ut` where city='Modena' && SIC_code='5261'DB:business_master_new
loadtime:0.14742398262024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mona' limit 1
loadtime:0.14746403694153 / seconds
Query Executed:select id FROM `ut` where city='Mona' && SIC_code='5261'DB:business_master_new
loadtime:0.14790105819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.14794611930847 / seconds
Query Executed:select id FROM `ut` where city='Monroe' && SIC_code='5261'DB:business_master_new
loadtime:0.14841198921204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma Creek' limit 1
loadtime:0.14844012260437 / seconds
Query Executed:select id FROM `ut` where city='Montezuma Creek' && SIC_code='5261'DB:business_master_new
loadtime:0.14886808395386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.14891719818115 / seconds
Query Executed:select id FROM `ut` where city='Monticello' && SIC_code='5261'DB:business_master_new
loadtime:0.14942097663879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Valley' limit 1
loadtime:0.14946508407593 / seconds
Query Executed:select id FROM `ut` where city='Monument Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.1499330997467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.14997720718384 / seconds
Query Executed:select id FROM `ut` where city='Morgan' && SIC_code='5261'DB:business_master_new
loadtime:0.15053105354309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moroni' limit 1
loadtime:0.15056610107422 / seconds
Query Executed:select id FROM `ut` where city='Moroni' && SIC_code='5261'DB:business_master_new
loadtime:0.15100407600403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.15105104446411 / seconds
Query Executed:select id FROM `ut` where city='Mount Carmel' && SIC_code='5261'DB:business_master_new
loadtime:0.15144610404968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.15148615837097 / seconds
Query Executed:select id FROM `ut` where city='Mount Pleasant' && SIC_code='5261'DB:business_master_new
loadtime:0.1520471572876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:0.15210008621216 / seconds
Query Executed:select id FROM `ut` where city='Mountain Home' && SIC_code='5261'DB:business_master_new
loadtime:0.15246105194092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.15250015258789 / seconds
Query Executed:select id FROM `ut` where city='Mt Carmel' && SIC_code='5261'DB:business_master_new
loadtime:0.15272402763367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.15275597572327 / seconds
Query Executed:select id FROM `ut` where city='Mt Pleasant' && SIC_code='5261'DB:business_master_new
loadtime:0.15315413475037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.15319108963013 / seconds
Query Executed:select id FROM `ut` where city='Murray' && SIC_code='5261'DB:business_master_new
loadtime:0.15368103981018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myton' limit 1
loadtime:0.15375113487244 / seconds
Query Executed:select id FROM `ut` where city='Myton' && SIC_code='5261'DB:business_master_new
loadtime:0.15414619445801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.15418100357056 / seconds
Query Executed:select id FROM `ut` where city='Neola' && SIC_code='5261'DB:business_master_new
loadtime:0.15467619895935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nephi' limit 1
loadtime:0.15470600128174 / seconds
Query Executed:select id FROM `ut` where city='Nephi' && SIC_code='5261'DB:business_master_new
loadtime:0.15526819229126 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Harmony' limit 1
loadtime:0.15532803535461 / seconds
Query Executed:select id FROM `ut` where city='New Harmony' && SIC_code='5261'DB:business_master_new
loadtime:0.15583109855652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcastle' limit 1
loadtime:0.1558849811554 / seconds
Query Executed:select id FROM `ut` where city='Newcastle' && SIC_code='5261'DB:business_master_new
loadtime:0.15627408027649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.15631008148193 / seconds
Query Executed:select id FROM `ut` where city='Newton' && SIC_code='5261'DB:business_master_new
loadtime:0.15681409835815 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salt Lake' limit 1
loadtime:0.15686511993408 / seconds
Query Executed:select id FROM `ut` where city='North Salt Lake' && SIC_code='5261'DB:business_master_new
loadtime:0.15757012367249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:0.15761113166809 / seconds
Query Executed:select id FROM `ut` where city='Oak City' && SIC_code='5261'DB:business_master_new
loadtime:0.15805506706238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:0.15810298919678 / seconds
Query Executed:select id FROM `ut` where city='Oakley' && SIC_code='5261'DB:business_master_new
loadtime:0.15855002403259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oasis' limit 1
loadtime:0.15859198570251 / seconds
Query Executed:select id FROM `ut` where city='Oasis' && SIC_code='5261'DB:business_master_new
loadtime:0.15881204605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:0.15885019302368 / seconds
Query Executed:select id FROM `ut` where city='Ogden' && SIC_code='5261'DB:business_master_new
loadtime:0.16107702255249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeville' limit 1
loadtime:0.16113805770874 / seconds
Query Executed:select id FROM `ut` where city='Orangeville' && SIC_code='5261'DB:business_master_new
loadtime:0.16156005859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orderville' limit 1
loadtime:0.1615891456604 / seconds
Query Executed:select id FROM `ut` where city='Orderville' && SIC_code='5261'DB:business_master_new
loadtime:0.16203498840332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orem' limit 1
loadtime:0.16208720207214 / seconds
Query Executed:select id FROM `ut` where city='Orem' && SIC_code='5261'DB:business_master_new
loadtime:0.16437697410583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panguitch' limit 1
loadtime:0.16443419456482 / seconds
Query Executed:select id FROM `ut` where city='Panguitch' && SIC_code='5261'DB:business_master_new
loadtime:0.16497111320496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:0.16501903533936 / seconds
Query Executed:select id FROM `ut` where city='Paradise' && SIC_code='5261'DB:business_master_new
loadtime:0.16543197631836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paragonah' limit 1
loadtime:0.16548204421997 / seconds
Query Executed:select id FROM `ut` where city='Paragonah' && SIC_code='5261'DB:business_master_new
loadtime:0.16589999198914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park City' limit 1
loadtime:0.16593408584595 / seconds
Query Executed:select id FROM `ut` where city='Park City' && SIC_code='5261'DB:business_master_new
loadtime:0.16818714141846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Valley' limit 1
loadtime:0.16823410987854 / seconds
Query Executed:select id FROM `ut` where city='Park Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.16853618621826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parowan' limit 1
loadtime:0.16858220100403 / seconds
Query Executed:select id FROM `ut` where city='Parowan' && SIC_code='5261'DB:business_master_new
loadtime:0.16908407211304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.16912603378296 / seconds
Query Executed:select id FROM `ut` where city='Payson' && SIC_code='5261'DB:business_master_new
loadtime:0.16983413696289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoa' limit 1
loadtime:0.16989517211914 / seconds
Query Executed:select id FROM `ut` where city='Peoa' && SIC_code='5261'DB:business_master_new
loadtime:0.17031598091125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Valley' limit 1
loadtime:0.17034506797791 / seconds
Query Executed:select id FROM `ut` where city='Pine Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.17066311836243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Grove' limit 1
loadtime:0.17071413993835 / seconds
Query Executed:select id FROM `ut` where city='Pleasant Grove' && SIC_code='5261'DB:business_master_new
loadtime:0.17151212692261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.17155718803406 / seconds
Query Executed:select id FROM `ut` where city='Plymouth' && SIC_code='5261'DB:business_master_new
loadtime:0.17202615737915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:0.17206907272339 / seconds
Query Executed:select id FROM `ut` where city='Portage' && SIC_code='5261'DB:business_master_new
loadtime:0.17235708236694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Price' limit 1
loadtime:0.1724100112915 / seconds
Query Executed:select id FROM `ut` where city='Price' && SIC_code='5261'DB:business_master_new
loadtime:0.17317008972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:0.17322206497192 / seconds
Query Executed:select id FROM `ut` where city='Providence' && SIC_code='5261'DB:business_master_new
loadtime:0.17377114295959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provo' limit 1
loadtime:0.17381405830383 / seconds
Query Executed:select id FROM `ut` where city='Provo' && SIC_code='5261'DB:business_master_new
loadtime:0.17607498168945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randlett' limit 1
loadtime:0.17613410949707 / seconds
Query Executed:select id FROM `ut` where city='Randlett' && SIC_code='5261'DB:business_master_new
loadtime:0.17657399177551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.1766140460968 / seconds
Query Executed:select id FROM `ut` where city='Randolph' && SIC_code='5261'DB:business_master_new
loadtime:0.17706298828125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redmond' limit 1
loadtime:0.17710900306702 / seconds
Query Executed:select id FROM `ut` where city='Redmond' && SIC_code='5261'DB:business_master_new
loadtime:0.17752599716187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:0.17756700515747 / seconds
Query Executed:select id FROM `ut` where city='Richfield' && SIC_code='5261'DB:business_master_new
loadtime:0.17830014228821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.17835307121277 / seconds
Query Executed:select id FROM `ut` where city='Richmond' && SIC_code='5261'DB:business_master_new
loadtime:0.1788489818573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.17889618873596 / seconds
Query Executed:select id FROM `ut` where city='Riverside' && SIC_code='5261'DB:business_master_new
loadtime:0.17929410934448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.17933011054993 / seconds
Query Executed:select id FROM `ut` where city='Riverton' && SIC_code='5261'DB:business_master_new
loadtime:0.18022918701172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:0.18028616905212 / seconds
Query Executed:select id FROM `ut` where city='Rockville' && SIC_code='5261'DB:business_master_new
loadtime:0.18066120147705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.18070912361145 / seconds
Query Executed:select id FROM `ut` where city='Roosevelt' && SIC_code='5261'DB:business_master_new
loadtime:0.18139600753784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.18145608901978 / seconds
Query Executed:select id FROM `ut` where city='Roy' && SIC_code='5261'DB:business_master_new
loadtime:0.18213820457458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush Valley' limit 1
loadtime:0.18219113349915 / seconds
Query Executed:select id FROM `ut` where city='Rush Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.18256497383118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.18260908126831 / seconds
Query Executed:select id FROM `ut` where city='Saint George' && SIC_code='5261'DB:business_master_new
loadtime:0.18485403060913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.18491506576538 / seconds
Query Executed:select id FROM `ut` where city='Salem' && SIC_code='5261'DB:business_master_new
loadtime:0.18542313575745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salina' limit 1
loadtime:0.18545818328857 / seconds
Query Executed:select id FROM `ut` where city='Salina' && SIC_code='5261'DB:business_master_new
loadtime:0.18595910072327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salt Lake City' limit 1
loadtime:0.18600797653198 / seconds
Query Executed:select id FROM `ut` where city='Salt Lake City' && SIC_code='5261'DB:business_master_new
loadtime:0.18832397460938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy' limit 1
loadtime:0.18843102455139 / seconds
Query Executed:select id FROM `ut` where city='Sandy' && SIC_code='5261'DB:business_master_new
loadtime:0.19071102142334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:0.19077301025391 / seconds
Query Executed:select id FROM `ut` where city='Santa Clara' && SIC_code='5261'DB:business_master_new
loadtime:0.19131708145142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santaquin' limit 1
loadtime:0.19138503074646 / seconds
Query Executed:select id FROM `ut` where city='Santaquin' && SIC_code='5261'DB:business_master_new
loadtime:0.19190502166748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga Springs' limit 1
loadtime:0.19194912910461 / seconds
Query Executed:select id FROM `ut` where city='Saratoga Springs' && SIC_code='5261'DB:business_master_new
loadtime:0.19242715835571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scipio' limit 1
loadtime:0.19246816635132 / seconds
Query Executed:select id FROM `ut` where city='Scipio' && SIC_code='5261'DB:business_master_new
loadtime:0.19285106658936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sevier' limit 1
loadtime:0.1928870677948 / seconds
Query Executed:select id FROM `ut` where city='Sevier' && SIC_code='5261'DB:business_master_new
loadtime:0.19319200515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigurd' limit 1
loadtime:0.19323301315308 / seconds
Query Executed:select id FROM `ut` where city='Sigurd' && SIC_code='5261'DB:business_master_new
loadtime:0.19369697570801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:0.19376802444458 / seconds
Query Executed:select id FROM `ut` where city='Smithfield' && SIC_code='5261'DB:business_master_new
loadtime:0.19434905052185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowbird' limit 1
loadtime:0.19439005851746 / seconds
Query Executed:select id FROM `ut` where city='Snowbird' && SIC_code='5261'DB:business_master_new
loadtime:0.19476509094238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowville' limit 1
loadtime:0.19481706619263 / seconds
Query Executed:select id FROM `ut` where city='Snowville' && SIC_code='5261'DB:business_master_new
loadtime:0.1953010559082 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Jordan' limit 1
loadtime:0.19533610343933 / seconds
Query Executed:select id FROM `ut` where city='South Jordan' && SIC_code='5261'DB:business_master_new
loadtime:0.1975531578064 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Salt Lake' limit 1
loadtime:0.19759798049927 / seconds
Query Executed:select id FROM `ut` where city='South Salt Lake' && SIC_code='5261'DB:business_master_new
loadtime:0.19802618026733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanish Fork' limit 1
loadtime:0.19807600975037 / seconds
Query Executed:select id FROM `ut` where city='Spanish Fork' && SIC_code='5261'DB:business_master_new
loadtime:0.19895815849304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring City' limit 1
loadtime:0.19901609420776 / seconds
Query Executed:select id FROM `ut` where city='Spring City' && SIC_code='5261'DB:business_master_new
loadtime:0.1994571685791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springdale' limit 1
loadtime:0.19949817657471 / seconds
Query Executed:select id FROM `ut` where city='Springdale' && SIC_code='5261'DB:business_master_new
loadtime:0.19994401931763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:0.19999003410339 / seconds
Query Executed:select id FROM `ut` where city='Springville' && SIC_code='5261'DB:business_master_new
loadtime:0.20083808898926 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.20089912414551 / seconds
Query Executed:select id FROM `ut` where city='St George' && SIC_code='5261'DB:business_master_new
loadtime:0.20138502120972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.20142912864685 / seconds
Query Executed:select id FROM `ut` where city='Sterling' && SIC_code='5261'DB:business_master_new
loadtime:0.20184516906738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:0.20189213752747 / seconds
Query Executed:select id FROM `ut` where city='Stockton' && SIC_code='5261'DB:business_master_new
loadtime:0.20230507850647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.20234107971191 / seconds
Query Executed:select id FROM `ut` where city='Summit' && SIC_code='5261'DB:business_master_new
loadtime:0.20269417762756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunnyside' limit 1
loadtime:0.20273017883301 / seconds
Query Executed:select id FROM `ut` where city='Sunnyside' && SIC_code='5261'DB:business_master_new
loadtime:0.20309114456177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syracuse' limit 1
loadtime:0.2031409740448 / seconds
Query Executed:select id FROM `ut` where city='Syracuse' && SIC_code='5261'DB:business_master_new
loadtime:0.20372104644775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabiona' limit 1
loadtime:0.20378112792969 / seconds
Query Executed:select id FROM `ut` where city='Tabiona' && SIC_code='5261'DB:business_master_new
loadtime:0.2041871547699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talmage' limit 1
loadtime:0.20424008369446 / seconds
Query Executed:select id FROM `ut` where city='Talmage' && SIC_code='5261'DB:business_master_new
loadtime:0.20460414886475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teasdale' limit 1
loadtime:0.20463705062866 / seconds
Query Executed:select id FROM `ut` where city='Teasdale' && SIC_code='5261'DB:business_master_new
loadtime:0.20501303672791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terra' limit 1
loadtime:0.20506501197815 / seconds
Query Executed:select id FROM `ut` where city='Terra' && SIC_code='5261'DB:business_master_new
loadtime:0.20531415939331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.20535016059875 / seconds
Query Executed:select id FROM `ut` where city='Thompson' && SIC_code='5261'DB:business_master_new
loadtime:0.20567512512207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tooele' limit 1
loadtime:0.20571708679199 / seconds
Query Executed:select id FROM `ut` where city='Tooele' && SIC_code='5261'DB:business_master_new
loadtime:0.20797109603882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toquerville' limit 1
loadtime:0.20802998542786 / seconds
Query Executed:select id FROM `ut` where city='Toquerville' && SIC_code='5261'DB:business_master_new
loadtime:0.20847511291504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrey' limit 1
loadtime:0.20851516723633 / seconds
Query Executed:select id FROM `ut` where city='Torrey' && SIC_code='5261'DB:business_master_new
loadtime:0.20894598960876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremonton' limit 1
loadtime:0.20898818969727 / seconds
Query Executed:select id FROM `ut` where city='Tremonton' && SIC_code='5261'DB:business_master_new
loadtime:0.2096540927887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:0.2097110748291 / seconds
Query Executed:select id FROM `ut` where city='Trenton' && SIC_code='5261'DB:business_master_new
loadtime:0.21012020111084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tridell' limit 1
loadtime:0.21017718315125 / seconds
Query Executed:select id FROM `ut` where city='Tridell' && SIC_code='5261'DB:business_master_new
loadtime:0.21047520637512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tropic' limit 1
loadtime:0.21050310134888 / seconds
Query Executed:select id FROM `ut` where city='Tropic' && SIC_code='5261'DB:business_master_new
loadtime:0.21092319488525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Venice' limit 1
loadtime:0.21097302436829 / seconds
Query Executed:select id FROM `ut` where city='Venice' && SIC_code='5261'DB:business_master_new
loadtime:0.21127319335938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernal' limit 1
loadtime:0.21131110191345 / seconds
Query Executed:select id FROM `ut` where city='Vernal' && SIC_code='5261'DB:business_master_new
loadtime:0.21356105804443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.21361804008484 / seconds
Query Executed:select id FROM `ut` where city='Vernon' && SIC_code='5261'DB:business_master_new
loadtime:0.21398115158081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veyo' limit 1
loadtime:0.21402812004089 / seconds
Query Executed:select id FROM `ut` where city='Veyo' && SIC_code='5261'DB:business_master_new
loadtime:0.21443104743958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgin' limit 1
loadtime:0.21447110176086 / seconds
Query Executed:select id FROM `ut` where city='Virgin' && SIC_code='5261'DB:business_master_new
loadtime:0.21484899520874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:0.21489310264587 / seconds
Query Executed:select id FROM `ut` where city='Wales' && SIC_code='5261'DB:business_master_new
loadtime:0.21524214744568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallsburg' limit 1
loadtime:0.21527099609375 / seconds
Query Executed:select id FROM `ut` where city='Wallsburg' && SIC_code='5261'DB:business_master_new
loadtime:0.21571397781372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.2157621383667 / seconds
Query Executed:select id FROM `ut` where city='Washington' && SIC_code='5261'DB:business_master_new
loadtime:0.2163200378418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:0.21637320518494 / seconds
Query Executed:select id FROM `ut` where city='Wellington' && SIC_code='5261'DB:business_master_new
loadtime:0.21681499481201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsville' limit 1
loadtime:0.21686410903931 / seconds
Query Executed:select id FROM `ut` where city='Wellsville' && SIC_code='5261'DB:business_master_new
loadtime:0.21735215187073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendover' limit 1
loadtime:0.21741819381714 / seconds
Query Executed:select id FROM `ut` where city='Wendover' && SIC_code='5261'DB:business_master_new
loadtime:0.21788620948792 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.21793103218079 / seconds
Query Executed:select id FROM `ut` where city='West Haven' && SIC_code='5261'DB:business_master_new
loadtime:0.21817016601562 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jordan' limit 1
loadtime:0.21820902824402 / seconds
Query Executed:select id FROM `ut` where city='West Jordan' && SIC_code='5261'DB:business_master_new
loadtime:0.22043204307556 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Valley' limit 1
loadtime:0.22049307823181 / seconds
Query Executed:select id FROM `ut` where city='West Valley' && SIC_code='5261'DB:business_master_new
loadtime:0.22092604637146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiterocks' limit 1
loadtime:0.22095513343811 / seconds
Query Executed:select id FROM `ut` where city='Whiterocks' && SIC_code='5261'DB:business_master_new
loadtime:0.22128105163574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:0.22131419181824 / seconds
Query Executed:select id FROM `ut` where city='Willard' && SIC_code='5261'DB:business_master_new
loadtime:0.22179913520813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Hills' limit 1
loadtime:0.22184205055237 / seconds
Query Executed:select id FROM `ut` where city='Woodland Hills' && SIC_code='5261'DB:business_master_new
loadtime:0.22206115722656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.22209501266479 / seconds
Query Executed:select id FROM `ut` where city='Woodruff' && SIC_code='5261'DB:business_master_new
loadtime:0.22247505187988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross' limit 1
loadtime:0.22251605987549 / seconds
Query Executed:select id FROM `ut` where city='Woods Cross' && SIC_code='5261'DB:business_master_new
loadtime:0.2247359752655 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.22483015060425 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.22498416900635 / seconds
Operation template executed (chunk cache operation)
loadtime:0.22505307197571 / seconds
template override:Default
loadtime:0.22506999969482 / 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.22585606575012 / seconds
Template Constructed, Array Rows:49
loadtime:0.22608709335327 / seconds
TOTAL EXECUTION TIME: 0.2259
loadtime:0.22616815567017 / 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] => retail-nurseries-lawn-and-garden-supply-stores [stateURLid] => utah )


_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.22617316246033
TOTAL KEY ARRAYS: 69