DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.8930130004883E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00048685073852539 / seconds
host not found setting manual db connection
loadtime:0.00092697143554688 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001349925994873 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0015449523925781 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0015997886657715 / seconds
zipcode:
loadtime:0.0016179084777832 / seconds
Query Executed:select * from search_referrer where page_hash='852724685316d406195c587c4206a109' limit 10 DB:ezrox_toadli
loadtime:0.0018219947814941 / seconds
Operation header executed (non global)
loadtime:0.0018389225006104 / seconds
Operation leaderboard executed (non global)
loadtime:0.001884937286377 / seconds
Operation square executed (non global)
loadtime:0.0018999576568604 / seconds
Operation square_bottom executed (non global)
loadtime:0.0019128322601318 / seconds
Operation smallsquare executed (non global)
loadtime:0.001924991607666 / seconds
Operation headeradright executed (non global)
loadtime:0.0019359588623047 / seconds
Operation google_analytics executed (non global)
loadtime:0.0019469261169434 / seconds
Operation topstories executed (non global)
loadtime:0.001957893371582 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0019688606262207 / seconds
Operation memberbuscount executed (non global)
loadtime:0.001978874206543 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0023739337921143 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0025289058685303 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0025689601898193 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.002626895904541 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0026648044586182 / seconds
Template key: archive_menu pushed
loadtime:0.0026698112487793 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0026757717132568 / seconds
Template key: get_gravatar pushed
loadtime:0.0026798248291016 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0026838779449463 / seconds
*10)-10)+1 | start:0
loadtime:0.0027058124542236 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.0027368068695068 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.0028369426727295 / seconds
DB connected to localhost business_master_new
loadtime:0.0032308101654053 / seconds
Query Executed:select * from `hi_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.020869970321655 / seconds
Query stored in cache : _QUERY_www.toadli.com08b4c72170f1d87a8ae3a28e3286c02f
loadtime:0.021052837371826 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.021078824996948 / seconds
Query Executed:select sum(totalcount) as totalsum from `hi_catmap` where sic='6021'DB:business_master_new
loadtime:0.021819829940796 / seconds
Query stored in cache : _QUERY_www.toadli.com29ed3eed60d7560be374341ad0f2756a
loadtime:0.021856784820557 / seconds
96 / 11
loadtime:0.021888971328735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiea' limit 1
loadtime:0.02193284034729 / seconds
Query Executed:select id FROM `hi` where city='Aiea' && SIC_code='6021'DB:business_master_new
loadtime:0.60851287841797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anahola' limit 1
loadtime:0.60858392715454 / seconds
Query Executed:select id FROM `hi` where city='Anahola' && SIC_code='6021'DB:business_master_new
loadtime:0.60912680625916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp H M Smith' limit 1
loadtime:0.60917091369629 / seconds
Query Executed:select id FROM `hi` where city='Camp H M Smith' && SIC_code='6021'DB:business_master_new
loadtime:0.61247587203979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Captain Cook' limit 1
loadtime:0.61251878738403 / seconds
Query Executed:select id FROM `hi` where city='Captain Cook' && SIC_code='6021'DB:business_master_new
loadtime:0.61337089538574 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleele' limit 1
loadtime:0.61340689659119 / seconds
Query Executed:select id FROM `hi` where city='Eleele' && SIC_code='6021'DB:business_master_new
loadtime:0.61419987678528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewa Beach' limit 1
loadtime:0.61425495147705 / seconds
Query Executed:select id FROM `hi` where city='Ewa Beach' && SIC_code='6021'DB:business_master_new
loadtime:0.61653590202332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Shafter' limit 1
loadtime:0.61658477783203 / seconds
Query Executed:select id FROM `hi` where city='Fort Shafter' && SIC_code='6021'DB:business_master_new
loadtime:0.6213698387146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haiku' limit 1
loadtime:0.62141990661621 / seconds
Query Executed:select id FROM `hi` where city='Haiku' && SIC_code='6021'DB:business_master_new
loadtime:0.62552785873413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hakalau' limit 1
loadtime:0.6256377696991 / seconds
Query Executed:select id FROM `hi` where city='Hakalau' && SIC_code='6021'DB:business_master_new
loadtime:0.64898586273193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haleiwa' limit 1
loadtime:0.64913082122803 / seconds
Query Executed:select id FROM `hi` where city='Haleiwa' && SIC_code='6021'DB:business_master_new
loadtime:0.65426683425903 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hana' limit 1
loadtime:0.65445899963379 / seconds
Query Executed:select id FROM `hi` where city='Hana' && SIC_code='6021'DB:business_master_new
loadtime:0.65577697753906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanalei' limit 1
loadtime:0.65589785575867 / seconds
Query Executed:select id FROM `hi` where city='Hanalei' && SIC_code='6021'DB:business_master_new
loadtime:0.65726780891418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanamaulu' limit 1
loadtime:0.65733790397644 / seconds
Query Executed:select id FROM `hi` where city='Hanamaulu' && SIC_code='6021'DB:business_master_new
loadtime:0.66134691238403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanapepe' limit 1
loadtime:0.66138076782227 / seconds
Query Executed:select id FROM `hi` where city='Hanapepe' && SIC_code='6021'DB:business_master_new
loadtime:0.66236996650696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hauula' limit 1
loadtime:0.66241979598999 / seconds
Query Executed:select id FROM `hi` where city='Hauula' && SIC_code='6021'DB:business_master_new
loadtime:0.66316199302673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawaii National Park' limit 1
loadtime:0.66318893432617 / seconds
Query Executed:select id FROM `hi` where city='Hawaii National Park' && SIC_code='6021'DB:business_master_new
loadtime:0.71918177604675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawaii Natl Park' limit 1
loadtime:0.71923279762268 / seconds
Query Executed:select id FROM `hi` where city='Hawaii Natl Park' && SIC_code='6021'DB:business_master_new
loadtime:0.72004199028015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawi' limit 1
loadtime:0.7200767993927 / seconds
Query Executed:select id FROM `hi` where city='Hawi' && SIC_code='6021'DB:business_master_new
loadtime:0.72055697441101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickam Afb' limit 1
loadtime:0.72059488296509 / seconds
Query Executed:select id FROM `hi` where city='Hickam Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.7210259437561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilo' limit 1
loadtime:0.72106981277466 / seconds
Query Executed:select id FROM `hi` where city='Hilo' && SIC_code='6021'DB:business_master_new
loadtime:0.72292184829712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holualoa' limit 1
loadtime:0.72296977043152 / seconds
Query Executed:select id FROM `hi` where city='Holualoa' && SIC_code='6021'DB:business_master_new
loadtime:0.72347688674927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaunau' limit 1
loadtime:0.72351598739624 / seconds
Query Executed:select id FROM `hi` where city='Honaunau' && SIC_code='6021'DB:business_master_new
loadtime:0.723965883255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honokaa' limit 1
loadtime:0.72400784492493 / seconds
Query Executed:select id FROM `hi` where city='Honokaa' && SIC_code='6021'DB:business_master_new
loadtime:0.7250189781189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honolulu' limit 1
loadtime:0.72506880760193 / seconds
Query Executed:select id FROM `hi` where city='Honolulu' && SIC_code='6021'DB:business_master_new
loadtime:0.72700786590576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honomu' limit 1
loadtime:0.72710394859314 / seconds
Query Executed:select id FROM `hi` where city='Honomu' && SIC_code='6021'DB:business_master_new
loadtime:0.72758197784424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoolehua' limit 1
loadtime:0.72763395309448 / seconds
Query Executed:select id FROM `hi` where city='Hoolehua' && SIC_code='6021'DB:business_master_new
loadtime:0.72810077667236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaaawa' limit 1
loadtime:0.72814583778381 / seconds
Query Executed:select id FROM `hi` where city='Kaaawa' && SIC_code='6021'DB:business_master_new
loadtime:0.72860884666443 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahuku' limit 1
loadtime:0.72864580154419 / seconds
Query Executed:select id FROM `hi` where city='Kahuku' && SIC_code='6021'DB:business_master_new
loadtime:0.72913885116577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahului' limit 1
loadtime:0.72919678688049 / seconds
Query Executed:select id FROM `hi` where city='Kahului' && SIC_code='6021'DB:business_master_new
loadtime:0.73104286193848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kailua' limit 1
loadtime:0.7310938835144 / seconds
Query Executed:select id FROM `hi` where city='Kailua' && SIC_code='6021'DB:business_master_new
loadtime:0.73293590545654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kailua Kona' limit 1
loadtime:0.73299598693848 / seconds
Query Executed:select id FROM `hi` where city='Kailua Kona' && SIC_code='6021'DB:business_master_new
loadtime:0.73484778404236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalaheo' limit 1
loadtime:0.73489594459534 / seconds
Query Executed:select id FROM `hi` where city='Kalaheo' && SIC_code='6021'DB:business_master_new
loadtime:0.73540091514587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalaupapa' limit 1
loadtime:0.73544597625732 / seconds
Query Executed:select id FROM `hi` where city='Kalaupapa' && SIC_code='6021'DB:business_master_new
loadtime:0.74612092971802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamuela' limit 1
loadtime:0.74616098403931 / seconds
Query Executed:select id FROM `hi` where city='Kamuela' && SIC_code='6021'DB:business_master_new
loadtime:0.74935984611511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaneohe' limit 1
loadtime:0.74941992759705 / seconds
Query Executed:select id FROM `hi` where city='Kaneohe' && SIC_code='6021'DB:business_master_new
loadtime:0.75188493728638 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapaa' limit 1
loadtime:0.75195384025574 / seconds
Query Executed:select id FROM `hi` where city='Kapaa' && SIC_code='6021'DB:business_master_new
loadtime:0.75380277633667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapaau' limit 1
loadtime:0.75385284423828 / seconds
Query Executed:select id FROM `hi` where city='Kapaau' && SIC_code='6021'DB:business_master_new
loadtime:0.75439882278442 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapolei' limit 1
loadtime:0.75444579124451 / seconds
Query Executed:select id FROM `hi` where city='Kapolei' && SIC_code='6021'DB:business_master_new
loadtime:0.75633192062378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaumakani' limit 1
loadtime:0.75637698173523 / seconds
Query Executed:select id FROM `hi` where city='Kaumakani' && SIC_code='6021'DB:business_master_new
loadtime:0.78734183311462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaunakakai' limit 1
loadtime:0.78739190101624 / seconds
Query Executed:select id FROM `hi` where city='Kaunakakai' && SIC_code='6021'DB:business_master_new
loadtime:0.78921794891357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keaau' limit 1
loadtime:0.78926181793213 / seconds
Query Executed:select id FROM `hi` where city='Keaau' && SIC_code='6021'DB:business_master_new
loadtime:0.79108691215515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kealakekua' limit 1
loadtime:0.79113698005676 / seconds
Query Executed:select id FROM `hi` where city='Kealakekua' && SIC_code='6021'DB:business_master_new
loadtime:0.79297280311584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kealia' limit 1
loadtime:0.79300999641418 / seconds
Query Executed:select id FROM `hi` where city='Kealia' && SIC_code='6021'DB:business_master_new
loadtime:0.81288385391235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keauhou' limit 1
loadtime:0.81293487548828 / seconds
Query Executed:select id FROM `hi` where city='Keauhou' && SIC_code='6021'DB:business_master_new
loadtime:0.8134229183197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kekaha' limit 1
loadtime:0.8134617805481 / seconds
Query Executed:select id FROM `hi` where city='Kekaha' && SIC_code='6021'DB:business_master_new
loadtime:0.81391882896423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kihei' limit 1
loadtime:0.81395387649536 / seconds
Query Executed:select id FROM `hi` where city='Kihei' && SIC_code='6021'DB:business_master_new
loadtime:0.81582188606262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilauea' limit 1
loadtime:0.81588387489319 / seconds
Query Executed:select id FROM `hi` where city='Kilauea' && SIC_code='6021'DB:business_master_new
loadtime:0.81641983985901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koloa' limit 1
loadtime:0.81645393371582 / seconds
Query Executed:select id FROM `hi` where city='Koloa' && SIC_code='6021'DB:business_master_new
loadtime:0.81826877593994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kualapuu' limit 1
loadtime:0.81834077835083 / seconds
Query Executed:select id FROM `hi` where city='Kualapuu' && SIC_code='6021'DB:business_master_new
loadtime:0.81878185272217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kula' limit 1
loadtime:0.81882286071777 / seconds
Query Executed:select id FROM `hi` where city='Kula' && SIC_code='6021'DB:business_master_new
loadtime:0.82066178321838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kunia' limit 1
loadtime:0.82070994377136 / seconds
Query Executed:select id FROM `hi` where city='Kunia' && SIC_code='6021'DB:business_master_new
loadtime:0.82114887237549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kurtistown' limit 1
loadtime:0.82118487358093 / seconds
Query Executed:select id FROM `hi` where city='Kurtistown' && SIC_code='6021'DB:business_master_new
loadtime:0.82167196273804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lahaina' limit 1
loadtime:0.82172179222107 / seconds
Query Executed:select id FROM `hi` where city='Lahaina' && SIC_code='6021'DB:business_master_new
loadtime:0.82354998588562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laie' limit 1
loadtime:0.82360982894897 / seconds
Query Executed:select id FROM `hi` where city='Laie' && SIC_code='6021'DB:business_master_new
loadtime:0.82411789894104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanai City' limit 1
loadtime:0.82416796684265 / seconds
Query Executed:select id FROM `hi` where city='Lanai City' && SIC_code='6021'DB:business_master_new
loadtime:0.82469391822815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laupahoehoe' limit 1
loadtime:0.82475185394287 / seconds
Query Executed:select id FROM `hi` where city='Laupahoehoe' && SIC_code='6021'DB:business_master_new
loadtime:0.82517600059509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawai' limit 1
loadtime:0.82521677017212 / seconds
Query Executed:select id FROM `hi` where city='Lawai' && SIC_code='6021'DB:business_master_new
loadtime:0.82567691802979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lihue' limit 1
loadtime:0.8257269859314 / seconds
Query Executed:select id FROM `hi` where city='Lihue' && SIC_code='6021'DB:business_master_new
loadtime:0.82758498191833 / seconds
Query loaded from cache:select * from geodata_geocity where city='M C B H Kaneohe Bay' limit 1
loadtime:0.82763600349426 / seconds
Query Executed:select id FROM `hi` where city='M C B H Kaneohe Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.82888078689575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Makawao' limit 1
loadtime:0.82892990112305 / seconds
Query Executed:select id FROM `hi` where city='Makawao' && SIC_code='6021'DB:business_master_new
loadtime:0.83077692985535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Makaweli' limit 1
loadtime:0.8308207988739 / seconds
Query Executed:select id FROM `hi` where city='Makaweli' && SIC_code='6021'DB:business_master_new
loadtime:0.83413195610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maunaloa' limit 1
loadtime:0.83417892456055 / seconds
Query Executed:select id FROM `hi` where city='Maunaloa' && SIC_code='6021'DB:business_master_new
loadtime:0.83479285240173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbh Kaneohe Bay' limit 1
loadtime:0.83484196662903 / seconds
Query Executed:select id FROM `hi` where city='Mcbh Kaneohe Bay' && SIC_code='6021'DB:business_master_new
loadtime:0.83532500267029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mililani' limit 1
loadtime:0.83535289764404 / seconds
Query Executed:select id FROM `hi` where city='Mililani' && SIC_code='6021'DB:business_master_new
loadtime:0.83906197547913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain View' limit 1
loadtime:0.83912181854248 / seconds
Query Executed:select id FROM `hi` where city='Mountain View' && SIC_code='6021'DB:business_master_new
loadtime:0.83971381187439 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naalehu' limit 1
loadtime:0.83975481987 / seconds
Query Executed:select id FROM `hi` where city='Naalehu' && SIC_code='6021'DB:business_master_new
loadtime:0.84042692184448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninole' limit 1
loadtime:0.84047484397888 / seconds
Query Executed:select id FROM `hi` where city='Ninole' && SIC_code='6021'DB:business_master_new
loadtime:0.84272789955139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean View' limit 1
loadtime:0.84277081489563 / seconds
Query Executed:select id FROM `hi` where city='Ocean View' && SIC_code='6021'DB:business_master_new
loadtime:0.84322500228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ookala' limit 1
loadtime:0.84328699111938 / seconds
Query Executed:select id FROM `hi` where city='Ookala' && SIC_code='6021'DB:business_master_new
loadtime:0.84544777870178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paauilo' limit 1
loadtime:0.84549784660339 / seconds
Query Executed:select id FROM `hi` where city='Paauilo' && SIC_code='6021'DB:business_master_new
loadtime:0.84591579437256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pahala' limit 1
loadtime:0.84594297409058 / seconds
Query Executed:select id FROM `hi` where city='Pahala' && SIC_code='6021'DB:business_master_new
loadtime:0.84678387641907 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pahoa' limit 1
loadtime:0.84683990478516 / seconds
Query Executed:select id FROM `hi` where city='Pahoa' && SIC_code='6021'DB:business_master_new
loadtime:0.84868597984314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paia' limit 1
loadtime:0.84873580932617 / seconds
Query Executed:select id FROM `hi` where city='Paia' && SIC_code='6021'DB:business_master_new
loadtime:0.85056185722351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Papaaloa' limit 1
loadtime:0.85062289237976 / seconds
Query Executed:select id FROM `hi` where city='Papaaloa' && SIC_code='6021'DB:business_master_new
loadtime:0.87613081932068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Papaikou' limit 1
loadtime:0.87616586685181 / seconds
Query Executed:select id FROM `hi` where city='Papaikou' && SIC_code='6021'DB:business_master_new
loadtime:0.87665677070618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl City' limit 1
loadtime:0.87670588493347 / seconds
Query Executed:select id FROM `hi` where city='Pearl City' && SIC_code='6021'DB:business_master_new
loadtime:0.87854480743408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl Harbor' limit 1
loadtime:0.87858891487122 / seconds
Query Executed:select id FROM `hi` where city='Pearl Harbor' && SIC_code='6021'DB:business_master_new
loadtime:0.87906193733215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepeekeo' limit 1
loadtime:0.87911295890808 / seconds
Query Executed:select id FROM `hi` where city='Pepeekeo' && SIC_code='6021'DB:business_master_new
loadtime:0.87952780723572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:0.87956595420837 / seconds
Query Executed:select id FROM `hi` where city='Princeville' && SIC_code='6021'DB:business_master_new
loadtime:0.88005185127258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukalani' limit 1
loadtime:0.8800938129425 / seconds
Query Executed:select id FROM `hi` where city='Pukalani' && SIC_code='6021'DB:business_master_new
loadtime:0.8805148601532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puunene' limit 1
loadtime:0.88056588172913 / seconds
Query Executed:select id FROM `hi` where city='Puunene' && SIC_code='6021'DB:business_master_new
loadtime:0.88100695610046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield Barracks' limit 1
loadtime:0.88104486465454 / seconds
Query Executed:select id FROM `hi` where city='Schofield Barracks' && SIC_code='6021'DB:business_master_new
loadtime:0.88148880004883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield Brrcks' limit 1
loadtime:0.88153886795044 / seconds
Query Executed:select id FROM `hi` where city='Schofield Brrcks' && SIC_code='6021'DB:business_master_new
loadtime:0.88230895996094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamc' limit 1
loadtime:0.88235187530518 / seconds
Query Executed:select id FROM `hi` where city='Tamc' && SIC_code='6021'DB:business_master_new
loadtime:0.88395500183105 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripler Amc' limit 1
loadtime:0.88400483131409 / seconds
Query Executed:select id FROM `hi` where city='Tripler Amc' && SIC_code='6021'DB:business_master_new
loadtime:0.88585782051086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volcano' limit 1
loadtime:0.88589286804199 / seconds
Query Executed:select id FROM `hi` where city='Volcano' && SIC_code='6021'DB:business_master_new
loadtime:0.88633990287781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wahiawa' limit 1
loadtime:0.88638091087341 / seconds
Query Executed:select id FROM `hi` where city='Wahiawa' && SIC_code='6021'DB:business_master_new
loadtime:0.88822484016418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waialua' limit 1
loadtime:0.88829398155212 / seconds
Query Executed:select id FROM `hi` where city='Waialua' && SIC_code='6021'DB:business_master_new
loadtime:0.88880586624146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waianae' limit 1
loadtime:0.88885092735291 / seconds
Query Executed:select id FROM `hi` where city='Waianae' && SIC_code='6021'DB:business_master_new
loadtime:0.89067077636719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waikoloa' limit 1
loadtime:0.89072799682617 / seconds
Query Executed:select id FROM `hi` where city='Waikoloa' && SIC_code='6021'DB:business_master_new
loadtime:0.89252781867981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wailuku' limit 1
loadtime:0.89257788658142 / seconds
Query Executed:select id FROM `hi` where city='Wailuku' && SIC_code='6021'DB:business_master_new
loadtime:0.89440298080444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waimanalo' limit 1
loadtime:0.89446187019348 / seconds
Query Executed:select id FROM `hi` where city='Waimanalo' && SIC_code='6021'DB:business_master_new
loadtime:0.89629197120667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waimea' limit 1
loadtime:0.89632892608643 / seconds
Query Executed:select id FROM `hi` where city='Waimea' && SIC_code='6021'DB:business_master_new
loadtime:0.89685082435608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waipahu' limit 1
loadtime:0.8969099521637 / seconds
Query Executed:select id FROM `hi` where city='Waipahu' && SIC_code='6021'DB:business_master_new
loadtime:0.8987398147583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler Afb' limit 1
loadtime:0.89878487586975 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.90033888816833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler Army Airfield' limit 1
loadtime:0.90039396286011 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Army Airfield' && SIC_code='6021'DB:business_master_new
loadtime:0.90081095695496 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.90088582038879 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.90102076530457 / seconds
Operation template executed (chunk cache operation)
loadtime:0.90108180046082 / seconds
template override:Default
loadtime:0.90110087394714 / 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.90187382698059 / seconds
Template Constructed, Array Rows:49
loadtime:0.9021008014679 / seconds
TOTAL EXECUTION TIME: 0.90192
loadtime:0.90217781066895 / 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.90218281745911
TOTAL KEY ARRAYS: 69