Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.6982040405273E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00048398971557617 / seconds
host not found setting manual db connection
loadtime:0.00084280967712402 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010960102081299 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012438297271729 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012969970703125 / seconds
zipcode:
loadtime:0.0013139247894287 / seconds
Query Executed:select * from search_referrer where page_hash='395fe2fc87578fe46648653149fad1d3' limit 10 DB:ezrox_toadli
loadtime:0.0014939308166504 / seconds
Operation header executed (non global)
loadtime:0.0015108585357666 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015428066253662 / seconds
Operation square executed (non global)
loadtime:0.0015568733215332 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015699863433838 / seconds
Operation smallsquare executed (non global)
loadtime:0.0015809535980225 / seconds
Operation headeradright executed (non global)
loadtime:0.0016059875488281 / seconds
Operation google_analytics executed (non global)
loadtime:0.0016210079193115 / seconds
Operation topstories executed (non global)
loadtime:0.0016329288482666 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0016438961029053 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0016539096832275 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018730163574219 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0020239353179932 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020627975463867 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0021297931671143 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021669864654541 / seconds
Template key: archive_menu pushed
loadtime:0.0021719932556152 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021779537200928 / seconds
Template key: get_gravatar pushed
loadtime:0.0021820068359375 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0021858215332031 / seconds
*10)-10)+1 | start:0
loadtime:0.0022079944610596 / seconds
DB connected to localhost business_master_new
loadtime:0.002424955368042 / seconds
Query Executed:select * from categories where cat_URLid='gasoline-service-station'DB:business_master_new
loadtime:0.002957820892334 / seconds
Query stored in cache : _QUERY_www.toadli.comae9eaa17c7f2f271be87cf6879e91433
loadtime:0.0029909610748291 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-jersey'
loadtime:0.0030238628387451 / seconds
Query Executed:select * from `nj_catmap` where sic='5541' order by city ascDB:business_master_new
loadtime:0.14861989021301 / seconds
Query stored in cache : _QUERY_www.toadli.comebf569758d1fe5334ba17bd45476f9d1
loadtime:0.14975094795227 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-jersey'
loadtime:0.14979791641235 / seconds
Query Executed:select sum(totalcount) as totalsum from `nj_catmap` where sic='5541'DB:business_master_new
loadtime:0.15356993675232 / seconds
Query stored in cache : _QUERY_www.toadli.com9c88c0f0f81c544299bbe59aba0ff9a9
loadtime:0.15361189842224 / seconds
696 / 11
loadtime:0.15365290641785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Absecon' limit 1
loadtime:0.15370297431946 / seconds
Query Executed:select id FROM `nj` where city='Absecon' && SIC_code='5541'DB:business_master_new
loadtime:0.19444394111633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adelphia' limit 1
loadtime:0.19450092315674 / seconds
Query Executed:select id FROM `nj` where city='Adelphia' && SIC_code='5541'DB:business_master_new
loadtime:0.19544792175293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allamuchy' limit 1
loadtime:0.19549798965454 / seconds
Query Executed:select id FROM `nj` where city='Allamuchy' && SIC_code='5541'DB:business_master_new
loadtime:0.1967408657074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allendale' limit 1
loadtime:0.19677591323853 / seconds
Query Executed:select id FROM `nj` where city='Allendale' && SIC_code='5541'DB:business_master_new
loadtime:0.19962191581726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenhurst' limit 1
loadtime:0.19967889785767 / seconds
Query Executed:select id FROM `nj` where city='Allenhurst' && SIC_code='5541'DB:business_master_new
loadtime:0.55338001251221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allentown' limit 1
loadtime:0.5534508228302 / seconds
Query Executed:select id FROM `nj` where city='Allentown' && SIC_code='5541'DB:business_master_new
loadtime:0.55537581443787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allenwood' limit 1
loadtime:0.55543088912964 / seconds
Query Executed:select id FROM `nj` where city='Allenwood' && SIC_code='5541'DB:business_master_new
loadtime:0.67913794517517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alloway' limit 1
loadtime:0.67918491363525 / seconds
Query Executed:select id FROM `nj` where city='Alloway' && SIC_code='5541'DB:business_master_new
loadtime:0.68033790588379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpha' limit 1
loadtime:0.6804358959198 / seconds
Query Executed:select id FROM `nj` where city='Alpha' && SIC_code='5541'DB:business_master_new
loadtime:0.68089890480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.6809709072113 / seconds
Query Executed:select id FROM `nj` where city='Alpine' && SIC_code='5541'DB:business_master_new
loadtime:0.78271579742432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.78276085853577 / seconds
Query Executed:select id FROM `nj` where city='Andover' && SIC_code='5541'DB:business_master_new
loadtime:0.78534698486328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annandale' limit 1
loadtime:0.78540682792664 / seconds
Query Executed:select id FROM `nj` where city='Annandale' && SIC_code='5541'DB:business_master_new
loadtime:0.78703784942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury' limit 1
loadtime:0.78707599639893 / seconds
Query Executed:select id FROM `nj` where city='Asbury' && SIC_code='5541'DB:business_master_new
loadtime:0.78861594200134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asbury Park' limit 1
loadtime:0.78866291046143 / seconds
Query Executed:select id FROM `nj` where city='Asbury Park' && SIC_code='5541'DB:business_master_new
loadtime:0.79620480537415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atco' limit 1
loadtime:0.7962589263916 / seconds
Query Executed:select id FROM `nj` where city='Atco' && SIC_code='5541'DB:business_master_new
loadtime:0.79885697364807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic City' limit 1
loadtime:0.79891085624695 / seconds
Query Executed:select id FROM `nj` where city='Atlantic City' && SIC_code='5541'DB:business_master_new
loadtime:0.80467891693115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Hghlnds' limit 1
loadtime:0.80473184585571 / seconds
Query Executed:select id FROM `nj` where city='Atlantic Hghlnds' && SIC_code='5541'DB:business_master_new
loadtime:0.80549883842468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Highlands' limit 1
loadtime:0.8055419921875 / seconds
Query Executed:select id FROM `nj` where city='Atlantic Highlands' && SIC_code='5541'DB:business_master_new
loadtime:0.81132197380066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Audubon' limit 1
loadtime:0.8113808631897 / seconds
Query Executed:select id FROM `nj` where city='Audubon' && SIC_code='5541'DB:business_master_new
loadtime:0.81463479995728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Augusta' limit 1
loadtime:0.81467986106873 / seconds
Query Executed:select id FROM `nj` where city='Augusta' && SIC_code='5541'DB:business_master_new
loadtime:0.93914890289307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avalon' limit 1
loadtime:0.93921899795532 / seconds
Query Executed:select id FROM `nj` where city='Avalon' && SIC_code='5541'DB:business_master_new
loadtime:0.94109392166138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avenel' limit 1
loadtime:0.94113683700562 / seconds
Query Executed:select id FROM `nj` where city='Avenel' && SIC_code='5541'DB:business_master_new
loadtime:0.94418001174927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon By The Sea' limit 1
loadtime:0.94423890113831 / seconds
Query Executed:select id FROM `nj` where city='Avon By The Sea' && SIC_code='5541'DB:business_master_new
loadtime:0.94597792625427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baptistown' limit 1
loadtime:0.94602394104004 / seconds
Query Executed:select id FROM `nj` where city='Baptistown' && SIC_code='5541'DB:business_master_new
loadtime:0.94672179222107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnegat' limit 1
loadtime:0.94677186012268 / seconds
Query Executed:select id FROM `nj` where city='Barnegat' && SIC_code='5541'DB:business_master_new
loadtime:0.94928097724915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnegat Light' limit 1
loadtime:0.94933795928955 / seconds
Query Executed:select id FROM `nj` where city='Barnegat Light' && SIC_code='5541'DB:business_master_new
loadtime:1.0149319171906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barrington' limit 1
loadtime:1.0149688720703 / seconds
Query Executed:select id FROM `nj` where city='Barrington' && SIC_code='5541'DB:business_master_new
loadtime:1.0166509151459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Basking Ridge' limit 1
loadtime:1.0167529582977 / seconds
Query Executed:select id FROM `nj` where city='Basking Ridge' && SIC_code='5541'DB:business_master_new
loadtime:1.0207228660583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Head' limit 1
loadtime:1.020801782608 / seconds
Query Executed:select id FROM `nj` where city='Bay Head' && SIC_code='5541'DB:business_master_new
loadtime:1.0229849815369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayonne' limit 1
loadtime:1.0230708122253 / seconds
Query Executed:select id FROM `nj` where city='Bayonne' && SIC_code='5541'DB:business_master_new
loadtime:1.0318138599396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayville' limit 1
loadtime:1.0318739414215 / seconds
Query Executed:select id FROM `nj` where city='Bayville' && SIC_code='5541'DB:business_master_new
loadtime:1.0354909896851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beach Haven' limit 1
loadtime:1.0355508327484 / seconds
Query Executed:select id FROM `nj` where city='Beach Haven' && SIC_code='5541'DB:business_master_new
loadtime:1.0525588989258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beachwood' limit 1
loadtime:1.0526208877563 / seconds
Query Executed:select id FROM `nj` where city='Beachwood' && SIC_code='5541'DB:business_master_new
loadtime:1.0544300079346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedminster' limit 1
loadtime:1.054477930069 / seconds
Query Executed:select id FROM `nj` where city='Bedminster' && SIC_code='5541'DB:business_master_new
loadtime:1.0578849315643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belford' limit 1
loadtime:1.0579319000244 / seconds
Query Executed:select id FROM `nj` where city='Belford' && SIC_code='5541'DB:business_master_new
loadtime:1.0609998703003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Mead' limit 1
loadtime:1.0610349178314 / seconds
Query Executed:select id FROM `nj` where city='Belle Mead' && SIC_code='5541'DB:business_master_new
loadtime:1.0650908946991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belleville' limit 1
loadtime:1.0651497840881 / seconds
Query Executed:select id FROM `nj` where city='Belleville' && SIC_code='5541'DB:business_master_new
loadtime:1.0798118114471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellmawr' limit 1
loadtime:1.0798628330231 / seconds
Query Executed:select id FROM `nj` where city='Bellmawr' && SIC_code='5541'DB:business_master_new
loadtime:1.0825998783112 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmar' limit 1
loadtime:1.0827209949493 / seconds
Query Executed:select id FROM `nj` where city='Belmar' && SIC_code='5541'DB:business_master_new
loadtime:1.1213119029999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:1.1214399337769 / seconds
Query Executed:select id FROM `nj` where city='Belvidere' && SIC_code='5541'DB:business_master_new
loadtime:1.1260058879852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bergenfield' limit 1
loadtime:1.1260669231415 / seconds
Query Executed:select id FROM `nj` where city='Bergenfield' && SIC_code='5541'DB:business_master_new
loadtime:1.1286418437958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berkeley Heights' limit 1
loadtime:1.1286878585815 / seconds
Query Executed:select id FROM `nj` where city='Berkeley Heights' && SIC_code='5541'DB:business_master_new
loadtime:1.1455438137054 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:1.1456158161163 / seconds
Query Executed:select id FROM `nj` where city='Berlin' && SIC_code='5541'DB:business_master_new
loadtime:1.1496288776398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bernardsville' limit 1
loadtime:1.1496758460999 / seconds
Query Executed:select id FROM `nj` where city='Bernardsville' && SIC_code='5541'DB:business_master_new
loadtime:1.1522138118744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beverly' limit 1
loadtime:1.1522738933563 / seconds
Query Executed:select id FROM `nj` where city='Beverly' && SIC_code='5541'DB:business_master_new
loadtime:1.154905796051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:1.1549508571625 / seconds
Query Executed:select id FROM `nj` where city='Birmingham' && SIC_code='5541'DB:business_master_new
loadtime:1.1554629802704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blackwood' limit 1
loadtime:1.1555128097534 / seconds
Query Executed:select id FROM `nj` where city='Blackwood' && SIC_code='5541'DB:business_master_new
loadtime:1.1916689872742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blairstown' limit 1
loadtime:1.1917238235474 / seconds
Query Executed:select id FROM `nj` where city='Blairstown' && SIC_code='5541'DB:business_master_new
loadtime:1.193755865097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blawenburg' limit 1
loadtime:1.1938149929047 / seconds
Query Executed:select id FROM `nj` where city='Blawenburg' && SIC_code='5541'DB:business_master_new
loadtime:1.1943509578705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:1.1943979263306 / seconds
Query Executed:select id FROM `nj` where city='Bloomfield' && SIC_code='5541'DB:business_master_new
loadtime:1.2494609355927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomingdale' limit 1
loadtime:1.2495219707489 / seconds
Query Executed:select id FROM `nj` where city='Bloomingdale' && SIC_code='5541'DB:business_master_new
loadtime:1.2531838417053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomsbury' limit 1
loadtime:1.2532448768616 / seconds
Query Executed:select id FROM `nj` where city='Bloomsbury' && SIC_code='5541'DB:business_master_new
loadtime:1.4071998596191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bogota' limit 1
loadtime:1.4072549343109 / seconds
Query Executed:select id FROM `nj` where city='Bogota' && SIC_code='5541'DB:business_master_new
loadtime:1.4103219509125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonton' limit 1
loadtime:1.410383939743 / seconds
Query Executed:select id FROM `nj` where city='Boonton' && SIC_code='5541'DB:business_master_new
loadtime:1.4354000091553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bordentown' limit 1
loadtime:1.4354479312897 / seconds
Query Executed:select id FROM `nj` where city='Bordentown' && SIC_code='5541'DB:business_master_new
loadtime:1.4478178024292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bound Brook' limit 1
loadtime:1.4478878974915 / seconds
Query Executed:select id FROM `nj` where city='Bound Brook' && SIC_code='5541'DB:business_master_new
loadtime:1.4536669254303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradley Beach' limit 1
loadtime:1.4537189006805 / seconds
Query Executed:select id FROM `nj` where city='Bradley Beach' && SIC_code='5541'DB:business_master_new
loadtime:1.4566249847412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchburg' limit 1
loadtime:1.4566798210144 / seconds
Query Executed:select id FROM `nj` where city='Branchburg' && SIC_code='5541'DB:business_master_new
loadtime:1.4576728343964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:1.457722902298 / seconds
Query Executed:select id FROM `nj` where city='Branchville' && SIC_code='5541'DB:business_master_new
loadtime:1.4615409374237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brick' limit 1
loadtime:1.4615869522095 / seconds
Query Executed:select id FROM `nj` where city='Brick' && SIC_code='5541'DB:business_master_new
loadtime:1.5032269954681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:1.5032958984375 / seconds
Query Executed:select id FROM `nj` where city='Bridgeport' && SIC_code='5541'DB:business_master_new
loadtime:1.5649988651276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:1.565043926239 / seconds
Query Executed:select id FROM `nj` where city='Bridgeton' && SIC_code='5541'DB:business_master_new
loadtime:1.5723009109497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:1.5723669528961 / seconds
Query Executed:select id FROM `nj` where city='Bridgewater' && SIC_code='5541'DB:business_master_new
loadtime:1.5762028694153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brielle' limit 1
loadtime:1.5762498378754 / seconds
Query Executed:select id FROM `nj` where city='Brielle' && SIC_code='5541'DB:business_master_new
loadtime:1.5952978134155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brigantine' limit 1
loadtime:1.5953569412231 / seconds
Query Executed:select id FROM `nj` where city='Brigantine' && SIC_code='5541'DB:business_master_new
loadtime:1.6001598834991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:1.6002199649811 / seconds
Query Executed:select id FROM `nj` where city='Broadway' && SIC_code='5541'DB:business_master_new
loadtime:1.6014518737793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklawn' limit 1
loadtime:1.6014888286591 / seconds
Query Executed:select id FROM `nj` where city='Brooklawn' && SIC_code='5541'DB:business_master_new
loadtime:1.6022617816925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookside' limit 1
loadtime:1.6023199558258 / seconds
Query Executed:select id FROM `nj` where city='Brookside' && SIC_code='5541'DB:business_master_new
loadtime:1.6038680076599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Mills' limit 1
loadtime:1.6039040088654 / seconds
Query Executed:select id FROM `nj` where city='Browns Mills' && SIC_code='5541'DB:business_master_new
loadtime:1.6078488826752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Budd Lake' limit 1
loadtime:1.6079058647156 / seconds
Query Executed:select id FROM `nj` where city='Budd Lake' && SIC_code='5541'DB:business_master_new
loadtime:1.612851858139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buena' limit 1
loadtime:1.6129078865051 / seconds
Query Executed:select id FROM `nj` where city='Buena' && SIC_code='5541'DB:business_master_new
loadtime:1.7287797927856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:1.7288689613342 / seconds
Query Executed:select id FROM `nj` where city='Burlington' && SIC_code='5541'DB:business_master_new
loadtime:1.7345099449158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:1.734561920166 / seconds
Query Executed:select id FROM `nj` where city='Butler' && SIC_code='5541'DB:business_master_new
loadtime:1.7380568981171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buttzville' limit 1
loadtime:1.7381258010864 / seconds
Query Executed:select id FROM `nj` where city='Buttzville' && SIC_code='5541'DB:business_master_new
loadtime:1.7386980056763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caldwell' limit 1
loadtime:1.7387428283691 / seconds
Query Executed:select id FROM `nj` where city='Caldwell' && SIC_code='5541'DB:business_master_new
loadtime:1.7443678379059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Califon' limit 1
loadtime:1.7444179058075 / seconds
Query Executed:select id FROM `nj` where city='Califon' && SIC_code='5541'DB:business_master_new
loadtime:1.7461547851562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:1.7462918758392 / seconds
Query Executed:select id FROM `nj` where city='Camden' && SIC_code='5541'DB:business_master_new
loadtime:1.7514319419861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May' limit 1
loadtime:1.7514779567719 / seconds
Query Executed:select id FROM `nj` where city='Cape May' && SIC_code='5541'DB:business_master_new
loadtime:1.7558288574219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Court House' limit 1
loadtime:1.7560429573059 / seconds
Query Executed:select id FROM `nj` where city='Cape May Court House' && SIC_code='5541'DB:business_master_new
loadtime:1.7601118087769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Ct Hse' limit 1
loadtime:1.7601590156555 / seconds
Query Executed:select id FROM `nj` where city='Cape May Ct Hse' && SIC_code='5541'DB:business_master_new
loadtime:1.7615687847137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape May Point' limit 1
loadtime:1.7616310119629 / seconds
Query Executed:select id FROM `nj` where city='Cape May Point' && SIC_code='5541'DB:business_master_new
loadtime:1.7623288631439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carlstadt' limit 1
loadtime:1.762363910675 / seconds
Query Executed:select id FROM `nj` where city='Carlstadt' && SIC_code='5541'DB:business_master_new
loadtime:1.7671389579773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carneys Point' limit 1
loadtime:1.7671988010406 / seconds
Query Executed:select id FROM `nj` where city='Carneys Point' && SIC_code='5541'DB:business_master_new
loadtime:1.7677419185638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carteret' limit 1
loadtime:1.7677879333496 / seconds
Query Executed:select id FROM `nj` where city='Carteret' && SIC_code='5541'DB:business_master_new
loadtime:1.7836968898773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Brook' limit 1
loadtime:1.7838258743286 / seconds
Query Executed:select id FROM `nj` where city='Cedar Brook' && SIC_code='5541'DB:business_master_new
loadtime:1.7851498126984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:1.7853000164032 / seconds
Query Executed:select id FROM `nj` where city='Cedar Grove' && SIC_code='5541'DB:business_master_new
loadtime:1.7883489131927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Knolls' limit 1
loadtime:1.7885119915009 / seconds
Query Executed:select id FROM `nj` where city='Cedar Knolls' && SIC_code='5541'DB:business_master_new
loadtime:1.7902808189392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedarville' limit 1
loadtime:1.7904238700867 / seconds
Query Executed:select id FROM `nj` where city='Cedarville' && SIC_code='5541'DB:business_master_new
loadtime:1.7918388843536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Changewater' limit 1
loadtime:1.7920370101929 / seconds
Query Executed:select id FROM `nj` where city='Changewater' && SIC_code='5541'DB:business_master_new
loadtime:1.7926378250122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:1.7927358150482 / seconds
Query Executed:select id FROM `nj` where city='Chatham' && SIC_code='5541'DB:business_master_new
loadtime:1.7965757846832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatsworth' limit 1
loadtime:1.7967708110809 / seconds
Query Executed:select id FROM `nj` where city='Chatsworth' && SIC_code='5541'DB:business_master_new
loadtime:1.7977838516235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Hill' limit 1
loadtime:1.7978818416595 / seconds
Query Executed:select id FROM `nj` where city='Cherry Hill' && SIC_code='5541'DB:business_master_new
loadtime:1.842052936554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesilhurst' limit 1
loadtime:1.8422718048096 / seconds
Query Executed:select id FROM `nj` where city='Chesilhurst' && SIC_code='5541'DB:business_master_new
loadtime:1.8427908420563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:1.8428709506989 / seconds
Query Executed:select id FROM `nj` where city='Chester' && SIC_code='5541'DB:business_master_new
loadtime:1.8474078178406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cinnaminson' limit 1
loadtime:1.8475699424744 / seconds
Query Executed:select id FROM `nj` where city='Cinnaminson' && SIC_code='5541'DB:business_master_new
loadtime:1.8488318920135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clark' limit 1
loadtime:1.84898686409 / seconds
Query Executed:select id FROM `nj` where city='Clark' && SIC_code='5541'DB:business_master_new
loadtime:1.8655698299408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksboro' limit 1
loadtime:1.8657310009003 / seconds
Query Executed:select id FROM `nj` where city='Clarksboro' && SIC_code='5541'DB:business_master_new
loadtime:1.8673198223114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksburg' limit 1
loadtime:1.8674759864807 / seconds
Query Executed:select id FROM `nj` where city='Clarksburg' && SIC_code='5541'DB:business_master_new
loadtime:1.8681387901306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:1.8682708740234 / seconds
Query Executed:select id FROM `nj` where city='Clayton' && SIC_code='5541'DB:business_master_new
loadtime:1.8699038028717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clementon' limit 1
loadtime:1.8699998855591 / seconds
Query Executed:select id FROM `nj` where city='Clementon' && SIC_code='5541'DB:business_master_new
loadtime:1.8783128261566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside Park' limit 1
loadtime:1.8784959316254 / seconds
Query Executed:select id FROM `nj` where city='Cliffside Park' && SIC_code='5541'DB:business_master_new
loadtime:1.8823139667511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffwood' limit 1
loadtime:1.882444858551 / seconds
Query Executed:select id FROM `nj` where city='Cliffwood' && SIC_code='5541'DB:business_master_new
loadtime:1.9838240146637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clifton' limit 1
loadtime:1.9840078353882 / seconds
Query Executed:select id FROM `nj` where city='Clifton' && SIC_code='5541'DB:business_master_new
loadtime:2.0112159252167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:2.011403799057 / seconds
Query Executed:select id FROM `nj` where city='Clinton' && SIC_code='5541'DB:business_master_new
loadtime:2.016902923584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Closter' limit 1
loadtime:2.0170760154724 / seconds
Query Executed:select id FROM `nj` where city='Closter' && SIC_code='5541'DB:business_master_new
loadtime:2.0190958976746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collingswood' limit 1
loadtime:2.0192558765411 / seconds
Query Executed:select id FROM `nj` where city='Collingswood' && SIC_code='5541'DB:business_master_new
loadtime:2.0238208770752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cologne' limit 1
loadtime:2.0239498615265 / seconds
Query Executed:select id FROM `nj` where city='Cologne' && SIC_code='5541'DB:business_master_new
loadtime:2.0251848697662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colonia' limit 1
loadtime:2.025319814682 / seconds
Query Executed:select id FROM `nj` where city='Colonia' && SIC_code='5541'DB:business_master_new
loadtime:2.0297179222107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colts Neck' limit 1
loadtime:2.0298500061035 / seconds
Query Executed:select id FROM `nj` where city='Colts Neck' && SIC_code='5541'DB:business_master_new
loadtime:2.032753944397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:2.0329148769379 / seconds
Query Executed:select id FROM `nj` where city='Columbia' && SIC_code='5541'DB:business_master_new
loadtime:2.0360589027405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:2.036180973053 / seconds
Query Executed:select id FROM `nj` where city='Columbus' && SIC_code='5541'DB:business_master_new
loadtime:2.0392868518829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Convent Station' limit 1
loadtime:2.0394458770752 / seconds
Query Executed:select id FROM `nj` where city='Convent Station' && SIC_code='5541'DB:business_master_new
loadtime:2.0404679775238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cookstown' limit 1
loadtime:2.0405819416046 / seconds
Query Executed:select id FROM `nj` where city='Cookstown' && SIC_code='5541'DB:business_master_new
loadtime:2.0417289733887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corbin City' limit 1
loadtime:2.0418930053711 / seconds
Query Executed:select id FROM `nj` where city='Corbin City' && SIC_code='5541'DB:business_master_new
loadtime:2.0425779819489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranbury' limit 1
loadtime:2.0427467823029 / seconds
Query Executed:select id FROM `nj` where city='Cranbury' && SIC_code='5541'DB:business_master_new
loadtime:2.0484337806702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cranford' limit 1
loadtime:2.0485618114471 / seconds
Query Executed:select id FROM `nj` where city='Cranford' && SIC_code='5541'DB:business_master_new
loadtime:2.0815389156342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cream Ridge' limit 1
loadtime:2.0817489624023 / seconds
Query Executed:select id FROM `nj` where city='Cream Ridge' && SIC_code='5541'DB:business_master_new
loadtime:2.0837769508362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creamridge' limit 1
loadtime:2.0838968753815 / seconds
Query Executed:select id FROM `nj` where city='Creamridge' && SIC_code='5541'DB:business_master_new
loadtime:2.0846688747406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cresskill' limit 1
loadtime:2.0848038196564 / seconds
Query Executed:select id FROM `nj` where city='Cresskill' && SIC_code='5541'DB:business_master_new
loadtime:2.0905578136444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crosswicks' limit 1
loadtime:2.0907258987427 / seconds
Query Executed:select id FROM `nj` where city='Crosswicks' && SIC_code='5541'DB:business_master_new
loadtime:2.091374874115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayton' limit 1
loadtime:2.0915088653564 / seconds
Query Executed:select id FROM `nj` where city='Dayton' && SIC_code='5541'DB:business_master_new
loadtime:2.0938148498535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deal' limit 1
loadtime:2.0939319133759 / seconds
Query Executed:select id FROM `nj` where city='Deal' && SIC_code='5541'DB:business_master_new
loadtime:2.0964939594269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deepwater' limit 1
loadtime:2.0966618061066 / seconds
Query Executed:select id FROM `nj` where city='Deepwater' && SIC_code='5541'DB:business_master_new
loadtime:2.0974879264832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield Street' limit 1
loadtime:2.0976738929749 / seconds
Query Executed:select id FROM `nj` where city='Deerfield Street' && SIC_code='5541'DB:business_master_new
loadtime:2.0984129905701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Del Haven' limit 1
loadtime:2.0985097885132 / seconds
Query Executed:select id FROM `nj` where city='Del Haven' && SIC_code='5541'DB:business_master_new
loadtime:2.0989258289337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delair' limit 1
loadtime:2.0990419387817 / seconds
Query Executed:select id FROM `nj` where city='Delair' && SIC_code='5541'DB:business_master_new
loadtime:2.0997359752655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delanco' limit 1
loadtime:2.0998058319092 / seconds
Query Executed:select id FROM `nj` where city='Delanco' && SIC_code='5541'DB:business_master_new
loadtime:2.1004858016968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delaware' limit 1
loadtime:2.1006548404694 / seconds
Query Executed:select id FROM `nj` where city='Delaware' && SIC_code='5541'DB:business_master_new
loadtime:2.1014239788055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmont' limit 1
loadtime:2.1015439033508 / seconds
Query Executed:select id FROM `nj` where city='Delmont' && SIC_code='5541'DB:business_master_new
loadtime:2.1021108627319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delran' limit 1
loadtime:2.1022448539734 / seconds
Query Executed:select id FROM `nj` where city='Delran' && SIC_code='5541'DB:business_master_new
loadtime:2.1035759449005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Demarest' limit 1
loadtime:2.1037628650665 / seconds
Query Executed:select id FROM `nj` where city='Demarest' && SIC_code='5541'DB:business_master_new
loadtime:2.1054899692535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dennisville' limit 1
loadtime:2.1055870056152 / seconds
Query Executed:select id FROM `nj` where city='Dennisville' && SIC_code='5541'DB:business_master_new
loadtime:2.106714963913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denville' limit 1
loadtime:2.1068799495697 / seconds
Query Executed:select id FROM `nj` where city='Denville' && SIC_code='5541'DB:business_master_new
loadtime:2.1124517917633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deptford' limit 1
loadtime:2.1126308441162 / seconds
Query Executed:select id FROM `nj` where city='Deptford' && SIC_code='5541'DB:business_master_new
loadtime:2.1867029666901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dividing Creek' limit 1
loadtime:2.1870419979095 / seconds
Query Executed:select id FROM `nj` where city='Dividing Creek' && SIC_code='5541'DB:business_master_new
loadtime:2.1877689361572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:2.1878659725189 / seconds
Query Executed:select id FROM `nj` where city='Dorchester' && SIC_code='5541'DB:business_master_new
loadtime:2.1885747909546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorothy' limit 1
loadtime:2.1887638568878 / seconds
Query Executed:select id FROM `nj` where city='Dorothy' && SIC_code='5541'DB:business_master_new
loadtime:2.1898729801178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:2.1899788379669 / seconds
Query Executed:select id FROM `nj` where city='Dover' && SIC_code='5541'DB:business_master_new
loadtime:2.1960289478302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dumont' limit 1
loadtime:2.1962029933929 / seconds
Query Executed:select id FROM `nj` where city='Dumont' && SIC_code='5541'DB:business_master_new
loadtime:2.2087109088898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunellen' limit 1
loadtime:2.2087569236755 / seconds
Query Executed:select id FROM `nj` where city='Dunellen' && SIC_code='5541'DB:business_master_new
loadtime:2.2283599376678 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brunswick' limit 1
loadtime:2.228423833847 / seconds
Query Executed:select id FROM `nj` where city='East Brunswick' && SIC_code='5541'DB:business_master_new
loadtime:2.2369179725647 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hanover' limit 1
loadtime:2.2369740009308 / seconds
Query Executed:select id FROM `nj` where city='East Hanover' && SIC_code='5541'DB:business_master_new
loadtime:2.2401478290558 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Millstone' limit 1
loadtime:2.2402079105377 / seconds
Query Executed:select id FROM `nj` where city='East Millstone' && SIC_code='5541'DB:business_master_new
loadtime:2.2405688762665 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Newark' limit 1
loadtime:2.2406179904938 / seconds
Query Executed:select id FROM `nj` where city='East Newark' && SIC_code='5541'DB:business_master_new
loadtime:2.2409708499908 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Orange' limit 1
loadtime:2.2410178184509 / seconds
Query Executed:select id FROM `nj` where city='East Orange' && SIC_code='5541'DB:business_master_new
loadtime:2.2488880157471 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Rutherford' limit 1
loadtime:2.2489588260651 / seconds
Query Executed:select id FROM `nj` where city='East Rutherford' && SIC_code='5541'DB:business_master_new
loadtime:2.2527098655701 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:2.2527589797974 / seconds
Query Executed:select id FROM `nj` where city='East Windsor' && SIC_code='5541'DB:business_master_new
loadtime:2.2535769939423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eatontown' limit 1
loadtime:2.2536408901215 / seconds
Query Executed:select id FROM `nj` where city='Eatontown' && SIC_code='5541'DB:business_master_new
loadtime:2.260185956955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater' limit 1
loadtime:2.2602479457855 / seconds
Query Executed:select id FROM `nj` where city='Edgewater' && SIC_code='5541'DB:business_master_new
loadtime:2.2630310058594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edgewater Park' limit 1
loadtime:2.2630758285522 / seconds
Query Executed:select id FROM `nj` where city='Edgewater Park' && SIC_code='5541'DB:business_master_new
loadtime:2.2635009288788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edison' limit 1
loadtime:2.2635498046875 / seconds
Query Executed:select id FROM `nj` where city='Edison' && SIC_code='5541'DB:business_master_new
loadtime:2.2952358722687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor City' limit 1
loadtime:2.2953097820282 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor City' && SIC_code='5541'DB:business_master_new
loadtime:2.298996925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor Township' limit 1
loadtime:2.2990570068359 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor Township' && SIC_code='5541'DB:business_master_new
loadtime:2.3155648708344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Egg Harbor Twp' limit 1
loadtime:2.3156428337097 / seconds
Query Executed:select id FROM `nj` where city='Egg Harbor Twp' && SIC_code='5541'DB:business_master_new
loadtime:2.3800399303436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth' limit 1
loadtime:2.3801298141479 / seconds
Query Executed:select id FROM `nj` where city='Elizabeth' && SIC_code='5541'DB:business_master_new
loadtime:2.410640001297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmer' limit 1
loadtime:2.4107367992401 / seconds
Query Executed:select id FROM `nj` where city='Elmer' && SIC_code='5541'DB:business_master_new
loadtime:2.4132058620453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmwood Park' limit 1
loadtime:2.4132528305054 / seconds
Query Executed:select id FROM `nj` where city='Elmwood Park' && SIC_code='5541'DB:business_master_new
loadtime:2.4177107810974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elwood' limit 1
loadtime:2.4177758693695 / seconds
Query Executed:select id FROM `nj` where city='Elwood' && SIC_code='5541'DB:business_master_new
loadtime:2.4186599254608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerson' limit 1
loadtime:2.4187178611755 / seconds
Query Executed:select id FROM `nj` where city='Emerson' && SIC_code='5541'DB:business_master_new
loadtime:2.4210438728333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood' limit 1
loadtime:2.421101808548 / seconds
Query Executed:select id FROM `nj` where city='Englewood' && SIC_code='5541'DB:business_master_new
loadtime:2.4334509372711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englewood Cliffs' limit 1
loadtime:2.4335179328918 / seconds
Query Executed:select id FROM `nj` where city='Englewood Cliffs' && SIC_code='5541'DB:business_master_new
loadtime:2.4375779628754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Englishtown' limit 1
loadtime:2.4376528263092 / seconds
Query Executed:select id FROM `nj` where city='Englishtown' && SIC_code='5541'DB:business_master_new
loadtime:2.453516960144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex Fells' limit 1
loadtime:2.4535818099976 / seconds
Query Executed:select id FROM `nj` where city='Essex Fells' && SIC_code='5541'DB:business_master_new
loadtime:2.4548609256744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estell Manor' limit 1
loadtime:2.4549148082733 / seconds
Query Executed:select id FROM `nj` where city='Estell Manor' && SIC_code='5541'DB:business_master_new
loadtime:2.455953836441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewan' limit 1
loadtime:2.4560158252716 / seconds
Query Executed:select id FROM `nj` where city='Ewan' && SIC_code='5541'DB:business_master_new
loadtime:2.4564969539642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Haven' limit 1
loadtime:2.45654296875 / seconds
Query Executed:select id FROM `nj` where city='Fair Haven' && SIC_code='5541'DB:business_master_new
loadtime:2.459203004837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Lawn' limit 1
loadtime:2.4592669010162 / seconds
Query Executed:select id FROM `nj` where city='Fair Lawn' && SIC_code='5541'DB:business_master_new
loadtime:2.4651839733124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:2.4653759002686 / seconds
Query Executed:select id FROM `nj` where city='Fairfield' && SIC_code='5541'DB:business_master_new
loadtime:2.4714879989624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairton' limit 1
loadtime:2.4715528488159 / seconds
Query Executed:select id FROM `nj` where city='Fairton' && SIC_code='5541'DB:business_master_new
loadtime:2.4724159240723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:2.4725728034973 / seconds
Query Executed:select id FROM `nj` where city='Fairview' && SIC_code='5541'DB:business_master_new
loadtime:2.475350856781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fanwood' limit 1
loadtime:2.475508928299 / seconds
Query Executed:select id FROM `nj` where city='Fanwood' && SIC_code='5541'DB:business_master_new
loadtime:2.4801709651947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Far Hills' limit 1
loadtime:2.4802298545837 / seconds
Query Executed:select id FROM `nj` where city='Far Hills' && SIC_code='5541'DB:business_master_new
loadtime:2.4817569255829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmingdale' limit 1
loadtime:2.4818069934845 / seconds
Query Executed:select id FROM `nj` where city='Farmingdale' && SIC_code='5541'DB:business_master_new
loadtime:2.4853608608246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fieldsboro' limit 1
loadtime:2.4854209423065 / seconds
Query Executed:select id FROM `nj` where city='Fieldsboro' && SIC_code='5541'DB:business_master_new
loadtime:2.4857668876648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flagtown' limit 1
loadtime:2.4858059883118 / seconds
Query Executed:select id FROM `nj` where city='Flagtown' && SIC_code='5541'DB:business_master_new
loadtime:2.4863889217377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flanders' limit 1
loadtime:2.4864358901978 / seconds
Query Executed:select id FROM `nj` where city='Flanders' && SIC_code='5541'DB:business_master_new
loadtime:2.5010228157043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flemington' limit 1
loadtime:2.5010828971863 / seconds
Query Executed:select id FROM `nj` where city='Flemington' && SIC_code='5541'DB:business_master_new
loadtime:2.5336308479309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:2.5337009429932 / seconds
Query Executed:select id FROM `nj` where city='Florence' && SIC_code='5541'DB:business_master_new
loadtime:2.5352199077606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florham Park' limit 1
loadtime:2.5352628231049 / seconds
Query Executed:select id FROM `nj` where city='Florham Park' && SIC_code='5541'DB:business_master_new
loadtime:2.5380198955536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fords' limit 1
loadtime:2.5380778312683 / seconds
Query Executed:select id FROM `nj` where city='Fords' && SIC_code='5541'DB:business_master_new
loadtime:2.5410089492798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forked River' limit 1
loadtime:2.5410549640656 / seconds
Query Executed:select id FROM `nj` where city='Forked River' && SIC_code='5541'DB:business_master_new
loadtime:2.5443170070648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Dix' limit 1
loadtime:2.5443868637085 / seconds
Query Executed:select id FROM `nj` where city='Fort Dix' && SIC_code='5541'DB:business_master_new
loadtime:2.5454659461975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Hancock' limit 1
loadtime:2.5455188751221 / seconds
Query Executed:select id FROM `nj` where city='Fort Hancock' && SIC_code='5541'DB:business_master_new
loadtime:2.5459039211273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Lee' limit 1
loadtime:2.5459558963776 / seconds
Query Executed:select id FROM `nj` where city='Fort Lee' && SIC_code='5541'DB:business_master_new
loadtime:2.5576629638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Monmouth' limit 1
loadtime:2.5577359199524 / seconds
Query Executed:select id FROM `nj` where city='Fort Monmouth' && SIC_code='5541'DB:business_master_new
loadtime:2.5588028430939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fortescue' limit 1
loadtime:2.558849811554 / seconds
Query Executed:select id FROM `nj` where city='Fortescue' && SIC_code='5541'DB:business_master_new
loadtime:2.5593988895416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.5594339370728 / seconds
Query Executed:select id FROM `nj` where city='Franklin' && SIC_code='5541'DB:business_master_new
loadtime:2.5616958141327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin Lakes' limit 1
loadtime:2.5617568492889 / seconds
Query Executed:select id FROM `nj` where city='Franklin Lakes' && SIC_code='5541'DB:business_master_new
loadtime:2.5699110031128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin Park' limit 1
loadtime:2.5699639320374 / seconds
Query Executed:select id FROM `nj` where city='Franklin Park' && SIC_code='5541'DB:business_master_new
loadtime:2.5730309486389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:2.5730907917023 / seconds
Query Executed:select id FROM `nj` where city='Franklinville' && SIC_code='5541'DB:business_master_new
loadtime:2.5756359100342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fredon' limit 1
loadtime:2.5756978988647 / seconds
Query Executed:select id FROM `nj` where city='Fredon' && SIC_code='5541'DB:business_master_new
loadtime:2.5760869979858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freehold' limit 1
loadtime:2.5761229991913 / seconds
Query Executed:select id FROM `nj` where city='Freehold' && SIC_code='5541'DB:business_master_new
loadtime:2.649493932724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frenchtown' limit 1
loadtime:2.6495718955994 / seconds
Query Executed:select id FROM `nj` where city='Frenchtown' && SIC_code='5541'DB:business_master_new
loadtime:2.6521549224854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Galloway' limit 1
loadtime:2.6521999835968 / seconds
Query Executed:select id FROM `nj` where city='Galloway' && SIC_code='5541'DB:business_master_new
loadtime:2.6528418064117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garfield' limit 1
loadtime:2.6528987884521 / seconds
Query Executed:select id FROM `nj` where city='Garfield' && SIC_code='5541'DB:business_master_new
loadtime:2.6565098762512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garwood' limit 1
loadtime:2.6565699577332 / seconds
Query Executed:select id FROM `nj` where city='Garwood' && SIC_code='5541'DB:business_master_new
loadtime:2.6588168144226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibbsboro' limit 1
loadtime:2.6588618755341 / seconds
Query Executed:select id FROM `nj` where city='Gibbsboro' && SIC_code='5541'DB:business_master_new
loadtime:2.6611578464508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibbstown' limit 1
loadtime:2.6612148284912 / seconds
Query Executed:select id FROM `nj` where city='Gibbstown' && SIC_code='5541'DB:business_master_new
loadtime:2.8121349811554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gillette' limit 1
loadtime:2.8122098445892 / seconds
Query Executed:select id FROM `nj` where city='Gillette' && SIC_code='5541'DB:business_master_new
loadtime:2.8143978118896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gladstone' limit 1
loadtime:2.8144559860229 / seconds
Query Executed:select id FROM `nj` where city='Gladstone' && SIC_code='5541'DB:business_master_new
loadtime:2.8956348896027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glassboro' limit 1
loadtime:2.8957238197327 / seconds
Query Executed:select id FROM `nj` where city='Glassboro' && SIC_code='5541'DB:business_master_new
loadtime:2.8997218608856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasser' limit 1
loadtime:2.8997898101807 / seconds
Query Executed:select id FROM `nj` where city='Glasser' && SIC_code='5541'DB:business_master_new
loadtime:2.9001829624176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Gardner' limit 1
loadtime:2.9002149105072 / seconds
Query Executed:select id FROM `nj` where city='Glen Gardner' && SIC_code='5541'DB:business_master_new
loadtime:2.9017548561096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Ridge' limit 1
loadtime:2.9017930030823 / seconds
Query Executed:select id FROM `nj` where city='Glen Ridge' && SIC_code='5541'DB:business_master_new
loadtime:2.9033010005951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Rock' limit 1
loadtime:2.9033379554749 / seconds
Query Executed:select id FROM `nj` where city='Glen Rock' && SIC_code='5541'DB:business_master_new
loadtime:2.906986951828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendora' limit 1
loadtime:2.9070298671722 / seconds
Query Executed:select id FROM `nj` where city='Glendora' && SIC_code='5541'DB:business_master_new
loadtime:2.9836800098419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:2.9837999343872 / seconds
Query Executed:select id FROM `nj` where city='Glenwood' && SIC_code='5541'DB:business_master_new
loadtime:2.9851558208466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester City' limit 1
loadtime:2.9852068424225 / seconds
Query Executed:select id FROM `nj` where city='Gloucester City' && SIC_code='5541'DB:business_master_new
loadtime:3.0127818584442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:3.0129539966583 / seconds
Query Executed:select id FROM `nj` where city='Goshen' && SIC_code='5541'DB:business_master_new
loadtime:3.0145909786224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Great Meadows' limit 1
loadtime:3.0147788524628 / seconds
Query Executed:select id FROM `nj` where city='Great Meadows' && SIC_code='5541'DB:business_master_new
loadtime:3.0184278488159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Brook' limit 1
loadtime:3.0185468196869 / seconds
Query Executed:select id FROM `nj` where city='Green Brook' && SIC_code='5541'DB:business_master_new
loadtime:3.0199179649353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Creek' limit 1
loadtime:3.0200459957123 / seconds
Query Executed:select id FROM `nj` where city='Green Creek' && SIC_code='5541'DB:business_master_new
loadtime:3.0222058296204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Village' limit 1
loadtime:3.0223608016968 / seconds
Query Executed:select id FROM `nj` where city='Green Village' && SIC_code='5541'DB:business_master_new
loadtime:3.0248358249664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greendell' limit 1
loadtime:3.0249907970428 / seconds
Query Executed:select id FROM `nj` where city='Greendell' && SIC_code='5541'DB:business_master_new
loadtime:3.0267059803009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:3.0268399715424 / seconds
Query Executed:select id FROM `nj` where city='Greenwich' && SIC_code='5541'DB:business_master_new
loadtime:3.0294759273529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grenloch' limit 1
loadtime:3.0296738147736 / seconds
Query Executed:select id FROM `nj` where city='Grenloch' && SIC_code='5541'DB:business_master_new
loadtime:3.0310399532318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greystone Park' limit 1
loadtime:3.0311858654022 / seconds
Query Executed:select id FROM `nj` where city='Greystone Park' && SIC_code='5541'DB:business_master_new
loadtime:3.0323898792267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guttenberg' limit 1
loadtime:3.0325219631195 / seconds
Query Executed:select id FROM `nj` where city='Guttenberg' && SIC_code='5541'DB:business_master_new
loadtime:3.0337748527527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackensack' limit 1
loadtime:3.0339148044586 / seconds
Query Executed:select id FROM `nj` where city='Hackensack' && SIC_code='5541'DB:business_master_new
loadtime:3.0487248897552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackettstown' limit 1
loadtime:3.0487959384918 / seconds
Query Executed:select id FROM `nj` where city='Hackettstown' && SIC_code='5541'DB:business_master_new
loadtime:3.0546178817749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddon Heights' limit 1
loadtime:3.0546908378601 / seconds
Query Executed:select id FROM `nj` where city='Haddon Heights' && SIC_code='5541'DB:business_master_new
loadtime:3.0568869113922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddon Twp' limit 1
loadtime:3.0569357872009 / seconds
Query Executed:select id FROM `nj` where city='Haddon Twp' && SIC_code='5541'DB:business_master_new
loadtime:3.0573408603668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddonfield' limit 1
loadtime:3.0573909282684 / seconds
Query Executed:select id FROM `nj` where city='Haddonfield' && SIC_code='5541'DB:business_master_new
loadtime:3.0612418651581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hainesport' limit 1
loadtime:3.0614068508148 / seconds
Query Executed:select id FROM `nj` where city='Hainesport' && SIC_code='5541'DB:business_master_new
loadtime:3.0654139518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haledon' limit 1
loadtime:3.0654609203339 / seconds
Query Executed:select id FROM `nj` where city='Haledon' && SIC_code='5541'DB:business_master_new
loadtime:3.070384979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamburg' limit 1
loadtime:3.0705490112305 / seconds
Query Executed:select id FROM `nj` where city='Hamburg' && SIC_code='5541'DB:business_master_new
loadtime:3.0740509033203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hammonton' limit 1
loadtime:3.0740969181061 / seconds
Query Executed:select id FROM `nj` where city='Hammonton' && SIC_code='5541'DB:business_master_new
loadtime:3.0927979946136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:3.0928637981415 / seconds
Query Executed:select id FROM `nj` where city='Hampton' && SIC_code='5541'DB:business_master_new
loadtime:3.0978357791901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancocks Bridge' limit 1
loadtime:3.0979068279266 / seconds
Query Executed:select id FROM `nj` where city='Hancocks Bridge' && SIC_code='5541'DB:business_master_new
loadtime:3.0986239910126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hardwick' limit 1
loadtime:3.0986759662628 / seconds
Query Executed:select id FROM `nj` where city='Hardwick' && SIC_code='5541'DB:business_master_new
loadtime:3.0990159511566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrington Park' limit 1
loadtime:3.0990498065948 / seconds
Query Executed:select id FROM `nj` where city='Harrington Park' && SIC_code='5541'DB:business_master_new
loadtime:3.100555896759 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrison' limit 1
loadtime:3.1006219387054 / seconds
Query Executed:select id FROM `nj` where city='Harrison' && SIC_code='5541'DB:business_master_new
loadtime:3.1046979427338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisonville' limit 1
loadtime:3.1047599315643 / seconds
Query Executed:select id FROM `nj` where city='Harrisonville' && SIC_code='5541'DB:business_master_new
loadtime:3.105400800705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvey Cedars' limit 1
loadtime:3.1054508686066 / seconds
Query Executed:select id FROM `nj` where city='Harvey Cedars' && SIC_code='5541'DB:business_master_new
loadtime:3.1059157848358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasbrouck Heights' limit 1
loadtime:3.1059699058533 / seconds
Query Executed:select id FROM `nj` where city='Hasbrouck Heights' && SIC_code='5541'DB:business_master_new
loadtime:3.1278829574585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hasbrouck Hts' limit 1
loadtime:3.1279339790344 / seconds
Query Executed:select id FROM `nj` where city='Hasbrouck Hts' && SIC_code='5541'DB:business_master_new
loadtime:3.1286249160767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haskell' limit 1
loadtime:3.1286737918854 / seconds
Query Executed:select id FROM `nj` where city='Haskell' && SIC_code='5541'DB:business_master_new
loadtime:3.21058177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haworth' limit 1
loadtime:3.2106728553772 / seconds
Query Executed:select id FROM `nj` where city='Haworth' && SIC_code='5541'DB:business_master_new
loadtime:3.2141478061676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawthorne' limit 1
loadtime:3.214183807373 / seconds
Query Executed:select id FROM `nj` where city='Hawthorne' && SIC_code='5541'DB:business_master_new
loadtime:3.2237319946289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazlet' limit 1
loadtime:3.2237849235535 / seconds
Query Executed:select id FROM `nj` where city='Hazlet' && SIC_code='5541'DB:business_master_new
loadtime:3.2389228343964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heislerville' limit 1
loadtime:3.2389838695526 / seconds
Query Executed:select id FROM `nj` where city='Heislerville' && SIC_code='5541'DB:business_master_new
loadtime:3.2395157814026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helmetta' limit 1
loadtime:3.239560842514 / seconds
Query Executed:select id FROM `nj` where city='Helmetta' && SIC_code='5541'DB:business_master_new
loadtime:3.2405729293823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hewitt' limit 1
loadtime:3.2406477928162 / seconds
Query Executed:select id FROM `nj` where city='Hewitt' && SIC_code='5541'DB:business_master_new
loadtime:3.2431008815765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hibernia' limit 1
loadtime:3.243145942688 / seconds
Query Executed:select id FROM `nj` where city='Hibernia' && SIC_code='5541'DB:business_master_new
loadtime:3.2437899112701 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Bridge' limit 1
loadtime:3.2438299655914 / seconds
Query Executed:select id FROM `nj` where city='High Bridge' && SIC_code='5541'DB:business_master_new
loadtime:3.2453119754791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Lakes' limit 1
loadtime:3.2453618049622 / seconds
Query Executed:select id FROM `nj` where city='Highland Lakes' && SIC_code='5541'DB:business_master_new
loadtime:3.2469108104706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Park' limit 1
loadtime:3.2469689846039 / seconds
Query Executed:select id FROM `nj` where city='Highland Park' && SIC_code='5541'DB:business_master_new
loadtime:3.2497289180756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:3.249773979187 / seconds
Query Executed:select id FROM `nj` where city='Highlands' && SIC_code='5541'DB:business_master_new
loadtime:3.2513239383698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hightstown' limit 1
loadtime:3.2513828277588 / seconds
Query Executed:select id FROM `nj` where city='Hightstown' && SIC_code='5541'DB:business_master_new
loadtime:3.2585809230804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:3.2586557865143 / seconds
Query Executed:select id FROM `nj` where city='Hillsborough' && SIC_code='5541'DB:business_master_new
loadtime:3.2630848884583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsdale' limit 1
loadtime:3.2631390094757 / seconds
Query Executed:select id FROM `nj` where city='Hillsdale' && SIC_code='5541'DB:business_master_new
loadtime:3.2786128520966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillside' limit 1
loadtime:3.2786738872528 / seconds
Query Executed:select id FROM `nj` where city='Hillside' && SIC_code='5541'DB:business_master_new
loadtime:3.2842848300934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ho Ho Kus' limit 1
loadtime:3.284334897995 / seconds
Query Executed:select id FROM `nj` where city='Ho Ho Kus' && SIC_code='5541'DB:business_master_new
loadtime:3.288106918335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoboken' limit 1
loadtime:3.288165807724 / seconds
Query Executed:select id FROM `nj` where city='Hoboken' && SIC_code='5541'DB:business_master_new
loadtime:3.2933158874512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holmdel' limit 1
loadtime:3.2933700084686 / seconds
Query Executed:select id FROM `nj` where city='Holmdel' && SIC_code='5541'DB:business_master_new
loadtime:3.3085789680481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopatcong' limit 1
loadtime:3.308650970459 / seconds
Query Executed:select id FROM `nj` where city='Hopatcong' && SIC_code='5541'DB:business_master_new
loadtime:3.310986995697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope' limit 1
loadtime:3.3110318183899 / seconds
Query Executed:select id FROM `nj` where city='Hope' && SIC_code='5541'DB:business_master_new
loadtime:3.3919568061829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopewell' limit 1
loadtime:3.3920328617096 / seconds
Query Executed:select id FROM `nj` where city='Hopewell' && SIC_code='5541'DB:business_master_new
loadtime:3.3982179164886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:3.3982779979706 / seconds
Query Executed:select id FROM `nj` where city='Howell' && SIC_code='5541'DB:business_master_new
loadtime:3.4171497821808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Imlaystown' limit 1
loadtime:3.4172008037567 / seconds
Query Executed:select id FROM `nj` where city='Imlaystown' && SIC_code='5541'DB:business_master_new
loadtime:3.4177119731903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Interlaken' limit 1
loadtime:3.4177539348602 / seconds
Query Executed:select id FROM `nj` where city='Interlaken' && SIC_code='5541'DB:business_master_new
loadtime:3.4180908203125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ironia' limit 1
loadtime:3.4181349277496 / seconds
Query Executed:select id FROM `nj` where city='Ironia' && SIC_code='5541'DB:business_master_new
loadtime:3.4189858436584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:3.4190459251404 / seconds
Query Executed:select id FROM `nj` where city='Irvington' && SIC_code='5541'DB:business_master_new
loadtime:3.4317438602448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iselin' limit 1
loadtime:3.4319269657135 / seconds
Query Executed:select id FROM `nj` where city='Iselin' && SIC_code='5541'DB:business_master_new
loadtime:3.4586498737335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Island Heights' limit 1
loadtime:3.4587118625641 / seconds
Query Executed:select id FROM `nj` where city='Island Heights' && SIC_code='5541'DB:business_master_new
loadtime:3.5910317897797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:3.5911359786987 / seconds
Query Executed:select id FROM `nj` where city='Jackson' && SIC_code='5541'DB:business_master_new
loadtime:3.5956559181213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesburg' limit 1
loadtime:3.5957179069519 / seconds
Query Executed:select id FROM `nj` where city='Jamesburg' && SIC_code='5541'DB:business_master_new
loadtime:3.5971097946167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jersey City' limit 1
loadtime:3.5971488952637 / seconds
Query Executed:select id FROM `nj` where city='Jersey City' && SIC_code='5541'DB:business_master_new
loadtime:3.6182498931885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jobstown' limit 1
loadtime:3.618479013443 / seconds
Query Executed:select id FROM `nj` where city='Jobstown' && SIC_code='5541'DB:business_master_new
loadtime:3.6202178001404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Johnsonburg' limit 1
loadtime:3.620386838913 / seconds
Query Executed:select id FROM `nj` where city='Johnsonburg' && SIC_code='5541'DB:business_master_new
loadtime:3.6219348907471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Juliustown' limit 1
loadtime:3.622074842453 / seconds
Query Executed:select id FROM `nj` where city='Juliustown' && SIC_code='5541'DB:business_master_new
loadtime:3.6234939098358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keansburg' limit 1
loadtime:3.6235899925232 / seconds
Query Executed:select id FROM `nj` where city='Keansburg' && SIC_code='5541'DB:business_master_new
loadtime:3.6307718753815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearny' limit 1
loadtime:3.6308298110962 / seconds
Query Executed:select id FROM `nj` where city='Kearny' && SIC_code='5541'DB:business_master_new
loadtime:3.6386649608612 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keasbey' limit 1
loadtime:3.6387197971344 / seconds
Query Executed:select id FROM `nj` where city='Keasbey' && SIC_code='5541'DB:business_master_new
loadtime:3.6400098800659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kendall Park' limit 1
loadtime:3.6400618553162 / seconds
Query Executed:select id FROM `nj` where city='Kendall Park' && SIC_code='5541'DB:business_master_new
loadtime:3.6427779197693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:3.6428217887878 / seconds
Query Executed:select id FROM `nj` where city='Kenilworth' && SIC_code='5541'DB:business_master_new
loadtime:3.6520638465881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenvil' limit 1
loadtime:3.6521408557892 / seconds
Query Executed:select id FROM `nj` where city='Kenvil' && SIC_code='5541'DB:business_master_new
loadtime:3.6541128158569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keyport' limit 1
loadtime:3.6541409492493 / seconds
Query Executed:select id FROM `nj` where city='Keyport' && SIC_code='5541'DB:business_master_new
loadtime:3.657243013382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:3.6572918891907 / seconds
Query Executed:select id FROM `nj` where city='Kingston' && SIC_code='5541'DB:business_master_new
loadtime:3.751179933548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinnelon' limit 1
loadtime:3.7512919902802 / seconds
Query Executed:select id FROM `nj` where city='Kinnelon' && SIC_code='5541'DB:business_master_new
loadtime:3.7520999908447 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:3.7521347999573 / seconds
Query Executed:select id FROM `nj` where city='Lafayette' && SIC_code='5541'DB:business_master_new
loadtime:3.7546098232269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Hiawatha' limit 1
loadtime:3.7547187805176 / seconds
Query Executed:select id FROM `nj` where city='Lake Hiawatha' && SIC_code='5541'DB:business_master_new
loadtime:3.7575988769531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Hopatcong' limit 1
loadtime:3.7576649188995 / seconds
Query Executed:select id FROM `nj` where city='Lake Hopatcong' && SIC_code='5541'DB:business_master_new
loadtime:3.7615149021149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakehurst' limit 1
loadtime:3.7616419792175 / seconds
Query Executed:select id FROM `nj` where city='Lakehurst' && SIC_code='5541'DB:business_master_new
loadtime:3.7643718719482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakewood' limit 1
loadtime:3.7644279003143 / seconds
Query Executed:select id FROM `nj` where city='Lakewood' && SIC_code='5541'DB:business_master_new
loadtime:3.780345916748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lambertville' limit 1
loadtime:3.7804229259491 / seconds
Query Executed:select id FROM `nj` where city='Lambertville' && SIC_code='5541'DB:business_master_new
loadtime:3.7835659980774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landing' limit 1
loadtime:3.7836389541626 / seconds
Query Executed:select id FROM `nj` where city='Landing' && SIC_code='5541'DB:business_master_new
loadtime:3.7869079113007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landisville' limit 1
loadtime:3.786985874176 / seconds
Query Executed:select id FROM `nj` where city='Landisville' && SIC_code='5541'DB:business_master_new
loadtime:3.7888100147247 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanoka Harbor' limit 1
loadtime:3.7889089584351 / seconds
Query Executed:select id FROM `nj` where city='Lanoka Harbor' && SIC_code='5541'DB:business_master_new
loadtime:3.7926368713379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:3.7927157878876 / seconds
Query Executed:select id FROM `nj` where city='Laurel Springs' && SIC_code='5541'DB:business_master_new
loadtime:3.7938408851624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurence Harbor' limit 1
loadtime:3.7939310073853 / seconds
Query Executed:select id FROM `nj` where city='Laurence Harbor' && SIC_code='5541'DB:business_master_new
loadtime:3.794900894165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lavallette' limit 1
loadtime:3.7950048446655 / seconds
Query Executed:select id FROM `nj` where city='Lavallette' && SIC_code='5541'DB:business_master_new
loadtime:3.7983119487762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawnside' limit 1
loadtime:3.7983558177948 / seconds
Query Executed:select id FROM `nj` where city='Lawnside' && SIC_code='5541'DB:business_master_new
loadtime:3.8308417797089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawrenceville' limit 1
loadtime:3.8309237957001 / seconds
Query Executed:select id FROM `nj` where city='Lawrenceville' && SIC_code='5541'DB:business_master_new
loadtime:3.910285949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:3.9103498458862 / seconds
Query Executed:select id FROM `nj` where city='Layton' && SIC_code='5541'DB:business_master_new
loadtime:3.9110398292542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:3.9110808372498 / seconds
Query Executed:select id FROM `nj` where city='Lebanon' && SIC_code='5541'DB:business_master_new
loadtime:3.9158828258514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledgewood' limit 1
loadtime:3.9159939289093 / seconds
Query Executed:select id FROM `nj` where city='Ledgewood' && SIC_code='5541'DB:business_master_new
loadtime:3.9200208187103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds Point' limit 1
loadtime:3.9200618267059 / seconds
Query Executed:select id FROM `nj` where city='Leeds Point' && SIC_code='5541'DB:business_master_new
loadtime:3.920786857605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:3.9208528995514 / seconds
Query Executed:select id FROM `nj` where city='Leesburg' && SIC_code='5541'DB:business_master_new
loadtime:3.9220008850098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonardo' limit 1
loadtime:3.9220669269562 / seconds
Query Executed:select id FROM `nj` where city='Leonardo' && SIC_code='5541'DB:business_master_new
loadtime:4.051472902298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leonia' limit 1
loadtime:4.0515148639679 / seconds
Query Executed:select id FROM `nj` where city='Leonia' && SIC_code='5541'DB:business_master_new
loadtime:4.0536618232727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty Corner' limit 1
loadtime:4.0537118911743 / seconds
Query Executed:select id FROM `nj` where city='Liberty Corner' && SIC_code='5541'DB:business_master_new
loadtime:4.055083990097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln Park' limit 1
loadtime:4.0551359653473 / seconds
Query Executed:select id FROM `nj` where city='Lincoln Park' && SIC_code='5541'DB:business_master_new
loadtime:4.0591878890991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincroft' limit 1
loadtime:4.0593569278717 / seconds
Query Executed:select id FROM `nj` where city='Lincroft' && SIC_code='5541'DB:business_master_new
loadtime:4.0630037784576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:4.0631628036499 / seconds
Query Executed:select id FROM `nj` where city='Linden' && SIC_code='5541'DB:business_master_new
loadtime:4.0732028484344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindenwold' limit 1
loadtime:4.0732748508453 / seconds
Query Executed:select id FROM `nj` where city='Lindenwold' && SIC_code='5541'DB:business_master_new
loadtime:4.0739188194275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:4.0739688873291 / seconds
Query Executed:select id FROM `nj` where city='Linwood' && SIC_code='5541'DB:business_master_new
loadtime:4.0773229598999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Egg Hbr' limit 1
loadtime:4.0774707794189 / seconds
Query Executed:select id FROM `nj` where city='Little Egg Hbr' && SIC_code='5541'DB:business_master_new
loadtime:4.0787289142609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Falls' limit 1
loadtime:4.0787758827209 / seconds
Query Executed:select id FROM `nj` where city='Little Falls' && SIC_code='5541'DB:business_master_new
loadtime:4.0865199565887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Ferry' limit 1
loadtime:4.08673787117 / seconds
Query Executed:select id FROM `nj` where city='Little Ferry' && SIC_code='5541'DB:business_master_new
loadtime:4.0902149677277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Silver' limit 1
loadtime:4.0903458595276 / seconds
Query Executed:select id FROM `nj` where city='Little Silver' && SIC_code='5541'DB:business_master_new
loadtime:4.0953109264374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little York' limit 1
loadtime:4.0954627990723 / seconds
Query Executed:select id FROM `nj` where city='Little York' && SIC_code='5541'DB:business_master_new
loadtime:4.0965847969055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:4.0967450141907 / seconds
Query Executed:select id FROM `nj` where city='Livingston' && SIC_code='5541'DB:business_master_new
loadtime:4.1023647785187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lodi' limit 1
loadtime:4.1025350093842 / seconds
Query Executed:select id FROM `nj` where city='Lodi' && SIC_code='5541'DB:business_master_new
loadtime:4.1088287830353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach' limit 1
loadtime:4.1088948249817 / seconds
Query Executed:select id FROM `nj` where city='Long Beach' && SIC_code='5541'DB:business_master_new
loadtime:4.1098749637604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Beach Twp' limit 1
loadtime:4.1099739074707 / seconds
Query Executed:select id FROM `nj` where city='Long Beach Twp' && SIC_code='5541'DB:business_master_new
loadtime:4.1110589504242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Branch' limit 1
loadtime:4.1111869812012 / seconds
Query Executed:select id FROM `nj` where city='Long Branch' && SIC_code='5541'DB:business_master_new
loadtime:4.1171028614044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Long Valley' limit 1
loadtime:4.117164850235 / seconds
Query Executed:select id FROM `nj` where city='Long Valley' && SIC_code='5541'DB:business_master_new
loadtime:4.1203269958496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longport' limit 1
loadtime:4.1203858852386 / seconds
Query Executed:select id FROM `nj` where city='Longport' && SIC_code='5541'DB:business_master_new
loadtime:4.1216969490051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:4.1217429637909 / seconds
Query Executed:select id FROM `nj` where city='Lumberton' && SIC_code='5541'DB:business_master_new
loadtime:4.1236658096313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyndhurst' limit 1
loadtime:4.1237227916718 / seconds
Query Executed:select id FROM `nj` where city='Lyndhurst' && SIC_code='5541'DB:business_master_new
loadtime:4.1299698352814 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyons' limit 1
loadtime:4.1300339698792 / seconds
Query Executed:select id FROM `nj` where city='Lyons' && SIC_code='5541'DB:business_master_new
loadtime:4.1305048465729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:4.1305418014526 / seconds
Query Executed:select id FROM `nj` where city='Madison' && SIC_code='5541'DB:business_master_new
loadtime:4.135381937027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:4.1354658603668 / seconds
Query Executed:select id FROM `nj` where city='Magnolia' && SIC_code='5541'DB:business_master_new
loadtime:4.1944479942322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mahwah' limit 1
loadtime:4.1945199966431 / seconds
Query Executed:select id FROM `nj` where city='Mahwah' && SIC_code='5541'DB:business_master_new
loadtime:4.2032129764557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malaga' limit 1
loadtime:4.2032690048218 / seconds
Query Executed:select id FROM `nj` where city='Malaga' && SIC_code='5541'DB:business_master_new
loadtime:4.2060849666595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manahawkin' limit 1
loadtime:4.2062559127808 / seconds
Query Executed:select id FROM `nj` where city='Manahawkin' && SIC_code='5541'DB:business_master_new
loadtime:4.2120218276978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manalapan' limit 1
loadtime:4.2120668888092 / seconds
Query Executed:select id FROM `nj` where city='Manalapan' && SIC_code='5541'DB:business_master_new
loadtime:4.2950139045715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manasquan' limit 1
loadtime:4.2950739860535 / seconds
Query Executed:select id FROM `nj` where city='Manasquan' && SIC_code='5541'DB:business_master_new
loadtime:4.2987267971039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:4.2987909317017 / seconds
Query Executed:select id FROM `nj` where city='Manchester' && SIC_code='5541'DB:business_master_new
loadtime:4.2993788719177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester Township' limit 1
loadtime:4.2994248867035 / seconds
Query Executed:select id FROM `nj` where city='Manchester Township' && SIC_code='5541'DB:business_master_new
loadtime:4.3029799461365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantoloking' limit 1
loadtime:4.3030729293823 / seconds
Query Executed:select id FROM `nj` where city='Mantoloking' && SIC_code='5541'DB:business_master_new
loadtime:4.3057248592377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:4.3057940006256 / seconds
Query Executed:select id FROM `nj` where city='Mantua' && SIC_code='5541'DB:business_master_new
loadtime:4.3192999362946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manville' limit 1
loadtime:4.3194198608398 / seconds
Query Executed:select id FROM `nj` where city='Manville' && SIC_code='5541'DB:business_master_new
loadtime:4.3242239952087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Shade' limit 1
loadtime:4.3242819309235 / seconds
Query Executed:select id FROM `nj` where city='Maple Shade' && SIC_code='5541'DB:business_master_new
loadtime:4.3324828147888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplewood' limit 1
loadtime:4.3325488567352 / seconds
Query Executed:select id FROM `nj` where city='Maplewood' && SIC_code='5541'DB:business_master_new
loadtime:4.3396549224854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margate City' limit 1
loadtime:4.3398327827454 / seconds
Query Executed:select id FROM `nj` where city='Margate City' && SIC_code='5541'DB:business_master_new
loadtime:4.3442828655243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlboro' limit 1
loadtime:4.3444039821625 / seconds
Query Executed:select id FROM `nj` where city='Marlboro' && SIC_code='5541'DB:business_master_new
loadtime:4.3491039276123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlton' limit 1
loadtime:4.3491640090942 / seconds
Query Executed:select id FROM `nj` where city='Marlton' && SIC_code='5541'DB:business_master_new
loadtime:4.4128630161285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marmora' limit 1
loadtime:4.4129178524017 / seconds
Query Executed:select id FROM `nj` where city='Marmora' && SIC_code='5541'DB:business_master_new
loadtime:4.4156179428101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Martinsville' limit 1
loadtime:4.4156680107117 / seconds
Query Executed:select id FROM `nj` where city='Martinsville' && SIC_code='5541'DB:business_master_new
loadtime:4.4174838066101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matawan' limit 1
loadtime:4.4175188541412 / seconds
Query Executed:select id FROM `nj` where city='Matawan' && SIC_code='5541'DB:business_master_new
loadtime:4.4216787815094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mauricetown' limit 1
loadtime:4.4217309951782 / seconds
Query Executed:select id FROM `nj` where city='Mauricetown' && SIC_code='5541'DB:business_master_new
loadtime:4.422278881073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mays Landing' limit 1
loadtime:4.4223117828369 / seconds
Query Executed:select id FROM `nj` where city='Mays Landing' && SIC_code='5541'DB:business_master_new
loadtime:4.4401578903198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maywood' limit 1
loadtime:4.4402039051056 / seconds
Query Executed:select id FROM `nj` where city='Maywood' && SIC_code='5541'DB:business_master_new
loadtime:4.4432318210602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Afee' limit 1
loadtime:4.443274974823 / seconds
Query Executed:select id FROM `nj` where city='Mc Afee' && SIC_code='5541'DB:business_master_new
loadtime:4.4444849491119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Guire Afb' limit 1
loadtime:4.4445278644562 / seconds
Query Executed:select id FROM `nj` where city='Mc Guire Afb' && SIC_code='5541'DB:business_master_new
loadtime:4.4449498653412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford' limit 1
loadtime:4.4449849128723 / seconds
Query Executed:select id FROM `nj` where city='Medford' && SIC_code='5541'DB:business_master_new
loadtime:4.449236869812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Medford Lakes' limit 1
loadtime:4.4492959976196 / seconds
Query Executed:select id FROM `nj` where city='Medford Lakes' && SIC_code='5541'DB:business_master_new
loadtime:4.4496479034424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendham' limit 1
loadtime:4.4496929645538 / seconds
Query Executed:select id FROM `nj` where city='Mendham' && SIC_code='5541'DB:business_master_new
loadtime:4.4516518115997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mercerville' limit 1
loadtime:4.451807975769 / seconds
Query Executed:select id FROM `nj` where city='Mercerville' && SIC_code='5541'DB:business_master_new
loadtime:4.4528768062592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merchantville' limit 1
loadtime:4.453017950058 / seconds
Query Executed:select id FROM `nj` where city='Merchantville' && SIC_code='5541'DB:business_master_new
loadtime:4.456738948822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Metuchen' limit 1
loadtime:4.4567859172821 / seconds
Query Executed:select id FROM `nj` where city='Metuchen' && SIC_code='5541'DB:business_master_new
loadtime:4.4621708393097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mickleton' limit 1
loadtime:4.4622359275818 / seconds
Query Executed:select id FROM `nj` where city='Mickleton' && SIC_code='5541'DB:business_master_new
loadtime:4.5015218257904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:4.501580953598 / seconds
Query Executed:select id FROM `nj` where city='Middlesex' && SIC_code='5541'DB:business_master_new
loadtime:4.5225629806519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:4.5226359367371 / seconds
Query Executed:select id FROM `nj` where city='Middletown' && SIC_code='5541'DB:business_master_new
loadtime:4.5386939048767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleville' limit 1
loadtime:4.5387690067291 / seconds
Query Executed:select id FROM `nj` where city='Middleville' && SIC_code='5541'DB:business_master_new
loadtime:4.5393218994141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland Park' limit 1
loadtime:4.5394148826599 / seconds
Query Executed:select id FROM `nj` where city='Midland Park' && SIC_code='5541'DB:business_master_new
loadtime:4.5417230129242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:4.5418238639832 / seconds
Query Executed:select id FROM `nj` where city='Milford' && SIC_code='5541'DB:business_master_new
loadtime:4.5436789989471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millburn' limit 1
loadtime:4.5437779426575 / seconds
Query Executed:select id FROM `nj` where city='Millburn' && SIC_code='5541'DB:business_master_new
loadtime:4.5466558933258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millington' limit 1
loadtime:4.5467348098755 / seconds
Query Executed:select id FROM `nj` where city='Millington' && SIC_code='5541'DB:business_master_new
loadtime:4.5488758087158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millstone Twp' limit 1
loadtime:4.5489339828491 / seconds
Query Executed:select id FROM `nj` where city='Millstone Twp' && SIC_code='5541'DB:business_master_new
loadtime:4.5492749214172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milltown' limit 1
loadtime:4.5493078231812 / seconds
Query Executed:select id FROM `nj` where city='Milltown' && SIC_code='5541'DB:business_master_new
loadtime:4.5516488552094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:4.5516970157623 / seconds
Query Executed:select id FROM `nj` where city='Millville' && SIC_code='5541'DB:business_master_new
loadtime:4.5544970035553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milmay' limit 1
loadtime:4.5545439720154 / seconds
Query Executed:select id FROM `nj` where city='Milmay' && SIC_code='5541'DB:business_master_new
loadtime:4.5552988052368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mine Hill' limit 1
loadtime:4.5553338527679 / seconds
Query Executed:select id FROM `nj` where city='Mine Hill' && SIC_code='5541'DB:business_master_new
loadtime:4.5566399097443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minotola' limit 1
loadtime:4.5566828250885 / seconds
Query Executed:select id FROM `nj` where city='Minotola' && SIC_code='5541'DB:business_master_new
loadtime:4.5576989650726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mizpah' limit 1
loadtime:4.5577387809753 / seconds
Query Executed:select id FROM `nj` where city='Mizpah' && SIC_code='5541'DB:business_master_new
loadtime:4.5581870079041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Beach' limit 1
loadtime:4.5582118034363 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Beach' && SIC_code='5541'DB:business_master_new
loadtime:4.5595369338989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Jct' limit 1
loadtime:4.5595719814301 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Jct' && SIC_code='5541'DB:business_master_new
loadtime:4.5599939823151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monmouth Junction' limit 1
loadtime:4.5600409507751 / seconds
Query Executed:select id FROM `nj` where city='Monmouth Junction' && SIC_code='5541'DB:business_master_new
loadtime:4.5635139942169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Township' limit 1
loadtime:4.5635578632355 / seconds
Query Executed:select id FROM `nj` where city='Monroe Township' && SIC_code='5541'DB:business_master_new
loadtime:4.5661389827728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe Twp' limit 1
loadtime:4.5661838054657 / seconds
Query Executed:select id FROM `nj` where city='Monroe Twp' && SIC_code='5541'DB:business_master_new
loadtime:4.5672647953033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroeville' limit 1
loadtime:4.5673158168793 / seconds
Query Executed:select id FROM `nj` where city='Monroeville' && SIC_code='5541'DB:business_master_new
loadtime:4.6659069061279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montague' limit 1
loadtime:4.665965795517 / seconds
Query Executed:select id FROM `nj` where city='Montague' && SIC_code='5541'DB:business_master_new
loadtime:4.6678628921509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montclair' limit 1
loadtime:4.667918920517 / seconds
Query Executed:select id FROM `nj` where city='Montclair' && SIC_code='5541'DB:business_master_new
loadtime:4.6876327991486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montvale' limit 1
loadtime:4.6877129077911 / seconds
Query Executed:select id FROM `nj` where city='Montvale' && SIC_code='5541'DB:business_master_new
loadtime:4.6918067932129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:4.6918749809265 / seconds
Query Executed:select id FROM `nj` where city='Montville' && SIC_code='5541'DB:business_master_new
loadtime:4.6939899921417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moonachie' limit 1
loadtime:4.6940398216248 / seconds
Query Executed:select id FROM `nj` where city='Moonachie' && SIC_code='5541'DB:business_master_new
loadtime:4.6954038143158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moorestown' limit 1
loadtime:4.6954429149628 / seconds
Query Executed:select id FROM `nj` where city='Moorestown' && SIC_code='5541'DB:business_master_new
loadtime:4.6982979774475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganville' limit 1
loadtime:4.6983468532562 / seconds
Query Executed:select id FROM `nj` where city='Morganville' && SIC_code='5541'DB:business_master_new
loadtime:4.7005789279938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris Plains' limit 1
loadtime:4.7006239891052 / seconds
Query Executed:select id FROM `nj` where city='Morris Plains' && SIC_code='5541'DB:business_master_new
loadtime:4.7043378353119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morristown' limit 1
loadtime:4.704384803772 / seconds
Query Executed:select id FROM `nj` where city='Morristown' && SIC_code='5541'DB:business_master_new
loadtime:4.7105119228363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Arlington' limit 1
loadtime:4.7105779647827 / seconds
Query Executed:select id FROM `nj` where city='Mount Arlington' && SIC_code='5541'DB:business_master_new
loadtime:4.7122778892517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ephraim' limit 1
loadtime:4.7123348712921 / seconds
Query Executed:select id FROM `nj` where city='Mount Ephraim' && SIC_code='5541'DB:business_master_new
loadtime:4.714656829834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Freedom' limit 1
loadtime:4.7147178649902 / seconds
Query Executed:select id FROM `nj` where city='Mount Freedom' && SIC_code='5541'DB:business_master_new
loadtime:4.7158479690552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:4.7159199714661 / seconds
Query Executed:select id FROM `nj` where city='Mount Holly' && SIC_code='5541'DB:business_master_new
loadtime:4.7194747924805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Laurel' limit 1
loadtime:4.7195229530334 / seconds
Query Executed:select id FROM `nj` where city='Mount Laurel' && SIC_code='5541'DB:business_master_new
loadtime:4.7240769863129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Royal' limit 1
loadtime:4.7241408824921 / seconds
Query Executed:select id FROM `nj` where city='Mount Royal' && SIC_code='5541'DB:business_master_new
loadtime:4.7249817848206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Tabor' limit 1
loadtime:4.725035905838 / seconds
Query Executed:select id FROM `nj` where city='Mount Tabor' && SIC_code='5541'DB:business_master_new
loadtime:4.7256817817688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Lakes' limit 1
loadtime:4.7257258892059 / seconds
Query Executed:select id FROM `nj` where city='Mountain Lakes' && SIC_code='5541'DB:business_master_new
loadtime:4.7271139621735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountainside' limit 1
loadtime:4.7271618843079 / seconds
Query Executed:select id FROM `nj` where city='Mountainside' && SIC_code='5541'DB:business_master_new
loadtime:4.7308468818665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Arlington' limit 1
loadtime:4.7309098243713 / seconds
Query Executed:select id FROM `nj` where city='Mt Arlington' && SIC_code='5541'DB:business_master_new
loadtime:4.7313868999481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ephraim' limit 1
loadtime:4.7314360141754 / seconds
Query Executed:select id FROM `nj` where city='Mt Ephraim' && SIC_code='5541'DB:business_master_new
loadtime:4.7317938804626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Freedom' limit 1
loadtime:4.7318379878998 / seconds
Query Executed:select id FROM `nj` where city='Mt Freedom' && SIC_code='5541'DB:business_master_new
loadtime:4.7322788238525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:4.73233294487 / seconds
Query Executed:select id FROM `nj` where city='Mt Holly' && SIC_code='5541'DB:business_master_new
loadtime:4.7333858013153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Laurel' limit 1
loadtime:4.7334408760071 / seconds
Query Executed:select id FROM `nj` where city='Mt Laurel' && SIC_code='5541'DB:business_master_new
loadtime:4.8363528251648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Royal' limit 1
loadtime:4.8364229202271 / seconds
Query Executed:select id FROM `nj` where city='Mt Royal' && SIC_code='5541'DB:business_master_new
loadtime:4.8367748260498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Tabor' limit 1
loadtime:4.8368139266968 / seconds
Query Executed:select id FROM `nj` where city='Mt Tabor' && SIC_code='5541'DB:business_master_new
loadtime:4.8372008800507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mullica Hill' limit 1
loadtime:4.8372437953949 / seconds
Query Executed:select id FROM `nj` where city='Mullica Hill' && SIC_code='5541'DB:business_master_new
loadtime:4.8396379947662 / seconds
Query loaded from cache:select * from geodata_geocity where city='National Park' limit 1
loadtime:4.8397018909454 / seconds
Query Executed:select id FROM `nj` where city='National Park' && SIC_code='5541'DB:business_master_new
loadtime:4.8411128520966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navesink' limit 1
loadtime:4.8411779403687 / seconds
Query Executed:select id FROM `nj` where city='Navesink' && SIC_code='5541'DB:business_master_new
loadtime:4.8420147895813 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neptune' limit 1
loadtime:4.8420720100403 / seconds
Query Executed:select id FROM `nj` where city='Neptune' && SIC_code='5541'DB:business_master_new
loadtime:4.8673269748688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neptune City' limit 1
loadtime:4.8674259185791 / seconds
Query Executed:select id FROM `nj` where city='Neptune City' && SIC_code='5541'DB:business_master_new
loadtime:4.8680729866028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neshanic Station' limit 1
loadtime:4.8681259155273 / seconds
Query Executed:select id FROM `nj` where city='Neshanic Station' && SIC_code='5541'DB:business_master_new
loadtime:4.8695778846741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Netcong' limit 1
loadtime:4.8696949481964 / seconds
Query Executed:select id FROM `nj` where city='Netcong' && SIC_code='5541'DB:business_master_new
loadtime:4.8717279434204 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Brunswick' limit 1
loadtime:4.8718109130859 / seconds
Query Executed:select id FROM `nj` where city='New Brunswick' && SIC_code='5541'DB:business_master_new
loadtime:4.888463973999 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Egypt' limit 1
loadtime:4.8885729312897 / seconds
Query Executed:select id FROM `nj` where city='New Egypt' && SIC_code='5541'DB:business_master_new
loadtime:4.8903069496155 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Gretna' limit 1
loadtime:4.8904039859772 / seconds
Query Executed:select id FROM `nj` where city='New Gretna' && SIC_code='5541'DB:business_master_new
loadtime:4.891371011734 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Lisbon' limit 1
loadtime:4.8914468288422 / seconds
Query Executed:select id FROM `nj` where city='New Lisbon' && SIC_code='5541'DB:business_master_new
loadtime:4.8921439647675 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:4.8921937942505 / seconds
Query Executed:select id FROM `nj` where city='New Milford' && SIC_code='5541'DB:business_master_new
loadtime:4.8947148323059 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Monmouth' limit 1
loadtime:4.8947949409485 / seconds
Query Executed:select id FROM `nj` where city='New Monmouth' && SIC_code='5541'DB:business_master_new
loadtime:4.8951818943024 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Providence' limit 1
loadtime:4.8952689170837 / seconds
Query Executed:select id FROM `nj` where city='New Providence' && SIC_code='5541'DB:business_master_new
loadtime:4.8968689441681 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Vernon' limit 1
loadtime:4.8969697952271 / seconds
Query Executed:select id FROM `nj` where city='New Vernon' && SIC_code='5541'DB:business_master_new
loadtime:4.8982059955597 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newark' limit 1
loadtime:4.898295879364 / seconds
Query Executed:select id FROM `nj` where city='Newark' && SIC_code='5541'DB:business_master_new
loadtime:4.9278798103333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfield' limit 1
loadtime:4.9280848503113 / seconds
Query Executed:select id FROM `nj` where city='Newfield' && SIC_code='5541'DB:business_master_new
loadtime:4.9302618503571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newfoundland' limit 1
loadtime:4.9303619861603 / seconds
Query Executed:select id FROM `nj` where city='Newfoundland' && SIC_code='5541'DB:business_master_new
loadtime:4.9324188232422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:4.9325299263 / seconds
Query Executed:select id FROM `nj` where city='Newport' && SIC_code='5541'DB:business_master_new
loadtime:4.9333019256592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:4.9333639144897 / seconds
Query Executed:select id FROM `nj` where city='Newton' && SIC_code='5541'DB:business_master_new
loadtime:4.9377059936523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtonville' limit 1
loadtime:4.9377729892731 / seconds
Query Executed:select id FROM `nj` where city='Newtonville' && SIC_code='5541'DB:business_master_new
loadtime:4.938462972641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norma' limit 1
loadtime:4.938542842865 / seconds
Query Executed:select id FROM `nj` where city='Norma' && SIC_code='5541'DB:business_master_new
loadtime:4.9392600059509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Normandy Beach' limit 1
loadtime:4.9393467903137 / seconds
Query Executed:select id FROM `nj` where city='Normandy Beach' && SIC_code='5541'DB:business_master_new
loadtime:4.9403228759766 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Arlington' limit 1
loadtime:4.9404249191284 / seconds
Query Executed:select id FROM `nj` where city='North Arlington' && SIC_code='5541'DB:business_master_new
loadtime:4.9433798789978 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Bergen' limit 1
loadtime:4.9434258937836 / seconds
Query Executed:select id FROM `nj` where city='North Bergen' && SIC_code='5541'DB:business_master_new
loadtime:4.9520847797394 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branch' limit 1
loadtime:4.9521567821503 / seconds
Query Executed:select id FROM `nj` where city='North Branch' && SIC_code='5541'DB:business_master_new
loadtime:4.9528229236603 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Brunswick' limit 1
loadtime:4.9528658390045 / seconds
Query Executed:select id FROM `nj` where city='North Brunswick' && SIC_code='5541'DB:business_master_new
loadtime:4.9577457904816 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Cape May' limit 1
loadtime:4.9578108787537 / seconds
Query Executed:select id FROM `nj` where city='North Cape May' && SIC_code='5541'DB:business_master_new
loadtime:4.9582698345184 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haledon' limit 1
loadtime:4.9583468437195 / seconds
Query Executed:select id FROM `nj` where city='North Haledon' && SIC_code='5541'DB:business_master_new
loadtime:4.9588079452515 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Middletown' limit 1
loadtime:4.9588549137115 / seconds
Query Executed:select id FROM `nj` where city='North Middletown' && SIC_code='5541'DB:business_master_new
loadtime:4.9592487812042 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Plainfield' limit 1
loadtime:4.9593458175659 / seconds
Query Executed:select id FROM `nj` where city='North Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:4.9603178501129 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wildwood' limit 1
loadtime:4.9603788852692 / seconds
Query Executed:select id FROM `nj` where city='North Wildwood' && SIC_code='5541'DB:business_master_new
loadtime:4.9611577987671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:4.9612598419189 / seconds
Query Executed:select id FROM `nj` where city='Northfield' && SIC_code='5541'DB:business_master_new
loadtime:4.9636738300323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northvale' limit 1
loadtime:4.9637517929077 / seconds
Query Executed:select id FROM `nj` where city='Northvale' && SIC_code='5541'DB:business_master_new
loadtime:4.9672799110413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:4.9673969745636 / seconds
Query Executed:select id FROM `nj` where city='Norwood' && SIC_code='5541'DB:business_master_new
loadtime:4.9691619873047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nutley' limit 1
loadtime:4.9692358970642 / seconds
Query Executed:select id FROM `nj` where city='Nutley' && SIC_code='5541'DB:business_master_new
loadtime:4.9879679679871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:4.9881179332733 / seconds
Query Executed:select id FROM `nj` where city='Oak Ridge' && SIC_code='5541'DB:business_master_new
loadtime:4.9913439750671 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakhurst' limit 1
loadtime:4.9914078712463 / seconds
Query Executed:select id FROM `nj` where city='Oakhurst' && SIC_code='5541'DB:business_master_new
loadtime:4.994402885437 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakland' limit 1
loadtime:4.9944679737091 / seconds
Query Executed:select id FROM `nj` where city='Oakland' && SIC_code='5541'DB:business_master_new
loadtime:4.9966650009155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oaklyn' limit 1
loadtime:4.9967110157013 / seconds
Query Executed:select id FROM `nj` where city='Oaklyn' && SIC_code='5541'DB:business_master_new
loadtime:4.9988198280334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean' limit 1
loadtime:4.998881816864 / seconds
Query Executed:select id FROM `nj` where city='Ocean' && SIC_code='5541'DB:business_master_new
loadtime:5.0360839366913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean City' limit 1
loadtime:5.0361218452454 / seconds
Query Executed:select id FROM `nj` where city='Ocean City' && SIC_code='5541'DB:business_master_new
loadtime:5.0412709712982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Gate' limit 1
loadtime:5.0413308143616 / seconds
Query Executed:select id FROM `nj` where city='Ocean Gate' && SIC_code='5541'DB:business_master_new
loadtime:5.0423889160156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Grove' limit 1
loadtime:5.0424318313599 / seconds
Query Executed:select id FROM `nj` where city='Ocean Grove' && SIC_code='5541'DB:business_master_new
loadtime:5.0439729690552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean View' limit 1
loadtime:5.0440318584442 / seconds
Query Executed:select id FROM `nj` where city='Ocean View' && SIC_code='5541'DB:business_master_new
loadtime:5.0468158721924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanport' limit 1
loadtime:5.046875 / seconds
Query Executed:select id FROM `nj` where city='Oceanport' && SIC_code='5541'DB:business_master_new
loadtime:5.0484669208527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oceanville' limit 1
loadtime:5.0485179424286 / seconds
Query Executed:select id FROM `nj` where city='Oceanville' && SIC_code='5541'DB:business_master_new
loadtime:5.0492868423462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogdensburg' limit 1
loadtime:5.0493350028992 / seconds
Query Executed:select id FROM `nj` where city='Ogdensburg' && SIC_code='5541'DB:business_master_new
loadtime:5.050773859024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Bridge' limit 1
loadtime:5.0508317947388 / seconds
Query Executed:select id FROM `nj` where city='Old Bridge' && SIC_code='5541'DB:business_master_new
loadtime:5.0584118366241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Tappan' limit 1
loadtime:5.0584828853607 / seconds
Query Executed:select id FROM `nj` where city='Old Tappan' && SIC_code='5541'DB:business_master_new
loadtime:5.0591728687286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oldwick' limit 1
loadtime:5.0592110157013 / seconds
Query Executed:select id FROM `nj` where city='Oldwick' && SIC_code='5541'DB:business_master_new
loadtime:5.1314527988434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oradell' limit 1
loadtime:5.1315019130707 / seconds
Query Executed:select id FROM `nj` where city='Oradell' && SIC_code='5541'DB:business_master_new
loadtime:5.134733915329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:5.1347789764404 / seconds
Query Executed:select id FROM `nj` where city='Orange' && SIC_code='5541'DB:business_master_new
loadtime:5.139527797699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Osbornsville' limit 1
loadtime:5.1396059989929 / seconds
Query Executed:select id FROM `nj` where city='Osbornsville' && SIC_code='5541'DB:business_master_new
loadtime:5.1399989128113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:5.1400499343872 / seconds
Query Executed:select id FROM `nj` where city='Oxford' && SIC_code='5541'DB:business_master_new
loadtime:5.1895248889923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palisades Park' limit 1
loadtime:5.1895678043365 / seconds
Query Executed:select id FROM `nj` where city='Palisades Park' && SIC_code='5541'DB:business_master_new
loadtime:5.192706823349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmyra' limit 1
loadtime:5.1927709579468 / seconds
Query Executed:select id FROM `nj` where city='Palmyra' && SIC_code='5541'DB:business_master_new
loadtime:5.1950249671936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paramus' limit 1
loadtime:5.195084810257 / seconds
Query Executed:select id FROM `nj` where city='Paramus' && SIC_code='5541'DB:business_master_new
loadtime:5.2010908126831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Ridge' limit 1
loadtime:5.2012197971344 / seconds
Query Executed:select id FROM `nj` where city='Park Ridge' && SIC_code='5541'DB:business_master_new
loadtime:5.2038168907166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parlin' limit 1
loadtime:5.2038938999176 / seconds
Query Executed:select id FROM `nj` where city='Parlin' && SIC_code='5541'DB:business_master_new
loadtime:5.2062900066376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parsippany' limit 1
loadtime:5.2063479423523 / seconds
Query Executed:select id FROM `nj` where city='Parsippany' && SIC_code='5541'DB:business_master_new
loadtime:5.2116940021515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Passaic' limit 1
loadtime:5.2117478847504 / seconds
Query Executed:select id FROM `nj` where city='Passaic' && SIC_code='5541'DB:business_master_new
loadtime:5.2162699699402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paterson' limit 1
loadtime:5.2163329124451 / seconds
Query Executed:select id FROM `nj` where city='Paterson' && SIC_code='5541'DB:business_master_new
loadtime:5.2276649475098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paulsboro' limit 1
loadtime:5.2277388572693 / seconds
Query Executed:select id FROM `nj` where city='Paulsboro' && SIC_code='5541'DB:business_master_new
loadtime:5.2316098213196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peapack' limit 1
loadtime:5.2316648960114 / seconds
Query Executed:select id FROM `nj` where city='Peapack' && SIC_code='5541'DB:business_master_new
loadtime:5.2659809589386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pedricktown' limit 1
loadtime:5.2660279273987 / seconds
Query Executed:select id FROM `nj` where city='Pedricktown' && SIC_code='5541'DB:business_master_new
loadtime:5.2674849033356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pemberton' limit 1
loadtime:5.2675437927246 / seconds
Query Executed:select id FROM `nj` where city='Pemberton' && SIC_code='5541'DB:business_master_new
loadtime:5.2703008651733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington' limit 1
loadtime:5.2703619003296 / seconds
Query Executed:select id FROM `nj` where city='Pennington' && SIC_code='5541'DB:business_master_new
loadtime:5.2729179859161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penns Grove' limit 1
loadtime:5.2729699611664 / seconds
Query Executed:select id FROM `nj` where city='Penns Grove' && SIC_code='5541'DB:business_master_new
loadtime:5.2781059741974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsauken' limit 1
loadtime:5.278214931488 / seconds
Query Executed:select id FROM `nj` where city='Pennsauken' && SIC_code='5541'DB:business_master_new
loadtime:5.2868518829346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennsville' limit 1
loadtime:5.286906003952 / seconds
Query Executed:select id FROM `nj` where city='Pennsville' && SIC_code='5541'DB:business_master_new
loadtime:5.2890408039093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequannock' limit 1
loadtime:5.2891449928284 / seconds
Query Executed:select id FROM `nj` where city='Pequannock' && SIC_code='5541'DB:business_master_new
loadtime:5.2915558815002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perrineville' limit 1
loadtime:5.2916669845581 / seconds
Query Executed:select id FROM `nj` where city='Perrineville' && SIC_code='5541'DB:business_master_new
loadtime:5.2921509742737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perth Amboy' limit 1
loadtime:5.292210817337 / seconds
Query Executed:select id FROM `nj` where city='Perth Amboy' && SIC_code='5541'DB:business_master_new
loadtime:5.2993228435516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phillipsburg' limit 1
loadtime:5.2993738651276 / seconds
Query Executed:select id FROM `nj` where city='Phillipsburg' && SIC_code='5541'DB:business_master_new
loadtime:5.3059449195862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picatinny Arsenal' limit 1
loadtime:5.3060169219971 / seconds
Query Executed:select id FROM `nj` where city='Picatinny Arsenal' && SIC_code='5541'DB:business_master_new
loadtime:5.3065438270569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Picatinny Arsnl' limit 1
loadtime:5.3065819740295 / seconds
Query Executed:select id FROM `nj` where city='Picatinny Arsnl' && SIC_code='5541'DB:business_master_new
loadtime:5.3072719573975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilesgrove' limit 1
loadtime:5.3073129653931 / seconds
Query Executed:select id FROM `nj` where city='Pilesgrove' && SIC_code='5541'DB:business_master_new
loadtime:5.3077778816223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Beach' limit 1
loadtime:5.3078207969666 / seconds
Query Executed:select id FROM `nj` where city='Pine Beach' && SIC_code='5541'DB:business_master_new
loadtime:5.3616797924042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Brook' limit 1
loadtime:5.3617508411407 / seconds
Query Executed:select id FROM `nj` where city='Pine Brook' && SIC_code='5541'DB:business_master_new
loadtime:5.3643639087677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hill' limit 1
loadtime:5.364424943924 / seconds
Query Executed:select id FROM `nj` where city='Pine Hill' && SIC_code='5541'DB:business_master_new
loadtime:5.3649578094482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piscataway' limit 1
loadtime:5.3649938106537 / seconds
Query Executed:select id FROM `nj` where city='Piscataway' && SIC_code='5541'DB:business_master_new
loadtime:5.3682727813721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pitman' limit 1
loadtime:5.3683369159698 / seconds
Query Executed:select id FROM `nj` where city='Pitman' && SIC_code='5541'DB:business_master_new
loadtime:5.3704268932343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsgrove' limit 1
loadtime:5.3704748153687 / seconds
Query Executed:select id FROM `nj` where city='Pittsgrove' && SIC_code='5541'DB:business_master_new
loadtime:5.3709218502045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittstown' limit 1
loadtime:5.3709650039673 / seconds
Query Executed:select id FROM `nj` where city='Pittstown' && SIC_code='5541'DB:business_master_new
loadtime:5.3725678920746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:5.3726289272308 / seconds
Query Executed:select id FROM `nj` where city='Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:5.3805558681488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainsboro' limit 1
loadtime:5.380676984787 / seconds
Query Executed:select id FROM `nj` where city='Plainsboro' && SIC_code='5541'DB:business_master_new
loadtime:5.382465839386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasantville' limit 1
loadtime:5.382504940033 / seconds
Query Executed:select id FROM `nj` where city='Pleasantville' && SIC_code='5541'DB:business_master_new
loadtime:5.3857009410858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pluckemin' limit 1
loadtime:5.3857679367065 / seconds
Query Executed:select id FROM `nj` where city='Pluckemin' && SIC_code='5541'DB:business_master_new
loadtime:5.3870289325714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant' limit 1
loadtime:5.3870649337769 / seconds
Query Executed:select id FROM `nj` where city='Point Pleasant' && SIC_code='5541'DB:business_master_new
loadtime:5.3880498409271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Pleasant Beach' limit 1
loadtime:5.3880999088287 / seconds
Query Executed:select id FROM `nj` where city='Point Pleasant Beach' && SIC_code='5541'DB:business_master_new
loadtime:5.3938488960266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomona' limit 1
loadtime:5.3939049243927 / seconds
Query Executed:select id FROM `nj` where city='Pomona' && SIC_code='5541'DB:business_master_new
loadtime:5.4285078048706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompton Lakes' limit 1
loadtime:5.4285759925842 / seconds
Query Executed:select id FROM `nj` where city='Pompton Lakes' && SIC_code='5541'DB:business_master_new
loadtime:5.430713891983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pompton Plains' limit 1
loadtime:5.4307539463043 / seconds
Query Executed:select id FROM `nj` where city='Pompton Plains' && SIC_code='5541'DB:business_master_new
loadtime:5.434476852417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Elizabeth' limit 1
loadtime:5.4345369338989 / seconds
Query Executed:select id FROM `nj` where city='Port Elizabeth' && SIC_code='5541'DB:business_master_new
loadtime:5.435133934021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Monmouth' limit 1
loadtime:5.4351828098297 / seconds
Query Executed:select id FROM `nj` where city='Port Monmouth' && SIC_code='5541'DB:business_master_new
loadtime:5.4929130077362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Murray' limit 1
loadtime:5.4929559230804 / seconds
Query Executed:select id FROM `nj` where city='Port Murray' && SIC_code='5541'DB:business_master_new
loadtime:5.5426619052887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Norris' limit 1
loadtime:5.5427157878876 / seconds
Query Executed:select id FROM `nj` where city='Port Norris' && SIC_code='5541'DB:business_master_new
loadtime:5.5739228725433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Reading' limit 1
loadtime:5.5739669799805 / seconds
Query Executed:select id FROM `nj` where city='Port Reading' && SIC_code='5541'DB:business_master_new
loadtime:5.575318813324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Port Republic' limit 1
loadtime:5.5753679275513 / seconds
Query Executed:select id FROM `nj` where city='Port Republic' && SIC_code='5541'DB:business_master_new
loadtime:5.576507806778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pottersville' limit 1
loadtime:5.5765559673309 / seconds
Query Executed:select id FROM `nj` where city='Pottersville' && SIC_code='5541'DB:business_master_new
loadtime:5.5775849819183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:5.5776438713074 / seconds
Query Executed:select id FROM `nj` where city='Princeton' && SIC_code='5541'DB:business_master_new
loadtime:5.5839219093323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton Jct' limit 1
loadtime:5.5839998722076 / seconds
Query Executed:select id FROM `nj` where city='Princeton Jct' && SIC_code='5541'DB:business_master_new
loadtime:5.5845317840576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton Junction' limit 1
loadtime:5.5845768451691 / seconds
Query Executed:select id FROM `nj` where city='Princeton Junction' && SIC_code='5541'DB:business_master_new
loadtime:5.5878159999847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Park' limit 1
loadtime:5.5878717899323 / seconds
Query Executed:select id FROM `nj` where city='Prospect Park' && SIC_code='5541'DB:business_master_new
loadtime:5.588262796402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pt Pleasant Bch' limit 1
loadtime:5.5883128643036 / seconds
Query Executed:select id FROM `nj` where city='Pt Pleasant Bch' && SIC_code='5541'DB:business_master_new
loadtime:5.5888109207153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pt Pleasant Boro' limit 1
loadtime:5.5888388156891 / seconds
Query Executed:select id FROM `nj` where city='Pt Pleasant Boro' && SIC_code='5541'DB:business_master_new
loadtime:5.5892119407654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quakertown' limit 1
loadtime:5.5892589092255 / seconds
Query Executed:select id FROM `nj` where city='Quakertown' && SIC_code='5541'DB:business_master_new
loadtime:5.5899119377136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:5.5899479389191 / seconds
Query Executed:select id FROM `nj` where city='Quinton' && SIC_code='5541'DB:business_master_new
loadtime:5.5906457901001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rahway' limit 1
loadtime:5.5906949043274 / seconds
Query Executed:select id FROM `nj` where city='Rahway' && SIC_code='5541'DB:business_master_new
loadtime:5.6205008029938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramsey' limit 1
loadtime:5.6205530166626 / seconds
Query Executed:select id FROM `nj` where city='Ramsey' && SIC_code='5541'DB:business_master_new
loadtime:5.6237487792969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rancocas' limit 1
loadtime:5.623804807663 / seconds
Query Executed:select id FROM `nj` where city='Rancocas' && SIC_code='5541'DB:business_master_new
loadtime:5.625020980835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:5.6250739097595 / seconds
Query Executed:select id FROM `nj` where city='Randolph' && SIC_code='5541'DB:business_master_new
loadtime:5.6288089752197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raritan' limit 1
loadtime:5.628870010376 / seconds
Query Executed:select id FROM `nj` where city='Raritan' && SIC_code='5541'DB:business_master_new
loadtime:5.6327269077301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Readington' limit 1
loadtime:5.6327719688416 / seconds
Query Executed:select id FROM `nj` where city='Readington' && SIC_code='5541'DB:business_master_new
loadtime:5.6334187984467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Bank' limit 1
loadtime:5.6334819793701 / seconds
Query Executed:select id FROM `nj` where city='Red Bank' && SIC_code='5541'DB:business_master_new
loadtime:5.638689994812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richland' limit 1
loadtime:5.6387548446655 / seconds
Query Executed:select id FROM `nj` where city='Richland' && SIC_code='5541'DB:business_master_new
loadtime:5.6395628452301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richwood' limit 1
loadtime:5.639613866806 / seconds
Query Executed:select id FROM `nj` where city='Richwood' && SIC_code='5541'DB:business_master_new
loadtime:5.6404738426208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:5.6405239105225 / seconds
Query Executed:select id FROM `nj` where city='Ridgefield' && SIC_code='5541'DB:business_master_new
loadtime:5.6477098464966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield Park' limit 1
loadtime:5.6477649211884 / seconds
Query Executed:select id FROM `nj` where city='Ridgefield Park' && SIC_code='5541'DB:business_master_new
loadtime:5.6502549648285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgewood' limit 1
loadtime:5.6503188610077 / seconds
Query Executed:select id FROM `nj` where city='Ridgewood' && SIC_code='5541'DB:business_master_new
loadtime:5.6532628536224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringoes' limit 1
loadtime:5.6533179283142 / seconds
Query Executed:select id FROM `nj` where city='Ringoes' && SIC_code='5541'DB:business_master_new
loadtime:5.6552708148956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ringwood' limit 1
loadtime:5.6553349494934 / seconds
Query Executed:select id FROM `nj` where city='Ringwood' && SIC_code='5541'DB:business_master_new
loadtime:5.6585857868195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rio Grande' limit 1
loadtime:5.6586608886719 / seconds
Query Executed:select id FROM `nj` where city='Rio Grande' && SIC_code='5541'DB:business_master_new
loadtime:5.6606647968292 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Edge' limit 1
loadtime:5.6607048511505 / seconds
Query Executed:select id FROM `nj` where city='River Edge' && SIC_code='5541'DB:business_master_new
loadtime:5.6624917984009 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Vale' limit 1
loadtime:5.6625390052795 / seconds
Query Executed:select id FROM `nj` where city='River Vale' && SIC_code='5541'DB:business_master_new
loadtime:5.6630029678345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverdale' limit 1
loadtime:5.6630427837372 / seconds
Query Executed:select id FROM `nj` where city='Riverdale' && SIC_code='5541'DB:business_master_new
loadtime:5.6651659011841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:5.6652178764343 / seconds
Query Executed:select id FROM `nj` where city='Riverside' && SIC_code='5541'DB:business_master_new
loadtime:5.6680459976196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:5.6680889129639 / seconds
Query Executed:select id FROM `nj` where city='Riverton' && SIC_code='5541'DB:business_master_new
loadtime:5.67152094841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:5.6715807914734 / seconds
Query Executed:select id FROM `nj` where city='Robbinsville' && SIC_code='5541'DB:business_master_new
loadtime:5.6723799705505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochelle Park' limit 1
loadtime:5.672415971756 / seconds
Query Executed:select id FROM `nj` where city='Rochelle Park' && SIC_code='5541'DB:business_master_new
loadtime:5.6747329235077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockaway' limit 1
loadtime:5.6747889518738 / seconds
Query Executed:select id FROM `nj` where city='Rockaway' && SIC_code='5541'DB:business_master_new
loadtime:5.6780829429626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockleigh' limit 1
loadtime:5.6781628131866 / seconds
Query Executed:select id FROM `nj` where city='Rockleigh' && SIC_code='5541'DB:business_master_new
loadtime:5.6785078048706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:5.6785678863525 / seconds
Query Executed:select id FROM `nj` where city='Rocky Hill' && SIC_code='5541'DB:business_master_new
loadtime:5.7058730125427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roebling' limit 1
loadtime:5.7059497833252 / seconds
Query Executed:select id FROM `nj` where city='Roebling' && SIC_code='5541'DB:business_master_new
loadtime:5.7073888778687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:5.7074589729309 / seconds
Query Executed:select id FROM `nj` where city='Roosevelt' && SIC_code='5541'DB:business_master_new
loadtime:5.7083909511566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseland' limit 1
loadtime:5.7084519863129 / seconds
Query Executed:select id FROM `nj` where city='Roseland' && SIC_code='5541'DB:business_master_new
loadtime:5.7106177806854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roselle' limit 1
loadtime:5.7106618881226 / seconds
Query Executed:select id FROM `nj` where city='Roselle' && SIC_code='5541'DB:business_master_new
loadtime:5.7131788730621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roselle Park' limit 1
loadtime:5.7132308483124 / seconds
Query Executed:select id FROM `nj` where city='Roselle Park' && SIC_code='5541'DB:business_master_new
loadtime:5.7162568569183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosemont' limit 1
loadtime:5.7163388729095 / seconds
Query Executed:select id FROM `nj` where city='Rosemont' && SIC_code='5541'DB:business_master_new
loadtime:5.7171440124512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosenhayn' limit 1
loadtime:5.7171847820282 / seconds
Query Executed:select id FROM `nj` where city='Rosenhayn' && SIC_code='5541'DB:business_master_new
loadtime:5.7182018756866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rumson' limit 1
loadtime:5.7182478904724 / seconds
Query Executed:select id FROM `nj` where city='Rumson' && SIC_code='5541'DB:business_master_new
loadtime:5.7199649810791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Runnemede' limit 1
loadtime:5.7200338840485 / seconds
Query Executed:select id FROM `nj` where city='Runnemede' && SIC_code='5541'DB:business_master_new
loadtime:5.7231719493866 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford' limit 1
loadtime:5.7232179641724 / seconds
Query Executed:select id FROM `nj` where city='Rutherford' && SIC_code='5541'DB:business_master_new
loadtime:5.7398738861084 / seconds
Query loaded from cache:select * from geodata_geocity where city='S Bound Brook' limit 1
loadtime:5.7399368286133 / seconds
Query Executed:select id FROM `nj` where city='S Bound Brook' && SIC_code='5541'DB:business_master_new
loadtime:5.7403519153595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddle Brook' limit 1
loadtime:5.7403979301453 / seconds
Query Executed:select id FROM `nj` where city='Saddle Brook' && SIC_code='5541'DB:business_master_new
loadtime:5.7442798614502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saddle River' limit 1
loadtime:5.744325876236 / seconds
Query Executed:select id FROM `nj` where city='Saddle River' && SIC_code='5541'DB:business_master_new
loadtime:5.7477579116821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:5.7478239536285 / seconds
Query Executed:select id FROM `nj` where city='Salem' && SIC_code='5541'DB:business_master_new
loadtime:5.7495529651642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandyston' limit 1
loadtime:5.7496099472046 / seconds
Query Executed:select id FROM `nj` where city='Sandyston' && SIC_code='5541'DB:business_master_new
loadtime:5.7499468326569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayreville' limit 1
loadtime:5.7499868869781 / seconds
Query Executed:select id FROM `nj` where city='Sayreville' && SIC_code='5541'DB:business_master_new
loadtime:5.7541558742523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schooleys Mountain' limit 1
loadtime:5.7542059421539 / seconds
Query Executed:select id FROM `nj` where city='Schooleys Mountain' && SIC_code='5541'DB:business_master_new
loadtime:5.7547769546509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schooleys Mtn' limit 1
loadtime:5.7548198699951 / seconds
Query Executed:select id FROM `nj` where city='Schooleys Mtn' && SIC_code='5541'DB:business_master_new
loadtime:5.7551758289337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotch Plains' limit 1
loadtime:5.7552049160004 / seconds
Query Executed:select id FROM `nj` where city='Scotch Plains' && SIC_code='5541'DB:business_master_new
loadtime:5.7587049007416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Bright' limit 1
loadtime:5.7587587833405 / seconds
Query Executed:select id FROM `nj` where city='Sea Bright' && SIC_code='5541'DB:business_master_new
loadtime:5.7591409683228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Girt' limit 1
loadtime:5.7591760158539 / seconds
Query Executed:select id FROM `nj` where city='Sea Girt' && SIC_code='5541'DB:business_master_new
loadtime:5.7612760066986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sea Isle City' limit 1
loadtime:5.7613317966461 / seconds
Query Executed:select id FROM `nj` where city='Sea Isle City' && SIC_code='5541'DB:business_master_new
loadtime:5.7629199028015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:5.7629687786102 / seconds
Query Executed:select id FROM `nj` where city='Seabrook' && SIC_code='5541'DB:business_master_new
loadtime:5.7633759975433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside Heights' limit 1
loadtime:5.7634229660034 / seconds
Query Executed:select id FROM `nj` where city='Seaside Heights' && SIC_code='5541'DB:business_master_new
loadtime:5.7657308578491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaside Park' limit 1
loadtime:5.7657740116119 / seconds
Query Executed:select id FROM `nj` where city='Seaside Park' && SIC_code='5541'DB:business_master_new
loadtime:5.7679078578949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Secaucus' limit 1
loadtime:5.767963886261 / seconds
Query Executed:select id FROM `nj` where city='Secaucus' && SIC_code='5541'DB:business_master_new
loadtime:5.7719728946686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sergeantsville' limit 1
loadtime:5.7720379829407 / seconds
Query Executed:select id FROM `nj` where city='Sergeantsville' && SIC_code='5541'DB:business_master_new
loadtime:5.77290391922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sewaren' limit 1
loadtime:5.7729477882385 / seconds
Query Executed:select id FROM `nj` where city='Sewaren' && SIC_code='5541'DB:business_master_new
loadtime:5.7739799022675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sewell' limit 1
loadtime:5.7740278244019 / seconds
Query Executed:select id FROM `nj` where city='Sewell' && SIC_code='5541'DB:business_master_new
loadtime:5.7768988609314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shamong' limit 1
loadtime:5.7769589424133 / seconds
Query Executed:select id FROM `nj` where city='Shamong' && SIC_code='5541'DB:business_master_new
loadtime:5.7774269580841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:5.7774708271027 / seconds
Query Executed:select id FROM `nj` where city='Shiloh' && SIC_code='5541'DB:business_master_new
loadtime:5.7783718109131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ship Bottom' limit 1
loadtime:5.7784309387207 / seconds
Query Executed:select id FROM `nj` where city='Ship Bottom' && SIC_code='5541'DB:business_master_new
loadtime:5.7790608406067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Short Hills' limit 1
loadtime:5.7791140079498 / seconds
Query Executed:select id FROM `nj` where city='Short Hills' && SIC_code='5541'DB:business_master_new
loadtime:5.7812478542328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shrewsbury' limit 1
loadtime:5.7812929153442 / seconds
Query Executed:select id FROM `nj` where city='Shrewsbury' && SIC_code='5541'DB:business_master_new
loadtime:5.7834589481354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sicklerville' limit 1
loadtime:5.7835137844086 / seconds
Query Executed:select id FROM `nj` where city='Sicklerville' && SIC_code='5541'DB:business_master_new
loadtime:5.7859199047089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skillman' limit 1
loadtime:5.7859778404236 / seconds
Query Executed:select id FROM `nj` where city='Skillman' && SIC_code='5541'DB:business_master_new
loadtime:5.7876069545746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithville' limit 1
loadtime:5.7876439094543 / seconds
Query Executed:select id FROM `nj` where city='Smithville' && SIC_code='5541'DB:business_master_new
loadtime:5.7880928516388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerdale' limit 1
loadtime:5.7881288528442 / seconds
Query Executed:select id FROM `nj` where city='Somerdale' && SIC_code='5541'DB:business_master_new
loadtime:5.7897288799286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers Point' limit 1
loadtime:5.7897617816925 / seconds
Query Executed:select id FROM `nj` where city='Somers Point' && SIC_code='5541'DB:business_master_new
loadtime:5.7929818630219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerset' limit 1
loadtime:5.7930278778076 / seconds
Query Executed:select id FROM `nj` where city='Somerset' && SIC_code='5541'DB:business_master_new
loadtime:5.7981479167938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:5.7982029914856 / seconds
Query Executed:select id FROM `nj` where city='Somerville' && SIC_code='5541'DB:business_master_new
loadtime:5.8039197921753 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Amboy' limit 1
loadtime:5.8039968013763 / seconds
Query Executed:select id FROM `nj` where city='South Amboy' && SIC_code='5541'DB:business_master_new
loadtime:5.8263819217682 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Bound Brook' limit 1
loadtime:5.826456785202 / seconds
Query Executed:select id FROM `nj` where city='South Bound Brook' && SIC_code='5541'DB:business_master_new
loadtime:5.8624908924103 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Dennis' limit 1
loadtime:5.8625469207764 / seconds
Query Executed:select id FROM `nj` where city='South Dennis' && SIC_code='5541'DB:business_master_new
loadtime:5.8631978034973 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Hackensack' limit 1
loadtime:5.8632488250732 / seconds
Query Executed:select id FROM `nj` where city='South Hackensack' && SIC_code='5541'DB:business_master_new
loadtime:5.8650028705597 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Orange' limit 1
loadtime:5.8650608062744 / seconds
Query Executed:select id FROM `nj` where city='South Orange' && SIC_code='5541'DB:business_master_new
loadtime:5.8677339553833 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Plainfield' limit 1
loadtime:5.8677949905396 / seconds
Query Executed:select id FROM `nj` where city='South Plainfield' && SIC_code='5541'DB:business_master_new
loadtime:5.8710219860077 / seconds
Query loaded from cache:select * from geodata_geocity where city='South River' limit 1
loadtime:5.8710858821869 / seconds
Query Executed:select id FROM `nj` where city='South River' && SIC_code='5541'DB:business_master_new
loadtime:5.8729009628296 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Seaville' limit 1
loadtime:5.8729457855225 / seconds
Query Executed:select id FROM `nj` where city='South Seaville' && SIC_code='5541'DB:business_master_new
loadtime:5.8736817836761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southampton' limit 1
loadtime:5.8737418651581 / seconds
Query Executed:select id FROM `nj` where city='Southampton' && SIC_code='5541'DB:business_master_new
loadtime:5.8743000030518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:5.8743369579315 / seconds
Query Executed:select id FROM `nj` where city='Sparta' && SIC_code='5541'DB:business_master_new
loadtime:5.8771319389343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spotswood' limit 1
loadtime:5.8771908283234 / seconds
Query Executed:select id FROM `nj` where city='Spotswood' && SIC_code='5541'DB:business_master_new
loadtime:5.8788228034973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:5.8788828849792 / seconds
Query Executed:select id FROM `nj` where city='Spring Lake' && SIC_code='5541'DB:business_master_new
loadtime:5.8816859722137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:5.88174700737 / seconds
Query Executed:select id FROM `nj` where city='Springfield' && SIC_code='5541'DB:business_master_new
loadtime:5.8847019672394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanhope' limit 1
loadtime:5.8847649097443 / seconds
Query Executed:select id FROM `nj` where city='Stanhope' && SIC_code='5541'DB:business_master_new
loadtime:5.8868927955627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:5.886950969696 / seconds
Query Executed:select id FROM `nj` where city='Stanton' && SIC_code='5541'DB:business_master_new
loadtime:5.8876237869263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stewartsville' limit 1
loadtime:5.8876729011536 / seconds
Query Executed:select id FROM `nj` where city='Stewartsville' && SIC_code='5541'DB:business_master_new
loadtime:5.8891789913177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stillwater' limit 1
loadtime:5.8892288208008 / seconds
Query Executed:select id FROM `nj` where city='Stillwater' && SIC_code='5541'DB:business_master_new
loadtime:5.8900718688965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stirling' limit 1
loadtime:5.8901228904724 / seconds
Query Executed:select id FROM `nj` where city='Stirling' && SIC_code='5541'DB:business_master_new
loadtime:5.893049955368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockholm' limit 1
loadtime:5.8931097984314 / seconds
Query Executed:select id FROM `nj` where city='Stockholm' && SIC_code='5541'DB:business_master_new
loadtime:5.9191060066223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:5.9191629886627 / seconds
Query Executed:select id FROM `nj` where city='Stockton' && SIC_code='5541'DB:business_master_new
loadtime:5.9207649230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stone Harbor' limit 1
loadtime:5.9208219051361 / seconds
Query Executed:select id FROM `nj` where city='Stone Harbor' && SIC_code='5541'DB:business_master_new
loadtime:5.9223937988281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:5.9224429130554 / seconds
Query Executed:select id FROM `nj` where city='Stratford' && SIC_code='5541'DB:business_master_new
loadtime:5.9240958690643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strathmere' limit 1
loadtime:5.9241569042206 / seconds
Query Executed:select id FROM `nj` where city='Strathmere' && SIC_code='5541'DB:business_master_new
loadtime:5.9246888160706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Succasunna' limit 1
loadtime:5.9247310161591 / seconds
Query Executed:select id FROM `nj` where city='Succasunna' && SIC_code='5541'DB:business_master_new
loadtime:5.9276378154755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:5.9276959896088 / seconds
Query Executed:select id FROM `nj` where city='Summit' && SIC_code='5541'DB:business_master_new
loadtime:5.9306337833405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:5.9306998252869 / seconds
Query Executed:select id FROM `nj` where city='Surf City' && SIC_code='5541'DB:business_master_new
loadtime:5.9312169551849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sussex' limit 1
loadtime:5.931263923645 / seconds
Query Executed:select id FROM `nj` where city='Sussex' && SIC_code='5541'DB:business_master_new
loadtime:5.934229850769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swartswood' limit 1
loadtime:5.9342918395996 / seconds
Query Executed:select id FROM `nj` where city='Swartswood' && SIC_code='5541'DB:business_master_new
loadtime:5.934830904007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swedesboro' limit 1
loadtime:5.9348738193512 / seconds
Query Executed:select id FROM `nj` where city='Swedesboro' && SIC_code='5541'DB:business_master_new
loadtime:5.9378938674927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabernacle' limit 1
loadtime:5.9379568099976 / seconds
Query Executed:select id FROM `nj` where city='Tabernacle' && SIC_code='5541'DB:business_master_new
loadtime:5.9384498596191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teaneck' limit 1
loadtime:5.9384977817535 / seconds
Query Executed:select id FROM `nj` where city='Teaneck' && SIC_code='5541'DB:business_master_new
loadtime:5.9452159404755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tenafly' limit 1
loadtime:5.9452848434448 / seconds
Query Executed:select id FROM `nj` where city='Tenafly' && SIC_code='5541'DB:business_master_new
loadtime:5.947331905365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tennent' limit 1
loadtime:5.9473819732666 / seconds
Query Executed:select id FROM `nj` where city='Tennent' && SIC_code='5541'DB:business_master_new
loadtime:5.9482460021973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teterboro' limit 1
loadtime:5.948294878006 / seconds
Query Executed:select id FROM `nj` where city='Teterboro' && SIC_code='5541'DB:business_master_new
loadtime:5.9498438835144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorofare' limit 1
loadtime:5.949896812439 / seconds
Query Executed:select id FROM `nj` where city='Thorofare' && SIC_code='5541'DB:business_master_new
loadtime:5.9517979621887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Three Bridges' limit 1
loadtime:5.9518427848816 / seconds
Query Executed:select id FROM `nj` where city='Three Bridges' && SIC_code='5541'DB:business_master_new
loadtime:5.9530739784241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tinton Falls' limit 1
loadtime:5.9531278610229 / seconds
Query Executed:select id FROM `nj` where city='Tinton Falls' && SIC_code='5541'DB:business_master_new
loadtime:5.953882932663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titusville' limit 1
loadtime:5.9539330005646 / seconds
Query Executed:select id FROM `nj` where city='Titusville' && SIC_code='5541'DB:business_master_new
loadtime:6.0683898925781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toms River' limit 1
loadtime:6.0684390068054 / seconds
Query Executed:select id FROM `nj` where city='Toms River' && SIC_code='5541'DB:business_master_new
loadtime:6.0869867801666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Totowa' limit 1
loadtime:6.087070941925 / seconds
Query Executed:select id FROM `nj` where city='Totowa' && SIC_code='5541'DB:business_master_new
loadtime:6.0917458534241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Towaco' limit 1
loadtime:6.0918109416962 / seconds
Query Executed:select id FROM `nj` where city='Towaco' && SIC_code='5541'DB:business_master_new
loadtime:6.0947148799896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Township Of Washington' limit 1
loadtime:6.0947740077972 / seconds
Query Executed:select id FROM `nj` where city='Township Of Washington' && SIC_code='5541'DB:business_master_new
loadtime:6.0983929634094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tranquility' limit 1
loadtime:6.0984499454498 / seconds
Query Executed:select id FROM `nj` where city='Tranquility' && SIC_code='5541'DB:business_master_new
loadtime:6.0997099876404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:6.0997638702393 / seconds
Query Executed:select id FROM `nj` where city='Trenton' && SIC_code='5541'DB:business_master_new
loadtime:6.1689119338989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckahoe' limit 1
loadtime:6.1690969467163 / seconds
Query Executed:select id FROM `nj` where city='Tuckahoe' && SIC_code='5541'DB:business_master_new
loadtime:6.1722469329834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckerton' limit 1
loadtime:6.1723039150238 / seconds
Query Executed:select id FROM `nj` where city='Tuckerton' && SIC_code='5541'DB:business_master_new
loadtime:6.1777539253235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersville' limit 1
loadtime:6.1779170036316 / seconds
Query Executed:select id FROM `nj` where city='Turnersville' && SIC_code='5541'DB:business_master_new
loadtime:6.179468870163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:6.1796598434448 / seconds
Query Executed:select id FROM `nj` where city='Union' && SIC_code='5541'DB:business_master_new
loadtime:6.1897039413452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Beach' limit 1
loadtime:6.1899290084839 / seconds
Query Executed:select id FROM `nj` where city='Union Beach' && SIC_code='5541'DB:business_master_new
loadtime:6.1905329227448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union City' limit 1
loadtime:6.1907198429108 / seconds
Query Executed:select id FROM `nj` where city='Union City' && SIC_code='5541'DB:business_master_new
loadtime:6.1977379322052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Upper Saddle Rvr' limit 1
loadtime:6.1979010105133 / seconds
Query Executed:select id FROM `nj` where city='Upper Saddle Rvr' && SIC_code='5541'DB:business_master_new
loadtime:6.198502779007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vauxhall' limit 1
loadtime:6.1986429691315 / seconds
Query Executed:select id FROM `nj` where city='Vauxhall' && SIC_code='5541'DB:business_master_new
loadtime:6.2308769226074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ventnor City' limit 1
loadtime:6.2309558391571 / seconds
Query Executed:select id FROM `nj` where city='Ventnor City' && SIC_code='5541'DB:business_master_new
loadtime:6.2357609272003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:6.235790014267 / seconds
Query Executed:select id FROM `nj` where city='Vernon' && SIC_code='5541'DB:business_master_new
loadtime:6.2403359413147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verona' limit 1
loadtime:6.2403810024261 / seconds
Query Executed:select id FROM `nj` where city='Verona' && SIC_code='5541'DB:business_master_new
loadtime:6.2469358444214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vienna' limit 1
loadtime:6.2469918727875 / seconds
Query Executed:select id FROM `nj` where city='Vienna' && SIC_code='5541'DB:business_master_new
loadtime:6.248389005661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Villas' limit 1
loadtime:6.2484319210052 / seconds
Query Executed:select id FROM `nj` where city='Villas' && SIC_code='5541'DB:business_master_new
loadtime:6.2526187896729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincentown' limit 1
loadtime:6.2526648044586 / seconds
Query Executed:select id FROM `nj` where city='Vincentown' && SIC_code='5541'DB:business_master_new
loadtime:6.2586708068848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vineland' limit 1
loadtime:6.2587068080902 / seconds
Query Executed:select id FROM `nj` where city='Vineland' && SIC_code='5541'DB:business_master_new
loadtime:6.269495010376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voorhees' limit 1
loadtime:6.2695608139038 / seconds
Query Executed:select id FROM `nj` where city='Voorhees' && SIC_code='5541'DB:business_master_new
loadtime:6.2774908542633 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Collingswd Hts' limit 1
loadtime:6.2775268554688 / seconds
Query Executed:select id FROM `nj` where city='W Collingswd Hts' && SIC_code='5541'DB:business_master_new
loadtime:6.2783739566803 / seconds
Query loaded from cache:select * from geodata_geocity where city='W Collingswood' limit 1
loadtime:6.2784090042114 / seconds
Query Executed:select id FROM `nj` where city='W Collingswood' && SIC_code='5541'DB:business_master_new
loadtime:6.2792959213257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waldwick' limit 1
loadtime:6.2793288230896 / seconds
Query Executed:select id FROM `nj` where city='Waldwick' && SIC_code='5541'DB:business_master_new
loadtime:6.2837100028992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall' limit 1
loadtime:6.2837429046631 / seconds
Query Executed:select id FROM `nj` where city='Wall' && SIC_code='5541'DB:business_master_new
loadtime:6.3170399665833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wall Township' limit 1
loadtime:6.3170847892761 / seconds
Query Executed:select id FROM `nj` where city='Wall Township' && SIC_code='5541'DB:business_master_new
loadtime:6.3190050125122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallington' limit 1
loadtime:6.3190448284149 / seconds
Query Executed:select id FROM `nj` where city='Wallington' && SIC_code='5541'DB:business_master_new
loadtime:6.3254508972168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallpack Center' limit 1
loadtime:6.325493812561 / seconds
Query Executed:select id FROM `nj` where city='Wallpack Center' && SIC_code='5541'DB:business_master_new
loadtime:6.3264579772949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanaque' limit 1
loadtime:6.3264939785004 / seconds
Query Executed:select id FROM `nj` where city='Wanaque' && SIC_code='5541'DB:business_master_new
loadtime:6.3305048942566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waretown' limit 1
loadtime:6.3305289745331 / seconds
Query Executed:select id FROM `nj` where city='Waretown' && SIC_code='5541'DB:business_master_new
loadtime:6.3351747989655 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:6.3352158069611 / seconds
Query Executed:select id FROM `nj` where city='Warren' && SIC_code='5541'DB:business_master_new
loadtime:6.3419408798218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:6.341983795166 / seconds
Query Executed:select id FROM `nj` where city='Washington' && SIC_code='5541'DB:business_master_new
loadtime:6.347559928894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Twp' limit 1
loadtime:6.3476169109344 / seconds
Query Executed:select id FROM `nj` where city='Washington Twp' && SIC_code='5541'DB:business_master_new
loadtime:6.3693947792053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watchung' limit 1
loadtime:6.3694398403168 / seconds
Query Executed:select id FROM `nj` where city='Watchung' && SIC_code='5541'DB:business_master_new
loadtime:6.3749198913574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford Works' limit 1
loadtime:6.3749718666077 / seconds
Query Executed:select id FROM `nj` where city='Waterford Works' && SIC_code='5541'DB:business_master_new
loadtime:6.3966698646545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wayne' limit 1
loadtime:6.3967218399048 / seconds
Query Executed:select id FROM `nj` where city='Wayne' && SIC_code='5541'DB:business_master_new
loadtime:6.4081218242645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weehawken' limit 1
loadtime:6.4081909656525 / seconds
Query Executed:select id FROM `nj` where city='Weehawken' && SIC_code='5541'DB:business_master_new
loadtime:6.4135808944702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wenonah' limit 1
loadtime:6.4136388301849 / seconds
Query Executed:select id FROM `nj` where city='Wenonah' && SIC_code='5541'DB:business_master_new
loadtime:6.4177198410034 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Berlin' limit 1
loadtime:6.4177780151367 / seconds
Query Executed:select id FROM `nj` where city='West Berlin' && SIC_code='5541'DB:business_master_new
loadtime:6.4226179122925 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Caldwell' limit 1
loadtime:6.4226779937744 / seconds
Query Executed:select id FROM `nj` where city='West Caldwell' && SIC_code='5541'DB:business_master_new
loadtime:6.4242839813232 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cape May' limit 1
loadtime:6.4243338108063 / seconds
Query Executed:select id FROM `nj` where city='West Cape May' && SIC_code='5541'DB:business_master_new
loadtime:6.425244808197 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Creek' limit 1
loadtime:6.4252939224243 / seconds
Query Executed:select id FROM `nj` where city='West Creek' && SIC_code='5541'DB:business_master_new
loadtime:6.4303278923035 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Long Branch' limit 1
loadtime:6.4303867816925 / seconds
Query Executed:select id FROM `nj` where city='West Long Branch' && SIC_code='5541'DB:business_master_new
loadtime:6.4367108345032 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Milford' limit 1
loadtime:6.4367787837982 / seconds
Query Executed:select id FROM `nj` where city='West Milford' && SIC_code='5541'DB:business_master_new
loadtime:6.4429287910461 / seconds
Query loaded from cache:select * from geodata_geocity where city='West New York' limit 1
loadtime:6.4429748058319 / seconds
Query Executed:select id FROM `nj` where city='West New York' && SIC_code='5541'DB:business_master_new
loadtime:6.4502220153809 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Orange' limit 1
loadtime:6.4502809047699 / seconds
Query Executed:select id FROM `nj` where city='West Orange' && SIC_code='5541'DB:business_master_new
loadtime:6.4593019485474 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Paterson' limit 1
loadtime:6.4593708515167 / seconds
Query Executed:select id FROM `nj` where city='West Paterson' && SIC_code='5541'DB:business_master_new
loadtime:6.4613599777222 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Trenton' limit 1
loadtime:6.461413860321 / seconds
Query Executed:select id FROM `nj` where city='West Trenton' && SIC_code='5541'DB:business_master_new
loadtime:6.4628968238831 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Wildwood' limit 1
loadtime:6.462947845459 / seconds
Query Executed:select id FROM `nj` where city='West Wildwood' && SIC_code='5541'DB:business_master_new
loadtime:6.4637639522552 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Windsor' limit 1
loadtime:6.463800907135 / seconds
Query Executed:select id FROM `nj` where city='West Windsor' && SIC_code='5541'DB:business_master_new
loadtime:6.4650278091431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westampton' limit 1
loadtime:6.465075969696 / seconds
Query Executed:select id FROM `nj` where city='Westampton' && SIC_code='5541'DB:business_master_new
loadtime:6.4662048816681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:6.4662518501282 / seconds
Query Executed:select id FROM `nj` where city='Westfield' && SIC_code='5541'DB:business_master_new
loadtime:6.4737567901611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmont' limit 1
loadtime:6.4739298820496 / seconds
Query Executed:select id FROM `nj` where city='Westmont' && SIC_code='5541'DB:business_master_new
loadtime:6.4746909141541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westville' limit 1
loadtime:6.4748048782349 / seconds
Query Executed:select id FROM `nj` where city='Westville' && SIC_code='5541'DB:business_master_new
loadtime:6.4766829013824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westwood' limit 1
loadtime:6.4768369197845 / seconds
Query Executed:select id FROM `nj` where city='Westwood' && SIC_code='5541'DB:business_master_new
loadtime:6.4812388420105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wharton' limit 1
loadtime:6.4813148975372 / seconds
Query Executed:select id FROM `nj` where city='Wharton' && SIC_code='5541'DB:business_master_new
loadtime:6.4865489006042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whippany' limit 1
loadtime:6.4866118431091 / seconds
Query Executed:select id FROM `nj` where city='Whippany' && SIC_code='5541'DB:business_master_new
loadtime:6.492164850235 / seconds
Query loaded from cache:select * from geodata_geocity where city='White House Station' limit 1
loadtime:6.4922268390656 / seconds
Query Executed:select id FROM `nj` where city='White House Station' && SIC_code='5541'DB:business_master_new
loadtime:6.493115901947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse' limit 1
loadtime:6.4931509494781 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse' && SIC_code='5541'DB:business_master_new
loadtime:6.4979569911957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse Sta' limit 1
loadtime:6.4980127811432 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse Sta' && SIC_code='5541'DB:business_master_new
loadtime:6.4991438388824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitehouse Station' limit 1
loadtime:6.4991858005524 / seconds
Query Executed:select id FROM `nj` where city='Whitehouse Station' && SIC_code='5541'DB:business_master_new
loadtime:6.5045077800751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitesboro' limit 1
loadtime:6.5045669078827 / seconds
Query Executed:select id FROM `nj` where city='Whitesboro' && SIC_code='5541'DB:business_master_new
loadtime:6.5055019855499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiting' limit 1
loadtime:6.5055508613586 / seconds
Query Executed:select id FROM `nj` where city='Whiting' && SIC_code='5541'DB:business_master_new
loadtime:6.507376909256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wickatunk' limit 1
loadtime:6.5074238777161 / seconds
Query Executed:select id FROM `nj` where city='Wickatunk' && SIC_code='5541'DB:business_master_new
loadtime:6.5091857910156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wildwood' limit 1
loadtime:6.5092358589172 / seconds
Query Executed:select id FROM `nj` where city='Wildwood' && SIC_code='5541'DB:business_master_new
loadtime:6.5162618160248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wildwood Crest' limit 1
loadtime:6.5163259506226 / seconds
Query Executed:select id FROM `nj` where city='Wildwood Crest' && SIC_code='5541'DB:business_master_new
loadtime:6.5178368091583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamstown' limit 1
loadtime:6.5178887844086 / seconds
Query Executed:select id FROM `nj` where city='Williamstown' && SIC_code='5541'DB:business_master_new
loadtime:6.5257728099823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willingboro' limit 1
loadtime:6.5258359909058 / seconds
Query Executed:select id FROM `nj` where city='Willingboro' && SIC_code='5541'DB:business_master_new
loadtime:6.5317299365997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:6.5317928791046 / seconds
Query Executed:select id FROM `nj` where city='Windsor' && SIC_code='5541'DB:business_master_new
loadtime:6.5816309452057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield Park' limit 1
loadtime:6.5816810131073 / seconds
Query Executed:select id FROM `nj` where city='Winfield Park' && SIC_code='5541'DB:business_master_new
loadtime:6.5826280117035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winslow' limit 1
loadtime:6.5826809406281 / seconds
Query Executed:select id FROM `nj` where city='Winslow' && SIC_code='5541'DB:business_master_new
loadtime:6.6242778301239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood Ridge' limit 1
loadtime:6.624354839325 / seconds
Query Executed:select id FROM `nj` where city='Wood Ridge' && SIC_code='5541'DB:business_master_new
loadtime:6.6290559768677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wood-Ridge' limit 1
loadtime:6.6291089057922 / seconds
Query Executed:select id FROM `nj` where city='Wood-Ridge' && SIC_code='5541'DB:business_master_new
loadtime:6.6305558681488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbine' limit 1
loadtime:6.6306238174438 / seconds
Query Executed:select id FROM `nj` where city='Woodbine' && SIC_code='5541'DB:business_master_new
loadtime:6.635018825531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:6.6350758075714 / seconds
Query Executed:select id FROM `nj` where city='Woodbridge' && SIC_code='5541'DB:business_master_new
loadtime:6.6415619850159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:6.6416218280792 / seconds
Query Executed:select id FROM `nj` where city='Woodbury' && SIC_code='5541'DB:business_master_new
loadtime:6.6499328613281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury Heights' limit 1
loadtime:6.6499989032745 / seconds
Query Executed:select id FROM `nj` where city='Woodbury Heights' && SIC_code='5541'DB:business_master_new
loadtime:6.6547048091888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodcliff Lake' limit 1
loadtime:6.6547648906708 / seconds
Query Executed:select id FROM `nj` where city='Woodcliff Lake' && SIC_code='5541'DB:business_master_new
loadtime:6.6601088047028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstown' limit 1
loadtime:6.6601688861847 / seconds
Query Executed:select id FROM `nj` where city='Woodstown' && SIC_code='5541'DB:business_master_new
loadtime:6.6663808822632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightstown' limit 1
loadtime:6.6664409637451 / seconds
Query Executed:select id FROM `nj` where city='Wrightstown' && SIC_code='5541'DB:business_master_new
loadtime:6.6708388328552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wyckoff' limit 1
loadtime:6.6709039211273 / seconds
Query Executed:select id FROM `nj` where city='Wyckoff' && SIC_code='5541'DB:business_master_new
loadtime:6.6778469085693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yardville' limit 1
loadtime:6.6778938770294 / seconds
Query Executed:select id FROM `nj` where city='Yardville' && SIC_code='5541'DB:business_master_new
loadtime:6.6790659427643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zarephath' limit 1
loadtime:6.6791207790375 / seconds
Query Executed:select id FROM `nj` where city='Zarephath' && SIC_code='5541'DB:business_master_new
loadtime:6.6802430152893 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:6.6803348064423 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:6.6805438995361 / seconds
Operation template executed (chunk cache operation)
loadtime:6.6806478500366 / seconds
template override:Default
loadtime:6.6806697845459 / 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:6.6825788021088 / seconds
Template Constructed, Array Rows:49
loadtime:6.683257818222 / seconds
TOTAL EXECUTION TIME: 6.68274
loadtime:6.6834168434143 / 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] => gasoline-service-station [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:6.6834208965302
TOTAL KEY ARRAYS: 69