Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.2956085205078E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001777172088623 / seconds
host not found setting manual db connection
loadtime:0.0095000267028809 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.009721040725708 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0099101066589355 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.009972095489502 / seconds
zipcode:
loadtime:0.010001182556152 / seconds
Query Executed:select * from search_referrer where page_hash='9b270ccd4162d4b26fd1765e0d741fdc' limit 10 DB:ezrox_toadli
loadtime:0.01024603843689 / seconds
Operation header executed (non global)
loadtime:0.010274171829224 / seconds
Operation leaderboard executed (non global)
loadtime:0.010324954986572 / seconds
Operation square executed (non global)
loadtime:0.010354995727539 / seconds
Operation square_bottom executed (non global)
loadtime:0.010382175445557 / seconds
Operation smallsquare executed (non global)
loadtime:0.010408163070679 / seconds
Operation headeradright executed (non global)
loadtime:0.010432958602905 / seconds
Operation google_analytics executed (non global)
loadtime:0.010457992553711 / seconds
Operation topstories executed (non global)
loadtime:0.010483026504517 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010509967803955 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010535001754761 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010764122009277 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.010928153991699 / seconds
Operation categories executed (global stored into APC)
loadtime:0.010970115661621 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011031150817871 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011079072952271 / seconds
Template key: archive_menu pushed
loadtime:0.011089086532593 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.01110315322876 / seconds
Template key: get_gravatar pushed
loadtime:0.011110067367554 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.01111912727356 / seconds
*10)-10)+1 | start:0
loadtime:0.011159181594849 / seconds
DB connected to localhost business_master_new
loadtime:0.011415004730225 / seconds
Query Executed:select * from categories where cat_URLid='auto-and-home-supply-stores'DB:business_master_new
loadtime:0.012421131134033 / seconds
Query stored in cache : _QUERY_www.toadli.come4f69782081f0ed656ec764576e5695a
loadtime:0.012479066848755 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.01252007484436 / seconds
Query Executed:select * from `ct_catmap` where sic='5531' order by city ascDB:business_master_new
loadtime:0.021862983703613 / seconds
Query stored in cache : _QUERY_www.toadli.com3a8b05c8dbdcc85cd21675a2b35346fd
loadtime:0.022982120513916 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.023033142089844 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='5531'DB:business_master_new
loadtime:0.024650096893311 / seconds
Query stored in cache : _QUERY_www.toadli.com05b6234595bbdac00d331655234263ed
loadtime:0.024686098098755 / seconds
273 / 11
loadtime:0.024749994277954 / seconds
Query Executed:select * from geodata_geocity where city='Abington' limit 1DB:business_master_new
loadtime:0.025196075439453 / seconds
Query stored in cache : _QUERY_www.toadli.com907445db5270b7152e3d83e07120b9ad
loadtime:0.025264024734497 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='5531'DB:business_master_new
loadtime:0.031246185302734 / seconds
Query Executed:select * from geodata_geocity where city='Amston' limit 1DB:business_master_new
loadtime:0.03167200088501 / seconds
Query stored in cache : _QUERY_www.toadli.com402cad0a7837fd917718238e1dbaefc3
loadtime:0.031752109527588 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='5531'DB:business_master_new
loadtime:0.032773017883301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.032829999923706 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='5531'DB:business_master_new
loadtime:0.03410816192627 / seconds
Query Executed:select * from geodata_geocity where city='Ansonia' limit 1DB:business_master_new
loadtime:0.034507989883423 / seconds
Query stored in cache : _QUERY_www.toadli.com5e203c49d23160b5467f190f105e3558
loadtime:0.034574031829834 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='5531'DB:business_master_new
loadtime:0.043154001235962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.043231010437012 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='5531'DB:business_master_new
loadtime:0.04472804069519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.044787168502808 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='5531'DB:business_master_new
loadtime:0.04925799369812 / seconds
Query Executed:select * from geodata_geocity where city='Ballouville' limit 1DB:business_master_new
loadtime:0.049671173095703 / seconds
Query stored in cache : _QUERY_www.toadli.com6ef4d42b271e1af94d260a919135c580
loadtime:0.049751043319702 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='5531'DB:business_master_new
loadtime:0.050431966781616 / seconds
Query Executed:select * from geodata_geocity where city='Baltic' limit 1DB:business_master_new
loadtime:0.050827980041504 / seconds
Query stored in cache : _QUERY_www.toadli.coma6f1a4d4107a56c2dad5101f5b27fc26
loadtime:0.05089807510376 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='5531'DB:business_master_new
loadtime:0.05194616317749 / seconds
Query Executed:select * from geodata_geocity where city='Bantam' limit 1DB:business_master_new
loadtime:0.052356958389282 / seconds
Query stored in cache : _QUERY_www.toadli.com942bd9ac8be633abc73e5eb3fb0fdf7c
loadtime:0.052426099777222 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='5531'DB:business_master_new
loadtime:0.053781032562256 / seconds
Query Executed:select * from geodata_geocity where city='Barkhamsted' limit 1DB:business_master_new
loadtime:0.054214000701904 / seconds
Query stored in cache : _QUERY_www.toadli.comf9855ecd85241279c73ac60a6b0a7e86
loadtime:0.054279088973999 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='5531'DB:business_master_new
loadtime:0.055530071258545 / seconds
Query Executed:select * from geodata_geocity where city='Beacon Falls' limit 1DB:business_master_new
loadtime:0.055950164794922 / seconds
Query stored in cache : _QUERY_www.toadli.comed9642d6bf40bab4e03b0d021bdc0f9e
loadtime:0.056014060974121 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='5531'DB:business_master_new
loadtime:0.060482978820801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.06053900718689 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='5531'DB:business_master_new
loadtime:0.065016031265259 / seconds
Query Executed:select * from geodata_geocity where city='Bethany' limit 1DB:business_master_new
loadtime:0.06544017791748 / seconds
Query stored in cache : _QUERY_www.toadli.com4b5e4edaea749c6d9bb58326f95b2360
loadtime:0.065505981445312 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='5531'DB:business_master_new
loadtime:0.070000171661377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.070073127746582 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='5531'DB:business_master_new
loadtime:0.074558019638062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.074635028839111 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='5531'DB:business_master_new
loadtime:0.076604127883911 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.076672077178955 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='5531'DB:business_master_new
loadtime:0.081166982650757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.081223011016846 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='5531'DB:business_master_new
loadtime:0.083136081695557 / seconds
Query Executed:select * from geodata_geocity where city='Botsford' limit 1DB:business_master_new
loadtime:0.083572149276733 / seconds
Query stored in cache : _QUERY_www.toadli.comf817dbed5af7c20c4b2c3b68e4972d88
loadtime:0.083636999130249 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='5531'DB:business_master_new
loadtime:0.084473133087158 / seconds
Query Executed:select * from geodata_geocity where city='Bozrah' limit 1DB:business_master_new
loadtime:0.084920167922974 / seconds
Query stored in cache : _QUERY_www.toadli.com8cd16927585d0b10031364ebd13b80db
loadtime:0.084985971450806 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='5531'DB:business_master_new
loadtime:0.086227178573608 / seconds
Query Executed:select * from geodata_geocity where city='Branford' limit 1DB:business_master_new
loadtime:0.086697101593018 / seconds
Query stored in cache : _QUERY_www.toadli.com6c8ecb1e32aa39581b8ceb634ae0d32a
loadtime:0.086771011352539 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='5531'DB:business_master_new
loadtime:0.091274976730347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.09135913848877 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='5531'DB:business_master_new
loadtime:0.095901012420654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.096068143844604 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='5531'DB:business_master_new
loadtime:0.097488164901733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.097547054290771 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='5531'DB:business_master_new
loadtime:0.10205817222595 / seconds
Query Executed:select * from geodata_geocity where city='Broad Brook' limit 1DB:business_master_new
loadtime:0.10248303413391 / seconds
Query stored in cache : _QUERY_www.toadli.combc60c1caa109e28cdf539fbb0b9b1c77
loadtime:0.10256004333496 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='5531'DB:business_master_new
loadtime:0.10412311553955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.1041841506958 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='5531'DB:business_master_new
loadtime:0.1086699962616 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.10874319076538 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='5531'DB:business_master_new
loadtime:0.11064600944519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.11070203781128 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='5531'DB:business_master_new
loadtime:0.11517000198364 / seconds
Query Executed:select * from geodata_geocity where city='Canaan' limit 1DB:business_master_new
loadtime:0.11561417579651 / seconds
Query stored in cache : _QUERY_www.toadli.com302b83ace79e212131e7f67d6251a425
loadtime:0.11568117141724 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='5531'DB:business_master_new
loadtime:0.117760181427 / seconds
Query Executed:select * from geodata_geocity where city='Canterbury' limit 1DB:business_master_new
loadtime:0.11818909645081 / seconds
Query stored in cache : _QUERY_www.toadli.com7b4df376b9c55c36839787f62b04915d
loadtime:0.11825799942017 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='5531'DB:business_master_new
loadtime:0.11982011795044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.11987709999084 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='5531'DB:business_master_new
loadtime:0.12433910369873 / seconds
Query Executed:select * from geodata_geocity where city='Canton Center' limit 1DB:business_master_new
loadtime:0.12478017807007 / seconds
Query stored in cache : _QUERY_www.toadli.com4e15464a15694961afd0375f40e9161b
loadtime:0.12485408782959 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='5531'DB:business_master_new
loadtime:0.12561297416687 / seconds
Query Executed:select * from geodata_geocity where city='Centerbrook' limit 1DB:business_master_new
loadtime:0.12602806091309 / seconds
Query stored in cache : _QUERY_www.toadli.com826eb9326cf55148716f2e4e2d11c2b9
loadtime:0.12609815597534 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='5531'DB:business_master_new
loadtime:0.12732315063477 / seconds
Query Executed:select * from geodata_geocity where city='Central Village' limit 1DB:business_master_new
loadtime:0.12773609161377 / seconds
Query stored in cache : _QUERY_www.toadli.com271b4de0ee147679dcda927183cd8efd
loadtime:0.12781000137329 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='5531'DB:business_master_new
loadtime:0.12860798835754 / seconds
Query Executed:select * from geodata_geocity where city='Chaplin' limit 1DB:business_master_new
loadtime:0.12906408309937 / seconds
Query stored in cache : _QUERY_www.toadli.come387d43eec08c42c0ee23e60ec4e73f3
loadtime:0.12912797927856 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='5531'DB:business_master_new
loadtime:0.13019704818726 / seconds
Query Executed:select * from geodata_geocity where city='Cheshire' limit 1DB:business_master_new
loadtime:0.13061714172363 / seconds
Query stored in cache : _QUERY_www.toadli.comf4f4fbf643d5e1d2ec423cc06deaef41
loadtime:0.13068103790283 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='5531'DB:business_master_new
loadtime:0.13516712188721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.13524198532104 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='5531'DB:business_master_new
loadtime:0.13750195503235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.13755917549133 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='5531'DB:business_master_new
loadtime:0.14204216003418 / seconds
Query Executed:select * from geodata_geocity where city='Cobalt' limit 1DB:business_master_new
loadtime:0.14247798919678 / seconds
Query stored in cache : _QUERY_www.toadli.comdd5e8d0ac83f5b6670021db2b05f6119
loadtime:0.14254307746887 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='5531'DB:business_master_new
loadtime:0.14327907562256 / seconds
Query Executed:select * from geodata_geocity where city='Colchester' limit 1DB:business_master_new
loadtime:0.1436550617218 / seconds
Query stored in cache : _QUERY_www.toadli.com620839df3144b8f34c902c5553f1ea16
loadtime:0.1437201499939 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='5531'DB:business_master_new
loadtime:0.14819717407227 / seconds
Query Executed:select * from geodata_geocity where city='Colebrook' limit 1DB:business_master_new
loadtime:0.1486120223999 / seconds
Query stored in cache : _QUERY_www.toadli.com48f61dbc5e4a35a1d026c0260bded065
loadtime:0.148677110672 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='5531'DB:business_master_new
loadtime:0.14948511123657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.14954304695129 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='5531'DB:business_master_new
loadtime:0.15040612220764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.15046000480652 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='5531'DB:business_master_new
loadtime:0.15218710899353 / seconds
Query Executed:select * from geodata_geocity where city='Cornwall' limit 1DB:business_master_new
loadtime:0.15260815620422 / seconds
Query stored in cache : _QUERY_www.toadli.com42fbd19cec046f4dbcba61fc1a6ab954
loadtime:0.15267705917358 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='5531'DB:business_master_new
loadtime:0.15349316596985 / seconds
Query Executed:select * from geodata_geocity where city='Cornwall Bridge' limit 1DB:business_master_new
loadtime:0.15393114089966 / seconds
Query stored in cache : _QUERY_www.toadli.com39a1fbaf019decad5a000c7451659810
loadtime:0.15400099754333 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='5531'DB:business_master_new
loadtime:0.15519404411316 / seconds
Query Executed:select * from geodata_geocity where city='Cos Cob' limit 1DB:business_master_new
loadtime:0.15560698509216 / seconds
Query stored in cache : _QUERY_www.toadli.comb952e2a50ffd294e2a80cb9fd6a178a8
loadtime:0.15567111968994 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='5531'DB:business_master_new
loadtime:0.16016006469727 / seconds
Query Executed:select * from geodata_geocity where city='Coventry' limit 1DB:business_master_new
loadtime:0.1605761051178 / seconds
Query stored in cache : _QUERY_www.toadli.com9759c83c0748c87df576f920023da993
loadtime:0.160640001297 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='5531'DB:business_master_new
loadtime:0.16513299942017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.16518902778625 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='5531'DB:business_master_new
loadtime:0.16969799995422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.16975712776184 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='5531'DB:business_master_new
loadtime:0.17429995536804 / seconds
Query Executed:select * from geodata_geocity where city='Danielson' limit 1DB:business_master_new
loadtime:0.17476606369019 / seconds
Query stored in cache : _QUERY_www.toadli.comf86a8f2809b1e26a7ecfcd096df0cc9f
loadtime:0.17484211921692 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='5531'DB:business_master_new
loadtime:0.1793270111084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.17940306663513 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='5531'DB:business_master_new
loadtime:0.18386316299438 / seconds
Query Executed:select * from geodata_geocity where city='Dayville' limit 1DB:business_master_new
loadtime:0.18431496620178 / seconds
Query stored in cache : _QUERY_www.toadli.coma8b97169f08e050ac3ade646e8a4f4d0
loadtime:0.18438005447388 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='5531'DB:business_master_new
loadtime:0.18609714508057 / seconds
Query Executed:select * from geodata_geocity where city='Deep River' limit 1DB:business_master_new
loadtime:0.18649411201477 / seconds
Query stored in cache : _QUERY_www.toadli.com755c7c38d7295882c601eead2de1e9ef
loadtime:0.18655896186829 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='5531'DB:business_master_new
loadtime:0.1886191368103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.18867516517639 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='5531'DB:business_master_new
loadtime:0.19314908981323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.19322299957275 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='5531'DB:business_master_new
loadtime:0.19767904281616 / seconds
Query Executed:select * from geodata_geocity where city='East Berlin' limit 1DB:business_master_new
loadtime:0.19810509681702 / seconds
Query stored in cache : _QUERY_www.toadli.com3dc89dd08f9eaf385638110f9e4062c4
loadtime:0.19817805290222 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='5531'DB:business_master_new
loadtime:0.19938611984253 / seconds
Query Executed:select * from geodata_geocity where city='East Canaan' limit 1DB:business_master_new
loadtime:0.19976997375488 / seconds
Query stored in cache : _QUERY_www.toadli.comb813e9210d73a8e16ef78177f1f2c0dc
loadtime:0.19984912872314 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='5531'DB:business_master_new
loadtime:0.20066618919373 / seconds
Query Executed:select * from geodata_geocity where city='East Glastonbury' limit 1DB:business_master_new
loadtime:0.20108103752136 / seconds
Query stored in cache : _QUERY_www.toadli.com8eab313908312a33e39093b35ff8fd27
loadtime:0.20114517211914 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='5531'DB:business_master_new
loadtime:0.20186018943787 / seconds
Query Executed:select * from geodata_geocity where city='East Granby' limit 1DB:business_master_new
loadtime:0.20226311683655 / seconds
Query stored in cache : _QUERY_www.toadli.com66dfa65177a85bda980e7488100bbd5d
loadtime:0.20232796669006 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='5531'DB:business_master_new
loadtime:0.20681810379028 / seconds
Query Executed:select * from geodata_geocity where city='East Haddam' limit 1DB:business_master_new
loadtime:0.20721912384033 / seconds
Query stored in cache : _QUERY_www.toadli.comd02cde2032219cc07afa34f14d8177b2
loadtime:0.20728397369385 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='5531'DB:business_master_new
loadtime:0.20915102958679 / seconds
Query Executed:select * from geodata_geocity where city='East Hampton' limit 1DB:business_master_new
loadtime:0.20954704284668 / seconds
Query stored in cache : _QUERY_www.toadli.com79b200f4c2e2f013dbeb70694494c019
loadtime:0.20961809158325 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='5531'DB:business_master_new
loadtime:0.21411895751953 / seconds
Query Executed:select * from geodata_geocity where city='East Hartford' limit 1DB:business_master_new
loadtime:0.21458315849304 / seconds
Query stored in cache : _QUERY_www.toadli.com6686ae9ca83e28d84330607829e72cf4
loadtime:0.21470212936401 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='5531'DB:business_master_new
loadtime:0.2192530632019 / seconds
Query Executed:select * from geodata_geocity where city='East Hartland' limit 1DB:business_master_new
loadtime:0.21966099739075 / seconds
Query stored in cache : _QUERY_www.toadli.com4d8d1170cc4962e9ae686daf3bdbc17a
loadtime:0.21972608566284 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='5531'DB:business_master_new
loadtime:0.22072005271912 / seconds
Query Executed:select * from geodata_geocity where city='East Haven' limit 1DB:business_master_new
loadtime:0.22112798690796 / seconds
Query stored in cache : _QUERY_www.toadli.com4e970c7f115cc13ebb0a7fadc9a5a00c
loadtime:0.22119498252869 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='5531'DB:business_master_new
loadtime:0.22567009925842 / seconds
Query Executed:select * from geodata_geocity where city='East Killingly' limit 1DB:business_master_new
loadtime:0.22610712051392 / seconds
Query stored in cache : _QUERY_www.toadli.com4f400cb630073f8de1d410a8cf6773e4
loadtime:0.22617197036743 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='5531'DB:business_master_new
loadtime:0.22693514823914 / seconds
Query Executed:select * from geodata_geocity where city='East Lyme' limit 1DB:business_master_new
loadtime:0.22735500335693 / seconds
Query stored in cache : _QUERY_www.toadli.come84cd275dc9c08ce609f86eb04df1b4e
loadtime:0.22742104530334 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='5531'DB:business_master_new
loadtime:0.23190999031067 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.23198509216309 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='5531'DB:business_master_new
loadtime:0.23647117614746 / seconds
Query Executed:select * from geodata_geocity where city='East Windsor Hill' limit 1DB:business_master_new
loadtime:0.23690104484558 / seconds
Query stored in cache : _QUERY_www.toadli.come910d719c545c11c4ff0c2a95d82796a
loadtime:0.23697209358215 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='5531'DB:business_master_new
loadtime:0.23769807815552 / seconds
Query Executed:select * from geodata_geocity where city='East Woodstock' limit 1DB:business_master_new
loadtime:0.23811197280884 / seconds
Query stored in cache : _QUERY_www.toadli.comcd70f69abb4d3c204b49737700cbc068
loadtime:0.23817610740662 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='5531'DB:business_master_new
loadtime:0.2389349937439 / seconds
Query Executed:select * from geodata_geocity where city='Eastford' limit 1DB:business_master_new
loadtime:0.23932003974915 / seconds
Query stored in cache : _QUERY_www.toadli.com6eb29df21832078a7a88acc994a30067
loadtime:0.23938608169556 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='5531'DB:business_master_new
loadtime:0.24046206474304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.24051809310913 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='5531'DB:business_master_new
loadtime:0.24499201774597 / seconds
Query Executed:select * from geodata_geocity where city='Ellington' limit 1DB:business_master_new
loadtime:0.24540114402771 / seconds
Query stored in cache : _QUERY_www.toadli.com2804f55c0757dc9004de228e401c5116
loadtime:0.24546599388123 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='5531'DB:business_master_new
loadtime:0.24992918968201 / seconds
Query Executed:select * from geodata_geocity where city='Enfield' limit 1DB:business_master_new
loadtime:0.25041198730469 / seconds
Query stored in cache : _QUERY_www.toadli.comf7b2c30814d60bb5ac7e5ffced40aa10
loadtime:0.25047898292542 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='5531'DB:business_master_new
loadtime:0.25495910644531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.25504612922668 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='5531'DB:business_master_new
loadtime:0.25952196121216 / seconds
Query Executed:select * from geodata_geocity where city='Fabyan' limit 1DB:business_master_new
loadtime:0.25994801521301 / seconds
Query stored in cache : _QUERY_www.toadli.com346366781cb03d9804b6a58e38d8e6fd
loadtime:0.2600200176239 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='5531'DB:business_master_new
loadtime:0.26066398620605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.26071810722351 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='5531'DB:business_master_new
loadtime:0.26521110534668 / seconds
Query Executed:select * from geodata_geocity where city='Falls Village' limit 1DB:business_master_new
loadtime:0.26565504074097 / seconds
Query stored in cache : _QUERY_www.toadli.com88a0ab3b2bd0c4addc6f1e4ee4cb425b
loadtime:0.26572418212891 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='5531'DB:business_master_new
loadtime:0.26686096191406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.26691913604736 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='5531'DB:business_master_new
loadtime:0.27139115333557 / seconds
Query Executed:select * from geodata_geocity where city='Gales Ferry' limit 1DB:business_master_new
loadtime:0.27183413505554 / seconds
Query stored in cache : _QUERY_www.toadli.com0df884edbbdfba6637704a4fcbad662a
loadtime:0.27190518379211 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='5531'DB:business_master_new
loadtime:0.27377605438232 / seconds
Query Executed:select * from geodata_geocity where city='Gaylordsville' limit 1DB:business_master_new
loadtime:0.2741961479187 / seconds
Query stored in cache : _QUERY_www.toadli.comb714171a051b73bef4cfc7615dbacd82
loadtime:0.27426218986511 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='5531'DB:business_master_new
loadtime:0.27520203590393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.2752571105957 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='5531'DB:business_master_new
loadtime:0.27655100822449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.27660417556763 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='5531'DB:business_master_new
loadtime:0.27726817131042 / seconds
Query Executed:select * from geodata_geocity where city='Glasgo' limit 1DB:business_master_new
loadtime:0.27763319015503 / seconds
Query stored in cache : _QUERY_www.toadli.com4f0eebebb447219189e78e252e791650
loadtime:0.27769708633423 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='5531'DB:business_master_new
loadtime:0.27835607528687 / seconds
Query Executed:select * from geodata_geocity where city='Glastonbury' limit 1DB:business_master_new
loadtime:0.27873015403748 / seconds
Query stored in cache : _QUERY_www.toadli.com6198a618973111a0d0f21a4f134bdcee
loadtime:0.27880811691284 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='5531'DB:business_master_new
loadtime:0.28330612182617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.28337407112122 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='5531'DB:business_master_new
loadtime:0.28508996963501 / seconds
Query Executed:select * from geodata_geocity where city='Granby' limit 1DB:business_master_new
loadtime:0.28548717498779 / seconds
Query stored in cache : _QUERY_www.toadli.com42c49269074d7a180351646593250836
loadtime:0.28555607795715 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='5531'DB:business_master_new
loadtime:0.28830313682556 / seconds
Query Executed:select * from geodata_geocity where city='Greens Farms' limit 1DB:business_master_new
loadtime:0.28869915008545 / seconds
Query stored in cache : _QUERY_www.toadli.com672c45eb7f1bf6566fc7ee665a79689d
loadtime:0.28876399993896 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='5531'DB:business_master_new
loadtime:0.28968596458435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.28974199295044 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='5531'DB:business_master_new
loadtime:0.29423213005066 / seconds
Query Executed:select * from geodata_geocity where city='Grosvenor Dale' limit 1DB:business_master_new
loadtime:0.2946560382843 / seconds
Query stored in cache : _QUERY_www.toadli.comd52e6a2d05b7d870f8b42815619cd4ac
loadtime:0.29472017288208 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='5531'DB:business_master_new
loadtime:0.29541110992432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.29546713829041 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='5531'DB:business_master_new
loadtime:0.29992818832397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.30000019073486 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='5531'DB:business_master_new
loadtime:0.30444812774658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.30451917648315 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='5531'DB:business_master_new
loadtime:0.30590605735779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.30597901344299 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='5531'DB:business_master_new
loadtime:0.30673503875732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.30678796768188 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='5531'DB:business_master_new
loadtime:0.31127905845642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.31136798858643 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='5531'DB:business_master_new
loadtime:0.31246304512024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.31251811981201 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='5531'DB:business_master_new
loadtime:0.31319499015808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.31324815750122 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='5531'DB:business_master_new
loadtime:0.31772208213806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.31779408454895 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='5531'DB:business_master_new
loadtime:0.31979608535767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.31985902786255 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='5531'DB:business_master_new
loadtime:0.32062411308289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.32068109512329 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='5531'DB:business_master_new
loadtime:0.32277417182922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.32283496856689 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='5531'DB:business_master_new
loadtime:0.32438206672668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.32443404197693 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='5531'DB:business_master_new
loadtime:0.3255341053009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.32559204101562 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='5531'DB:business_master_new
loadtime:0.33007097244263 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.33013701438904 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='5531'DB:business_master_new
loadtime:0.3322160243988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.33228206634521 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='5531'DB:business_master_new
loadtime:0.33451008796692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.3345639705658 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='5531'DB:business_master_new
loadtime:0.335294008255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.33534908294678 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='5531'DB:business_master_new
loadtime:0.33704113960266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.33709502220154 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='5531'DB:business_master_new
loadtime:0.33907604217529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.33913016319275 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='5531'DB:business_master_new
loadtime:0.34095597267151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.34101510047913 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='5531'DB:business_master_new
loadtime:0.34547805786133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.34553718566895 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='5531'DB:business_master_new
loadtime:0.35001802444458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.35009002685547 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='5531'DB:business_master_new
loadtime:0.3545560836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.35462498664856 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='5531'DB:business_master_new
loadtime:0.35657596588135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.35663104057312 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='5531'DB:business_master_new
loadtime:0.3573751449585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.35742807388306 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='5531'DB:business_master_new
loadtime:0.35811305046082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.35816717147827 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='5531'DB:business_master_new
loadtime:0.359050989151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.35910415649414 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='5531'DB:business_master_new
loadtime:0.36134910583496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.36140298843384 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='5531'DB:business_master_new
loadtime:0.36590003967285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.36598515510559 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='5531'DB:business_master_new
loadtime:0.36674308776855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.36680603027344 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='5531'DB:business_master_new
loadtime:0.37129902839661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.37135314941406 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='5531'DB:business_master_new
loadtime:0.3730890750885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.37315511703491 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='5531'DB:business_master_new
loadtime:0.37763810157776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.37770795822144 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='5531'DB:business_master_new
loadtime:0.38221907615662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.3823070526123 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='5531'DB:business_master_new
loadtime:0.38335800170898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.38341498374939 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='5531'DB:business_master_new
loadtime:0.38788104057312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.38794898986816 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='5531'DB:business_master_new
loadtime:0.38882517814636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.38887906074524 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='5531'DB:business_master_new
loadtime:0.39005613327026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.39012312889099 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='5531'DB:business_master_new
loadtime:0.39128303527832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.39135003089905 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='5531'DB:business_master_new
loadtime:0.39257907867432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.39263200759888 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='5531'DB:business_master_new
loadtime:0.3971049785614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.39717316627502 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='5531'DB:business_master_new
loadtime:0.40164113044739 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.40171504020691 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='5531'DB:business_master_new
loadtime:0.40619897842407 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.40627002716064 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='5531'DB:business_master_new
loadtime:0.41074800491333 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.41082406044006 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='5531'DB:business_master_new
loadtime:0.41530609130859 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.41537308692932 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='5531'DB:business_master_new
loadtime:0.41749906539917 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.41755604743958 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='5531'DB:business_master_new
loadtime:0.42204999923706 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.42213201522827 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='5531'DB:business_master_new
loadtime:0.426598072052 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.42665600776672 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='5531'DB:business_master_new
loadtime:0.43113803863525 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.43120503425598 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='5531'DB:business_master_new
loadtime:0.43265414237976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.43272018432617 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='5531'DB:business_master_new
loadtime:0.43720698356628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.43726706504822 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='5531'DB:business_master_new
loadtime:0.44172811508179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.44179606437683 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='5531'DB:business_master_new
loadtime:0.44628214836121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.44633603096008 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='5531'DB:business_master_new
loadtime:0.44786810874939 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.44792199134827 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='5531'DB:business_master_new
loadtime:0.45237302780151 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.45244407653809 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='5531'DB:business_master_new
loadtime:0.45311999320984 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.45317602157593 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='5531'DB:business_master_new
loadtime:0.45446515083313 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.45453119277954 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='5531'DB:business_master_new
loadtime:0.45560216903687 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.45565700531006 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='5531'DB:business_master_new
loadtime:0.45683002471924 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.45690011978149 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='5531'DB:business_master_new
loadtime:0.46138906478882 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.4614691734314 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='5531'DB:business_master_new
loadtime:0.46340298652649 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.46345806121826 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='5531'DB:business_master_new
loadtime:0.46411609649658 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.46416902542114 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='5531'DB:business_master_new
loadtime:0.46537399291992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.46543908119202 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='5531'DB:business_master_new
loadtime:0.46632218360901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.46637511253357 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='5531'DB:business_master_new
loadtime:0.46941113471985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.46946406364441 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='5531'DB:business_master_new
loadtime:0.47394704818726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.47404217720032 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='5531'DB:business_master_new
loadtime:0.47849917411804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.4785680770874 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='5531'DB:business_master_new
loadtime:0.48006296157837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.48012900352478 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='5531'DB:business_master_new
loadtime:0.48194599151611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.48200416564941 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='5531'DB:business_master_new
loadtime:0.48648810386658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.4865620136261 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='5531'DB:business_master_new
loadtime:0.49103498458862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.49108910560608 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='5531'DB:business_master_new
loadtime:0.49196910858154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.49203014373779 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='5531'DB:business_master_new
loadtime:0.49649405479431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.49656414985657 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='5531'DB:business_master_new
loadtime:0.49731802940369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.49737405776978 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='5531'DB:business_master_new
loadtime:0.50184798240662 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.5019199848175 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='5531'DB:business_master_new
loadtime:0.50639414787292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.50646495819092 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='5531'DB:business_master_new
loadtime:0.50869011878967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.50874495506287 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='5531'DB:business_master_new
loadtime:0.50952506065369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.50957703590393 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='5531'DB:business_master_new
loadtime:0.51030397415161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.51035618782043 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='5531'DB:business_master_new
loadtime:0.51481413841248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.51488018035889 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='5531'DB:business_master_new
loadtime:0.51934599876404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.51941418647766 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='5531'DB:business_master_new
loadtime:0.5218710899353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.5219361782074 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='5531'DB:business_master_new
loadtime:0.52259302139282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.52264714241028 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='5531'DB:business_master_new
loadtime:0.52381300926208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.52386808395386 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='5531'DB:business_master_new
loadtime:0.52472496032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.52479195594788 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='5531'DB:business_master_new
loadtime:0.52632403373718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.52637600898743 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='5531'DB:business_master_new
loadtime:0.52713108062744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.52718305587769 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='5531'DB:business_master_new
loadtime:0.53026509284973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.53034210205078 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='5531'DB:business_master_new
loadtime:0.53191804885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.53200697898865 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='5531'DB:business_master_new
loadtime:0.53649210929871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.53657197952271 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='5531'DB:business_master_new
loadtime:0.54104208946228 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.54110813140869 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='5531'DB:business_master_new
loadtime:0.54227709770203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.5423309803009 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='5531'DB:business_master_new
loadtime:0.54310703277588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.54315996170044 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='5531'DB:business_master_new
loadtime:0.54759407043457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.54764819145203 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='5531'DB:business_master_new
loadtime:0.54843211174011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.54851508140564 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='5531'DB:business_master_new
loadtime:0.54934501647949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.54940509796143 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='5531'DB:business_master_new
loadtime:0.55386996269226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.55394315719604 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='5531'DB:business_master_new
loadtime:0.55840611457825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.55847907066345 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='5531'DB:business_master_new
loadtime:0.55930304527283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.55935716629028 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='5531'DB:business_master_new
loadtime:0.56019997596741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.56025409698486 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='5531'DB:business_master_new
loadtime:0.5647280216217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.56479406356812 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='5531'DB:business_master_new
loadtime:0.56554007530212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.565593957901 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='5531'DB:business_master_new
loadtime:0.56713008880615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.56718397140503 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='5531'DB:business_master_new
loadtime:0.56874299049377 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.56879615783691 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='5531'DB:business_master_new
loadtime:0.57023096084595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.57028603553772 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='5531'DB:business_master_new
loadtime:0.5747389793396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.57479119300842 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='5531'DB:business_master_new
loadtime:0.57571697235107 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.5757691860199 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='5531'DB:business_master_new
loadtime:0.58024597167969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.58031296730042 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='5531'DB:business_master_new
loadtime:0.5825080871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.58256196975708 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='5531'DB:business_master_new
loadtime:0.58702898025513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.58709502220154 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='5531'DB:business_master_new
loadtime:0.58956217765808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.58961796760559 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='5531'DB:business_master_new
loadtime:0.59408712387085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.59413909912109 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='5531'DB:business_master_new
loadtime:0.59698414802551 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.59705495834351 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='5531'DB:business_master_new
loadtime:0.597815990448 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.59786796569824 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='5531'DB:business_master_new
loadtime:0.59854698181152 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.59860014915466 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='5531'DB:business_master_new
loadtime:0.60025596618652 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.60030913352966 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='5531'DB:business_master_new
loadtime:0.60116910934448 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.60122203826904 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='5531'DB:business_master_new
loadtime:0.60196304321289 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.60201907157898 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='5531'DB:business_master_new
loadtime:0.60272407531738 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.60277414321899 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='5531'DB:business_master_new
loadtime:0.60363912582397 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.60369300842285 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='5531'DB:business_master_new
loadtime:0.60818099975586 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.60824918746948 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='5531'DB:business_master_new
loadtime:0.60912013053894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.60917496681213 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='5531'DB:business_master_new
loadtime:0.61366105079651 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.6137580871582 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='5531'DB:business_master_new
loadtime:0.61826014518738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.61832714080811 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='5531'DB:business_master_new
loadtime:0.62319111824036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.62326097488403 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='5531'DB:business_master_new
loadtime:0.62410998344421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.62416505813599 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='5531'DB:business_master_new
loadtime:0.62729501724243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.62736415863037 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='5531'DB:business_master_new
loadtime:0.62808918952942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.62814903259277 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='5531'DB:business_master_new
loadtime:0.63264513015747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.63273310661316 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='5531'DB:business_master_new
loadtime:0.63380599021912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.63386416435242 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='5531'DB:business_master_new
loadtime:0.63464903831482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.63471508026123 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='5531'DB:business_master_new
loadtime:0.63919115066528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.63924598693848 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='5531'DB:business_master_new
loadtime:0.64197611808777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.64202904701233 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='5531'DB:business_master_new
loadtime:0.6464991569519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.64658617973328 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='5531'DB:business_master_new
loadtime:0.64971113204956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.64978408813477 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='5531'DB:business_master_new
loadtime:0.65045714378357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.65051102638245 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='5531'DB:business_master_new
loadtime:0.65162515640259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.65169095993042 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='5531'DB:business_master_new
loadtime:0.65261006355286 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.65266513824463 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='5531'DB:business_master_new
loadtime:0.6547110080719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.65476608276367 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='5531'DB:business_master_new
loadtime:0.65923619270325 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.65930414199829 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='5531'DB:business_master_new
loadtime:0.66078901290894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.6608510017395 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='5531'DB:business_master_new
loadtime:0.6653139591217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.66538000106812 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='5531'DB:business_master_new
loadtime:0.6698260307312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.66989398002625 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='5531'DB:business_master_new
loadtime:0.67437696456909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.67443299293518 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='5531'DB:business_master_new
loadtime:0.67669606208801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.67676305770874 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='5531'DB:business_master_new
loadtime:0.67883515357971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.67888903617859 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='5531'DB:business_master_new
loadtime:0.68336009979248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.68342804908752 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='5531'DB:business_master_new
loadtime:0.68414115905762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.68419504165649 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='5531'DB:business_master_new
loadtime:0.68542218208313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.68547606468201 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='5531'DB:business_master_new
loadtime:0.68995714187622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.69004702568054 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='5531'DB:business_master_new
loadtime:0.69131207466125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.69137096405029 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='5531'DB:business_master_new
loadtime:0.69288611412048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.69295215606689 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='5531'DB:business_master_new
loadtime:0.69744396209717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.69755601882935 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='5531'DB:business_master_new
loadtime:0.70203709602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.70210599899292 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='5531'DB:business_master_new
loadtime:0.70655918121338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:0.70662903785706 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='5531'DB:business_master_new
loadtime:0.70738506317139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:0.70743799209595 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='5531'DB:business_master_new
loadtime:0.70902895927429 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:0.70908117294312 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='5531'DB:business_master_new
loadtime:0.71023011207581 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:0.71028399467468 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='5531'DB:business_master_new
loadtime:0.71114706993103 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.71120119094849 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='5531'DB:business_master_new
loadtime:0.71569609642029 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:0.71576309204102 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='5531'DB:business_master_new
loadtime:0.71649408340454 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.7165470123291 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='5531'DB:business_master_new
loadtime:0.72105717658997 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:0.72114706039429 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='5531'DB:business_master_new
loadtime:0.72194695472717 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:0.72200798988342 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='5531'DB:business_master_new
loadtime:0.72288608551025 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:0.7229380607605 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='5531'DB:business_master_new
loadtime:0.72452998161316 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:0.7245831489563 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='5531'DB:business_master_new
loadtime:0.72591400146484 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:0.7259681224823 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='5531'DB:business_master_new
loadtime:0.72663402557373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:0.72668600082397 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='5531'DB:business_master_new
loadtime:0.72974896430969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.72981214523315 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='5531'DB:business_master_new
loadtime:0.73428702354431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.73434114456177 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='5531'DB:business_master_new
loadtime:0.73880410194397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:0.73887395858765 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='5531'DB:business_master_new
loadtime:0.74333214759827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:0.74339914321899 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='5531'DB:business_master_new
loadtime:0.74787616729736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:0.74794411659241 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='5531'DB:business_master_new
loadtime:0.7495710849762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.74962615966797 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='5531'DB:business_master_new
loadtime:0.75411915779114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:0.7541880607605 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='5531'DB:business_master_new
loadtime:0.75489902496338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.75495314598083 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='5531'DB:business_master_new
loadtime:0.75608611106873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.75615215301514 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='5531'DB:business_master_new
loadtime:0.76065301895142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:0.76071000099182 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='5531'DB:business_master_new
loadtime:0.76519012451172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:0.7652440071106 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='5531'DB:business_master_new
loadtime:0.76970815658569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.76978516578674 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='5531'DB:business_master_new
loadtime:0.77426910400391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:0.77434015274048 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='5531'DB:business_master_new
loadtime:0.77879405021667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.77886915206909 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='5531'DB:business_master_new
loadtime:0.78337812423706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.78343296051025 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='5531'DB:business_master_new
loadtime:0.787917137146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:0.78797698020935 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='5531'DB:business_master_new
loadtime:0.78876113891602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:0.78882312774658 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='5531'DB:business_master_new
loadtime:0.78968405723572 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.78984713554382 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.79027009010315 / seconds
Operation template executed (chunk cache operation)
loadtime:0.79043197631836 / seconds
template override:Default
loadtime:0.79047417640686 / 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.79190301895142 / seconds
Template Constructed, Array Rows:49
loadtime:0.79243016242981 / seconds
TOTAL EXECUTION TIME: 0.792
loadtime:0.7940239906311 / 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] => auto-and-home-supply-stores [stateURLid] => connecticut )


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