DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.702278137207E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001849889755249 / seconds
host not found setting manual db connection
loadtime:0.0096549987792969 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0099539756774902 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010161876678467 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010255813598633 / seconds
zipcode:
loadtime:0.010290861129761 / seconds
Query Executed:select * from search_referrer where page_hash='852724685316d406195c587c4206a109' limit 10 DB:ezrox_toadli
loadtime:0.010520935058594 / seconds
Operation header executed (non global)
loadtime:0.010552883148193 / seconds
Operation leaderboard executed (non global)
loadtime:0.010623931884766 / seconds
Operation square executed (non global)
loadtime:0.010654926300049 / seconds
Operation square_bottom executed (non global)
loadtime:0.010684013366699 / seconds
Operation smallsquare executed (non global)
loadtime:0.010710954666138 / seconds
Operation headeradright executed (non global)
loadtime:0.010737895965576 / seconds
Operation google_analytics executed (non global)
loadtime:0.010762929916382 / seconds
Operation topstories executed (non global)
loadtime:0.010788917541504 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010816812515259 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010842800140381 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011125802993774 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011368989944458 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011405944824219 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011467933654785 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011515855789185 / seconds
Template key: archive_menu pushed
loadtime:0.011525869369507 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011539936065674 / seconds
Template key: get_gravatar pushed
loadtime:0.011546850204468 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.01155686378479 / seconds
*10)-10)+1 | start:0
loadtime:0.011602878570557 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.011644840240479 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.011684894561768 / seconds
DB connected to localhost business_master_new
loadtime:0.011937856674194 / seconds
Query Executed:select * from `hi_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.023458003997803 / seconds
Query stored in cache : _QUERY_www.toadli.com08b4c72170f1d87a8ae3a28e3286c02f
loadtime:0.023875951766968 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.023918867111206 / seconds
Query Executed:select sum(totalcount) as totalsum from `hi_catmap` where sic='6021'DB:business_master_new
loadtime:0.024724960327148 / seconds
Query stored in cache : _QUERY_www.toadli.com29ed3eed60d7560be374341ad0f2756a
loadtime:0.024760007858276 / seconds
96 / 11
loadtime:0.024818897247314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiea' limit 1
loadtime:0.024886846542358 / seconds
Query Executed:select id FROM `hi` where city='Aiea' && SIC_code='6021'DB:business_master_new
loadtime:0.027453899383545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anahola' limit 1
loadtime:0.027537822723389 / seconds
Query Executed:select id FROM `hi` where city='Anahola' && SIC_code='6021'DB:business_master_new
loadtime:0.028482913970947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp H M Smith' limit 1
loadtime:0.028538942337036 / seconds
Query Executed:select id FROM `hi` where city='Camp H M Smith' && SIC_code='6021'DB:business_master_new
loadtime:0.029062986373901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Captain Cook' limit 1
loadtime:0.029115915298462 / seconds
Query Executed:select id FROM `hi` where city='Captain Cook' && SIC_code='6021'DB:business_master_new
loadtime:0.038600921630859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleele' limit 1
loadtime:0.03865385055542 / seconds
Query Executed:select id FROM `hi` where city='Eleele' && SIC_code='6021'DB:business_master_new
loadtime:0.040035009384155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewa Beach' limit 1
loadtime:0.040109872817993 / seconds
Query Executed:select id FROM `hi` where city='Ewa Beach' && SIC_code='6021'DB:business_master_new
loadtime:0.042407989501953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Shafter' limit 1
loadtime:0.042475938796997 / seconds
Query Executed:select id FROM `hi` where city='Fort Shafter' && SIC_code='6021'DB:business_master_new
loadtime:0.043064832687378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haiku' limit 1
loadtime:0.043118000030518 / seconds
Query Executed:select id FROM `hi` where city='Haiku' && SIC_code='6021'DB:business_master_new
loadtime:0.045378923416138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hakalau' limit 1
loadtime:0.045431852340698 / seconds
Query Executed:select id FROM `hi` where city='Hakalau' && SIC_code='6021'DB:business_master_new
loadtime:0.046018838882446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haleiwa' limit 1
loadtime:0.04607892036438 / seconds
Query Executed:select id FROM `hi` where city='Haleiwa' && SIC_code='6021'DB:business_master_new
loadtime:0.0483558177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hana' limit 1
loadtime:0.048424005508423 / seconds
Query Executed:select id FROM `hi` where city='Hana' && SIC_code='6021'DB:business_master_new
loadtime:0.050311803817749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanalei' limit 1
loadtime:0.050378799438477 / seconds
Query Executed:select id FROM `hi` where city='Hanalei' && SIC_code='6021'DB:business_master_new
loadtime:0.053761005401611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanamaulu' limit 1
loadtime:0.053828954696655 / seconds
Query Executed:select id FROM `hi` where city='Hanamaulu' && SIC_code='6021'DB:business_master_new
loadtime:0.054356813430786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanapepe' limit 1
loadtime:0.054409980773926 / seconds
Query Executed:select id FROM `hi` where city='Hanapepe' && SIC_code='6021'DB:business_master_new
loadtime:0.056497812271118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hauula' limit 1
loadtime:0.056563854217529 / seconds
Query Executed:select id FROM `hi` where city='Hauula' && SIC_code='6021'DB:business_master_new
loadtime:0.058259963989258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawaii National Park' limit 1
loadtime:0.058313846588135 / seconds
Query Executed:select id FROM `hi` where city='Hawaii National Park' && SIC_code='6021'DB:business_master_new
loadtime:0.058913946151733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawaii Natl Park' limit 1
loadtime:0.058965921401978 / seconds
Query Executed:select id FROM `hi` where city='Hawaii Natl Park' && SIC_code='6021'DB:business_master_new
loadtime:0.059454917907715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawi' limit 1
loadtime:0.059507846832275 / seconds
Query Executed:select id FROM `hi` where city='Hawi' && SIC_code='6021'DB:business_master_new
loadtime:0.060910940170288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickam Afb' limit 1
loadtime:0.060962915420532 / seconds
Query Executed:select id FROM `hi` where city='Hickam Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.061654806137085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilo' limit 1
loadtime:0.061707973480225 / seconds
Query Executed:select id FROM `hi` where city='Hilo' && SIC_code='6021'DB:business_master_new
loadtime:0.063998937606812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holualoa' limit 1
loadtime:0.064090967178345 / seconds
Query Executed:select id FROM `hi` where city='Holualoa' && SIC_code='6021'DB:business_master_new
loadtime:0.066226959228516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaunau' limit 1
loadtime:0.066282987594604 / seconds
Query Executed:select id FROM `hi` where city='Honaunau' && SIC_code='6021'DB:business_master_new
loadtime:0.0676589012146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honokaa' limit 1
loadtime:0.067710876464844 / seconds
Query Executed:select id FROM `hi` where city='Honokaa' && SIC_code='6021'DB:business_master_new
loadtime:0.070585012435913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honolulu' limit 1
loadtime:0.070652008056641 / seconds
Query Executed:select id FROM `hi` where city='Honolulu' && SIC_code='6021'DB:business_master_new
loadtime:0.073027849197388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honomu' limit 1
loadtime:0.073240995407104 / seconds
Query Executed:select id FROM `hi` where city='Honomu' && SIC_code='6021'DB:business_master_new
loadtime:0.07397985458374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoolehua' limit 1
loadtime:0.074050903320312 / seconds
Query Executed:select id FROM `hi` where city='Hoolehua' && SIC_code='6021'DB:business_master_new
loadtime:0.074922800064087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaaawa' limit 1
loadtime:0.074975967407227 / seconds
Query Executed:select id FROM `hi` where city='Kaaawa' && SIC_code='6021'DB:business_master_new
loadtime:0.076092958450317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahuku' limit 1
loadtime:0.076145887374878 / seconds
Query Executed:select id FROM `hi` where city='Kahuku' && SIC_code='6021'DB:business_master_new
loadtime:0.07783579826355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahului' limit 1
loadtime:0.077901840209961 / seconds
Query Executed:select id FROM `hi` where city='Kahului' && SIC_code='6021'DB:business_master_new
loadtime:0.080206871032715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kailua' limit 1
loadtime:0.080281972885132 / seconds
Query Executed:select id FROM `hi` where city='Kailua' && SIC_code='6021'DB:business_master_new
loadtime:0.08256983757019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kailua Kona' limit 1
loadtime:0.082641839981079 / seconds
Query Executed:select id FROM `hi` where city='Kailua Kona' && SIC_code='6021'DB:business_master_new
loadtime:0.084980010986328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalaheo' limit 1
loadtime:0.085065841674805 / seconds
Query Executed:select id FROM `hi` where city='Kalaheo' && SIC_code='6021'DB:business_master_new
loadtime:0.087775945663452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalaupapa' limit 1
loadtime:0.087831974029541 / seconds
Query Executed:select id FROM `hi` where city='Kalaupapa' && SIC_code='6021'DB:business_master_new
loadtime:0.088402986526489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamuela' limit 1
loadtime:0.088454961776733 / seconds
Query Executed:select id FROM `hi` where city='Kamuela' && SIC_code='6021'DB:business_master_new
loadtime:0.090914964675903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaneohe' limit 1
loadtime:0.090981006622314 / seconds
Query Executed:select id FROM `hi` where city='Kaneohe' && SIC_code='6021'DB:business_master_new
loadtime:0.093281984329224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapaa' limit 1
loadtime:0.093354940414429 / seconds
Query Executed:select id FROM `hi` where city='Kapaa' && SIC_code='6021'DB:business_master_new
loadtime:0.095650911331177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapaau' limit 1
loadtime:0.095719814300537 / seconds
Query Executed:select id FROM `hi` where city='Kapaau' && SIC_code='6021'DB:business_master_new
loadtime:0.098115921020508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapolei' limit 1
loadtime:0.098182916641235 / seconds
Query Executed:select id FROM `hi` where city='Kapolei' && SIC_code='6021'DB:business_master_new
loadtime:0.10046696662903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaumakani' limit 1
loadtime:0.1005380153656 / seconds
Query Executed:select id FROM `hi` where city='Kaumakani' && SIC_code='6021'DB:business_master_new
loadtime:0.10117483139038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaunakakai' limit 1
loadtime:0.101233959198 / seconds
Query Executed:select id FROM `hi` where city='Kaunakakai' && SIC_code='6021'DB:business_master_new
loadtime:0.10352087020874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keaau' limit 1
loadtime:0.10358881950378 / seconds
Query Executed:select id FROM `hi` where city='Keaau' && SIC_code='6021'DB:business_master_new
loadtime:0.10585403442383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kealakekua' limit 1
loadtime:0.10590791702271 / seconds
Query Executed:select id FROM `hi` where city='Kealakekua' && SIC_code='6021'DB:business_master_new
loadtime:0.10819101333618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kealia' limit 1
loadtime:0.10826396942139 / seconds
Query Executed:select id FROM `hi` where city='Kealia' && SIC_code='6021'DB:business_master_new
loadtime:0.10884189605713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keauhou' limit 1
loadtime:0.10889387130737 / seconds
Query Executed:select id FROM `hi` where city='Keauhou' && SIC_code='6021'DB:business_master_new
loadtime:0.11043095588684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kekaha' limit 1
loadtime:0.11048483848572 / seconds
Query Executed:select id FROM `hi` where city='Kekaha' && SIC_code='6021'DB:business_master_new
loadtime:0.11186981201172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kihei' limit 1
loadtime:0.11192297935486 / seconds
Query Executed:select id FROM `hi` where city='Kihei' && SIC_code='6021'DB:business_master_new
loadtime:0.11421680450439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilauea' limit 1
loadtime:0.11429190635681 / seconds
Query Executed:select id FROM `hi` where city='Kilauea' && SIC_code='6021'DB:business_master_new
loadtime:0.11754488945007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koloa' limit 1
loadtime:0.1176118850708 / seconds
Query Executed:select id FROM `hi` where city='Koloa' && SIC_code='6021'DB:business_master_new
loadtime:0.11988997459412 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kualapuu' limit 1
loadtime:0.11995697021484 / seconds
Query Executed:select id FROM `hi` where city='Kualapuu' && SIC_code='6021'DB:business_master_new
loadtime:0.12080097198486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kula' limit 1
loadtime:0.12085390090942 / seconds
Query Executed:select id FROM `hi` where city='Kula' && SIC_code='6021'DB:business_master_new
loadtime:0.1231529712677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kunia' limit 1
loadtime:0.12320590019226 / seconds
Query Executed:select id FROM `hi` where city='Kunia' && SIC_code='6021'DB:business_master_new
loadtime:0.12379097938538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kurtistown' limit 1
loadtime:0.1238420009613 / seconds
Query Executed:select id FROM `hi` where city='Kurtistown' && SIC_code='6021'DB:business_master_new
loadtime:0.12523102760315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lahaina' limit 1
loadtime:0.12528300285339 / seconds
Query Executed:select id FROM `hi` where city='Lahaina' && SIC_code='6021'DB:business_master_new
loadtime:0.12757396697998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laie' limit 1
loadtime:0.12764596939087 / seconds
Query Executed:select id FROM `hi` where city='Laie' && SIC_code='6021'DB:business_master_new
loadtime:0.12944984436035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanai City' limit 1
loadtime:0.12951683998108 / seconds
Query Executed:select id FROM `hi` where city='Lanai City' && SIC_code='6021'DB:business_master_new
loadtime:0.13161897659302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laupahoehoe' limit 1
loadtime:0.13168692588806 / seconds
Query Executed:select id FROM `hi` where city='Laupahoehoe' && SIC_code='6021'DB:business_master_new
loadtime:0.13239288330078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawai' limit 1
loadtime:0.13244581222534 / seconds
Query Executed:select id FROM `hi` where city='Lawai' && SIC_code='6021'DB:business_master_new
loadtime:0.13392782211304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lihue' limit 1
loadtime:0.13397979736328 / seconds
Query Executed:select id FROM `hi` where city='Lihue' && SIC_code='6021'DB:business_master_new
loadtime:0.136305809021 / seconds
Query loaded from cache:select * from geodata_geocity where city='M C B H Kaneohe Bay' limit 1
loadtime:0.13643503189087 / seconds
Query Executed:select id FROM `hi` where city='M C B H Kaneohe Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.13691186904907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Makawao' limit 1
loadtime:0.13697791099548 / seconds
Query Executed:select id FROM `hi` where city='Makawao' && SIC_code='6021'DB:business_master_new
loadtime:0.13924598693848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Makaweli' limit 1
loadtime:0.13929986953735 / seconds
Query Executed:select id FROM `hi` where city='Makaweli' && SIC_code='6021'DB:business_master_new
loadtime:0.13975095748901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maunaloa' limit 1
loadtime:0.13980197906494 / seconds
Query Executed:select id FROM `hi` where city='Maunaloa' && SIC_code='6021'DB:business_master_new
loadtime:0.1405348777771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbh Kaneohe Bay' limit 1
loadtime:0.14058899879456 / seconds
Query Executed:select id FROM `hi` where city='Mcbh Kaneohe Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.14122486114502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mililani' limit 1
loadtime:0.14127898216248 / seconds
Query Executed:select id FROM `hi` where city='Mililani' && SIC_code='6021'DB:business_master_new
loadtime:0.14354586601257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain View' limit 1
loadtime:0.14362001419067 / seconds
Query Executed:select id FROM `hi` where city='Mountain View' && SIC_code='6021'DB:business_master_new
loadtime:0.14510297775269 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naalehu' limit 1
loadtime:0.14516401290894 / seconds
Query Executed:select id FROM `hi` where city='Naalehu' && SIC_code='6021'DB:business_master_new
loadtime:0.1470308303833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninole' limit 1
loadtime:0.14708399772644 / seconds
Query Executed:select id FROM `hi` where city='Ninole' && SIC_code='6021'DB:business_master_new
loadtime:0.14755988121033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean View' limit 1
loadtime:0.14761281013489 / seconds
Query Executed:select id FROM `hi` where city='Ocean View' && SIC_code='6021'DB:business_master_new
loadtime:0.14848494529724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ookala' limit 1
loadtime:0.1485378742218 / seconds
Query Executed:select id FROM `hi` where city='Ookala' && SIC_code='6021'DB:business_master_new
loadtime:0.14905095100403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paauilo' limit 1
loadtime:0.14910387992859 / seconds
Query Executed:select id FROM `hi` where city='Paauilo' && SIC_code='6021'DB:business_master_new
loadtime:0.14993190765381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pahala' limit 1
loadtime:0.14999580383301 / seconds
Query Executed:select id FROM `hi` where city='Pahala' && SIC_code='6021'DB:business_master_new
loadtime:0.15098690986633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pahoa' limit 1
loadtime:0.15105295181274 / seconds
Query Executed:select id FROM `hi` where city='Pahoa' && SIC_code='6021'DB:business_master_new
loadtime:0.15441298484802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paia' limit 1
loadtime:0.15448093414307 / seconds
Query Executed:select id FROM `hi` where city='Paia' && SIC_code='6021'DB:business_master_new
loadtime:0.15781593322754 / seconds
Query loaded from cache:select * from geodata_geocity where city='Papaaloa' limit 1
loadtime:0.15788292884827 / seconds
Query Executed:select id FROM `hi` where city='Papaaloa' && SIC_code='6021'DB:business_master_new
loadtime:0.15841794013977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Papaikou' limit 1
loadtime:0.15847182273865 / seconds
Query Executed:select id FROM `hi` where city='Papaikou' && SIC_code='6021'DB:business_master_new
loadtime:0.15960597991943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl City' limit 1
loadtime:0.15965986251831 / seconds
Query Executed:select id FROM `hi` where city='Pearl City' && SIC_code='6021'DB:business_master_new
loadtime:0.16197681427002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl Harbor' limit 1
loadtime:0.16204786300659 / seconds
Query Executed:select id FROM `hi` where city='Pearl Harbor' && SIC_code='6021'DB:business_master_new
loadtime:0.16269683837891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepeekeo' limit 1
loadtime:0.162752866745 / seconds
Query Executed:select id FROM `hi` where city='Pepeekeo' && SIC_code='6021'DB:business_master_new
loadtime:0.16338300704956 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:0.16343593597412 / seconds
Query Executed:select id FROM `hi` where city='Princeville' && SIC_code='6021'DB:business_master_new
loadtime:0.16556596755981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukalani' limit 1
loadtime:0.16563200950623 / seconds
Query Executed:select id FROM `hi` where city='Pukalani' && SIC_code='6021'DB:business_master_new
loadtime:0.16688084602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puunene' limit 1
loadtime:0.16694593429565 / seconds
Query Executed:select id FROM `hi` where city='Puunene' && SIC_code='6021'DB:business_master_new
loadtime:0.16849899291992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield Barracks' limit 1
loadtime:0.16855382919312 / seconds
Query Executed:select id FROM `hi` where city='Schofield Barracks' && SIC_code='6021'DB:business_master_new
loadtime:0.16938996315002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield Brrcks' limit 1
loadtime:0.16945481300354 / seconds
Query Executed:select id FROM `hi` where city='Schofield Brrcks' && SIC_code='6021'DB:business_master_new
loadtime:0.16993188858032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamc' limit 1
loadtime:0.16999292373657 / seconds
Query Executed:select id FROM `hi` where city='Tamc' && SIC_code='6021'DB:business_master_new
loadtime:0.1704888343811 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripler Amc' limit 1
loadtime:0.17054200172424 / seconds
Query Executed:select id FROM `hi` where city='Tripler Amc' && SIC_code='6021'DB:business_master_new
loadtime:0.17106485366821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volcano' limit 1
loadtime:0.17111682891846 / seconds
Query Executed:select id FROM `hi` where city='Volcano' && SIC_code='6021'DB:business_master_new
loadtime:0.17278599739075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wahiawa' limit 1
loadtime:0.17283892631531 / seconds
Query Executed:select id FROM `hi` where city='Wahiawa' && SIC_code='6021'DB:business_master_new
loadtime:0.17512893676758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waialua' limit 1
loadtime:0.17520093917847 / seconds
Query Executed:select id FROM `hi` where city='Waialua' && SIC_code='6021'DB:business_master_new
loadtime:0.17763495445251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waianae' limit 1
loadtime:0.17769002914429 / seconds
Query Executed:select id FROM `hi` where city='Waianae' && SIC_code='6021'DB:business_master_new
loadtime:0.17998790740967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waikoloa' limit 1
loadtime:0.18005681037903 / seconds
Query Executed:select id FROM `hi` where city='Waikoloa' && SIC_code='6021'DB:business_master_new
loadtime:0.18329381942749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wailuku' limit 1
loadtime:0.18336081504822 / seconds
Query Executed:select id FROM `hi` where city='Wailuku' && SIC_code='6021'DB:business_master_new
loadtime:0.18565082550049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waimanalo' limit 1
loadtime:0.18571996688843 / seconds
Query Executed:select id FROM `hi` where city='Waimanalo' && SIC_code='6021'DB:business_master_new
loadtime:0.18870186805725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waimea' limit 1
loadtime:0.18875694274902 / seconds
Query Executed:select id FROM `hi` where city='Waimea' && SIC_code='6021'DB:business_master_new
loadtime:0.19102692604065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waipahu' limit 1
loadtime:0.19109702110291 / seconds
Query Executed:select id FROM `hi` where city='Waipahu' && SIC_code='6021'DB:business_master_new
loadtime:0.19340682029724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler Afb' limit 1
loadtime:0.19348096847534 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.19398498535156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler Army Airfield' limit 1
loadtime:0.19403886795044 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Army Airfield' && SIC_code='6021'DB:business_master_new
loadtime:0.19455981254578 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.19471883773804 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.19506502151489 / seconds
Operation template executed (chunk cache operation)
loadtime:0.19520497322083 / seconds
template override:Default
loadtime:0.19524884223938 / 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.19658780097961 / seconds
Template Constructed, Array Rows:49
loadtime:0.19711399078369 / seconds
TOTAL EXECUTION TIME: 0.19668
loadtime:0.1982319355011 / 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] => hawaii )


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