Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.2015991210938E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00056219100952148 / seconds
host not found setting manual db connection
loadtime:0.00095701217651367 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0011801719665527 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0013840198516846 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0014650821685791 / seconds
zipcode:
loadtime:0.0014851093292236 / seconds
Query Executed:select * from search_referrer where page_hash='386d65a80d0619d31b6b9640e8255163' limit 10 DB:ezrox_toadli
loadtime:0.0016801357269287 / seconds
Operation header executed (non global)
loadtime:0.0016989707946777 / seconds
Operation leaderboard executed (non global)
loadtime:0.0017411708831787 / seconds
Operation square executed (non global)
loadtime:0.0017561912536621 / seconds
Operation square_bottom executed (non global)
loadtime:0.0017690658569336 / seconds
Operation smallsquare executed (non global)
loadtime:0.0017800331115723 / seconds
Operation headeradright executed (non global)
loadtime:0.0017921924591064 / seconds
Operation google_analytics executed (non global)
loadtime:0.0018031597137451 / seconds
Operation topstories executed (non global)
loadtime:0.0018150806427002 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0018260478973389 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0018360614776611 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0020999908447266 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0022530555725098 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0022931098937988 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0023810863494873 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0024189949035645 / seconds
Template key: archive_menu pushed
loadtime:0.0024251937866211 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0024380683898926 / seconds
Template key: get_gravatar pushed
loadtime:0.0024430751800537 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0024471282958984 / seconds
*10)-10)+1 | start:0
loadtime:0.0024690628051758 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.0024940967559814 / seconds
DB connected to localhost business_master_new
loadtime:0.0027191638946533 / seconds
Query Executed:select * from geodata_usstates where url_id='district-of-columbia'DB:business_master_new
loadtime:0.0028800964355469 / seconds
Query stored in cache : _QUERY_www.toadli.comff8d1d824362c2dc6f5da83f96893c02
loadtime:0.0029101371765137 / seconds
Query Executed:select * from `dc_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.022616147994995 / seconds
Query stored in cache : _QUERY_www.toadli.com9e951f720318fd8fe0efb14e7aabf806
loadtime:0.022654056549072 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='district-of-columbia'
loadtime:0.022675037384033 / seconds
Query Executed:select sum(totalcount) as totalsum from `dc_catmap` where sic='6021'DB:business_master_new
loadtime:0.022907972335815 / seconds
Query stored in cache : _QUERY_www.toadli.com8083445d556e24a74f32185c02f687cf
loadtime:0.022952079772949 / seconds
6 / 11
loadtime:0.022984027862549 / seconds
Query Executed:select * from geodata_geocity where city='Bolling Afb' limit 1DB:business_master_new
loadtime:0.023281097412109 / seconds
Query stored in cache : _QUERY_www.toadli.com90b8733a86f030b2d9fa19a7e7445fc3
loadtime:0.023313999176025 / seconds
Query Executed:select id FROM `dc` where city='Bolling Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.045098066329956 / seconds
Query Executed:select * from geodata_geocity where city='Fort Mcnair' limit 1DB:business_master_new
loadtime:0.045427083969116 / seconds
Query stored in cache : _QUERY_www.toadli.comc06023396b1b4ae0a63cd04c87beead1
loadtime:0.045469999313354 / seconds
Query Executed:select id FROM `dc` where city='Fort Mcnair' && SIC_code='6021'DB:business_master_new
loadtime:0.045906066894531 / seconds
Query Executed:select * from geodata_geocity where city='Naval Anacost Annex' limit 1DB:business_master_new
loadtime:0.046205997467041 / seconds
Query stored in cache : _QUERY_www.toadli.comdadcd9a0dcf9a85dea7024cf5b15e9c8
loadtime:0.046235084533691 / seconds
Query Executed:select id FROM `dc` where city='Naval Anacost Annex' && SIC_code='6021'DB:business_master_new
loadtime:0.046684980392456 / seconds
Query Executed:select * from geodata_geocity where city='Washingotn' limit 1DB:business_master_new
loadtime:0.046995162963867 / seconds
Query stored in cache : _QUERY_www.toadli.comf4e9229332d6bc6fd197cca824f55b54
loadtime:0.047039985656738 / seconds
Query Executed:select id FROM `dc` where city='Washingotn' && SIC_code='6021'DB:business_master_new
loadtime:0.047489166259766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.047538042068481 / seconds
Query Executed:select id FROM `dc` where city='Washington' && SIC_code='6021'DB:business_master_new
loadtime:0.82088017463684 / seconds
Query Executed:select * from geodata_geocity where city='Washington Navy Yard' limit 1DB:business_master_new
loadtime:0.82148909568787 / seconds
Query stored in cache : _QUERY_www.toadli.come4e46c3d68a9aaeec0b127e4309c90ca
loadtime:0.8215479850769 / seconds
Query Executed:select id FROM `dc` where city='Washington Navy Yard' && SIC_code='6021'DB:business_master_new
loadtime:0.82207703590393 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.82217001914978 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.82227206230164 / seconds
Operation template executed (chunk cache operation)
loadtime:0.82237911224365 / seconds
template override:Default
loadtime:0.8223991394043 / 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.82314014434814 / seconds
Template Constructed, Array Rows:49
loadtime:0.82336115837097 / seconds
TOTAL EXECUTION TIME: 0.82318
loadtime:0.82341814041138 / 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] => national-commercial-banks [stateURLid] => district-of-columbia )


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