DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00015377998352051 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00092983245849609 / seconds
host not found setting manual db connection
loadtime:0.0014829635620117 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0019378662109375 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0023679733276367 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0025129318237305 / seconds
zipcode:
loadtime:0.0025589466094971 / seconds
Query Executed:select * from search_referrer where page_hash='8d6e7c6ddda791e453cf5f969647c638' limit 10 DB:ezrox_toadli
loadtime:0.0029478073120117 / seconds
Operation header executed (non global)
loadtime:0.002971887588501 / seconds
Operation leaderboard executed (non global)
loadtime:0.0030148029327393 / seconds
Operation square executed (non global)
loadtime:0.0030298233032227 / seconds
Operation square_bottom executed (non global)
loadtime:0.003058910369873 / seconds
Operation smallsquare executed (non global)
loadtime:0.0030789375305176 / seconds
Operation headeradright executed (non global)
loadtime:0.0030977725982666 / seconds
Operation google_analytics executed (non global)
loadtime:0.0031158924102783 / seconds
Operation topstories executed (non global)
loadtime:0.0031359195709229 / seconds
Operation businessnearyou executed (non global)
loadtime:0.003173828125 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0031847953796387 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0034070014953613 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0037620067596436 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0038290023803711 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0039417743682861 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0040497779846191 / seconds
Template key: archive_menu pushed
loadtime:0.0040638446807861 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0040929317474365 / seconds
Template key: get_gravatar pushed
loadtime:0.0041048526763916 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0041148662567139 / seconds
*10)-10)+1 | start:0
loadtime:0.0041718482971191 / seconds
Query loaded from cache:select * from categories where cat_URLid='laundry-and-garment-services-nec'
loadtime:0.0042459964752197 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.0043199062347412 / seconds
DB connected to localhost business_master_new
loadtime:0.0048868656158447 / seconds
Query Executed:select * from `ct_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.090985774993896 / seconds
Query stored in cache : _QUERY_www.toadli.com9f425fbe96524afe31b4ad19732cfd8e
loadtime:0.091770887374878 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='connecticut'
loadtime:0.091808795928955 / seconds
Query Executed:select sum(totalcount) as totalsum from `ct_catmap` where sic='7219'DB:business_master_new
loadtime:0.093495845794678 / seconds
Query stored in cache : _QUERY_www.toadli.com63a13f27cf22cf2e5f6bee928380357e
loadtime:0.093538999557495 / seconds
273 / 11
loadtime:0.093576908111572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abington' limit 1
loadtime:0.0936439037323 / seconds
Query Executed:select id FROM `ct` where city='Abington' && SIC_code='7219'DB:business_master_new
loadtime:0.098444938659668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Amston' limit 1
loadtime:0.0984787940979 / seconds
Query Executed:select id FROM `ct` where city='Amston' && SIC_code='7219'DB:business_master_new
loadtime:0.10794186592102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andover' limit 1
loadtime:0.10798978805542 / seconds
Query Executed:select id FROM `ct` where city='Andover' && SIC_code='7219'DB:business_master_new
loadtime:0.1292519569397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonia' limit 1
loadtime:0.12930798530579 / seconds
Query Executed:select id FROM `ct` where city='Ansonia' && SIC_code='7219'DB:business_master_new
loadtime:0.13027191162109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.13034081459045 / seconds
Query Executed:select id FROM `ct` where city='Ashford' && SIC_code='7219'DB:business_master_new
loadtime:0.1313488483429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.13143181800842 / seconds
Query Executed:select id FROM `ct` where city='Avon' && SIC_code='7219'DB:business_master_new
loadtime:0.13241386413574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ballouville' limit 1
loadtime:0.13247179985046 / seconds
Query Executed:select id FROM `ct` where city='Ballouville' && SIC_code='7219'DB:business_master_new
loadtime:0.13436388969421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baltic' limit 1
loadtime:0.13444685935974 / seconds
Query Executed:select id FROM `ct` where city='Baltic' && SIC_code='7219'DB:business_master_new
loadtime:0.14531898498535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bantam' limit 1
loadtime:0.14535284042358 / seconds
Query Executed:select id FROM `ct` where city='Bantam' && SIC_code='7219'DB:business_master_new
loadtime:0.14632296562195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barkhamsted' limit 1
loadtime:0.14637279510498 / seconds
Query Executed:select id FROM `ct` where city='Barkhamsted' && SIC_code='7219'DB:business_master_new
loadtime:0.14728093147278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beacon Falls' limit 1
loadtime:0.14731478691101 / seconds
Query Executed:select id FROM `ct` where city='Beacon Falls' && SIC_code='7219'DB:business_master_new
loadtime:0.14820981025696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berlin' limit 1
loadtime:0.14825892448425 / seconds
Query Executed:select id FROM `ct` where city='Berlin' && SIC_code='7219'DB:business_master_new
loadtime:0.1491858959198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethany' limit 1
loadtime:0.14922690391541 / seconds
Query Executed:select id FROM `ct` where city='Bethany' && SIC_code='7219'DB:business_master_new
loadtime:0.15014982223511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.15019679069519 / seconds
Query Executed:select id FROM `ct` where city='Bethel' && SIC_code='7219'DB:business_master_new
loadtime:0.1511127948761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethlehem' limit 1
loadtime:0.15116786956787 / seconds
Query Executed:select id FROM `ct` where city='Bethlehem' && SIC_code='7219'DB:business_master_new
loadtime:0.15208697319031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bloomfield' limit 1
loadtime:0.15213584899902 / seconds
Query Executed:select id FROM `ct` where city='Bloomfield' && SIC_code='7219'DB:business_master_new
loadtime:0.15310382843018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.15315079689026 / seconds
Query Executed:select id FROM `ct` where city='Bolton' && SIC_code='7219'DB:business_master_new
loadtime:0.15407180786133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Botsford' limit 1
loadtime:0.15411877632141 / seconds
Query Executed:select id FROM `ct` where city='Botsford' && SIC_code='7219'DB:business_master_new
loadtime:0.16028189659119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bozrah' limit 1
loadtime:0.16034197807312 / seconds
Query Executed:select id FROM `ct` where city='Bozrah' && SIC_code='7219'DB:business_master_new
loadtime:0.16256499290466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branford' limit 1
loadtime:0.16266798973083 / seconds
Query Executed:select id FROM `ct` where city='Branford' && SIC_code='7219'DB:business_master_new
loadtime:0.16483092308044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.16487383842468 / seconds
Query Executed:select id FROM `ct` where city='Bridgeport' && SIC_code='7219'DB:business_master_new
loadtime:0.16577982902527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgewater' limit 1
loadtime:0.16583490371704 / seconds
Query Executed:select id FROM `ct` where city='Bridgewater' && SIC_code='7219'DB:business_master_new
loadtime:0.1667308807373 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bristol' limit 1
loadtime:0.16676688194275 / seconds
Query Executed:select id FROM `ct` where city='Bristol' && SIC_code='7219'DB:business_master_new
loadtime:0.16765785217285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broad Brook' limit 1
loadtime:0.16771388053894 / seconds
Query Executed:select id FROM `ct` where city='Broad Brook' && SIC_code='7219'DB:business_master_new
loadtime:0.16863679885864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookfield' limit 1
loadtime:0.16868591308594 / seconds
Query Executed:select id FROM `ct` where city='Brookfield' && SIC_code='7219'DB:business_master_new
loadtime:0.16960883140564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.16965794563293 / seconds
Query Executed:select id FROM `ct` where city='Brooklyn' && SIC_code='7219'DB:business_master_new
loadtime:0.17055797576904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.17060399055481 / seconds
Query Executed:select id FROM `ct` where city='Burlington' && SIC_code='7219'DB:business_master_new
loadtime:0.17152690887451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canaan' limit 1
loadtime:0.17156195640564 / seconds
Query Executed:select id FROM `ct` where city='Canaan' && SIC_code='7219'DB:business_master_new
loadtime:0.17247891426086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canterbury' limit 1
loadtime:0.1730318069458 / seconds
Query Executed:select id FROM `ct` where city='Canterbury' && SIC_code='7219'DB:business_master_new
loadtime:0.17414093017578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:0.17422389984131 / seconds
Query Executed:select id FROM `ct` where city='Canton' && SIC_code='7219'DB:business_master_new
loadtime:0.17583894729614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton Center' limit 1
loadtime:0.1758987903595 / seconds
Query Executed:select id FROM `ct` where city='Canton Center' && SIC_code='7219'DB:business_master_new
loadtime:0.18074989318848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerbrook' limit 1
loadtime:0.18079781532288 / seconds
Query Executed:select id FROM `ct` where city='Centerbrook' && SIC_code='7219'DB:business_master_new
loadtime:0.1817798614502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Village' limit 1
loadtime:0.18185186386108 / seconds
Query Executed:select id FROM `ct` where city='Central Village' && SIC_code='7219'DB:business_master_new
loadtime:0.18778896331787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chaplin' limit 1
loadtime:0.18783688545227 / seconds
Query Executed:select id FROM `ct` where city='Chaplin' && SIC_code='7219'DB:business_master_new
loadtime:0.18872094154358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cheshire' limit 1
loadtime:0.18876886367798 / seconds
Query Executed:select id FROM `ct` where city='Cheshire' && SIC_code='7219'DB:business_master_new
loadtime:0.18968391418457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.18973898887634 / seconds
Query Executed:select id FROM `ct` where city='Chester' && SIC_code='7219'DB:business_master_new
loadtime:0.19064998626709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.19070196151733 / seconds
Query Executed:select id FROM `ct` where city='Clinton' && SIC_code='7219'DB:business_master_new
loadtime:0.19165682792664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cobalt' limit 1
loadtime:0.19171285629272 / seconds
Query Executed:select id FROM `ct` where city='Cobalt' && SIC_code='7219'DB:business_master_new
loadtime:0.19488286972046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colchester' limit 1
loadtime:0.19491696357727 / seconds
Query Executed:select id FROM `ct` where city='Colchester' && SIC_code='7219'DB:business_master_new
loadtime:0.19676184654236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colebrook' limit 1
loadtime:0.1968309879303 / seconds
Query Executed:select id FROM `ct` where city='Colebrook' && SIC_code='7219'DB:business_master_new
loadtime:0.20136094093323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.20139598846436 / seconds
Query Executed:select id FROM `ct` where city='Collinsville' && SIC_code='7219'DB:business_master_new
loadtime:0.21050095558167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.21054983139038 / seconds
Query Executed:select id FROM `ct` where city='Columbia' && SIC_code='7219'DB:business_master_new
loadtime:0.21148180961609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall' limit 1
loadtime:0.21151685714722 / seconds
Query Executed:select id FROM `ct` where city='Cornwall' && SIC_code='7219'DB:business_master_new
loadtime:0.21783685684204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornwall Bridge' limit 1
loadtime:0.21788477897644 / seconds
Query Executed:select id FROM `ct` where city='Cornwall Bridge' && SIC_code='7219'DB:business_master_new
loadtime:0.21836996078491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cos Cob' limit 1
loadtime:0.21843886375427 / seconds
Query Executed:select id FROM `ct` where city='Cos Cob' && SIC_code='7219'DB:business_master_new
loadtime:0.21940994262695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coventry' limit 1
loadtime:0.21944499015808 / seconds
Query Executed:select id FROM `ct` where city='Coventry' && SIC_code='7219'DB:business_master_new
loadtime:0.22036981582642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.22041893005371 / seconds
Query Executed:select id FROM `ct` where city='Cromwell' && SIC_code='7219'DB:business_master_new
loadtime:0.22137379646301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:0.22142291069031 / seconds
Query Executed:select id FROM `ct` where city='Danbury' && SIC_code='7219'DB:business_master_new
loadtime:0.22235488891602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danielson' limit 1
loadtime:0.22239780426025 / seconds
Query Executed:select id FROM `ct` where city='Danielson' && SIC_code='7219'DB:business_master_new
loadtime:0.22331786155701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Darien' limit 1
loadtime:0.2233669757843 / seconds
Query Executed:select id FROM `ct` where city='Darien' && SIC_code='7219'DB:business_master_new
loadtime:0.22432899475098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dayville' limit 1
loadtime:0.22503590583801 / seconds
Query Executed:select id FROM `ct` where city='Dayville' && SIC_code='7219'DB:business_master_new
loadtime:0.22602891921997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep River' limit 1
loadtime:0.22607684135437 / seconds
Query Executed:select id FROM `ct` where city='Deep River' && SIC_code='7219'DB:business_master_new
loadtime:0.22700691223145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Derby' limit 1
loadtime:0.22704696655273 / seconds
Query Executed:select id FROM `ct` where city='Derby' && SIC_code='7219'DB:business_master_new
loadtime:0.22797298431396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:0.22801995277405 / seconds
Query Executed:select id FROM `ct` where city='Durham' && SIC_code='7219'DB:business_master_new
loadtime:0.22892689704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Berlin' limit 1
loadtime:0.22897386550903 / seconds
Query Executed:select id FROM `ct` where city='East Berlin' && SIC_code='7219'DB:business_master_new
loadtime:0.22986698150635 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Canaan' limit 1
loadtime:0.22990798950195 / seconds
Query Executed:select id FROM `ct` where city='East Canaan' && SIC_code='7219'DB:business_master_new
loadtime:0.23589491844177 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Glastonbury' limit 1
loadtime:0.23594188690186 / seconds
Query Executed:select id FROM `ct` where city='East Glastonbury' && SIC_code='7219'DB:business_master_new
loadtime:0.23824286460876 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Granby' limit 1
loadtime:0.23827791213989 / seconds
Query Executed:select id FROM `ct` where city='East Granby' && SIC_code='7219'DB:business_master_new
loadtime:0.23921895027161 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haddam' limit 1
loadtime:0.23926687240601 / seconds
Query Executed:select id FROM `ct` where city='East Haddam' && SIC_code='7219'DB:business_master_new
loadtime:0.24027299880981 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hampton' limit 1
loadtime:0.24031281471252 / seconds
Query Executed:select id FROM `ct` where city='East Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.24126482009888 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartford' limit 1
loadtime:0.24132084846497 / seconds
Query Executed:select id FROM `ct` where city='East Hartford' && SIC_code='7219'DB:business_master_new
loadtime:0.24224281311035 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Hartland' limit 1
loadtime:0.24229884147644 / seconds
Query Executed:select id FROM `ct` where city='East Hartland' && SIC_code='7219'DB:business_master_new
loadtime:0.25089287757874 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Haven' limit 1
loadtime:0.25092792510986 / seconds
Query Executed:select id FROM `ct` where city='East Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.25184679031372 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Killingly' limit 1
loadtime:0.25189590454102 / seconds
Query Executed:select id FROM `ct` where city='East Killingly' && SIC_code='7219'DB:business_master_new
loadtime:0.25429892539978 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lyme' limit 1
loadtime:0.25433278083801 / seconds
Query Executed:select id FROM `ct` where city='East Lyme' && SIC_code='7219'DB:business_master_new
loadtime:0.25525689125061 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor' limit 1
loadtime:0.25530600547791 / seconds
Query Executed:select id FROM `ct` where city='East Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.25623679161072 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Windsor Hill' limit 1
loadtime:0.25627779960632 / seconds
Query Executed:select id FROM `ct` where city='East Windsor Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.2593879699707 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Woodstock' limit 1
loadtime:0.2594358921051 / seconds
Query Executed:select id FROM `ct` where city='East Woodstock' && SIC_code='7219'DB:business_master_new
loadtime:0.26349592208862 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastford' limit 1
loadtime:0.26353096961975 / seconds
Query Executed:select id FROM `ct` where city='Eastford' && SIC_code='7219'DB:business_master_new
loadtime:0.26402688026428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Easton' limit 1
loadtime:0.26407480239868 / seconds
Query Executed:select id FROM `ct` where city='Easton' && SIC_code='7219'DB:business_master_new
loadtime:0.2650318145752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellington' limit 1
loadtime:0.26508092880249 / seconds
Query Executed:select id FROM `ct` where city='Ellington' && SIC_code='7219'DB:business_master_new
loadtime:0.26600790023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:0.26605486869812 / seconds
Query Executed:select id FROM `ct` where city='Enfield' && SIC_code='7219'DB:business_master_new
loadtime:0.26698088645935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Essex' limit 1
loadtime:0.26701593399048 / seconds
Query Executed:select id FROM `ct` where city='Essex' && SIC_code='7219'DB:business_master_new
loadtime:0.26793384552002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fabyan' limit 1
loadtime:0.26837277412415 / seconds
Query Executed:select id FROM `ct` where city='Fabyan' && SIC_code='7219'DB:business_master_new
loadtime:0.26884198188782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.26887392997742 / seconds
Query Executed:select id FROM `ct` where city='Fairfield' && SIC_code='7219'DB:business_master_new
loadtime:0.26978492736816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falls Village' limit 1
loadtime:0.26983499526978 / seconds
Query Executed:select id FROM `ct` where city='Falls Village' && SIC_code='7219'DB:business_master_new
loadtime:0.27032995223999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.27042889595032 / seconds
Query Executed:select id FROM `ct` where city='Farmington' && SIC_code='7219'DB:business_master_new
loadtime:0.27211999893188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gales Ferry' limit 1
loadtime:0.27219486236572 / seconds
Query Executed:select id FROM `ct` where city='Gales Ferry' && SIC_code='7219'DB:business_master_new
loadtime:0.27348399162292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylordsville' limit 1
loadtime:0.27353477478027 / seconds
Query Executed:select id FROM `ct` where city='Gaylordsville' && SIC_code='7219'DB:business_master_new
loadtime:0.28273892402649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgetown' limit 1
loadtime:0.28278779983521 / seconds
Query Executed:select id FROM `ct` where city='Georgetown' && SIC_code='7219'DB:business_master_new
loadtime:0.28371596336365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilman' limit 1
loadtime:0.28375387191772 / seconds
Query Executed:select id FROM `ct` where city='Gilman' && SIC_code='7219'DB:business_master_new
loadtime:0.28480792045593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glasgo' limit 1
loadtime:0.28483581542969 / seconds
Query Executed:select id FROM `ct` where city='Glasgo' && SIC_code='7219'DB:business_master_new
loadtime:0.28621387481689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glastonbury' limit 1
loadtime:0.2862548828125 / seconds
Query Executed:select id FROM `ct` where city='Glastonbury' && SIC_code='7219'DB:business_master_new
loadtime:0.28726387023926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.28730797767639 / seconds
Query Executed:select id FROM `ct` where city='Goshen' && SIC_code='7219'DB:business_master_new
loadtime:0.28820490837097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granby' limit 1
loadtime:0.28823089599609 / seconds
Query Executed:select id FROM `ct` where city='Granby' && SIC_code='7219'DB:business_master_new
loadtime:0.28913497924805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greens Farms' limit 1
loadtime:0.28917098045349 / seconds
Query Executed:select id FROM `ct` where city='Greens Farms' && SIC_code='7219'DB:business_master_new
loadtime:0.29908180236816 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.29912185668945 / seconds
Query Executed:select id FROM `ct` where city='Greenwich' && SIC_code='7219'DB:business_master_new
loadtime:0.30013489723206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grosvenor Dale' limit 1
loadtime:0.30019283294678 / seconds
Query Executed:select id FROM `ct` where city='Grosvenor Dale' && SIC_code='7219'DB:business_master_new
loadtime:0.30172181129456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groton' limit 1
loadtime:0.30175685882568 / seconds
Query Executed:select id FROM `ct` where city='Groton' && SIC_code='7219'DB:business_master_new
loadtime:0.30265498161316 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guilford' limit 1
loadtime:0.30270290374756 / seconds
Query Executed:select id FROM `ct` where city='Guilford' && SIC_code='7219'DB:business_master_new
loadtime:0.30363082885742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haddam' limit 1
loadtime:0.30367279052734 / seconds
Query Executed:select id FROM `ct` where city='Haddam' && SIC_code='7219'DB:business_master_new
loadtime:0.30464291572571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hadlyme' limit 1
loadtime:0.30468893051147 / seconds
Query Executed:select id FROM `ct` where city='Hadlyme' && SIC_code='7219'DB:business_master_new
loadtime:0.30838084220886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamden' limit 1
loadtime:0.30842900276184 / seconds
Query Executed:select id FROM `ct` where city='Hamden' && SIC_code='7219'DB:business_master_new
loadtime:0.30937886238098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampton' limit 1
loadtime:0.30944895744324 / seconds
Query Executed:select id FROM `ct` where city='Hampton' && SIC_code='7219'DB:business_master_new
loadtime:0.32759380340576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanover' limit 1
loadtime:0.32765293121338 / seconds
Query Executed:select id FROM `ct` where city='Hanover' && SIC_code='7219'DB:business_master_new
loadtime:0.33004593849182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:0.33008694648743 / seconds
Query Executed:select id FROM `ct` where city='Hartford' && SIC_code='7219'DB:business_master_new
loadtime:0.33106589317322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harwinton' limit 1
loadtime:0.33112287521362 / seconds
Query Executed:select id FROM `ct` where city='Harwinton' && SIC_code='7219'DB:business_master_new
loadtime:0.33205890655518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawleyville' limit 1
loadtime:0.33209991455078 / seconds
Query Executed:select id FROM `ct` where city='Hawleyville' && SIC_code='7219'DB:business_master_new
loadtime:0.33839297294617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hebron' limit 1
loadtime:0.33844184875488 / seconds
Query Executed:select id FROM `ct` where city='Hebron' && SIC_code='7219'DB:business_master_new
loadtime:0.33936381340027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higganum' limit 1
loadtime:0.33939790725708 / seconds
Query Executed:select id FROM `ct` where city='Higganum' && SIC_code='7219'DB:business_master_new
loadtime:0.34033989906311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivoryton' limit 1
loadtime:0.34038996696472 / seconds
Query Executed:select id FROM `ct` where city='Ivoryton' && SIC_code='7219'DB:business_master_new
loadtime:0.34090089797974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jewett City' limit 1
loadtime:0.34094882011414 / seconds
Query Executed:select id FROM `ct` where city='Jewett City' && SIC_code='7219'DB:business_master_new
loadtime:0.34186792373657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kent' limit 1
loadtime:0.34191584587097 / seconds
Query Executed:select id FROM `ct` where city='Kent' && SIC_code='7219'DB:business_master_new
loadtime:0.34283089637756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killingworth' limit 1
loadtime:0.34286594390869 / seconds
Query Executed:select id FROM `ct` where city='Killingworth' && SIC_code='7219'DB:business_master_new
loadtime:0.34375691413879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeside' limit 1
loadtime:0.34380388259888 / seconds
Query Executed:select id FROM `ct` where city='Lakeside' && SIC_code='7219'DB:business_master_new
loadtime:0.3470618724823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeville' limit 1
loadtime:0.34710884094238 / seconds
Query Executed:select id FROM `ct` where city='Lakeville' && SIC_code='7219'DB:business_master_new
loadtime:0.34802484512329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lebanon' limit 1
loadtime:0.34805989265442 / seconds
Query Executed:select id FROM `ct` where city='Lebanon' && SIC_code='7219'DB:business_master_new
loadtime:0.34902191162109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ledyard' limit 1
loadtime:0.34907078742981 / seconds
Query Executed:select id FROM `ct` where city='Ledyard' && SIC_code='7219'DB:business_master_new
loadtime:0.35001182556152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Litchfield' limit 1
loadtime:0.35006189346313 / seconds
Query Executed:select id FROM `ct` where city='Litchfield' && SIC_code='7219'DB:business_master_new
loadtime:0.350989818573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:0.35103988647461 / seconds
Query Executed:select id FROM `ct` where city='Madison' && SIC_code='7219'DB:business_master_new
loadtime:0.35195779800415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manchester' limit 1
loadtime:0.35201287269592 / seconds
Query Executed:select id FROM `ct` where city='Manchester' && SIC_code='7219'DB:business_master_new
loadtime:0.35296392440796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Center' limit 1
loadtime:0.35300779342651 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Center' && SIC_code='7219'DB:business_master_new
loadtime:0.35394382476807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mansfield Depot' limit 1
loadtime:0.35400080680847 / seconds
Query Executed:select id FROM `ct` where city='Mansfield Depot' && SIC_code='7219'DB:business_master_new
loadtime:0.35678291320801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble Dale' limit 1
loadtime:0.3568229675293 / seconds
Query Executed:select id FROM `ct` where city='Marble Dale' && SIC_code='7219'DB:business_master_new
loadtime:0.35785698890686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:0.35790491104126 / seconds
Query Executed:select id FROM `ct` where city='Marion' && SIC_code='7219'DB:business_master_new
loadtime:0.3656108379364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marlborough' limit 1
loadtime:0.36567497253418 / seconds
Query Executed:select id FROM `ct` where city='Marlborough' && SIC_code='7219'DB:business_master_new
loadtime:0.3666079044342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meriden' limit 1
loadtime:0.3666558265686 / seconds
Query Executed:select id FROM `ct` where city='Meriden' && SIC_code='7219'DB:business_master_new
loadtime:0.36762881278992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middle Haddam' limit 1
loadtime:0.36768388748169 / seconds
Query Executed:select id FROM `ct` where city='Middle Haddam' && SIC_code='7219'DB:business_master_new
loadtime:0.37220191955566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlebury' limit 1
loadtime:0.37223696708679 / seconds
Query Executed:select id FROM `ct` where city='Middlebury' && SIC_code='7219'DB:business_master_new
loadtime:0.37319278717041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlefield' limit 1
loadtime:0.37324190139771 / seconds
Query Executed:select id FROM `ct` where city='Middlefield' && SIC_code='7219'DB:business_master_new
loadtime:0.37418985366821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middletown' limit 1
loadtime:0.37422490119934 / seconds
Query Executed:select id FROM `ct` where city='Middletown' && SIC_code='7219'DB:business_master_new
loadtime:0.37515377998352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.37519979476929 / seconds
Query Executed:select id FROM `ct` where city='Milford' && SIC_code='7219'DB:business_master_new
loadtime:0.37613081932068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milldale' limit 1
loadtime:0.37616586685181 / seconds
Query Executed:select id FROM `ct` where city='Milldale' && SIC_code='7219'DB:business_master_new
loadtime:0.38848185539246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.38852977752686 / seconds
Query Executed:select id FROM `ct` where city='Monroe' && SIC_code='7219'DB:business_master_new
loadtime:0.38945198059082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montville' limit 1
loadtime:0.38949179649353 / seconds
Query Executed:select id FROM `ct` where city='Montville' && SIC_code='7219'DB:business_master_new
loadtime:0.39551877975464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moodus' limit 1
loadtime:0.39554786682129 / seconds
Query Executed:select id FROM `ct` where city='Moodus' && SIC_code='7219'DB:business_master_new
loadtime:0.39645385742188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moosup' limit 1
loadtime:0.39649391174316 / seconds
Query Executed:select id FROM `ct` where city='Moosup' && SIC_code='7219'DB:business_master_new
loadtime:0.3969988822937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:0.39704084396362 / seconds
Query Executed:select id FROM `ct` where city='Morris' && SIC_code='7219'DB:business_master_new
loadtime:0.39796876907349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mystic' limit 1
loadtime:0.39800381660461 / seconds
Query Executed:select id FROM `ct` where city='Mystic' && SIC_code='7219'DB:business_master_new
loadtime:0.39892983436584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naugatuck' limit 1
loadtime:0.39897894859314 / seconds
Query Executed:select id FROM `ct` where city='Naugatuck' && SIC_code='7219'DB:business_master_new
loadtime:0.39991593360901 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Britain' limit 1
loadtime:0.39995098114014 / seconds
Query Executed:select id FROM `ct` where city='New Britain' && SIC_code='7219'DB:business_master_new
loadtime:0.4008629322052 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Canaan' limit 1
loadtime:0.40092086791992 / seconds
Query Executed:select id FROM `ct` where city='New Canaan' && SIC_code='7219'DB:business_master_new
loadtime:0.40182590484619 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Fairfield' limit 1
loadtime:0.4018759727478 / seconds
Query Executed:select id FROM `ct` where city='New Fairfield' && SIC_code='7219'DB:business_master_new
loadtime:0.40276288986206 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hartford' limit 1
loadtime:0.40280985832214 / seconds
Query Executed:select id FROM `ct` where city='New Hartford' && SIC_code='7219'DB:business_master_new
loadtime:0.4037458896637 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Haven' limit 1
loadtime:0.4037868976593 / seconds
Query Executed:select id FROM `ct` where city='New Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.40467381477356 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:0.40473580360413 / seconds
Query Executed:select id FROM `ct` where city='New London' && SIC_code='7219'DB:business_master_new
loadtime:0.40565299987793 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Milford' limit 1
loadtime:0.40568780899048 / seconds
Query Executed:select id FROM `ct` where city='New Milford' && SIC_code='7219'DB:business_master_new
loadtime:0.40660095214844 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Preston Marble Dale' limit 1
loadtime:0.40666484832764 / seconds
Query Executed:select id FROM `ct` where city='New Preston Marble Dale' && SIC_code='7219'DB:business_master_new
loadtime:0.40756392478943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newington' limit 1
loadtime:0.40760588645935 / seconds
Query Executed:select id FROM `ct` where city='Newington' && SIC_code='7219'DB:business_master_new
loadtime:0.40860486030579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newtown' limit 1
loadtime:0.40866589546204 / seconds
Query Executed:select id FROM `ct` where city='Newtown' && SIC_code='7219'DB:business_master_new
loadtime:0.40960693359375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Niantic' limit 1
loadtime:0.40965485572815 / seconds
Query Executed:select id FROM `ct` where city='Niantic' && SIC_code='7219'DB:business_master_new
loadtime:0.41060900688171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norfolk' limit 1
loadtime:0.41067790985107 / seconds
Query Executed:select id FROM `ct` where city='Norfolk' && SIC_code='7219'DB:business_master_new
loadtime:0.41159081459045 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Branford' limit 1
loadtime:0.41164994239807 / seconds
Query Executed:select id FROM `ct` where city='North Branford' && SIC_code='7219'DB:business_master_new
loadtime:0.41254281997681 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Canton' limit 1
loadtime:0.41257786750793 / seconds
Query Executed:select id FROM `ct` where city='North Canton' && SIC_code='7219'DB:business_master_new
loadtime:0.41474795341492 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Franklin' limit 1
loadtime:0.41480898857117 / seconds
Query Executed:select id FROM `ct` where city='North Franklin' && SIC_code='7219'DB:business_master_new
loadtime:0.41610097885132 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Granby' limit 1
loadtime:0.4161388874054 / seconds
Query Executed:select id FROM `ct` where city='North Granby' && SIC_code='7219'DB:business_master_new
loadtime:0.41663479804993 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Grosvenordale' limit 1
loadtime:0.41668391227722 / seconds
Query Executed:select id FROM `ct` where city='North Grosvenordale' && SIC_code='7219'DB:business_master_new
loadtime:0.41715478897095 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Haven' limit 1
loadtime:0.41718983650208 / seconds
Query Executed:select id FROM `ct` where city='North Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.41812896728516 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Stonington' limit 1
loadtime:0.41818380355835 / seconds
Query Executed:select id FROM `ct` where city='North Stonington' && SIC_code='7219'DB:business_master_new
loadtime:0.41909980773926 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Westchester' limit 1
loadtime:0.4191358089447 / seconds
Query Executed:select id FROM `ct` where city='North Westchester' && SIC_code='7219'DB:business_master_new
loadtime:0.4201328754425 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Windham' limit 1
loadtime:0.42019200325012 / seconds
Query Executed:select id FROM `ct` where city='North Windham' && SIC_code='7219'DB:business_master_new
loadtime:0.42111682891846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northfield' limit 1
loadtime:0.42115378379822 / seconds
Query Executed:select id FROM `ct` where city='Northfield' && SIC_code='7219'DB:business_master_new
loadtime:0.42910385131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northford' limit 1
loadtime:0.42914581298828 / seconds
Query Executed:select id FROM `ct` where city='Northford' && SIC_code='7219'DB:business_master_new
loadtime:0.4300549030304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwalk' limit 1
loadtime:0.43008279800415 / seconds
Query Executed:select id FROM `ct` where city='Norwalk' && SIC_code='7219'DB:business_master_new
loadtime:0.43096995353699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwich' limit 1
loadtime:0.43101477622986 / seconds
Query Executed:select id FROM `ct` where city='Norwich' && SIC_code='7219'DB:business_master_new
loadtime:0.43189883232117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakdale' limit 1
loadtime:0.43193578720093 / seconds
Query Executed:select id FROM `ct` where city='Oakdale' && SIC_code='7219'DB:business_master_new
loadtime:0.43286800384521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakville' limit 1
loadtime:0.43290781974792 / seconds
Query Executed:select id FROM `ct` where city='Oakville' && SIC_code='7219'DB:business_master_new
loadtime:0.43379688262939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Greenwich' limit 1
loadtime:0.43383979797363 / seconds
Query Executed:select id FROM `ct` where city='Old Greenwich' && SIC_code='7219'DB:business_master_new
loadtime:0.43474078178406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Lyme' limit 1
loadtime:0.43477487564087 / seconds
Query Executed:select id FROM `ct` where city='Old Lyme' && SIC_code='7219'DB:business_master_new
loadtime:0.43567299842834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Mystic' limit 1
loadtime:0.43570995330811 / seconds
Query Executed:select id FROM `ct` where city='Old Mystic' && SIC_code='7219'DB:business_master_new
loadtime:0.44403195381165 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Saybrook' limit 1
loadtime:0.44406795501709 / seconds
Query Executed:select id FROM `ct` where city='Old Saybrook' && SIC_code='7219'DB:business_master_new
loadtime:0.44499397277832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneco' limit 1
loadtime:0.44504499435425 / seconds
Query Executed:select id FROM `ct` where city='Oneco' && SIC_code='7219'DB:business_master_new
loadtime:0.4481508731842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange' limit 1
loadtime:0.44819188117981 / seconds
Query Executed:select id FROM `ct` where city='Orange' && SIC_code='7219'DB:business_master_new
loadtime:0.44910287857056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:0.44912886619568 / seconds
Query Executed:select id FROM `ct` where city='Oxford' && SIC_code='7219'DB:business_master_new
loadtime:0.45006489753723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pawcatuck' limit 1
loadtime:0.45010185241699 / seconds
Query Executed:select id FROM `ct` where city='Pawcatuck' && SIC_code='7219'DB:business_master_new
loadtime:0.45101881027222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pequabuck' limit 1
loadtime:0.45104384422302 / seconds
Query Executed:select id FROM `ct` where city='Pequabuck' && SIC_code='7219'DB:business_master_new
loadtime:0.45404291152954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Meadow' limit 1
loadtime:0.45407891273499 / seconds
Query Executed:select id FROM `ct` where city='Pine Meadow' && SIC_code='7219'DB:business_master_new
loadtime:0.4568498134613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainfield' limit 1
loadtime:0.45688486099243 / seconds
Query Executed:select id FROM `ct` where city='Plainfield' && SIC_code='7219'DB:business_master_new
loadtime:0.45777988433838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plainville' limit 1
loadtime:0.45782995223999 / seconds
Query Executed:select id FROM `ct` where city='Plainville' && SIC_code='7219'DB:business_master_new
loadtime:0.45875477790833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantsville' limit 1
loadtime:0.45879077911377 / seconds
Query Executed:select id FROM `ct` where city='Plantsville' && SIC_code='7219'DB:business_master_new
loadtime:0.45969796180725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Valley' limit 1
loadtime:0.45974683761597 / seconds
Query Executed:select id FROM `ct` where city='Pleasant Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.46058583259583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.46065592765808 / seconds
Query Executed:select id FROM `ct` where city='Plymouth' && SIC_code='7219'DB:business_master_new
loadtime:0.46158599853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret' limit 1
loadtime:0.46164679527283 / seconds
Query Executed:select id FROM `ct` where city='Pomfret' && SIC_code='7219'DB:business_master_new
loadtime:0.46835684776306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pomfret Center' limit 1
loadtime:0.46839189529419 / seconds
Query Executed:select id FROM `ct` where city='Pomfret Center' && SIC_code='7219'DB:business_master_new
loadtime:0.46937394142151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poquonock' limit 1
loadtime:0.46941685676575 / seconds
Query Executed:select id FROM `ct` where city='Poquonock' && SIC_code='7219'DB:business_master_new
loadtime:0.4732677936554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portland' limit 1
loadtime:0.47329688072205 / seconds
Query Executed:select id FROM `ct` where city='Portland' && SIC_code='7219'DB:business_master_new
loadtime:0.47418999671936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Preston' limit 1
loadtime:0.47422885894775 / seconds
Query Executed:select id FROM `ct` where city='Preston' && SIC_code='7219'DB:business_master_new
loadtime:0.47514081001282 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect' limit 1
loadtime:0.47518086433411 / seconds
Query Executed:select id FROM `ct` where city='Prospect' && SIC_code='7219'DB:business_master_new
loadtime:0.4760959148407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Putnam' limit 1
loadtime:0.4761209487915 / seconds
Query Executed:select id FROM `ct` where city='Putnam' && SIC_code='7219'DB:business_master_new
loadtime:0.47707486152649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quaker Hill' limit 1
loadtime:0.47712397575378 / seconds
Query Executed:select id FROM `ct` where city='Quaker Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.47804188728333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinebaug' limit 1
loadtime:0.47810482978821 / seconds
Query Executed:select id FROM `ct` where city='Quinebaug' && SIC_code='7219'DB:business_master_new
loadtime:0.48226594924927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding' limit 1
loadtime:0.48230195045471 / seconds
Query Executed:select id FROM `ct` where city='Redding' && SIC_code='7219'DB:business_master_new
loadtime:0.48320198059082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Center' limit 1
loadtime:0.48324394226074 / seconds
Query Executed:select id FROM `ct` where city='Redding Center' && SIC_code='7219'DB:business_master_new
loadtime:0.48730278015137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redding Ridge' limit 1
loadtime:0.48733186721802 / seconds
Query Executed:select id FROM `ct` where city='Redding Ridge' && SIC_code='7219'DB:business_master_new
loadtime:0.49356293678284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgefield' limit 1
loadtime:0.49360299110413 / seconds
Query Executed:select id FROM `ct` where city='Ridgefield' && SIC_code='7219'DB:business_master_new
loadtime:0.4945228099823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.49455690383911 / seconds
Query Executed:select id FROM `ct` where city='Riverside' && SIC_code='7219'DB:business_master_new
loadtime:0.4955039024353 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.49554181098938 / seconds
Query Executed:select id FROM `ct` where city='Riverton' && SIC_code='7219'DB:business_master_new
loadtime:0.50044393539429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockfall' limit 1
loadtime:0.500492811203 / seconds
Query Executed:select id FROM `ct` where city='Rockfall' && SIC_code='7219'DB:business_master_new
loadtime:0.51127099990845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Hill' limit 1
loadtime:0.51130700111389 / seconds
Query Executed:select id FROM `ct` where city='Rocky Hill' && SIC_code='7219'DB:business_master_new
loadtime:0.51227784156799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogers' limit 1
loadtime:0.51233291625977 / seconds
Query Executed:select id FROM `ct` where city='Rogers' && SIC_code='7219'DB:business_master_new
loadtime:0.51584887504578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxbury' limit 1
loadtime:0.51589679718018 / seconds
Query Executed:select id FROM `ct` where city='Roxbury' && SIC_code='7219'DB:business_master_new
loadtime:0.5168240070343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.51687288284302 / seconds
Query Executed:select id FROM `ct` where city='Salem' && SIC_code='7219'DB:business_master_new
loadtime:0.51777696609497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:0.51781892776489 / seconds
Query Executed:select id FROM `ct` where city='Salisbury' && SIC_code='7219'DB:business_master_new
loadtime:0.5187029838562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Hook' limit 1
loadtime:0.51875185966492 / seconds
Query Executed:select id FROM `ct` where city='Sandy Hook' && SIC_code='7219'DB:business_master_new
loadtime:0.51964688301086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland' limit 1
loadtime:0.51968193054199 / seconds
Query Executed:select id FROM `ct` where city='Scotland' && SIC_code='7219'DB:business_master_new
loadtime:0.52868485450745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seymour' limit 1
loadtime:0.52874994277954 / seconds
Query Executed:select id FROM `ct` where city='Seymour' && SIC_code='7219'DB:business_master_new
loadtime:0.52971696853638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharon' limit 1
loadtime:0.52975177764893 / seconds
Query Executed:select id FROM `ct` where city='Sharon' && SIC_code='7219'DB:business_master_new
loadtime:0.53065800666809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelton' limit 1
loadtime:0.53070592880249 / seconds
Query Executed:select id FROM `ct` where city='Shelton' && SIC_code='7219'DB:business_master_new
loadtime:0.53165078163147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherman' limit 1
loadtime:0.53170490264893 / seconds
Query Executed:select id FROM `ct` where city='Sherman' && SIC_code='7219'DB:business_master_new
loadtime:0.53260588645935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simsbury' limit 1
loadtime:0.53266596794128 / seconds
Query Executed:select id FROM `ct` where city='Simsbury' && SIC_code='7219'DB:business_master_new
loadtime:0.53360795974731 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somers' limit 1
loadtime:0.53366994857788 / seconds
Query Executed:select id FROM `ct` where city='Somers' && SIC_code='7219'DB:business_master_new
loadtime:0.53457689285278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somersville' limit 1
loadtime:0.53461194038391 / seconds
Query Executed:select id FROM `ct` where city='Somersville' && SIC_code='7219'DB:business_master_new
loadtime:0.53840088844299 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Britain' limit 1
loadtime:0.53844690322876 / seconds
Query Executed:select id FROM `ct` where city='South Britain' && SIC_code='7219'DB:business_master_new
loadtime:0.54059100151062 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Glastonbury' limit 1
loadtime:0.54063987731934 / seconds
Query Executed:select id FROM `ct` where city='South Glastonbury' && SIC_code='7219'DB:business_master_new
loadtime:0.54158496856689 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Kent' limit 1
loadtime:0.54164791107178 / seconds
Query Executed:select id FROM `ct` where city='South Kent' && SIC_code='7219'DB:business_master_new
loadtime:0.54960083961487 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Lyme' limit 1
loadtime:0.54964780807495 / seconds
Query Executed:select id FROM `ct` where city='South Lyme' && SIC_code='7219'DB:business_master_new
loadtime:0.55210185050964 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Willington' limit 1
loadtime:0.55215191841125 / seconds
Query Executed:select id FROM `ct` where city='South Willington' && SIC_code='7219'DB:business_master_new
loadtime:0.5534188747406 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windham' limit 1
loadtime:0.55345392227173 / seconds
Query Executed:select id FROM `ct` where city='South Windham' && SIC_code='7219'DB:business_master_new
loadtime:0.5603358745575 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Windsor' limit 1
loadtime:0.56038498878479 / seconds
Query Executed:select id FROM `ct` where city='South Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.56135678291321 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Woodstock' limit 1
loadtime:0.56140685081482 / seconds
Query Executed:select id FROM `ct` where city='South Woodstock' && SIC_code='7219'DB:business_master_new
loadtime:0.56763887405396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southbury' limit 1
loadtime:0.56767582893372 / seconds
Query Executed:select id FROM `ct` where city='Southbury' && SIC_code='7219'DB:business_master_new
loadtime:0.56860280036926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southington' limit 1
loadtime:0.56866383552551 / seconds
Query Executed:select id FROM `ct` where city='Southington' && SIC_code='7219'DB:business_master_new
loadtime:0.56964993476868 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:0.56969285011292 / seconds
Query Executed:select id FROM `ct` where city='Southport' && SIC_code='7219'DB:business_master_new
loadtime:0.57060885429382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford' limit 1
loadtime:0.57066893577576 / seconds
Query Executed:select id FROM `ct` where city='Stafford' && SIC_code='7219'DB:business_master_new
loadtime:0.57746577262878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stafford Springs' limit 1
loadtime:0.57750082015991 / seconds
Query Executed:select id FROM `ct` where city='Stafford Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.57844185829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staffordville' limit 1
loadtime:0.57849097251892 / seconds
Query Executed:select id FROM `ct` where city='Staffordville' && SIC_code='7219'DB:business_master_new
loadtime:0.58399891853333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stamford' limit 1
loadtime:0.58404088020325 / seconds
Query Executed:select id FROM `ct` where city='Stamford' && SIC_code='7219'DB:business_master_new
loadtime:0.58502793312073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.5850818157196 / seconds
Query Executed:select id FROM `ct` where city='Sterling' && SIC_code='7219'DB:business_master_new
loadtime:0.595782995224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:0.59586596488953 / seconds
Query Executed:select id FROM `ct` where city='Stevenson' && SIC_code='7219'DB:business_master_new
loadtime:0.60079979896545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonington' limit 1
loadtime:0.60083484649658 / seconds
Query Executed:select id FROM `ct` where city='Stonington' && SIC_code='7219'DB:business_master_new
loadtime:0.60174798965454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Storrs Mansfield' limit 1
loadtime:0.60179495811462 / seconds
Query Executed:select id FROM `ct` where city='Storrs Mansfield' && SIC_code='7219'DB:business_master_new
loadtime:0.60269093513489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stratford' limit 1
loadtime:0.60271692276001 / seconds
Query Executed:select id FROM `ct` where city='Stratford' && SIC_code='7219'DB:business_master_new
loadtime:0.60362887382507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Suffield' limit 1
loadtime:0.60367298126221 / seconds
Query Executed:select id FROM `ct` where city='Suffield' && SIC_code='7219'DB:business_master_new
loadtime:0.60457491874695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taconic' limit 1
loadtime:0.60460495948792 / seconds
Query Executed:select id FROM `ct` where city='Taconic' && SIC_code='7219'DB:business_master_new
loadtime:0.60540390014648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taftville' limit 1
loadtime:0.6054527759552 / seconds
Query Executed:select id FROM `ct` where city='Taftville' && SIC_code='7219'DB:business_master_new
loadtime:0.60596299171448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tariffville' limit 1
loadtime:0.60600900650024 / seconds
Query Executed:select id FROM `ct` where city='Tariffville' && SIC_code='7219'DB:business_master_new
loadtime:0.61657285690308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terryville' limit 1
loadtime:0.61664295196533 / seconds
Query Executed:select id FROM `ct` where city='Terryville' && SIC_code='7219'DB:business_master_new
loadtime:0.61766600608826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:0.61770677566528 / seconds
Query Executed:select id FROM `ct` where city='Thomaston' && SIC_code='7219'DB:business_master_new
loadtime:0.61860299110413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.61864185333252 / seconds
Query Executed:select id FROM `ct` where city='Thompson' && SIC_code='7219'DB:business_master_new
loadtime:0.61956191062927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tolland' limit 1
loadtime:0.61960196495056 / seconds
Query Executed:select id FROM `ct` where city='Tolland' && SIC_code='7219'DB:business_master_new
loadtime:0.62050199508667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrington' limit 1
loadtime:0.6205267906189 / seconds
Query Executed:select id FROM `ct` where city='Torrington' && SIC_code='7219'DB:business_master_new
loadtime:0.62145185470581 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trumbull' limit 1
loadtime:0.62148785591125 / seconds
Query Executed:select id FROM `ct` where city='Trumbull' && SIC_code='7219'DB:business_master_new
loadtime:0.62241077423096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uncasville' limit 1
loadtime:0.62244296073914 / seconds
Query Executed:select id FROM `ct` where city='Uncasville' && SIC_code='7219'DB:business_master_new
loadtime:0.62334084510803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Unionville' limit 1
loadtime:0.62337684631348 / seconds
Query Executed:select id FROM `ct` where city='Unionville' && SIC_code='7219'DB:business_master_new
loadtime:0.62427091598511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon Rockville' limit 1
loadtime:0.62430691719055 / seconds
Query Executed:select id FROM `ct` where city='Vernon Rockville' && SIC_code='7219'DB:business_master_new
loadtime:0.62522482872009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Versailles' limit 1
loadtime:0.62525486946106 / seconds
Query Executed:select id FROM `ct` where city='Versailles' && SIC_code='7219'DB:business_master_new
loadtime:0.62695980072021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Voluntown' limit 1
loadtime:0.62699484825134 / seconds
Query Executed:select id FROM `ct` where city='Voluntown' && SIC_code='7219'DB:business_master_new
loadtime:0.62790894508362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallingford' limit 1
loadtime:0.62793278694153 / seconds
Query Executed:select id FROM `ct` where city='Wallingford' && SIC_code='7219'DB:business_master_new
loadtime:0.62886595726013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.62889981269836 / seconds
Query Executed:select id FROM `ct` where city='Washington' && SIC_code='7219'DB:business_master_new
loadtime:0.62977886199951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington Depot' limit 1
loadtime:0.62980699539185 / seconds
Query Executed:select id FROM `ct` where city='Washington Depot' && SIC_code='7219'DB:business_master_new
loadtime:0.63071298599243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterbury' limit 1
loadtime:0.63074684143066 / seconds
Query Executed:select id FROM `ct` where city='Waterbury' && SIC_code='7219'DB:business_master_new
loadtime:0.63163781166077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterford' limit 1
loadtime:0.63166999816895 / seconds
Query Executed:select id FROM `ct` where city='Waterford' && SIC_code='7219'DB:business_master_new
loadtime:0.63255381584167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watertown' limit 1
loadtime:0.63259696960449 / seconds
Query Executed:select id FROM `ct` where city='Watertown' && SIC_code='7219'DB:business_master_new
loadtime:0.6335289478302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wauregan' limit 1
loadtime:0.63356280326843 / seconds
Query Executed:select id FROM `ct` where city='Wauregan' && SIC_code='7219'DB:business_master_new
loadtime:0.63631296157837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weatogue' limit 1
loadtime:0.6363468170166 / seconds
Query Executed:select id FROM `ct` where city='Weatogue' && SIC_code='7219'DB:business_master_new
loadtime:0.63727784156799 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Cornwall' limit 1
loadtime:0.63730192184448 / seconds
Query Executed:select id FROM `ct` where city='West Cornwall' && SIC_code='7219'DB:business_master_new
loadtime:0.63773798942566 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Granby' limit 1
loadtime:0.63777184486389 / seconds
Query Executed:select id FROM `ct` where city='West Granby' && SIC_code='7219'DB:business_master_new
loadtime:0.64546489715576 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartford' limit 1
loadtime:0.64548993110657 / seconds
Query Executed:select id FROM `ct` where city='West Hartford' && SIC_code='7219'DB:business_master_new
loadtime:0.64641690254211 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Hartland' limit 1
loadtime:0.64645886421204 / seconds
Query Executed:select id FROM `ct` where city='West Hartland' && SIC_code='7219'DB:business_master_new
loadtime:0.64707899093628 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.64710283279419 / seconds
Query Executed:select id FROM `ct` where city='West Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.64800882339478 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Mystic' limit 1
loadtime:0.64805889129639 / seconds
Query Executed:select id FROM `ct` where city='West Mystic' && SIC_code='7219'DB:business_master_new
loadtime:0.65360593795776 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Redding' limit 1
loadtime:0.65367197990417 / seconds
Query Executed:select id FROM `ct` where city='West Redding' && SIC_code='7219'DB:business_master_new
loadtime:0.6605019569397 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Simsbury' limit 1
loadtime:0.66056489944458 / seconds
Query Executed:select id FROM `ct` where city='West Simsbury' && SIC_code='7219'DB:business_master_new
loadtime:0.66236877441406 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Suffield' limit 1
loadtime:0.66247987747192 / seconds
Query Executed:select id FROM `ct` where city='West Suffield' && SIC_code='7219'DB:business_master_new
loadtime:0.66439199447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Willington' limit 1
loadtime:0.66445279121399 / seconds
Query Executed:select id FROM `ct` where city='West Willington' && SIC_code='7219'DB:business_master_new
loadtime:0.66528391838074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westbrook' limit 1
loadtime:0.66533088684082 / seconds
Query Executed:select id FROM `ct` where city='Westbrook' && SIC_code='7219'DB:business_master_new
loadtime:0.66625690460205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weston' limit 1
loadtime:0.66631293296814 / seconds
Query Executed:select id FROM `ct` where city='Weston' && SIC_code='7219'DB:business_master_new
loadtime:0.66722893714905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westport' limit 1
loadtime:0.66726398468018 / seconds
Query Executed:select id FROM `ct` where city='Westport' && SIC_code='7219'DB:business_master_new
loadtime:0.66820979118347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wethersfield' limit 1
loadtime:0.66826796531677 / seconds
Query Executed:select id FROM `ct` where city='Wethersfield' && SIC_code='7219'DB:business_master_new
loadtime:0.66921186447144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willimantic' limit 1
loadtime:0.66925477981567 / seconds
Query Executed:select id FROM `ct` where city='Willimantic' && SIC_code='7219'DB:business_master_new
loadtime:0.67017292976379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willington' limit 1
loadtime:0.67022299766541 / seconds
Query Executed:select id FROM `ct` where city='Willington' && SIC_code='7219'DB:business_master_new
loadtime:0.67114186286926 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:0.67118883132935 / seconds
Query Executed:select id FROM `ct` where city='Wilton' && SIC_code='7219'DB:business_master_new
loadtime:0.67211389541626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winchester Center' limit 1
loadtime:0.6721568107605 / seconds
Query Executed:select id FROM `ct` where city='Winchester Center' && SIC_code='7219'DB:business_master_new
loadtime:0.67441582679749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windham' limit 1
loadtime:0.67446279525757 / seconds
Query Executed:select id FROM `ct` where city='Windham' && SIC_code='7219'DB:business_master_new
loadtime:0.67538499832153 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:0.67543292045593 / seconds
Query Executed:select id FROM `ct` where city='Windsor' && SIC_code='7219'DB:business_master_new
loadtime:0.67636299133301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor Locks' limit 1
loadtime:0.67639780044556 / seconds
Query Executed:select id FROM `ct` where city='Windsor Locks' && SIC_code='7219'DB:business_master_new
loadtime:0.67733979225159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winsted' limit 1
loadtime:0.67738890647888 / seconds
Query Executed:select id FROM `ct` where city='Winsted' && SIC_code='7219'DB:business_master_new
loadtime:0.6783139705658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wolcott' limit 1
loadtime:0.67899584770203 / seconds
Query Executed:select id FROM `ct` where city='Wolcott' && SIC_code='7219'DB:business_master_new
loadtime:0.68008184432983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbridge' limit 1
loadtime:0.68011689186096 / seconds
Query Executed:select id FROM `ct` where city='Woodbridge' && SIC_code='7219'DB:business_master_new
loadtime:0.68105697631836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodbury' limit 1
loadtime:0.68110489845276 / seconds
Query Executed:select id FROM `ct` where city='Woodbury' && SIC_code='7219'DB:business_master_new
loadtime:0.68203186988831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:0.68207979202271 / seconds
Query Executed:select id FROM `ct` where city='Woodstock' && SIC_code='7219'DB:business_master_new
loadtime:0.68300890922546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock Valley' limit 1
loadtime:0.68306493759155 / seconds
Query Executed:select id FROM `ct` where city='Woodstock Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.68398189544678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yantic' limit 1
loadtime:0.68401694297791 / seconds
Query Executed:select id FROM `ct` where city='Yantic' && SIC_code='7219'DB:business_master_new
loadtime:0.6849467754364 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.68503880500793 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.685213804245 / seconds
Operation template executed (chunk cache operation)
loadtime:0.68529582023621 / seconds
template override:Default
loadtime:0.68531584739685 / 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.68612790107727 / seconds
Template Constructed, Array Rows:49
loadtime:0.68636083602905 / seconds
TOTAL EXECUTION TIME: 0.68617
loadtime:0.68644595146179 / 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] => 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.68645000457764
TOTAL KEY ARRAYS: 69