Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:6.4849853515625E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017738342285156 / seconds
host not found setting manual db connection
loadtime:0.0097529888153076 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010033845901489 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.010191917419434 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.010255813598633 / seconds
zipcode:
loadtime:0.010283946990967 / seconds
Query Executed:select * from search_referrer where page_hash='5320a316e47d73362215bbb4292148f8' limit 10 DB:ezrox_toadli
loadtime:0.010509014129639 / seconds
Operation header executed (non global)
loadtime:0.01053786277771 / seconds
Operation leaderboard executed (non global)
loadtime:0.010589838027954 / seconds
Operation square executed (non global)
loadtime:0.010618925094604 / seconds
Operation square_bottom executed (non global)
loadtime:0.010648965835571 / seconds
Operation smallsquare executed (non global)
loadtime:0.010674953460693 / seconds
Operation headeradright executed (non global)
loadtime:0.010699987411499 / seconds
Operation google_analytics executed (non global)
loadtime:0.010725021362305 / seconds
Operation topstories executed (non global)
loadtime:0.010749816894531 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010776996612549 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010816812515259 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011055946350098 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011219024658203 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011262893676758 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011337995529175 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011387825012207 / seconds
Template key: archive_menu pushed
loadtime:0.011396884918213 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.01141095161438 / seconds
Template key: get_gravatar pushed
loadtime:0.011417865753174 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.01142692565918 / seconds
*10)-10)+1 | start:0
loadtime:0.011469841003418 / seconds
Query loaded from cache:select * from categories where cat_URLid='real-estate-agents-and-managers'
loadtime:0.011523008346558 / seconds
DB connected to localhost business_master_new
loadtime:0.011742830276489 / seconds
Query Executed:select * from geodata_usstates where url_id='hawaii'DB:business_master_new
loadtime:0.01193380355835 / seconds
Query stored in cache : _QUERY_www.toadli.comb43919b2acbd6dcfc29173062b68cee0
loadtime:0.011999845504761 / seconds
Query Executed:select * from `hi_catmap` where sic='6531' order by city ascDB:business_master_new
loadtime:0.022689819335938 / seconds
Query stored in cache : _QUERY_www.toadli.comb5cf443becbcfaada3bf683f737707da
loadtime:0.023123979568481 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.023168802261353 / seconds
Query Executed:select sum(totalcount) as totalsum from `hi_catmap` where sic='6531'DB:business_master_new
loadtime:0.023891925811768 / seconds
Query stored in cache : _QUERY_www.toadli.com4467294d0245383cb7d618615a83cae2
loadtime:0.023928880691528 / seconds
96 / 11
loadtime:0.023990869522095 / seconds
Query Executed:select * from geodata_geocity where city='Aiea' limit 1DB:business_master_new
loadtime:0.024415969848633 / seconds
Query stored in cache : _QUERY_www.toadli.com704129cefaae80c4f5eacff56b995207
loadtime:0.024484872817993 / seconds
Query Executed:select id FROM `hi` where city='Aiea' && SIC_code='6531'DB:business_master_new
loadtime:0.054673910140991 / seconds
Query Executed:select * from geodata_geocity where city='Anahola' limit 1DB:business_master_new
loadtime:0.055256843566895 / seconds
Query stored in cache : _QUERY_www.toadli.come43c83a5745a4e9504b74d4ad2e7c4ba
loadtime:0.055331945419312 / seconds
Query Executed:select id FROM `hi` where city='Anahola' && SIC_code='6531'DB:business_master_new
loadtime:0.056270837783813 / seconds
Query Executed:select * from geodata_geocity where city='Camp H M Smith' limit 1DB:business_master_new
loadtime:0.05675196647644 / seconds
Query stored in cache : _QUERY_www.toadli.com6c8fad2725073ab3b50eb2e56cd657f2
loadtime:0.056831836700439 / seconds
Query Executed:select id FROM `hi` where city='Camp H M Smith' && SIC_code='6531'DB:business_master_new
loadtime:0.057329893112183 / seconds
Query Executed:select * from geodata_geocity where city='Captain Cook' limit 1DB:business_master_new
loadtime:0.057729005813599 / seconds
Query stored in cache : _QUERY_www.toadli.com8562e6208e8c0806d34954c15be1a2de
loadtime:0.057801008224487 / seconds
Query Executed:select id FROM `hi` where city='Captain Cook' && SIC_code='6531'DB:business_master_new
loadtime:0.080753803253174 / seconds
Query Executed:select * from geodata_geocity where city='Eleele' limit 1DB:business_master_new
loadtime:0.081192970275879 / seconds
Query stored in cache : _QUERY_www.toadli.com27c172c03251b730cb91c128042aca63
loadtime:0.081271886825562 / seconds
Query Executed:select id FROM `hi` where city='Eleele' && SIC_code='6531'DB:business_master_new
loadtime:0.082351922988892 / seconds
Query Executed:select * from geodata_geocity where city='Ewa Beach' limit 1DB:business_master_new
loadtime:0.082736015319824 / seconds
Query stored in cache : _QUERY_www.toadli.comc074803ecc05500983b016abd83def10
loadtime:0.082814931869507 / seconds
Query Executed:select id FROM `hi` where city='Ewa Beach' && SIC_code='6531'DB:business_master_new
loadtime:0.089672803878784 / seconds
Query Executed:select * from geodata_geocity where city='Fort Shafter' limit 1DB:business_master_new
loadtime:0.090139865875244 / seconds
Query stored in cache : _QUERY_www.toadli.com1368863a8b4d4c817cab7aab79d6fc8d
loadtime:0.0902099609375 / seconds
Query Executed:select id FROM `hi` where city='Fort Shafter' && SIC_code='6531'DB:business_master_new
loadtime:0.090762853622437 / seconds
Query Executed:select * from geodata_geocity where city='Haiku' limit 1DB:business_master_new
loadtime:0.091192007064819 / seconds
Query stored in cache : _QUERY_www.toadli.com6dd396424aded44e0820eb6b98abee81
loadtime:0.091256856918335 / seconds
Query Executed:select id FROM `hi` where city='Haiku' && SIC_code='6531'DB:business_master_new
loadtime:0.097108840942383 / seconds
Query Executed:select * from geodata_geocity where city='Hakalau' limit 1DB:business_master_new
loadtime:0.097534894943237 / seconds
Query stored in cache : _QUERY_www.toadli.comb722459ca29db3f6b19e9c8436b96d29
loadtime:0.097599029541016 / seconds
Query Executed:select id FROM `hi` where city='Hakalau' && SIC_code='6531'DB:business_master_new
loadtime:0.098176002502441 / seconds
Query Executed:select * from geodata_geocity where city='Haleiwa' limit 1DB:business_master_new
loadtime:0.098591804504395 / seconds
Query stored in cache : _QUERY_www.toadli.comd58b316f0928dc113fcaf8dd9eabd7ad
loadtime:0.098656892776489 / seconds
Query Executed:select id FROM `hi` where city='Haleiwa' && SIC_code='6531'DB:business_master_new
loadtime:0.10500192642212 / seconds
Query Executed:select * from geodata_geocity where city='Hana' limit 1DB:business_master_new
loadtime:0.10551500320435 / seconds
Query stored in cache : _QUERY_www.toadli.com4223b2d132fdebd5479168ee68542e7b
loadtime:0.10558581352234 / seconds
Query Executed:select id FROM `hi` where city='Hana' && SIC_code='6531'DB:business_master_new
loadtime:0.10715293884277 / seconds
Query Executed:select * from geodata_geocity where city='Hanalei' limit 1DB:business_master_new
loadtime:0.10762882232666 / seconds
Query stored in cache : _QUERY_www.toadli.com51c9fe3be736ead6942e745535321257
loadtime:0.10769391059875 / seconds
Query Executed:select id FROM `hi` where city='Hanalei' && SIC_code='6531'DB:business_master_new
loadtime:0.13029384613037 / seconds
Query Executed:select * from geodata_geocity where city='Hanamaulu' limit 1DB:business_master_new
loadtime:0.13082194328308 / seconds
Query stored in cache : _QUERY_www.toadli.com1f80758304e9f127846fe846f2089e41
loadtime:0.13088798522949 / seconds
Query Executed:select id FROM `hi` where city='Hanamaulu' && SIC_code='6531'DB:business_master_new
loadtime:0.13138794898987 / seconds
Query Executed:select * from geodata_geocity where city='Hanapepe' limit 1DB:business_master_new
loadtime:0.1318678855896 / seconds
Query stored in cache : _QUERY_www.toadli.com80a8bb0e4ff0ab3d69704c4498b60be4
loadtime:0.13193297386169 / seconds
Query Executed:select id FROM `hi` where city='Hanapepe' && SIC_code='6531'DB:business_master_new
loadtime:0.15367102622986 / seconds
Query Executed:select * from geodata_geocity where city='Hauula' limit 1DB:business_master_new
loadtime:0.15410184860229 / seconds
Query stored in cache : _QUERY_www.toadli.com3517aa6e15bf70383df7d1b11e515958
loadtime:0.15416884422302 / seconds
Query Executed:select id FROM `hi` where city='Hauula' && SIC_code='6531'DB:business_master_new
loadtime:0.15555191040039 / seconds
Query Executed:select * from geodata_geocity where city='Hawaii National Park' limit 1DB:business_master_new
loadtime:0.15600180625916 / seconds
Query stored in cache : _QUERY_www.toadli.com803c21bf744e1f7ee012108112de56cd
loadtime:0.15606689453125 / seconds
Query Executed:select id FROM `hi` where city='Hawaii National Park' && SIC_code='6531'DB:business_master_new
loadtime:0.1566469669342 / seconds
Query Executed:select * from geodata_geocity where city='Hawaii Natl Park' limit 1DB:business_master_new
loadtime:0.15708494186401 / seconds
Query stored in cache : _QUERY_www.toadli.come36ffd71669772d12339d8e5bce5fb7f
loadtime:0.15715599060059 / seconds
Query Executed:select id FROM `hi` where city='Hawaii Natl Park' && SIC_code='6531'DB:business_master_new
loadtime:0.1576189994812 / seconds
Query Executed:select * from geodata_geocity where city='Hawi' limit 1DB:business_master_new
loadtime:0.15805888175964 / seconds
Query stored in cache : _QUERY_www.toadli.com12a8aedbff5a91e5135f8b44979fdbcf
loadtime:0.15812802314758 / seconds
Query Executed:select id FROM `hi` where city='Hawi' && SIC_code='6531'DB:business_master_new
loadtime:0.1592538356781 / seconds
Query Executed:select * from geodata_geocity where city='Hickam Afb' limit 1DB:business_master_new
loadtime:0.15966296195984 / seconds
Query stored in cache : _QUERY_www.toadli.com33e2521e4b2afdf9ce8082bc1080d880
loadtime:0.15973091125488 / seconds
Query Executed:select id FROM `hi` where city='Hickam Afb' && SIC_code='6531'DB:business_master_new
loadtime:0.16039991378784 / seconds
Query Executed:select * from geodata_geocity where city='Hilo' limit 1DB:business_master_new
loadtime:0.16084289550781 / seconds
Query stored in cache : _QUERY_www.toadli.comc5701bbc1c2058ff630c0f39170dd5c5
loadtime:0.16091084480286 / seconds
Query Executed:select id FROM `hi` where city='Hilo' && SIC_code='6531'DB:business_master_new
loadtime:0.19871187210083 / seconds
Query Executed:select * from geodata_geocity where city='Holualoa' limit 1DB:business_master_new
loadtime:0.19942688941956 / seconds
Query stored in cache : _QUERY_www.toadli.com65dd0a4dfa6b6effb1381687a12bb00c
loadtime:0.19950580596924 / seconds
Query Executed:select id FROM `hi` where city='Holualoa' && SIC_code='6531'DB:business_master_new
loadtime:0.22199392318726 / seconds
Query Executed:select * from geodata_geocity where city='Honaunau' limit 1DB:business_master_new
loadtime:0.22249293327332 / seconds
Query stored in cache : _QUERY_www.toadli.com77b265e91ce68bace87fd8f23194fcff
loadtime:0.22255992889404 / seconds
Query Executed:select id FROM `hi` where city='Honaunau' && SIC_code='6531'DB:business_master_new
loadtime:0.22364497184753 / seconds
Query Executed:select * from geodata_geocity where city='Honokaa' limit 1DB:business_master_new
loadtime:0.22414493560791 / seconds
Query stored in cache : _QUERY_www.toadli.com524eb80145b2216f06188e9602b1220a
loadtime:0.22421097755432 / seconds
Query Executed:select id FROM `hi` where city='Honokaa' && SIC_code='6531'DB:business_master_new
loadtime:0.24617695808411 / seconds
Query Executed:select * from geodata_geocity where city='Honolulu' limit 1DB:business_master_new
loadtime:0.24668502807617 / seconds
Query stored in cache : _QUERY_www.toadli.com34866c4636ebdd32e0e8b95f27766ddb
loadtime:0.24674987792969 / seconds
Query Executed:select id FROM `hi` where city='Honolulu' && SIC_code='6531'DB:business_master_new
loadtime:0.2724449634552 / seconds
Query Executed:select * from geodata_geocity where city='Honomu' limit 1DB:business_master_new
loadtime:0.27463793754578 / seconds
Query stored in cache : _QUERY_www.toadli.comf5041aa1172bec1c413c7f1809d0a64a
loadtime:0.27471089363098 / seconds
Query Executed:select id FROM `hi` where city='Honomu' && SIC_code='6531'DB:business_master_new
loadtime:0.27544093132019 / seconds
Query Executed:select * from geodata_geocity where city='Hoolehua' limit 1DB:business_master_new
loadtime:0.27602601051331 / seconds
Query stored in cache : _QUERY_www.toadli.com33620656364ce854d2b05c05cc7417b4
loadtime:0.27609300613403 / seconds
Query Executed:select id FROM `hi` where city='Hoolehua' && SIC_code='6531'DB:business_master_new
loadtime:0.27695393562317 / seconds
Query Executed:select * from geodata_geocity where city='Kaaawa' limit 1DB:business_master_new
loadtime:0.27737402915955 / seconds
Query stored in cache : _QUERY_www.toadli.comf5f9fa157d4eef648b95b6aea754814c
loadtime:0.27743792533875 / seconds
Query Executed:select id FROM `hi` where city='Kaaawa' && SIC_code='6531'DB:business_master_new
loadtime:0.27830195426941 / seconds
Query Executed:select * from geodata_geocity where city='Kahuku' limit 1DB:business_master_new
loadtime:0.27873492240906 / seconds
Query stored in cache : _QUERY_www.toadli.com240155c3149b14d09b6769c55a83e3d4
loadtime:0.27881503105164 / seconds
Query Executed:select id FROM `hi` where city='Kahuku' && SIC_code='6531'DB:business_master_new
loadtime:0.30079889297485 / seconds
Query Executed:select * from geodata_geocity where city='Kahului' limit 1DB:business_master_new
loadtime:0.30124092102051 / seconds
Query stored in cache : _QUERY_www.toadli.com9b3d2bdf0077bfabeb2bf8f024a72553
loadtime:0.30130887031555 / seconds
Query Executed:select id FROM `hi` where city='Kahului' && SIC_code='6531'DB:business_master_new
loadtime:0.31972503662109 / seconds
Query Executed:select * from geodata_geocity where city='Kailua' limit 1DB:business_master_new
loadtime:0.32024002075195 / seconds
Query stored in cache : _QUERY_www.toadli.com71e3077879f93a44a2286f07b15c7eb4
loadtime:0.320307970047 / seconds
Query Executed:select id FROM `hi` where city='Kailua' && SIC_code='6531'DB:business_master_new
loadtime:0.34281301498413 / seconds
Query Executed:select * from geodata_geocity where city='Kailua Kona' limit 1DB:business_master_new
loadtime:0.34337592124939 / seconds
Query stored in cache : _QUERY_www.toadli.comf0c70b542b8b1841501165fe9423a495
loadtime:0.34344291687012 / seconds
Query Executed:select id FROM `hi` where city='Kailua Kona' && SIC_code='6531'DB:business_master_new
loadtime:0.37309098243713 / seconds
Query Executed:select * from geodata_geocity where city='Kalaheo' limit 1DB:business_master_new
loadtime:0.37382483482361 / seconds
Query stored in cache : _QUERY_www.toadli.com82125d30f00c6faeddd0bcc212349086
loadtime:0.37389993667603 / seconds
Query Executed:select id FROM `hi` where city='Kalaheo' && SIC_code='6531'DB:business_master_new
loadtime:0.39687490463257 / seconds
Query Executed:select * from geodata_geocity where city='Kalaupapa' limit 1DB:business_master_new
loadtime:0.39736199378967 / seconds
Query stored in cache : _QUERY_www.toadli.comb5d7fc7374e1484a5a26cf01a0de8e63
loadtime:0.39743781089783 / seconds
Query Executed:select id FROM `hi` where city='Kalaupapa' && SIC_code='6531'DB:business_master_new
loadtime:0.39799499511719 / seconds
Query Executed:select * from geodata_geocity where city='Kamuela' limit 1DB:business_master_new
loadtime:0.39841103553772 / seconds
Query stored in cache : _QUERY_www.toadli.com3904505cf8910b5ee5e3368bd7daf010
loadtime:0.39847493171692 / seconds
Query Executed:select id FROM `hi` where city='Kamuela' && SIC_code='6531'DB:business_master_new
loadtime:0.40951180458069 / seconds
Query Executed:select * from geodata_geocity where city='Kaneohe' limit 1DB:business_master_new
loadtime:0.4100558757782 / seconds
Query stored in cache : _QUERY_www.toadli.com9a7921ccf49db5db2b0bf62bd77e723c
loadtime:0.41012191772461 / seconds
Query Executed:select id FROM `hi` where city='Kaneohe' && SIC_code='6531'DB:business_master_new
loadtime:0.42916703224182 / seconds
Query Executed:select * from geodata_geocity where city='Kapaa' limit 1DB:business_master_new
loadtime:0.42967081069946 / seconds
Query stored in cache : _QUERY_www.toadli.com0baf12a8a83c37660e45bb0b2455e636
loadtime:0.42973780632019 / seconds
Query Executed:select id FROM `hi` where city='Kapaa' && SIC_code='6531'DB:business_master_new
loadtime:0.44162392616272 / seconds
Query Executed:select * from geodata_geocity where city='Kapaau' limit 1DB:business_master_new
loadtime:0.44209599494934 / seconds
Query stored in cache : _QUERY_www.toadli.comd2ed776e83bcbb214e0fba03365d3ba7
loadtime:0.44216299057007 / seconds
Query Executed:select id FROM `hi` where city='Kapaau' && SIC_code='6531'DB:business_master_new
loadtime:0.46477103233337 / seconds
Query Executed:select * from geodata_geocity where city='Kapolei' limit 1DB:business_master_new
loadtime:0.46520280838013 / seconds
Query stored in cache : _QUERY_www.toadli.com1ad35d83072e676691c349742af38792
loadtime:0.46527099609375 / seconds
Query Executed:select id FROM `hi` where city='Kapolei' && SIC_code='6531'DB:business_master_new
loadtime:0.47532892227173 / seconds
Query Executed:select * from geodata_geocity where city='Kaumakani' limit 1DB:business_master_new
loadtime:0.4757719039917 / seconds
Query stored in cache : _QUERY_www.toadli.coma63b4a8a527d8e1fdce0da446a31a7cd
loadtime:0.47584891319275 / seconds
Query Executed:select id FROM `hi` where city='Kaumakani' && SIC_code='6531'DB:business_master_new
loadtime:0.4764609336853 / seconds
Query Executed:select * from geodata_geocity where city='Kaunakakai' limit 1DB:business_master_new
loadtime:0.47687602043152 / seconds
Query stored in cache : _QUERY_www.toadli.com15bcec43e0efdceaf8f0a5c4bee0d503
loadtime:0.47694087028503 / seconds
Query Executed:select id FROM `hi` where city='Kaunakakai' && SIC_code='6531'DB:business_master_new
loadtime:0.4991500377655 / seconds
Query Executed:select * from geodata_geocity where city='Keaau' limit 1DB:business_master_new
loadtime:0.49959492683411 / seconds
Query stored in cache : _QUERY_www.toadli.comb1c9d4508c81294b2117c37c4de6288c
loadtime:0.49966502189636 / seconds
Query Executed:select id FROM `hi` where city='Keaau' && SIC_code='6531'DB:business_master_new
loadtime:0.52177286148071 / seconds
Query Executed:select * from geodata_geocity where city='Kealakekua' limit 1DB:business_master_new
loadtime:0.52223300933838 / seconds
Query stored in cache : _QUERY_www.toadli.comceef9f6ba42cc67db7a59ce282a5c661
loadtime:0.52229881286621 / seconds
Query Executed:select id FROM `hi` where city='Kealakekua' && SIC_code='6531'DB:business_master_new
loadtime:0.52752184867859 / seconds
Query Executed:select * from geodata_geocity where city='Kealia' limit 1DB:business_master_new
loadtime:0.52798390388489 / seconds
Query stored in cache : _QUERY_www.toadli.com53b8daf34c5aeda9c74d29af17ff0457
loadtime:0.5280499458313 / seconds
Query Executed:select id FROM `hi` where city='Kealia' && SIC_code='6531'DB:business_master_new
loadtime:0.52861595153809 / seconds
Query Executed:select * from geodata_geocity where city='Keauhou' limit 1DB:business_master_new
loadtime:0.52907991409302 / seconds
Query stored in cache : _QUERY_www.toadli.com7cf1a2f43f3cdf9e2c64c5a903910821
loadtime:0.52914595603943 / seconds
Query Executed:select id FROM `hi` where city='Keauhou' && SIC_code='6531'DB:business_master_new
loadtime:0.53039383888245 / seconds
Query Executed:select * from geodata_geocity where city='Kekaha' limit 1DB:business_master_new
loadtime:0.53086185455322 / seconds
Query stored in cache : _QUERY_www.toadli.com5666ea1c4e40140ef8f3e6ad953f4ca7
loadtime:0.53093481063843 / seconds
Query Executed:select id FROM `hi` where city='Kekaha' && SIC_code='6531'DB:business_master_new
loadtime:0.53204989433289 / seconds
Query Executed:select * from geodata_geocity where city='Kihei' limit 1DB:business_master_new
loadtime:0.5324809551239 / seconds
Query stored in cache : _QUERY_www.toadli.com5651a247378fd45fddf894a591c90d03
loadtime:0.53255081176758 / seconds
Query Executed:select id FROM `hi` where city='Kihei' && SIC_code='6531'DB:business_master_new
loadtime:0.55284094810486 / seconds
Query Executed:select * from geodata_geocity where city='Kilauea' limit 1DB:business_master_new
loadtime:0.55352187156677 / seconds
Query stored in cache : _QUERY_www.toadli.com96ddc5d2e249f644657dbc316a4eed50
loadtime:0.5535888671875 / seconds
Query Executed:select id FROM `hi` where city='Kilauea' && SIC_code='6531'DB:business_master_new
loadtime:0.57622385025024 / seconds
Query Executed:select * from geodata_geocity where city='Koloa' limit 1DB:business_master_new
loadtime:0.57675099372864 / seconds
Query stored in cache : _QUERY_www.toadli.comb6b1cafd8aeea36ddcaf730dfe99c368
loadtime:0.57682681083679 / seconds
Query Executed:select id FROM `hi` where city='Koloa' && SIC_code='6531'DB:business_master_new
loadtime:0.58307981491089 / seconds
Query Executed:select * from geodata_geocity where city='Kualapuu' limit 1DB:business_master_new
loadtime:0.58354187011719 / seconds
Query stored in cache : _QUERY_www.toadli.com6974acbf369d28993270c8f0e18893ca
loadtime:0.5836079120636 / seconds
Query Executed:select id FROM `hi` where city='Kualapuu' && SIC_code='6531'DB:business_master_new
loadtime:0.58444499969482 / seconds
Query Executed:select * from geodata_geocity where city='Kula' limit 1DB:business_master_new
loadtime:0.5848708152771 / seconds
Query stored in cache : _QUERY_www.toadli.com3f301d90f5a83aa2fe5dd3723a312ee0
loadtime:0.58494091033936 / seconds
Query Executed:select id FROM `hi` where city='Kula' && SIC_code='6531'DB:business_master_new
loadtime:0.59088087081909 / seconds
Query Executed:select * from geodata_geocity where city='Kunia' limit 1DB:business_master_new
loadtime:0.59129285812378 / seconds
Query stored in cache : _QUERY_www.toadli.com64cf3e27b3d0107ee00701976ba51ce5
loadtime:0.59135890007019 / seconds
Query Executed:select id FROM `hi` where city='Kunia' && SIC_code='6531'DB:business_master_new
loadtime:0.59193181991577 / seconds
Query Executed:select * from geodata_geocity where city='Kurtistown' limit 1DB:business_master_new
loadtime:0.59233689308167 / seconds
Query stored in cache : _QUERY_www.toadli.com9899ebc92dfd38f23bfb5aed1b08e28f
loadtime:0.59240484237671 / seconds
Query Executed:select id FROM `hi` where city='Kurtistown' && SIC_code='6531'DB:business_master_new
loadtime:0.59349989891052 / seconds
Query Executed:select * from geodata_geocity where city='Lahaina' limit 1DB:business_master_new
loadtime:0.59397888183594 / seconds
Query stored in cache : _QUERY_www.toadli.comed6d806fda55e4df7dfb1920fb401e66
loadtime:0.59404897689819 / seconds
Query Executed:select id FROM `hi` where city='Lahaina' && SIC_code='6531'DB:business_master_new
loadtime:0.61372995376587 / seconds
Query Executed:select * from geodata_geocity where city='Laie' limit 1DB:business_master_new
loadtime:0.61431193351746 / seconds
Query stored in cache : _QUERY_www.toadli.com3bdaa4587af9c55504dee9a5c43af543
loadtime:0.61438703536987 / seconds
Query Executed:select id FROM `hi` where city='Laie' && SIC_code='6531'DB:business_master_new
loadtime:0.61590480804443 / seconds
Query Executed:select * from geodata_geocity where city='Lanai City' limit 1DB:business_master_new
loadtime:0.61633682250977 / seconds
Query stored in cache : _QUERY_www.toadli.com3ed3d230cb1048ef02d4eebcdcf45b59
loadtime:0.61640596389771 / seconds
Query Executed:select id FROM `hi` where city='Lanai City' && SIC_code='6531'DB:business_master_new
loadtime:0.63883590698242 / seconds
Query Executed:select * from geodata_geocity where city='Laupahoehoe' limit 1DB:business_master_new
loadtime:0.6393449306488 / seconds
Query stored in cache : _QUERY_www.toadli.coma2121bf756f0b3ca6a5fa18066a65a96
loadtime:0.63941097259521 / seconds
Query Executed:select id FROM `hi` where city='Laupahoehoe' && SIC_code='6531'DB:business_master_new
loadtime:0.64010381698608 / seconds
Query Executed:select * from geodata_geocity where city='Lawai' limit 1DB:business_master_new
loadtime:0.64054584503174 / seconds
Query stored in cache : _QUERY_www.toadli.comffd6cab29c96704fe1efcb5d12145aa3
loadtime:0.64061689376831 / seconds
Query Executed:select id FROM `hi` where city='Lawai' && SIC_code='6531'DB:business_master_new
loadtime:0.64183187484741 / seconds
Query Executed:select * from geodata_geocity where city='Lihue' limit 1DB:business_master_new
loadtime:0.64228081703186 / seconds
Query stored in cache : _QUERY_www.toadli.com32b13fc6ae1576fd8b7140db5eff3352
loadtime:0.64234590530396 / seconds
Query Executed:select id FROM `hi` where city='Lihue' && SIC_code='6531'DB:business_master_new
loadtime:0.6594660282135 / seconds
Query Executed:select * from geodata_geocity where city='M C B H Kaneohe Bay' limit 1DB:business_master_new
loadtime:0.65999484062195 / seconds
Query stored in cache : _QUERY_www.toadli.comdf1335ba806bc1dde561794297ced950
loadtime:0.66006302833557 / seconds
Query Executed:select id FROM `hi` where city='M C B H Kaneohe Bay' && SIC_code='6531'DB:business_master_new
loadtime:0.66051888465881 / seconds
Query Executed:select * from geodata_geocity where city='Makawao' limit 1DB:business_master_new
loadtime:0.660964012146 / seconds
Query stored in cache : _QUERY_www.toadli.comfbad2a3ff9f6e788d5f04b7dc5383cc4
loadtime:0.66102886199951 / seconds
Query Executed:select id FROM `hi` where city='Makawao' && SIC_code='6531'DB:business_master_new
loadtime:0.66983795166016 / seconds
Query Executed:select * from geodata_geocity where city='Makaweli' limit 1DB:business_master_new
loadtime:0.67032384872437 / seconds
Query stored in cache : _QUERY_www.toadli.com69df35449ce0b11fb4c4311c44612d7e
loadtime:0.67039585113525 / seconds
Query Executed:select id FROM `hi` where city='Makaweli' && SIC_code='6531'DB:business_master_new
loadtime:0.67084693908691 / seconds
Query Executed:select * from geodata_geocity where city='Maunaloa' limit 1DB:business_master_new
loadtime:0.67125296592712 / seconds
Query stored in cache : _QUERY_www.toadli.com67d0e174cdfa4e680022d1a17720c55b
loadtime:0.67131781578064 / seconds
Query Executed:select id FROM `hi` where city='Maunaloa' && SIC_code='6531'DB:business_master_new
loadtime:0.67202281951904 / seconds
Query Executed:select * from geodata_geocity where city='Mcbh Kaneohe Bay' limit 1DB:business_master_new
loadtime:0.67240190505981 / seconds
Query stored in cache : _QUERY_www.toadli.combec69de72c3eab96c13194c2c8ed7ecb
loadtime:0.67246580123901 / seconds
Query Executed:select id FROM `hi` where city='Mcbh Kaneohe Bay' && SIC_code='6531'DB:business_master_new
loadtime:0.6730968952179 / seconds
Query Executed:select * from geodata_geocity where city='Mililani' limit 1DB:business_master_new
loadtime:0.67350888252258 / seconds
Query stored in cache : _QUERY_www.toadli.com3dccde69627d7f207637ff032c933aba
loadtime:0.67357301712036 / seconds
Query Executed:select id FROM `hi` where city='Mililani' && SIC_code='6531'DB:business_master_new
loadtime:0.6828978061676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain View' limit 1
loadtime:0.68303203582764 / seconds
Query Executed:select id FROM `hi` where city='Mountain View' && SIC_code='6531'DB:business_master_new
loadtime:0.68426203727722 / seconds
Query Executed:select * from geodata_geocity where city='Naalehu' limit 1DB:business_master_new
loadtime:0.68473887443542 / seconds
Query stored in cache : _QUERY_www.toadli.com4dec800d5eef34b2a9646804a5e8953b
loadtime:0.68481993675232 / seconds
Query Executed:select id FROM `hi` where city='Naalehu' && SIC_code='6531'DB:business_master_new
loadtime:0.68642282485962 / seconds
Query Executed:select * from geodata_geocity where city='Ninole' limit 1DB:business_master_new
loadtime:0.68688297271729 / seconds
Query stored in cache : _QUERY_www.toadli.com62f8966b832b62cd25521b333185d659
loadtime:0.68695092201233 / seconds
Query Executed:select id FROM `hi` where city='Ninole' && SIC_code='6531'DB:business_master_new
loadtime:0.68741893768311 / seconds
Query Executed:select * from geodata_geocity where city='Ocean View' limit 1DB:business_master_new
loadtime:0.68789601325989 / seconds
Query stored in cache : _QUERY_www.toadli.com6ca4e5bdb44dcdddf290022a039b9796
loadtime:0.68797302246094 / seconds
Query Executed:select id FROM `hi` where city='Ocean View' && SIC_code='6531'DB:business_master_new
loadtime:0.68883895874023 / seconds
Query Executed:select * from geodata_geocity where city='Ookala' limit 1DB:business_master_new
loadtime:0.68933391571045 / seconds
Query stored in cache : _QUERY_www.toadli.com546c06f7f41b882569a785b6ed61d744
loadtime:0.68939781188965 / seconds
Query Executed:select id FROM `hi` where city='Ookala' && SIC_code='6531'DB:business_master_new
loadtime:0.68990683555603 / seconds
Query Executed:select * from geodata_geocity where city='Paauilo' limit 1DB:business_master_new
loadtime:0.69034600257874 / seconds
Query stored in cache : _QUERY_www.toadli.com0219a3ae088f1ec78baaa28d24ddf479
loadtime:0.69041180610657 / seconds
Query Executed:select id FROM `hi` where city='Paauilo' && SIC_code='6531'DB:business_master_new
loadtime:0.69124984741211 / seconds
Query Executed:select * from geodata_geocity where city='Pahala' limit 1DB:business_master_new
loadtime:0.69168090820312 / seconds
Query stored in cache : _QUERY_www.toadli.com6219f4aef4576b746de3adc5a22add9c
loadtime:0.69174790382385 / seconds
Query Executed:select id FROM `hi` where city='Pahala' && SIC_code='6531'DB:business_master_new
loadtime:0.69272899627686 / seconds
Query Executed:select * from geodata_geocity where city='Pahoa' limit 1DB:business_master_new
loadtime:0.69317483901978 / seconds
Query stored in cache : _QUERY_www.toadli.comb6e619e2267d57c2f53a5d815811354c
loadtime:0.69324588775635 / seconds
Query Executed:select id FROM `hi` where city='Pahoa' && SIC_code='6531'DB:business_master_new
loadtime:0.71589493751526 / seconds
Query Executed:select * from geodata_geocity where city='Paia' limit 1DB:business_master_new
loadtime:0.71635103225708 / seconds
Query stored in cache : _QUERY_www.toadli.comed7b8c9ea4c2b6428ed3cab867ec7928
loadtime:0.71641802787781 / seconds
Query Executed:select id FROM `hi` where city='Paia' && SIC_code='6531'DB:business_master_new
loadtime:0.73840403556824 / seconds
Query Executed:select * from geodata_geocity where city='Papaaloa' limit 1DB:business_master_new
loadtime:0.73888802528381 / seconds
Query stored in cache : _QUERY_www.toadli.com89b8d582e8b80390267653bedc174ef3
loadtime:0.73896288871765 / seconds
Query Executed:select id FROM `hi` where city='Papaaloa' && SIC_code='6531'DB:business_master_new
loadtime:0.73947286605835 / seconds
Query Executed:select * from geodata_geocity where city='Papaikou' limit 1DB:business_master_new
loadtime:0.73990893363953 / seconds
Query stored in cache : _QUERY_www.toadli.comec1c8d45d821773aa277754214f0e936
loadtime:0.7399799823761 / seconds
Query Executed:select id FROM `hi` where city='Papaikou' && SIC_code='6531'DB:business_master_new
loadtime:0.74111390113831 / seconds
Query Executed:select * from geodata_geocity where city='Pearl City' limit 1DB:business_master_new
loadtime:0.74152684211731 / seconds
Query stored in cache : _QUERY_www.toadli.com251a469c3a94a1af27620b5e54e22946
loadtime:0.74159097671509 / seconds
Query Executed:select id FROM `hi` where city='Pearl City' && SIC_code='6531'DB:business_master_new
loadtime:0.75332283973694 / seconds
Query Executed:select * from geodata_geocity where city='Pearl Harbor' limit 1DB:business_master_new
loadtime:0.75375580787659 / seconds
Query stored in cache : _QUERY_www.toadli.com1eef1044258c4013f221874964a889ac
loadtime:0.75383591651917 / seconds
Query Executed:select id FROM `hi` where city='Pearl Harbor' && SIC_code='6531'DB:business_master_new
loadtime:0.75448203086853 / seconds
Query Executed:select * from geodata_geocity where city='Pepeekeo' limit 1DB:business_master_new
loadtime:0.75492286682129 / seconds
Query stored in cache : _QUERY_www.toadli.com2ce8e127c98402638b82d7a9f381c578
loadtime:0.75499391555786 / seconds
Query Executed:select id FROM `hi` where city='Pepeekeo' && SIC_code='6531'DB:business_master_new
loadtime:0.75559902191162 / seconds
Query Executed:select * from geodata_geocity where city='Princeville' limit 1DB:business_master_new
loadtime:0.75604796409607 / seconds
Query stored in cache : _QUERY_www.toadli.comb6f98b6e914625a21551b85a8b0bacd9
loadtime:0.75611281394958 / seconds
Query Executed:select id FROM `hi` where city='Princeville' && SIC_code='6531'DB:business_master_new
loadtime:0.77830696105957 / seconds
Query Executed:select * from geodata_geocity where city='Pukalani' limit 1DB:business_master_new
loadtime:0.77880883216858 / seconds
Query stored in cache : _QUERY_www.toadli.comb95b589d4029d07940fac1254ff0efb6
loadtime:0.77887487411499 / seconds
Query Executed:select id FROM `hi` where city='Pukalani' && SIC_code='6531'DB:business_master_new
loadtime:0.77984285354614 / seconds
Query Executed:select * from geodata_geocity where city='Puunene' limit 1DB:business_master_new
loadtime:0.78027892112732 / seconds
Query stored in cache : _QUERY_www.toadli.com30ec1f241033c64b5fef3cd44af87cac
loadtime:0.78034591674805 / seconds
Query Executed:select id FROM `hi` where city='Puunene' && SIC_code='6531'DB:business_master_new
loadtime:0.78163194656372 / seconds
Query Executed:select * from geodata_geocity where city='Schofield Barracks' limit 1DB:business_master_new
loadtime:0.78210091590881 / seconds
Query stored in cache : _QUERY_www.toadli.comddd34be6d4910d3d07b5e887fe96eb8f
loadtime:0.78216791152954 / seconds
Query Executed:select id FROM `hi` where city='Schofield Barracks' && SIC_code='6531'DB:business_master_new
loadtime:0.78298902511597 / seconds
Query Executed:select * from geodata_geocity where city='Schofield Brrcks' limit 1DB:business_master_new
loadtime:0.78345084190369 / seconds
Query stored in cache : _QUERY_www.toadli.com74f58ac07b8eb267799f8da4fc2ab164
loadtime:0.78352189064026 / seconds
Query Executed:select id FROM `hi` where city='Schofield Brrcks' && SIC_code='6531'DB:business_master_new
loadtime:0.78400492668152 / seconds
Query Executed:select * from geodata_geocity where city='Tamc' limit 1DB:business_master_new
loadtime:0.78442096710205 / seconds
Query stored in cache : _QUERY_www.toadli.com1333b04eabe183122818b24d2726a530
loadtime:0.78448581695557 / seconds
Query Executed:select id FROM `hi` where city='Tamc' && SIC_code='6531'DB:business_master_new
loadtime:0.78498196601868 / seconds
Query Executed:select * from geodata_geocity where city='Tripler Amc' limit 1DB:business_master_new
loadtime:0.78540587425232 / seconds
Query stored in cache : _QUERY_www.toadli.com9439ee470e67191074634f232c9bd240
loadtime:0.7854688167572 / seconds
Query Executed:select id FROM `hi` where city='Tripler Amc' && SIC_code='6531'DB:business_master_new
loadtime:0.7859959602356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volcano' limit 1
loadtime:0.78606390953064 / seconds
Query Executed:select id FROM `hi` where city='Volcano' && SIC_code='6531'DB:business_master_new
loadtime:0.78747582435608 / seconds
Query Executed:select * from geodata_geocity where city='Wahiawa' limit 1DB:business_master_new
loadtime:0.7879478931427 / seconds
Query stored in cache : _QUERY_www.toadli.com0442d652c18caeda6d0943a5896f23b3
loadtime:0.78802084922791 / seconds
Query Executed:select id FROM `hi` where city='Wahiawa' && SIC_code='6531'DB:business_master_new
loadtime:0.79677081108093 / seconds
Query Executed:select * from geodata_geocity where city='Waialua' limit 1DB:business_master_new
loadtime:0.79725694656372 / seconds
Query stored in cache : _QUERY_www.toadli.com3205c849dbcc877009dd693a1258a34b
loadtime:0.79732298851013 / seconds
Query Executed:select id FROM `hi` where city='Waialua' && SIC_code='6531'DB:business_master_new
loadtime:0.81951189041138 / seconds
Query Executed:select * from geodata_geocity where city='Waianae' limit 1DB:business_master_new
loadtime:0.82000184059143 / seconds
Query stored in cache : _QUERY_www.toadli.com80c1f8ae7184708c6a34bd574ae911ed
loadtime:0.82007598876953 / seconds
Query Executed:select id FROM `hi` where city='Waianae' && SIC_code='6531'DB:business_master_new
loadtime:0.82855701446533 / seconds
Query Executed:select * from geodata_geocity where city='Waikoloa' limit 1DB:business_master_new
loadtime:0.82905602455139 / seconds
Query stored in cache : _QUERY_www.toadli.come0efb38299aec07dc0f035633f0199a8
loadtime:0.82912182807922 / seconds
Query Executed:select id FROM `hi` where city='Waikoloa' && SIC_code='6531'DB:business_master_new
loadtime:0.8514039516449 / seconds
Query Executed:select * from geodata_geocity where city='Wailuku' limit 1DB:business_master_new
loadtime:0.85190200805664 / seconds
Query stored in cache : _QUERY_www.toadli.com7b2d4e4d3988a91bdc195b6602ef86d2
loadtime:0.85197782516479 / seconds
Query Executed:select id FROM `hi` where city='Wailuku' && SIC_code='6531'DB:business_master_new
loadtime:0.87257289886475 / seconds
Query Executed:select * from geodata_geocity where city='Waimanalo' limit 1DB:business_master_new
loadtime:0.87317490577698 / seconds
Query stored in cache : _QUERY_www.toadli.com0d1191d2242aa8cf9a1d2c7bab075f2d
loadtime:0.87324285507202 / seconds
Query Executed:select id FROM `hi` where city='Waimanalo' && SIC_code='6531'DB:business_master_new
loadtime:0.89557790756226 / seconds
Query Executed:select * from geodata_geocity where city='Waimea' limit 1DB:business_master_new
loadtime:0.89604902267456 / seconds
Query stored in cache : _QUERY_www.toadli.com1da9d1a763a4e248a3dbf73673a2dc2c
loadtime:0.89611601829529 / seconds
Query Executed:select id FROM `hi` where city='Waimea' && SIC_code='6531'DB:business_master_new
loadtime:0.91807293891907 / seconds
Query Executed:select * from geodata_geocity where city='Waipahu' limit 1DB:business_master_new
loadtime:0.91848301887512 / seconds
Query stored in cache : _QUERY_www.toadli.com1bceb79729e2a69d06d35c037e243c3f
loadtime:0.91854786872864 / seconds
Query Executed:select id FROM `hi` where city='Waipahu' && SIC_code='6531'DB:business_master_new
loadtime:0.93680095672607 / seconds
Query Executed:select * from geodata_geocity where city='Wheeler Afb' limit 1DB:business_master_new
loadtime:0.9372889995575 / seconds
Query stored in cache : _QUERY_www.toadli.comac00b51af88f139327e3e4d478b34893
loadtime:0.93735694885254 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Afb' && SIC_code='6531'DB:business_master_new
loadtime:0.93784999847412 / seconds
Query Executed:select * from geodata_geocity where city='Wheeler Army Airfield' limit 1DB:business_master_new
loadtime:0.93826603889465 / seconds
Query stored in cache : _QUERY_www.toadli.com5c57ec30604fd430d352d2c14ae65257
loadtime:0.93833088874817 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Army Airfield' && SIC_code='6531'DB:business_master_new
loadtime:0.93884897232056 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.93901801109314 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.9393618106842 / seconds
Operation template executed (chunk cache operation)
loadtime:0.93950486183167 / seconds
template override:Default
loadtime:0.93954801559448 / 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.94065999984741 / seconds
Template Constructed, Array Rows:49
loadtime:0.94120001792908 / seconds
TOTAL EXECUTION TIME: 0.94075
loadtime:0.94255399703979 / 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] => real-estate-agents-and-managers [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.94256496429443
TOTAL KEY ARRAYS: 69