Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.0810317993164E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00050687789916992 / seconds
host not found setting manual db connection
loadtime:0.00092196464538574 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011889934539795 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.00130295753479 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0013489723205566 / seconds
zipcode:
loadtime:0.0013649463653564 / seconds
Query Executed:select * from search_referrer where page_hash='589e1c1fdee801fef88d0717f9cdeee4' limit 10 DB:ezrox_toadli
loadtime:0.0015468597412109 / seconds
Operation header executed (non global)
loadtime:0.0015628337860107 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015878677368164 / seconds
Operation square executed (non global)
loadtime:0.001600980758667 / seconds
Operation square_bottom executed (non global)
loadtime:0.0016138553619385 / seconds
Operation smallsquare executed (non global)
loadtime:0.0016238689422607 / seconds
Operation headeradright executed (non global)
loadtime:0.0016357898712158 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016458034515381 / seconds
Operation topstories executed (non global)
loadtime:0.0016567707061768 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016679763793945 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016779899597168 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0019738674163818 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.002119779586792 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0021598339080811 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0022737979888916 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0023398399353027 / seconds
Template key: archive_menu pushed
loadtime:0.0023488998413086 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0023579597473145 / seconds
Template key: get_gravatar pushed
loadtime:0.0023648738861084 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0023708343505859 / seconds
*10)-10)+1 | start:0
loadtime:0.0024058818817139 / seconds
DB connected to localhost business_master_new
loadtime:0.0028939247131348 / seconds
Query Executed:select * from categories where cat_URLid='hotels-and-motels'DB:business_master_new
loadtime:0.0036468505859375 / seconds
Query stored in cache : _QUERY_www.toadli.coma3d211b8c105c1f61843ec3bcfcfa87f
loadtime:0.0037038326263428 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-jersey'
loadtime:0.0037639141082764 / seconds
Query Executed:select * from `nj_catmap` where sic='7011' order by city ascDB:business_master_new
loadtime:0.065288782119751 / seconds
Query stored in cache : _QUERY_www.toadli.comc7e9217eb826b84e718bd6d4e8477d03
loadtime:0.066371917724609 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-jersey'
loadtime:0.066423892974854 / seconds
Query Executed:select sum(totalcount) as totalsum from `nj_catmap` where sic='7011'DB:business_master_new
loadtime:0.070538997650146 / seconds
Query stored in cache : _QUERY_www.toadli.com6b9800f11242cff0c0ee278100f8a284
loadtime:0.070565938949585 / seconds
696 / 11
loadtime:0.070605993270874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Absecon' limit 1
loadtime:0.070655822753906 / seconds
Query Executed:select id FROM `nj` where city='Absecon' && SIC_code='7011'DB:business_master_new
loadtime:0.096646785736084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adelphia' limit 1
loadtime:0.096774816513062 / seconds
Query Executed:select id FROM `nj` where city='Adelphia' && SIC_code='7011'DB:business_master_new
loadtime:0.11890983581543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allamuchy' limit 1
loadtime:0.118971824646 / seconds
Query Executed:select id FROM `nj` where city='Allamuchy' && SIC_code='7011'DB:business_master_new
loadtime:0.14947390556335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.14954090118408 / seconds
Query Executed:select id FROM `nj` where city='Allendale' && SIC_code='7011'DB:business_master_new
loadtime:0.15167784690857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenhurst' limit 1
loadtime:0.15183281898499 / seconds
Query Executed:select id FROM `nj` where city='Allenhurst' && SIC_code='7011'DB:business_master_new
loadtime:0.15376782417297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allentown' limit 1
loadtime:0.1538028717041 / seconds
Query Executed:select id FROM `nj` where city='Allentown' && SIC_code='7011'DB:business_master_new
loadtime:0.15505290031433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenwood' limit 1
loadtime:0.1550989151001 / seconds
Query Executed:select id FROM `nj` where city='Allenwood' && SIC_code='7011'DB:business_master_new
loadtime:0.19890880584717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alloway' limit 1
loadtime:0.19895792007446 / seconds
Query Executed:select id FROM `nj` where city='Alloway' && SIC_code='7011'DB:business_master_new
loadtime:0.2279109954834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.22796988487244 / seconds
Query Executed:select id FROM `nj` where city='Alpha' && SIC_code='7011'DB:business_master_new
loadtime:0.23120594024658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.23125576972961 / seconds
Query Executed:select id FROM `nj` where city='Alpine' && SIC_code='7011'DB:business_master_new
loadtime:0.27910685539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.2791428565979 / seconds
Query Executed:select id FROM `nj` where city='Andover' && SIC_code='7011'DB:business_master_new
loadtime:0.28134489059448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.28143882751465 / seconds
Query Executed:select id FROM `nj` where city='Annandale' && SIC_code='7011'DB:business_master_new
loadtime:0.2839949131012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury' limit 1
loadtime:0.28409290313721 / seconds
Query Executed:select id FROM `nj` where city='Asbury' && SIC_code='7011'DB:business_master_new
loadtime:0.28572297096252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury Park' limit 1
loadtime:0.28577780723572 / seconds
Query Executed:select id FROM `nj` where city='Asbury Park' && SIC_code='7011'DB:business_master_new
loadtime:0.29564595222473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atco' limit 1
loadtime:0.29569792747498 / seconds
Query Executed:select id FROM `nj` where city='Atco' && SIC_code='7011'DB:business_master_new
loadtime:0.29882097244263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic City' limit 1
loadtime:0.29887700080872 / seconds
Query Executed:select id FROM `nj` where city='Atlantic City' && SIC_code='7011'DB:business_master_new
loadtime:0.33165287971497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Hghlnds' limit 1
loadtime:0.3317608833313 / seconds
Query Executed:select id FROM `nj` where city='Atlantic Hghlnds' && SIC_code='7011'DB:business_master_new
loadtime:0.34787392616272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Highlands' limit 1
loadtime:0.34793877601624 / seconds
Query Executed:select id FROM `nj` where city='Atlantic Highlands' && SIC_code='7011'DB:business_master_new
loadtime:0.35002994537354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.35007381439209 / seconds
Query Executed:select id FROM `nj` where city='Audubon' && SIC_code='7011'DB:business_master_new
loadtime:0.3516309261322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.35168480873108 / seconds
Query Executed:select id FROM `nj` where city='Augusta' && SIC_code='7011'DB:business_master_new
loadtime:0.35280084609985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.35284686088562 / seconds
Query Executed:select id FROM `nj` where city='Avalon' && SIC_code='7011'DB:business_master_new
loadtime:0.35799098014832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avenel' limit 1
loadtime:0.35803985595703 / seconds
Query Executed:select id FROM `nj` where city='Avenel' && SIC_code='7011'DB:business_master_new
loadtime:0.36673283576965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon By The Sea' limit 1
loadtime:0.36679697036743 / seconds
Query Executed:select id FROM `nj` where city='Avon By The Sea' && SIC_code='7011'DB:business_master_new
loadtime:0.36988377571106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baptistown' limit 1
loadtime:0.36995196342468 / seconds
Query Executed:select id FROM `nj` where city='Baptistown' && SIC_code='7011'DB:business_master_new
loadtime:0.38429999351501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnegat' limit 1
loadtime:0.38434886932373 / seconds
Query Executed:select id FROM `nj` where city='Barnegat' && SIC_code='7011'DB:business_master_new
loadtime:0.38761782646179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnegat Light' limit 1
loadtime:0.38773488998413 / seconds
Query Executed:select id FROM `nj` where city='Barnegat Light' && SIC_code='7011'DB:business_master_new
loadtime:0.44430088996887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.44436097145081 / seconds
Query Executed:select id FROM `nj` where city='Barrington' && SIC_code='7011'DB:business_master_new
loadtime:0.44612288475037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basking Ridge' limit 1
loadtime:0.4461669921875 / seconds
Query Executed:select id FROM `nj` where city='Basking Ridge' && SIC_code='7011'DB:business_master_new
loadtime:0.44901990890503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Head' limit 1
loadtime:0.44905281066895 / seconds
Query Executed:select id FROM `nj` where city='Bay Head' && SIC_code='7011'DB:business_master_new
loadtime:0.48230695724487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayonne' limit 1
loadtime:0.48234295845032 / seconds
Query Executed:select id FROM `nj` where city='Bayonne' && SIC_code='7011'DB:business_master_new
loadtime:0.48547387123108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayville' limit 1
loadtime:0.48552393913269 / seconds
Query Executed:select id FROM `nj` where city='Bayville' && SIC_code='7011'DB:business_master_new
loadtime:0.48784995079041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beach Haven' limit 1
loadtime:0.48788976669312 / seconds
Query Executed:select id FROM `nj` where city='Beach Haven' && SIC_code='7011'DB:business_master_new
loadtime:0.50535297393799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beachwood' limit 1
loadtime:0.5054337978363 / seconds
Query Executed:select id FROM `nj` where city='Beachwood' && SIC_code='7011'DB:business_master_new
loadtime:0.50670790672302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedminster' limit 1
loadtime:0.50675678253174 / seconds
Query Executed:select id FROM `nj` where city='Bedminster' && SIC_code='7011'DB:business_master_new
loadtime:0.50839686393738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belford' limit 1
loadtime:0.50845193862915 / seconds
Query Executed:select id FROM `nj` where city='Belford' && SIC_code='7011'DB:business_master_new
loadtime:0.50966095924377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Mead' limit 1
loadtime:0.50969576835632 / seconds
Query Executed:select id FROM `nj` where city='Belle Mead' && SIC_code='7011'DB:business_master_new
loadtime:0.51167297363281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.51182079315186 / seconds
Query Executed:select id FROM `nj` where city='Belleville' && SIC_code='7011'DB:business_master_new
loadtime:0.51738381385803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellmawr' limit 1
loadtime:0.51757287979126 / seconds
Query Executed:select id FROM `nj` where city='Bellmawr' && SIC_code='7011'DB:business_master_new
loadtime:0.52278280258179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmar' limit 1
loadtime:0.52282786369324 / seconds
Query Executed:select id FROM `nj` where city='Belmar' && SIC_code='7011'DB:business_master_new
loadtime:0.53335094451904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.53341889381409 / seconds
Query Executed:select id FROM `nj` where city='Belvidere' && SIC_code='7011'DB:business_master_new
loadtime:0.53523588180542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergenfield' limit 1
loadtime:0.53528094291687 / seconds
Query Executed:select id FROM `nj` where city='Bergenfield' && SIC_code='7011'DB:business_master_new
loadtime:0.53694295883179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkeley Heights' limit 1
loadtime:0.53697776794434 / seconds
Query Executed:select id FROM `nj` where city='Berkeley Heights' && SIC_code='7011'DB:business_master_new
loadtime:0.53887176513672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.53891396522522 / seconds
Query Executed:select id FROM `nj` where city='Berlin' && SIC_code='7011'DB:business_master_new
loadtime:0.54237794876099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardsville' limit 1
loadtime:0.54241895675659 / seconds
Query Executed:select id FROM `nj` where city='Bernardsville' && SIC_code='7011'DB:business_master_new
loadtime:0.54484677314758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.54496192932129 / seconds
Query Executed:select id FROM `nj` where city='Beverly' && SIC_code='7011'DB:business_master_new
loadtime:0.54803681373596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.54813480377197 / seconds
Query Executed:select id FROM `nj` where city='Birmingham' && SIC_code='7011'DB:business_master_new
loadtime:0.55268597602844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwood' limit 1
loadtime:0.55271983146667 / seconds
Query Executed:select id FROM `nj` where city='Blackwood' && SIC_code='7011'DB:business_master_new
loadtime:0.558513879776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:0.55862784385681 / seconds
Query Executed:select id FROM `nj` where city='Blairstown' && SIC_code='7011'DB:business_master_new
loadtime:0.56224489212036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blawenburg' limit 1
loadtime:0.56227588653564 / seconds
Query Executed:select id FROM `nj` where city='Blawenburg' && SIC_code='7011'DB:business_master_new
loadtime:0.5671718120575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.56720781326294 / seconds
Query Executed:select id FROM `nj` where city='Bloomfield' && SIC_code='7011'DB:business_master_new
loadtime:0.56991481781006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:0.56996583938599 / seconds
Query Executed:select id FROM `nj` where city='Bloomingdale' && SIC_code='7011'DB:business_master_new
loadtime:0.57119584083557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomsbury' limit 1
loadtime:0.57122778892517 / seconds
Query Executed:select id FROM `nj` where city='Bloomsbury' && SIC_code='7011'DB:business_master_new
loadtime:0.57232999801636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bogota' limit 1
loadtime:0.57236194610596 / seconds
Query Executed:select id FROM `nj` where city='Bogota' && SIC_code='7011'DB:business_master_new
loadtime:0.57357096672058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonton' limit 1
loadtime:0.57360291481018 / seconds
Query Executed:select id FROM `nj` where city='Boonton' && SIC_code='7011'DB:business_master_new
loadtime:0.57691788673401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bordentown' limit 1
loadtime:0.5769670009613 / seconds
Query Executed:select id FROM `nj` where city='Bordentown' && SIC_code='7011'DB:business_master_new
loadtime:0.58623600006104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bound Brook' limit 1
loadtime:0.58627986907959 / seconds
Query Executed:select id FROM `nj` where city='Bound Brook' && SIC_code='7011'DB:business_master_new
loadtime:0.58878684043884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley Beach' limit 1
loadtime:0.58882594108582 / seconds
Query Executed:select id FROM `nj` where city='Bradley Beach' && SIC_code='7011'DB:business_master_new
loadtime:0.59283781051636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchburg' limit 1
loadtime:0.59286785125732 / seconds
Query Executed:select id FROM `nj` where city='Branchburg' && SIC_code='7011'DB:business_master_new
loadtime:0.60210490226746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.60213780403137 / seconds
Query Executed:select id FROM `nj` where city='Branchville' && SIC_code='7011'DB:business_master_new
loadtime:0.60430479049683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brick' limit 1
loadtime:0.6043438911438 / seconds
Query Executed:select id FROM `nj` where city='Brick' && SIC_code='7011'DB:business_master_new
loadtime:0.61096787452698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.61100888252258 / seconds
Query Executed:select id FROM `nj` where city='Bridgeport' && SIC_code='7011'DB:business_master_new
loadtime:0.65772581100464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:0.65777397155762 / seconds
Query Executed:select id FROM `nj` where city='Bridgeton' && SIC_code='7011'DB:business_master_new
loadtime:0.66155481338501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.6616108417511 / seconds
Query Executed:select id FROM `nj` where city='Bridgewater' && SIC_code='7011'DB:business_master_new
loadtime:0.66837382316589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brielle' limit 1
loadtime:0.66850399971008 / seconds
Query Executed:select id FROM `nj` where city='Brielle' && SIC_code='7011'DB:business_master_new
loadtime:0.67205786705017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brigantine' limit 1
loadtime:0.67218780517578 / seconds
Query Executed:select id FROM `nj` where city='Brigantine' && SIC_code='7011'DB:business_master_new
loadtime:0.67711877822876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.67718195915222 / seconds
Query Executed:select id FROM `nj` where city='Broadway' && SIC_code='7011'DB:business_master_new
loadtime:0.69028782844543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklawn' limit 1
loadtime:0.69033598899841 / seconds
Query Executed:select id FROM `nj` where city='Brooklawn' && SIC_code='7011'DB:business_master_new
loadtime:0.69484996795654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookside' limit 1
loadtime:0.69489693641663 / seconds
Query Executed:select id FROM `nj` where city='Brookside' && SIC_code='7011'DB:business_master_new
loadtime:0.71731090545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Mills' limit 1
loadtime:0.71735787391663 / seconds
Query Executed:select id FROM `nj` where city='Browns Mills' && SIC_code='7011'DB:business_master_new
loadtime:0.7205798625946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Budd Lake' limit 1
loadtime:0.72061896324158 / seconds
Query Executed:select id FROM `nj` where city='Budd Lake' && SIC_code='7011'DB:business_master_new
loadtime:0.72455096244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena' limit 1
loadtime:0.72460389137268 / seconds
Query Executed:select id FROM `nj` where city='Buena' && SIC_code='7011'DB:business_master_new
loadtime:0.80408978462219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.80415081977844 / seconds
Query Executed:select id FROM `nj` where city='Burlington' && SIC_code='7011'DB:business_master_new
loadtime:0.81026196479797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.81032085418701 / seconds
Query Executed:select id FROM `nj` where city='Butler' && SIC_code='7011'DB:business_master_new
loadtime:0.81557178497314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buttzville' limit 1
loadtime:0.81572794914246 / seconds
Query Executed:select id FROM `nj` where city='Buttzville' && SIC_code='7011'DB:business_master_new
loadtime:0.83047294616699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caldwell' limit 1
loadtime:0.83060884475708 / seconds
Query Executed:select id FROM `nj` where city='Caldwell' && SIC_code='7011'DB:business_master_new
loadtime:0.83596086502075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Califon' limit 1
loadtime:0.83600497245789 / seconds
Query Executed:select id FROM `nj` where city='Califon' && SIC_code='7011'DB:business_master_new
loadtime:0.83753395080566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.83758497238159 / seconds
Query Executed:select id FROM `nj` where city='Camden' && SIC_code='7011'DB:business_master_new
loadtime:0.84091377258301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May' limit 1
loadtime:0.84106588363647 / seconds
Query Executed:select id FROM `nj` where city='Cape May' && SIC_code='7011'DB:business_master_new
loadtime:0.91914081573486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Court House' limit 1
loadtime:0.91928386688232 / seconds
Query Executed:select id FROM `nj` where city='Cape May Court House' && SIC_code='7011'DB:business_master_new
loadtime:0.92554688453674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Ct Hse' limit 1
loadtime:0.92564296722412 / seconds
Query Executed:select id FROM `nj` where city='Cape May Ct Hse' && SIC_code='7011'DB:business_master_new
loadtime:0.97094178199768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Point' limit 1
loadtime:0.97097897529602 / seconds
Query Executed:select id FROM `nj` where city='Cape May Point' && SIC_code='7011'DB:business_master_new
loadtime:0.98850679397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlstadt' limit 1
loadtime:0.98856377601624 / seconds
Query Executed:select id FROM `nj` where city='Carlstadt' && SIC_code='7011'DB:business_master_new
loadtime:0.99243378639221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carneys Point' limit 1
loadtime:0.99255084991455 / seconds
Query Executed:select id FROM `nj` where city='Carneys Point' && SIC_code='7011'DB:business_master_new
loadtime:1.0057148933411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carteret' limit 1
loadtime:1.0057628154755 / seconds
Query Executed:select id FROM `nj` where city='Carteret' && SIC_code='7011'DB:business_master_new
loadtime:1.0102779865265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Brook' limit 1
loadtime:1.0104269981384 / seconds
Query Executed:select id FROM `nj` where city='Cedar Brook' && SIC_code='7011'DB:business_master_new
loadtime:1.0462698936462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:1.0463509559631 / seconds
Query Executed:select id FROM `nj` where city='Cedar Grove' && SIC_code='7011'DB:business_master_new
loadtime:1.0489008426666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Knolls' limit 1
loadtime:1.048999786377 / seconds
Query Executed:select id FROM `nj` where city='Cedar Knolls' && SIC_code='7011'DB:business_master_new
loadtime:1.0520589351654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:1.0521857738495 / seconds
Query Executed:select id FROM `nj` where city='Cedarville' && SIC_code='7011'DB:business_master_new
loadtime:1.1033749580383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Changewater' limit 1
loadtime:1.103423833847 / seconds
Query Executed:select id FROM `nj` where city='Changewater' && SIC_code='7011'DB:business_master_new
loadtime:1.1071479320526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.1071858406067 / seconds
Query Executed:select id FROM `nj` where city='Chatham' && SIC_code='7011'DB:business_master_new
loadtime:1.1093208789825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:1.1093559265137 / seconds
Query Executed:select id FROM `nj` where city='Chatsworth' && SIC_code='7011'DB:business_master_new
loadtime:1.1297209262848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Hill' limit 1
loadtime:1.1297709941864 / seconds
Query Executed:select id FROM `nj` where city='Cherry Hill' && SIC_code='7011'DB:business_master_new
loadtime:1.1414499282837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesilhurst' limit 1
loadtime:1.1415178775787 / seconds
Query Executed:select id FROM `nj` where city='Chesilhurst' && SIC_code='7011'DB:business_master_new
loadtime:1.143504858017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.1435558795929 / seconds
Query Executed:select id FROM `nj` where city='Chester' && SIC_code='7011'DB:business_master_new
loadtime:1.1451399326324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cinnaminson' limit 1
loadtime:1.1451869010925 / seconds
Query Executed:select id FROM `nj` where city='Cinnaminson' && SIC_code='7011'DB:business_master_new
loadtime:1.1735417842865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:1.173595905304 / seconds
Query Executed:select id FROM `nj` where city='Clark' && SIC_code='7011'DB:business_master_new
loadtime:1.1767358779907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksboro' limit 1
loadtime:1.1767919063568 / seconds
Query Executed:select id FROM `nj` where city='Clarksboro' && SIC_code='7011'DB:business_master_new
loadtime:1.2170469760895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:1.2170939445496 / seconds
Query Executed:select id FROM `nj` where city='Clarksburg' && SIC_code='7011'DB:business_master_new
loadtime:1.2232649326324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:1.2233138084412 / seconds
Query Executed:select id FROM `nj` where city='Clayton' && SIC_code='7011'DB:business_master_new
loadtime:1.2244939804077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clementon' limit 1
loadtime:1.2245428562164 / seconds
Query Executed:select id FROM `nj` where city='Clementon' && SIC_code='7011'DB:business_master_new
loadtime:1.2268929481506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside Park' limit 1
loadtime:1.226949930191 / seconds
Query Executed:select id FROM `nj` where city='Cliffside Park' && SIC_code='7011'DB:business_master_new
loadtime:1.2286088466644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffwood' limit 1
loadtime:1.2286558151245 / seconds
Query Executed:select id FROM `nj` where city='Cliffwood' && SIC_code='7011'DB:business_master_new
loadtime:1.2835369110107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.2835719585419 / seconds
Query Executed:select id FROM `nj` where city='Clifton' && SIC_code='7011'DB:business_master_new
loadtime:1.2895398139954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.2895998954773 / seconds
Query Executed:select id FROM `nj` where city='Clinton' && SIC_code='7011'DB:business_master_new
loadtime:1.2921268939972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Closter' limit 1
loadtime:1.2921829223633 / seconds
Query Executed:select id FROM `nj` where city='Closter' && SIC_code='7011'DB:business_master_new
loadtime:1.2936708927155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collingswood' limit 1
loadtime:1.2937178611755 / seconds
Query Executed:select id FROM `nj` where city='Collingswood' && SIC_code='7011'DB:business_master_new
loadtime:1.295599937439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:1.2956449985504 / seconds
Query Executed:select id FROM `nj` where city='Cologne' && SIC_code='7011'DB:business_master_new
loadtime:1.3335309028625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonia' limit 1
loadtime:1.3335909843445 / seconds
Query Executed:select id FROM `nj` where city='Colonia' && SIC_code='7011'DB:business_master_new
loadtime:1.3349637985229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colts Neck' limit 1
loadtime:1.3349997997284 / seconds
Query Executed:select id FROM `nj` where city='Colts Neck' && SIC_code='7011'DB:business_master_new
loadtime:1.3381857872009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:1.3382358551025 / seconds
Query Executed:select id FROM `nj` where city='Columbia' && SIC_code='7011'DB:business_master_new
loadtime:1.3404178619385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:1.3404607772827 / seconds
Query Executed:select id FROM `nj` where city='Columbus' && SIC_code='7011'DB:business_master_new
loadtime:1.3416907787323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Convent Station' limit 1
loadtime:1.3417167663574 / seconds
Query Executed:select id FROM `nj` where city='Convent Station' && SIC_code='7011'DB:business_master_new
loadtime:1.3582458496094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cookstown' limit 1
loadtime:1.3582949638367 / seconds
Query Executed:select id FROM `nj` where city='Cookstown' && SIC_code='7011'DB:business_master_new
loadtime:1.3822779655457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin City' limit 1
loadtime:1.3823328018188 / seconds
Query Executed:select id FROM `nj` where city='Corbin City' && SIC_code='7011'DB:business_master_new
loadtime:1.3838708400726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranbury' limit 1
loadtime:1.3839178085327 / seconds
Query Executed:select id FROM `nj` where city='Cranbury' && SIC_code='7011'DB:business_master_new
loadtime:1.3881068229675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranford' limit 1
loadtime:1.3881659507751 / seconds
Query Executed:select id FROM `nj` where city='Cranford' && SIC_code='7011'DB:business_master_new
loadtime:1.390321969986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cream Ridge' limit 1
loadtime:1.3903658390045 / seconds
Query Executed:select id FROM `nj` where city='Cream Ridge' && SIC_code='7011'DB:business_master_new
loadtime:1.3921029567719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creamridge' limit 1
loadtime:1.3921988010406 / seconds
Query Executed:select id FROM `nj` where city='Creamridge' && SIC_code='7011'DB:business_master_new
loadtime:1.3927829265594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresskill' limit 1
loadtime:1.39284491539 / seconds
Query Executed:select id FROM `nj` where city='Cresskill' && SIC_code='7011'DB:business_master_new
loadtime:1.3949508666992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosswicks' limit 1
loadtime:1.3950309753418 / seconds
Query Executed:select id FROM `nj` where city='Crosswicks' && SIC_code='7011'DB:business_master_new
loadtime:1.4010968208313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:1.4011428356171 / seconds
Query Executed:select id FROM `nj` where city='Dayton' && SIC_code='7011'DB:business_master_new
loadtime:1.4039340019226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deal' limit 1
loadtime:1.4039897918701 / seconds
Query Executed:select id FROM `nj` where city='Deal' && SIC_code='7011'DB:business_master_new
loadtime:1.4051349163055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deepwater' limit 1
loadtime:1.4051809310913 / seconds
Query Executed:select id FROM `nj` where city='Deepwater' && SIC_code='7011'DB:business_master_new
loadtime:1.4191889762878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield Street' limit 1
loadtime:1.4192698001862 / seconds
Query Executed:select id FROM `nj` where city='Deerfield Street' && SIC_code='7011'DB:business_master_new
loadtime:1.4311039447784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Del Haven' limit 1
loadtime:1.4311499595642 / seconds
Query Executed:select id FROM `nj` where city='Del Haven' && SIC_code='7011'DB:business_master_new
loadtime:1.4317269325256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delair' limit 1
loadtime:1.4317698478699 / seconds
Query Executed:select id FROM `nj` where city='Delair' && SIC_code='7011'DB:business_master_new
loadtime:1.4327399730682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delanco' limit 1
loadtime:1.4328019618988 / seconds
Query Executed:select id FROM `nj` where city='Delanco' && SIC_code='7011'DB:business_master_new
loadtime:1.4382047653198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:1.4382507801056 / seconds
Query Executed:select id FROM `nj` where city='Delaware' && SIC_code='7011'DB:business_master_new
loadtime:1.448853969574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:1.448903799057 / seconds
Query Executed:select id FROM `nj` where city='Delmont' && SIC_code='7011'DB:business_master_new
loadtime:1.4529769420624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delran' limit 1
loadtime:1.4530198574066 / seconds
Query Executed:select id FROM `nj` where city='Delran' && SIC_code='7011'DB:business_master_new
loadtime:1.4691557884216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Demarest' limit 1
loadtime:1.4691948890686 / seconds
Query Executed:select id FROM `nj` where city='Demarest' && SIC_code='7011'DB:business_master_new
loadtime:1.4703288078308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennisville' limit 1
loadtime:1.4703619480133 / seconds
Query Executed:select id FROM `nj` where city='Dennisville' && SIC_code='7011'DB:business_master_new
loadtime:1.4960298538208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denville' limit 1
loadtime:1.4960768222809 / seconds
Query Executed:select id FROM `nj` where city='Denville' && SIC_code='7011'DB:business_master_new
loadtime:1.498783826828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deptford' limit 1
loadtime:1.4988269805908 / seconds
Query Executed:select id FROM `nj` where city='Deptford' && SIC_code='7011'DB:business_master_new
loadtime:1.5455229282379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dividing Creek' limit 1
loadtime:1.5455877780914 / seconds
Query Executed:select id FROM `nj` where city='Dividing Creek' && SIC_code='7011'DB:business_master_new
loadtime:1.5508859157562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:1.5509448051453 / seconds
Query Executed:select id FROM `nj` where city='Dorchester' && SIC_code='7011'DB:business_master_new
loadtime:1.55832695961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorothy' limit 1
loadtime:1.558376789093 / seconds
Query Executed:select id FROM `nj` where city='Dorothy' && SIC_code='7011'DB:business_master_new
loadtime:1.591362953186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:1.59144282341 / seconds
Query Executed:select id FROM `nj` where city='Dover' && SIC_code='7011'DB:business_master_new
loadtime:1.5958919525146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:1.5959639549255 / seconds
Query Executed:select id FROM `nj` where city='Dumont' && SIC_code='7011'DB:business_master_new
loadtime:1.5989649295807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunellen' limit 1
loadtime:1.5990447998047 / seconds
Query Executed:select id FROM `nj` where city='Dunellen' && SIC_code='7011'DB:business_master_new
loadtime:1.6030209064484 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brunswick' limit 1
loadtime:1.6031148433685 / seconds
Query Executed:select id FROM `nj` where city='East Brunswick' && SIC_code='7011'DB:business_master_new
loadtime:1.6121199131012 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hanover' limit 1
loadtime:1.6122219562531 / seconds
Query Executed:select id FROM `nj` where city='East Hanover' && SIC_code='7011'DB:business_master_new
loadtime:1.6177008152008 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Millstone' limit 1
loadtime:1.6177568435669 / seconds
Query Executed:select id FROM `nj` where city='East Millstone' && SIC_code='7011'DB:business_master_new
loadtime:1.619616985321 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Newark' limit 1
loadtime:1.6196517944336 / seconds
Query Executed:select id FROM `nj` where city='East Newark' && SIC_code='7011'DB:business_master_new
loadtime:1.620857000351 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:1.6209049224854 / seconds
Query Executed:select id FROM `nj` where city='East Orange' && SIC_code='7011'DB:business_master_new
loadtime:1.6272609233856 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Rutherford' limit 1
loadtime:1.6273169517517 / seconds
Query Executed:select id FROM `nj` where city='East Rutherford' && SIC_code='7011'DB:business_master_new
loadtime:1.6322848796844 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:1.6323328018188 / seconds
Query Executed:select id FROM `nj` where city='East Windsor' && SIC_code='7011'DB:business_master_new
loadtime:1.642951965332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eatontown' limit 1
loadtime:1.6430327892303 / seconds
Query Executed:select id FROM `nj` where city='Eatontown' && SIC_code='7011'DB:business_master_new
loadtime:1.6527459621429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:1.6528518199921 / seconds
Query Executed:select id FROM `nj` where city='Edgewater' && SIC_code='7011'DB:business_master_new
loadtime:1.6565568447113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater Park' limit 1
loadtime:1.6566388607025 / seconds
Query Executed:select id FROM `nj` where city='Edgewater Park' && SIC_code='7011'DB:business_master_new
loadtime:1.6605629920959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edison' limit 1
loadtime:1.6606328487396 / seconds
Query Executed:select id FROM `nj` where city='Edison' && SIC_code='7011'DB:business_master_new
loadtime:1.6755828857422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor City' limit 1
loadtime:1.6756358146667 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor City' && SIC_code='7011'DB:business_master_new
loadtime:1.6789019107819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor Township' limit 1
loadtime:1.6789908409119 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor Township' && SIC_code='7011'DB:business_master_new
loadtime:1.6899628639221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor Twp' limit 1
loadtime:1.6900169849396 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor Twp' && SIC_code='7011'DB:business_master_new
loadtime:1.7406599521637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:1.7407078742981 / seconds
Query Executed:select id FROM `nj` where city='Elizabeth' && SIC_code='7011'DB:business_master_new
loadtime:1.7516918182373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmer' limit 1
loadtime:1.7517499923706 / seconds
Query Executed:select id FROM `nj` where city='Elmer' && SIC_code='7011'DB:business_master_new
loadtime:1.7531409263611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood Park' limit 1
loadtime:1.7531898021698 / seconds
Query Executed:select id FROM `nj` where city='Elmwood Park' && SIC_code='7011'DB:business_master_new
loadtime:1.7557818889618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:1.7558379173279 / seconds
Query Executed:select id FROM `nj` where city='Elwood' && SIC_code='7011'DB:business_master_new
loadtime:1.7744998931885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:1.7745859622955 / seconds
Query Executed:select id FROM `nj` where city='Emerson' && SIC_code='7011'DB:business_master_new
loadtime:1.7768428325653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:1.7769048213959 / seconds
Query Executed:select id FROM `nj` where city='Englewood' && SIC_code='7011'DB:business_master_new
loadtime:1.7818109989166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood Cliffs' limit 1
loadtime:1.7818667888641 / seconds
Query Executed:select id FROM `nj` where city='Englewood Cliffs' && SIC_code='7011'DB:business_master_new
loadtime:1.7840368747711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englishtown' limit 1
loadtime:1.7840797901154 / seconds
Query Executed:select id FROM `nj` where city='Englishtown' && SIC_code='7011'DB:business_master_new
loadtime:1.7874858379364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Fells' limit 1
loadtime:1.7875428199768 / seconds
Query Executed:select id FROM `nj` where city='Essex Fells' && SIC_code='7011'DB:business_master_new
loadtime:1.8260819911957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estell Manor' limit 1
loadtime:1.8261289596558 / seconds
Query Executed:select id FROM `nj` where city='Estell Manor' && SIC_code='7011'DB:business_master_new
loadtime:1.8494789600372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewan' limit 1
loadtime:1.8495879173279 / seconds
Query Executed:select id FROM `nj` where city='Ewan' && SIC_code='7011'DB:business_master_new
loadtime:1.8560588359833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:1.8561058044434 / seconds
Query Executed:select id FROM `nj` where city='Fair Haven' && SIC_code='7011'DB:business_master_new
loadtime:1.857391834259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Lawn' limit 1
loadtime:1.8574388027191 / seconds
Query Executed:select id FROM `nj` where city='Fair Lawn' && SIC_code='7011'DB:business_master_new
loadtime:1.8607068061829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.8607618808746 / seconds
Query Executed:select id FROM `nj` where city='Fairfield' && SIC_code='7011'DB:business_master_new
loadtime:1.8699338436127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairton' limit 1
loadtime:1.8699989318848 / seconds
Query Executed:select id FROM `nj` where city='Fairton' && SIC_code='7011'DB:business_master_new
loadtime:1.8901338577271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.8901708126068 / seconds
Query Executed:select id FROM `nj` where city='Fairview' && SIC_code='7011'DB:business_master_new
loadtime:1.8916277885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fanwood' limit 1
loadtime:1.891676902771 / seconds
Query Executed:select id FROM `nj` where city='Fanwood' && SIC_code='7011'DB:business_master_new
loadtime:1.8929448127747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Far Hills' limit 1
loadtime:1.8929917812347 / seconds
Query Executed:select id FROM `nj` where city='Far Hills' && SIC_code='7011'DB:business_master_new
loadtime:1.8941569328308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmingdale' limit 1
loadtime:1.8941929340363 / seconds
Query Executed:select id FROM `nj` where city='Farmingdale' && SIC_code='7011'DB:business_master_new
loadtime:1.8974628448486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldsboro' limit 1
loadtime:1.8975298404694 / seconds
Query Executed:select id FROM `nj` where city='Fieldsboro' && SIC_code='7011'DB:business_master_new
loadtime:1.8980867862701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagtown' limit 1
loadtime:1.8981249332428 / seconds
Query Executed:select id FROM `nj` where city='Flagtown' && SIC_code='7011'DB:business_master_new
loadtime:1.9083709716797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flanders' limit 1
loadtime:1.908499956131 / seconds
Query Executed:select id FROM `nj` where city='Flanders' && SIC_code='7011'DB:business_master_new
loadtime:1.9111988544464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flemington' limit 1
loadtime:1.9112539291382 / seconds
Query Executed:select id FROM `nj` where city='Flemington' && SIC_code='7011'DB:business_master_new
loadtime:1.9168789386749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.9169578552246 / seconds
Query Executed:select id FROM `nj` where city='Florence' && SIC_code='7011'DB:business_master_new
loadtime:1.9191079139709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florham Park' limit 1
loadtime:1.9191517829895 / seconds
Query Executed:select id FROM `nj` where city='Florham Park' && SIC_code='7011'DB:business_master_new
loadtime:1.9224779605865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fords' limit 1
loadtime:1.9225339889526 / seconds
Query Executed:select id FROM `nj` where city='Fords' && SIC_code='7011'DB:business_master_new
loadtime:1.9238059520721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forked River' limit 1
loadtime:1.9238409996033 / seconds
Query Executed:select id FROM `nj` where city='Forked River' && SIC_code='7011'DB:business_master_new
loadtime:1.9274129867554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dix' limit 1
loadtime:1.9274678230286 / seconds
Query Executed:select id FROM `nj` where city='Fort Dix' && SIC_code='7011'DB:business_master_new
loadtime:1.9562239646912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Hancock' limit 1
loadtime:1.9562799930573 / seconds
Query Executed:select id FROM `nj` where city='Fort Hancock' && SIC_code='7011'DB:business_master_new
loadtime:1.9575479030609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:1.9575967788696 / seconds
Query Executed:select id FROM `nj` where city='Fort Lee' && SIC_code='7011'DB:business_master_new
loadtime:1.9673337936401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monmouth' limit 1
loadtime:1.9673969745636 / seconds
Query Executed:select id FROM `nj` where city='Fort Monmouth' && SIC_code='7011'DB:business_master_new
loadtime:1.9981417655945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fortescue' limit 1
loadtime:1.9982929229736 / seconds
Query Executed:select id FROM `nj` where city='Fortescue' && SIC_code='7011'DB:business_master_new
loadtime:2.0115578174591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.0116548538208 / seconds
Query Executed:select id FROM `nj` where city='Franklin' && SIC_code='7011'DB:business_master_new
loadtime:2.016016960144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin Lakes' limit 1
loadtime:2.0160729885101 / seconds
Query Executed:select id FROM `nj` where city='Franklin Lakes' && SIC_code='7011'DB:business_master_new
loadtime:2.0183088779449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin Park' limit 1
loadtime:2.018364906311 / seconds
Query Executed:select id FROM `nj` where city='Franklin Park' && SIC_code='7011'DB:business_master_new
loadtime:2.019565820694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:2.0196127891541 / seconds
Query Executed:select id FROM `nj` where city='Franklinville' && SIC_code='7011'DB:business_master_new
loadtime:2.0209119319916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredon' limit 1
loadtime:2.0209608078003 / seconds
Query Executed:select id FROM `nj` where city='Fredon' && SIC_code='7011'DB:business_master_new
loadtime:2.0239639282227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freehold' limit 1
loadtime:2.0240108966827 / seconds
Query Executed:select id FROM `nj` where city='Freehold' && SIC_code='7011'DB:business_master_new
loadtime:2.0297088623047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frenchtown' limit 1
loadtime:2.0297667980194 / seconds
Query Executed:select id FROM `nj` where city='Frenchtown' && SIC_code='7011'DB:business_master_new
loadtime:2.0327019691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:2.0327467918396 / seconds
Query Executed:select id FROM `nj` where city='Galloway' && SIC_code='7011'DB:business_master_new
loadtime:2.04314494133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:2.0431988239288 / seconds
Query Executed:select id FROM `nj` where city='Garfield' && SIC_code='7011'DB:business_master_new
loadtime:2.0451989173889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwood' limit 1
loadtime:2.0452527999878 / seconds
Query Executed:select id FROM `nj` where city='Garwood' && SIC_code='7011'DB:business_master_new
loadtime:2.0464999675751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibbsboro' limit 1
loadtime:2.0465347766876 / seconds
Query Executed:select id FROM `nj` where city='Gibbsboro' && SIC_code='7011'DB:business_master_new
loadtime:2.0477249622345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibbstown' limit 1
loadtime:2.0477728843689 / seconds
Query Executed:select id FROM `nj` where city='Gibbstown' && SIC_code='7011'DB:business_master_new
loadtime:2.0495779514313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillette' limit 1
loadtime:2.049635887146 / seconds
Query Executed:select id FROM `nj` where city='Gillette' && SIC_code='7011'DB:business_master_new
loadtime:2.0507988929749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:2.0508489608765 / seconds
Query Executed:select id FROM `nj` where city='Gladstone' && SIC_code='7011'DB:business_master_new
loadtime:2.1037399768829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glassboro' limit 1
loadtime:2.103786945343 / seconds
Query Executed:select id FROM `nj` where city='Glassboro' && SIC_code='7011'DB:business_master_new
loadtime:2.1057658195496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasser' limit 1
loadtime:2.1058328151703 / seconds
Query Executed:select id FROM `nj` where city='Glasser' && SIC_code='7011'DB:business_master_new
loadtime:2.1083707809448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Gardner' limit 1
loadtime:2.1084208488464 / seconds
Query Executed:select id FROM `nj` where city='Glen Gardner' && SIC_code='7011'DB:business_master_new
loadtime:2.1096549034119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Ridge' limit 1
loadtime:2.1097018718719 / seconds
Query Executed:select id FROM `nj` where city='Glen Ridge' && SIC_code='7011'DB:business_master_new
loadtime:2.110916852951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Rock' limit 1
loadtime:2.1109747886658 / seconds
Query Executed:select id FROM `nj` where city='Glen Rock' && SIC_code='7011'DB:business_master_new
loadtime:2.1124119758606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:2.1124467849731 / seconds
Query Executed:select id FROM `nj` where city='Glendora' && SIC_code='7011'DB:business_master_new
loadtime:2.1136288642883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:2.1136748790741 / seconds
Query Executed:select id FROM `nj` where city='Glenwood' && SIC_code='7011'DB:business_master_new
loadtime:2.1409997940063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester City' limit 1
loadtime:2.1410558223724 / seconds
Query Executed:select id FROM `nj` where city='Gloucester City' && SIC_code='7011'DB:business_master_new
loadtime:2.146791934967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:2.1468508243561 / seconds
Query Executed:select id FROM `nj` where city='Goshen' && SIC_code='7011'DB:business_master_new
loadtime:2.1555888652802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Meadows' limit 1
loadtime:2.1556398868561 / seconds
Query Executed:select id FROM `nj` where city='Great Meadows' && SIC_code='7011'DB:business_master_new
loadtime:2.1584057807922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Brook' limit 1
loadtime:2.1584498882294 / seconds
Query Executed:select id FROM `nj` where city='Green Brook' && SIC_code='7011'DB:business_master_new
loadtime:2.1686987876892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Creek' limit 1
loadtime:2.1687459945679 / seconds
Query Executed:select id FROM `nj` where city='Green Creek' && SIC_code='7011'DB:business_master_new
loadtime:2.1895139217377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Village' limit 1
loadtime:2.1895699501038 / seconds
Query Executed:select id FROM `nj` where city='Green Village' && SIC_code='7011'DB:business_master_new
loadtime:2.213045835495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greendell' limit 1
loadtime:2.2131037712097 / seconds
Query Executed:select id FROM `nj` where city='Greendell' && SIC_code='7011'DB:business_master_new
loadtime:2.2225999832153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:2.2226459980011 / seconds
Query Executed:select id FROM `nj` where city='Greenwich' && SIC_code='7011'DB:business_master_new
loadtime:2.2436349391937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenloch' limit 1
loadtime:2.2436897754669 / seconds
Query Executed:select id FROM `nj` where city='Grenloch' && SIC_code='7011'DB:business_master_new
loadtime:2.2488248348236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greystone Park' limit 1
loadtime:2.2488708496094 / seconds
Query Executed:select id FROM `nj` where city='Greystone Park' && SIC_code='7011'DB:business_master_new
loadtime:2.2504649162292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:2.2505128383636 / seconds
Query Executed:select id FROM `nj` where city='Guttenberg' && SIC_code='7011'DB:business_master_new
loadtime:2.2543299198151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackensack' limit 1
loadtime:2.2543778419495 / seconds
Query Executed:select id FROM `nj` where city='Hackensack' && SIC_code='7011'DB:business_master_new
loadtime:2.2602248191833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackettstown' limit 1
loadtime:2.2602708339691 / seconds
Query Executed:select id FROM `nj` where city='Hackettstown' && SIC_code='7011'DB:business_master_new
loadtime:2.2637519836426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddon Heights' limit 1
loadtime:2.2638077735901 / seconds
Query Executed:select id FROM `nj` where city='Haddon Heights' && SIC_code='7011'DB:business_master_new
loadtime:2.2651619911194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddon Twp' limit 1
loadtime:2.2651979923248 / seconds
Query Executed:select id FROM `nj` where city='Haddon Twp' && SIC_code='7011'DB:business_master_new
loadtime:2.268278837204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddonfield' limit 1
loadtime:2.2683258056641 / seconds
Query Executed:select id FROM `nj` where city='Haddonfield' && SIC_code='7011'DB:business_master_new
loadtime:2.270623922348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hainesport' limit 1
loadtime:2.2706668376923 / seconds
Query Executed:select id FROM `nj` where city='Hainesport' && SIC_code='7011'DB:business_master_new
loadtime:2.272323846817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haledon' limit 1
loadtime:2.2723789215088 / seconds
Query Executed:select id FROM `nj` where city='Haledon' && SIC_code='7011'DB:business_master_new
loadtime:2.2739567756653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:2.274002790451 / seconds
Query Executed:select id FROM `nj` where city='Hamburg' && SIC_code='7011'DB:business_master_new
loadtime:2.2764167785645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammonton' limit 1
loadtime:2.2764718532562 / seconds
Query Executed:select id FROM `nj` where city='Hammonton' && SIC_code='7011'DB:business_master_new
loadtime:2.2817249298096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:2.281772851944 / seconds
Query Executed:select id FROM `nj` where city='Hampton' && SIC_code='7011'DB:business_master_new
loadtime:2.2835388183594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancocks Bridge' limit 1
loadtime:2.2835948467255 / seconds
Query Executed:select id FROM `nj` where city='Hancocks Bridge' && SIC_code='7011'DB:business_master_new
loadtime:2.2953579425812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:2.2954039573669 / seconds
Query Executed:select id FROM `nj` where city='Hardwick' && SIC_code='7011'DB:business_master_new
loadtime:2.2957379817963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrington Park' limit 1
loadtime:2.2957808971405 / seconds
Query Executed:select id FROM `nj` where city='Harrington Park' && SIC_code='7011'DB:business_master_new
loadtime:2.2969679832458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:2.2970149517059 / seconds
Query Executed:select id FROM `nj` where city='Harrison' && SIC_code='7011'DB:business_master_new
loadtime:2.2990589141846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonville' limit 1
loadtime:2.2991008758545 / seconds
Query Executed:select id FROM `nj` where city='Harrisonville' && SIC_code='7011'DB:business_master_new
loadtime:2.3091239929199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey Cedars' limit 1
loadtime:2.3091747760773 / seconds
Query Executed:select id FROM `nj` where city='Harvey Cedars' && SIC_code='7011'DB:business_master_new
loadtime:2.3129057884216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasbrouck Heights' limit 1
loadtime:2.3129558563232 / seconds
Query Executed:select id FROM `nj` where city='Hasbrouck Heights' && SIC_code='7011'DB:business_master_new
loadtime:2.3157198429108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasbrouck Hts' limit 1
loadtime:2.3157827854156 / seconds
Query Executed:select id FROM `nj` where city='Hasbrouck Hts' && SIC_code='7011'DB:business_master_new
loadtime:2.3305308818817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haskell' limit 1
loadtime:2.330579996109 / seconds
Query Executed:select id FROM `nj` where city='Haskell' && SIC_code='7011'DB:business_master_new
loadtime:2.3317258358002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haworth' limit 1
loadtime:2.3317728042603 / seconds
Query Executed:select id FROM `nj` where city='Haworth' && SIC_code='7011'DB:business_master_new
loadtime:2.3329458236694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawthorne' limit 1
loadtime:2.3329927921295 / seconds
Query Executed:select id FROM `nj` where city='Hawthorne' && SIC_code='7011'DB:business_master_new
loadtime:2.3350069522858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlet' limit 1
loadtime:2.3350608348846 / seconds
Query Executed:select id FROM `nj` where city='Hazlet' && SIC_code='7011'DB:business_master_new
loadtime:2.3394827842712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heislerville' limit 1
loadtime:2.3395397663116 / seconds
Query Executed:select id FROM `nj` where city='Heislerville' && SIC_code='7011'DB:business_master_new
loadtime:2.3458797931671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helmetta' limit 1
loadtime:2.3459408283234 / seconds
Query Executed:select id FROM `nj` where city='Helmetta' && SIC_code='7011'DB:business_master_new
loadtime:2.3673379421234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewitt' limit 1
loadtime:2.3673839569092 / seconds
Query Executed:select id FROM `nj` where city='Hewitt' && SIC_code='7011'DB:business_master_new
loadtime:2.3691799640656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hibernia' limit 1
loadtime:2.3692338466644 / seconds
Query Executed:select id FROM `nj` where city='Hibernia' && SIC_code='7011'DB:business_master_new
loadtime:2.3813679218292 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Bridge' limit 1
loadtime:2.3814039230347 / seconds
Query Executed:select id FROM `nj` where city='High Bridge' && SIC_code='7011'DB:business_master_new
loadtime:2.3825838565826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Lakes' limit 1
loadtime:2.3826308250427 / seconds
Query Executed:select id FROM `nj` where city='Highland Lakes' && SIC_code='7011'DB:business_master_new
loadtime:2.3837997913361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:2.3838498592377 / seconds
Query Executed:select id FROM `nj` where city='Highland Park' && SIC_code='7011'DB:business_master_new
loadtime:2.3853478431702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:2.3854019641876 / seconds
Query Executed:select id FROM `nj` where city='Highlands' && SIC_code='7011'DB:business_master_new
loadtime:2.388011932373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightstown' limit 1
loadtime:2.3880569934845 / seconds
Query Executed:select id FROM `nj` where city='Hightstown' && SIC_code='7011'DB:business_master_new
loadtime:2.3949019908905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:2.3949749469757 / seconds
Query Executed:select id FROM `nj` where city='Hillsborough' && SIC_code='7011'DB:business_master_new
loadtime:2.3984577655792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:2.3985137939453 / seconds
Query Executed:select id FROM `nj` where city='Hillsdale' && SIC_code='7011'DB:business_master_new
loadtime:2.3998889923096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillside' limit 1
loadtime:2.3999509811401 / seconds
Query Executed:select id FROM `nj` where city='Hillside' && SIC_code='7011'DB:business_master_new
loadtime:2.4015469551086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ho Ho Kus' limit 1
loadtime:2.4015817642212 / seconds
Query Executed:select id FROM `nj` where city='Ho Ho Kus' && SIC_code='7011'DB:business_master_new
loadtime:2.402813911438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoboken' limit 1
loadtime:2.4028599262238 / seconds
Query Executed:select id FROM `nj` where city='Hoboken' && SIC_code='7011'DB:business_master_new
loadtime:2.4054789543152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holmdel' limit 1
loadtime:2.4055328369141 / seconds
Query Executed:select id FROM `nj` where city='Holmdel' && SIC_code='7011'DB:business_master_new
loadtime:2.4080259799957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopatcong' limit 1
loadtime:2.4080817699432 / seconds
Query Executed:select id FROM `nj` where city='Hopatcong' && SIC_code='7011'DB:business_master_new
loadtime:2.4093418121338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:2.4093959331512 / seconds
Query Executed:select id FROM `nj` where city='Hope' && SIC_code='7011'DB:business_master_new
loadtime:2.4583129882812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:2.4583687782288 / seconds
Query Executed:select id FROM `nj` where city='Hopewell' && SIC_code='7011'DB:business_master_new
loadtime:2.4605588912964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:2.4606058597565 / seconds
Query Executed:select id FROM `nj` where city='Howell' && SIC_code='7011'DB:business_master_new
loadtime:2.4648938179016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlaystown' limit 1
loadtime:2.4649529457092 / seconds
Query Executed:select id FROM `nj` where city='Imlaystown' && SIC_code='7011'DB:business_master_new
loadtime:2.4697389602661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlaken' limit 1
loadtime:2.4697878360748 / seconds
Query Executed:select id FROM `nj` where city='Interlaken' && SIC_code='7011'DB:business_master_new
loadtime:2.4700899124146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironia' limit 1
loadtime:2.4701278209686 / seconds
Query Executed:select id FROM `nj` where city='Ironia' && SIC_code='7011'DB:business_master_new
loadtime:2.4900858402252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:2.4901328086853 / seconds
Query Executed:select id FROM `nj` where city='Irvington' && SIC_code='7011'DB:business_master_new
loadtime:2.4944257736206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iselin' limit 1
loadtime:2.4944839477539 / seconds
Query Executed:select id FROM `nj` where city='Iselin' && SIC_code='7011'DB:business_master_new
loadtime:2.4992549419403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Heights' limit 1
loadtime:2.4993138313293 / seconds
Query Executed:select id FROM `nj` where city='Island Heights' && SIC_code='7011'DB:business_master_new
loadtime:2.5681087970734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:2.5681967735291 / seconds
Query Executed:select id FROM `nj` where city='Jackson' && SIC_code='7011'DB:business_master_new
loadtime:2.5712897777557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesburg' limit 1
loadtime:2.5713379383087 / seconds
Query Executed:select id FROM `nj` where city='Jamesburg' && SIC_code='7011'DB:business_master_new
loadtime:2.5731329917908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey City' limit 1
loadtime:2.5731689929962 / seconds
Query Executed:select id FROM `nj` where city='Jersey City' && SIC_code='7011'DB:business_master_new
loadtime:2.5864629745483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jobstown' limit 1
loadtime:2.5865299701691 / seconds
Query Executed:select id FROM `nj` where city='Jobstown' && SIC_code='7011'DB:business_master_new
loadtime:2.6093778610229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonburg' limit 1
loadtime:2.6094369888306 / seconds
Query Executed:select id FROM `nj` where city='Johnsonburg' && SIC_code='7011'DB:business_master_new
loadtime:2.6185109615326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juliustown' limit 1
loadtime:2.618558883667 / seconds
Query Executed:select id FROM `nj` where city='Juliustown' && SIC_code='7011'DB:business_master_new
loadtime:2.6266329288483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keansburg' limit 1
loadtime:2.6266798973083 / seconds
Query Executed:select id FROM `nj` where city='Keansburg' && SIC_code='7011'DB:business_master_new
loadtime:2.6292309761047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:2.6292867660522 / seconds
Query Executed:select id FROM `nj` where city='Kearny' && SIC_code='7011'DB:business_master_new
loadtime:2.6319599151611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keasbey' limit 1
loadtime:2.6320178508759 / seconds
Query Executed:select id FROM `nj` where city='Keasbey' && SIC_code='7011'DB:business_master_new
loadtime:2.6653308868408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall Park' limit 1
loadtime:2.6653800010681 / seconds
Query Executed:select id FROM `nj` where city='Kendall Park' && SIC_code='7011'DB:business_master_new
loadtime:2.6667039394379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:2.6667509078979 / seconds
Query Executed:select id FROM `nj` where city='Kenilworth' && SIC_code='7011'DB:business_master_new
loadtime:2.6698019504547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenvil' limit 1
loadtime:2.6698458194733 / seconds
Query Executed:select id FROM `nj` where city='Kenvil' && SIC_code='7011'DB:business_master_new
loadtime:2.671728849411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keyport' limit 1
loadtime:2.6717829704285 / seconds
Query Executed:select id FROM `nj` where city='Keyport' && SIC_code='7011'DB:business_master_new
loadtime:2.6733548641205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:2.6733908653259 / seconds
Query Executed:select id FROM `nj` where city='Kingston' && SIC_code='7011'DB:business_master_new
loadtime:2.7180857658386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinnelon' limit 1
loadtime:2.7181217670441 / seconds
Query Executed:select id FROM `nj` where city='Kinnelon' && SIC_code='7011'DB:business_master_new
loadtime:2.7271568775177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:2.7272038459778 / seconds
Query Executed:select id FROM `nj` where city='Lafayette' && SIC_code='7011'DB:business_master_new
loadtime:2.729749917984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Hiawatha' limit 1
loadtime:2.7298028469086 / seconds
Query Executed:select id FROM `nj` where city='Lake Hiawatha' && SIC_code='7011'DB:business_master_new
loadtime:2.7322218418121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Hopatcong' limit 1
loadtime:2.7322688102722 / seconds
Query Executed:select id FROM `nj` where city='Lake Hopatcong' && SIC_code='7011'DB:business_master_new
loadtime:2.7343888282776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakehurst' limit 1
loadtime:2.7344448566437 / seconds
Query Executed:select id FROM `nj` where city='Lakehurst' && SIC_code='7011'DB:business_master_new
loadtime:2.7370998859406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:2.7371468544006 / seconds
Query Executed:select id FROM `nj` where city='Lakewood' && SIC_code='7011'DB:business_master_new
loadtime:2.7440497875214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:2.7441098690033 / seconds
Query Executed:select id FROM `nj` where city='Lambertville' && SIC_code='7011'DB:business_master_new
loadtime:2.7477598190308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landing' limit 1
loadtime:2.747829914093 / seconds
Query Executed:select id FROM `nj` where city='Landing' && SIC_code='7011'DB:business_master_new
loadtime:2.7490758895874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landisville' limit 1
loadtime:2.7491118907928 / seconds
Query Executed:select id FROM `nj` where city='Landisville' && SIC_code='7011'DB:business_master_new
loadtime:2.7782738208771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanoka Harbor' limit 1
loadtime:2.7783238887787 / seconds
Query Executed:select id FROM `nj` where city='Lanoka Harbor' && SIC_code='7011'DB:business_master_new
loadtime:2.781124830246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:2.781219959259 / seconds
Query Executed:select id FROM `nj` where city='Laurel Springs' && SIC_code='7011'DB:business_master_new
loadtime:2.7952558994293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurence Harbor' limit 1
loadtime:2.795304775238 / seconds
Query Executed:select id FROM `nj` where city='Laurence Harbor' && SIC_code='7011'DB:business_master_new
loadtime:2.8046288490295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lavallette' limit 1
loadtime:2.8046779632568 / seconds
Query Executed:select id FROM `nj` where city='Lavallette' && SIC_code='7011'DB:business_master_new
loadtime:2.8075678348541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawnside' limit 1
loadtime:2.8076128959656 / seconds
Query Executed:select id FROM `nj` where city='Lawnside' && SIC_code='7011'DB:business_master_new
loadtime:2.8534579277039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:2.8535158634186 / seconds
Query Executed:select id FROM `nj` where city='Lawrenceville' && SIC_code='7011'DB:business_master_new
loadtime:2.8547239303589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:2.8547599315643 / seconds
Query Executed:select id FROM `nj` where city='Layton' && SIC_code='7011'DB:business_master_new
loadtime:2.8700687885284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:2.8701188564301 / seconds
Query Executed:select id FROM `nj` where city='Lebanon' && SIC_code='7011'DB:business_master_new
loadtime:2.8723108768463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledgewood' limit 1
loadtime:2.8723559379578 / seconds
Query Executed:select id FROM `nj` where city='Ledgewood' && SIC_code='7011'DB:business_master_new
loadtime:2.8751618862152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds Point' limit 1
loadtime:2.8753199577332 / seconds
Query Executed:select id FROM `nj` where city='Leeds Point' && SIC_code='7011'DB:business_master_new
loadtime:2.8815939426422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:2.8816418647766 / seconds
Query Executed:select id FROM `nj` where city='Leesburg' && SIC_code='7011'DB:business_master_new
loadtime:2.8952288627625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonardo' limit 1
loadtime:2.8953628540039 / seconds
Query Executed:select id FROM `nj` where city='Leonardo' && SIC_code='7011'DB:business_master_new
loadtime:2.897665977478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonia' limit 1
loadtime:2.8977079391479 / seconds
Query Executed:select id FROM `nj` where city='Leonia' && SIC_code='7011'DB:business_master_new
loadtime:2.8994247913361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Corner' limit 1
loadtime:2.8994789123535 / seconds
Query Executed:select id FROM `nj` where city='Liberty Corner' && SIC_code='7011'DB:business_master_new
loadtime:2.9411318302155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:2.9411799907684 / seconds
Query Executed:select id FROM `nj` where city='Lincoln Park' && SIC_code='7011'DB:business_master_new
loadtime:2.9425179958344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincroft' limit 1
loadtime:2.9425649642944 / seconds
Query Executed:select id FROM `nj` where city='Lincroft' && SIC_code='7011'DB:business_master_new
loadtime:2.9438149929047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:2.9438629150391 / seconds
Query Executed:select id FROM `nj` where city='Linden' && SIC_code='7011'DB:business_master_new
loadtime:2.9483327865601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindenwold' limit 1
loadtime:2.9483897686005 / seconds
Query Executed:select id FROM `nj` where city='Lindenwold' && SIC_code='7011'DB:business_master_new
loadtime:2.9573149681091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:2.9573509693146 / seconds
Query Executed:select id FROM `nj` where city='Linwood' && SIC_code='7011'DB:business_master_new
loadtime:2.959018945694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Egg Hbr' limit 1
loadtime:2.9590759277344 / seconds
Query Executed:select id FROM `nj` where city='Little Egg Hbr' && SIC_code='7011'DB:business_master_new
loadtime:2.9621469974518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Falls' limit 1
loadtime:2.9621829986572 / seconds
Query Executed:select id FROM `nj` where city='Little Falls' && SIC_code='7011'DB:business_master_new
loadtime:2.9648008346558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Ferry' limit 1
loadtime:2.9648637771606 / seconds
Query Executed:select id FROM `nj` where city='Little Ferry' && SIC_code='7011'DB:business_master_new
loadtime:2.9671487808228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Silver' limit 1
loadtime:2.9672048091888 / seconds
Query Executed:select id FROM `nj` where city='Little Silver' && SIC_code='7011'DB:business_master_new
loadtime:2.9685468673706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little York' limit 1
loadtime:2.968582868576 / seconds
Query Executed:select id FROM `nj` where city='Little York' && SIC_code='7011'DB:business_master_new
loadtime:2.9706339836121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:2.9706838130951 / seconds
Query Executed:select id FROM `nj` where city='Livingston' && SIC_code='7011'DB:business_master_new
loadtime:2.9751148223877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodi' limit 1
loadtime:2.975172996521 / seconds
Query Executed:select id FROM `nj` where city='Lodi' && SIC_code='7011'DB:business_master_new
loadtime:2.9768009185791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:2.9768488407135 / seconds
Query Executed:select id FROM `nj` where city='Long Beach' && SIC_code='7011'DB:business_master_new
loadtime:2.9783189296722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach Twp' limit 1
loadtime:2.9783658981323 / seconds
Query Executed:select id FROM `nj` where city='Long Beach Twp' && SIC_code='7011'DB:business_master_new
loadtime:2.9801058769226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Branch' limit 1
loadtime:2.9801609516144 / seconds
Query Executed:select id FROM `nj` where city='Long Branch' && SIC_code='7011'DB:business_master_new
loadtime:2.985613822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:2.9856729507446 / seconds
Query Executed:select id FROM `nj` where city='Long Valley' && SIC_code='7011'DB:business_master_new
loadtime:2.9870619773865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longport' limit 1
loadtime:2.9871048927307 / seconds
Query Executed:select id FROM `nj` where city='Longport' && SIC_code='7011'DB:business_master_new
loadtime:3.0236639976501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:3.0237119197845 / seconds
Query Executed:select id FROM `nj` where city='Lumberton' && SIC_code='7011'DB:business_master_new
loadtime:3.0255918502808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:3.025634765625 / seconds
Query Executed:select id FROM `nj` where city='Lyndhurst' && SIC_code='7011'DB:business_master_new
loadtime:3.0309588909149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:3.0310039520264 / seconds
Query Executed:select id FROM `nj` where city='Lyons' && SIC_code='7011'DB:business_master_new
loadtime:3.0359029769897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:3.0359618663788 / seconds
Query Executed:select id FROM `nj` where city='Madison' && SIC_code='7011'DB:business_master_new
loadtime:3.0378937721252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:3.0379638671875 / seconds
Query Executed:select id FROM `nj` where city='Magnolia' && SIC_code='7011'DB:business_master_new
loadtime:3.0392179489136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mahwah' limit 1
loadtime:3.0392649173737 / seconds
Query Executed:select id FROM `nj` where city='Mahwah' && SIC_code='7011'DB:business_master_new
loadtime:3.0462827682495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:3.0463449954987 / seconds
Query Executed:select id FROM `nj` where city='Malaga' && SIC_code='7011'DB:business_master_new
loadtime:3.0852489471436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manahawkin' limit 1
loadtime:3.0853099822998 / seconds
Query Executed:select id FROM `nj` where city='Manahawkin' && SIC_code='7011'DB:business_master_new
loadtime:3.0889818668365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manalapan' limit 1
loadtime:3.089136838913 / seconds
Query Executed:select id FROM `nj` where city='Manalapan' && SIC_code='7011'DB:business_master_new
loadtime:3.1472568511963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manasquan' limit 1
loadtime:3.1473047733307 / seconds
Query Executed:select id FROM `nj` where city='Manasquan' && SIC_code='7011'DB:business_master_new
loadtime:3.1525588035583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:3.1527187824249 / seconds
Query Executed:select id FROM `nj` where city='Manchester' && SIC_code='7011'DB:business_master_new
loadtime:3.1609499454498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Township' limit 1
loadtime:3.1609978675842 / seconds
Query Executed:select id FROM `nj` where city='Manchester Township' && SIC_code='7011'DB:business_master_new
loadtime:3.1636838912964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantoloking' limit 1
loadtime:3.1637468338013 / seconds
Query Executed:select id FROM `nj` where city='Mantoloking' && SIC_code='7011'DB:business_master_new
loadtime:3.1906509399414 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:3.1907007694244 / seconds
Query Executed:select id FROM `nj` where city='Mantua' && SIC_code='7011'DB:business_master_new
loadtime:3.191960811615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manville' limit 1
loadtime:3.1919958591461 / seconds
Query Executed:select id FROM `nj` where city='Manville' && SIC_code='7011'DB:business_master_new
loadtime:3.1933078765869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Shade' limit 1
loadtime:3.193354845047 / seconds
Query Executed:select id FROM `nj` where city='Maple Shade' && SIC_code='7011'DB:business_master_new
loadtime:3.197970867157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:3.1980299949646 / seconds
Query Executed:select id FROM `nj` where city='Maplewood' && SIC_code='7011'DB:business_master_new
loadtime:3.2005817890167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margate City' limit 1
loadtime:3.2006387710571 / seconds
Query Executed:select id FROM `nj` where city='Margate City' && SIC_code='7011'DB:business_master_new
loadtime:3.2019639015198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:3.2019999027252 / seconds
Query Executed:select id FROM `nj` where city='Marlboro' && SIC_code='7011'DB:business_master_new
loadtime:3.2035658359528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlton' limit 1
loadtime:3.2036128044128 / seconds
Query Executed:select id FROM `nj` where city='Marlton' && SIC_code='7011'DB:business_master_new
loadtime:3.2063629627228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marmora' limit 1
loadtime:3.2064168453217 / seconds
Query Executed:select id FROM `nj` where city='Marmora' && SIC_code='7011'DB:business_master_new
loadtime:3.2092938423157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:3.2093498706818 / seconds
Query Executed:select id FROM `nj` where city='Martinsville' && SIC_code='7011'DB:business_master_new
loadtime:3.2106058597565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matawan' limit 1
loadtime:3.2106428146362 / seconds
Query Executed:select id FROM `nj` where city='Matawan' && SIC_code='7011'DB:business_master_new
loadtime:3.2138669490814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauricetown' limit 1
loadtime:3.2139217853546 / seconds
Query Executed:select id FROM `nj` where city='Mauricetown' && SIC_code='7011'DB:business_master_new
loadtime:3.2226648330688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mays Landing' limit 1
loadtime:3.2227149009705 / seconds
Query Executed:select id FROM `nj` where city='Mays Landing' && SIC_code='7011'DB:business_master_new
loadtime:3.227089881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maywood' limit 1
loadtime:3.2271468639374 / seconds
Query Executed:select id FROM `nj` where city='Maywood' && SIC_code='7011'DB:business_master_new
loadtime:3.2285039424896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Afee' limit 1
loadtime:3.228551864624 / seconds
Query Executed:select id FROM `nj` where city='Mc Afee' && SIC_code='7011'DB:business_master_new
loadtime:3.2645089626312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Guire Afb' limit 1
loadtime:3.2645738124847 / seconds
Query Executed:select id FROM `nj` where city='Mc Guire Afb' && SIC_code='7011'DB:business_master_new
loadtime:3.2717719078064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:3.2718648910522 / seconds
Query Executed:select id FROM `nj` where city='Medford' && SIC_code='7011'DB:business_master_new
loadtime:3.2768759727478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford Lakes' limit 1
loadtime:3.2769448757172 / seconds
Query Executed:select id FROM `nj` where city='Medford Lakes' && SIC_code='7011'DB:business_master_new
loadtime:3.2798538208008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendham' limit 1
loadtime:3.2799007892609 / seconds
Query Executed:select id FROM `nj` where city='Mendham' && SIC_code='7011'DB:business_master_new
loadtime:3.2816009521484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercerville' limit 1
loadtime:3.2816438674927 / seconds
Query Executed:select id FROM `nj` where city='Mercerville' && SIC_code='7011'DB:business_master_new
loadtime:3.3080449104309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merchantville' limit 1
loadtime:3.3080928325653 / seconds
Query Executed:select id FROM `nj` where city='Merchantville' && SIC_code='7011'DB:business_master_new
loadtime:3.3096449375153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metuchen' limit 1
loadtime:3.3096919059753 / seconds
Query Executed:select id FROM `nj` where city='Metuchen' && SIC_code='7011'DB:business_master_new
loadtime:3.3114237785339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mickleton' limit 1
loadtime:3.3114809989929 / seconds
Query Executed:select id FROM `nj` where city='Mickleton' && SIC_code='7011'DB:business_master_new
loadtime:3.3619709014893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:3.3620309829712 / seconds
Query Executed:select id FROM `nj` where city='Middlesex' && SIC_code='7011'DB:business_master_new
loadtime:3.3650989532471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:3.3651478290558 / seconds
Query Executed:select id FROM `nj` where city='Middletown' && SIC_code='7011'DB:business_master_new
loadtime:3.3674669265747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:3.3675239086151 / seconds
Query Executed:select id FROM `nj` where city='Middleville' && SIC_code='7011'DB:business_master_new
loadtime:3.3743209838867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland Park' limit 1
loadtime:3.3743679523468 / seconds
Query Executed:select id FROM `nj` where city='Midland Park' && SIC_code='7011'DB:business_master_new
loadtime:3.3758828639984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:3.3759188652039 / seconds
Query Executed:select id FROM `nj` where city='Milford' && SIC_code='7011'DB:business_master_new
loadtime:3.3778109550476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millburn' limit 1
loadtime:3.3780138492584 / seconds
Query Executed:select id FROM `nj` where city='Millburn' && SIC_code='7011'DB:business_master_new
loadtime:3.3856768608093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:3.3857247829437 / seconds
Query Executed:select id FROM `nj` where city='Millington' && SIC_code='7011'DB:business_master_new
loadtime:3.3869569301605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millstone Twp' limit 1
loadtime:3.3870069980621 / seconds
Query Executed:select id FROM `nj` where city='Millstone Twp' && SIC_code='7011'DB:business_master_new
loadtime:3.3882269859314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milltown' limit 1
loadtime:3.3882749080658 / seconds
Query Executed:select id FROM `nj` where city='Milltown' && SIC_code='7011'DB:business_master_new
loadtime:3.3895947933197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:3.3896408081055 / seconds
Query Executed:select id FROM `nj` where city='Millville' && SIC_code='7011'DB:business_master_new
loadtime:3.3956089019775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milmay' limit 1
loadtime:3.3956668376923 / seconds
Query Executed:select id FROM `nj` where city='Milmay' && SIC_code='7011'DB:business_master_new
loadtime:3.4125108718872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Hill' limit 1
loadtime:3.4125587940216 / seconds
Query Executed:select id FROM `nj` where city='Mine Hill' && SIC_code='7011'DB:business_master_new
loadtime:3.4154989719391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minotola' limit 1
loadtime:3.4156489372253 / seconds
Query Executed:select id FROM `nj` where city='Minotola' && SIC_code='7011'DB:business_master_new
loadtime:3.4467568397522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mizpah' limit 1
loadtime:3.446793794632 / seconds
Query Executed:select id FROM `nj` where city='Mizpah' && SIC_code='7011'DB:business_master_new
loadtime:3.4544169902802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Beach' limit 1
loadtime:3.4544668197632 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Beach' && SIC_code='7011'DB:business_master_new
loadtime:3.4557349681854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Jct' limit 1
loadtime:3.4557828903198 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Jct' && SIC_code='7011'DB:business_master_new
loadtime:3.4616079330444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Junction' limit 1
loadtime:3.4616568088531 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Junction' && SIC_code='7011'DB:business_master_new
loadtime:3.4675979614258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Township' limit 1
loadtime:3.4676568508148 / seconds
Query Executed:select id FROM `nj` where city='Monroe Township' && SIC_code='7011'DB:business_master_new
loadtime:3.4710319042206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Twp' limit 1
loadtime:3.471088886261 / seconds
Query Executed:select id FROM `nj` where city='Monroe Twp' && SIC_code='7011'DB:business_master_new
loadtime:3.5010058879852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroeville' limit 1
loadtime:3.5011048316956 / seconds
Query Executed:select id FROM `nj` where city='Monroeville' && SIC_code='7011'DB:business_master_new
loadtime:3.5039889812469 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:3.5040509700775 / seconds
Query Executed:select id FROM `nj` where city='Montague' && SIC_code='7011'DB:business_master_new
loadtime:3.5069878101349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montclair' limit 1
loadtime:3.5070819854736 / seconds
Query Executed:select id FROM `nj` where city='Montclair' && SIC_code='7011'DB:business_master_new
loadtime:3.5126869678497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:3.5127518177032 / seconds
Query Executed:select id FROM `nj` where city='Montvale' && SIC_code='7011'DB:business_master_new
loadtime:3.5166578292847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:3.5167529582977 / seconds
Query Executed:select id FROM `nj` where city='Montville' && SIC_code='7011'DB:business_master_new
loadtime:3.5187377929688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moonachie' limit 1
loadtime:3.5187928676605 / seconds
Query Executed:select id FROM `nj` where city='Moonachie' && SIC_code='7011'DB:business_master_new
loadtime:3.5200719833374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorestown' limit 1
loadtime:3.5201189517975 / seconds
Query Executed:select id FROM `nj` where city='Moorestown' && SIC_code='7011'DB:business_master_new
loadtime:3.5229198932648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganville' limit 1
loadtime:3.5229878425598 / seconds
Query Executed:select id FROM `nj` where city='Morganville' && SIC_code='7011'DB:business_master_new
loadtime:3.5245478153229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris Plains' limit 1
loadtime:3.5245978832245 / seconds
Query Executed:select id FROM `nj` where city='Morris Plains' && SIC_code='7011'DB:business_master_new
loadtime:3.5275838375092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:3.5276279449463 / seconds
Query Executed:select id FROM `nj` where city='Morristown' && SIC_code='7011'DB:business_master_new
loadtime:3.5351858139038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Arlington' limit 1
loadtime:3.5352518558502 / seconds
Query Executed:select id FROM `nj` where city='Mount Arlington' && SIC_code='7011'DB:business_master_new
loadtime:3.5382168292999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ephraim' limit 1
loadtime:3.5382947921753 / seconds
Query Executed:select id FROM `nj` where city='Mount Ephraim' && SIC_code='7011'DB:business_master_new
loadtime:3.5412337779999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Freedom' limit 1
loadtime:3.5413069725037 / seconds
Query Executed:select id FROM `nj` where city='Mount Freedom' && SIC_code='7011'DB:business_master_new
loadtime:3.5731799602509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:3.5732278823853 / seconds
Query Executed:select id FROM `nj` where city='Mount Holly' && SIC_code='7011'DB:business_master_new
loadtime:3.5779888629913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Laurel' limit 1
loadtime:3.578047990799 / seconds
Query Executed:select id FROM `nj` where city='Mount Laurel' && SIC_code='7011'DB:business_master_new
loadtime:3.593211889267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Royal' limit 1
loadtime:3.5932908058167 / seconds
Query Executed:select id FROM `nj` where city='Mount Royal' && SIC_code='7011'DB:business_master_new
loadtime:3.6132237911224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Tabor' limit 1
loadtime:3.613273859024 / seconds
Query Executed:select id FROM `nj` where city='Mount Tabor' && SIC_code='7011'DB:business_master_new
loadtime:3.6289207935333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Lakes' limit 1
loadtime:3.6289808750153 / seconds
Query Executed:select id FROM `nj` where city='Mountain Lakes' && SIC_code='7011'DB:business_master_new
loadtime:3.6303069591522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainside' limit 1
loadtime:3.6303548812866 / seconds
Query Executed:select id FROM `nj` where city='Mountainside' && SIC_code='7011'DB:business_master_new
loadtime:3.6330828666687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Arlington' limit 1
loadtime:3.6331679821014 / seconds
Query Executed:select id FROM `nj` where city='Mt Arlington' && SIC_code='7011'DB:business_master_new
loadtime:3.6387128829956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ephraim' limit 1
loadtime:3.6387619972229 / seconds
Query Executed:select id FROM `nj` where city='Mt Ephraim' && SIC_code='7011'DB:business_master_new
loadtime:3.6411259174347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Freedom' limit 1
loadtime:3.6411728858948 / seconds
Query Executed:select id FROM `nj` where city='Mt Freedom' && SIC_code='7011'DB:business_master_new
loadtime:3.6451768875122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:3.6452248096466 / seconds
Query Executed:select id FROM `nj` where city='Mt Holly' && SIC_code='7011'DB:business_master_new
loadtime:3.6711578369141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Laurel' limit 1
loadtime:3.6712019443512 / seconds
Query Executed:select id FROM `nj` where city='Mt Laurel' && SIC_code='7011'DB:business_master_new
loadtime:3.6727619171143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Royal' limit 1
loadtime:3.6728179454803 / seconds
Query Executed:select id FROM `nj` where city='Mt Royal' && SIC_code='7011'DB:business_master_new
loadtime:3.674192905426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Tabor' limit 1
loadtime:3.6742429733276 / seconds
Query Executed:select id FROM `nj` where city='Mt Tabor' && SIC_code='7011'DB:business_master_new
loadtime:3.6791839599609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullica Hill' limit 1
loadtime:3.679233789444 / seconds
Query Executed:select id FROM `nj` where city='Mullica Hill' && SIC_code='7011'DB:business_master_new
loadtime:3.6808488368988 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Park' limit 1
loadtime:3.6808919906616 / seconds
Query Executed:select id FROM `nj` where city='National Park' && SIC_code='7011'DB:business_master_new
loadtime:3.7061769962311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navesink' limit 1
loadtime:3.7062637805939 / seconds
Query Executed:select id FROM `nj` where city='Navesink' && SIC_code='7011'DB:business_master_new
loadtime:3.7291619777679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neptune' limit 1
loadtime:3.7292428016663 / seconds
Query Executed:select id FROM `nj` where city='Neptune' && SIC_code='7011'DB:business_master_new
loadtime:3.7388248443604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neptune City' limit 1
loadtime:3.7388889789581 / seconds
Query Executed:select id FROM `nj` where city='Neptune City' && SIC_code='7011'DB:business_master_new
loadtime:3.7485718727112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neshanic Station' limit 1
loadtime:3.7486228942871 / seconds
Query Executed:select id FROM `nj` where city='Neshanic Station' && SIC_code='7011'DB:business_master_new
loadtime:3.750391960144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Netcong' limit 1
loadtime:3.750433921814 / seconds
Query Executed:select id FROM `nj` where city='Netcong' && SIC_code='7011'DB:business_master_new
loadtime:3.7519187927246 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Brunswick' limit 1
loadtime:3.7519869804382 / seconds
Query Executed:select id FROM `nj` where city='New Brunswick' && SIC_code='7011'DB:business_master_new
loadtime:3.7561218738556 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Egypt' limit 1
loadtime:3.756178855896 / seconds
Query Executed:select id FROM `nj` where city='New Egypt' && SIC_code='7011'DB:business_master_new
loadtime:3.7576909065247 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Gretna' limit 1
loadtime:3.7577497959137 / seconds
Query Executed:select id FROM `nj` where city='New Gretna' && SIC_code='7011'DB:business_master_new
loadtime:3.7773749828339 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lisbon' limit 1
loadtime:3.7774248123169 / seconds
Query Executed:select id FROM `nj` where city='New Lisbon' && SIC_code='7011'DB:business_master_new
loadtime:3.7885267734528 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:3.7885768413544 / seconds
Query Executed:select id FROM `nj` where city='New Milford' && SIC_code='7011'DB:business_master_new
loadtime:3.7901618480682 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Monmouth' limit 1
loadtime:3.790237903595 / seconds
Query Executed:select id FROM `nj` where city='New Monmouth' && SIC_code='7011'DB:business_master_new
loadtime:3.7927169799805 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:3.7927639484406 / seconds
Query Executed:select id FROM `nj` where city='New Providence' && SIC_code='7011'DB:business_master_new
loadtime:3.796315908432 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vernon' limit 1
loadtime:3.796413898468 / seconds
Query Executed:select id FROM `nj` where city='New Vernon' && SIC_code='7011'DB:business_master_new
loadtime:3.8259527683258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newark' limit 1
loadtime:3.8260037899017 / seconds
Query Executed:select id FROM `nj` where city='Newark' && SIC_code='7011'DB:business_master_new
loadtime:4.1962828636169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfield' limit 1
loadtime:4.1964387893677 / seconds
Query Executed:select id FROM `nj` where city='Newfield' && SIC_code='7011'DB:business_master_new
loadtime:4.1978878974915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfoundland' limit 1
loadtime:4.1979467868805 / seconds
Query Executed:select id FROM `nj` where city='Newfoundland' && SIC_code='7011'DB:business_master_new
loadtime:4.1991729736328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:4.1992268562317 / seconds
Query Executed:select id FROM `nj` where city='Newport' && SIC_code='7011'DB:business_master_new
loadtime:4.2096529006958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:4.2097039222717 / seconds
Query Executed:select id FROM `nj` where city='Newton' && SIC_code='7011'DB:business_master_new
loadtime:4.2117669582367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:4.2118239402771 / seconds
Query Executed:select id FROM `nj` where city='Newtonville' && SIC_code='7011'DB:business_master_new
loadtime:4.2270278930664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norma' limit 1
loadtime:4.2270829677582 / seconds
Query Executed:select id FROM `nj` where city='Norma' && SIC_code='7011'DB:business_master_new
loadtime:4.2375559806824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Normandy Beach' limit 1
loadtime:4.2376008033752 / seconds
Query Executed:select id FROM `nj` where city='Normandy Beach' && SIC_code='7011'DB:business_master_new
loadtime:4.2580437660217 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Arlington' limit 1
loadtime:4.2581028938293 / seconds
Query Executed:select id FROM `nj` where city='North Arlington' && SIC_code='7011'DB:business_master_new
loadtime:4.2595739364624 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bergen' limit 1
loadtime:4.2596218585968 / seconds
Query Executed:select id FROM `nj` where city='North Bergen' && SIC_code='7011'DB:business_master_new
loadtime:4.2621188163757 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:4.2621829509735 / seconds
Query Executed:select id FROM `nj` where city='North Branch' && SIC_code='7011'DB:business_master_new
loadtime:4.2710738182068 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brunswick' limit 1
loadtime:4.2711248397827 / seconds
Query Executed:select id FROM `nj` where city='North Brunswick' && SIC_code='7011'DB:business_master_new
loadtime:4.2731809616089 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cape May' limit 1
loadtime:4.2732419967651 / seconds
Query Executed:select id FROM `nj` where city='North Cape May' && SIC_code='7011'DB:business_master_new
loadtime:4.2755630016327 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haledon' limit 1
loadtime:4.2756128311157 / seconds
Query Executed:select id FROM `nj` where city='North Haledon' && SIC_code='7011'DB:business_master_new
loadtime:4.279620885849 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Middletown' limit 1
loadtime:4.2796678543091 / seconds
Query Executed:select id FROM `nj` where city='North Middletown' && SIC_code='7011'DB:business_master_new
loadtime:4.2821137905121 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Plainfield' limit 1
loadtime:4.2821598052979 / seconds
Query Executed:select id FROM `nj` where city='North Plainfield' && SIC_code='7011'DB:business_master_new
loadtime:4.2955977916718 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wildwood' limit 1
loadtime:4.2956488132477 / seconds
Query Executed:select id FROM `nj` where city='North Wildwood' && SIC_code='7011'DB:business_master_new
loadtime:4.3022758960724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:4.3023359775543 / seconds
Query Executed:select id FROM `nj` where city='Northfield' && SIC_code='7011'DB:business_master_new
loadtime:4.3039407730103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northvale' limit 1
loadtime:4.3039889335632 / seconds
Query Executed:select id FROM `nj` where city='Northvale' && SIC_code='7011'DB:business_master_new
loadtime:4.305312871933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:4.3053588867188 / seconds
Query Executed:select id FROM `nj` where city='Norwood' && SIC_code='7011'DB:business_master_new
loadtime:4.3066339492798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutley' limit 1
loadtime:4.3066809177399 / seconds
Query Executed:select id FROM `nj` where city='Nutley' && SIC_code='7011'DB:business_master_new
loadtime:4.3085658550262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:4.3086128234863 / seconds
Query Executed:select id FROM `nj` where city='Oak Ridge' && SIC_code='7011'DB:business_master_new
loadtime:4.3099629878998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakhurst' limit 1
loadtime:4.3100109100342 / seconds
Query Executed:select id FROM `nj` where city='Oakhurst' && SIC_code='7011'DB:business_master_new
loadtime:4.3113927841187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:4.3114418983459 / seconds
Query Executed:select id FROM `nj` where city='Oakland' && SIC_code='7011'DB:business_master_new
loadtime:4.3129558563232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oaklyn' limit 1
loadtime:4.3129999637604 / seconds
Query Executed:select id FROM `nj` where city='Oaklyn' && SIC_code='7011'DB:business_master_new
loadtime:4.3142778873444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean' limit 1
loadtime:4.3143298625946 / seconds
Query Executed:select id FROM `nj` where city='Ocean' && SIC_code='7011'DB:business_master_new
loadtime:4.3507618904114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean City' limit 1
loadtime:4.3508229255676 / seconds
Query Executed:select id FROM `nj` where city='Ocean City' && SIC_code='7011'DB:business_master_new
loadtime:4.3560009002686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Gate' limit 1
loadtime:4.3561189174652 / seconds
Query Executed:select id FROM `nj` where city='Ocean Gate' && SIC_code='7011'DB:business_master_new
loadtime:4.3758578300476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Grove' limit 1
loadtime:4.3759109973907 / seconds
Query Executed:select id FROM `nj` where city='Ocean Grove' && SIC_code='7011'DB:business_master_new
loadtime:4.3774948120117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean View' limit 1
loadtime:4.3776059150696 / seconds
Query Executed:select id FROM `nj` where city='Ocean View' && SIC_code='7011'DB:business_master_new
loadtime:4.3788959980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanport' limit 1
loadtime:4.3789668083191 / seconds
Query Executed:select id FROM `nj` where city='Oceanport' && SIC_code='7011'DB:business_master_new
loadtime:4.3801739215851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanville' limit 1
loadtime:4.3802089691162 / seconds
Query Executed:select id FROM `nj` where city='Oceanville' && SIC_code='7011'DB:business_master_new
loadtime:4.3936228752136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogdensburg' limit 1
loadtime:4.3936729431152 / seconds
Query Executed:select id FROM `nj` where city='Ogdensburg' && SIC_code='7011'DB:business_master_new
loadtime:4.4239618778229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Bridge' limit 1
loadtime:4.4240279197693 / seconds
Query Executed:select id FROM `nj` where city='Old Bridge' && SIC_code='7011'DB:business_master_new
loadtime:4.4267067909241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Tappan' limit 1
loadtime:4.4267618656158 / seconds
Query Executed:select id FROM `nj` where city='Old Tappan' && SIC_code='7011'DB:business_master_new
loadtime:4.4367668628693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldwick' limit 1
loadtime:4.4368939399719 / seconds
Query Executed:select id FROM `nj` where city='Oldwick' && SIC_code='7011'DB:business_master_new
loadtime:4.4793338775635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oradell' limit 1
loadtime:4.4793829917908 / seconds
Query Executed:select id FROM `nj` where city='Oradell' && SIC_code='7011'DB:business_master_new
loadtime:4.4808337688446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:4.4808809757233 / seconds
Query Executed:select id FROM `nj` where city='Orange' && SIC_code='7011'DB:business_master_new
loadtime:4.482736825943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osbornsville' limit 1
loadtime:4.4827938079834 / seconds
Query Executed:select id FROM `nj` where city='Osbornsville' && SIC_code='7011'DB:business_master_new
loadtime:4.4843239784241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:4.4843738079071 / seconds
Query Executed:select id FROM `nj` where city='Oxford' && SIC_code='7011'DB:business_master_new
loadtime:4.4855718612671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisades Park' limit 1
loadtime:4.4856219291687 / seconds
Query Executed:select id FROM `nj` where city='Palisades Park' && SIC_code='7011'DB:business_master_new
loadtime:4.4873309135437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:4.4873738288879 / seconds
Query Executed:select id FROM `nj` where city='Palmyra' && SIC_code='7011'DB:business_master_new
loadtime:4.4886248111725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paramus' limit 1
loadtime:4.4886817932129 / seconds
Query Executed:select id FROM `nj` where city='Paramus' && SIC_code='7011'DB:business_master_new
loadtime:4.4915189743042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Ridge' limit 1
loadtime:4.4915819168091 / seconds
Query Executed:select id FROM `nj` where city='Park Ridge' && SIC_code='7011'DB:business_master_new
loadtime:4.493020772934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parlin' limit 1
loadtime:4.4930648803711 / seconds
Query Executed:select id FROM `nj` where city='Parlin' && SIC_code='7011'DB:business_master_new
loadtime:4.494414806366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parsippany' limit 1
loadtime:4.4944698810577 / seconds
Query Executed:select id FROM `nj` where city='Parsippany' && SIC_code='7011'DB:business_master_new
loadtime:4.4973459243774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passaic' limit 1
loadtime:4.4974148273468 / seconds
Query Executed:select id FROM `nj` where city='Passaic' && SIC_code='7011'DB:business_master_new
loadtime:4.4997417926788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paterson' limit 1
loadtime:4.4997978210449 / seconds
Query Executed:select id FROM `nj` where city='Paterson' && SIC_code='7011'DB:business_master_new
loadtime:4.5034379959106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulsboro' limit 1
loadtime:4.5034959316254 / seconds
Query Executed:select id FROM `nj` where city='Paulsboro' && SIC_code='7011'DB:business_master_new
loadtime:4.504852771759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peapack' limit 1
loadtime:4.504900932312 / seconds
Query Executed:select id FROM `nj` where city='Peapack' && SIC_code='7011'DB:business_master_new
loadtime:4.5420868396759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pedricktown' limit 1
loadtime:4.5421488285065 / seconds
Query Executed:select id FROM `nj` where city='Pedricktown' && SIC_code='7011'DB:business_master_new
loadtime:4.5669939517975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pemberton' limit 1
loadtime:4.5670299530029 / seconds
Query Executed:select id FROM `nj` where city='Pemberton' && SIC_code='7011'DB:business_master_new
loadtime:4.5683019161224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington' limit 1
loadtime:4.5683588981628 / seconds
Query Executed:select id FROM `nj` where city='Pennington' && SIC_code='7011'DB:business_master_new
loadtime:4.5699398517609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penns Grove' limit 1
loadtime:4.5699989795685 / seconds
Query Executed:select id FROM `nj` where city='Penns Grove' && SIC_code='7011'DB:business_master_new
loadtime:4.5714709758759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsauken' limit 1
loadtime:4.5715219974518 / seconds
Query Executed:select id FROM `nj` where city='Pennsauken' && SIC_code='7011'DB:business_master_new
loadtime:4.5734248161316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsville' limit 1
loadtime:4.5734829902649 / seconds
Query Executed:select id FROM `nj` where city='Pennsville' && SIC_code='7011'DB:business_master_new
loadtime:4.5748779773712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequannock' limit 1
loadtime:4.5749449729919 / seconds
Query Executed:select id FROM `nj` where city='Pequannock' && SIC_code='7011'DB:business_master_new
loadtime:4.5761289596558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrineville' limit 1
loadtime:4.5761759281158 / seconds
Query Executed:select id FROM `nj` where city='Perrineville' && SIC_code='7011'DB:business_master_new
loadtime:4.5784268379211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perth Amboy' limit 1
loadtime:4.5784759521484 / seconds
Query Executed:select id FROM `nj` where city='Perth Amboy' && SIC_code='7011'DB:business_master_new
loadtime:4.5804369449615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipsburg' limit 1
loadtime:4.5804948806763 / seconds
Query Executed:select id FROM `nj` where city='Phillipsburg' && SIC_code='7011'DB:business_master_new
loadtime:4.5824768543243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picatinny Arsenal' limit 1
loadtime:4.5825338363647 / seconds
Query Executed:select id FROM `nj` where city='Picatinny Arsenal' && SIC_code='7011'DB:business_master_new
loadtime:4.589460849762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picatinny Arsnl' limit 1
loadtime:4.5895187854767 / seconds
Query Executed:select id FROM `nj` where city='Picatinny Arsnl' && SIC_code='7011'DB:business_master_new
loadtime:4.5994307994843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilesgrove' limit 1
loadtime:4.5994799137115 / seconds
Query Executed:select id FROM `nj` where city='Pilesgrove' && SIC_code='7011'DB:business_master_new
loadtime:4.6025528907776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Beach' limit 1
loadtime:4.6025998592377 / seconds
Query Executed:select id FROM `nj` where city='Pine Beach' && SIC_code='7011'DB:business_master_new
loadtime:4.6290719509125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Brook' limit 1
loadtime:4.6291198730469 / seconds
Query Executed:select id FROM `nj` where city='Pine Brook' && SIC_code='7011'DB:business_master_new
loadtime:4.6306159496307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hill' limit 1
loadtime:4.6306748390198 / seconds
Query Executed:select id FROM `nj` where city='Pine Hill' && SIC_code='7011'DB:business_master_new
loadtime:4.6341648101807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piscataway' limit 1
loadtime:4.6342058181763 / seconds
Query Executed:select id FROM `nj` where city='Piscataway' && SIC_code='7011'DB:business_master_new
loadtime:4.6364808082581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pitman' limit 1
loadtime:4.63654088974 / seconds
Query Executed:select id FROM `nj` where city='Pitman' && SIC_code='7011'DB:business_master_new
loadtime:4.6379599571228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsgrove' limit 1
loadtime:4.6380169391632 / seconds
Query Executed:select id FROM `nj` where city='Pittsgrove' && SIC_code='7011'DB:business_master_new
loadtime:4.6412987709045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittstown' limit 1
loadtime:4.6413459777832 / seconds
Query Executed:select id FROM `nj` where city='Pittstown' && SIC_code='7011'DB:business_master_new
loadtime:4.6426899433136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:4.6427447795868 / seconds
Query Executed:select id FROM `nj` where city='Plainfield' && SIC_code='7011'DB:business_master_new
loadtime:4.6452498435974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainsboro' limit 1
loadtime:4.6453068256378 / seconds
Query Executed:select id FROM `nj` where city='Plainsboro' && SIC_code='7011'DB:business_master_new
loadtime:4.6467559337616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:4.6468098163605 / seconds
Query Executed:select id FROM `nj` where city='Pleasantville' && SIC_code='7011'DB:business_master_new
loadtime:4.6488218307495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pluckemin' limit 1
loadtime:4.6488928794861 / seconds
Query Executed:select id FROM `nj` where city='Pluckemin' && SIC_code='7011'DB:business_master_new
loadtime:4.6693649291992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant' limit 1
loadtime:4.669401884079 / seconds
Query Executed:select id FROM `nj` where city='Point Pleasant' && SIC_code='7011'DB:business_master_new
loadtime:4.6859829425812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant Beach' limit 1
loadtime:4.6860339641571 / seconds
Query Executed:select id FROM `nj` where city='Point Pleasant Beach' && SIC_code='7011'DB:business_master_new
loadtime:4.6889967918396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomona' limit 1
loadtime:4.6890759468079 / seconds
Query Executed:select id FROM `nj` where city='Pomona' && SIC_code='7011'DB:business_master_new
loadtime:4.722559928894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompton Lakes' limit 1
loadtime:4.7226147651672 / seconds
Query Executed:select id FROM `nj` where city='Pompton Lakes' && SIC_code='7011'DB:business_master_new
loadtime:4.724102973938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompton Plains' limit 1
loadtime:4.724152803421 / seconds
Query Executed:select id FROM `nj` where city='Pompton Plains' && SIC_code='7011'DB:business_master_new
loadtime:4.7256717681885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Elizabeth' limit 1
loadtime:4.7257289886475 / seconds
Query Executed:select id FROM `nj` where city='Port Elizabeth' && SIC_code='7011'DB:business_master_new
loadtime:4.7321767807007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Monmouth' limit 1
loadtime:4.7322249412537 / seconds
Query Executed:select id FROM `nj` where city='Port Monmouth' && SIC_code='7011'DB:business_master_new
loadtime:4.7334079742432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Murray' limit 1
loadtime:4.7334539890289 / seconds
Query Executed:select id FROM `nj` where city='Port Murray' && SIC_code='7011'DB:business_master_new
loadtime:4.7641179561615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Norris' limit 1
loadtime:4.7641727924347 / seconds
Query Executed:select id FROM `nj` where city='Port Norris' && SIC_code='7011'DB:business_master_new
loadtime:4.7907857894897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Reading' limit 1
loadtime:4.790825843811 / seconds
Query Executed:select id FROM `nj` where city='Port Reading' && SIC_code='7011'DB:business_master_new
loadtime:4.8118209838867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:4.8118607997894 / seconds
Query Executed:select id FROM `nj` where city='Port Republic' && SIC_code='7011'DB:business_master_new
loadtime:4.8359749317169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pottersville' limit 1
loadtime:4.8360269069672 / seconds
Query Executed:select id FROM `nj` where city='Pottersville' && SIC_code='7011'DB:business_master_new
loadtime:4.8494889736176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:4.849536895752 / seconds
Query Executed:select id FROM `nj` where city='Princeton' && SIC_code='7011'DB:business_master_new
loadtime:4.8533668518066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton Jct' limit 1
loadtime:4.8534328937531 / seconds
Query Executed:select id FROM `nj` where city='Princeton Jct' && SIC_code='7011'DB:business_master_new
loadtime:4.8566479682922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton Junction' limit 1
loadtime:4.8566877841949 / seconds
Query Executed:select id FROM `nj` where city='Princeton Junction' && SIC_code='7011'DB:business_master_new
loadtime:4.8582558631897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Park' limit 1
loadtime:4.8582968711853 / seconds
Query Executed:select id FROM `nj` where city='Prospect Park' && SIC_code='7011'DB:business_master_new
loadtime:4.8586099147797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pt Pleasant Bch' limit 1
loadtime:4.8586418628693 / seconds
Query Executed:select id FROM `nj` where city='Pt Pleasant Bch' && SIC_code='7011'DB:business_master_new
loadtime:4.8620457649231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pt Pleasant Boro' limit 1
loadtime:4.8620808124542 / seconds
Query Executed:select id FROM `nj` where city='Pt Pleasant Boro' && SIC_code='7011'DB:business_master_new
loadtime:4.8624069690704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quakertown' limit 1
loadtime:4.8624367713928 / seconds
Query Executed:select id FROM `nj` where city='Quakertown' && SIC_code='7011'DB:business_master_new
loadtime:4.8711369037628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:4.8711709976196 / seconds
Query Executed:select id FROM `nj` where city='Quinton' && SIC_code='7011'DB:business_master_new
loadtime:4.8834087848663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rahway' limit 1
loadtime:4.8834588527679 / seconds
Query Executed:select id FROM `nj` where city='Rahway' && SIC_code='7011'DB:business_master_new
loadtime:4.8852968215942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsey' limit 1
loadtime:4.8853528499603 / seconds
Query Executed:select id FROM `nj` where city='Ramsey' && SIC_code='7011'DB:business_master_new
loadtime:4.8872849941254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rancocas' limit 1
loadtime:4.8873448371887 / seconds
Query Executed:select id FROM `nj` where city='Rancocas' && SIC_code='7011'DB:business_master_new
loadtime:4.9088809490204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:4.908942937851 / seconds
Query Executed:select id FROM `nj` where city='Randolph' && SIC_code='7011'DB:business_master_new
loadtime:4.9107577800751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raritan' limit 1
loadtime:4.9108068943024 / seconds
Query Executed:select id FROM `nj` where city='Raritan' && SIC_code='7011'DB:business_master_new
loadtime:4.912172794342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readington' limit 1
loadtime:4.9122178554535 / seconds
Query Executed:select id FROM `nj` where city='Readington' && SIC_code='7011'DB:business_master_new
loadtime:4.9235219955444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Bank' limit 1
loadtime:4.9236629009247 / seconds
Query Executed:select id FROM `nj` where city='Red Bank' && SIC_code='7011'DB:business_master_new
loadtime:4.9272840023041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:4.9273347854614 / seconds
Query Executed:select id FROM `nj` where city='Richland' && SIC_code='7011'DB:business_master_new
loadtime:4.9393739700317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richwood' limit 1
loadtime:4.9394237995148 / seconds
Query Executed:select id FROM `nj` where city='Richwood' && SIC_code='7011'DB:business_master_new
loadtime:4.9494249820709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:4.949471950531 / seconds
Query Executed:select id FROM `nj` where city='Ridgefield' && SIC_code='7011'DB:business_master_new
loadtime:4.9525139331818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield Park' limit 1
loadtime:4.9525718688965 / seconds
Query Executed:select id FROM `nj` where city='Ridgefield Park' && SIC_code='7011'DB:business_master_new
loadtime:4.9546008110046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgewood' limit 1
loadtime:4.9546568393707 / seconds
Query Executed:select id FROM `nj` where city='Ridgewood' && SIC_code='7011'DB:business_master_new
loadtime:4.9568867683411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringoes' limit 1
loadtime:4.9569537639618 / seconds
Query Executed:select id FROM `nj` where city='Ringoes' && SIC_code='7011'DB:business_master_new
loadtime:4.9582188129425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringwood' limit 1
loadtime:4.9582757949829 / seconds
Query Executed:select id FROM `nj` where city='Ringwood' && SIC_code='7011'DB:business_master_new
loadtime:4.9596819877625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Grande' limit 1
loadtime:4.9597268104553 / seconds
Query Executed:select id FROM `nj` where city='Rio Grande' && SIC_code='7011'DB:business_master_new
loadtime:4.9611809253693 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Edge' limit 1
loadtime:4.9612407684326 / seconds
Query Executed:select id FROM `nj` where city='River Edge' && SIC_code='7011'DB:business_master_new
loadtime:4.9626388549805 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Vale' limit 1
loadtime:4.9626939296722 / seconds
Query Executed:select id FROM `nj` where city='River Vale' && SIC_code='7011'DB:business_master_new
loadtime:4.9654037952423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:4.9654397964478 / seconds
Query Executed:select id FROM `nj` where city='Riverdale' && SIC_code='7011'DB:business_master_new
loadtime:4.9667558670044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:4.9668037891388 / seconds
Query Executed:select id FROM `nj` where city='Riverside' && SIC_code='7011'DB:business_master_new
loadtime:4.9684929847717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:4.9685409069061 / seconds
Query Executed:select id FROM `nj` where city='Riverton' && SIC_code='7011'DB:business_master_new
loadtime:4.9704258441925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:4.9704899787903 / seconds
Query Executed:select id FROM `nj` where city='Robbinsville' && SIC_code='7011'DB:business_master_new
loadtime:4.9843719005585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle Park' limit 1
loadtime:4.9844238758087 / seconds
Query Executed:select id FROM `nj` where city='Rochelle Park' && SIC_code='7011'DB:business_master_new
loadtime:4.9864568710327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockaway' limit 1
loadtime:4.9865207672119 / seconds
Query Executed:select id FROM `nj` where city='Rockaway' && SIC_code='7011'DB:business_master_new
loadtime:4.9885859489441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockleigh' limit 1
loadtime:4.9886338710785 / seconds
Query Executed:select id FROM `nj` where city='Rockleigh' && SIC_code='7011'DB:business_master_new
loadtime:4.9896597862244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:4.9897148609161 / seconds
Query Executed:select id FROM `nj` where city='Rocky Hill' && SIC_code='7011'DB:business_master_new
loadtime:5.0180268287659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebling' limit 1
loadtime:5.018073797226 / seconds
Query Executed:select id FROM `nj` where city='Roebling' && SIC_code='7011'DB:business_master_new
loadtime:5.0484309196472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:5.0484848022461 / seconds
Query Executed:select id FROM `nj` where city='Roosevelt' && SIC_code='7011'DB:business_master_new
loadtime:5.0612239837646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:5.0612678527832 / seconds
Query Executed:select id FROM `nj` where city='Roseland' && SIC_code='7011'DB:business_master_new
loadtime:5.0626997947693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roselle' limit 1
loadtime:5.0627458095551 / seconds
Query Executed:select id FROM `nj` where city='Roselle' && SIC_code='7011'DB:business_master_new
loadtime:5.0641958713531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roselle Park' limit 1
loadtime:5.0642318725586 / seconds
Query Executed:select id FROM `nj` where city='Roselle Park' && SIC_code='7011'DB:business_master_new
loadtime:5.0656008720398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosemont' limit 1
loadtime:5.0656268596649 / seconds
Query Executed:select id FROM `nj` where city='Rosemont' && SIC_code='7011'DB:business_master_new
loadtime:5.0825409889221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosenhayn' limit 1
loadtime:5.0826609134674 / seconds
Query Executed:select id FROM `nj` where city='Rosenhayn' && SIC_code='7011'DB:business_master_new
loadtime:5.1049308776855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumson' limit 1
loadtime:5.1049787998199 / seconds
Query Executed:select id FROM `nj` where city='Rumson' && SIC_code='7011'DB:business_master_new
loadtime:5.1067969799042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnemede' limit 1
loadtime:5.1068449020386 / seconds
Query Executed:select id FROM `nj` where city='Runnemede' && SIC_code='7011'DB:business_master_new
loadtime:5.1081619262695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford' limit 1
loadtime:5.1082079410553 / seconds
Query Executed:select id FROM `nj` where city='Rutherford' && SIC_code='7011'DB:business_master_new
loadtime:5.1100029945374 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Bound Brook' limit 1
loadtime:5.1100468635559 / seconds
Query Executed:select id FROM `nj` where city='S Bound Brook' && SIC_code='7011'DB:business_master_new
loadtime:5.1116278171539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddle Brook' limit 1
loadtime:5.1116638183594 / seconds
Query Executed:select id FROM `nj` where city='Saddle Brook' && SIC_code='7011'DB:business_master_new
loadtime:5.1133759021759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddle River' limit 1
loadtime:5.1134238243103 / seconds
Query Executed:select id FROM `nj` where city='Saddle River' && SIC_code='7011'DB:business_master_new
loadtime:5.1149978637695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:5.1150448322296 / seconds
Query Executed:select id FROM `nj` where city='Salem' && SIC_code='7011'DB:business_master_new
loadtime:5.1164219379425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandyston' limit 1
loadtime:5.1164638996124 / seconds
Query Executed:select id FROM `nj` where city='Sandyston' && SIC_code='7011'DB:business_master_new
loadtime:5.1167647838593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayreville' limit 1
loadtime:5.1167969703674 / seconds
Query Executed:select id FROM `nj` where city='Sayreville' && SIC_code='7011'DB:business_master_new
loadtime:5.1182019710541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schooleys Mountain' limit 1
loadtime:5.1182417869568 / seconds
Query Executed:select id FROM `nj` where city='Schooleys Mountain' && SIC_code='7011'DB:business_master_new
loadtime:5.1251528263092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schooleys Mtn' limit 1
loadtime:5.1252119541168 / seconds
Query Executed:select id FROM `nj` where city='Schooleys Mtn' && SIC_code='7011'DB:business_master_new
loadtime:5.1257119178772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Plains' limit 1
loadtime:5.1257438659668 / seconds
Query Executed:select id FROM `nj` where city='Scotch Plains' && SIC_code='7011'DB:business_master_new
loadtime:5.1274828910828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Bright' limit 1
loadtime:5.1275229454041 / seconds
Query Executed:select id FROM `nj` where city='Sea Bright' && SIC_code='7011'DB:business_master_new
loadtime:5.1297187805176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Girt' limit 1
loadtime:5.1299719810486 / seconds
Query Executed:select id FROM `nj` where city='Sea Girt' && SIC_code='7011'DB:business_master_new
loadtime:5.1324939727783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Isle City' limit 1
loadtime:5.1326467990875 / seconds
Query Executed:select id FROM `nj` where city='Sea Isle City' && SIC_code='7011'DB:business_master_new
loadtime:5.1355049610138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:5.1356608867645 / seconds
Query Executed:select id FROM `nj` where city='Seabrook' && SIC_code='7011'DB:business_master_new
loadtime:5.1406469345093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside Heights' limit 1
loadtime:5.1406919956207 / seconds
Query Executed:select id FROM `nj` where city='Seaside Heights' && SIC_code='7011'DB:business_master_new
loadtime:5.1426107883453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside Park' limit 1
loadtime:5.1426908969879 / seconds
Query Executed:select id FROM `nj` where city='Seaside Park' && SIC_code='7011'DB:business_master_new
loadtime:5.1456019878387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Secaucus' limit 1
loadtime:5.1456527709961 / seconds
Query Executed:select id FROM `nj` where city='Secaucus' && SIC_code='7011'DB:business_master_new
loadtime:5.1477768421173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeantsville' limit 1
loadtime:5.1478319168091 / seconds
Query Executed:select id FROM `nj` where city='Sergeantsville' && SIC_code='7011'DB:business_master_new
loadtime:5.1601948738098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sewaren' limit 1
loadtime:5.1602449417114 / seconds
Query Executed:select id FROM `nj` where city='Sewaren' && SIC_code='7011'DB:business_master_new
loadtime:5.1781158447266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sewell' limit 1
loadtime:5.1781578063965 / seconds
Query Executed:select id FROM `nj` where city='Sewell' && SIC_code='7011'DB:business_master_new
loadtime:5.1799778938293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shamong' limit 1
loadtime:5.1800229549408 / seconds
Query Executed:select id FROM `nj` where city='Shamong' && SIC_code='7011'DB:business_master_new
loadtime:5.182119846344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:5.1821599006653 / seconds
Query Executed:select id FROM `nj` where city='Shiloh' && SIC_code='7011'DB:business_master_new
loadtime:5.1956298351288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ship Bottom' limit 1
loadtime:5.1958818435669 / seconds
Query Executed:select id FROM `nj` where city='Ship Bottom' && SIC_code='7011'DB:business_master_new
loadtime:5.201887845993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Short Hills' limit 1
loadtime:5.2019469738007 / seconds
Query Executed:select id FROM `nj` where city='Short Hills' && SIC_code='7011'DB:business_master_new
loadtime:5.2054147720337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:5.2054688930511 / seconds
Query Executed:select id FROM `nj` where city='Shrewsbury' && SIC_code='7011'DB:business_master_new
loadtime:5.2079467773438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sicklerville' limit 1
loadtime:5.2079949378967 / seconds
Query Executed:select id FROM `nj` where city='Sicklerville' && SIC_code='7011'DB:business_master_new
loadtime:5.2095379829407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skillman' limit 1
loadtime:5.2095928192139 / seconds
Query Executed:select id FROM `nj` where city='Skillman' && SIC_code='7011'DB:business_master_new
loadtime:5.2109048366547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:5.2109649181366 / seconds
Query Executed:select id FROM `nj` where city='Smithville' && SIC_code='7011'DB:business_master_new
loadtime:5.2140038013458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerdale' limit 1
loadtime:5.2140498161316 / seconds
Query Executed:select id FROM `nj` where city='Somerdale' && SIC_code='7011'DB:business_master_new
loadtime:5.215322971344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers Point' limit 1
loadtime:5.2153708934784 / seconds
Query Executed:select id FROM `nj` where city='Somers Point' && SIC_code='7011'DB:business_master_new
loadtime:5.2170929908752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:5.2171549797058 / seconds
Query Executed:select id FROM `nj` where city='Somerset' && SIC_code='7011'DB:business_master_new
loadtime:5.2196459770203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:5.2197158336639 / seconds
Query Executed:select id FROM `nj` where city='Somerville' && SIC_code='7011'DB:business_master_new
loadtime:5.2220678329468 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amboy' limit 1
loadtime:5.2221319675446 / seconds
Query Executed:select id FROM `nj` where city='South Amboy' && SIC_code='7011'DB:business_master_new
loadtime:5.2236649990082 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Bound Brook' limit 1
loadtime:5.223709821701 / seconds
Query Executed:select id FROM `nj` where city='South Bound Brook' && SIC_code='7011'DB:business_master_new
loadtime:5.2248618602753 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:5.2249088287354 / seconds
Query Executed:select id FROM `nj` where city='South Dennis' && SIC_code='7011'DB:business_master_new
loadtime:5.2316589355469 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hackensack' limit 1
loadtime:5.2317168712616 / seconds
Query Executed:select id FROM `nj` where city='South Hackensack' && SIC_code='7011'DB:business_master_new
loadtime:5.2332019805908 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orange' limit 1
loadtime:5.2332479953766 / seconds
Query Executed:select id FROM `nj` where city='South Orange' && SIC_code='7011'DB:business_master_new
loadtime:5.2349488735199 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Plainfield' limit 1
loadtime:5.2350058555603 / seconds
Query Executed:select id FROM `nj` where city='South Plainfield' && SIC_code='7011'DB:business_master_new
loadtime:5.2372009754181 / seconds
Query loaded from cache:select * from geodata_geocity where city='South River' limit 1
loadtime:5.2372598648071 / seconds
Query Executed:select id FROM `nj` where city='South River' && SIC_code='7011'DB:business_master_new
loadtime:5.2386929988861 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Seaville' limit 1
loadtime:5.2390828132629 / seconds
Query Executed:select id FROM `nj` where city='South Seaville' && SIC_code='7011'DB:business_master_new
loadtime:5.2556879520416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:5.2558069229126 / seconds
Query Executed:select id FROM `nj` where city='Southampton' && SIC_code='7011'DB:business_master_new
loadtime:5.2611677646637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:5.261207818985 / seconds
Query Executed:select id FROM `nj` where city='Sparta' && SIC_code='7011'DB:business_master_new
loadtime:5.2665019035339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotswood' limit 1
loadtime:5.2665719985962 / seconds
Query Executed:select id FROM `nj` where city='Spotswood' && SIC_code='7011'DB:business_master_new
loadtime:5.2679178714752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:5.2679889202118 / seconds
Query Executed:select id FROM `nj` where city='Spring Lake' && SIC_code='7011'DB:business_master_new
loadtime:5.2700397968292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:5.2701709270477 / seconds
Query Executed:select id FROM `nj` where city='Springfield' && SIC_code='7011'DB:business_master_new
loadtime:5.2731788158417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:5.2733569145203 / seconds
Query Executed:select id FROM `nj` where city='Stanhope' && SIC_code='7011'DB:business_master_new
loadtime:5.2764809131622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:5.2765378952026 / seconds
Query Executed:select id FROM `nj` where city='Stanton' && SIC_code='7011'DB:business_master_new
loadtime:5.2963008880615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartsville' limit 1
loadtime:5.2963488101959 / seconds
Query Executed:select id FROM `nj` where city='Stewartsville' && SIC_code='7011'DB:business_master_new
loadtime:5.2985799312592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stillwater' limit 1
loadtime:5.2986559867859 / seconds
Query Executed:select id FROM `nj` where city='Stillwater' && SIC_code='7011'DB:business_master_new
loadtime:5.3138048648834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stirling' limit 1
loadtime:5.3138489723206 / seconds
Query Executed:select id FROM `nj` where city='Stirling' && SIC_code='7011'DB:business_master_new
loadtime:5.3161108493805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:5.3161549568176 / seconds
Query Executed:select id FROM `nj` where city='Stockholm' && SIC_code='7011'DB:business_master_new
loadtime:5.3454399108887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:5.3454868793488 / seconds
Query Executed:select id FROM `nj` where city='Stockton' && SIC_code='7011'DB:business_master_new
loadtime:5.3467779159546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Harbor' limit 1
loadtime:5.3468279838562 / seconds
Query Executed:select id FROM `nj` where city='Stone Harbor' && SIC_code='7011'DB:business_master_new
loadtime:5.348140001297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:5.3481888771057 / seconds
Query Executed:select id FROM `nj` where city='Stratford' && SIC_code='7011'DB:business_master_new
loadtime:5.3494358062744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strathmere' limit 1
loadtime:5.3494729995728 / seconds
Query Executed:select id FROM `nj` where city='Strathmere' && SIC_code='7011'DB:business_master_new
loadtime:5.3539958000183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Succasunna' limit 1
loadtime:5.3540439605713 / seconds
Query Executed:select id FROM `nj` where city='Succasunna' && SIC_code='7011'DB:business_master_new
loadtime:5.3554558753967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:5.3554928302765 / seconds
Query Executed:select id FROM `nj` where city='Summit' && SIC_code='7011'DB:business_master_new
loadtime:5.3574469089508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:5.357489824295 / seconds
Query Executed:select id FROM `nj` where city='Surf City' && SIC_code='7011'DB:business_master_new
loadtime:5.3609998226166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:5.3610458374023 / seconds
Query Executed:select id FROM `nj` where city='Sussex' && SIC_code='7011'DB:business_master_new
loadtime:5.3626699447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartswood' limit 1
loadtime:5.3627188205719 / seconds
Query Executed:select id FROM `nj` where city='Swartswood' && SIC_code='7011'DB:business_master_new
loadtime:5.3682999610901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesboro' limit 1
loadtime:5.3683438301086 / seconds
Query Executed:select id FROM `nj` where city='Swedesboro' && SIC_code='7011'DB:business_master_new
loadtime:5.3698267936707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabernacle' limit 1
loadtime:5.3698728084564 / seconds
Query Executed:select id FROM `nj` where city='Tabernacle' && SIC_code='7011'DB:business_master_new
loadtime:5.3733458518982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaneck' limit 1
loadtime:5.3733868598938 / seconds
Query Executed:select id FROM `nj` where city='Teaneck' && SIC_code='7011'DB:business_master_new
loadtime:5.3756909370422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tenafly' limit 1
loadtime:5.3757379055023 / seconds
Query Executed:select id FROM `nj` where city='Tenafly' && SIC_code='7011'DB:business_master_new
loadtime:5.3772809505463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennent' limit 1
loadtime:5.3773219585419 / seconds
Query Executed:select id FROM `nj` where city='Tennent' && SIC_code='7011'DB:business_master_new
loadtime:5.3857388496399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teterboro' limit 1
loadtime:5.3857817649841 / seconds
Query Executed:select id FROM `nj` where city='Teterboro' && SIC_code='7011'DB:business_master_new
loadtime:5.3870089054108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorofare' limit 1
loadtime:5.3870508670807 / seconds
Query Executed:select id FROM `nj` where city='Thorofare' && SIC_code='7011'DB:business_master_new
loadtime:5.3883039951324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Bridges' limit 1
loadtime:5.3883488178253 / seconds
Query Executed:select id FROM `nj` where city='Three Bridges' && SIC_code='7011'DB:business_master_new
loadtime:5.4133088588715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinton Falls' limit 1
loadtime:5.4133608341217 / seconds
Query Executed:select id FROM `nj` where city='Tinton Falls' && SIC_code='7011'DB:business_master_new
loadtime:5.417662858963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titusville' limit 1
loadtime:5.4179108142853 / seconds
Query Executed:select id FROM `nj` where city='Titusville' && SIC_code='7011'DB:business_master_new
loadtime:5.4540169239044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms River' limit 1
loadtime:5.4540829658508 / seconds
Query Executed:select id FROM `nj` where city='Toms River' && SIC_code='7011'DB:business_master_new
loadtime:5.4583718776703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Totowa' limit 1
loadtime:5.4584379196167 / seconds
Query Executed:select id FROM `nj` where city='Totowa' && SIC_code='7011'DB:business_master_new
loadtime:5.4601008892059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towaco' limit 1
loadtime:5.4601449966431 / seconds
Query Executed:select id FROM `nj` where city='Towaco' && SIC_code='7011'DB:business_master_new
loadtime:5.461327791214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Township Of Washington' limit 1
loadtime:5.4613659381866 / seconds
Query Executed:select id FROM `nj` where city='Township Of Washington' && SIC_code='7011'DB:business_master_new
loadtime:5.463211774826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tranquility' limit 1
loadtime:5.4633409976959 / seconds
Query Executed:select id FROM `nj` where city='Tranquility' && SIC_code='7011'DB:business_master_new
loadtime:5.4702439308167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:5.470291852951 / seconds
Query Executed:select id FROM `nj` where city='Trenton' && SIC_code='7011'DB:business_master_new
loadtime:5.4784278869629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckahoe' limit 1
loadtime:5.4785399436951 / seconds
Query Executed:select id FROM `nj` where city='Tuckahoe' && SIC_code='7011'DB:business_master_new
loadtime:5.4950268268585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckerton' limit 1
loadtime:5.49507188797 / seconds
Query Executed:select id FROM `nj` where city='Tuckerton' && SIC_code='7011'DB:business_master_new
loadtime:5.4966487884521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersville' limit 1
loadtime:5.4966969490051 / seconds
Query Executed:select id FROM `nj` where city='Turnersville' && SIC_code='7011'DB:business_master_new
loadtime:5.5119848251343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:5.5120339393616 / seconds
Query Executed:select id FROM `nj` where city='Union' && SIC_code='7011'DB:business_master_new
loadtime:5.5146698951721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Beach' limit 1
loadtime:5.5147149562836 / seconds
Query Executed:select id FROM `nj` where city='Union Beach' && SIC_code='7011'DB:business_master_new
loadtime:5.517951965332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:5.5179917812347 / seconds
Query Executed:select id FROM `nj` where city='Union City' && SIC_code='7011'DB:business_master_new
loadtime:5.5204658508301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upper Saddle Rvr' limit 1
loadtime:5.5205109119415 / seconds
Query Executed:select id FROM `nj` where city='Upper Saddle Rvr' && SIC_code='7011'DB:business_master_new
loadtime:5.5216047763824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vauxhall' limit 1
loadtime:5.5216457843781 / seconds
Query Executed:select id FROM `nj` where city='Vauxhall' && SIC_code='7011'DB:business_master_new
loadtime:5.5227828025818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventnor City' limit 1
loadtime:5.5228209495544 / seconds
Query Executed:select id FROM `nj` where city='Ventnor City' && SIC_code='7011'DB:business_master_new
loadtime:5.5242748260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:5.5243108272552 / seconds
Query Executed:select id FROM `nj` where city='Vernon' && SIC_code='7011'DB:business_master_new
loadtime:5.5257239341736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:5.5257709026337 / seconds
Query Executed:select id FROM `nj` where city='Verona' && SIC_code='7011'DB:business_master_new
loadtime:5.5274038314819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:5.5274548530579 / seconds
Query Executed:select id FROM `nj` where city='Vienna' && SIC_code='7011'DB:business_master_new
loadtime:5.5380408763885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villas' limit 1
loadtime:5.5380909442902 / seconds
Query Executed:select id FROM `nj` where city='Villas' && SIC_code='7011'DB:business_master_new
loadtime:5.5393228530884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincentown' limit 1
loadtime:5.5393698215485 / seconds
Query Executed:select id FROM `nj` where city='Vincentown' && SIC_code='7011'DB:business_master_new
loadtime:5.5410628318787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineland' limit 1
loadtime:5.5411088466644 / seconds
Query Executed:select id FROM `nj` where city='Vineland' && SIC_code='7011'DB:business_master_new
loadtime:5.5439538955688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voorhees' limit 1
loadtime:5.544017791748 / seconds
Query Executed:select id FROM `nj` where city='Voorhees' && SIC_code='7011'DB:business_master_new
loadtime:5.5461149215698 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Collingswd Hts' limit 1
loadtime:5.5461709499359 / seconds
Query Executed:select id FROM `nj` where city='W Collingswd Hts' && SIC_code='7011'DB:business_master_new
loadtime:5.5465137958527 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Collingswood' limit 1
loadtime:5.5465588569641 / seconds
Query Executed:select id FROM `nj` where city='W Collingswood' && SIC_code='7011'DB:business_master_new
loadtime:5.547287940979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldwick' limit 1
loadtime:5.5473279953003 / seconds
Query Executed:select id FROM `nj` where city='Waldwick' && SIC_code='7011'DB:business_master_new
loadtime:5.5487139225006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:5.5487489700317 / seconds
Query Executed:select id FROM `nj` where city='Wall' && SIC_code='7011'DB:business_master_new
loadtime:5.5832169055939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Township' limit 1
loadtime:5.5832788944244 / seconds
Query Executed:select id FROM `nj` where city='Wall Township' && SIC_code='7011'DB:business_master_new
loadtime:5.5912568569183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallington' limit 1
loadtime:5.5912888050079 / seconds
Query Executed:select id FROM `nj` where city='Wallington' && SIC_code='7011'DB:business_master_new
loadtime:5.5925920009613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallpack Center' limit 1
loadtime:5.5926299095154 / seconds
Query Executed:select id FROM `nj` where city='Wallpack Center' && SIC_code='7011'DB:business_master_new
loadtime:5.5971238613129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanaque' limit 1
loadtime:5.5971548557281 / seconds
Query Executed:select id FROM `nj` where city='Wanaque' && SIC_code='7011'DB:business_master_new
loadtime:5.5983319282532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waretown' limit 1
loadtime:5.5983698368073 / seconds
Query Executed:select id FROM `nj` where city='Waretown' && SIC_code='7011'DB:business_master_new
loadtime:5.5996298789978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:5.5996809005737 / seconds
Query Executed:select id FROM `nj` where city='Warren' && SIC_code='7011'DB:business_master_new
loadtime:5.6012949943542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:5.6013379096985 / seconds
Query Executed:select id FROM `nj` where city='Washington' && SIC_code='7011'DB:business_master_new
loadtime:5.6028549671173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Twp' limit 1
loadtime:5.6033279895782 / seconds
Query Executed:select id FROM `nj` where city='Washington Twp' && SIC_code='7011'DB:business_master_new
loadtime:5.629222869873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watchung' limit 1
loadtime:5.6292579174042 / seconds
Query Executed:select id FROM `nj` where city='Watchung' && SIC_code='7011'DB:business_master_new
loadtime:5.6306807994843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford Works' limit 1
loadtime:5.6307289600372 / seconds
Query Executed:select id FROM `nj` where city='Waterford Works' && SIC_code='7011'DB:business_master_new
loadtime:5.658252954483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:5.6582989692688 / seconds
Query Executed:select id FROM `nj` where city='Wayne' && SIC_code='7011'DB:business_master_new
loadtime:5.6612157821655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weehawken' limit 1
loadtime:5.6612589359283 / seconds
Query Executed:select id FROM `nj` where city='Weehawken' && SIC_code='7011'DB:business_master_new
loadtime:5.6625969409943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenonah' limit 1
loadtime:5.6626439094543 / seconds
Query Executed:select id FROM `nj` where city='Wenonah' && SIC_code='7011'DB:business_master_new
loadtime:5.6638059616089 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Berlin' limit 1
loadtime:5.6638388633728 / seconds
Query Executed:select id FROM `nj` where city='West Berlin' && SIC_code='7011'DB:business_master_new
loadtime:5.6652278900146 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Caldwell' limit 1
loadtime:5.6652719974518 / seconds
Query Executed:select id FROM `nj` where city='West Caldwell' && SIC_code='7011'DB:business_master_new
loadtime:5.6708679199219 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cape May' limit 1
loadtime:5.6708979606628 / seconds
Query Executed:select id FROM `nj` where city='West Cape May' && SIC_code='7011'DB:business_master_new
loadtime:5.6720368862152 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Creek' limit 1
loadtime:5.6720747947693 / seconds
Query Executed:select id FROM `nj` where city='West Creek' && SIC_code='7011'DB:business_master_new
loadtime:5.6732659339905 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Long Branch' limit 1
loadtime:5.6733088493347 / seconds
Query Executed:select id FROM `nj` where city='West Long Branch' && SIC_code='7011'DB:business_master_new
loadtime:5.674754858017 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Milford' limit 1
loadtime:5.6747899055481 / seconds
Query Executed:select id FROM `nj` where city='West Milford' && SIC_code='7011'DB:business_master_new
loadtime:5.6762669086456 / seconds
Query loaded from cache:select * from geodata_geocity where city='West New York' limit 1
loadtime:5.6763088703156 / seconds
Query Executed:select id FROM `nj` where city='West New York' && SIC_code='7011'DB:business_master_new
loadtime:5.6784868240356 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Orange' limit 1
loadtime:5.6785128116608 / seconds
Query Executed:select id FROM `nj` where city='West Orange' && SIC_code='7011'DB:business_master_new
loadtime:5.6811258792877 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Paterson' limit 1
loadtime:5.6811709403992 / seconds
Query Executed:select id FROM `nj` where city='West Paterson' && SIC_code='7011'DB:business_master_new
loadtime:5.687805891037 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Trenton' limit 1
loadtime:5.6878409385681 / seconds
Query Executed:select id FROM `nj` where city='West Trenton' && SIC_code='7011'DB:business_master_new
loadtime:5.6914579868317 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wildwood' limit 1
loadtime:5.6914999485016 / seconds
Query Executed:select id FROM `nj` where city='West Wildwood' && SIC_code='7011'DB:business_master_new
loadtime:5.6918199062347 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:5.6918468475342 / seconds
Query Executed:select id FROM `nj` where city='West Windsor' && SIC_code='7011'DB:business_master_new
loadtime:5.6950659751892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westampton' limit 1
loadtime:5.695102930069 / seconds
Query Executed:select id FROM `nj` where city='Westampton' && SIC_code='7011'DB:business_master_new
loadtime:5.6974029541016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:5.697438955307 / seconds
Query Executed:select id FROM `nj` where city='Westfield' && SIC_code='7011'DB:business_master_new
loadtime:5.6995739936829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmont' limit 1
loadtime:5.6996068954468 / seconds
Query Executed:select id FROM `nj` where city='Westmont' && SIC_code='7011'DB:business_master_new
loadtime:5.7055149078369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:5.7055568695068 / seconds
Query Executed:select id FROM `nj` where city='Westville' && SIC_code='7011'DB:business_master_new
loadtime:5.7068319320679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:5.7068657875061 / seconds
Query Executed:select id FROM `nj` where city='Westwood' && SIC_code='7011'DB:business_master_new
loadtime:5.708878993988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wharton' limit 1
loadtime:5.7089188098907 / seconds
Query Executed:select id FROM `nj` where city='Wharton' && SIC_code='7011'DB:business_master_new
loadtime:5.7111539840698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whippany' limit 1
loadtime:5.7112698554993 / seconds
Query Executed:select id FROM `nj` where city='Whippany' && SIC_code='7011'DB:business_master_new
loadtime:5.7151229381561 / seconds
Query loaded from cache:select * from geodata_geocity where city='White House Station' limit 1
loadtime:5.7152848243713 / seconds
Query Executed:select id FROM `nj` where city='White House Station' && SIC_code='7011'DB:business_master_new
loadtime:5.7160499095917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse' limit 1
loadtime:5.7160999774933 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse' && SIC_code='7011'DB:business_master_new
loadtime:5.7187678813934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse Sta' limit 1
loadtime:5.7188849449158 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse Sta' && SIC_code='7011'DB:business_master_new
loadtime:5.7211618423462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse Station' limit 1
loadtime:5.7212109565735 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse Station' && SIC_code='7011'DB:business_master_new
loadtime:5.7247598171234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitesboro' limit 1
loadtime:5.7248787879944 / seconds
Query Executed:select id FROM `nj` where city='Whitesboro' && SIC_code='7011'DB:business_master_new
loadtime:5.7295877933502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:5.7296350002289 / seconds
Query Executed:select id FROM `nj` where city='Whiting' && SIC_code='7011'DB:business_master_new
loadtime:5.7358958721161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickatunk' limit 1
loadtime:5.7359459400177 / seconds
Query Executed:select id FROM `nj` where city='Wickatunk' && SIC_code='7011'DB:business_master_new
loadtime:5.7432289123535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wildwood' limit 1
loadtime:5.7432768344879 / seconds
Query Executed:select id FROM `nj` where city='Wildwood' && SIC_code='7011'DB:business_master_new
loadtime:5.7489328384399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wildwood Crest' limit 1
loadtime:5.7492079734802 / seconds
Query Executed:select id FROM `nj` where city='Wildwood Crest' && SIC_code='7011'DB:business_master_new
loadtime:5.7527618408203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:5.7528238296509 / seconds
Query Executed:select id FROM `nj` where city='Williamstown' && SIC_code='7011'DB:business_master_new
loadtime:5.7547149658203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willingboro' limit 1
loadtime:5.754763841629 / seconds
Query Executed:select id FROM `nj` where city='Willingboro' && SIC_code='7011'DB:business_master_new
loadtime:5.7574808597565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:5.7575368881226 / seconds
Query Executed:select id FROM `nj` where city='Windsor' && SIC_code='7011'DB:business_master_new
loadtime:5.7821497917175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield Park' limit 1
loadtime:5.7822098731995 / seconds
Query Executed:select id FROM `nj` where city='Winfield Park' && SIC_code='7011'DB:business_master_new
loadtime:5.7827749252319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:5.782851934433 / seconds
Query Executed:select id FROM `nj` where city='Winslow' && SIC_code='7011'DB:business_master_new
loadtime:5.805083990097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood Ridge' limit 1
loadtime:5.8051419258118 / seconds
Query Executed:select id FROM `nj` where city='Wood Ridge' && SIC_code='7011'DB:business_master_new
loadtime:5.8064239025116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood-Ridge' limit 1
loadtime:5.8064589500427 / seconds
Query Executed:select id FROM `nj` where city='Wood-Ridge' && SIC_code='7011'DB:business_master_new
loadtime:5.8070228099823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:5.8070597648621 / seconds
Query Executed:select id FROM `nj` where city='Woodbine' && SIC_code='7011'DB:business_master_new
loadtime:5.8083307743073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:5.8083739280701 / seconds
Query Executed:select id FROM `nj` where city='Woodbridge' && SIC_code='7011'DB:business_master_new
loadtime:5.8103759288788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:5.8104209899902 / seconds
Query Executed:select id FROM `nj` where city='Woodbury' && SIC_code='7011'DB:business_master_new
loadtime:5.8125858306885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury Heights' limit 1
loadtime:5.812618970871 / seconds
Query Executed:select id FROM `nj` where city='Woodbury Heights' && SIC_code='7011'DB:business_master_new
loadtime:5.8137679100037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodcliff Lake' limit 1
loadtime:5.8138039112091 / seconds
Query Executed:select id FROM `nj` where city='Woodcliff Lake' && SIC_code='7011'DB:business_master_new
loadtime:5.8151409626007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstown' limit 1
loadtime:5.8151738643646 / seconds
Query Executed:select id FROM `nj` where city='Woodstown' && SIC_code='7011'DB:business_master_new
loadtime:5.816526889801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightstown' limit 1
loadtime:5.8165678977966 / seconds
Query Executed:select id FROM `nj` where city='Wrightstown' && SIC_code='7011'DB:business_master_new
loadtime:5.8178777694702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyckoff' limit 1
loadtime:5.817932844162 / seconds
Query Executed:select id FROM `nj` where city='Wyckoff' && SIC_code='7011'DB:business_master_new
loadtime:5.8195109367371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yardville' limit 1
loadtime:5.8195359706879 / seconds
Query Executed:select id FROM `nj` where city='Yardville' && SIC_code='7011'DB:business_master_new
loadtime:5.823145866394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zarephath' limit 1
loadtime:5.8231899738312 / seconds
Query Executed:select id FROM `nj` where city='Zarephath' && SIC_code='7011'DB:business_master_new
loadtime:5.824521780014 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:5.8245987892151 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:5.8247947692871 / seconds
Operation template executed (chunk cache operation)
loadtime:5.824866771698 / seconds
template override:Default
loadtime:5.82488489151 / 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:5.825591802597 / seconds
Template Constructed, Array Rows:49
loadtime:5.8258287906647 / seconds
TOTAL EXECUTION TIME: 5.82563
loadtime:5.8259439468384 / 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] => hotels-and-motels [stateURLid] => new-jersey )


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