DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00014185905456543 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010719299316406 / seconds
host not found setting manual db connection
loadtime:0.0019369125366211 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0028269290924072 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0032789707183838 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0034098625183105 / seconds
zipcode:
loadtime:0.0034539699554443 / seconds
Query Executed:select * from search_referrer where page_hash='dbf6fa9092c82831aa5d9f5129914e42' limit 10 DB:ezrox_toadli
loadtime:0.0040750503540039 / seconds
Operation header executed (non global)
loadtime:0.004133939743042 / seconds
Operation leaderboard executed (non global)
loadtime:0.0042219161987305 / seconds
Operation square executed (non global)
loadtime:0.0042588710784912 / seconds
Operation square_bottom executed (non global)
loadtime:0.0042910575866699 / seconds
Operation smallsquare executed (non global)
loadtime:0.0043208599090576 / seconds
Operation headeradright executed (non global)
loadtime:0.0043489933013916 / seconds
Operation google_analytics executed (non global)
loadtime:0.0043759346008301 / seconds
Operation topstories executed (non global)
loadtime:0.0044050216674805 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0044338703155518 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0044610500335693 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.005112886428833 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0055348873138428 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0056910514831543 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0058510303497314 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0059459209442139 / seconds
Template key: archive_menu pushed
loadtime:0.0059590339660645 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0059778690338135 / seconds
Template key: get_gravatar pushed
loadtime:0.0059878826141357 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.005997896194458 / seconds
*10)-10)+1 | start:0
loadtime:0.0060548782348633 / seconds
Query loaded from cache:select * from categories where cat_URLid='laundry-and-garment-services-nec'
loadtime:0.0061690807342529 / seconds
DB connected to localhost business_master_new
loadtime:0.0069339275360107 / seconds
Query Executed:select * from geodata_usstates where url_id='new-hampshire'DB:business_master_new
loadtime:0.0073699951171875 / seconds
Query stored in cache : _QUERY_www.toadli.coma18ca27a314d08cbdc4b1d1da4fd4824
loadtime:0.0074710845947266 / seconds
Query Executed:select * from `nh_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.081480026245117 / seconds
Query stored in cache : _QUERY_www.toadli.com0c6caa34fad21fc093843369a900451e
loadtime:0.081974983215332 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='new-hampshire'
loadtime:0.082004070281982 / seconds
Query Executed:select sum(totalcount) as totalsum from `nh_catmap` where sic='7219'DB:business_master_new
loadtime:0.08376407623291 / seconds
Query stored in cache : _QUERY_www.toadli.come4a14d05d0c23ae481bc490ec71af642
loadtime:0.083795070648193 / seconds
309 / 11
loadtime:0.083828926086426 / seconds
Query Executed:select * from geodata_geocity where city='Acworth' limit 1DB:business_master_new
loadtime:0.084135055541992 / seconds
Query stored in cache : _QUERY_www.toadli.com028637895891b8eae53d42ac5a84415d
loadtime:0.084176063537598 / seconds
Query Executed:select id FROM `nh` where city='Acworth' && SIC_code='7219'DB:business_master_new
loadtime:0.085475921630859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albany' limit 1
loadtime:0.085646867752075 / seconds
Query Executed:select id FROM `nh` where city='Albany' && SIC_code='7219'DB:business_master_new
loadtime:0.089843988418579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.089892864227295 / seconds
Query Executed:select id FROM `nh` where city='Alexandria' && SIC_code='7219'DB:business_master_new
loadtime:0.090900897979736 / seconds
Query Executed:select * from geodata_geocity where city='Allenstown' limit 1DB:business_master_new
loadtime:0.091194868087769 / seconds
Query stored in cache : _QUERY_www.toadli.com4e46dbe7f0ce29c185b47c5e81467e65
loadtime:0.091243982315063 / seconds
Query Executed:select id FROM `nh` where city='Allenstown' && SIC_code='7219'DB:business_master_new
loadtime:0.094666957855225 / seconds
Query Executed:select * from geodata_geocity where city='Alstead' limit 1DB:business_master_new
loadtime:0.09495997428894 / seconds
Query stored in cache : _QUERY_www.toadli.com59697b7d404b6f199e1b1a518f2628c6
loadtime:0.095009088516235 / seconds
Query Executed:select id FROM `nh` where city='Alstead' && SIC_code='7219'DB:business_master_new
loadtime:0.10475087165833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.10480093955994 / seconds
Query Executed:select id FROM `nh` where city='Alton' && SIC_code='7219'DB:business_master_new
loadtime:0.10522699356079 / seconds
Query Executed:select * from geodata_geocity where city='Alton Bay' limit 1DB:business_master_new
loadtime:0.10550999641418 / seconds
Query stored in cache : _QUERY_www.toadli.com0eef878ea5830529bf0021b543288cc2
loadtime:0.10555791854858 / seconds
Query Executed:select id FROM `nh` where city='Alton Bay' && SIC_code='7219'DB:business_master_new
loadtime:0.10598587989807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amherst' limit 1
loadtime:0.10603308677673 / seconds
Query Executed:select id FROM `nh` where city='Amherst' && SIC_code='7219'DB:business_master_new
loadtime:0.10662698745728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.10672998428345 / seconds
Query Executed:select id FROM `nh` where city='Andover' && SIC_code='7219'DB:business_master_new
loadtime:0.10784602165222 / seconds
Query Executed:select * from geodata_geocity where city='Antrim' limit 1DB:business_master_new
loadtime:0.10868406295776 / seconds
Query stored in cache : _QUERY_www.toadli.com3d2025284ffe8237e5c014039618fb18
loadtime:0.10881590843201 / seconds
Query Executed:select id FROM `nh` where city='Antrim' && SIC_code='7219'DB:business_master_new
loadtime:0.11000895500183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.1101610660553 / seconds
Query Executed:select id FROM `nh` where city='Ashland' && SIC_code='7219'DB:business_master_new
loadtime:0.11104488372803 / seconds
Query Executed:select * from geodata_geocity where city='Ashuelot' limit 1DB:business_master_new
loadtime:0.11187291145325 / seconds
Query stored in cache : _QUERY_www.toadli.com11a2efaa620e43bb81854826c8b4e0e0
loadtime:0.11191487312317 / seconds
Query Executed:select id FROM `nh` where city='Ashuelot' && SIC_code='7219'DB:business_master_new
loadtime:0.11814093589783 / seconds
Query Executed:select * from geodata_geocity where city='Atkinson' limit 1DB:business_master_new
loadtime:0.11845302581787 / seconds
Query stored in cache : _QUERY_www.toadli.comb7e8618748d2c784eb06f4f12743b477
loadtime:0.11849594116211 / seconds
Query Executed:select id FROM `nh` where city='Atkinson' && SIC_code='7219'DB:business_master_new
loadtime:0.11894106864929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.11898994445801 / seconds
Query Executed:select id FROM `nh` where city='Auburn' && SIC_code='7219'DB:business_master_new
loadtime:0.11941885948181 / seconds
Query Executed:select * from geodata_geocity where city='Barnstead' limit 1DB:business_master_new
loadtime:0.11971592903137 / seconds
Query stored in cache : _QUERY_www.toadli.com4f427483e4f8ae236abe64118c64c0b3
loadtime:0.11976194381714 / seconds
Query Executed:select id FROM `nh` where city='Barnstead' && SIC_code='7219'DB:business_master_new
loadtime:0.1201798915863 / seconds
Query Executed:select * from geodata_geocity where city='Barrington' limit 1DB:business_master_new
loadtime:0.12046194076538 / seconds
Query stored in cache : _QUERY_www.toadli.com89eed680674ea331c79ecc0d1286ac7f
loadtime:0.1205039024353 / seconds
Query Executed:select id FROM `nh` where city='Barrington' && SIC_code='7219'DB:business_master_new
loadtime:0.12093806266785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bartlett' limit 1
loadtime:0.12098693847656 / seconds
Query Executed:select id FROM `nh` where city='Bartlett' && SIC_code='7219'DB:business_master_new
loadtime:0.12141299247742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.12146997451782 / seconds
Query Executed:select id FROM `nh` where city='Bath' && SIC_code='7219'DB:business_master_new
loadtime:0.12191104888916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bedford' limit 1
loadtime:0.12195897102356 / seconds
Query Executed:select id FROM `nh` where city='Bedford' && SIC_code='7219'DB:business_master_new
loadtime:0.12238597869873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.12243390083313 / seconds
Query Executed:select id FROM `nh` where city='Belmont' && SIC_code='7219'DB:business_master_new
loadtime:0.12287092208862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennington' limit 1
loadtime:0.12292003631592 / seconds
Query Executed:select id FROM `nh` where city='Bennington' && SIC_code='7219'DB:business_master_new
loadtime:0.12333703041077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benton' limit 1
loadtime:0.12338590621948 / seconds
Query Executed:select id FROM `nh` where city='Benton' && SIC_code='7219'DB:business_master_new
loadtime:0.12363886833191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.12368106842041 / seconds
Query Executed:select id FROM `nh` where city='Berlin' && SIC_code='7219'DB:business_master_new
loadtime:0.12409591674805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.1241409778595 / seconds
Query Executed:select id FROM `nh` where city='Bethlehem' && SIC_code='7219'DB:business_master_new
loadtime:0.12454986572266 / seconds
Query Executed:select * from geodata_geocity where city='Boscawen' limit 1DB:business_master_new
loadtime:0.12485909461975 / seconds
Query stored in cache : _QUERY_www.toadli.com8d19aeaaed3e8312378c47a15ac268cb
loadtime:0.12490200996399 / seconds
Query Executed:select id FROM `nh` where city='Boscawen' && SIC_code='7219'DB:business_master_new
loadtime:0.12797093391418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bow' limit 1
loadtime:0.12801790237427 / seconds
Query Executed:select id FROM `nh` where city='Bow' && SIC_code='7219'DB:business_master_new
loadtime:0.12844705581665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bradford' limit 1
loadtime:0.12848901748657 / seconds
Query Executed:select id FROM `nh` where city='Bradford' && SIC_code='7219'DB:business_master_new
loadtime:0.1289370059967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brentwood' limit 1
loadtime:0.12899208068848 / seconds
Query Executed:select id FROM `nh` where city='Brentwood' && SIC_code='7219'DB:business_master_new
loadtime:0.13341188430786 / seconds
Query Executed:select * from geodata_geocity where city='Bretton Woods' limit 1DB:business_master_new
loadtime:0.13418292999268 / seconds
Query stored in cache : _QUERY_www.toadli.comfe6f58ed8b3e5590cdc1b56932632f7d
loadtime:0.13428688049316 / seconds
Query Executed:select id FROM `nh` where city='Bretton Woods' && SIC_code='7219'DB:business_master_new
loadtime:0.13924193382263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.1393780708313 / seconds
Query Executed:select id FROM `nh` where city='Bristol' && SIC_code='7219'DB:business_master_new
loadtime:0.14061307907104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.14076805114746 / seconds
Query Executed:select id FROM `nh` where city='Brookfield' && SIC_code='7219'DB:business_master_new
loadtime:0.14202094078064 / seconds
Query Executed:select * from geodata_geocity where city='Brookline' limit 1DB:business_master_new
loadtime:0.14274907112122 / seconds
Query stored in cache : _QUERY_www.toadli.com32cb85027ec1eaed0a235b38ddfae001
loadtime:0.14288902282715 / seconds
Query Executed:select id FROM `nh` where city='Brookline' && SIC_code='7219'DB:business_master_new
loadtime:0.14421701431274 / seconds
Query Executed:select * from geodata_geocity where city='Campton' limit 1DB:business_master_new
loadtime:0.14515399932861 / seconds
Query stored in cache : _QUERY_www.toadli.com96f369c2c454763661b1d27d652b61f8
loadtime:0.14529204368591 / seconds
Query Executed:select id FROM `nh` where city='Campton' && SIC_code='7219'DB:business_master_new
loadtime:0.14632487297058 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.1463770866394 / seconds
Query Executed:select id FROM `nh` where city='Canaan' && SIC_code='7219'DB:business_master_new
loadtime:0.14747595787048 / seconds
Query Executed:select * from geodata_geocity where city='Candia' limit 1DB:business_master_new
loadtime:0.14835000038147 / seconds
Query stored in cache : _QUERY_www.toadli.comf08b36f21d52e97fba85ffc6f9de443a
loadtime:0.14847898483276 / seconds
Query Executed:select id FROM `nh` where city='Candia' && SIC_code='7219'DB:business_master_new
loadtime:0.14964389801025 / seconds
Query Executed:select * from geodata_geocity where city='Canterbury' limit 1DB:business_master_new
loadtime:0.15050387382507 / seconds
Query stored in cache : _QUERY_www.toadli.com7b4df376b9c55c36839787f62b04915d
loadtime:0.15064287185669 / seconds
Query Executed:select id FROM `nh` where city='Canterbury' && SIC_code='7219'DB:business_master_new
loadtime:0.15177297592163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carroll' limit 1
loadtime:0.1519410610199 / seconds
Query Executed:select id FROM `nh` where city='Carroll' && SIC_code='7219'DB:business_master_new
loadtime:0.15446186065674 / seconds
Query Executed:select * from geodata_geocity where city='Center Barnstead' limit 1DB:business_master_new
loadtime:0.15478706359863 / seconds
Query stored in cache : _QUERY_www.toadli.comab55ac09058da5c9ab5088f805e7ef47
loadtime:0.15483403205872 / seconds
Query Executed:select id FROM `nh` where city='Center Barnstead' && SIC_code='7219'DB:business_master_new
loadtime:0.155268907547 / seconds
Query Executed:select * from geodata_geocity where city='Center Conway' limit 1DB:business_master_new
loadtime:0.15555691719055 / seconds
Query stored in cache : _QUERY_www.toadli.coma9ff9ca0766ccf6c6e0d7cb9b4f55c40
loadtime:0.15559101104736 / seconds
Query Executed:select id FROM `nh` where city='Center Conway' && SIC_code='7219'DB:business_master_new
loadtime:0.15602803230286 / seconds
Query Executed:select * from geodata_geocity where city='Center Harbor' limit 1DB:business_master_new
loadtime:0.1563138961792 / seconds
Query stored in cache : _QUERY_www.toadli.com9e3941cba42658eea69f2d5fcaed9321
loadtime:0.15635704994202 / seconds
Query Executed:select id FROM `nh` where city='Center Harbor' && SIC_code='7219'DB:business_master_new
loadtime:0.15679001808167 / seconds
Query Executed:select * from geodata_geocity where city='Center Ossipee' limit 1DB:business_master_new
loadtime:0.15706992149353 / seconds
Query stored in cache : _QUERY_www.toadli.com38c4471b903579dd79342e22b86c72e1
loadtime:0.15710806846619 / seconds
Query Executed:select id FROM `nh` where city='Center Ossipee' && SIC_code='7219'DB:business_master_new
loadtime:0.15752601623535 / seconds
Query Executed:select * from geodata_geocity where city='Center Sandwich' limit 1DB:business_master_new
loadtime:0.15778493881226 / seconds
Query stored in cache : _QUERY_www.toadli.com2906aa91981f7561a6046df8b01a1402
loadtime:0.15781307220459 / seconds
Query Executed:select id FROM `nh` where city='Center Sandwich' && SIC_code='7219'DB:business_master_new
loadtime:0.15825390815735 / seconds
Query Executed:select * from geodata_geocity where city='Center Strafford' limit 1DB:business_master_new
loadtime:0.15857005119324 / seconds
Query stored in cache : _QUERY_www.toadli.com4e0c24287743a67db85108b62e190654
loadtime:0.15861797332764 / seconds
Query Executed:select id FROM `nh` where city='Center Strafford' && SIC_code='7219'DB:business_master_new
loadtime:0.15895891189575 / seconds
Query Executed:select * from geodata_geocity where city='Center Tuftonboro' limit 1DB:business_master_new
loadtime:0.15923500061035 / seconds
Query stored in cache : _QUERY_www.toadli.com3cd12ff585865faa79df6af53bc7f2ce
loadtime:0.15927505493164 / seconds
Query Executed:select id FROM `nh` where city='Center Tuftonboro' && SIC_code='7219'DB:business_master_new
loadtime:0.15968298912048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlestown' limit 1
loadtime:0.15972304344177 / seconds
Query Executed:select id FROM `nh` where city='Charlestown' && SIC_code='7219'DB:business_master_new
loadtime:0.16015005111694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatham' limit 1
loadtime:0.16019606590271 / seconds
Query Executed:select id FROM `nh` where city='Chatham' && SIC_code='7219'DB:business_master_new
loadtime:0.16193199157715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.16197991371155 / seconds
Query Executed:select id FROM `nh` where city='Chester' && SIC_code='7219'DB:business_master_new
loadtime:0.1624128818512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chesterfield' limit 1
loadtime:0.16244697570801 / seconds
Query Executed:select id FROM `nh` where city='Chesterfield' && SIC_code='7219'DB:business_master_new
loadtime:0.1628839969635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chichester' limit 1
loadtime:0.16293787956238 / seconds
Query Executed:select id FROM `nh` where city='Chichester' && SIC_code='7219'DB:business_master_new
loadtime:0.16333699226379 / seconds
Query Executed:select * from geodata_geocity where city='Chocorua' limit 1DB:business_master_new
loadtime:0.16361403465271 / seconds
Query stored in cache : _QUERY_www.toadli.com50b3a0bf46dabcdd1f99bf28cba7639c
loadtime:0.16365599632263 / seconds
Query Executed:select id FROM `nh` where city='Chocorua' && SIC_code='7219'DB:business_master_new
loadtime:0.16406798362732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:0.16411590576172 / seconds
Query Executed:select id FROM `nh` where city='Claremont' && SIC_code='7219'DB:business_master_new
loadtime:0.16452693939209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarksville' limit 1
loadtime:0.16458106040955 / seconds
Query Executed:select id FROM `nh` where city='Clarksville' && SIC_code='7219'DB:business_master_new
loadtime:0.16522288322449 / seconds
Query Executed:select * from geodata_geocity where city='Colebrook' limit 1DB:business_master_new
loadtime:0.16549301147461 / seconds
Query stored in cache : _QUERY_www.toadli.com48f61dbc5e4a35a1d026c0260bded065
loadtime:0.16552591323853 / seconds
Query Executed:select id FROM `nh` where city='Colebrook' && SIC_code='7219'DB:business_master_new
loadtime:0.16596794128418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:0.16601586341858 / seconds
Query Executed:select id FROM `nh` where city='Concord' && SIC_code='7219'DB:business_master_new
loadtime:0.16643905639648 / seconds
Query Executed:select * from geodata_geocity where city='Contoocook' limit 1DB:business_master_new
loadtime:0.16672301292419 / seconds
Query stored in cache : _QUERY_www.toadli.com48eb1f12a8c269df0d3007f4894153e2
loadtime:0.16676497459412 / seconds
Query Executed:select id FROM `nh` where city='Contoocook' && SIC_code='7219'DB:business_master_new
loadtime:0.16718602180481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:0.16722893714905 / seconds
Query Executed:select id FROM `nh` where city='Conway' && SIC_code='7219'DB:business_master_new
loadtime:0.16763401031494 / seconds
Query Executed:select * from geodata_geocity where city='Cornish' limit 1DB:business_master_new
loadtime:0.16792106628418 / seconds
Query stored in cache : _QUERY_www.toadli.comc1c28b2178e49e04ee93c31dea2c40ef
loadtime:0.1679539680481 / seconds
Query Executed:select id FROM `nh` where city='Cornish' && SIC_code='7219'DB:business_master_new
loadtime:0.1683509349823 / seconds
Query Executed:select * from geodata_geocity where city='Cornish Flat' limit 1DB:business_master_new
loadtime:0.16863107681274 / seconds
Query stored in cache : _QUERY_www.toadli.com8c29161740a6ce1ce82a4be8a88132f2
loadtime:0.16867208480835 / seconds
Query Executed:select id FROM `nh` where city='Cornish Flat' && SIC_code='7219'DB:business_master_new
loadtime:0.17666387557983 / seconds
Query Executed:select * from geodata_geocity where city='Croydon' limit 1DB:business_master_new
loadtime:0.17753195762634 / seconds
Query stored in cache : _QUERY_www.toadli.com7307d9ab3193ee65bbcac7c94d9a60f9
loadtime:0.17770290374756 / seconds
Query Executed:select id FROM `nh` where city='Croydon' && SIC_code='7219'DB:business_master_new
loadtime:0.17873692512512 / seconds
Query Executed:select * from geodata_geocity where city='Ctr Tuftonboro' limit 1DB:business_master_new
loadtime:0.17902207374573 / seconds
Query stored in cache : _QUERY_www.toadli.comc64cfcc7b5d17a56df0d5076d73b8e84
loadtime:0.17906308174133 / seconds
Query Executed:select id FROM `nh` where city='Ctr Tuftonboro' && SIC_code='7219'DB:business_master_new
loadtime:0.17930698394775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dalton' limit 1
loadtime:0.17934393882751 / seconds
Query Executed:select id FROM `nh` where city='Dalton' && SIC_code='7219'DB:business_master_new
loadtime:0.17995595932007 / seconds
Query Executed:select * from geodata_geocity where city='Danbury' limit 1DB:business_master_new
loadtime:0.18029499053955 / seconds
Query stored in cache : _QUERY_www.toadli.comc5a0b04711d01fd78cc77f2ae84f459c
loadtime:0.18033790588379 / seconds
Query Executed:select id FROM `nh` where city='Danbury' && SIC_code='7219'DB:business_master_new
loadtime:0.18075108528137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.18079304695129 / seconds
Query Executed:select id FROM `nh` where city='Danville' && SIC_code='7219'DB:business_master_new
loadtime:0.18121600151062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deerfield' limit 1
loadtime:0.18126606941223 / seconds
Query Executed:select id FROM `nh` where city='Deerfield' && SIC_code='7219'DB:business_master_new
loadtime:0.18167686462402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deering' limit 1
loadtime:0.18170404434204 / seconds
Query Executed:select id FROM `nh` where city='Deering' && SIC_code='7219'DB:business_master_new
loadtime:0.18379592895508 / seconds
Query Executed:select * from geodata_geocity where city='Derry' limit 1DB:business_master_new
loadtime:0.18410706520081 / seconds
Query stored in cache : _QUERY_www.toadli.combd16a021b6b20fcd52dd8b26f5bccd0e
loadtime:0.18414497375488 / seconds
Query Executed:select id FROM `nh` where city='Derry' && SIC_code='7219'DB:business_master_new
loadtime:0.18456387519836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dorchester' limit 1
loadtime:0.18460893630981 / seconds
Query Executed:select id FROM `nh` where city='Dorchester' && SIC_code='7219'DB:business_master_new
loadtime:0.18484306335449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:0.18487906455994 / seconds
Query Executed:select id FROM `nh` where city='Dover' && SIC_code='7219'DB:business_master_new
loadtime:0.18529105186462 / seconds
Query Executed:select * from geodata_geocity where city='Drewsville' limit 1DB:business_master_new
loadtime:0.18558502197266 / seconds
Query stored in cache : _QUERY_www.toadli.comb5f691aca7c4f07f8a0530ca594f38e9
loadtime:0.18563103675842 / seconds
Query Executed:select id FROM `nh` where city='Drewsville' && SIC_code='7219'DB:business_master_new
loadtime:0.18638396263123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:0.18642902374268 / seconds
Query Executed:select id FROM `nh` where city='Dublin' && SIC_code='7219'DB:business_master_new
loadtime:0.18686294555664 / seconds
Query Executed:select * from geodata_geocity where city='Dummer' limit 1DB:business_master_new
loadtime:0.18715000152588 / seconds
Query stored in cache : _QUERY_www.toadli.com62805eafa10966e762a1e65d9071bb91
loadtime:0.18718886375427 / seconds
Query Executed:select id FROM `nh` where city='Dummer' && SIC_code='7219'DB:business_master_new
loadtime:0.18812799453735 / seconds
Query Executed:select * from geodata_geocity where city='Dunbarton' limit 1DB:business_master_new
loadtime:0.18876791000366 / seconds
Query stored in cache : _QUERY_www.toadli.com6fae6640b94c1aec77712902d75853df
loadtime:0.18888807296753 / seconds
Query Executed:select id FROM `nh` where city='Dunbarton' && SIC_code='7219'DB:business_master_new
loadtime:0.19006586074829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.1902379989624 / seconds
Query Executed:select id FROM `nh` where city='Durham' && SIC_code='7219'DB:business_master_new
loadtime:0.1914279460907 / seconds
Query Executed:select * from geodata_geocity where city='East Andover' limit 1DB:business_master_new
loadtime:0.19229388237 / seconds
Query stored in cache : _QUERY_www.toadli.comb36cf6bad2a29963ffd1433bb4abfac1
loadtime:0.19243288040161 / seconds
Query Executed:select id FROM `nh` where city='East Andover' && SIC_code='7219'DB:business_master_new
loadtime:0.19678497314453 / seconds
Query Executed:select * from geodata_geocity where city='East Candia' limit 1DB:business_master_new
loadtime:0.19704389572144 / seconds
Query stored in cache : _QUERY_www.toadli.com57f30429e95d6f95a0defaf0edd1eaea
loadtime:0.19709300994873 / seconds
Query Executed:select id FROM `nh` where city='East Candia' && SIC_code='7219'DB:business_master_new
loadtime:0.19733500480652 / seconds
Query Executed:select * from geodata_geocity where city='East Derry' limit 1DB:business_master_new
loadtime:0.19759607315063 / seconds
Query stored in cache : _QUERY_www.toadli.com7a8d7f7fe0d1f78a86bf61efc4b37e4d
loadtime:0.19763493537903 / seconds
Query Executed:select id FROM `nh` where city='East Derry' && SIC_code='7219'DB:business_master_new
loadtime:0.19799900054932 / seconds
Query Executed:select * from geodata_geocity where city='East Hampstead' limit 1DB:business_master_new
loadtime:0.19828104972839 / seconds
Query stored in cache : _QUERY_www.toadli.com759fb982ead6b7da223385a07b4da611
loadtime:0.19831490516663 / seconds
Query Executed:select id FROM `nh` where city='East Hampstead' && SIC_code='7219'DB:business_master_new
loadtime:0.19872498512268 / seconds
Query Executed:select * from geodata_geocity where city='East Hebron' limit 1DB:business_master_new
loadtime:0.1989848613739 / seconds
Query stored in cache : _QUERY_www.toadli.com185c17d255bc900cb1e0118c6967dade
loadtime:0.19902300834656 / seconds
Query Executed:select id FROM `nh` where city='East Hebron' && SIC_code='7219'DB:business_master_new
loadtime:0.19927906990051 / seconds
Query Executed:select * from geodata_geocity where city='East Kingston' limit 1DB:business_master_new
loadtime:0.19955205917358 / seconds
Query stored in cache : _QUERY_www.toadli.com88f1ff394bd914ef91308d1efceecdf5
loadtime:0.19958090782166 / seconds
Query Executed:select id FROM `nh` where city='East Kingston' && SIC_code='7219'DB:business_master_new
loadtime:0.20000600814819 / seconds
Query Executed:select * from geodata_geocity where city='East Swanzey' limit 1DB:business_master_new
loadtime:0.20028305053711 / seconds
Query stored in cache : _QUERY_www.toadli.com4264d2a1889e62de49f6cd693380d3f4
loadtime:0.20032691955566 / seconds
Query Executed:select id FROM `nh` where city='East Swanzey' && SIC_code='7219'DB:business_master_new
loadtime:0.20059108734131 / seconds
Query Executed:select * from geodata_geocity where city='East Wakefield' limit 1DB:business_master_new
loadtime:0.20085406303406 / seconds
Query stored in cache : _QUERY_www.toadli.com3ea2e0567ee4850c28753831addd0bff
loadtime:0.20088291168213 / seconds
Query Executed:select id FROM `nh` where city='East Wakefield' && SIC_code='7219'DB:business_master_new
loadtime:0.20121693611145 / seconds
Query Executed:select * from geodata_geocity where city='Eaton Center' limit 1DB:business_master_new
loadtime:0.20147395133972 / seconds
Query stored in cache : _QUERY_www.toadli.com5dd8d2de25a260966ebcbfc694b9fd20
loadtime:0.20150709152222 / seconds
Query Executed:select id FROM `nh` where city='Eaton Center' && SIC_code='7219'DB:business_master_new
loadtime:0.20185303688049 / seconds
Query Executed:select * from geodata_geocity where city='Effingham' limit 1DB:business_master_new
loadtime:0.20214486122131 / seconds
Query stored in cache : _QUERY_www.toadli.coma5c93c934a212d021705596b0d5e344e
loadtime:0.20218396186829 / seconds
Query Executed:select id FROM `nh` where city='Effingham' && SIC_code='7219'DB:business_master_new
loadtime:0.20278906822205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkins' limit 1
loadtime:0.20288991928101 / seconds
Query Executed:select id FROM `nh` where city='Elkins' && SIC_code='7219'DB:business_master_new
loadtime:0.20371294021606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellsworth' limit 1
loadtime:0.20381903648376 / seconds
Query Executed:select id FROM `nh` where city='Ellsworth' && SIC_code='7219'DB:business_master_new
loadtime:0.20448803901672 / seconds
Query Executed:select * from geodata_geocity where city='Enfield' limit 1DB:business_master_new
loadtime:0.20537686347961 / seconds
Query stored in cache : _QUERY_www.toadli.comf7b2c30814d60bb5ac7e5ffced40aa10
loadtime:0.20549297332764 / seconds
Query Executed:select id FROM `nh` where city='Enfield' && SIC_code='7219'DB:business_master_new
loadtime:0.2066478729248 / seconds
Query Executed:select * from geodata_geocity where city='Enfield Center' limit 1DB:business_master_new
loadtime:0.20749592781067 / seconds
Query stored in cache : _QUERY_www.toadli.com96f412a167388c1973fda3984b5f0e89
loadtime:0.20767188072205 / seconds
Query Executed:select id FROM `nh` where city='Enfield Center' && SIC_code='7219'DB:business_master_new
loadtime:0.21034288406372 / seconds
Query Executed:select * from geodata_geocity where city='Epping' limit 1DB:business_master_new
loadtime:0.21066498756409 / seconds
Query stored in cache : _QUERY_www.toadli.comd8c0678e165c4a7cfe554563437e1b53
loadtime:0.21071100234985 / seconds
Query Executed:select id FROM `nh` where city='Epping' && SIC_code='7219'DB:business_master_new
loadtime:0.21114802360535 / seconds
Query Executed:select * from geodata_geocity where city='Epsom' limit 1DB:business_master_new
loadtime:0.21220397949219 / seconds
Query stored in cache : _QUERY_www.toadli.coma6b49023d0bf74322bb37094157e2d5d
loadtime:0.21225190162659 / seconds
Query Executed:select id FROM `nh` where city='Epsom' && SIC_code='7219'DB:business_master_new
loadtime:0.21268486976624 / seconds
Query Executed:select * from geodata_geocity where city='Errol' limit 1DB:business_master_new
loadtime:0.21297907829285 / seconds
Query stored in cache : _QUERY_www.toadli.comb823d3178b33bad6ecc442b33e31d4e0
loadtime:0.2130138874054 / seconds
Query Executed:select id FROM `nh` where city='Errol' && SIC_code='7219'DB:business_master_new
loadtime:0.21342587471008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etna' limit 1
loadtime:0.21346592903137 / seconds
Query Executed:select id FROM `nh` where city='Etna' && SIC_code='7219'DB:business_master_new
loadtime:0.21390390396118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Exeter' limit 1
loadtime:0.21395206451416 / seconds
Query Executed:select id FROM `nh` where city='Exeter' && SIC_code='7219'DB:business_master_new
loadtime:0.2143759727478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.21440887451172 / seconds
Query Executed:select id FROM `nh` where city='Farmington' && SIC_code='7219'DB:business_master_new
loadtime:0.21484804153442 / seconds
Query Executed:select * from geodata_geocity where city='Fitzwilliam' limit 1DB:business_master_new
loadtime:0.21511197090149 / seconds
Query stored in cache : _QUERY_www.toadli.com5c38be8bfc3c4a63efb58e78da865917
loadtime:0.21515297889709 / seconds
Query Executed:select id FROM `nh` where city='Fitzwilliam' && SIC_code='7219'DB:business_master_new
loadtime:0.21555304527283 / seconds
Query Executed:select * from geodata_geocity where city='Francestown' limit 1DB:business_master_new
loadtime:0.21581292152405 / seconds
Query stored in cache : _QUERY_www.toadli.com07d3747b65ae66ebfcb38c200c21d1e2
loadtime:0.21584296226501 / seconds
Query Executed:select id FROM `nh` where city='Francestown' && SIC_code='7219'DB:business_master_new
loadtime:0.2162458896637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franconia' limit 1
loadtime:0.21628189086914 / seconds
Query Executed:select id FROM `nh` where city='Franconia' && SIC_code='7219'DB:business_master_new
loadtime:0.21667194366455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:0.21671199798584 / seconds
Query Executed:select id FROM `nh` where city='Franklin' && SIC_code='7219'DB:business_master_new
loadtime:0.21712303161621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Freedom' limit 1
loadtime:0.21717095375061 / seconds
Query Executed:select id FROM `nh` where city='Freedom' && SIC_code='7219'DB:business_master_new
loadtime:0.21756386756897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:0.21760201454163 / seconds
Query Executed:select id FROM `nh` where city='Fremont' && SIC_code='7219'DB:business_master_new
loadtime:0.21800398826599 / seconds
Query Executed:select * from geodata_geocity where city='Georges Mills' limit 1DB:business_master_new
loadtime:0.2183039188385 / seconds
Query stored in cache : _QUERY_www.toadli.com95c5d9ba9de946277b6c2a08b3fcb9b7
loadtime:0.21834993362427 / seconds
Query Executed:select id FROM `nh` where city='Georges Mills' && SIC_code='7219'DB:business_master_new
loadtime:0.21868395805359 / seconds
Query Executed:select * from geodata_geocity where city='Gilford' limit 1DB:business_master_new
loadtime:0.2189610004425 / seconds
Query stored in cache : _QUERY_www.toadli.com4b7a7dc5c375875c1a2c4fd186255572
loadtime:0.21899890899658 / seconds
Query Executed:select id FROM `nh` where city='Gilford' && SIC_code='7219'DB:business_master_new
loadtime:0.21940803527832 / seconds
Query Executed:select * from geodata_geocity where city='Gilmanton' limit 1DB:business_master_new
loadtime:0.21970701217651 / seconds
Query stored in cache : _QUERY_www.toadli.comc250784fc07569c35daacc6155e3a416
loadtime:0.21973896026611 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton' && SIC_code='7219'DB:business_master_new
loadtime:0.22015500068665 / seconds
Query Executed:select * from geodata_geocity where city='Gilmanton Iron Works' limit 1DB:business_master_new
loadtime:0.22044801712036 / seconds
Query stored in cache : _QUERY_www.toadli.com4a7318a994dc5ca04d294871b5865ece
loadtime:0.2204909324646 / seconds
Query Executed:select id FROM `nh` where city='Gilmanton Iron Works' && SIC_code='7219'DB:business_master_new
loadtime:0.22092008590698 / seconds
Query Executed:select * from geodata_geocity where city='Gilsum' limit 1DB:business_master_new
loadtime:0.22119903564453 / seconds
Query stored in cache : _QUERY_www.toadli.comaf943b10d8e3d35e13ff24f1f41368d7
loadtime:0.22124004364014 / seconds
Query Executed:select id FROM `nh` where city='Gilsum' && SIC_code='7219'DB:business_master_new
loadtime:0.22155690193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen' limit 1
loadtime:0.22159886360168 / seconds
Query Executed:select id FROM `nh` where city='Glen' && SIC_code='7219'DB:business_master_new
loadtime:0.22202706336975 / seconds
Query Executed:select * from geodata_geocity where city='Glencliff' limit 1DB:business_master_new
loadtime:0.22229599952698 / seconds
Query stored in cache : _QUERY_www.toadli.comf41122dfe04e985574d956757557e2b0
loadtime:0.2223379611969 / seconds
Query Executed:select id FROM `nh` where city='Glencliff' && SIC_code='7219'DB:business_master_new
loadtime:0.22394394874573 / seconds
Query Executed:select * from geodata_geocity where city='Glmntn Iron Wks' limit 1DB:business_master_new
loadtime:0.22421789169312 / seconds
Query stored in cache : _QUERY_www.toadli.com9b3b98af661247c5890b04f8fe7e7323
loadtime:0.22426295280457 / seconds
Query Executed:select id FROM `nh` where city='Glmntn Iron Wks' && SIC_code='7219'DB:business_master_new
loadtime:0.22566986083984 / seconds
Query Executed:select * from geodata_geocity where city='Goffstown' limit 1DB:business_master_new
loadtime:0.22629594802856 / seconds
Query stored in cache : _QUERY_www.toadli.com26e3bc17838bb389746518684cd8e5c5
loadtime:0.22634291648865 / seconds
Query Executed:select id FROM `nh` where city='Goffstown' && SIC_code='7219'DB:business_master_new
loadtime:0.22753596305847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gorham' limit 1
loadtime:0.22773408889771 / seconds
Query Executed:select id FROM `nh` where city='Gorham' && SIC_code='7219'DB:business_master_new
loadtime:0.22891592979431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.2290198802948 / seconds
Query Executed:select id FROM `nh` where city='Goshen' && SIC_code='7219'DB:business_master_new
loadtime:0.23016786575317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grafton' limit 1
loadtime:0.230220079422 / seconds
Query Executed:select id FROM `nh` where city='Grafton' && SIC_code='7219'DB:business_master_new
loadtime:0.2311098575592 / seconds
Query Executed:select * from geodata_geocity where city='Grantham' limit 1DB:business_master_new
loadtime:0.23198986053467 / seconds
Query stored in cache : _QUERY_www.toadli.com802c38936f192a02dfdce5a89d62efdc
loadtime:0.23210692405701 / seconds
Query Executed:select id FROM `nh` where city='Grantham' && SIC_code='7219'DB:business_master_new
loadtime:0.23324203491211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenfield' limit 1
loadtime:0.23335599899292 / seconds
Query Executed:select id FROM `nh` where city='Greenfield' && SIC_code='7219'DB:business_master_new
loadtime:0.23429608345032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenland' limit 1
loadtime:0.23433804512024 / seconds
Query Executed:select id FROM `nh` where city='Greenland' && SIC_code='7219'DB:business_master_new
loadtime:0.23497009277344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.23502087593079 / seconds
Query Executed:select id FROM `nh` where city='Greenville' && SIC_code='7219'DB:business_master_new
loadtime:0.23544502258301 / seconds
Query Executed:select * from geodata_geocity where city='Groveton' limit 1DB:business_master_new
loadtime:0.23585200309753 / seconds
Query stored in cache : _QUERY_www.toadli.com2fc15cf298d27e4589241e3f25ba8b6d
loadtime:0.23597598075867 / seconds
Query Executed:select id FROM `nh` where city='Groveton' && SIC_code='7219'DB:business_master_new
loadtime:0.2365870475769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guild' limit 1
loadtime:0.2366669178009 / seconds
Query Executed:select id FROM `nh` where city='Guild' && SIC_code='7219'DB:business_master_new
loadtime:0.24088788032532 / seconds
Query Executed:select * from geodata_geocity where city='Hales Location' limit 1DB:business_master_new
loadtime:0.24117302894592 / seconds
Query stored in cache : _QUERY_www.toadli.combcd174d14b78e20ab8bf81c4a0fe6a93
loadtime:0.24121594429016 / seconds
Query Executed:select id FROM `nh` where city='Hales Location' && SIC_code='7219'DB:business_master_new
loadtime:0.24144101142883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:0.24147987365723 / seconds
Query Executed:select id FROM `nh` where city='Hampstead' && SIC_code='7219'DB:business_master_new
loadtime:0.24190402030945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.24195194244385 / seconds
Query Executed:select id FROM `nh` where city='Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.24237394332886 / seconds
Query Executed:select * from geodata_geocity where city='Hampton Falls' limit 1DB:business_master_new
loadtime:0.24267506599426 / seconds
Query stored in cache : _QUERY_www.toadli.com5bbdf42d4e9b9762017065800062fbc5
loadtime:0.24270987510681 / seconds
Query Executed:select id FROM `nh` where city='Hampton Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.243332862854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hancock' limit 1
loadtime:0.24342799186707 / seconds
Query Executed:select id FROM `nh` where city='Hancock' && SIC_code='7219'DB:business_master_new
loadtime:0.2444589138031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.24462008476257 / seconds
Query Executed:select id FROM `nh` where city='Hanover' && SIC_code='7219'DB:business_master_new
loadtime:0.24565291404724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisville' limit 1
loadtime:0.24579191207886 / seconds
Query Executed:select id FROM `nh` where city='Harrisville' && SIC_code='7219'DB:business_master_new
loadtime:0.24665808677673 / seconds
Query Executed:select * from geodata_geocity where city='Harts Location' limit 1DB:business_master_new
loadtime:0.24735403060913 / seconds
Query stored in cache : _QUERY_www.toadli.coma1eb64286ff217942267ecdb63297ca5
loadtime:0.24749994277954 / seconds
Query Executed:select id FROM `nh` where city='Harts Location' && SIC_code='7219'DB:business_master_new
loadtime:0.24921607971191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haverhill' limit 1
loadtime:0.24927186965942 / seconds
Query Executed:select id FROM `nh` where city='Haverhill' && SIC_code='7219'DB:business_master_new
loadtime:0.24959397315979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.2496349811554 / seconds
Query Executed:select id FROM `nh` where city='Hebron' && SIC_code='7219'DB:business_master_new
loadtime:0.25005292892456 / seconds
Query Executed:select * from geodata_geocity where city='Henniker' limit 1DB:business_master_new
loadtime:0.25037693977356 / seconds
Query stored in cache : _QUERY_www.toadli.com3817a7ba6851c5f918ecefe5942cdfbc
loadtime:0.25048089027405 / seconds
Query Executed:select id FROM `nh` where city='Henniker' && SIC_code='7219'DB:business_master_new
loadtime:0.25165486335754 / seconds
Query Executed:select * from geodata_geocity where city='Hill' limit 1DB:business_master_new
loadtime:0.25247693061829 / seconds
Query stored in cache : _QUERY_www.toadli.comffa322598b26c13c67d10a9c05ac4274
loadtime:0.25322103500366 / seconds
Query Executed:select id FROM `nh` where city='Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.25421690940857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:0.25426602363586 / seconds
Query Executed:select id FROM `nh` where city='Hillsboro' && SIC_code='7219'DB:business_master_new
loadtime:0.25525999069214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:0.25539302825928 / seconds
Query Executed:select id FROM `nh` where city='Hillsborough' && SIC_code='7219'DB:business_master_new
loadtime:0.25660085678101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinsdale' limit 1
loadtime:0.25672698020935 / seconds
Query Executed:select id FROM `nh` where city='Hinsdale' && SIC_code='7219'DB:business_master_new
loadtime:0.25786304473877 / seconds
Query Executed:select * from geodata_geocity where city='Holderness' limit 1DB:business_master_new
loadtime:0.25821590423584 / seconds
Query stored in cache : _QUERY_www.toadli.comc6cd820cf94afcc5ef9148acb9c4080c
loadtime:0.25825095176697 / seconds
Query Executed:select id FROM `nh` where city='Holderness' && SIC_code='7219'DB:business_master_new
loadtime:0.25915002822876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollis' limit 1
loadtime:0.25927090644836 / seconds
Query Executed:select id FROM `nh` where city='Hollis' && SIC_code='7219'DB:business_master_new
loadtime:0.26032400131226 / seconds
Query Executed:select * from geodata_geocity where city='Hooksett' limit 1DB:business_master_new
loadtime:0.26110196113586 / seconds
Query stored in cache : _QUERY_www.toadli.comd2ef7c22b1680acdd4ac9af4fe303a0a
loadtime:0.26122093200684 / seconds
Query Executed:select id FROM `nh` where city='Hooksett' && SIC_code='7219'DB:business_master_new
loadtime:0.26206398010254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hopkinton' limit 1
loadtime:0.26212286949158 / seconds
Query Executed:select id FROM `nh` where city='Hopkinton' && SIC_code='7219'DB:business_master_new
loadtime:0.26675891876221 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:0.26681208610535 / seconds
Query Executed:select id FROM `nh` where city='Hudson' && SIC_code='7219'DB:business_master_new
loadtime:0.26726388931274 / seconds
Query Executed:select * from geodata_geocity where city='Intervale' limit 1DB:business_master_new
loadtime:0.26757097244263 / seconds
Query stored in cache : _QUERY_www.toadli.com2b77b876ac74f9ef0d904682ae7aa1ad
loadtime:0.26760697364807 / seconds
Query Executed:select id FROM `nh` where city='Intervale' && SIC_code='7219'DB:business_master_new
loadtime:0.2680389881134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:0.26808595657349 / seconds
Query Executed:select id FROM `nh` where city='Jackson' && SIC_code='7219'DB:business_master_new
loadtime:0.26849699020386 / seconds
Query Executed:select * from geodata_geocity where city='Jaffrey' limit 1DB:business_master_new
loadtime:0.26878190040588 / seconds
Query stored in cache : _QUERY_www.toadli.com2303d219533fd1fe2d6185fbfc702fc8
loadtime:0.26882791519165 / seconds
Query Executed:select id FROM `nh` where city='Jaffrey' && SIC_code='7219'DB:business_master_new
loadtime:0.26925587654114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:0.26930093765259 / seconds
Query Executed:select id FROM `nh` where city='Jefferson' && SIC_code='7219'DB:business_master_new
loadtime:0.26970601081848 / seconds
Query Executed:select * from geodata_geocity where city='Kearsarge' limit 1DB:business_master_new
loadtime:0.26999998092651 / seconds
Query stored in cache : _QUERY_www.toadli.comb14fcb040a5a0a417706c25300953978
loadtime:0.27004098892212 / seconds
Query Executed:select id FROM `nh` where city='Kearsarge' && SIC_code='7219'DB:business_master_new
loadtime:0.2736439704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keene' limit 1
loadtime:0.27369499206543 / seconds
Query Executed:select id FROM `nh` where city='Keene' && SIC_code='7219'DB:business_master_new
loadtime:0.27414608001709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kensington' limit 1
loadtime:0.27420091629028 / seconds
Query Executed:select id FROM `nh` where city='Kensington' && SIC_code='7219'DB:business_master_new
loadtime:0.27470707893372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.27474594116211 / seconds
Query Executed:select id FROM `nh` where city='Kingston' && SIC_code='7219'DB:business_master_new
loadtime:0.2756929397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laconia' limit 1
loadtime:0.27583503723145 / seconds
Query Executed:select id FROM `nh` where city='Laconia' && SIC_code='7219'DB:business_master_new
loadtime:0.27658295631409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lancaster' limit 1
loadtime:0.27663707733154 / seconds
Query Executed:select id FROM `nh` where city='Lancaster' && SIC_code='7219'DB:business_master_new
loadtime:0.27724099159241 / seconds
Query Executed:select * from geodata_geocity where city='Landaff' limit 1DB:business_master_new
loadtime:0.2781240940094 / seconds
Query stored in cache : _QUERY_www.toadli.com0e96dd6c410641b16b0a094614e0536b
loadtime:0.27818202972412 / seconds
Query Executed:select id FROM `nh` where city='Landaff' && SIC_code='7219'DB:business_master_new
loadtime:0.27861905097961 / seconds
Query Executed:select * from geodata_geocity where city='Langdon' limit 1DB:business_master_new
loadtime:0.2793710231781 / seconds
Query stored in cache : _QUERY_www.toadli.combd0e5b89eb0931a23ed641962ba3dbf1
loadtime:0.27950000762939 / seconds
Query Executed:select id FROM `nh` where city='Langdon' && SIC_code='7219'DB:business_master_new
loadtime:0.2821900844574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.28223896026611 / seconds
Query Executed:select id FROM `nh` where city='Lebanon' && SIC_code='7219'DB:business_master_new
loadtime:0.28266596794128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lee' limit 1
loadtime:0.28270697593689 / seconds
Query Executed:select id FROM `nh` where city='Lee' && SIC_code='7219'DB:business_master_new
loadtime:0.28312706947327 / seconds
Query Executed:select * from geodata_geocity where city='Lempster' limit 1DB:business_master_new
loadtime:0.28339600563049 / seconds
Query stored in cache : _QUERY_www.toadli.com053ee0781f2c3e05c81396098e62b0dd
loadtime:0.28342890739441 / seconds
Query Executed:select id FROM `nh` where city='Lempster' && SIC_code='7219'DB:business_master_new
loadtime:0.2838659286499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:0.2839150428772 / seconds
Query Executed:select id FROM `nh` where city='Lincoln' && SIC_code='7219'DB:business_master_new
loadtime:0.28433609008789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisbon' limit 1
loadtime:0.28438401222229 / seconds
Query Executed:select id FROM `nh` where city='Lisbon' && SIC_code='7219'DB:business_master_new
loadtime:0.28478693962097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.28483295440674 / seconds
Query Executed:select id FROM `nh` where city='Litchfield' && SIC_code='7219'DB:business_master_new
loadtime:0.28523993492126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:0.28528594970703 / seconds
Query Executed:select id FROM `nh` where city='Littleton' && SIC_code='7219'DB:business_master_new
loadtime:0.28568601608276 / seconds
Query Executed:select * from geodata_geocity where city='Lochmere' limit 1DB:business_master_new
loadtime:0.28596091270447 / seconds
Query stored in cache : _QUERY_www.toadli.com8800f595e4cae0fbd285952088a8b2f2
loadtime:0.28600096702576 / seconds
Query Executed:select id FROM `nh` where city='Lochmere' && SIC_code='7219'DB:business_master_new
loadtime:0.28961086273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Londonderry' limit 1
loadtime:0.28975796699524 / seconds
Query Executed:select id FROM `nh` where city='Londonderry' && SIC_code='7219'DB:business_master_new
loadtime:0.29061889648438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loudon' limit 1
loadtime:0.29077506065369 / seconds
Query Executed:select id FROM `nh` where city='Loudon' && SIC_code='7219'DB:business_master_new
loadtime:0.29189395904541 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.29202699661255 / seconds
Query Executed:select id FROM `nh` where city='Lyman' && SIC_code='7219'DB:business_master_new
loadtime:0.29272389411926 / seconds
Query Executed:select * from geodata_geocity where city='Lyme' limit 1DB:business_master_new
loadtime:0.29352593421936 / seconds
Query stored in cache : _QUERY_www.toadli.coma6f6ae6c7fed5ff991f4ad1a3f5a8c13
loadtime:0.29369592666626 / seconds
Query Executed:select id FROM `nh` where city='Lyme' && SIC_code='7219'DB:business_master_new
loadtime:0.29484105110168 / seconds
Query Executed:select * from geodata_geocity where city='Lyme Center' limit 1DB:business_master_new
loadtime:0.29569792747498 / seconds
Query stored in cache : _QUERY_www.toadli.com1f7863d376fe68aebee6c3dc4d0d702f
loadtime:0.29641103744507 / seconds
Query Executed:select id FROM `nh` where city='Lyme Center' && SIC_code='7219'DB:business_master_new
loadtime:0.299320936203 / seconds
Query Executed:select * from geodata_geocity where city='Lyndeborough' limit 1DB:business_master_new
loadtime:0.29993200302124 / seconds
Query stored in cache : _QUERY_www.toadli.comcf444f6323442ce87416f0803e0d39bc
loadtime:0.30002403259277 / seconds
Query Executed:select id FROM `nh` where city='Lyndeborough' && SIC_code='7219'DB:business_master_new
loadtime:0.30124497413635 / seconds
Query Executed:select * from geodata_geocity where city='Madbury' limit 1DB:business_master_new
loadtime:0.30217504501343 / seconds
Query stored in cache : _QUERY_www.toadli.comffe908ea666c1fcb2336331ef615229d
loadtime:0.30222392082214 / seconds
Query Executed:select id FROM `nh` where city='Madbury' && SIC_code='7219'DB:business_master_new
loadtime:0.30301308631897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.30310893058777 / seconds
Query Executed:select id FROM `nh` where city='Madison' && SIC_code='7219'DB:business_master_new
loadtime:0.30382895469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.30390691757202 / seconds
Query Executed:select id FROM `nh` where city='Manchester' && SIC_code='7219'DB:business_master_new
loadtime:0.30465698242188 / seconds
Query Executed:select * from geodata_geocity where city='Marlborough' limit 1DB:business_master_new
loadtime:0.30552005767822 / seconds
Query stored in cache : _QUERY_www.toadli.comcc75f75d854c3e68f32b1a40c223efa4
loadtime:0.30565905570984 / seconds
Query Executed:select id FROM `nh` where city='Marlborough' && SIC_code='7219'DB:business_master_new
loadtime:0.30681395530701 / seconds
Query Executed:select * from geodata_geocity where city='Marlow' limit 1DB:business_master_new
loadtime:0.30761909484863 / seconds
Query stored in cache : _QUERY_www.toadli.com5f1053582cf59c6e037f9665357bb3fb
loadtime:0.3077609539032 / seconds
Query Executed:select id FROM `nh` where city='Marlow' && SIC_code='7219'DB:business_master_new
loadtime:0.30869102478027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mason' limit 1
loadtime:0.30882287025452 / seconds
Query Executed:select id FROM `nh` where city='Mason' && SIC_code='7219'DB:business_master_new
loadtime:0.31169390678406 / seconds
Query Executed:select * from geodata_geocity where city='Meadows' limit 1DB:business_master_new
loadtime:0.31199502944946 / seconds
Query stored in cache : _QUERY_www.toadli.com8d4c5ab47f8341dcd46df9967aaa1715
loadtime:0.31203603744507 / seconds
Query Executed:select id FROM `nh` where city='Meadows' && SIC_code='7219'DB:business_master_new
loadtime:0.31227588653564 / seconds
Query Executed:select * from geodata_geocity where city='Melvin Village' limit 1DB:business_master_new
loadtime:0.31255292892456 / seconds
Query stored in cache : _QUERY_www.toadli.comde158bd4d36665136103d1a93cc5335f
loadtime:0.31258201599121 / seconds
Query Executed:select id FROM `nh` where city='Melvin Village' && SIC_code='7219'DB:business_master_new
loadtime:0.313148021698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meredith' limit 1
loadtime:0.31327390670776 / seconds
Query Executed:select id FROM `nh` where city='Meredith' && SIC_code='7219'DB:business_master_new
loadtime:0.31419706344604 / seconds
Query Executed:select * from geodata_geocity where city='Meriden' limit 1DB:business_master_new
loadtime:0.31511187553406 / seconds
Query stored in cache : _QUERY_www.toadli.comad6f85cfb976f5fdaa21e8b2b555063f
loadtime:0.31524705886841 / seconds
Query Executed:select id FROM `nh` where city='Meriden' && SIC_code='7219'DB:business_master_new
loadtime:0.31596398353577 / seconds
Query Executed:select * from geodata_geocity where city='Merrimack' limit 1DB:business_master_new
loadtime:0.31681895256042 / seconds
Query stored in cache : _QUERY_www.toadli.coma1b89b84e132ddbf8f26d3189a4d2c08
loadtime:0.31692385673523 / seconds
Query Executed:select id FROM `nh` where city='Merrimack' && SIC_code='7219'DB:business_master_new
loadtime:0.31781005859375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleton' limit 1
loadtime:0.31791687011719 / seconds
Query Executed:select id FROM `nh` where city='Middleton' && SIC_code='7219'DB:business_master_new
loadtime:0.32028198242188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milan' limit 1
loadtime:0.32033395767212 / seconds
Query Executed:select id FROM `nh` where city='Milan' && SIC_code='7219'DB:business_master_new
loadtime:0.32077503204346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.32080101966858 / seconds
Query Executed:select id FROM `nh` where city='Milford' && SIC_code='7219'DB:business_master_new
loadtime:0.32122397422791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:0.32127094268799 / seconds
Query Executed:select id FROM `nh` where city='Milton' && SIC_code='7219'DB:business_master_new
loadtime:0.3216769695282 / seconds
Query Executed:select * from geodata_geocity where city='Milton Mills' limit 1DB:business_master_new
loadtime:0.32214689254761 / seconds
Query stored in cache : _QUERY_www.toadli.com695c88a384cc2dd6a0e073af0b4159ed
loadtime:0.32228899002075 / seconds
Query Executed:select id FROM `nh` where city='Milton Mills' && SIC_code='7219'DB:business_master_new
loadtime:0.32849287986755 / seconds
Query Executed:select * from geodata_geocity where city='Mirror Lake' limit 1DB:business_master_new
loadtime:0.32944297790527 / seconds
Query stored in cache : _QUERY_www.toadli.comb5741b7b8dc9dac2a5a5fe4dd8d0e301
loadtime:0.32989001274109 / seconds
Query Executed:select id FROM `nh` where city='Mirror Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.33070993423462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.33085298538208 / seconds
Query Executed:select id FROM `nh` where city='Monroe' && SIC_code='7219'DB:business_master_new
loadtime:0.33163690567017 / seconds
Query Executed:select * from geodata_geocity where city='Mont Vernon' limit 1DB:business_master_new
loadtime:0.33246898651123 / seconds
Query stored in cache : _QUERY_www.toadli.comf256e4b1012443f27eacca4eb7041e08
loadtime:0.33263802528381 / seconds
Query Executed:select id FROM `nh` where city='Mont Vernon' && SIC_code='7219'DB:business_master_new
loadtime:0.33350205421448 / seconds
Query Executed:select * from geodata_geocity where city='Moultonborough' limit 1DB:business_master_new
loadtime:0.3343710899353 / seconds
Query stored in cache : _QUERY_www.toadli.comac828464a15b9ea8c2a147c037b27cc4
loadtime:0.33441686630249 / seconds
Query Executed:select id FROM `nh` where city='Moultonborough' && SIC_code='7219'DB:business_master_new
loadtime:0.33541798591614 / seconds
Query Executed:select * from geodata_geocity where city='Mt Sunapee' limit 1DB:business_master_new
loadtime:0.3360230922699 / seconds
Query stored in cache : _QUERY_www.toadli.com19c831ad0f59f48cd4cd6c3d4597e91a
loadtime:0.33613801002502 / seconds
Query Executed:select id FROM `nh` where city='Mt Sunapee' && SIC_code='7219'DB:business_master_new
loadtime:0.33746290206909 / seconds
Query Executed:select * from geodata_geocity where city='Munsonville' limit 1DB:business_master_new
loadtime:0.33805990219116 / seconds
Query stored in cache : _QUERY_www.toadli.com8f0253986579c6baa23a726ed94261c2
loadtime:0.33833599090576 / seconds
Query Executed:select id FROM `nh` where city='Munsonville' && SIC_code='7219'DB:business_master_new
loadtime:0.34148001670837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashua' limit 1
loadtime:0.34153199195862 / seconds
Query Executed:select id FROM `nh` where city='Nashua' && SIC_code='7219'DB:business_master_new
loadtime:0.34220409393311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nelson' limit 1
loadtime:0.34226393699646 / seconds
Query Executed:select id FROM `nh` where city='Nelson' && SIC_code='7219'DB:business_master_new
loadtime:0.34813404083252 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Boston' limit 1
loadtime:0.34826803207397 / seconds
Query Executed:select id FROM `nh` where city='New Boston' && SIC_code='7219'DB:business_master_new
loadtime:0.34918808937073 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Castle' limit 1
loadtime:0.34928894042969 / seconds
Query Executed:select id FROM `nh` where city='New Castle' && SIC_code='7219'DB:business_master_new
loadtime:0.35016489028931 / seconds
Query Executed:select * from geodata_geocity where city='New Durham' limit 1DB:business_master_new
loadtime:0.35061287879944 / seconds
Query stored in cache : _QUERY_www.toadli.com98fc948bba4dfa8eaba5387972a038ae
loadtime:0.35070204734802 / seconds
Query Executed:select id FROM `nh` where city='New Durham' && SIC_code='7219'DB:business_master_new
loadtime:0.35169100761414 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hampton' limit 1
loadtime:0.3517279624939 / seconds
Query Executed:select id FROM `nh` where city='New Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.35268592834473 / seconds
Query Executed:select * from geodata_geocity where city='New Ipswich' limit 1DB:business_master_new
loadtime:0.35331702232361 / seconds
Query stored in cache : _QUERY_www.toadli.comcf155a6fdbe670588d78301a3a0de915
loadtime:0.35335302352905 / seconds
Query Executed:select id FROM `nh` where city='New Ipswich' && SIC_code='7219'DB:business_master_new
loadtime:0.3543598651886 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.3544750213623 / seconds
Query Executed:select id FROM `nh` where city='New London' && SIC_code='7219'DB:business_master_new
loadtime:0.35529494285583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbury' limit 1
loadtime:0.35540008544922 / seconds
Query Executed:select id FROM `nh` where city='Newbury' && SIC_code='7219'DB:business_master_new
loadtime:0.3564670085907 / seconds
Query Executed:select * from geodata_geocity where city='Newfields' limit 1DB:business_master_new
loadtime:0.35689187049866 / seconds
Query stored in cache : _QUERY_www.toadli.com6c1bec5da81cc5b5699e0dde73b99f74
loadtime:0.35698103904724 / seconds
Query Executed:select id FROM `nh` where city='Newfields' && SIC_code='7219'DB:business_master_new
loadtime:0.3580539226532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.35810089111328 / seconds
Query Executed:select id FROM `nh` where city='Newington' && SIC_code='7219'DB:business_master_new
loadtime:0.36155486106873 / seconds
Query Executed:select * from geodata_geocity where city='Newmarket' limit 1DB:business_master_new
loadtime:0.36184000968933 / seconds
Query stored in cache : _QUERY_www.toadli.comb70c71b1fb20165e3fab14ce6a72e648
loadtime:0.36187601089478 / seconds
Query Executed:select id FROM `nh` where city='Newmarket' && SIC_code='7219'DB:business_master_new
loadtime:0.36228704452515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:0.36232304573059 / seconds
Query Executed:select id FROM `nh` where city='Newport' && SIC_code='7219'DB:business_master_new
loadtime:0.36272788047791 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.36276507377625 / seconds
Query Executed:select id FROM `nh` where city='Newton' && SIC_code='7219'DB:business_master_new
loadtime:0.3631579875946 / seconds
Query Executed:select * from geodata_geocity where city='Newton Junction' limit 1DB:business_master_new
loadtime:0.36342692375183 / seconds
Query stored in cache : _QUERY_www.toadli.come61040a2585b5a39acee38a4c4110de8
loadtime:0.36345601081848 / seconds
Query Executed:select id FROM `nh` where city='Newton Junction' && SIC_code='7219'DB:business_master_new
loadtime:0.36844301223755 / seconds
Query Executed:select * from geodata_geocity where city='North Conway' limit 1DB:business_master_new
loadtime:0.36874604225159 / seconds
Query stored in cache : _QUERY_www.toadli.com7cf362cea5bf5937d78ae8432bed87c3
loadtime:0.36878705024719 / seconds
Query Executed:select id FROM `nh` where city='North Conway' && SIC_code='7219'DB:business_master_new
loadtime:0.3691930770874 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Hampton' limit 1
loadtime:0.36922788619995 / seconds
Query Executed:select id FROM `nh` where city='North Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.36963105201721 / seconds
Query Executed:select * from geodata_geocity where city='North Haverhill' limit 1DB:business_master_new
loadtime:0.36987805366516 / seconds
Query stored in cache : _QUERY_www.toadli.com9ccc17314a7f4a13c180aba60ccedbcf
loadtime:0.36991405487061 / seconds
Query Executed:select id FROM `nh` where city='North Haverhill' && SIC_code='7219'DB:business_master_new
loadtime:0.3703179359436 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salem' limit 1
loadtime:0.3703510761261 / seconds
Query Executed:select id FROM `nh` where city='North Salem' && SIC_code='7219'DB:business_master_new
loadtime:0.37069988250732 / seconds
Query Executed:select * from geodata_geocity where city='North Sandwich' limit 1DB:business_master_new
loadtime:0.37093997001648 / seconds
Query stored in cache : _QUERY_www.toadli.com2e9c3313be950b92325f6d95e75682e0
loadtime:0.3709659576416 / seconds
Query Executed:select id FROM `nh` where city='North Sandwich' && SIC_code='7219'DB:business_master_new
loadtime:0.37126302719116 / seconds
Query Executed:select * from geodata_geocity where city='North Stratford' limit 1DB:business_master_new
loadtime:0.37152194976807 / seconds
Query stored in cache : _QUERY_www.toadli.com166042a80ec5c0d89d97194e0eb7af70
loadtime:0.37157106399536 / seconds
Query Executed:select id FROM `nh` where city='North Stratford' && SIC_code='7219'DB:business_master_new
loadtime:0.37195992469788 / seconds
Query Executed:select * from geodata_geocity where city='North Sutton' limit 1DB:business_master_new
loadtime:0.37221097946167 / seconds
Query stored in cache : _QUERY_www.toadli.com7b33027a62f25dcbe13e8c5cd1ffc0fc
loadtime:0.37224292755127 / seconds
Query Executed:select id FROM `nh` where city='North Sutton' && SIC_code='7219'DB:business_master_new
loadtime:0.37264609336853 / seconds
Query Executed:select * from geodata_geocity where city='North Walpole' limit 1DB:business_master_new
loadtime:0.37289905548096 / seconds
Query stored in cache : _QUERY_www.toadli.comdea9ef855cfb5c10e6c9de326410cd6e
loadtime:0.37293386459351 / seconds
Query Executed:select id FROM `nh` where city='North Walpole' && SIC_code='7219'DB:business_master_new
loadtime:0.37326407432556 / seconds
Query Executed:select * from geodata_geocity where city='North Woodstock' limit 1DB:business_master_new
loadtime:0.37352108955383 / seconds
Query stored in cache : _QUERY_www.toadli.combe33c85e1efa5c57e823583de50296fc
loadtime:0.37355804443359 / seconds
Query Executed:select id FROM `nh` where city='North Woodstock' && SIC_code='7219'DB:business_master_new
loadtime:0.37394189834595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.3739800453186 / seconds
Query Executed:select id FROM `nh` where city='Northfield' && SIC_code='7219'DB:business_master_new
loadtime:0.37510299682617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northwood' limit 1
loadtime:0.37513995170593 / seconds
Query Executed:select id FROM `nh` where city='Northwood' && SIC_code='7219'DB:business_master_new
loadtime:0.37552309036255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nottingham' limit 1
loadtime:0.37556600570679 / seconds
Query Executed:select id FROM `nh` where city='Nottingham' && SIC_code='7219'DB:business_master_new
loadtime:0.37594795227051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.37597894668579 / seconds
Query Executed:select id FROM `nh` where city='Orange' && SIC_code='7219'DB:business_master_new
loadtime:0.37620687484741 / seconds
Query Executed:select * from geodata_geocity where city='Orford' limit 1DB:business_master_new
loadtime:0.37689590454102 / seconds
Query stored in cache : _QUERY_www.toadli.coma4e135c1aec999045a8a58c57e3ceb14
loadtime:0.37693285942078 / seconds
Query Executed:select id FROM `nh` where city='Orford' && SIC_code='7219'DB:business_master_new
loadtime:0.37731599807739 / seconds
Query Executed:select * from geodata_geocity where city='Ossipee' limit 1DB:business_master_new
loadtime:0.37757706642151 / seconds
Query stored in cache : _QUERY_www.toadli.comd1973fcdbfea8b4c6cb7418e4ada0600
loadtime:0.37760806083679 / seconds
Query Executed:select id FROM `nh` where city='Ossipee' && SIC_code='7219'DB:business_master_new
loadtime:0.37798690795898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:0.37802290916443 / seconds
Query Executed:select id FROM `nh` where city='Pelham' && SIC_code='7219'DB:business_master_new
loadtime:0.37841200828552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:0.37844300270081 / seconds
Query Executed:select id FROM `nh` where city='Pembroke' && SIC_code='7219'DB:business_master_new
loadtime:0.38201498985291 / seconds
Query Executed:select * from geodata_geocity where city='Penacook' limit 1DB:business_master_new
loadtime:0.38231301307678 / seconds
Query stored in cache : _QUERY_www.toadli.com5bccfd513cebb7b7ebf0b151acff6cef
loadtime:0.38238000869751 / seconds
Query Executed:select id FROM `nh` where city='Penacook' && SIC_code='7219'DB:business_master_new
loadtime:0.38343596458435 / seconds
Query Executed:select * from geodata_geocity where city='Peterborough' limit 1DB:business_master_new
loadtime:0.38373398780823 / seconds
Query stored in cache : _QUERY_www.toadli.com051d971f08c995949e24011c88696884
loadtime:0.38377690315247 / seconds
Query Executed:select id FROM `nh` where city='Peterborough' && SIC_code='7219'DB:business_master_new
loadtime:0.38417792320251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piermont' limit 1
loadtime:0.38421201705933 / seconds
Query Executed:select id FROM `nh` where city='Piermont' && SIC_code='7219'DB:business_master_new
loadtime:0.3845489025116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike' limit 1
loadtime:0.38458299636841 / seconds
Query Executed:select id FROM `nh` where city='Pike' && SIC_code='7219'DB:business_master_new
loadtime:0.38970899581909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsburg' limit 1
loadtime:0.38974499702454 / seconds
Query Executed:select id FROM `nh` where city='Pittsburg' && SIC_code='7219'DB:business_master_new
loadtime:0.39014005661011 / seconds
Query Executed:select * from geodata_geocity where city='Pittsfield' limit 1DB:business_master_new
loadtime:0.39044904708862 / seconds
Query stored in cache : _QUERY_www.toadli.com1e3706145a19aa1ddbcf97c79c14572c
loadtime:0.39048409461975 / seconds
Query Executed:select id FROM `nh` where city='Pittsfield' && SIC_code='7219'DB:business_master_new
loadtime:0.39089488983154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.39092993736267 / seconds
Query Executed:select id FROM `nh` where city='Plainfield' && SIC_code='7219'DB:business_master_new
loadtime:0.39131689071655 / seconds
Query Executed:select * from geodata_geocity where city='Plaistow' limit 1DB:business_master_new
loadtime:0.39157891273499 / seconds
Query stored in cache : _QUERY_www.toadli.com684b8b15f8a95d1a3bf9457485f18c19
loadtime:0.39161801338196 / seconds
Query Executed:select id FROM `nh` where city='Plaistow' && SIC_code='7219'DB:business_master_new
loadtime:0.39201188087463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.39204406738281 / seconds
Query Executed:select id FROM `nh` where city='Plymouth' && SIC_code='7219'DB:business_master_new
loadtime:0.39243507385254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portsmouth' limit 1
loadtime:0.3924720287323 / seconds
Query Executed:select id FROM `nh` where city='Portsmouth' && SIC_code='7219'DB:business_master_new
loadtime:0.39287185668945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.39291286468506 / seconds
Query Executed:select id FROM `nh` where city='Randolph' && SIC_code='7219'DB:business_master_new
loadtime:0.3948130607605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raymond' limit 1
loadtime:0.39484786987305 / seconds
Query Executed:select id FROM `nh` where city='Raymond' && SIC_code='7219'DB:business_master_new
loadtime:0.39522290229797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.39525389671326 / seconds
Query Executed:select id FROM `nh` where city='Richmond' && SIC_code='7219'DB:business_master_new
loadtime:0.39631986618042 / seconds
Query Executed:select * from geodata_geocity where city='Rindge' limit 1DB:business_master_new
loadtime:0.39661002159119 / seconds
Query stored in cache : _QUERY_www.toadli.com6884a770217ce376b6515ce3c873e7e0
loadtime:0.39664101600647 / seconds
Query Executed:select id FROM `nh` where city='Rindge' && SIC_code='7219'DB:business_master_new
loadtime:0.39702391624451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rochester' limit 1
loadtime:0.39706087112427 / seconds
Query Executed:select id FROM `nh` where city='Rochester' && SIC_code='7219'DB:business_master_new
loadtime:0.39744806289673 / seconds
Query Executed:select * from geodata_geocity where city='Rollinsford' limit 1DB:business_master_new
loadtime:0.39771103858948 / seconds
Query stored in cache : _QUERY_www.toadli.comb7e1383040c999c5a6540f74a3a2baa7
loadtime:0.39775109291077 / seconds
Query Executed:select id FROM `nh` where city='Rollinsford' && SIC_code='7219'DB:business_master_new
loadtime:0.39814805984497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.39818096160889 / seconds
Query Executed:select id FROM `nh` where city='Roxbury' && SIC_code='7219'DB:business_master_new
loadtime:0.39839887619019 / seconds
Query Executed:select * from geodata_geocity where city='Rumney' limit 1DB:business_master_new
loadtime:0.3986759185791 / seconds
Query stored in cache : _QUERY_www.toadli.comb6f846e3f37b6431adf5e7cfcac81202
loadtime:0.3987078666687 / seconds
Query Executed:select id FROM `nh` where city='Rumney' && SIC_code='7219'DB:business_master_new
loadtime:0.39907693862915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rye' limit 1
loadtime:0.39911198616028 / seconds
Query Executed:select id FROM `nh` where city='Rye' && SIC_code='7219'DB:business_master_new
loadtime:0.39948701858521 / seconds
Query Executed:select * from geodata_geocity where city='Rye Beach' limit 1DB:business_master_new
loadtime:0.39976596832275 / seconds
Query stored in cache : _QUERY_www.toadli.com9b025f7340b503261b480857b778e071
loadtime:0.39980602264404 / seconds
Query Executed:select id FROM `nh` where city='Rye Beach' && SIC_code='7219'DB:business_master_new
loadtime:0.40018892288208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.40021991729736 / seconds
Query Executed:select id FROM `nh` where city='Salem' && SIC_code='7219'DB:business_master_new
loadtime:0.40061807632446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.40065908432007 / seconds
Query Executed:select id FROM `nh` where city='Salisbury' && SIC_code='7219'DB:business_master_new
loadtime:0.40103602409363 / seconds
Query Executed:select * from geodata_geocity where city='Sanbornton' limit 1DB:business_master_new
loadtime:0.40133094787598 / seconds
Query stored in cache : _QUERY_www.toadli.comf892c8d8902b8477470c7c3dc3c4adc2
loadtime:0.40136098861694 / seconds
Query Executed:select id FROM `nh` where city='Sanbornton' && SIC_code='7219'DB:business_master_new
loadtime:0.4017539024353 / seconds
Query Executed:select * from geodata_geocity where city='Sanbornville' limit 1DB:business_master_new
loadtime:0.4020459651947 / seconds
Query stored in cache : _QUERY_www.toadli.com894e0926bbf17ed609cfbabb2a0e716c
loadtime:0.40207886695862 / seconds
Query Executed:select id FROM `nh` where city='Sanbornville' && SIC_code='7219'DB:business_master_new
loadtime:0.40247893333435 / seconds
Query Executed:select * from geodata_geocity where city='Sandown' limit 1DB:business_master_new
loadtime:0.40274405479431 / seconds
Query stored in cache : _QUERY_www.toadli.com246fe894227f3a0834d92e8787f9d5de
loadtime:0.40277886390686 / seconds
Query Executed:select id FROM `nh` where city='Sandown' && SIC_code='7219'DB:business_master_new
loadtime:0.4031720161438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seabrook' limit 1
loadtime:0.40321397781372 / seconds
Query Executed:select id FROM `nh` where city='Seabrook' && SIC_code='7219'DB:business_master_new
loadtime:0.40360808372498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.40363192558289 / seconds
Query Executed:select id FROM `nh` where city='Sharon' && SIC_code='7219'DB:business_master_new
loadtime:0.40447998046875 / seconds
Query Executed:select * from geodata_geocity where city='Shelburne' limit 1DB:business_master_new
loadtime:0.40475988388062 / seconds
Query stored in cache : _QUERY_www.toadli.com60cc4a906ac2dcca01273fd98efeab75
loadtime:0.40478706359863 / seconds
Query Executed:select id FROM `nh` where city='Shelburne' && SIC_code='7219'DB:business_master_new
loadtime:0.4056499004364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silver Lake' limit 1
loadtime:0.40569686889648 / seconds
Query Executed:select id FROM `nh` where city='Silver Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.4060389995575 / seconds
Query Executed:select * from geodata_geocity where city='Somersworth' limit 1DB:business_master_new
loadtime:0.40633392333984 / seconds
Query stored in cache : _QUERY_www.toadli.comca1516d43984e717a8c9159869c0c689
loadtime:0.40637707710266 / seconds
Query Executed:select id FROM `nh` where city='Somersworth' && SIC_code='7219'DB:business_master_new
loadtime:0.40690588951111 / seconds
Query Executed:select * from geodata_geocity where city='South Acworth' limit 1DB:business_master_new
loadtime:0.40729999542236 / seconds
Query stored in cache : _QUERY_www.toadli.comdd79336f1449c8d125800d41f01f2c04
loadtime:0.40740394592285 / seconds
Query Executed:select id FROM `nh` where city='South Acworth' && SIC_code='7219'DB:business_master_new
loadtime:0.41092205047607 / seconds
Query Executed:select * from geodata_geocity where city='South Effingham' limit 1DB:business_master_new
loadtime:0.41227793693542 / seconds
Query stored in cache : _QUERY_www.toadli.com4243bb5cc0963a234f6285cf7ce4f811
loadtime:0.4124059677124 / seconds
Query Executed:select id FROM `nh` where city='South Effingham' && SIC_code='7219'DB:business_master_new
loadtime:0.41309189796448 / seconds
Query Executed:select * from geodata_geocity where city='South Hampton' limit 1DB:business_master_new
loadtime:0.4138720035553 / seconds
Query stored in cache : _QUERY_www.toadli.comf3abe4c83ddf1e1994686cc691723ce1
loadtime:0.41397786140442 / seconds
Query Executed:select id FROM `nh` where city='South Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.41499090194702 / seconds
Query Executed:select * from geodata_geocity where city='South Newbury' limit 1DB:business_master_new
loadtime:0.4155170917511 / seconds
Query stored in cache : _QUERY_www.toadli.com7b1df2d448e650c47fff67b228528ee8
loadtime:0.41569805145264 / seconds
Query Executed:select id FROM `nh` where city='South Newbury' && SIC_code='7219'DB:business_master_new
loadtime:0.41888308525085 / seconds
Query Executed:select * from geodata_geocity where city='South Sutton' limit 1DB:business_master_new
loadtime:0.41967797279358 / seconds
Query stored in cache : _QUERY_www.toadli.com0ed6e143c5f8a6d302d6b4e2cc76df25
loadtime:0.4198100566864 / seconds
Query Executed:select id FROM `nh` where city='South Sutton' && SIC_code='7219'DB:business_master_new
loadtime:0.42073202133179 / seconds
Query Executed:select * from geodata_geocity where city='South Tamworth' limit 1DB:business_master_new
loadtime:0.42130494117737 / seconds
Query stored in cache : _QUERY_www.toadli.com50d9b7c1e977853e1a6de8b4a0bf4714
loadtime:0.42134189605713 / seconds
Query Executed:select id FROM `nh` where city='South Tamworth' && SIC_code='7219'DB:business_master_new
loadtime:0.42191386222839 / seconds
Query Executed:select * from geodata_geocity where city='Spofford' limit 1DB:business_master_new
loadtime:0.42240500450134 / seconds
Query stored in cache : _QUERY_www.toadli.comff7880609bc4049b5e1f51ec30d2a30e
loadtime:0.422523021698 / seconds
Query Executed:select id FROM `nh` where city='Spofford' && SIC_code='7219'DB:business_master_new
loadtime:0.4237048625946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springfield' limit 1
loadtime:0.42383193969727 / seconds
Query Executed:select id FROM `nh` where city='Springfield' && SIC_code='7219'DB:business_master_new
loadtime:0.42499089241028 / seconds
Query Executed:select * from geodata_geocity where city='Stark' limit 1DB:business_master_new
loadtime:0.42586898803711 / seconds
Query stored in cache : _QUERY_www.toadli.com211b13dbfb16d838ea39227bcaf26394
loadtime:0.4259729385376 / seconds
Query Executed:select id FROM `nh` where city='Stark' && SIC_code='7219'DB:business_master_new
loadtime:0.42635703086853 / seconds
Query Executed:select * from geodata_geocity where city='Stewartstown' limit 1DB:business_master_new
loadtime:0.42707395553589 / seconds
Query stored in cache : _QUERY_www.toadli.comc6eb85090c1178b5d60b81d77758e3f5
loadtime:0.42720890045166 / seconds
Query Executed:select id FROM `nh` where city='Stewartstown' && SIC_code='7219'DB:business_master_new
loadtime:0.42827796936035 / seconds
Query Executed:select * from geodata_geocity where city='Stinson Lake' limit 1DB:business_master_new
loadtime:0.42885208129883 / seconds
Query stored in cache : _QUERY_www.toadli.combe1440a2802782753234c21d4b843937
loadtime:0.42897605895996 / seconds
Query Executed:select id FROM `nh` where city='Stinson Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.42964196205139 / seconds
Query Executed:select * from geodata_geocity where city='Stoddard' limit 1DB:business_master_new
loadtime:0.43074107170105 / seconds
Query stored in cache : _QUERY_www.toadli.com073f84d16a55794751ad7feca98e361a
loadtime:0.43086886405945 / seconds
Query Executed:select id FROM `nh` where city='Stoddard' && SIC_code='7219'DB:business_master_new
loadtime:0.43213200569153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Strafford' limit 1
loadtime:0.43225693702698 / seconds
Query Executed:select id FROM `nh` where city='Strafford' && SIC_code='7219'DB:business_master_new
loadtime:0.4334659576416 / seconds
Query Executed:select * from geodata_geocity where city='Stratham' limit 1DB:business_master_new
loadtime:0.43424606323242 / seconds
Query stored in cache : _QUERY_www.toadli.com4bb4bf638cdd4a354cccd59b85cf2fbd
loadtime:0.43428993225098 / seconds
Query Executed:select id FROM `nh` where city='Stratham' && SIC_code='7219'DB:business_master_new
loadtime:0.43516206741333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Hill' limit 1
loadtime:0.43532395362854 / seconds
Query Executed:select id FROM `nh` where city='Sugar Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.4362850189209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sullivan' limit 1
loadtime:0.43642091751099 / seconds
Query Executed:select id FROM `nh` where city='Sullivan' && SIC_code='7219'DB:business_master_new
loadtime:0.43737697601318 / seconds
Query Executed:select * from geodata_geocity where city='Sunapee' limit 1DB:business_master_new
loadtime:0.43815493583679 / seconds
Query stored in cache : _QUERY_www.toadli.com207c4ea91bfad90d22d6672892b987b5
loadtime:0.43822503089905 / seconds
Query Executed:select id FROM `nh` where city='Sunapee' && SIC_code='7219'DB:business_master_new
loadtime:0.43907809257507 / seconds
Query Executed:select * from geodata_geocity where city='Suncook' limit 1DB:business_master_new
loadtime:0.43987488746643 / seconds
Query stored in cache : _QUERY_www.toadli.com7148de11aa35c8a3a40a63a67fe6bc59
loadtime:0.44000005722046 / seconds
Query Executed:select id FROM `nh` where city='Suncook' && SIC_code='7219'DB:business_master_new
loadtime:0.44124293327332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surry' limit 1
loadtime:0.4413628578186 / seconds
Query Executed:select id FROM `nh` where city='Surry' && SIC_code='7219'DB:business_master_new
loadtime:0.44415593147278 / seconds
Query Executed:select * from geodata_geocity where city='Swanzey' limit 1DB:business_master_new
loadtime:0.44505906105042 / seconds
Query stored in cache : _QUERY_www.toadli.com1d0e44bb54c3db4830a1dca0a4a37b48
loadtime:0.4451630115509 / seconds
Query Executed:select id FROM `nh` where city='Swanzey' && SIC_code='7219'DB:business_master_new
loadtime:0.44626998901367 / seconds
Query Executed:select * from geodata_geocity where city='Tamworth' limit 1DB:business_master_new
loadtime:0.44696092605591 / seconds
Query stored in cache : _QUERY_www.toadli.com87bc6166160fe454e18f987bb5078175
loadtime:0.44708895683289 / seconds
Query Executed:select id FROM `nh` where city='Tamworth' && SIC_code='7219'DB:business_master_new
loadtime:0.44827389717102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Temple' limit 1
loadtime:0.44838309288025 / seconds
Query Executed:select id FROM `nh` where city='Temple' && SIC_code='7219'DB:business_master_new
loadtime:0.44953107833862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thornton' limit 1
loadtime:0.44969391822815 / seconds
Query Executed:select id FROM `nh` where city='Thornton' && SIC_code='7219'DB:business_master_new
loadtime:0.45062708854675 / seconds
Query Executed:select * from geodata_geocity where city='Tilton' limit 1DB:business_master_new
loadtime:0.45142006874084 / seconds
Query stored in cache : _QUERY_www.toadli.com56757cf3633c6f94a1ebea6836b5c8d4
loadtime:0.45152306556702 / seconds
Query Executed:select id FROM `nh` where city='Tilton' && SIC_code='7219'DB:business_master_new
loadtime:0.4526629447937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:0.45280289649963 / seconds
Query Executed:select id FROM `nh` where city='Troy' && SIC_code='7219'DB:business_master_new
loadtime:0.45389699935913 / seconds
Query Executed:select * from geodata_geocity where city='Twin Mountain' limit 1DB:business_master_new
loadtime:0.45450091362 / seconds
Query stored in cache : _QUERY_www.toadli.comd53b2ea5d42bf82a41a53592f34ca613
loadtime:0.45469403266907 / seconds
Query Executed:select id FROM `nh` where city='Twin Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.45523500442505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union' limit 1
loadtime:0.45527696609497 / seconds
Query Executed:select id FROM `nh` where city='Union' && SIC_code='7219'DB:business_master_new
loadtime:0.45628309249878 / seconds
Query Executed:select * from geodata_geocity where city='W Chesterfield' limit 1DB:business_master_new
loadtime:0.45669507980347 / seconds
Query stored in cache : _QUERY_www.toadli.comb2347d866d45bc3f1e8692714abe8bfb
loadtime:0.45676207542419 / seconds
Query Executed:select id FROM `nh` where city='W Chesterfield' && SIC_code='7219'DB:business_master_new
loadtime:0.46017408370972 / seconds
Query Executed:select * from geodata_geocity where city='W Peterborough' limit 1DB:business_master_new
loadtime:0.46046304702759 / seconds
Query stored in cache : _QUERY_www.toadli.com27c38f8aec0384f3fbcd981774d58095
loadtime:0.46050500869751 / seconds
Query Executed:select id FROM `nh` where city='W Peterborough' && SIC_code='7219'DB:business_master_new
loadtime:0.4607629776001 / seconds
Query Executed:select * from geodata_geocity where city='W Stewartstown' limit 1DB:business_master_new
loadtime:0.46102786064148 / seconds
Query stored in cache : _QUERY_www.toadli.comf4fb056d51fcb0eb0bdfa3bb88af6bc1
loadtime:0.46106290817261 / seconds
Query Executed:select id FROM `nh` where city='W Stewartstown' && SIC_code='7219'DB:business_master_new
loadtime:0.46139407157898 / seconds
Query Executed:select * from geodata_geocity where city='Walpole' limit 1DB:business_master_new
loadtime:0.46170902252197 / seconds
Query stored in cache : _QUERY_www.toadli.comdbe47b8b09b132f73abeed81904e2cf7
loadtime:0.46176695823669 / seconds
Query Executed:select id FROM `nh` where city='Walpole' && SIC_code='7219'DB:business_master_new
loadtime:0.46220803260803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warner' limit 1
loadtime:0.46225786209106 / seconds
Query Executed:select id FROM `nh` where city='Warner' && SIC_code='7219'DB:business_master_new
loadtime:0.4626669883728 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warren' limit 1
loadtime:0.46270489692688 / seconds
Query Executed:select id FROM `nh` where city='Warren' && SIC_code='7219'DB:business_master_new
loadtime:0.46310496330261 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.46315407752991 / seconds
Query Executed:select id FROM `nh` where city='Washington' && SIC_code='7219'DB:business_master_new
loadtime:0.46356987953186 / seconds
Query Executed:select * from geodata_geocity where city='Waterville Valley' limit 1DB:business_master_new
loadtime:0.46446990966797 / seconds
Query stored in cache : _QUERY_www.toadli.comcdcc7e1bdc82bc6e2a9730bb5a4d00f8
loadtime:0.46452188491821 / seconds
Query Executed:select id FROM `nh` where city='Waterville Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.46542406082153 / seconds
Query Executed:select * from geodata_geocity where city='Waterville Vly' limit 1DB:business_master_new
loadtime:0.46603608131409 / seconds
Query stored in cache : _QUERY_www.toadli.com8618c8f71ff45cc3f9645a7cde6784b0
loadtime:0.46607303619385 / seconds
Query Executed:select id FROM `nh` where city='Waterville Vly' && SIC_code='7219'DB:business_master_new
loadtime:0.46675801277161 / seconds
Query Executed:select * from geodata_geocity where city='Weare' limit 1DB:business_master_new
loadtime:0.467453956604 / seconds
Query stored in cache : _QUERY_www.toadli.com0f829217299ff08603dcc922a4f309ee
loadtime:0.46752500534058 / seconds
Query Executed:select id FROM `nh` where city='Weare' && SIC_code='7219'DB:business_master_new
loadtime:0.46828603744507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:0.46842002868652 / seconds
Query Executed:select id FROM `nh` where city='Webster' && SIC_code='7219'DB:business_master_new
loadtime:0.47052407264709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:0.47059798240662 / seconds
Query Executed:select id FROM `nh` where city='Wentworth' && SIC_code='7219'DB:business_master_new
loadtime:0.47102093696594 / seconds
Query Executed:select * from geodata_geocity where city='Wentworths Loctn' limit 1DB:business_master_new
loadtime:0.47129487991333 / seconds
Query stored in cache : _QUERY_www.toadli.comf2c29e3cebd2010331e0361fac2738b3
loadtime:0.4713339805603 / seconds
Query Executed:select id FROM `nh` where city='Wentworths Loctn' && SIC_code='7219'DB:business_master_new
loadtime:0.47156095504761 / seconds
Query Executed:select * from geodata_geocity where city='West Chesterfield' limit 1DB:business_master_new
loadtime:0.47182297706604 / seconds
Query stored in cache : _QUERY_www.toadli.com27381c8f624b06008273ccf253deb22a
loadtime:0.47185897827148 / seconds
Query Executed:select id FROM `nh` where city='West Chesterfield' && SIC_code='7219'DB:business_master_new
loadtime:0.47240996360779 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Lebanon' limit 1
loadtime:0.47250890731812 / seconds
Query Executed:select id FROM `nh` where city='West Lebanon' && SIC_code='7219'DB:business_master_new
loadtime:0.47347497940063 / seconds
Query Executed:select * from geodata_geocity where city='West Nottingham' limit 1DB:business_master_new
loadtime:0.47402191162109 / seconds
Query stored in cache : _QUERY_www.toadli.comc6449d62edb48bee4116cedefc117cb5
loadtime:0.47410607337952 / seconds
Query Executed:select id FROM `nh` where city='West Nottingham' && SIC_code='7219'DB:business_master_new
loadtime:0.47847104072571 / seconds
Query Executed:select * from geodata_geocity where city='West Ossipee' limit 1DB:business_master_new
loadtime:0.47912502288818 / seconds
Query stored in cache : _QUERY_www.toadli.comf39ff5ba642b8befdd8a019e4dfb2a8e
loadtime:0.47926092147827 / seconds
Query Executed:select id FROM `nh` where city='West Ossipee' && SIC_code='7219'DB:business_master_new
loadtime:0.48011898994446 / seconds
Query Executed:select * from geodata_geocity where city='West Peterborough' limit 1DB:business_master_new
loadtime:0.48098206520081 / seconds
Query stored in cache : _QUERY_www.toadli.com4291919510e920428c1127d4075c7f48
loadtime:0.48103094100952 / seconds
Query Executed:select id FROM `nh` where city='West Peterborough' && SIC_code='7219'DB:business_master_new
loadtime:0.48292803764343 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Springfield' limit 1
loadtime:0.48298192024231 / seconds
Query Executed:select id FROM `nh` where city='West Springfield' && SIC_code='7219'DB:business_master_new
loadtime:0.48322606086731 / seconds
Query Executed:select * from geodata_geocity where city='West Stewartstown' limit 1DB:business_master_new
loadtime:0.48348689079285 / seconds
Query stored in cache : _QUERY_www.toadli.com29ec2c9740af93e2150d83e56e8b5f80
loadtime:0.48352599143982 / seconds
Query Executed:select id FROM `nh` where city='West Stewartstown' && SIC_code='7219'DB:business_master_new
loadtime:0.48388695716858 / seconds
Query Executed:select * from geodata_geocity where city='West Swanzey' limit 1DB:business_master_new
loadtime:0.48418188095093 / seconds
Query stored in cache : _QUERY_www.toadli.com17ad640359015887abc6d45aff463e9e
loadtime:0.48422694206238 / seconds
Query Executed:select id FROM `nh` where city='West Swanzey' && SIC_code='7219'DB:business_master_new
loadtime:0.48464107513428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westmoreland' limit 1
loadtime:0.48468399047852 / seconds
Query Executed:select id FROM `nh` where city='Westmoreland' && SIC_code='7219'DB:business_master_new
loadtime:0.485102891922 / seconds
Query Executed:select * from geodata_geocity where city='Whitefield' limit 1DB:business_master_new
loadtime:0.48538398742676 / seconds
Query stored in cache : _QUERY_www.toadli.comfd9f0a1ed07688a8255c982c3e30f7a5
loadtime:0.48542308807373 / seconds
Query Executed:select id FROM `nh` where city='Whitefield' && SIC_code='7219'DB:business_master_new
loadtime:0.48583698272705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmot' limit 1
loadtime:0.48587989807129 / seconds
Query Executed:select id FROM `nh` where city='Wilmot' && SIC_code='7219'DB:business_master_new
loadtime:0.48628807067871 / seconds
Query Executed:select * from geodata_geocity where city='Wilmot Flat' limit 1DB:business_master_new
loadtime:0.48657608032227 / seconds
Query stored in cache : _QUERY_www.toadli.com24085371a398f57f3b5c85b0ad1818ca
loadtime:0.48661589622498 / seconds
Query Executed:select id FROM `nh` where city='Wilmot Flat' && SIC_code='7219'DB:business_master_new
loadtime:0.486820936203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.4868540763855 / seconds
Query Executed:select id FROM `nh` where city='Wilton' && SIC_code='7219'DB:business_master_new
loadtime:0.48723101615906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester' limit 1
loadtime:0.48726391792297 / seconds
Query Executed:select id FROM `nh` where city='Winchester' && SIC_code='7219'DB:business_master_new
loadtime:0.48764991760254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.48768591880798 / seconds
Query Executed:select id FROM `nh` where city='Windham' && SIC_code='7219'DB:business_master_new
loadtime:0.48808002471924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.48812007904053 / seconds
Query Executed:select id FROM `nh` where city='Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.48881602287292 / seconds
Query Executed:select * from geodata_geocity where city='Winnisquam' limit 1DB:business_master_new
loadtime:0.48910307884216 / seconds
Query stored in cache : _QUERY_www.toadli.com612a12e439b1d7bffa6c2f894b44beca
loadtime:0.48913502693176 / seconds
Query Executed:select id FROM `nh` where city='Winnisquam' && SIC_code='7219'DB:business_master_new
loadtime:0.48978090286255 / seconds
Query Executed:select * from geodata_geocity where city='Wolfeboro' limit 1DB:business_master_new
loadtime:0.4903039932251 / seconds
Query stored in cache : _QUERY_www.toadli.com7af7b4ef3c4a4f6cd4ab36efa2bf0ade
loadtime:0.49034905433655 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro' && SIC_code='7219'DB:business_master_new
loadtime:0.49146699905396 / seconds
Query Executed:select * from geodata_geocity where city='Wolfeboro Falls' limit 1DB:business_master_new
loadtime:0.49196887016296 / seconds
Query stored in cache : _QUERY_www.toadli.comd2d319dadc015e792780981052e5c217
loadtime:0.49204206466675 / seconds
Query Executed:select id FROM `nh` where city='Wolfeboro Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.49320197105408 / seconds
Query Executed:select * from geodata_geocity where city='Wonalancet' limit 1DB:business_master_new
loadtime:0.49361491203308 / seconds
Query stored in cache : _QUERY_www.toadli.com5ba1910c658f28e75b09e39b0fc1936b
loadtime:0.49374508857727 / seconds
Query Executed:select id FROM `nh` where city='Wonalancet' && SIC_code='7219'DB:business_master_new
loadtime:0.49532890319824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.49537801742554 / seconds
Query Executed:select id FROM `nh` where city='Woodstock' && SIC_code='7219'DB:business_master_new
loadtime:0.49646592140198 / seconds
Query Executed:select * from geodata_geocity where city='Woodsville' limit 1DB:business_master_new
loadtime:0.49689197540283 / seconds
Query stored in cache : _QUERY_www.toadli.com86abee761aca3bbe90c75cbb96a9d349
loadtime:0.49698495864868 / seconds
Query Executed:select id FROM `nh` where city='Woodsville' && SIC_code='7219'DB:business_master_new
loadtime:0.49817895889282 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.49827909469604 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.49866104125977 / seconds
Operation template executed (chunk cache operation)
loadtime:0.49884486198425 / seconds
template override:Default
loadtime:0.49889206886292 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.50047397613525 / seconds
Template Constructed, Array Rows:49
loadtime:0.50111103057861 / seconds
TOTAL EXECUTION TIME: 0.50062
loadtime:0.50129199028015 / 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] => laundry-and-garment-services-nec [stateURLid] => new-hampshire )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.50130391120911
TOTAL KEY ARRAYS: 69