Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.7962875366211E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018219947814941 / seconds
host not found setting manual db connection
loadtime:0.0095720291137695 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.009814977645874 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010030031204224 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010098934173584 / seconds
zipcode:
loadtime:0.010127067565918 / seconds
Query Executed:select * from search_referrer where page_hash='cd8a25b4a5c3c57c8133adc0175699f7' limit 10 DB:ezrox_toadli
loadtime:0.010394096374512 / seconds
Operation header executed (non global)
loadtime:0.010427951812744 / seconds
Operation leaderboard executed (non global)
loadtime:0.010487079620361 / seconds
Operation square executed (non global)
loadtime:0.010517120361328 / seconds
Operation square_bottom executed (non global)
loadtime:0.010545015335083 / seconds
Operation smallsquare executed (non global)
loadtime:0.010571002960205 / seconds
Operation headeradright executed (non global)
loadtime:0.010607957839966 / seconds
Operation google_analytics executed (non global)
loadtime:0.010637044906616 / seconds
Operation topstories executed (non global)
loadtime:0.010663032531738 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010689973831177 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010715007781982 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.01098895072937 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011213064193726 / seconds
Operation categories executed (global stored into APC)
loadtime:0.01124906539917 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011309146881104 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011358976364136 / seconds
Template key: archive_menu pushed
loadtime:0.011367082595825 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011381149291992 / seconds
Template key: get_gravatar pushed
loadtime:0.011388063430786 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011396169662476 / seconds
*10)-10)+1 | start:0
loadtime:0.011440992355347 / seconds
Query loaded from cache:select * from categories where cat_URLid='veterinary-services-for-animal-specialties'
loadtime:0.01148796081543 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-jersey'
loadtime:0.01152515411377 / seconds
DB connected to localhost business_master_new
loadtime:0.011789083480835 / seconds
Query Executed:select * from `nj_catmap` where sic='0742' order by city ascDB:business_master_new
loadtime:0.016736030578613 / seconds
Query stored in cache : _QUERY_www.toadli.comdbc18ff363194d60318659a01138c717
loadtime:0.019500970840454 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-jersey'
loadtime:0.019566059112549 / seconds
Query Executed:select sum(totalcount) as totalsum from `nj_catmap` where sic='0742'DB:business_master_new
loadtime:0.023182153701782 / seconds
Query stored in cache : _QUERY_www.toadli.comae42f8e975c9fe44dbe29edcdc5aecd6
loadtime:0.023218154907227 / seconds
696 / 11
loadtime:0.023273944854736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Absecon' limit 1
loadtime:0.023339986801147 / seconds
Query Executed:select id FROM `nj` where city='Absecon' && SIC_code='0742'DB:business_master_new
loadtime:0.044319152832031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adelphia' limit 1
loadtime:0.044398069381714 / seconds
Query Executed:select id FROM `nj` where city='Adelphia' && SIC_code='0742'DB:business_master_new
loadtime:0.045482158660889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allamuchy' limit 1
loadtime:0.045536994934082 / seconds
Query Executed:select id FROM `nj` where city='Allamuchy' && SIC_code='0742'DB:business_master_new
loadtime:0.046894073486328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.046946048736572 / seconds
Query Executed:select id FROM `nj` where city='Allendale' && SIC_code='0742'DB:business_master_new
loadtime:0.053122043609619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenhurst' limit 1
loadtime:0.053190946578979 / seconds
Query Executed:select id FROM `nj` where city='Allenhurst' && SIC_code='0742'DB:business_master_new
loadtime:0.055629968643188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allentown' limit 1
loadtime:0.055685997009277 / seconds
Query Executed:select id FROM `nj` where city='Allentown' && SIC_code='0742'DB:business_master_new
loadtime:0.061119079589844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenwood' limit 1
loadtime:0.061192989349365 / seconds
Query Executed:select id FROM `nj` where city='Allenwood' && SIC_code='0742'DB:business_master_new
loadtime:0.062915086746216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alloway' limit 1
loadtime:0.062984943389893 / seconds
Query Executed:select id FROM `nj` where city='Alloway' && SIC_code='0742'DB:business_master_new
loadtime:0.064258098602295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.064325094223022 / seconds
Query Executed:select id FROM `nj` where city='Alpha' && SIC_code='0742'DB:business_master_new
loadtime:0.064835071563721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.064890146255493 / seconds
Query Executed:select id FROM `nj` where city='Alpine' && SIC_code='0742'DB:business_master_new
loadtime:0.066715955734253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.066781997680664 / seconds
Query Executed:select id FROM `nj` where city='Andover' && SIC_code='0742'DB:business_master_new
loadtime:0.072741031646729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.072816133499146 / seconds
Query Executed:select id FROM `nj` where city='Annandale' && SIC_code='0742'DB:business_master_new
loadtime:0.077758073806763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury' limit 1
loadtime:0.07782506942749 / seconds
Query Executed:select id FROM `nj` where city='Asbury' && SIC_code='0742'DB:business_master_new
loadtime:0.081079006195068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury Park' limit 1
loadtime:0.081135034561157 / seconds
Query Executed:select id FROM `nj` where city='Asbury Park' && SIC_code='0742'DB:business_master_new
loadtime:0.089967012405396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atco' limit 1
loadtime:0.090038061141968 / seconds
Query Executed:select id FROM `nj` where city='Atco' && SIC_code='0742'DB:business_master_new
loadtime:0.095339059829712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic City' limit 1
loadtime:0.095406055450439 / seconds
Query Executed:select id FROM `nj` where city='Atlantic City' && SIC_code='0742'DB:business_master_new
loadtime:0.10361409187317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Hghlnds' limit 1
loadtime:0.10367012023926 / seconds
Query Executed:select id FROM `nj` where city='Atlantic Hghlnds' && SIC_code='0742'DB:business_master_new
loadtime:0.10456299781799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Highlands' limit 1
loadtime:0.10462594032288 / seconds
Query Executed:select id FROM `nj` where city='Atlantic Highlands' && SIC_code='0742'DB:business_master_new
loadtime:0.11216497421265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.11223316192627 / seconds
Query Executed:select id FROM `nj` where city='Audubon' && SIC_code='0742'DB:business_master_new
loadtime:0.11739206314087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.11746597290039 / seconds
Query Executed:select id FROM `nj` where city='Augusta' && SIC_code='0742'DB:business_master_new
loadtime:0.11960601806641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.11967396736145 / seconds
Query Executed:select id FROM `nj` where city='Avalon' && SIC_code='0742'DB:business_master_new
loadtime:0.12487602233887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avenel' limit 1
loadtime:0.12493014335632 / seconds
Query Executed:select id FROM `nj` where city='Avenel' && SIC_code='0742'DB:business_master_new
loadtime:0.13286900520325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon By The Sea' limit 1
loadtime:0.1329391002655 / seconds
Query Executed:select id FROM `nj` where city='Avon By The Sea' && SIC_code='0742'DB:business_master_new
loadtime:0.13548398017883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baptistown' limit 1
loadtime:0.13553905487061 / seconds
Query Executed:select id FROM `nj` where city='Baptistown' && SIC_code='0742'DB:business_master_new
loadtime:0.13636112213135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnegat' limit 1
loadtime:0.13641405105591 / seconds
Query Executed:select id FROM `nj` where city='Barnegat' && SIC_code='0742'DB:business_master_new
loadtime:0.1467649936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnegat Light' limit 1
loadtime:0.14683604240417 / seconds
Query Executed:select id FROM `nj` where city='Barnegat Light' && SIC_code='0742'DB:business_master_new
loadtime:0.14894199371338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:0.14899706840515 / seconds
Query Executed:select id FROM `nj` where city='Barrington' && SIC_code='0742'DB:business_master_new
loadtime:0.15222907066345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basking Ridge' limit 1
loadtime:0.15228295326233 / seconds
Query Executed:select id FROM `nj` where city='Basking Ridge' && SIC_code='0742'DB:business_master_new
loadtime:0.16473698616028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Head' limit 1
loadtime:0.16480708122253 / seconds
Query Executed:select id FROM `nj` where city='Bay Head' && SIC_code='0742'DB:business_master_new
loadtime:0.16625213623047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayonne' limit 1
loadtime:0.16630697250366 / seconds
Query Executed:select id FROM `nj` where city='Bayonne' && SIC_code='0742'DB:business_master_new
loadtime:0.1750111579895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayville' limit 1
loadtime:0.17510414123535 / seconds
Query Executed:select id FROM `nj` where city='Bayville' && SIC_code='0742'DB:business_master_new
loadtime:0.18588995933533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beach Haven' limit 1
loadtime:0.18597507476807 / seconds
Query Executed:select id FROM `nj` where city='Beach Haven' && SIC_code='0742'DB:business_master_new
loadtime:0.20013499259949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beachwood' limit 1
loadtime:0.20025706291199 / seconds
Query Executed:select id FROM `nj` where city='Beachwood' && SIC_code='0742'DB:business_master_new
loadtime:0.20475196838379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedminster' limit 1
loadtime:0.20483994483948 / seconds
Query Executed:select id FROM `nj` where city='Bedminster' && SIC_code='0742'DB:business_master_new
loadtime:0.21223306655884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belford' limit 1
loadtime:0.21234011650085 / seconds
Query Executed:select id FROM `nj` where city='Belford' && SIC_code='0742'DB:business_master_new
loadtime:0.21553301811218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Mead' limit 1
loadtime:0.21565103530884 / seconds
Query Executed:select id FROM `nj` where city='Belle Mead' && SIC_code='0742'DB:business_master_new
loadtime:0.22188496589661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:0.22199296951294 / seconds
Query Executed:select id FROM `nj` where city='Belleville' && SIC_code='0742'DB:business_master_new
loadtime:0.24015116691589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellmawr' limit 1
loadtime:0.24023413658142 / seconds
Query Executed:select id FROM `nj` where city='Bellmawr' && SIC_code='0742'DB:business_master_new
loadtime:0.24669194221497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmar' limit 1
loadtime:0.24676108360291 / seconds
Query Executed:select id FROM `nj` where city='Belmar' && SIC_code='0742'DB:business_master_new
loadtime:0.25551104545593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.25558114051819 / seconds
Query Executed:select id FROM `nj` where city='Belvidere' && SIC_code='0742'DB:business_master_new
loadtime:0.26157116889954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergenfield' limit 1
loadtime:0.26163601875305 / seconds
Query Executed:select id FROM `nj` where city='Bergenfield' && SIC_code='0742'DB:business_master_new
loadtime:0.27620697021484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkeley Heights' limit 1
loadtime:0.27627897262573 / seconds
Query Executed:select id FROM `nj` where city='Berkeley Heights' && SIC_code='0742'DB:business_master_new
loadtime:0.28528904914856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.2853569984436 / seconds
Query Executed:select id FROM `nj` where city='Berlin' && SIC_code='0742'DB:business_master_new
loadtime:0.2969069480896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardsville' limit 1
loadtime:0.29696297645569 / seconds
Query Executed:select id FROM `nj` where city='Bernardsville' && SIC_code='0742'DB:business_master_new
loadtime:0.30632710456848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:0.30639696121216 / seconds
Query Executed:select id FROM `nj` where city='Beverly' && SIC_code='0742'DB:business_master_new
loadtime:0.31102895736694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.31108403205872 / seconds
Query Executed:select id FROM `nj` where city='Birmingham' && SIC_code='0742'DB:business_master_new
loadtime:0.31172204017639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwood' limit 1
loadtime:0.31178402900696 / seconds
Query Executed:select id FROM `nj` where city='Blackwood' && SIC_code='0742'DB:business_master_new
loadtime:0.33438801765442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:0.33449411392212 / seconds
Query Executed:select id FROM `nj` where city='Blairstown' && SIC_code='0742'DB:business_master_new
loadtime:0.34252595901489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blawenburg' limit 1
loadtime:0.34261798858643 / seconds
Query Executed:select id FROM `nj` where city='Blawenburg' && SIC_code='0742'DB:business_master_new
loadtime:0.34319996833801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.34326910972595 / seconds
Query Executed:select id FROM `nj` where city='Bloomfield' && SIC_code='0742'DB:business_master_new
loadtime:0.35197496414185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:0.35205698013306 / seconds
Query Executed:select id FROM `nj` where city='Bloomingdale' && SIC_code='0742'DB:business_master_new
loadtime:0.35663795471191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomsbury' limit 1
loadtime:0.35671615600586 / seconds
Query Executed:select id FROM `nj` where city='Bloomsbury' && SIC_code='0742'DB:business_master_new
loadtime:0.35914206504822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bogota' limit 1
loadtime:0.35920405387878 / seconds
Query Executed:select id FROM `nj` where city='Bogota' && SIC_code='0742'DB:business_master_new
loadtime:0.36415600776672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonton' limit 1
loadtime:0.36421895027161 / seconds
Query Executed:select id FROM `nj` where city='Boonton' && SIC_code='0742'DB:business_master_new
loadtime:0.37700796127319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bordentown' limit 1
loadtime:0.37709212303162 / seconds
Query Executed:select id FROM `nj` where city='Bordentown' && SIC_code='0742'DB:business_master_new
loadtime:0.38809704780579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bound Brook' limit 1
loadtime:0.38818216323853 / seconds
Query Executed:select id FROM `nj` where city='Bound Brook' && SIC_code='0742'DB:business_master_new
loadtime:0.39686799049377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley Beach' limit 1
loadtime:0.39694809913635 / seconds
Query Executed:select id FROM `nj` where city='Bradley Beach' && SIC_code='0742'DB:business_master_new
loadtime:0.4004430770874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchburg' limit 1
loadtime:0.4005069732666 / seconds
Query Executed:select id FROM `nj` where city='Branchburg' && SIC_code='0742'DB:business_master_new
loadtime:0.40119814872742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.40125894546509 / seconds
Query Executed:select id FROM `nj` where city='Branchville' && SIC_code='0742'DB:business_master_new
loadtime:0.4076361656189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brick' limit 1
loadtime:0.4077160358429 / seconds
Query Executed:select id FROM `nj` where city='Brick' && SIC_code='0742'DB:business_master_new
loadtime:0.41635394096375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.41645407676697 / seconds
Query Executed:select id FROM `nj` where city='Bridgeport' && SIC_code='0742'DB:business_master_new
loadtime:0.41826105117798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:0.41832494735718 / seconds
Query Executed:select id FROM `nj` where city='Bridgeton' && SIC_code='0742'DB:business_master_new
loadtime:0.43919897079468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.43928599357605 / seconds
Query Executed:select id FROM `nj` where city='Bridgewater' && SIC_code='0742'DB:business_master_new
loadtime:0.44772410392761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brielle' limit 1
loadtime:0.44781112670898 / seconds
Query Executed:select id FROM `nj` where city='Brielle' && SIC_code='0742'DB:business_master_new
loadtime:0.45275211334229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brigantine' limit 1
loadtime:0.45283198356628 / seconds
Query Executed:select id FROM `nj` where city='Brigantine' && SIC_code='0742'DB:business_master_new
loadtime:0.45957803726196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.45966601371765 / seconds
Query Executed:select id FROM `nj` where city='Broadway' && SIC_code='0742'DB:business_master_new
loadtime:0.46044516563416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklawn' limit 1
loadtime:0.46051216125488 / seconds
Query Executed:select id FROM `nj` where city='Brooklawn' && SIC_code='0742'DB:business_master_new
loadtime:0.46106696128845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookside' limit 1
loadtime:0.4611279964447 / seconds
Query Executed:select id FROM `nj` where city='Brookside' && SIC_code='0742'DB:business_master_new
loadtime:0.4621901512146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Mills' limit 1
loadtime:0.46225214004517 / seconds
Query Executed:select id FROM `nj` where city='Browns Mills' && SIC_code='0742'DB:business_master_new
loadtime:0.46830201148987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Budd Lake' limit 1
loadtime:0.46838712692261 / seconds
Query Executed:select id FROM `nj` where city='Budd Lake' && SIC_code='0742'DB:business_master_new
loadtime:0.47646713256836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena' limit 1
loadtime:0.47654700279236 / seconds
Query Executed:select id FROM `nj` where city='Buena' && SIC_code='0742'DB:business_master_new
loadtime:0.47850394248962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.47856712341309 / seconds
Query Executed:select id FROM `nj` where city='Burlington' && SIC_code='0742'DB:business_master_new
loadtime:0.49918103218079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.49926805496216 / seconds
Query Executed:select id FROM `nj` where city='Butler' && SIC_code='0742'DB:business_master_new
loadtime:0.51321816444397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buttzville' limit 1
loadtime:0.51330995559692 / seconds
Query Executed:select id FROM `nj` where city='Buttzville' && SIC_code='0742'DB:business_master_new
loadtime:0.51403999328613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caldwell' limit 1
loadtime:0.51410412788391 / seconds
Query Executed:select id FROM `nj` where city='Caldwell' && SIC_code='0742'DB:business_master_new
loadtime:0.53690695762634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Califon' limit 1
loadtime:0.53699898719788 / seconds
Query Executed:select id FROM `nj` where city='Califon' && SIC_code='0742'DB:business_master_new
loadtime:0.54355096817017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.54364705085754 / seconds
Query Executed:select id FROM `nj` where city='Camden' && SIC_code='0742'DB:business_master_new
loadtime:0.55232810974121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May' limit 1
loadtime:0.55240607261658 / seconds
Query Executed:select id FROM `nj` where city='Cape May' && SIC_code='0742'DB:business_master_new
loadtime:0.56970715522766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Court House' limit 1
loadtime:0.56979012489319 / seconds
Query Executed:select id FROM `nj` where city='Cape May Court House' && SIC_code='0742'DB:business_master_new
loadtime:0.58495903015137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Ct Hse' limit 1
loadtime:0.58504605293274 / seconds
Query Executed:select id FROM `nj` where city='Cape May Ct Hse' && SIC_code='0742'DB:business_master_new
loadtime:0.58658504486084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Point' limit 1
loadtime:0.58666110038757 / seconds
Query Executed:select id FROM `nj` where city='Cape May Point' && SIC_code='0742'DB:business_master_new
loadtime:0.58753514289856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlstadt' limit 1
loadtime:0.58760714530945 / seconds
Query Executed:select id FROM `nj` where city='Carlstadt' && SIC_code='0742'DB:business_master_new
loadtime:0.59885907173157 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carneys Point' limit 1
loadtime:0.59893798828125 / seconds
Query Executed:select id FROM `nj` where city='Carneys Point' && SIC_code='0742'DB:business_master_new
loadtime:0.59963703155518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carteret' limit 1
loadtime:0.59969902038574 / seconds
Query Executed:select id FROM `nj` where city='Carteret' && SIC_code='0742'DB:business_master_new
loadtime:0.60789799690247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Brook' limit 1
loadtime:0.60797500610352 / seconds
Query Executed:select id FROM `nj` where city='Cedar Brook' && SIC_code='0742'DB:business_master_new
loadtime:0.60920810699463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:0.6092700958252 / seconds
Query Executed:select id FROM `nj` where city='Cedar Grove' && SIC_code='0742'DB:business_master_new
loadtime:0.61875605583191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Knolls' limit 1
loadtime:0.61883401870728 / seconds
Query Executed:select id FROM `nj` where city='Cedar Knolls' && SIC_code='0742'DB:business_master_new
loadtime:0.62424111366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:0.6243200302124 / seconds
Query Executed:select id FROM `nj` where city='Cedarville' && SIC_code='0742'DB:business_master_new
loadtime:0.62576603889465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Changewater' limit 1
loadtime:0.62582802772522 / seconds
Query Executed:select id FROM `nj` where city='Changewater' && SIC_code='0742'DB:business_master_new
loadtime:0.62636399269104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.62642598152161 / seconds
Query Executed:select id FROM `nj` where city='Chatham' && SIC_code='0742'DB:business_master_new
loadtime:0.63899207115173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:0.63906908035278 / seconds
Query Executed:select id FROM `nj` where city='Chatsworth' && SIC_code='0742'DB:business_master_new
loadtime:0.64009714126587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Hill' limit 1
loadtime:0.64016008377075 / seconds
Query Executed:select id FROM `nj` where city='Cherry Hill' && SIC_code='0742'DB:business_master_new
loadtime:0.64883494377136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesilhurst' limit 1
loadtime:0.64892911911011 / seconds
Query Executed:select id FROM `nj` where city='Chesilhurst' && SIC_code='0742'DB:business_master_new
loadtime:0.64941000938416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.64947915077209 / seconds
Query Executed:select id FROM `nj` where city='Chester' && SIC_code='0742'DB:business_master_new
loadtime:0.66175413131714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cinnaminson' limit 1
loadtime:0.66183400154114 / seconds
Query Executed:select id FROM `nj` where city='Cinnaminson' && SIC_code='0742'DB:business_master_new
loadtime:0.66313910484314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:0.66320204734802 / seconds
Query Executed:select id FROM `nj` where city='Clark' && SIC_code='0742'DB:business_master_new
loadtime:0.67555093765259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksboro' limit 1
loadtime:0.67564105987549 / seconds
Query Executed:select id FROM `nj` where city='Clarksboro' && SIC_code='0742'DB:business_master_new
loadtime:0.67728209495544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:0.67734408378601 / seconds
Query Executed:select id FROM `nj` where city='Clarksburg' && SIC_code='0742'DB:business_master_new
loadtime:0.67796611785889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.67804193496704 / seconds
Query Executed:select id FROM `nj` where city='Clayton' && SIC_code='0742'DB:business_master_new
loadtime:0.68108201026917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clementon' limit 1
loadtime:0.68116116523743 / seconds
Query Executed:select id FROM `nj` where city='Clementon' && SIC_code='0742'DB:business_master_new
loadtime:0.69624710083008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside Park' limit 1
loadtime:0.69633603096008 / seconds
Query Executed:select id FROM `nj` where city='Cliffside Park' && SIC_code='0742'DB:business_master_new
loadtime:0.70888710021973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffwood' limit 1
loadtime:0.70896506309509 / seconds
Query Executed:select id FROM `nj` where city='Cliffwood' && SIC_code='0742'DB:business_master_new
loadtime:0.71097707748413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:0.7110390663147 / seconds
Query Executed:select id FROM `nj` where city='Clifton' && SIC_code='0742'DB:business_master_new
loadtime:0.7196741104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.71976113319397 / seconds
Query Executed:select id FROM `nj` where city='Clinton' && SIC_code='0742'DB:business_master_new
loadtime:0.73070597648621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Closter' limit 1
loadtime:0.73078894615173 / seconds
Query Executed:select id FROM `nj` where city='Closter' && SIC_code='0742'DB:business_master_new
loadtime:0.74079513549805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collingswood' limit 1
loadtime:0.74087500572205 / seconds
Query Executed:select id FROM `nj` where city='Collingswood' && SIC_code='0742'DB:business_master_new
loadtime:0.75283408164978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:0.75291395187378 / seconds
Query Executed:select id FROM `nj` where city='Cologne' && SIC_code='0742'DB:business_master_new
loadtime:0.75415706634521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonia' limit 1
loadtime:0.75423407554626 / seconds
Query Executed:select id FROM `nj` where city='Colonia' && SIC_code='0742'DB:business_master_new
loadtime:0.76062607765198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colts Neck' limit 1
loadtime:0.76068997383118 / seconds
Query Executed:select id FROM `nj` where city='Colts Neck' && SIC_code='0742'DB:business_master_new
loadtime:0.76961493492126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.769700050354 / seconds
Query Executed:select id FROM `nj` where city='Columbia' && SIC_code='0742'DB:business_master_new
loadtime:0.7724871635437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:0.77254915237427 / seconds
Query Executed:select id FROM `nj` where city='Columbus' && SIC_code='0742'DB:business_master_new
loadtime:0.7771270275116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Convent Station' limit 1
loadtime:0.77720713615417 / seconds
Query Executed:select id FROM `nj` where city='Convent Station' && SIC_code='0742'DB:business_master_new
loadtime:0.77818512916565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cookstown' limit 1
loadtime:0.7782609462738 / seconds
Query Executed:select id FROM `nj` where city='Cookstown' && SIC_code='0742'DB:business_master_new
loadtime:0.77943205833435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin City' limit 1
loadtime:0.77950811386108 / seconds
Query Executed:select id FROM `nj` where city='Corbin City' && SIC_code='0742'DB:business_master_new
loadtime:0.78004908561707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranbury' limit 1
loadtime:0.78011202812195 / seconds
Query Executed:select id FROM `nj` where city='Cranbury' && SIC_code='0742'DB:business_master_new
loadtime:0.79139399528503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranford' limit 1
loadtime:0.79149508476257 / seconds
Query Executed:select id FROM `nj` where city='Cranford' && SIC_code='0742'DB:business_master_new
loadtime:0.8108069896698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cream Ridge' limit 1
loadtime:0.81090211868286 / seconds
Query Executed:select id FROM `nj` where city='Cream Ridge' && SIC_code='0742'DB:business_master_new
loadtime:0.81416416168213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creamridge' limit 1
loadtime:0.81424999237061 / seconds
Query Executed:select id FROM `nj` where city='Creamridge' && SIC_code='0742'DB:business_master_new
loadtime:0.81472015380859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresskill' limit 1
loadtime:0.81478309631348 / seconds
Query Executed:select id FROM `nj` where city='Cresskill' && SIC_code='0742'DB:business_master_new
loadtime:0.82100200653076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosswicks' limit 1
loadtime:0.82108116149902 / seconds
Query Executed:select id FROM `nj` where city='Crosswicks' && SIC_code='0742'DB:business_master_new
loadtime:0.82170510292053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:0.82176804542542 / seconds
Query Executed:select id FROM `nj` where city='Dayton' && SIC_code='0742'DB:business_master_new
loadtime:0.82858610153198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deal' limit 1
loadtime:0.82865905761719 / seconds
Query Executed:select id FROM `nj` where city='Deal' && SIC_code='0742'DB:business_master_new
loadtime:0.8315269947052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deepwater' limit 1
loadtime:0.83159494400024 / seconds
Query Executed:select id FROM `nj` where city='Deepwater' && SIC_code='0742'DB:business_master_new
loadtime:0.83241295814514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield Street' limit 1
loadtime:0.83246803283691 / seconds
Query Executed:select id FROM `nj` where city='Deerfield Street' && SIC_code='0742'DB:business_master_new
loadtime:0.83321213722229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Del Haven' limit 1
loadtime:0.83326506614685 / seconds
Query Executed:select id FROM `nj` where city='Del Haven' && SIC_code='0742'DB:business_master_new
loadtime:0.83386301994324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delair' limit 1
loadtime:0.83391714096069 / seconds
Query Executed:select id FROM `nj` where city='Delair' && SIC_code='0742'DB:business_master_new
loadtime:0.83452701568604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delanco' limit 1
loadtime:0.83458304405212 / seconds
Query Executed:select id FROM `nj` where city='Delanco' && SIC_code='0742'DB:business_master_new
loadtime:0.83535313606262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:0.83540511131287 / seconds
Query Executed:select id FROM `nj` where city='Delaware' && SIC_code='0742'DB:business_master_new
loadtime:0.83643412590027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:0.83648610115051 / seconds
Query Executed:select id FROM `nj` where city='Delmont' && SIC_code='0742'DB:business_master_new
loadtime:0.83728098869324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delran' limit 1
loadtime:0.83733415603638 / seconds
Query Executed:select id FROM `nj` where city='Delran' && SIC_code='0742'DB:business_master_new
loadtime:0.83832406997681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Demarest' limit 1
loadtime:0.8383891582489 / seconds
Query Executed:select id FROM `nj` where city='Demarest' && SIC_code='0742'DB:business_master_new
loadtime:0.8408989906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennisville' limit 1
loadtime:0.84095501899719 / seconds
Query Executed:select id FROM `nj` where city='Dennisville' && SIC_code='0742'DB:business_master_new
loadtime:0.84204816818237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denville' limit 1
loadtime:0.84210205078125 / seconds
Query Executed:select id FROM `nj` where city='Denville' && SIC_code='0742'DB:business_master_new
loadtime:0.86055016517639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deptford' limit 1
loadtime:0.86063694953918 / seconds
Query Executed:select id FROM `nj` where city='Deptford' && SIC_code='0742'DB:business_master_new
loadtime:0.86213493347168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dividing Creek' limit 1
loadtime:0.86219000816345 / seconds
Query Executed:select id FROM `nj` where city='Dividing Creek' && SIC_code='0742'DB:business_master_new
loadtime:0.86275696754456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.8628101348877 / seconds
Query Executed:select id FROM `nj` where city='Dorchester' && SIC_code='0742'DB:business_master_new
loadtime:0.86340713500977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorothy' limit 1
loadtime:0.86347007751465 / seconds
Query Executed:select id FROM `nj` where city='Dorothy' && SIC_code='0742'DB:business_master_new
loadtime:0.86458015441895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.8646399974823 / seconds
Query Executed:select id FROM `nj` where city='Dover' && SIC_code='0742'DB:business_master_new
loadtime:0.88120412826538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:0.88127303123474 / seconds
Query Executed:select id FROM `nj` where city='Dumont' && SIC_code='0742'DB:business_master_new
loadtime:0.89056515693665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunellen' limit 1
loadtime:0.8906409740448 / seconds
Query Executed:select id FROM `nj` where city='Dunellen' && SIC_code='0742'DB:business_master_new
loadtime:0.90244603157043 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brunswick' limit 1
loadtime:0.9025239944458 / seconds
Query Executed:select id FROM `nj` where city='East Brunswick' && SIC_code='0742'DB:business_master_new
loadtime:0.91121196746826 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hanover' limit 1
loadtime:0.91129207611084 / seconds
Query Executed:select id FROM `nj` where city='East Hanover' && SIC_code='0742'DB:business_master_new
loadtime:0.92671704292297 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Millstone' limit 1
loadtime:0.9267909526825 / seconds
Query Executed:select id FROM `nj` where city='East Millstone' && SIC_code='0742'DB:business_master_new
loadtime:0.92724609375 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Newark' limit 1
loadtime:0.92729997634888 / seconds
Query Executed:select id FROM `nj` where city='East Newark' && SIC_code='0742'DB:business_master_new
loadtime:0.92775893211365 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:0.92781209945679 / seconds
Query Executed:select id FROM `nj` where city='East Orange' && SIC_code='0742'DB:business_master_new
loadtime:0.93629503250122 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Rutherford' limit 1
loadtime:0.93636798858643 / seconds
Query Executed:select id FROM `nj` where city='East Rutherford' && SIC_code='0742'DB:business_master_new
loadtime:0.94670510292053 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.94677400588989 / seconds
Query Executed:select id FROM `nj` where city='East Windsor' && SIC_code='0742'DB:business_master_new
loadtime:0.94748210906982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eatontown' limit 1
loadtime:0.94753813743591 / seconds
Query Executed:select id FROM `nj` where city='Eatontown' && SIC_code='0742'DB:business_master_new
loadtime:0.96961402893066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:0.96969199180603 / seconds
Query Executed:select id FROM `nj` where city='Edgewater' && SIC_code='0742'DB:business_master_new
loadtime:0.97944402694702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater Park' limit 1
loadtime:0.9795229434967 / seconds
Query Executed:select id FROM `nj` where city='Edgewater Park' && SIC_code='0742'DB:business_master_new
loadtime:0.98006510734558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edison' limit 1
loadtime:0.98011898994446 / seconds
Query Executed:select id FROM `nj` where city='Edison' && SIC_code='0742'DB:business_master_new
loadtime:0.98861694335938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor City' limit 1
loadtime:0.98869204521179 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor City' && SIC_code='0742'DB:business_master_new
loadtime:0.99683904647827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor Township' limit 1
loadtime:0.99691009521484 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor Township' && SIC_code='0742'DB:business_master_new
loadtime:1.0175430774689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor Twp' limit 1
loadtime:1.0176291465759 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor Twp' && SIC_code='0742'DB:business_master_new
loadtime:1.0194699764252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:1.0195260047913 / seconds
Query Executed:select id FROM `nj` where city='Elizabeth' && SIC_code='0742'DB:business_master_new
loadtime:1.0279121398926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmer' limit 1
loadtime:1.0279791355133 / seconds
Query Executed:select id FROM `nj` where city='Elmer' && SIC_code='0742'DB:business_master_new
loadtime:1.036297082901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood Park' limit 1
loadtime:1.0363640785217 / seconds
Query Executed:select id FROM `nj` where city='Elmwood Park' && SIC_code='0742'DB:business_master_new
loadtime:1.0483779907227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:1.0484449863434 / seconds
Query Executed:select id FROM `nj` where city='Elwood' && SIC_code='0742'DB:business_master_new
loadtime:1.0494289398193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:1.0494921207428 / seconds
Query Executed:select id FROM `nj` where city='Emerson' && SIC_code='0742'DB:business_master_new
loadtime:1.0547721385956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:1.0548379421234 / seconds
Query Executed:select id FROM `nj` where city='Englewood' && SIC_code='0742'DB:business_master_new
loadtime:1.0631890296936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood Cliffs' limit 1
loadtime:1.0632569789886 / seconds
Query Executed:select id FROM `nj` where city='Englewood Cliffs' && SIC_code='0742'DB:business_master_new
loadtime:1.0773720741272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englishtown' limit 1
loadtime:1.0774421691895 / seconds
Query Executed:select id FROM `nj` where city='Englishtown' && SIC_code='0742'DB:business_master_new
loadtime:1.0857939720154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Fells' limit 1
loadtime:1.0858690738678 / seconds
Query Executed:select id FROM `nj` where city='Essex Fells' && SIC_code='0742'DB:business_master_new
loadtime:1.0873129367828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estell Manor' limit 1
loadtime:1.0873689651489 / seconds
Query Executed:select id FROM `nj` where city='Estell Manor' && SIC_code='0742'DB:business_master_new
loadtime:1.0885360240936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewan' limit 1
loadtime:1.0885889530182 / seconds
Query Executed:select id FROM `nj` where city='Ewan' && SIC_code='0742'DB:business_master_new
loadtime:1.0891909599304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:1.0892429351807 / seconds
Query Executed:select id FROM `nj` where city='Fair Haven' && SIC_code='0742'DB:business_master_new
loadtime:1.0944011211395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Lawn' limit 1
loadtime:1.0944809913635 / seconds
Query Executed:select id FROM `nj` where city='Fair Lawn' && SIC_code='0742'DB:business_master_new
loadtime:1.1028900146484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.1029601097107 / seconds
Query Executed:select id FROM `nj` where city='Fairfield' && SIC_code='0742'DB:business_master_new
loadtime:1.1111781597137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairton' limit 1
loadtime:1.1112520694733 / seconds
Query Executed:select id FROM `nj` where city='Fairton' && SIC_code='0742'DB:business_master_new
loadtime:1.1121251583099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.1121909618378 / seconds
Query Executed:select id FROM `nj` where city='Fairview' && SIC_code='0742'DB:business_master_new
loadtime:1.1207070350647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fanwood' limit 1
loadtime:1.1207630634308 / seconds
Query Executed:select id FROM `nj` where city='Fanwood' && SIC_code='0742'DB:business_master_new
loadtime:1.1251039505005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Far Hills' limit 1
loadtime:1.1251730918884 / seconds
Query Executed:select id FROM `nj` where city='Far Hills' && SIC_code='0742'DB:business_master_new
loadtime:1.128406047821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmingdale' limit 1
loadtime:1.1284821033478 / seconds
Query Executed:select id FROM `nj` where city='Farmingdale' && SIC_code='0742'DB:business_master_new
loadtime:1.1388969421387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldsboro' limit 1
loadtime:1.1389729976654 / seconds
Query Executed:select id FROM `nj` where city='Fieldsboro' && SIC_code='0742'DB:business_master_new
loadtime:1.1394181251526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagtown' limit 1
loadtime:1.1394829750061 / seconds
Query Executed:select id FROM `nj` where city='Flagtown' && SIC_code='0742'DB:business_master_new
loadtime:1.1401841640472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flanders' limit 1
loadtime:1.1402380466461 / seconds
Query Executed:select id FROM `nj` where city='Flanders' && SIC_code='0742'DB:business_master_new
loadtime:1.1488349437714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flemington' limit 1
loadtime:1.1489081382751 / seconds
Query Executed:select id FROM `nj` where city='Flemington' && SIC_code='0742'DB:business_master_new
loadtime:1.1798779964447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.1799600124359 / seconds
Query Executed:select id FROM `nj` where city='Florence' && SIC_code='0742'DB:business_master_new
loadtime:1.1828219890594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florham Park' limit 1
loadtime:1.1828920841217 / seconds
Query Executed:select id FROM `nj` where city='Florham Park' && SIC_code='0742'DB:business_master_new
loadtime:1.1964991092682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fords' limit 1
loadtime:1.1965539455414 / seconds
Query Executed:select id FROM `nj` where city='Fords' && SIC_code='0742'DB:business_master_new
loadtime:1.201514005661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forked River' limit 1
loadtime:1.201583147049 / seconds
Query Executed:select id FROM `nj` where city='Forked River' && SIC_code='0742'DB:business_master_new
loadtime:1.2142400741577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dix' limit 1
loadtime:1.2143111228943 / seconds
Query Executed:select id FROM `nj` where city='Fort Dix' && SIC_code='0742'DB:business_master_new
loadtime:1.215539932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Hancock' limit 1
loadtime:1.2155959606171 / seconds
Query Executed:select id FROM `nj` where city='Fort Hancock' && SIC_code='0742'DB:business_master_new
loadtime:1.2160739898682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:1.2161271572113 / seconds
Query Executed:select id FROM `nj` where city='Fort Lee' && SIC_code='0742'DB:business_master_new
loadtime:1.224977016449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monmouth' limit 1
loadtime:1.2250471115112 / seconds
Query Executed:select id FROM `nj` where city='Fort Monmouth' && SIC_code='0742'DB:business_master_new
loadtime:1.2262930870056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fortescue' limit 1
loadtime:1.2263481616974 / seconds
Query Executed:select id FROM `nj` where city='Fortescue' && SIC_code='0742'DB:business_master_new
loadtime:1.227077960968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.2271320819855 / seconds
Query Executed:select id FROM `nj` where city='Franklin' && SIC_code='0742'DB:business_master_new
loadtime:1.2334671020508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin Lakes' limit 1
loadtime:1.2335350513458 / seconds
Query Executed:select id FROM `nj` where city='Franklin Lakes' && SIC_code='0742'DB:business_master_new
loadtime:1.2428879737854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin Park' limit 1
loadtime:1.2429571151733 / seconds
Query Executed:select id FROM `nj` where city='Franklin Park' && SIC_code='0742'DB:business_master_new
loadtime:1.2462289333344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:1.2462849617004 / seconds
Query Executed:select id FROM `nj` where city='Franklinville' && SIC_code='0742'DB:business_master_new
loadtime:1.2513530254364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredon' limit 1
loadtime:1.2514071464539 / seconds
Query Executed:select id FROM `nj` where city='Fredon' && SIC_code='0742'DB:business_master_new
loadtime:1.2518751621246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freehold' limit 1
loadtime:1.2519280910492 / seconds
Query Executed:select id FROM `nj` where city='Freehold' && SIC_code='0742'DB:business_master_new
loadtime:1.2602310180664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frenchtown' limit 1
loadtime:1.2603170871735 / seconds
Query Executed:select id FROM `nj` where city='Frenchtown' && SIC_code='0742'DB:business_master_new
loadtime:1.265517950058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:1.2655889987946 / seconds
Query Executed:select id FROM `nj` where city='Galloway' && SIC_code='0742'DB:business_master_new
loadtime:1.2663719654083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:1.2664401531219 / seconds
Query Executed:select id FROM `nj` where city='Garfield' && SIC_code='0742'DB:business_master_new
loadtime:1.2808799743652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwood' limit 1
loadtime:1.280946969986 / seconds
Query Executed:select id FROM `nj` where city='Garwood' && SIC_code='0742'DB:business_master_new
loadtime:1.2852320671082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibbsboro' limit 1
loadtime:1.285285949707 / seconds
Query Executed:select id FROM `nj` where city='Gibbsboro' && SIC_code='0742'DB:business_master_new
loadtime:1.2883400917053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibbstown' limit 1
loadtime:1.2884061336517 / seconds
Query Executed:select id FROM `nj` where city='Gibbstown' && SIC_code='0742'DB:business_master_new
loadtime:1.2907841205597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillette' limit 1
loadtime:1.2908380031586 / seconds
Query Executed:select id FROM `nj` where city='Gillette' && SIC_code='0742'DB:business_master_new
loadtime:1.2934930324554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:1.2935600280762 / seconds
Query Executed:select id FROM `nj` where city='Gladstone' && SIC_code='0742'DB:business_master_new
loadtime:1.2955181598663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glassboro' limit 1
loadtime:1.2955720424652 / seconds
Query Executed:select id FROM `nj` where city='Glassboro' && SIC_code='0742'DB:business_master_new
loadtime:1.3054721355438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasser' limit 1
loadtime:1.3055379390717 / seconds
Query Executed:select id FROM `nj` where city='Glasser' && SIC_code='0742'DB:business_master_new
loadtime:1.3060231208801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Gardner' limit 1
loadtime:1.306077003479 / seconds
Query Executed:select id FROM `nj` where city='Glen Gardner' && SIC_code='0742'DB:business_master_new
loadtime:1.309690952301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Ridge' limit 1
loadtime:1.3097569942474 / seconds
Query Executed:select id FROM `nj` where city='Glen Ridge' && SIC_code='0742'DB:business_master_new
loadtime:1.3131129741669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Rock' limit 1
loadtime:1.3131799697876 / seconds
Query Executed:select id FROM `nj` where city='Glen Rock' && SIC_code='0742'DB:business_master_new
loadtime:1.3223750591278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:1.3224411010742 / seconds
Query Executed:select id FROM `nj` where city='Glendora' && SIC_code='0742'DB:business_master_new
loadtime:1.3248569965363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:1.3249220848083 / seconds
Query Executed:select id FROM `nj` where city='Glenwood' && SIC_code='0742'DB:business_master_new
loadtime:1.3262860774994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester City' limit 1
loadtime:1.3263399600983 / seconds
Query Executed:select id FROM `nj` where city='Gloucester City' && SIC_code='0742'DB:business_master_new
loadtime:1.3337099552155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:1.3337631225586 / seconds
Query Executed:select id FROM `nj` where city='Goshen' && SIC_code='0742'DB:business_master_new
loadtime:1.3343889713287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Meadows' limit 1
loadtime:1.3344399929047 / seconds
Query Executed:select id FROM `nj` where city='Great Meadows' && SIC_code='0742'DB:business_master_new
loadtime:1.337051153183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Brook' limit 1
loadtime:1.3371169567108 / seconds
Query Executed:select id FROM `nj` where city='Green Brook' && SIC_code='0742'DB:business_master_new
loadtime:1.3378450870514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Creek' limit 1
loadtime:1.3378989696503 / seconds
Query Executed:select id FROM `nj` where city='Green Creek' && SIC_code='0742'DB:business_master_new
loadtime:1.3389270305634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Village' limit 1
loadtime:1.3389811515808 / seconds
Query Executed:select id FROM `nj` where city='Green Village' && SIC_code='0742'DB:business_master_new
loadtime:1.340106010437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greendell' limit 1
loadtime:1.3401601314545 / seconds
Query Executed:select id FROM `nj` where city='Greendell' && SIC_code='0742'DB:business_master_new
loadtime:1.340861082077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:1.3409130573273 / seconds
Query Executed:select id FROM `nj` where city='Greenwich' && SIC_code='0742'DB:business_master_new
loadtime:1.3419799804688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenloch' limit 1
loadtime:1.3420341014862 / seconds
Query Executed:select id FROM `nj` where city='Grenloch' && SIC_code='0742'DB:business_master_new
loadtime:1.3426101207733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greystone Park' limit 1
loadtime:1.3426690101624 / seconds
Query Executed:select id FROM `nj` where city='Greystone Park' && SIC_code='0742'DB:business_master_new
loadtime:1.3431301116943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:1.3431811332703 / seconds
Query Executed:select id FROM `nj` where city='Guttenberg' && SIC_code='0742'DB:business_master_new
loadtime:1.3437240123749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackensack' limit 1
loadtime:1.3437769412994 / seconds
Query Executed:select id FROM `nj` where city='Hackensack' && SIC_code='0742'DB:business_master_new
loadtime:1.3525559902191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackettstown' limit 1
loadtime:1.3526251316071 / seconds
Query Executed:select id FROM `nj` where city='Hackettstown' && SIC_code='0742'DB:business_master_new
loadtime:1.3720080852509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddon Heights' limit 1
loadtime:1.3720810413361 / seconds
Query Executed:select id FROM `nj` where city='Haddon Heights' && SIC_code='0742'DB:business_master_new
loadtime:1.379191160202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddon Twp' limit 1
loadtime:1.3792591094971 / seconds
Query Executed:select id FROM `nj` where city='Haddon Twp' && SIC_code='0742'DB:business_master_new
loadtime:1.3797719478607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddonfield' limit 1
loadtime:1.3798270225525 / seconds
Query Executed:select id FROM `nj` where city='Haddonfield' && SIC_code='0742'DB:business_master_new
loadtime:1.3953990936279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hainesport' limit 1
loadtime:1.3954639434814 / seconds
Query Executed:select id FROM `nj` where city='Hainesport' && SIC_code='0742'DB:business_master_new
loadtime:1.4002830982208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haledon' limit 1
loadtime:1.4003541469574 / seconds
Query Executed:select id FROM `nj` where city='Haledon' && SIC_code='0742'DB:business_master_new
loadtime:1.4125089645386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:1.4125771522522 / seconds
Query Executed:select id FROM `nj` where city='Hamburg' && SIC_code='0742'DB:business_master_new
loadtime:1.4178991317749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammonton' limit 1
loadtime:1.4179670810699 / seconds
Query Executed:select id FROM `nj` where city='Hammonton' && SIC_code='0742'DB:business_master_new
loadtime:1.4360749721527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:1.4361510276794 / seconds
Query Executed:select id FROM `nj` where city='Hampton' && SIC_code='0742'DB:business_master_new
loadtime:1.4404730796814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancocks Bridge' limit 1
loadtime:1.4405429363251 / seconds
Query Executed:select id FROM `nj` where city='Hancocks Bridge' && SIC_code='0742'DB:business_master_new
loadtime:1.4413559436798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:1.4414110183716 / seconds
Query Executed:select id FROM `nj` where city='Hardwick' && SIC_code='0742'DB:business_master_new
loadtime:1.4418439865112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrington Park' limit 1
loadtime:1.4418959617615 / seconds
Query Executed:select id FROM `nj` where city='Harrington Park' && SIC_code='0742'DB:business_master_new
loadtime:1.4447009563446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:1.4447541236877 / seconds
Query Executed:select id FROM `nj` where city='Harrison' && SIC_code='0742'DB:business_master_new
loadtime:1.4556889533997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonville' limit 1
loadtime:1.4557430744171 / seconds
Query Executed:select id FROM `nj` where city='Harrisonville' && SIC_code='0742'DB:business_master_new
loadtime:1.4565019607544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey Cedars' limit 1
loadtime:1.4565539360046 / seconds
Query Executed:select id FROM `nj` where city='Harvey Cedars' && SIC_code='0742'DB:business_master_new
loadtime:1.4570679664612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasbrouck Heights' limit 1
loadtime:1.4571211338043 / seconds
Query Executed:select id FROM `nj` where city='Hasbrouck Heights' && SIC_code='0742'DB:business_master_new
loadtime:1.468435049057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasbrouck Hts' limit 1
loadtime:1.4685170650482 / seconds
Query Executed:select id FROM `nj` where city='Hasbrouck Hts' && SIC_code='0742'DB:business_master_new
loadtime:1.4692490100861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haskell' limit 1
loadtime:1.4693050384521 / seconds
Query Executed:select id FROM `nj` where city='Haskell' && SIC_code='0742'DB:business_master_new
loadtime:1.4717011451721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haworth' limit 1
loadtime:1.4717540740967 / seconds
Query Executed:select id FROM `nj` where city='Haworth' && SIC_code='0742'DB:business_master_new
loadtime:1.4742951393127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawthorne' limit 1
loadtime:1.4743480682373 / seconds
Query Executed:select id FROM `nj` where city='Hawthorne' && SIC_code='0742'DB:business_master_new
loadtime:1.4885170459747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlet' limit 1
loadtime:1.4885880947113 / seconds
Query Executed:select id FROM `nj` where city='Hazlet' && SIC_code='0742'DB:business_master_new
loadtime:1.5015561580658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heislerville' limit 1
loadtime:1.5016119480133 / seconds
Query Executed:select id FROM `nj` where city='Heislerville' && SIC_code='0742'DB:business_master_new
loadtime:1.502228975296 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helmetta' limit 1
loadtime:1.5022799968719 / seconds
Query Executed:select id FROM `nj` where city='Helmetta' && SIC_code='0742'DB:business_master_new
loadtime:1.5034010410309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewitt' limit 1
loadtime:1.5034630298615 / seconds
Query Executed:select id FROM `nj` where city='Hewitt' && SIC_code='0742'DB:business_master_new
loadtime:1.5088789463043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hibernia' limit 1
loadtime:1.5089480876923 / seconds
Query Executed:select id FROM `nj` where city='Hibernia' && SIC_code='0742'DB:business_master_new
loadtime:1.5097229480743 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Bridge' limit 1
loadtime:1.5097780227661 / seconds
Query Executed:select id FROM `nj` where city='High Bridge' && SIC_code='0742'DB:business_master_new
loadtime:1.5125050544739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Lakes' limit 1
loadtime:1.5125589370728 / seconds
Query Executed:select id FROM `nj` where city='Highland Lakes' && SIC_code='0742'DB:business_master_new
loadtime:1.5151009559631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:1.515153169632 / seconds
Query Executed:select id FROM `nj` where city='Highland Park' && SIC_code='0742'DB:business_master_new
loadtime:1.5249390602112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:1.5250079631805 / seconds
Query Executed:select id FROM `nj` where city='Highlands' && SIC_code='0742'DB:business_master_new
loadtime:1.5285260677338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightstown' limit 1
loadtime:1.5285811424255 / seconds
Query Executed:select id FROM `nj` where city='Hightstown' && SIC_code='0742'DB:business_master_new
loadtime:1.5374231338501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:1.5375030040741 / seconds
Query Executed:select id FROM `nj` where city='Hillsborough' && SIC_code='0742'DB:business_master_new
loadtime:1.5565969944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:1.5566799640656 / seconds
Query Executed:select id FROM `nj` where city='Hillsdale' && SIC_code='0742'DB:business_master_new
loadtime:1.5641491413116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillside' limit 1
loadtime:1.5642149448395 / seconds
Query Executed:select id FROM `nj` where city='Hillside' && SIC_code='0742'DB:business_master_new
loadtime:1.5767159461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ho Ho Kus' limit 1
loadtime:1.5767841339111 / seconds
Query Executed:select id FROM `nj` where city='Ho Ho Kus' && SIC_code='0742'DB:business_master_new
loadtime:1.5808601379395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoboken' limit 1
loadtime:1.5809280872345 / seconds
Query Executed:select id FROM `nj` where city='Hoboken' && SIC_code='0742'DB:business_master_new
loadtime:1.5895240306854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holmdel' limit 1
loadtime:1.589595079422 / seconds
Query Executed:select id FROM `nj` where city='Holmdel' && SIC_code='0742'DB:business_master_new
loadtime:1.6017370223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopatcong' limit 1
loadtime:1.6018061637878 / seconds
Query Executed:select id FROM `nj` where city='Hopatcong' && SIC_code='0742'DB:business_master_new
loadtime:1.6066319942474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:1.6066999435425 / seconds
Query Executed:select id FROM `nj` where city='Hope' && SIC_code='0742'DB:business_master_new
loadtime:1.6085650920868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:1.6086220741272 / seconds
Query Executed:select id FROM `nj` where city='Hopewell' && SIC_code='0742'DB:business_master_new
loadtime:1.6140811443329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:1.6141481399536 / seconds
Query Executed:select id FROM `nj` where city='Howell' && SIC_code='0742'DB:business_master_new
loadtime:1.6359419822693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlaystown' limit 1
loadtime:1.636018037796 / seconds
Query Executed:select id FROM `nj` where city='Imlaystown' && SIC_code='0742'DB:business_master_new
loadtime:1.6366169452667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlaken' limit 1
loadtime:1.6366751194 / seconds
Query Executed:select id FROM `nj` where city='Interlaken' && SIC_code='0742'DB:business_master_new
loadtime:1.6371059417725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironia' limit 1
loadtime:1.6371581554413 / seconds
Query Executed:select id FROM `nj` where city='Ironia' && SIC_code='0742'DB:business_master_new
loadtime:1.6381680965424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:1.6382350921631 / seconds
Query Executed:select id FROM `nj` where city='Irvington' && SIC_code='0742'DB:business_master_new
loadtime:1.6606841087341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iselin' limit 1
loadtime:1.6607501506805 / seconds
Query Executed:select id FROM `nj` where city='Iselin' && SIC_code='0742'DB:business_master_new
loadtime:1.67427110672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Heights' limit 1
loadtime:1.6743409633636 / seconds
Query Executed:select id FROM `nj` where city='Island Heights' && SIC_code='0742'DB:business_master_new
loadtime:1.6764400005341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.6765029430389 / seconds
Query Executed:select id FROM `nj` where city='Jackson' && SIC_code='0742'DB:business_master_new
loadtime:1.6987600326538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesburg' limit 1
loadtime:1.6988370418549 / seconds
Query Executed:select id FROM `nj` where city='Jamesburg' && SIC_code='0742'DB:business_master_new
loadtime:1.7002379894257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey City' limit 1
loadtime:1.7002940177917 / seconds
Query Executed:select id FROM `nj` where city='Jersey City' && SIC_code='0742'DB:business_master_new
loadtime:1.7091851234436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jobstown' limit 1
loadtime:1.7092549800873 / seconds
Query Executed:select id FROM `nj` where city='Jobstown' && SIC_code='0742'DB:business_master_new
loadtime:1.7103409767151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonburg' limit 1
loadtime:1.7103950977325 / seconds
Query Executed:select id FROM `nj` where city='Johnsonburg' && SIC_code='0742'DB:business_master_new
loadtime:1.7110769748688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juliustown' limit 1
loadtime:1.7111301422119 / seconds
Query Executed:select id FROM `nj` where city='Juliustown' && SIC_code='0742'DB:business_master_new
loadtime:1.7117609977722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keansburg' limit 1
loadtime:1.7118151187897 / seconds
Query Executed:select id FROM `nj` where city='Keansburg' && SIC_code='0742'DB:business_master_new
loadtime:1.7168569564819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:1.7169101238251 / seconds
Query Executed:select id FROM `nj` where city='Kearny' && SIC_code='0742'DB:business_master_new
loadtime:1.739305973053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keasbey' limit 1
loadtime:1.7393791675568 / seconds
Query Executed:select id FROM `nj` where city='Keasbey' && SIC_code='0742'DB:business_master_new
loadtime:1.740786075592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall Park' limit 1
loadtime:1.7408421039581 / seconds
Query Executed:select id FROM `nj` where city='Kendall Park' && SIC_code='0742'DB:business_master_new
loadtime:1.7456631660461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:1.7457311153412 / seconds
Query Executed:select id FROM `nj` where city='Kenilworth' && SIC_code='0742'DB:business_master_new
loadtime:1.7560160160065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenvil' limit 1
loadtime:1.7560880184174 / seconds
Query Executed:select id FROM `nj` where city='Kenvil' && SIC_code='0742'DB:business_master_new
loadtime:1.759083032608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keyport' limit 1
loadtime:1.7591390609741 / seconds
Query Executed:select id FROM `nj` where city='Keyport' && SIC_code='0742'DB:business_master_new
loadtime:1.7709579467773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:1.771026134491 / seconds
Query Executed:select id FROM `nj` where city='Kingston' && SIC_code='0742'DB:business_master_new
loadtime:1.7729480266571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinnelon' limit 1
loadtime:1.7730021476746 / seconds
Query Executed:select id FROM `nj` where city='Kinnelon' && SIC_code='0742'DB:business_master_new
loadtime:1.7737431526184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:1.773796081543 / seconds
Query Executed:select id FROM `nj` where city='Lafayette' && SIC_code='0742'DB:business_master_new
loadtime:1.7779710292816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Hiawatha' limit 1
loadtime:1.7780251502991 / seconds
Query Executed:select id FROM `nj` where city='Lake Hiawatha' && SIC_code='0742'DB:business_master_new
loadtime:1.782261133194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Hopatcong' limit 1
loadtime:1.782329082489 / seconds
Query Executed:select id FROM `nj` where city='Lake Hopatcong' && SIC_code='0742'DB:business_master_new
loadtime:1.7887749671936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakehurst' limit 1
loadtime:1.78884100914 / seconds
Query Executed:select id FROM `nj` where city='Lakehurst' && SIC_code='0742'DB:business_master_new
loadtime:1.7923290729523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:1.792384147644 / seconds
Query Executed:select id FROM `nj` where city='Lakewood' && SIC_code='0742'DB:business_master_new
loadtime:1.8010020256042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:1.8010749816895 / seconds
Query Executed:select id FROM `nj` where city='Lambertville' && SIC_code='0742'DB:business_master_new
loadtime:1.8100171089172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landing' limit 1
loadtime:1.8100881576538 / seconds
Query Executed:select id FROM `nj` where city='Landing' && SIC_code='0742'DB:business_master_new
loadtime:1.8141839504242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landisville' limit 1
loadtime:1.8142530918121 / seconds
Query Executed:select id FROM `nj` where city='Landisville' && SIC_code='0742'DB:business_master_new
loadtime:1.8155710697174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanoka Harbor' limit 1
loadtime:1.8156311511993 / seconds
Query Executed:select id FROM `nj` where city='Lanoka Harbor' && SIC_code='0742'DB:business_master_new
loadtime:1.8203539848328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:1.8204219341278 / seconds
Query Executed:select id FROM `nj` where city='Laurel Springs' && SIC_code='0742'DB:business_master_new
loadtime:1.8212380409241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurence Harbor' limit 1
loadtime:1.8212940692902 / seconds
Query Executed:select id FROM `nj` where city='Laurence Harbor' && SIC_code='0742'DB:business_master_new
loadtime:1.8219649791718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lavallette' limit 1
loadtime:1.8220191001892 / seconds
Query Executed:select id FROM `nj` where city='Lavallette' && SIC_code='0742'DB:business_master_new
loadtime:1.8255770206451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawnside' limit 1
loadtime:1.8256349563599 / seconds
Query Executed:select id FROM `nj` where city='Lawnside' && SIC_code='0742'DB:business_master_new
loadtime:1.8273839950562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:1.8274390697479 / seconds
Query Executed:select id FROM `nj` where city='Lawrenceville' && SIC_code='0742'DB:business_master_new
loadtime:1.8298871517181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:1.829952955246 / seconds
Query Executed:select id FROM `nj` where city='Layton' && SIC_code='0742'DB:business_master_new
loadtime:1.8307449817657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:1.8307981491089 / seconds
Query Executed:select id FROM `nj` where city='Lebanon' && SIC_code='0742'DB:business_master_new
loadtime:1.8405530452728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledgewood' limit 1
loadtime:1.840626001358 / seconds
Query Executed:select id FROM `nj` where city='Ledgewood' && SIC_code='0742'DB:business_master_new
loadtime:1.8457520008087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds Point' limit 1
loadtime:1.8458199501038 / seconds
Query Executed:select id FROM `nj` where city='Leeds Point' && SIC_code='0742'DB:business_master_new
loadtime:1.8463859558105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:1.8464381694794 / seconds
Query Executed:select id FROM `nj` where city='Leesburg' && SIC_code='0742'DB:business_master_new
loadtime:1.8472440242767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonardo' limit 1
loadtime:1.8472969532013 / seconds
Query Executed:select id FROM `nj` where city='Leonardo' && SIC_code='0742'DB:business_master_new
loadtime:1.8494279384613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonia' limit 1
loadtime:1.8494911193848 / seconds
Query Executed:select id FROM `nj` where city='Leonia' && SIC_code='0742'DB:business_master_new
loadtime:1.856124162674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Corner' limit 1
loadtime:1.8561799526215 / seconds
Query Executed:select id FROM `nj` where city='Liberty Corner' && SIC_code='0742'DB:business_master_new
loadtime:1.8577251434326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:1.8577780723572 / seconds
Query Executed:select id FROM `nj` where city='Lincoln Park' && SIC_code='0742'DB:business_master_new
loadtime:1.8647389411926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincroft' limit 1
loadtime:1.8648099899292 / seconds
Query Executed:select id FROM `nj` where city='Lincroft' && SIC_code='0742'DB:business_master_new
loadtime:1.8689880371094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.8690421581268 / seconds
Query Executed:select id FROM `nj` where city='Linden' && SIC_code='0742'DB:business_master_new
loadtime:1.894602060318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindenwold' limit 1
loadtime:1.8946630954742 / seconds
Query Executed:select id FROM `nj` where city='Lindenwold' && SIC_code='0742'DB:business_master_new
loadtime:1.895359992981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:1.8954110145569 / seconds
Query Executed:select id FROM `nj` where city='Linwood' && SIC_code='0742'DB:business_master_new
loadtime:1.9043910503387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Egg Hbr' limit 1
loadtime:1.90447306633 / seconds
Query Executed:select id FROM `nj` where city='Little Egg Hbr' && SIC_code='0742'DB:business_master_new
loadtime:1.9050321578979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Falls' limit 1
loadtime:1.9050869941711 / seconds
Query Executed:select id FROM `nj` where city='Little Falls' && SIC_code='0742'DB:business_master_new
loadtime:1.9247140884399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Ferry' limit 1
loadtime:1.9248051643372 / seconds
Query Executed:select id FROM `nj` where city='Little Ferry' && SIC_code='0742'DB:business_master_new
loadtime:1.9329500198364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Silver' limit 1
loadtime:1.933009147644 / seconds
Query Executed:select id FROM `nj` where city='Little Silver' && SIC_code='0742'DB:business_master_new
loadtime:1.9389519691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little York' limit 1
loadtime:1.9390230178833 / seconds
Query Executed:select id FROM `nj` where city='Little York' && SIC_code='0742'DB:business_master_new
loadtime:1.9394900798798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:1.9395439624786 / seconds
Query Executed:select id FROM `nj` where city='Livingston' && SIC_code='0742'DB:business_master_new
loadtime:1.9481921195984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodi' limit 1
loadtime:1.9482610225677 / seconds
Query Executed:select id FROM `nj` where city='Lodi' && SIC_code='0742'DB:business_master_new
loadtime:1.9604520797729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:1.9605231285095 / seconds
Query Executed:select id FROM `nj` where city='Long Beach' && SIC_code='0742'DB:business_master_new
loadtime:1.9609849452972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach Twp' limit 1
loadtime:1.9610409736633 / seconds
Query Executed:select id FROM `nj` where city='Long Beach Twp' && SIC_code='0742'DB:business_master_new
loadtime:1.9615290164948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Branch' limit 1
loadtime:1.9615840911865 / seconds
Query Executed:select id FROM `nj` where city='Long Branch' && SIC_code='0742'DB:business_master_new
loadtime:1.9810690879822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:1.9811379909515 / seconds
Query Executed:select id FROM `nj` where city='Long Valley' && SIC_code='0742'DB:business_master_new
loadtime:1.9891769886017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longport' limit 1
loadtime:1.9892511367798 / seconds
Query Executed:select id FROM `nj` where city='Longport' && SIC_code='0742'DB:business_master_new
loadtime:1.9908051490784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:1.9908590316772 / seconds
Query Executed:select id FROM `nj` where city='Lumberton' && SIC_code='0742'DB:business_master_new
loadtime:1.9975669384003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:1.9976241588593 / seconds
Query Executed:select id FROM `nj` where city='Lyndhurst' && SIC_code='0742'DB:business_master_new
loadtime:2.0153291225433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:2.0154039859772 / seconds
Query Executed:select id FROM `nj` where city='Lyons' && SIC_code='0742'DB:business_master_new
loadtime:2.0159871578217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:2.0160400867462 / seconds
Query Executed:select id FROM `nj` where city='Madison' && SIC_code='0742'DB:business_master_new
loadtime:2.028687953949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:2.0287611484528 / seconds
Query Executed:select id FROM `nj` where city='Magnolia' && SIC_code='0742'DB:business_master_new
loadtime:2.03125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mahwah' limit 1
loadtime:2.0313060283661 / seconds
Query Executed:select id FROM `nj` where city='Mahwah' && SIC_code='0742'DB:business_master_new
loadtime:2.048201084137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:2.0482881069183 / seconds
Query Executed:select id FROM `nj` where city='Malaga' && SIC_code='0742'DB:business_master_new
loadtime:2.04984998703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manahawkin' limit 1
loadtime:2.0499069690704 / seconds
Query Executed:select id FROM `nj` where city='Manahawkin' && SIC_code='0742'DB:business_master_new
loadtime:2.0648331642151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manalapan' limit 1
loadtime:2.0649061203003 / seconds
Query Executed:select id FROM `nj` where city='Manalapan' && SIC_code='0742'DB:business_master_new
loadtime:2.0670509338379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manasquan' limit 1
loadtime:2.0671219825745 / seconds
Query Executed:select id FROM `nj` where city='Manasquan' && SIC_code='0742'DB:business_master_new
loadtime:2.082337141037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:2.082405090332 / seconds
Query Executed:select id FROM `nj` where city='Manchester' && SIC_code='0742'DB:business_master_new
loadtime:2.0830931663513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Township' limit 1
loadtime:2.0831480026245 / seconds
Query Executed:select id FROM `nj` where city='Manchester Township' && SIC_code='0742'DB:business_master_new
loadtime:2.0919470787048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantoloking' limit 1
loadtime:2.0920209884644 / seconds
Query Executed:select id FROM `nj` where city='Mantoloking' && SIC_code='0742'DB:business_master_new
loadtime:2.0933120250702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:2.093367099762 / seconds
Query Executed:select id FROM `nj` where city='Mantua' && SIC_code='0742'DB:business_master_new
loadtime:2.0971331596375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manville' limit 1
loadtime:2.0972039699554 / seconds
Query Executed:select id FROM `nj` where city='Manville' && SIC_code='0742'DB:business_master_new
loadtime:2.1024091243744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Shade' limit 1
loadtime:2.1024720668793 / seconds
Query Executed:select id FROM `nj` where city='Maple Shade' && SIC_code='0742'DB:business_master_new
loadtime:2.1120381355286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:2.1121060848236 / seconds
Query Executed:select id FROM `nj` where city='Maplewood' && SIC_code='0742'DB:business_master_new
loadtime:2.1283531188965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margate City' limit 1
loadtime:2.1284279823303 / seconds
Query Executed:select id FROM `nj` where city='Margate City' && SIC_code='0742'DB:business_master_new
loadtime:2.1351699829102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:2.1352360248566 / seconds
Query Executed:select id FROM `nj` where city='Marlboro' && SIC_code='0742'DB:business_master_new
loadtime:2.1472480297089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlton' limit 1
loadtime:2.1473231315613 / seconds
Query Executed:select id FROM `nj` where city='Marlton' && SIC_code='0742'DB:business_master_new
loadtime:2.1560020446777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marmora' limit 1
loadtime:2.1560790538788 / seconds
Query Executed:select id FROM `nj` where city='Marmora' && SIC_code='0742'DB:business_master_new
loadtime:2.1617970466614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:2.1618671417236 / seconds
Query Executed:select id FROM `nj` where city='Martinsville' && SIC_code='0742'DB:business_master_new
loadtime:2.1653690338135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matawan' limit 1
loadtime:2.1654369831085 / seconds
Query Executed:select id FROM `nj` where city='Matawan' && SIC_code='0742'DB:business_master_new
loadtime:2.186506986618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauricetown' limit 1
loadtime:2.1865811347961 / seconds
Query Executed:select id FROM `nj` where city='Mauricetown' && SIC_code='0742'DB:business_master_new
loadtime:2.1873490810394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mays Landing' limit 1
loadtime:2.1874041557312 / seconds
Query Executed:select id FROM `nj` where city='Mays Landing' && SIC_code='0742'DB:business_master_new
loadtime:2.2022240161896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maywood' limit 1
loadtime:2.2022950649261 / seconds
Query Executed:select id FROM `nj` where city='Maywood' && SIC_code='0742'DB:business_master_new
loadtime:2.2083120346069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Afee' limit 1
loadtime:2.2083809375763 / seconds
Query Executed:select id FROM `nj` where city='Mc Afee' && SIC_code='0742'DB:business_master_new
loadtime:2.2098491191864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Guire Afb' limit 1
loadtime:2.2099180221558 / seconds
Query Executed:select id FROM `nj` where city='Mc Guire Afb' && SIC_code='0742'DB:business_master_new
loadtime:2.2104959487915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:2.210550069809 / seconds
Query Executed:select id FROM `nj` where city='Medford' && SIC_code='0742'DB:business_master_new
loadtime:2.2303969860077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford Lakes' limit 1
loadtime:2.2304940223694 / seconds
Query Executed:select id FROM `nj` where city='Medford Lakes' && SIC_code='0742'DB:business_master_new
loadtime:2.2309970855713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendham' limit 1
loadtime:2.2310531139374 / seconds
Query Executed:select id FROM `nj` where city='Mendham' && SIC_code='0742'DB:business_master_new
loadtime:2.2388520240784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercerville' limit 1
loadtime:2.2389240264893 / seconds
Query Executed:select id FROM `nj` where city='Mercerville' && SIC_code='0742'DB:business_master_new
loadtime:2.2399749755859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merchantville' limit 1
loadtime:2.240031003952 / seconds
Query Executed:select id FROM `nj` where city='Merchantville' && SIC_code='0742'DB:business_master_new
loadtime:2.250214099884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metuchen' limit 1
loadtime:2.2502679824829 / seconds
Query Executed:select id FROM `nj` where city='Metuchen' && SIC_code='0742'DB:business_master_new
loadtime:2.2655229568481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mickleton' limit 1
loadtime:2.2655940055847 / seconds
Query Executed:select id FROM `nj` where city='Mickleton' && SIC_code='0742'DB:business_master_new
loadtime:2.2674441337585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:2.2675189971924 / seconds
Query Executed:select id FROM `nj` where city='Middlesex' && SIC_code='0742'DB:business_master_new
loadtime:2.2796680927277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:2.2797360420227 / seconds
Query Executed:select id FROM `nj` where city='Middletown' && SIC_code='0742'DB:business_master_new
loadtime:2.2958791255951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:2.2959649562836 / seconds
Query Executed:select id FROM `nj` where city='Middleville' && SIC_code='0742'DB:business_master_new
loadtime:2.2966351509094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland Park' limit 1
loadtime:2.2966949939728 / seconds
Query Executed:select id FROM `nj` where city='Midland Park' && SIC_code='0742'DB:business_master_new
loadtime:2.3060419559479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:2.3061139583588 / seconds
Query Executed:select id FROM `nj` where city='Milford' && SIC_code='0742'DB:business_master_new
loadtime:2.3121030330658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millburn' limit 1
loadtime:2.3121731281281 / seconds
Query Executed:select id FROM `nj` where city='Millburn' && SIC_code='0742'DB:business_master_new
loadtime:2.3243820667267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:2.3244490623474 / seconds
Query Executed:select id FROM `nj` where city='Millington' && SIC_code='0742'DB:business_master_new
loadtime:2.3280940055847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millstone Twp' limit 1
loadtime:2.3281600475311 / seconds
Query Executed:select id FROM `nj` where city='Millstone Twp' && SIC_code='0742'DB:business_master_new
loadtime:2.3286280632019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milltown' limit 1
loadtime:2.3286859989166 / seconds
Query Executed:select id FROM `nj` where city='Milltown' && SIC_code='0742'DB:business_master_new
loadtime:2.3339560031891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:2.3340101242065 / seconds
Query Executed:select id FROM `nj` where city='Millville' && SIC_code='0742'DB:business_master_new
loadtime:2.3497750759125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milmay' limit 1
loadtime:2.3498470783234 / seconds
Query Executed:select id FROM `nj` where city='Milmay' && SIC_code='0742'DB:business_master_new
loadtime:2.3508560657501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Hill' limit 1
loadtime:2.3509111404419 / seconds
Query Executed:select id FROM `nj` where city='Mine Hill' && SIC_code='0742'DB:business_master_new
loadtime:2.3534419536591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minotola' limit 1
loadtime:2.3535251617432 / seconds
Query Executed:select id FROM `nj` where city='Minotola' && SIC_code='0742'DB:business_master_new
loadtime:2.3548240661621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mizpah' limit 1
loadtime:2.3548800945282 / seconds
Query Executed:select id FROM `nj` where city='Mizpah' && SIC_code='0742'DB:business_master_new
loadtime:2.3554971218109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Beach' limit 1
loadtime:2.3555510044098 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Beach' && SIC_code='0742'DB:business_master_new
loadtime:2.3584110736847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Jct' limit 1
loadtime:2.3584649562836 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Jct' && SIC_code='0742'DB:business_master_new
loadtime:2.3590409755707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Junction' limit 1
loadtime:2.3590950965881 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Junction' && SIC_code='0742'DB:business_master_new
loadtime:2.3673670291901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Township' limit 1
loadtime:2.3674359321594 / seconds
Query Executed:select id FROM `nj` where city='Monroe Township' && SIC_code='0742'DB:business_master_new
loadtime:2.3843519687653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Twp' limit 1
loadtime:2.3844201564789 / seconds
Query Executed:select id FROM `nj` where city='Monroe Twp' && SIC_code='0742'DB:business_master_new
loadtime:2.3857109546661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroeville' limit 1
loadtime:2.3857650756836 / seconds
Query Executed:select id FROM `nj` where city='Monroeville' && SIC_code='0742'DB:business_master_new
loadtime:2.3880360126495 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:2.3881011009216 / seconds
Query Executed:select id FROM `nj` where city='Montague' && SIC_code='0742'DB:business_master_new
loadtime:2.3908579349518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montclair' limit 1
loadtime:2.3909289836884 / seconds
Query Executed:select id FROM `nj` where city='Montclair' && SIC_code='0742'DB:business_master_new
loadtime:2.3995471000671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:2.3996231555939 / seconds
Query Executed:select id FROM `nj` where city='Montvale' && SIC_code='0742'DB:business_master_new
loadtime:2.4089601039886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:2.4090280532837 / seconds
Query Executed:select id FROM `nj` where city='Montville' && SIC_code='0742'DB:business_master_new
loadtime:2.4192881584167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moonachie' limit 1
loadtime:2.4193439483643 / seconds
Query Executed:select id FROM `nj` where city='Moonachie' && SIC_code='0742'DB:business_master_new
loadtime:2.4243321418762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorestown' limit 1
loadtime:2.4243860244751 / seconds
Query Executed:select id FROM `nj` where city='Moorestown' && SIC_code='0742'DB:business_master_new
loadtime:2.4461209774017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganville' limit 1
loadtime:2.4461970329285 / seconds
Query Executed:select id FROM `nj` where city='Morganville' && SIC_code='0742'DB:business_master_new
loadtime:2.4575879573822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris Plains' limit 1
loadtime:2.4576590061188 / seconds
Query Executed:select id FROM `nj` where city='Morris Plains' && SIC_code='0742'DB:business_master_new
loadtime:2.4693500995636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:2.4694221019745 / seconds
Query Executed:select id FROM `nj` where city='Morristown' && SIC_code='0742'DB:business_master_new
loadtime:2.4780881404877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Arlington' limit 1
loadtime:2.478168964386 / seconds
Query Executed:select id FROM `nj` where city='Mount Arlington' && SIC_code='0742'DB:business_master_new
loadtime:2.4817011356354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ephraim' limit 1
loadtime:2.4817571640015 / seconds
Query Executed:select id FROM `nj` where city='Mount Ephraim' && SIC_code='0742'DB:business_master_new
loadtime:2.4857361316681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Freedom' limit 1
loadtime:2.4857890605927 / seconds
Query Executed:select id FROM `nj` where city='Mount Freedom' && SIC_code='0742'DB:business_master_new
loadtime:2.4872529506683 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:2.4873061180115 / seconds
Query Executed:select id FROM `nj` where city='Mount Holly' && SIC_code='0742'DB:business_master_new
loadtime:2.5026869773865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Laurel' limit 1
loadtime:2.502758026123 / seconds
Query Executed:select id FROM `nj` where city='Mount Laurel' && SIC_code='0742'DB:business_master_new
loadtime:2.5112860202789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Royal' limit 1
loadtime:2.5113580226898 / seconds
Query Executed:select id FROM `nj` where city='Mount Royal' && SIC_code='0742'DB:business_master_new
loadtime:2.5123479366302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Tabor' limit 1
loadtime:2.5124039649963 / seconds
Query Executed:select id FROM `nj` where city='Mount Tabor' && SIC_code='0742'DB:business_master_new
loadtime:2.5132040977478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Lakes' limit 1
loadtime:2.5132579803467 / seconds
Query Executed:select id FROM `nj` where city='Mountain Lakes' && SIC_code='0742'DB:business_master_new
loadtime:2.5187001228333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainside' limit 1
loadtime:2.5187680721283 / seconds
Query Executed:select id FROM `nj` where city='Mountainside' && SIC_code='0742'DB:business_master_new
loadtime:2.5269839763641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Arlington' limit 1
loadtime:2.5270400047302 / seconds
Query Executed:select id FROM `nj` where city='Mt Arlington' && SIC_code='0742'DB:business_master_new
loadtime:2.5276350975037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ephraim' limit 1
loadtime:2.5276911258698 / seconds
Query Executed:select id FROM `nj` where city='Mt Ephraim' && SIC_code='0742'DB:business_master_new
loadtime:2.5281591415405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Freedom' limit 1
loadtime:2.5282120704651 / seconds
Query Executed:select id FROM `nj` where city='Mt Freedom' && SIC_code='0742'DB:business_master_new
loadtime:2.5287411212921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:2.528795003891 / seconds
Query Executed:select id FROM `nj` where city='Mt Holly' && SIC_code='0742'DB:business_master_new
loadtime:2.5300569534302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Laurel' limit 1
loadtime:2.5301110744476 / seconds
Query Executed:select id FROM `nj` where city='Mt Laurel' && SIC_code='0742'DB:business_master_new
loadtime:2.5321500301361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Royal' limit 1
loadtime:2.5322041511536 / seconds
Query Executed:select id FROM `nj` where city='Mt Royal' && SIC_code='0742'DB:business_master_new
loadtime:2.5327301025391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Tabor' limit 1
loadtime:2.5328140258789 / seconds
Query Executed:select id FROM `nj` where city='Mt Tabor' && SIC_code='0742'DB:business_master_new
loadtime:2.5333399772644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullica Hill' limit 1
loadtime:2.5334191322327 / seconds
Query Executed:select id FROM `nj` where city='Mullica Hill' && SIC_code='0742'DB:business_master_new
loadtime:2.5401401519775 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Park' limit 1
loadtime:2.5402221679688 / seconds
Query Executed:select id FROM `nj` where city='National Park' && SIC_code='0742'DB:business_master_new
loadtime:2.5416190624237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navesink' limit 1
loadtime:2.54168009758 / seconds
Query Executed:select id FROM `nj` where city='Navesink' && SIC_code='0742'DB:business_master_new
loadtime:2.5425789356232 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neptune' limit 1
loadtime:2.5426321029663 / seconds
Query Executed:select id FROM `nj` where city='Neptune' && SIC_code='0742'DB:business_master_new
loadtime:2.5510399341583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neptune City' limit 1
loadtime:2.5511119365692 / seconds
Query Executed:select id FROM `nj` where city='Neptune City' && SIC_code='0742'DB:business_master_new
loadtime:2.5518300533295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neshanic Station' limit 1
loadtime:2.5518860816956 / seconds
Query Executed:select id FROM `nj` where city='Neshanic Station' && SIC_code='0742'DB:business_master_new
loadtime:2.5556700229645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Netcong' limit 1
loadtime:2.5557241439819 / seconds
Query Executed:select id FROM `nj` where city='Netcong' && SIC_code='0742'DB:business_master_new
loadtime:2.5589480400085 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Brunswick' limit 1
loadtime:2.5590009689331 / seconds
Query Executed:select id FROM `nj` where city='New Brunswick' && SIC_code='0742'DB:business_master_new
loadtime:2.5672130584717 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Egypt' limit 1
loadtime:2.5672791004181 / seconds
Query Executed:select id FROM `nj` where city='New Egypt' && SIC_code='0742'DB:business_master_new
loadtime:2.5715870857239 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Gretna' limit 1
loadtime:2.5716421604156 / seconds
Query Executed:select id FROM `nj` where city='New Gretna' && SIC_code='0742'DB:business_master_new
loadtime:2.5727519989014 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lisbon' limit 1
loadtime:2.5728070735931 / seconds
Query Executed:select id FROM `nj` where city='New Lisbon' && SIC_code='0742'DB:business_master_new
loadtime:2.5736100673676 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:2.5736660957336 / seconds
Query Executed:select id FROM `nj` where city='New Milford' && SIC_code='0742'DB:business_master_new
loadtime:2.5802249908447 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Monmouth' limit 1
loadtime:2.5802791118622 / seconds
Query Executed:select id FROM `nj` where city='New Monmouth' && SIC_code='0742'DB:business_master_new
loadtime:2.5807490348816 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:2.5808019638062 / seconds
Query Executed:select id FROM `nj` where city='New Providence' && SIC_code='0742'DB:business_master_new
loadtime:2.5890879631042 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vernon' limit 1
loadtime:2.5891621112823 / seconds
Query Executed:select id FROM `nj` where city='New Vernon' && SIC_code='0742'DB:business_master_new
loadtime:2.5905539989471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newark' limit 1
loadtime:2.5906219482422 / seconds
Query Executed:select id FROM `nj` where city='Newark' && SIC_code='0742'DB:business_master_new
loadtime:2.5998611450195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfield' limit 1
loadtime:2.5999290943146 / seconds
Query Executed:select id FROM `nj` where city='Newfield' && SIC_code='0742'DB:business_master_new
loadtime:2.6042070388794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfoundland' limit 1
loadtime:2.6042640209198 / seconds
Query Executed:select id FROM `nj` where city='Newfoundland' && SIC_code='0742'DB:business_master_new
loadtime:2.6082890033722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:2.608344078064 / seconds
Query Executed:select id FROM `nj` where city='Newport' && SIC_code='0742'DB:business_master_new
loadtime:2.6091661453247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:2.6092190742493 / seconds
Query Executed:select id FROM `nj` where city='Newton' && SIC_code='0742'DB:business_master_new
loadtime:2.6176040172577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:2.6176919937134 / seconds
Query Executed:select id FROM `nj` where city='Newtonville' && SIC_code='0742'DB:business_master_new
loadtime:2.618499994278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norma' limit 1
loadtime:2.618556022644 / seconds
Query Executed:select id FROM `nj` where city='Norma' && SIC_code='0742'DB:business_master_new
loadtime:2.6193561553955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Normandy Beach' limit 1
loadtime:2.6194231510162 / seconds
Query Executed:select id FROM `nj` where city='Normandy Beach' && SIC_code='0742'DB:business_master_new
loadtime:2.620512008667 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Arlington' limit 1
loadtime:2.6205680370331 / seconds
Query Executed:select id FROM `nj` where city='North Arlington' && SIC_code='0742'DB:business_master_new
loadtime:2.6285591125488 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bergen' limit 1
loadtime:2.6286129951477 / seconds
Query Executed:select id FROM `nj` where city='North Bergen' && SIC_code='0742'DB:business_master_new
loadtime:2.6369421482086 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:2.6370141506195 / seconds
Query Executed:select id FROM `nj` where city='North Branch' && SIC_code='0742'DB:business_master_new
loadtime:2.637766122818 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brunswick' limit 1
loadtime:2.6378209590912 / seconds
Query Executed:select id FROM `nj` where city='North Brunswick' && SIC_code='0742'DB:business_master_new
loadtime:2.657142162323 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cape May' limit 1
loadtime:2.6572141647339 / seconds
Query Executed:select id FROM `nj` where city='North Cape May' && SIC_code='0742'DB:business_master_new
loadtime:2.6577451229095 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haledon' limit 1
loadtime:2.6577999591827 / seconds
Query Executed:select id FROM `nj` where city='North Haledon' && SIC_code='0742'DB:business_master_new
loadtime:2.6583640575409 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Middletown' limit 1
loadtime:2.6584169864655 / seconds
Query Executed:select id FROM `nj` where city='North Middletown' && SIC_code='0742'DB:business_master_new
loadtime:2.6589000225067 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Plainfield' limit 1
loadtime:2.6589541435242 / seconds
Query Executed:select id FROM `nj` where city='North Plainfield' && SIC_code='0742'DB:business_master_new
loadtime:2.6599690914154 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wildwood' limit 1
loadtime:2.6600229740143 / seconds
Query Executed:select id FROM `nj` where city='North Wildwood' && SIC_code='0742'DB:business_master_new
loadtime:2.6608071327209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:2.660863161087 / seconds
Query Executed:select id FROM `nj` where city='Northfield' && SIC_code='0742'DB:business_master_new
loadtime:2.6724791526794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northvale' limit 1
loadtime:2.6725471019745 / seconds
Query Executed:select id FROM `nj` where city='Northvale' && SIC_code='0742'DB:business_master_new
loadtime:2.6789979934692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:2.6790540218353 / seconds
Query Executed:select id FROM `nj` where city='Norwood' && SIC_code='0742'DB:business_master_new
loadtime:2.6843609809875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutley' limit 1
loadtime:2.6844160556793 / seconds
Query Executed:select id FROM `nj` where city='Nutley' && SIC_code='0742'DB:business_master_new
loadtime:2.7016749382019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:2.7017459869385 / seconds
Query Executed:select id FROM `nj` where city='Oak Ridge' && SIC_code='0742'DB:business_master_new
loadtime:2.7083330154419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakhurst' limit 1
loadtime:2.7084021568298 / seconds
Query Executed:select id FROM `nj` where city='Oakhurst' && SIC_code='0742'DB:business_master_new
loadtime:2.7163300514221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:2.7163960933685 / seconds
Query Executed:select id FROM `nj` where city='Oakland' && SIC_code='0742'DB:business_master_new
loadtime:2.7268760204315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oaklyn' limit 1
loadtime:2.7269470691681 / seconds
Query Executed:select id FROM `nj` where city='Oaklyn' && SIC_code='0742'DB:business_master_new
loadtime:2.7327499389648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean' limit 1
loadtime:2.7328209877014 / seconds
Query Executed:select id FROM `nj` where city='Ocean' && SIC_code='0742'DB:business_master_new
loadtime:2.7344369888306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean City' limit 1
loadtime:2.734500169754 / seconds
Query Executed:select id FROM `nj` where city='Ocean City' && SIC_code='0742'DB:business_master_new
loadtime:2.7520351409912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Gate' limit 1
loadtime:2.7521021366119 / seconds
Query Executed:select id FROM `nj` where city='Ocean Gate' && SIC_code='0742'DB:business_master_new
loadtime:2.7532751560211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Grove' limit 1
loadtime:2.75332903862 / seconds
Query Executed:select id FROM `nj` where city='Ocean Grove' && SIC_code='0742'DB:business_master_new
loadtime:2.7559330463409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean View' limit 1
loadtime:2.7559871673584 / seconds
Query Executed:select id FROM `nj` where city='Ocean View' && SIC_code='0742'DB:business_master_new
loadtime:2.7605550289154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanport' limit 1
loadtime:2.7606251239777 / seconds
Query Executed:select id FROM `nj` where city='Oceanport' && SIC_code='0742'DB:business_master_new
loadtime:2.7642059326172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanville' limit 1
loadtime:2.7642731666565 / seconds
Query Executed:select id FROM `nj` where city='Oceanville' && SIC_code='0742'DB:business_master_new
loadtime:2.7650661468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogdensburg' limit 1
loadtime:2.7651209831238 / seconds
Query Executed:select id FROM `nj` where city='Ogdensburg' && SIC_code='0742'DB:business_master_new
loadtime:2.7666771411896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Bridge' limit 1
loadtime:2.7667310237885 / seconds
Query Executed:select id FROM `nj` where city='Old Bridge' && SIC_code='0742'DB:business_master_new
loadtime:2.7833271026611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Tappan' limit 1
loadtime:2.7833960056305 / seconds
Query Executed:select id FROM `nj` where city='Old Tappan' && SIC_code='0742'DB:business_master_new
loadtime:2.7841100692749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldwick' limit 1
loadtime:2.7841761112213 / seconds
Query Executed:select id FROM `nj` where city='Oldwick' && SIC_code='0742'DB:business_master_new
loadtime:2.7861831188202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oradell' limit 1
loadtime:2.7862541675568 / seconds
Query Executed:select id FROM `nj` where city='Oradell' && SIC_code='0742'DB:business_master_new
loadtime:2.7946560382843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:2.7947101593018 / seconds
Query Executed:select id FROM `nj` where city='Orange' && SIC_code='0742'DB:business_master_new
loadtime:2.8119070529938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osbornsville' limit 1
loadtime:2.8119759559631 / seconds
Query Executed:select id FROM `nj` where city='Osbornsville' && SIC_code='0742'DB:business_master_new
loadtime:2.8124251365662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:2.8124859333038 / seconds
Query Executed:select id FROM `nj` where city='Oxford' && SIC_code='0742'DB:business_master_new
loadtime:2.8149001598358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisades Park' limit 1
loadtime:2.814954996109 / seconds
Query Executed:select id FROM `nj` where city='Palisades Park' && SIC_code='0742'DB:business_master_new
loadtime:2.8283140659332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:2.8283829689026 / seconds
Query Executed:select id FROM `nj` where city='Palmyra' && SIC_code='0742'DB:business_master_new
loadtime:2.8321571350098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paramus' limit 1
loadtime:2.8322110176086 / seconds
Query Executed:select id FROM `nj` where city='Paramus' && SIC_code='0742'DB:business_master_new
loadtime:2.8408570289612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Ridge' limit 1
loadtime:2.8409330844879 / seconds
Query Executed:select id FROM `nj` where city='Park Ridge' && SIC_code='0742'DB:business_master_new
loadtime:2.8490681648254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parlin' limit 1
loadtime:2.8491380214691 / seconds
Query Executed:select id FROM `nj` where city='Parlin' && SIC_code='0742'DB:business_master_new
loadtime:2.8558461666107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parsippany' limit 1
loadtime:2.8559010028839 / seconds
Query Executed:select id FROM `nj` where city='Parsippany' && SIC_code='0742'DB:business_master_new
loadtime:2.8641810417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passaic' limit 1
loadtime:2.8642561435699 / seconds
Query Executed:select id FROM `nj` where city='Passaic' && SIC_code='0742'DB:business_master_new
loadtime:2.8724880218506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paterson' limit 1
loadtime:2.8725621700287 / seconds
Query Executed:select id FROM `nj` where city='Paterson' && SIC_code='0742'DB:business_master_new
loadtime:2.8808419704437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulsboro' limit 1
loadtime:2.8809299468994 / seconds
Query Executed:select id FROM `nj` where city='Paulsboro' && SIC_code='0742'DB:business_master_new
loadtime:2.8861539363861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peapack' limit 1
loadtime:2.8862111568451 / seconds
Query Executed:select id FROM `nj` where city='Peapack' && SIC_code='0742'DB:business_master_new
loadtime:2.8877890110016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pedricktown' limit 1
loadtime:2.887843132019 / seconds
Query Executed:select id FROM `nj` where city='Pedricktown' && SIC_code='0742'DB:business_master_new
loadtime:2.8893251419067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pemberton' limit 1
loadtime:2.8893780708313 / seconds
Query Executed:select id FROM `nj` where city='Pemberton' && SIC_code='0742'DB:business_master_new
loadtime:2.8926911354065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington' limit 1
loadtime:2.8927450180054 / seconds
Query Executed:select id FROM `nj` where city='Pennington' && SIC_code='0742'DB:business_master_new
loadtime:2.9041471481323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penns Grove' limit 1
loadtime:2.9042229652405 / seconds
Query Executed:select id FROM `nj` where city='Penns Grove' && SIC_code='0742'DB:business_master_new
loadtime:2.91095495224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsauken' limit 1
loadtime:2.9110341072083 / seconds
Query Executed:select id FROM `nj` where city='Pennsauken' && SIC_code='0742'DB:business_master_new
loadtime:2.9289729595184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsville' limit 1
loadtime:2.929044008255 / seconds
Query Executed:select id FROM `nj` where city='Pennsville' && SIC_code='0742'DB:business_master_new
loadtime:2.9363820552826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequannock' limit 1
loadtime:2.9364769458771 / seconds
Query Executed:select id FROM `nj` where city='Pequannock' && SIC_code='0742'DB:business_master_new
loadtime:2.9395470619202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrineville' limit 1
loadtime:2.9396040439606 / seconds
Query Executed:select id FROM `nj` where city='Perrineville' && SIC_code='0742'DB:business_master_new
loadtime:2.9400899410248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perth Amboy' limit 1
loadtime:2.9401440620422 / seconds
Query Executed:select id FROM `nj` where city='Perth Amboy' && SIC_code='0742'DB:business_master_new
loadtime:2.9590470790863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipsburg' limit 1
loadtime:2.9591031074524 / seconds
Query Executed:select id FROM `nj` where city='Phillipsburg' && SIC_code='0742'DB:business_master_new
loadtime:2.9774661064148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picatinny Arsenal' limit 1
loadtime:2.9775531291962 / seconds
Query Executed:select id FROM `nj` where city='Picatinny Arsenal' && SIC_code='0742'DB:business_master_new
loadtime:2.9781579971313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picatinny Arsnl' limit 1
loadtime:2.9782140254974 / seconds
Query Executed:select id FROM `nj` where city='Picatinny Arsnl' && SIC_code='0742'DB:business_master_new
loadtime:2.9787950515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilesgrove' limit 1
loadtime:2.9788489341736 / seconds
Query Executed:select id FROM `nj` where city='Pilesgrove' && SIC_code='0742'DB:business_master_new
loadtime:2.9794130325317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Beach' limit 1
loadtime:2.9794750213623 / seconds
Query Executed:select id FROM `nj` where city='Pine Beach' && SIC_code='0742'DB:business_master_new
loadtime:2.9810359477997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Brook' limit 1
loadtime:2.9810900688171 / seconds
Query Executed:select id FROM `nj` where city='Pine Brook' && SIC_code='0742'DB:business_master_new
loadtime:2.9882230758667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hill' limit 1
loadtime:2.9882769584656 / seconds
Query Executed:select id FROM `nj` where city='Pine Hill' && SIC_code='0742'DB:business_master_new
loadtime:2.9888660907745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piscataway' limit 1
loadtime:2.9889199733734 / seconds
Query Executed:select id FROM `nj` where city='Piscataway' && SIC_code='0742'DB:business_master_new
loadtime:2.9975321292877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pitman' limit 1
loadtime:2.9975979328156 / seconds
Query Executed:select id FROM `nj` where city='Pitman' && SIC_code='0742'DB:business_master_new
loadtime:3.0047450065613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsgrove' limit 1
loadtime:3.0048141479492 / seconds
Query Executed:select id FROM `nj` where city='Pittsgrove' && SIC_code='0742'DB:business_master_new
loadtime:3.0053160190582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittstown' limit 1
loadtime:3.0053679943085 / seconds
Query Executed:select id FROM `nj` where city='Pittstown' && SIC_code='0742'DB:business_master_new
loadtime:3.0101130008698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:3.010183095932 / seconds
Query Executed:select id FROM `nj` where city='Plainfield' && SIC_code='0742'DB:business_master_new
loadtime:3.0184190273285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainsboro' limit 1
loadtime:3.0184960365295 / seconds
Query Executed:select id FROM `nj` where city='Plainsboro' && SIC_code='0742'DB:business_master_new
loadtime:3.0266370773315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:3.0267050266266 / seconds
Query Executed:select id FROM `nj` where city='Pleasantville' && SIC_code='0742'DB:business_master_new
loadtime:3.0409910678864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pluckemin' limit 1
loadtime:3.0410630702972 / seconds
Query Executed:select id FROM `nj` where city='Pluckemin' && SIC_code='0742'DB:business_master_new
loadtime:3.0424270629883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant' limit 1
loadtime:3.0424900054932 / seconds
Query Executed:select id FROM `nj` where city='Point Pleasant' && SIC_code='0742'DB:business_master_new
loadtime:3.0435180664062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant Beach' limit 1
loadtime:3.0435740947723 / seconds
Query Executed:select id FROM `nj` where city='Point Pleasant Beach' && SIC_code='0742'DB:business_master_new
loadtime:3.0519599914551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomona' limit 1
loadtime:3.0520370006561 / seconds
Query Executed:select id FROM `nj` where city='Pomona' && SIC_code='0742'DB:business_master_new
loadtime:3.0539481639862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompton Lakes' limit 1
loadtime:3.0540161132812 / seconds
Query Executed:select id FROM `nj` where city='Pompton Lakes' && SIC_code='0742'DB:business_master_new
loadtime:3.0628311634064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompton Plains' limit 1
loadtime:3.0629000663757 / seconds
Query Executed:select id FROM `nj` where city='Pompton Plains' && SIC_code='0742'DB:business_master_new
loadtime:3.0715520381927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Elizabeth' limit 1
loadtime:3.0716259479523 / seconds
Query Executed:select id FROM `nj` where city='Port Elizabeth' && SIC_code='0742'DB:business_master_new
loadtime:3.072261095047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Monmouth' limit 1
loadtime:3.0723149776459 / seconds
Query Executed:select id FROM `nj` where city='Port Monmouth' && SIC_code='0742'DB:business_master_new
loadtime:3.0746531486511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Murray' limit 1
loadtime:3.0747089385986 / seconds
Query Executed:select id FROM `nj` where city='Port Murray' && SIC_code='0742'DB:business_master_new
loadtime:3.076728105545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Norris' limit 1
loadtime:3.0767810344696 / seconds
Query Executed:select id FROM `nj` where city='Port Norris' && SIC_code='0742'DB:business_master_new
loadtime:3.0783791542053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Reading' limit 1
loadtime:3.0784320831299 / seconds
Query Executed:select id FROM `nj` where city='Port Reading' && SIC_code='0742'DB:business_master_new
loadtime:3.0799570083618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:3.0800099372864 / seconds
Query Executed:select id FROM `nj` where city='Port Republic' && SIC_code='0742'DB:business_master_new
loadtime:3.0812621116638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pottersville' limit 1
loadtime:3.0813150405884 / seconds
Query Executed:select id FROM `nj` where city='Pottersville' && SIC_code='0742'DB:business_master_new
loadtime:3.0824069976807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:3.0824680328369 / seconds
Query Executed:select id FROM `nj` where city='Princeton' && SIC_code='0742'DB:business_master_new
loadtime:3.0908739566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton Jct' limit 1
loadtime:3.0909531116486 / seconds
Query Executed:select id FROM `nj` where city='Princeton Jct' && SIC_code='0742'DB:business_master_new
loadtime:3.0915701389313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton Junction' limit 1
loadtime:3.0916299819946 / seconds
Query Executed:select id FROM `nj` where city='Princeton Junction' && SIC_code='0742'DB:business_master_new
loadtime:3.1025121212006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Park' limit 1
loadtime:3.1025819778442 / seconds
Query Executed:select id FROM `nj` where city='Prospect Park' && SIC_code='0742'DB:business_master_new
loadtime:3.1030161380768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pt Pleasant Bch' limit 1
loadtime:3.10307097435 / seconds
Query Executed:select id FROM `nj` where city='Pt Pleasant Bch' && SIC_code='0742'DB:business_master_new
loadtime:3.1036560535431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pt Pleasant Boro' limit 1
loadtime:3.103709936142 / seconds
Query Executed:select id FROM `nj` where city='Pt Pleasant Boro' && SIC_code='0742'DB:business_master_new
loadtime:3.1041519641876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quakertown' limit 1
loadtime:3.1042039394379 / seconds
Query Executed:select id FROM `nj` where city='Quakertown' && SIC_code='0742'DB:business_master_new
loadtime:3.1049599647522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:3.1050260066986 / seconds
Query Executed:select id FROM `nj` where city='Quinton' && SIC_code='0742'DB:business_master_new
loadtime:3.1058909893036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rahway' limit 1
loadtime:3.1059460639954 / seconds
Query Executed:select id FROM `nj` where city='Rahway' && SIC_code='0742'DB:business_master_new
loadtime:3.1217370033264 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsey' limit 1
loadtime:3.1218290328979 / seconds
Query Executed:select id FROM `nj` where city='Ramsey' && SIC_code='0742'DB:business_master_new
loadtime:3.1302161216736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rancocas' limit 1
loadtime:3.1302869319916 / seconds
Query Executed:select id FROM `nj` where city='Rancocas' && SIC_code='0742'DB:business_master_new
loadtime:3.1315701007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:3.1316299438477 / seconds
Query Executed:select id FROM `nj` where city='Randolph' && SIC_code='0742'DB:business_master_new
loadtime:3.1475620269775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raritan' limit 1
loadtime:3.1476390361786 / seconds
Query Executed:select id FROM `nj` where city='Raritan' && SIC_code='0742'DB:business_master_new
loadtime:3.153960943222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readington' limit 1
loadtime:3.1540291309357 / seconds
Query Executed:select id FROM `nj` where city='Readington' && SIC_code='0742'DB:business_master_new
loadtime:3.1547880172729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Bank' limit 1
loadtime:3.1548581123352 / seconds
Query Executed:select id FROM `nj` where city='Red Bank' && SIC_code='0742'DB:business_master_new
loadtime:3.1631679534912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:3.1632449626923 / seconds
Query Executed:select id FROM `nj` where city='Richland' && SIC_code='0742'DB:business_master_new
loadtime:3.164176940918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richwood' limit 1
loadtime:3.1642329692841 / seconds
Query Executed:select id FROM `nj` where city='Richwood' && SIC_code='0742'DB:business_master_new
loadtime:3.1651520729065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:3.1652050018311 / seconds
Query Executed:select id FROM `nj` where city='Ridgefield' && SIC_code='0742'DB:business_master_new
loadtime:3.1769139766693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield Park' limit 1
loadtime:3.1769821643829 / seconds
Query Executed:select id FROM `nj` where city='Ridgefield Park' && SIC_code='0742'DB:business_master_new
loadtime:3.184005022049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgewood' limit 1
loadtime:3.1840751171112 / seconds
Query Executed:select id FROM `nj` where city='Ridgewood' && SIC_code='0742'DB:business_master_new
loadtime:3.1926190853119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringoes' limit 1
loadtime:3.1927080154419 / seconds
Query Executed:select id FROM `nj` where city='Ringoes' && SIC_code='0742'DB:business_master_new
loadtime:3.1971180438995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringwood' limit 1
loadtime:3.1971919536591 / seconds
Query Executed:select id FROM `nj` where city='Ringwood' && SIC_code='0742'DB:business_master_new
loadtime:3.2052299976349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Grande' limit 1
loadtime:3.2053010463715 / seconds
Query Executed:select id FROM `nj` where city='Rio Grande' && SIC_code='0742'DB:business_master_new
loadtime:3.21036195755 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Edge' limit 1
loadtime:3.2104320526123 / seconds
Query Executed:select id FROM `nj` where city='River Edge' && SIC_code='0742'DB:business_master_new
loadtime:3.2178101539612 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Vale' limit 1
loadtime:3.2178771495819 / seconds
Query Executed:select id FROM `nj` where city='River Vale' && SIC_code='0742'DB:business_master_new
loadtime:3.2184319496155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:3.218493938446 / seconds
Query Executed:select id FROM `nj` where city='Riverdale' && SIC_code='0742'DB:business_master_new
loadtime:3.2232310771942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:3.2232961654663 / seconds
Query Executed:select id FROM `nj` where city='Riverside' && SIC_code='0742'DB:business_master_new
loadtime:3.2376720905304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:3.2377409934998 / seconds
Query Executed:select id FROM `nj` where city='Riverton' && SIC_code='0742'DB:business_master_new
loadtime:3.2513780593872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:3.2514481544495 / seconds
Query Executed:select id FROM `nj` where city='Robbinsville' && SIC_code='0742'DB:business_master_new
loadtime:3.2523391246796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle Park' limit 1
loadtime:3.25239610672 / seconds
Query Executed:select id FROM `nj` where city='Rochelle Park' && SIC_code='0742'DB:business_master_new
loadtime:3.2611310482025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockaway' limit 1
loadtime:3.2611839771271 / seconds
Query Executed:select id FROM `nj` where city='Rockaway' && SIC_code='0742'DB:business_master_new
loadtime:3.2809710502625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockleigh' limit 1
loadtime:3.2810471057892 / seconds
Query Executed:select id FROM `nj` where city='Rockleigh' && SIC_code='0742'DB:business_master_new
loadtime:3.2815079689026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:3.28156208992 / seconds
Query Executed:select id FROM `nj` where city='Rocky Hill' && SIC_code='0742'DB:business_master_new
loadtime:3.2832350730896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebling' limit 1
loadtime:3.2833001613617 / seconds
Query Executed:select id FROM `nj` where city='Roebling' && SIC_code='0742'DB:business_master_new
loadtime:3.28484416008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:3.2848989963531 / seconds
Query Executed:select id FROM `nj` where city='Roosevelt' && SIC_code='0742'DB:business_master_new
loadtime:3.2859461307526 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:3.2860000133514 / seconds
Query Executed:select id FROM `nj` where city='Roseland' && SIC_code='0742'DB:business_master_new
loadtime:3.2943179607391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roselle' limit 1
loadtime:3.2943849563599 / seconds
Query Executed:select id FROM `nj` where city='Roselle' && SIC_code='0742'DB:business_master_new
loadtime:3.303827047348 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roselle Park' limit 1
loadtime:3.3038959503174 / seconds
Query Executed:select id FROM `nj` where city='Roselle Park' && SIC_code='0742'DB:business_master_new
loadtime:3.3111619949341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosemont' limit 1
loadtime:3.311233997345 / seconds
Query Executed:select id FROM `nj` where city='Rosemont' && SIC_code='0742'DB:business_master_new
loadtime:3.3121621608734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosenhayn' limit 1
loadtime:3.3122169971466 / seconds
Query Executed:select id FROM `nj` where city='Rosenhayn' && SIC_code='0742'DB:business_master_new
loadtime:3.3133339881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumson' limit 1
loadtime:3.3133890628815 / seconds
Query Executed:select id FROM `nj` where city='Rumson' && SIC_code='0742'DB:business_master_new
loadtime:3.3208060264587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnemede' limit 1
loadtime:3.3208601474762 / seconds
Query Executed:select id FROM `nj` where city='Runnemede' && SIC_code='0742'DB:business_master_new
loadtime:3.3262360095978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford' limit 1
loadtime:3.3262901306152 / seconds
Query Executed:select id FROM `nj` where city='Rutherford' && SIC_code='0742'DB:business_master_new
loadtime:3.3414130210876 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Bound Brook' limit 1
loadtime:3.3414919376373 / seconds
Query Executed:select id FROM `nj` where city='S Bound Brook' && SIC_code='0742'DB:business_master_new
loadtime:3.3419420719147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddle Brook' limit 1
loadtime:3.3419971466064 / seconds
Query Executed:select id FROM `nj` where city='Saddle Brook' && SIC_code='0742'DB:business_master_new
loadtime:3.3547551631927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddle River' limit 1
loadtime:3.3548099994659 / seconds
Query Executed:select id FROM `nj` where city='Saddle River' && SIC_code='0742'DB:business_master_new
loadtime:3.3647661209106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:3.3648340702057 / seconds
Query Executed:select id FROM `nj` where city='Salem' && SIC_code='0742'DB:business_master_new
loadtime:3.3724970817566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandyston' limit 1
loadtime:3.3725669384003 / seconds
Query Executed:select id FROM `nj` where city='Sandyston' && SIC_code='0742'DB:business_master_new
loadtime:3.372985124588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayreville' limit 1
loadtime:3.3730399608612 / seconds
Query Executed:select id FROM `nj` where city='Sayreville' && SIC_code='0742'DB:business_master_new
loadtime:3.3810789585114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schooleys Mountain' limit 1
loadtime:3.3811500072479 / seconds
Query Executed:select id FROM `nj` where city='Schooleys Mountain' && SIC_code='0742'DB:business_master_new
loadtime:3.3818039894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schooleys Mtn' limit 1
loadtime:3.3818600177765 / seconds
Query Executed:select id FROM `nj` where city='Schooleys Mtn' && SIC_code='0742'DB:business_master_new
loadtime:3.3823120594025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Plains' limit 1
loadtime:3.3823640346527 / seconds
Query Executed:select id FROM `nj` where city='Scotch Plains' && SIC_code='0742'DB:business_master_new
loadtime:3.3958909511566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Bright' limit 1
loadtime:3.3959600925446 / seconds
Query Executed:select id FROM `nj` where city='Sea Bright' && SIC_code='0742'DB:business_master_new
loadtime:3.3964200019836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Girt' limit 1
loadtime:3.3964810371399 / seconds
Query Executed:select id FROM `nj` where city='Sea Girt' && SIC_code='0742'DB:business_master_new
loadtime:3.4025039672852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Isle City' limit 1
loadtime:3.4025709629059 / seconds
Query Executed:select id FROM `nj` where city='Sea Isle City' && SIC_code='0742'DB:business_master_new
loadtime:3.4073159694672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:3.4073700904846 / seconds
Query Executed:select id FROM `nj` where city='Seabrook' && SIC_code='0742'DB:business_master_new
loadtime:3.4078691005707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside Heights' limit 1
loadtime:3.4079220294952 / seconds
Query Executed:select id FROM `nj` where city='Seaside Heights' && SIC_code='0742'DB:business_master_new
loadtime:3.412985086441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside Park' limit 1
loadtime:3.4130401611328 / seconds
Query Executed:select id FROM `nj` where city='Seaside Park' && SIC_code='0742'DB:business_master_new
loadtime:3.4155349731445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Secaucus' limit 1
loadtime:3.4156010150909 / seconds
Query Executed:select id FROM `nj` where city='Secaucus' && SIC_code='0742'DB:business_master_new
loadtime:3.4242279529572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeantsville' limit 1
loadtime:3.4242980480194 / seconds
Query Executed:select id FROM `nj` where city='Sergeantsville' && SIC_code='0742'DB:business_master_new
loadtime:3.4252891540527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sewaren' limit 1
loadtime:3.4253439903259 / seconds
Query Executed:select id FROM `nj` where city='Sewaren' && SIC_code='0742'DB:business_master_new
loadtime:3.4264941215515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sewell' limit 1
loadtime:3.4265470504761 / seconds
Query Executed:select id FROM `nj` where city='Sewell' && SIC_code='0742'DB:business_master_new
loadtime:3.4429910182953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shamong' limit 1
loadtime:3.4430639743805 / seconds
Query Executed:select id FROM `nj` where city='Shamong' && SIC_code='0742'DB:business_master_new
loadtime:3.4436061382294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:3.4436731338501 / seconds
Query Executed:select id FROM `nj` where city='Shiloh' && SIC_code='0742'DB:business_master_new
loadtime:3.4446070194244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ship Bottom' limit 1
loadtime:3.4446661472321 / seconds
Query Executed:select id FROM `nj` where city='Ship Bottom' && SIC_code='0742'DB:business_master_new
loadtime:3.4453580379486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Short Hills' limit 1
loadtime:3.4454100131989 / seconds
Query Executed:select id FROM `nj` where city='Short Hills' && SIC_code='0742'DB:business_master_new
loadtime:3.4560899734497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:3.4561569690704 / seconds
Query Executed:select id FROM `nj` where city='Shrewsbury' && SIC_code='0742'DB:business_master_new
loadtime:3.4672169685364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sicklerville' limit 1
loadtime:3.4672729969025 / seconds
Query Executed:select id FROM `nj` where city='Sicklerville' && SIC_code='0742'DB:business_master_new
loadtime:3.4782471656799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skillman' limit 1
loadtime:3.4783201217651 / seconds
Query Executed:select id FROM `nj` where city='Skillman' && SIC_code='0742'DB:business_master_new
loadtime:3.4838960170746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:3.4839639663696 / seconds
Query Executed:select id FROM `nj` where city='Smithville' && SIC_code='0742'DB:business_master_new
loadtime:3.4844961166382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerdale' limit 1
loadtime:3.4845509529114 / seconds
Query Executed:select id FROM `nj` where city='Somerdale' && SIC_code='0742'DB:business_master_new
loadtime:3.4897720813751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers Point' limit 1
loadtime:3.4898409843445 / seconds
Query Executed:select id FROM `nj` where city='Somers Point' && SIC_code='0742'DB:business_master_new
loadtime:3.5008211135864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:3.5009069442749 / seconds
Query Executed:select id FROM `nj` where city='Somerset' && SIC_code='0742'DB:business_master_new
loadtime:3.5095691680908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:3.5096459388733 / seconds
Query Executed:select id FROM `nj` where city='Somerville' && SIC_code='0742'DB:business_master_new
loadtime:3.5180771350861 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amboy' limit 1
loadtime:3.5181500911713 / seconds
Query Executed:select id FROM `nj` where city='South Amboy' && SIC_code='0742'DB:business_master_new
loadtime:3.5277769565582 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Bound Brook' limit 1
loadtime:3.527850151062 / seconds
Query Executed:select id FROM `nj` where city='South Bound Brook' && SIC_code='0742'DB:business_master_new
loadtime:3.5299651622772 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:3.5300209522247 / seconds
Query Executed:select id FROM `nj` where city='South Dennis' && SIC_code='0742'DB:business_master_new
loadtime:3.530720949173 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hackensack' limit 1
loadtime:3.5307769775391 / seconds
Query Executed:select id FROM `nj` where city='South Hackensack' && SIC_code='0742'DB:business_master_new
loadtime:3.5374641418457 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orange' limit 1
loadtime:3.5375189781189 / seconds
Query Executed:select id FROM `nj` where city='South Orange' && SIC_code='0742'DB:business_master_new
loadtime:3.5508141517639 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Plainfield' limit 1
loadtime:3.5508849620819 / seconds
Query Executed:select id FROM `nj` where city='South Plainfield' && SIC_code='0742'DB:business_master_new
loadtime:3.5593831539154 / seconds
Query loaded from cache:select * from geodata_geocity where city='South River' limit 1
loadtime:3.5594630241394 / seconds
Query Executed:select id FROM `nj` where city='South River' && SIC_code='0742'DB:business_master_new
loadtime:3.5673639774323 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Seaville' limit 1
loadtime:3.5674350261688 / seconds
Query Executed:select id FROM `nj` where city='South Seaville' && SIC_code='0742'DB:business_master_new
loadtime:3.5683150291443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:3.5683701038361 / seconds
Query Executed:select id FROM `nj` where city='Southampton' && SIC_code='0742'DB:business_master_new
loadtime:3.5689880847931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:3.569041967392 / seconds
Query Executed:select id FROM `nj` where city='Sparta' && SIC_code='0742'DB:business_master_new
loadtime:3.5851650238037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotswood' limit 1
loadtime:3.585235118866 / seconds
Query Executed:select id FROM `nj` where city='Spotswood' && SIC_code='0742'DB:business_master_new
loadtime:3.5899441242218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:3.589998960495 / seconds
Query Executed:select id FROM `nj` where city='Spring Lake' && SIC_code='0742'DB:business_master_new
loadtime:3.599198102951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:3.5992670059204 / seconds
Query Executed:select id FROM `nj` where city='Springfield' && SIC_code='0742'DB:business_master_new
loadtime:3.6145830154419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:3.6146409511566 / seconds
Query Executed:select id FROM `nj` where city='Stanhope' && SIC_code='0742'DB:business_master_new
loadtime:3.6199550628662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:3.6200239658356 / seconds
Query Executed:select id FROM `nj` where city='Stanton' && SIC_code='0742'DB:business_master_new
loadtime:3.6208250522614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartsville' limit 1
loadtime:3.6208829879761 / seconds
Query Executed:select id FROM `nj` where city='Stewartsville' && SIC_code='0742'DB:business_master_new
loadtime:3.6235001087189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stillwater' limit 1
loadtime:3.6235680580139 / seconds
Query Executed:select id FROM `nj` where city='Stillwater' && SIC_code='0742'DB:business_master_new
loadtime:3.6245291233063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stirling' limit 1
loadtime:3.6245839595795 / seconds
Query Executed:select id FROM `nj` where city='Stirling' && SIC_code='0742'DB:business_master_new
loadtime:3.6275010108948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:3.6275670528412 / seconds
Query Executed:select id FROM `nj` where city='Stockholm' && SIC_code='0742'DB:business_master_new
loadtime:3.6293740272522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:3.6294269561768 / seconds
Query Executed:select id FROM `nj` where city='Stockton' && SIC_code='0742'DB:business_master_new
loadtime:3.633661031723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Harbor' limit 1
loadtime:3.6337339878082 / seconds
Query Executed:select id FROM `nj` where city='Stone Harbor' && SIC_code='0742'DB:business_master_new
loadtime:3.6376340389252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:3.6376900672913 / seconds
Query Executed:select id FROM `nj` where city='Stratford' && SIC_code='0742'DB:business_master_new
loadtime:3.6425659656525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strathmere' limit 1
loadtime:3.6426401138306 / seconds
Query Executed:select id FROM `nj` where city='Strathmere' && SIC_code='0742'DB:business_master_new
loadtime:3.643285036087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Succasunna' limit 1
loadtime:3.6433391571045 / seconds
Query Executed:select id FROM `nj` where city='Succasunna' && SIC_code='0742'DB:business_master_new
loadtime:3.652281999588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:3.6523489952087 / seconds
Query Executed:select id FROM `nj` where city='Summit' && SIC_code='0742'DB:business_master_new
loadtime:3.671863079071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:3.6719319820404 / seconds
Query Executed:select id FROM `nj` where city='Surf City' && SIC_code='0742'DB:business_master_new
loadtime:3.6725161075592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:3.6725721359253 / seconds
Query Executed:select id FROM `nj` where city='Sussex' && SIC_code='0742'DB:business_master_new
loadtime:3.6832871437073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartswood' limit 1
loadtime:3.6833591461182 / seconds
Query Executed:select id FROM `nj` where city='Swartswood' && SIC_code='0742'DB:business_master_new
loadtime:3.6840119361877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesboro' limit 1
loadtime:3.6840670108795 / seconds
Query Executed:select id FROM `nj` where city='Swedesboro' && SIC_code='0742'DB:business_master_new
loadtime:3.6928720474243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabernacle' limit 1
loadtime:3.692939043045 / seconds
Query Executed:select id FROM `nj` where city='Tabernacle' && SIC_code='0742'DB:business_master_new
loadtime:3.6935050487518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaneck' limit 1
loadtime:3.6935591697693 / seconds
Query Executed:select id FROM `nj` where city='Teaneck' && SIC_code='0742'DB:business_master_new
loadtime:3.7021420001984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tenafly' limit 1
loadtime:3.7022111415863 / seconds
Query Executed:select id FROM `nj` where city='Tenafly' && SIC_code='0742'DB:business_master_new
loadtime:3.7132720947266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennent' limit 1
loadtime:3.7133390903473 / seconds
Query Executed:select id FROM `nj` where city='Tennent' && SIC_code='0742'DB:business_master_new
loadtime:3.7143139839172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teterboro' limit 1
loadtime:3.7143700122833 / seconds
Query Executed:select id FROM `nj` where city='Teterboro' && SIC_code='0742'DB:business_master_new
loadtime:3.7180581092834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorofare' limit 1
loadtime:3.7181150913239 / seconds
Query Executed:select id FROM `nj` where city='Thorofare' && SIC_code='0742'DB:business_master_new
loadtime:3.7228009700775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Bridges' limit 1
loadtime:3.7228560447693 / seconds
Query Executed:select id FROM `nj` where city='Three Bridges' && SIC_code='0742'DB:business_master_new
loadtime:3.7241771221161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinton Falls' limit 1
loadtime:3.7242441177368 / seconds
Query Executed:select id FROM `nj` where city='Tinton Falls' && SIC_code='0742'DB:business_master_new
loadtime:3.7251009941101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titusville' limit 1
loadtime:3.7251551151276 / seconds
Query Executed:select id FROM `nj` where city='Titusville' && SIC_code='0742'DB:business_master_new
loadtime:3.7271211147308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms River' limit 1
loadtime:3.7271740436554 / seconds
Query Executed:select id FROM `nj` where city='Toms River' && SIC_code='0742'DB:business_master_new
loadtime:3.7355310916901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Totowa' limit 1
loadtime:3.7356221675873 / seconds
Query Executed:select id FROM `nj` where city='Totowa' && SIC_code='0742'DB:business_master_new
loadtime:3.7493360042572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towaco' limit 1
loadtime:3.7494051456451 / seconds
Query Executed:select id FROM `nj` where city='Towaco' && SIC_code='0742'DB:business_master_new
loadtime:3.7532529830933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Township Of Washington' limit 1
loadtime:3.7533221244812 / seconds
Query Executed:select id FROM `nj` where city='Township Of Washington' && SIC_code='0742'DB:business_master_new
loadtime:3.7568891048431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tranquility' limit 1
loadtime:3.7569551467896 / seconds
Query Executed:select id FROM `nj` where city='Tranquility' && SIC_code='0742'DB:business_master_new
loadtime:3.7578189373016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:3.7578859329224 / seconds
Query Executed:select id FROM `nj` where city='Trenton' && SIC_code='0742'DB:business_master_new
loadtime:3.7662329673767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckahoe' limit 1
loadtime:3.7663340568542 / seconds
Query Executed:select id FROM `nj` where city='Tuckahoe' && SIC_code='0742'DB:business_master_new
loadtime:3.7676179409027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckerton' limit 1
loadtime:3.767678976059 / seconds
Query Executed:select id FROM `nj` where city='Tuckerton' && SIC_code='0742'DB:business_master_new
loadtime:3.7795090675354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersville' limit 1
loadtime:3.7795829772949 / seconds
Query Executed:select id FROM `nj` where city='Turnersville' && SIC_code='0742'DB:business_master_new
loadtime:3.7809519767761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:3.7810070514679 / seconds
Query Executed:select id FROM `nj` where city='Union' && SIC_code='0742'DB:business_master_new
loadtime:3.7895450592041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Beach' limit 1
loadtime:3.7896311283112 / seconds
Query Executed:select id FROM `nj` where city='Union Beach' && SIC_code='0742'DB:business_master_new
loadtime:3.7901539802551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:3.7902100086212 / seconds
Query Executed:select id FROM `nj` where city='Union City' && SIC_code='0742'DB:business_master_new
loadtime:3.7984850406647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upper Saddle Rvr' limit 1
loadtime:3.7985570430756 / seconds
Query Executed:select id FROM `nj` where city='Upper Saddle Rvr' && SIC_code='0742'DB:business_master_new
loadtime:3.7990210056305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vauxhall' limit 1
loadtime:3.7990779876709 / seconds
Query Executed:select id FROM `nj` where city='Vauxhall' && SIC_code='0742'DB:business_master_new
loadtime:3.8013739585876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventnor City' limit 1
loadtime:3.8014290332794 / seconds
Query Executed:select id FROM `nj` where city='Ventnor City' && SIC_code='0742'DB:business_master_new
loadtime:3.8091130256653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:3.8091809749603 / seconds
Query Executed:select id FROM `nj` where city='Vernon' && SIC_code='0742'DB:business_master_new
loadtime:3.8158161640167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:3.8158869743347 / seconds
Query Executed:select id FROM `nj` where city='Verona' && SIC_code='0742'DB:business_master_new
loadtime:3.828253030777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:3.8283231258392 / seconds
Query Executed:select id FROM `nj` where city='Vienna' && SIC_code='0742'DB:business_master_new
loadtime:3.8289520740509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villas' limit 1
loadtime:3.8290071487427 / seconds
Query Executed:select id FROM `nj` where city='Villas' && SIC_code='0742'DB:business_master_new
loadtime:3.832535982132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincentown' limit 1
loadtime:3.8325901031494 / seconds
Query Executed:select id FROM `nj` where city='Vincentown' && SIC_code='0742'DB:business_master_new
loadtime:3.8452019691467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineland' limit 1
loadtime:3.8452789783478 / seconds
Query Executed:select id FROM `nj` where city='Vineland' && SIC_code='0742'DB:business_master_new
loadtime:3.8538820743561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voorhees' limit 1
loadtime:3.8539681434631 / seconds
Query Executed:select id FROM `nj` where city='Voorhees' && SIC_code='0742'DB:business_master_new
loadtime:3.8621790409088 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Collingswd Hts' limit 1
loadtime:3.8622510433197 / seconds
Query Executed:select id FROM `nj` where city='W Collingswd Hts' && SIC_code='0742'DB:business_master_new
loadtime:3.8626959323883 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Collingswood' limit 1
loadtime:3.8627519607544 / seconds
Query Executed:select id FROM `nj` where city='W Collingswood' && SIC_code='0742'DB:business_master_new
loadtime:3.8632030487061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldwick' limit 1
loadtime:3.8632559776306 / seconds
Query Executed:select id FROM `nj` where city='Waldwick' && SIC_code='0742'DB:business_master_new
loadtime:3.8710200786591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:3.8710889816284 / seconds
Query Executed:select id FROM `nj` where city='Wall' && SIC_code='0742'DB:business_master_new
loadtime:3.8728830814362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Township' limit 1
loadtime:3.8729391098022 / seconds
Query Executed:select id FROM `nj` where city='Wall Township' && SIC_code='0742'DB:business_master_new
loadtime:3.8737640380859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallington' limit 1
loadtime:3.8738191127777 / seconds
Query Executed:select id FROM `nj` where city='Wallington' && SIC_code='0742'DB:business_master_new
loadtime:3.8794231414795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallpack Center' limit 1
loadtime:3.8794870376587 / seconds
Query Executed:select id FROM `nj` where city='Wallpack Center' && SIC_code='0742'DB:business_master_new
loadtime:3.879949092865 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanaque' limit 1
loadtime:3.8800041675568 / seconds
Query Executed:select id FROM `nj` where city='Wanaque' && SIC_code='0742'DB:business_master_new
loadtime:3.8827519416809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waretown' limit 1
loadtime:3.882805109024 / seconds
Query Executed:select id FROM `nj` where city='Waretown' && SIC_code='0742'DB:business_master_new
loadtime:3.8865261077881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:3.8865909576416 / seconds
Query Executed:select id FROM `nj` where city='Warren' && SIC_code='0742'DB:business_master_new
loadtime:3.8987579345703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:3.8988299369812 / seconds
Query Executed:select id FROM `nj` where city='Washington' && SIC_code='0742'DB:business_master_new
loadtime:3.9087791442871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Twp' limit 1
loadtime:3.9088540077209 / seconds
Query Executed:select id FROM `nj` where city='Washington Twp' && SIC_code='0742'DB:business_master_new
loadtime:3.9106421470642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watchung' limit 1
loadtime:3.9107000827789 / seconds
Query Executed:select id FROM `nj` where city='Watchung' && SIC_code='0742'DB:business_master_new
loadtime:3.9180181026459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford Works' limit 1
loadtime:3.9180870056152 / seconds
Query Executed:select id FROM `nj` where city='Waterford Works' && SIC_code='0742'DB:business_master_new
loadtime:3.9202001094818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:3.9202539920807 / seconds
Query Executed:select id FROM `nj` where city='Wayne' && SIC_code='0742'DB:business_master_new
loadtime:3.9288280010223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weehawken' limit 1
loadtime:3.9289071559906 / seconds
Query Executed:select id FROM `nj` where city='Weehawken' && SIC_code='0742'DB:business_master_new
loadtime:3.9350321292877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenonah' limit 1
loadtime:3.9350950717926 / seconds
Query Executed:select id FROM `nj` where city='Wenonah' && SIC_code='0742'DB:business_master_new
loadtime:3.9379870891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Berlin' limit 1
loadtime:3.9380550384521 / seconds
Query Executed:select id FROM `nj` where city='West Berlin' && SIC_code='0742'DB:business_master_new
loadtime:3.9461660385132 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Caldwell' limit 1
loadtime:3.9462330341339 / seconds
Query Executed:select id FROM `nj` where city='West Caldwell' && SIC_code='0742'DB:business_master_new
loadtime:3.9469749927521 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cape May' limit 1
loadtime:3.9470291137695 / seconds
Query Executed:select id FROM `nj` where city='West Cape May' && SIC_code='0742'DB:business_master_new
loadtime:3.9475100040436 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Creek' limit 1
loadtime:3.9475629329681 / seconds
Query Executed:select id FROM `nj` where city='West Creek' && SIC_code='0742'DB:business_master_new
loadtime:3.9506480693817 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Long Branch' limit 1
loadtime:3.9507031440735 / seconds
Query Executed:select id FROM `nj` where city='West Long Branch' && SIC_code='0742'DB:business_master_new
loadtime:3.9587841033936 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Milford' limit 1
loadtime:3.9588389396667 / seconds
Query Executed:select id FROM `nj` where city='West Milford' && SIC_code='0742'DB:business_master_new
loadtime:3.9682109355927 / seconds
Query loaded from cache:select * from geodata_geocity where city='West New York' limit 1
loadtime:3.9682660102844 / seconds
Query Executed:select id FROM `nj` where city='West New York' && SIC_code='0742'DB:business_master_new
loadtime:3.9768090248108 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Orange' limit 1
loadtime:3.9768640995026 / seconds
Query Executed:select id FROM `nj` where city='West Orange' && SIC_code='0742'DB:business_master_new
loadtime:3.9851551055908 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Paterson' limit 1
loadtime:3.9852290153503 / seconds
Query Executed:select id FROM `nj` where city='West Paterson' && SIC_code='0742'DB:business_master_new
loadtime:3.9860870838165 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Trenton' limit 1
loadtime:3.9861431121826 / seconds
Query Executed:select id FROM `nj` where city='West Trenton' && SIC_code='0742'DB:business_master_new
loadtime:3.9867630004883 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wildwood' limit 1
loadtime:3.9868161678314 / seconds
Query Executed:select id FROM `nj` where city='West Wildwood' && SIC_code='0742'DB:business_master_new
loadtime:3.9872450828552 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:3.9872970581055 / seconds
Query Executed:select id FROM `nj` where city='West Windsor' && SIC_code='0742'DB:business_master_new
loadtime:3.9878821372986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westampton' limit 1
loadtime:3.9879350662231 / seconds
Query Executed:select id FROM `nj` where city='Westampton' && SIC_code='0742'DB:business_master_new
loadtime:3.9885020256042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:3.9885561466217 / seconds
Query Executed:select id FROM `nj` where city='Westfield' && SIC_code='0742'DB:business_master_new
loadtime:3.9967861175537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmont' limit 1
loadtime:3.9968590736389 / seconds
Query Executed:select id FROM `nj` where city='Westmont' && SIC_code='0742'DB:business_master_new
loadtime:3.9973881244659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:3.9974410533905 / seconds
Query Executed:select id FROM `nj` where city='Westville' && SIC_code='0742'DB:business_master_new
loadtime:4.0030081272125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:4.0030629634857 / seconds
Query Executed:select id FROM `nj` where city='Westwood' && SIC_code='0742'DB:business_master_new
loadtime:4.0113000869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wharton' limit 1
loadtime:4.0113689899445 / seconds
Query Executed:select id FROM `nj` where city='Wharton' && SIC_code='0742'DB:business_master_new
loadtime:4.0179409980774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whippany' limit 1
loadtime:4.0179960727692 / seconds
Query Executed:select id FROM `nj` where city='Whippany' && SIC_code='0742'DB:business_master_new
loadtime:4.0277011394501 / seconds
Query loaded from cache:select * from geodata_geocity where city='White House Station' limit 1
loadtime:4.0277700424194 / seconds
Query Executed:select id FROM `nj` where city='White House Station' && SIC_code='0742'DB:business_master_new
loadtime:4.0281970500946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse' limit 1
loadtime:4.0282490253448 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse' && SIC_code='0742'DB:business_master_new
loadtime:4.030727148056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse Sta' limit 1
loadtime:4.0307810306549 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse Sta' && SIC_code='0742'DB:business_master_new
loadtime:4.0312840938568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse Station' limit 1
loadtime:4.0313360691071 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse Station' && SIC_code='0742'DB:business_master_new
loadtime:4.0400431156158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitesboro' limit 1
loadtime:4.0401170253754 / seconds
Query Executed:select id FROM `nj` where city='Whitesboro' && SIC_code='0742'DB:business_master_new
loadtime:4.040796995163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:4.0408520698547 / seconds
Query Executed:select id FROM `nj` where city='Whiting' && SIC_code='0742'DB:business_master_new
loadtime:4.0417039394379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickatunk' limit 1
loadtime:4.0417580604553 / seconds
Query Executed:select id FROM `nj` where city='Wickatunk' && SIC_code='0742'DB:business_master_new
loadtime:4.0425181388855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wildwood' limit 1
loadtime:4.0425710678101 / seconds
Query Executed:select id FROM `nj` where city='Wildwood' && SIC_code='0742'DB:business_master_new
loadtime:4.0620019435883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wildwood Crest' limit 1
loadtime:4.06205701828 / seconds
Query Executed:select id FROM `nj` where city='Wildwood Crest' && SIC_code='0742'DB:business_master_new
loadtime:4.0627241134644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:4.0627779960632 / seconds
Query Executed:select id FROM `nj` where city='Williamstown' && SIC_code='0742'DB:business_master_new
loadtime:4.0789630413055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willingboro' limit 1
loadtime:4.079038143158 / seconds
Query Executed:select id FROM `nj` where city='Willingboro' && SIC_code='0742'DB:business_master_new
loadtime:4.0894620418549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:4.0895500183105 / seconds
Query Executed:select id FROM `nj` where city='Windsor' && SIC_code='0742'DB:business_master_new
loadtime:4.0913660526276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield Park' limit 1
loadtime:4.091423034668 / seconds
Query Executed:select id FROM `nj` where city='Winfield Park' && SIC_code='0742'DB:business_master_new
loadtime:4.0918879508972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:4.091943025589 / seconds
Query Executed:select id FROM `nj` where city='Winslow' && SIC_code='0742'DB:business_master_new
loadtime:4.0936241149902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood Ridge' limit 1
loadtime:4.0936789512634 / seconds
Query Executed:select id FROM `nj` where city='Wood Ridge' && SIC_code='0742'DB:business_master_new
loadtime:4.0981321334839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood-Ridge' limit 1
loadtime:4.0981860160828 / seconds
Query Executed:select id FROM `nj` where city='Wood-Ridge' && SIC_code='0742'DB:business_master_new
loadtime:4.098818063736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:4.0988709926605 / seconds
Query Executed:select id FROM `nj` where city='Woodbine' && SIC_code='0742'DB:business_master_new
loadtime:4.1038091182709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:4.1038620471954 / seconds
Query Executed:select id FROM `nj` where city='Woodbridge' && SIC_code='0742'DB:business_master_new
loadtime:4.1237280368805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:4.1238069534302 / seconds
Query Executed:select id FROM `nj` where city='Woodbury' && SIC_code='0742'DB:business_master_new
loadtime:4.132472038269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury Heights' limit 1
loadtime:4.1325330734253 / seconds
Query Executed:select id FROM `nj` where city='Woodbury Heights' && SIC_code='0742'DB:business_master_new
loadtime:4.1356480121613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodcliff Lake' limit 1
loadtime:4.1357171535492 / seconds
Query Executed:select id FROM `nj` where city='Woodcliff Lake' && SIC_code='0742'DB:business_master_new
loadtime:4.1418659687042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstown' limit 1
loadtime:4.141921043396 / seconds
Query Executed:select id FROM `nj` where city='Woodstown' && SIC_code='0742'DB:business_master_new
loadtime:4.149316072464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightstown' limit 1
loadtime:4.1493890285492 / seconds
Query Executed:select id FROM `nj` where city='Wrightstown' && SIC_code='0742'DB:business_master_new
loadtime:4.1535530090332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyckoff' limit 1
loadtime:4.1536321640015 / seconds
Query Executed:select id FROM `nj` where city='Wyckoff' && SIC_code='0742'DB:business_master_new
loadtime:4.1623771190643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yardville' limit 1
loadtime:4.1624569892883 / seconds
Query Executed:select id FROM `nj` where city='Yardville' && SIC_code='0742'DB:business_master_new
loadtime:4.1636500358582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zarephath' limit 1
loadtime:4.1637051105499 / seconds
Query Executed:select id FROM `nj` where city='Zarephath' && SIC_code='0742'DB:business_master_new
loadtime:4.1645350456238 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:4.1646981239319 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:4.1651661396027 / seconds
Operation template executed (chunk cache operation)
loadtime:4.1653201580048 / seconds
template override:Default
loadtime:4.1653599739075 / 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:4.1665720939636 / seconds
Template Constructed, Array Rows:49
loadtime:4.1671121120453 / seconds
TOTAL EXECUTION TIME: 4.16666
loadtime:4.1706800460815 / 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] => veterinary-services-for-animal-specialties [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:4.1706910133362
TOTAL KEY ARRAYS: 69