Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:5.7220458984375E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00041604042053223 / seconds
host not found setting manual db connection
loadtime:0.00075006484985352 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0010731220245361 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0012061595916748 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0012600421905518 / seconds
zipcode:
loadtime:0.0012781620025635 / seconds
Query Executed:select * from search_referrer where page_hash='0950ed4e1678e5ceebd70d91c907857b' limit 10 DB:ezrox_toadli
loadtime:0.001453161239624 / seconds
Operation header executed (non global)
loadtime:0.0014700889587402 / seconds
Operation leaderboard executed (non global)
loadtime:0.0015010833740234 / seconds
Operation square executed (non global)
loadtime:0.001514196395874 / seconds
Operation square_bottom executed (non global)
loadtime:0.0015270709991455 / seconds
Operation smallsquare executed (non global)
loadtime:0.0015389919281006 / seconds
Operation headeradright executed (non global)
loadtime:0.0015501976013184 / seconds
Operation google_analytics executed (non global)
loadtime:0.0015602111816406 / seconds
Operation topstories executed (non global)
loadtime:0.0015721321105957 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015840530395508 / seconds
Operation memberbuscount executed (non global)
loadtime:0.001594066619873 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018181800842285 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019772052764893 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020191669464111 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0020880699157715 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021312236785889 / seconds
Template key: archive_menu pushed
loadtime:0.0021359920501709 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021421909332275 / seconds
Template key: get_gravatar pushed
loadtime:0.0021460056304932 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0021500587463379 / seconds
*10)-10)+1 | start:0
loadtime:0.0021719932556152 / seconds
DB connected to localhost business_master_new
loadtime:0.0023941993713379 / seconds
Query Executed:select * from categories where cat_URLid='grocery-stores'DB:business_master_new
loadtime:0.002899169921875 / seconds
Query stored in cache : _QUERY_www.toadli.com8dd681f3b69114f317e8b1f6afba27ed
loadtime:0.0029370784759521 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.0029861927032471 / seconds
Query Executed:select * from `hi_catmap` where sic='5411' order by city ascDB:business_master_new
loadtime:0.016934156417847 / seconds
Query stored in cache : _QUERY_www.toadli.com7169be304215f9b947dfd382cd3c524e
loadtime:0.017178058624268 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='hawaii'
loadtime:0.017204999923706 / seconds
Query Executed:select sum(totalcount) as totalsum from `hi_catmap` where sic='5411'DB:business_master_new
loadtime:0.017903089523315 / seconds
Query stored in cache : _QUERY_www.toadli.comed278ed67c4f02e90bf426ce27c915f0
loadtime:0.017929077148438 / seconds
96 / 11
loadtime:0.017979145050049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aiea' limit 1
loadtime:0.018028020858765 / seconds
Query Executed:select id FROM `hi` where city='Aiea' && SIC_code='5411'DB:business_master_new
loadtime:0.027379035949707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anahola' limit 1
loadtime:0.027442216873169 / seconds
Query Executed:select id FROM `hi` where city='Anahola' && SIC_code='5411'DB:business_master_new
loadtime:0.028594017028809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp H M Smith' limit 1
loadtime:0.028686046600342 / seconds
Query Executed:select id FROM `hi` where city='Camp H M Smith' && SIC_code='5411'DB:business_master_new
loadtime:0.031732082366943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Captain Cook' limit 1
loadtime:0.031780004501343 / seconds
Query Executed:select id FROM `hi` where city='Captain Cook' && SIC_code='5411'DB:business_master_new
loadtime:0.033011198043823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eleele' limit 1
loadtime:0.033056020736694 / seconds
Query Executed:select id FROM `hi` where city='Eleele' && SIC_code='5411'DB:business_master_new
loadtime:0.034763097763062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ewa Beach' limit 1
loadtime:0.034821033477783 / seconds
Query Executed:select id FROM `hi` where city='Ewa Beach' && SIC_code='5411'DB:business_master_new
loadtime:0.039661169052124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Shafter' limit 1
loadtime:0.039722204208374 / seconds
Query Executed:select id FROM `hi` where city='Fort Shafter' && SIC_code='5411'DB:business_master_new
loadtime:0.044038057327271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haiku' limit 1
loadtime:0.044075012207031 / seconds
Query Executed:select id FROM `hi` where city='Haiku' && SIC_code='5411'DB:business_master_new
loadtime:0.045935153961182 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hakalau' limit 1
loadtime:0.04601001739502 / seconds
Query Executed:select id FROM `hi` where city='Hakalau' && SIC_code='5411'DB:business_master_new
loadtime:0.052361011505127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haleiwa' limit 1
loadtime:0.052397012710571 / seconds
Query Executed:select id FROM `hi` where city='Haleiwa' && SIC_code='5411'DB:business_master_new
loadtime:0.055689096450806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hana' limit 1
loadtime:0.055749177932739 / seconds
Query Executed:select id FROM `hi` where city='Hana' && SIC_code='5411'DB:business_master_new
loadtime:0.058004140853882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanalei' limit 1
loadtime:0.058050155639648 / seconds
Query Executed:select id FROM `hi` where city='Hanalei' && SIC_code='5411'DB:business_master_new
loadtime:0.059889078140259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanamaulu' limit 1
loadtime:0.05994701385498 / seconds
Query Executed:select id FROM `hi` where city='Hanamaulu' && SIC_code='5411'DB:business_master_new
loadtime:0.063997030258179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanapepe' limit 1
loadtime:0.064053058624268 / seconds
Query Executed:select id FROM `hi` where city='Hanapepe' && SIC_code='5411'DB:business_master_new
loadtime:0.065288066864014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hauula' limit 1
loadtime:0.065332174301147 / seconds
Query Executed:select id FROM `hi` where city='Hauula' && SIC_code='5411'DB:business_master_new
loadtime:0.067553043365479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawaii National Park' limit 1
loadtime:0.067610025405884 / seconds
Query Executed:select id FROM `hi` where city='Hawaii National Park' && SIC_code='5411'DB:business_master_new
loadtime:0.072876214981079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawaii Natl Park' limit 1
loadtime:0.072918176651001 / seconds
Query Executed:select id FROM `hi` where city='Hawaii Natl Park' && SIC_code='5411'DB:business_master_new
loadtime:0.073261022567749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hawi' limit 1
loadtime:0.073309183120728 / seconds
Query Executed:select id FROM `hi` where city='Hawi' && SIC_code='5411'DB:business_master_new
loadtime:0.075851202011108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickam Afb' limit 1
loadtime:0.075918197631836 / seconds
Query Executed:select id FROM `hi` where city='Hickam Afb' && SIC_code='5411'DB:business_master_new
loadtime:0.087314128875732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hilo' limit 1
loadtime:0.087372064590454 / seconds
Query Executed:select id FROM `hi` where city='Hilo' && SIC_code='5411'DB:business_master_new
loadtime:0.36271715164185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holualoa' limit 1
loadtime:0.36283612251282 / seconds
Query Executed:select id FROM `hi` where city='Holualoa' && SIC_code='5411'DB:business_master_new
loadtime:0.3637580871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honaunau' limit 1
loadtime:0.36382007598877 / seconds
Query Executed:select id FROM `hi` where city='Honaunau' && SIC_code='5411'DB:business_master_new
loadtime:0.36450004577637 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honokaa' limit 1
loadtime:0.36455011367798 / seconds
Query Executed:select id FROM `hi` where city='Honokaa' && SIC_code='5411'DB:business_master_new
loadtime:0.36533212661743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honolulu' limit 1
loadtime:0.36537313461304 / seconds
Query Executed:select id FROM `hi` where city='Honolulu' && SIC_code='5411'DB:business_master_new
loadtime:0.37244415283203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honomu' limit 1
loadtime:0.37271809577942 / seconds
Query Executed:select id FROM `hi` where city='Honomu' && SIC_code='5411'DB:business_master_new
loadtime:0.38059306144714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoolehua' limit 1
loadtime:0.38069915771484 / seconds
Query Executed:select id FROM `hi` where city='Hoolehua' && SIC_code='5411'DB:business_master_new
loadtime:0.38144516944885 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaaawa' limit 1
loadtime:0.38148903846741 / seconds
Query Executed:select id FROM `hi` where city='Kaaawa' && SIC_code='5411'DB:business_master_new
loadtime:0.38214921951294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahuku' limit 1
loadtime:0.38219499588013 / seconds
Query Executed:select id FROM `hi` where city='Kahuku' && SIC_code='5411'DB:business_master_new
loadtime:0.38285613059998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kahului' limit 1
loadtime:0.38290500640869 / seconds
Query Executed:select id FROM `hi` where city='Kahului' && SIC_code='5411'DB:business_master_new
loadtime:0.38472819328308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kailua' limit 1
loadtime:0.38485717773438 / seconds
Query Executed:select id FROM `hi` where city='Kailua' && SIC_code='5411'DB:business_master_new
loadtime:0.38651418685913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kailua Kona' limit 1
loadtime:0.38657116889954 / seconds
Query Executed:select id FROM `hi` where city='Kailua Kona' && SIC_code='5411'DB:business_master_new
loadtime:0.39281105995178 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalaheo' limit 1
loadtime:0.39287614822388 / seconds
Query Executed:select id FROM `hi` where city='Kalaheo' && SIC_code='5411'DB:business_master_new
loadtime:0.39362120628357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kalaupapa' limit 1
loadtime:0.39373421669006 / seconds
Query Executed:select id FROM `hi` where city='Kalaupapa' && SIC_code='5411'DB:business_master_new
loadtime:0.3981831073761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamuela' limit 1
loadtime:0.3982310295105 / seconds
Query Executed:select id FROM `hi` where city='Kamuela' && SIC_code='5411'DB:business_master_new
loadtime:0.39931106567383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaneohe' limit 1
loadtime:0.3993661403656 / seconds
Query Executed:select id FROM `hi` where city='Kaneohe' && SIC_code='5411'DB:business_master_new
loadtime:0.40083909034729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapaa' limit 1
loadtime:0.40090298652649 / seconds
Query Executed:select id FROM `hi` where city='Kapaa' && SIC_code='5411'DB:business_master_new
loadtime:0.40207409858704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapaau' limit 1
loadtime:0.40212512016296 / seconds
Query Executed:select id FROM `hi` where city='Kapaau' && SIC_code='5411'DB:business_master_new
loadtime:0.40284299850464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kapolei' limit 1
loadtime:0.40289711952209 / seconds
Query Executed:select id FROM `hi` where city='Kapolei' && SIC_code='5411'DB:business_master_new
loadtime:0.40397810935974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaumakani' limit 1
loadtime:0.40402221679688 / seconds
Query Executed:select id FROM `hi` where city='Kaumakani' && SIC_code='5411'DB:business_master_new
loadtime:0.41297912597656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaunakakai' limit 1
loadtime:0.4130392074585 / seconds
Query Executed:select id FROM `hi` where city='Kaunakakai' && SIC_code='5411'DB:business_master_new
loadtime:0.41385507583618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keaau' limit 1
loadtime:0.41390419006348 / seconds
Query Executed:select id FROM `hi` where city='Keaau' && SIC_code='5411'DB:business_master_new
loadtime:0.41472721099854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kealakekua' limit 1
loadtime:0.41477012634277 / seconds
Query Executed:select id FROM `hi` where city='Kealakekua' && SIC_code='5411'DB:business_master_new
loadtime:0.41561603546143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kealia' limit 1
loadtime:0.41566801071167 / seconds
Query Executed:select id FROM `hi` where city='Kealia' && SIC_code='5411'DB:business_master_new
loadtime:0.42271208763123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Keauhou' limit 1
loadtime:0.42274808883667 / seconds
Query Executed:select id FROM `hi` where city='Keauhou' && SIC_code='5411'DB:business_master_new
loadtime:0.4234561920166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kekaha' limit 1
loadtime:0.42350006103516 / seconds
Query Executed:select id FROM `hi` where city='Kekaha' && SIC_code='5411'DB:business_master_new
loadtime:0.42416906356812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kihei' limit 1
loadtime:0.4242091178894 / seconds
Query Executed:select id FROM `hi` where city='Kihei' && SIC_code='5411'DB:business_master_new
loadtime:0.42566919326782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kilauea' limit 1
loadtime:0.42572999000549 / seconds
Query Executed:select id FROM `hi` where city='Kilauea' && SIC_code='5411'DB:business_master_new
loadtime:0.42648601531982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koloa' limit 1
loadtime:0.42653918266296 / seconds
Query Executed:select id FROM `hi` where city='Koloa' && SIC_code='5411'DB:business_master_new
loadtime:0.42743802070618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kualapuu' limit 1
loadtime:0.42748212814331 / seconds
Query Executed:select id FROM `hi` where city='Kualapuu' && SIC_code='5411'DB:business_master_new
loadtime:0.42811512947083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kula' limit 1
loadtime:0.42816710472107 / seconds
Query Executed:select id FROM `hi` where city='Kula' && SIC_code='5411'DB:business_master_new
loadtime:0.42897415161133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kunia' limit 1
loadtime:0.42901611328125 / seconds
Query Executed:select id FROM `hi` where city='Kunia' && SIC_code='5411'DB:business_master_new
loadtime:0.43331503868103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kurtistown' limit 1
loadtime:0.43343210220337 / seconds
Query Executed:select id FROM `hi` where city='Kurtistown' && SIC_code='5411'DB:business_master_new
loadtime:0.43420505523682 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lahaina' limit 1
loadtime:0.43424606323242 / seconds
Query Executed:select id FROM `hi` where city='Lahaina' && SIC_code='5411'DB:business_master_new
loadtime:0.43730401992798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laie' limit 1
loadtime:0.43737816810608 / seconds
Query Executed:select id FROM `hi` where city='Laie' && SIC_code='5411'DB:business_master_new
loadtime:0.4381000995636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanai City' limit 1
loadtime:0.43814206123352 / seconds
Query Executed:select id FROM `hi` where city='Lanai City' && SIC_code='5411'DB:business_master_new
loadtime:0.43882703781128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laupahoehoe' limit 1
loadtime:0.43887805938721 / seconds
Query Executed:select id FROM `hi` where city='Laupahoehoe' && SIC_code='5411'DB:business_master_new
loadtime:0.44451117515564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawai' limit 1
loadtime:0.44456601142883 / seconds
Query Executed:select id FROM `hi` where city='Lawai' && SIC_code='5411'DB:business_master_new
loadtime:0.44524502754211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lihue' limit 1
loadtime:0.44535207748413 / seconds
Query Executed:select id FROM `hi` where city='Lihue' && SIC_code='5411'DB:business_master_new
loadtime:0.44672203063965 / seconds
Query loaded from cache:select * from geodata_geocity where city='M C B H Kaneohe Bay' limit 1
loadtime:0.4467761516571 / seconds
Query Executed:select id FROM `hi` where city='M C B H Kaneohe Bay' && SIC_code='5411'DB:business_master_new
loadtime:0.44710922241211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Makawao' limit 1
loadtime:0.44714021682739 / seconds
Query Executed:select id FROM `hi` where city='Makawao' && SIC_code='5411'DB:business_master_new
loadtime:0.4480721950531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Makaweli' limit 1
loadtime:0.44812607765198 / seconds
Query Executed:select id FROM `hi` where city='Makaweli' && SIC_code='5411'DB:business_master_new
loadtime:0.45012617111206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maunaloa' limit 1
loadtime:0.45015716552734 / seconds
Query Executed:select id FROM `hi` where city='Maunaloa' && SIC_code='5411'DB:business_master_new
loadtime:0.45075416564941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcbh Kaneohe Bay' limit 1
loadtime:0.45080304145813 / seconds
Query Executed:select id FROM `hi` where city='Mcbh Kaneohe Bay' && SIC_code='5411'DB:business_master_new
loadtime:0.45142412185669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mililani' limit 1
loadtime:0.45145511627197 / seconds
Query Executed:select id FROM `hi` where city='Mililani' && SIC_code='5411'DB:business_master_new
loadtime:0.45243406295776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain View' limit 1
loadtime:0.4525830745697 / seconds
Query Executed:select id FROM `hi` where city='Mountain View' && SIC_code='5411'DB:business_master_new
loadtime:0.4533371925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naalehu' limit 1
loadtime:0.45338702201843 / seconds
Query Executed:select id FROM `hi` where city='Naalehu' && SIC_code='5411'DB:business_master_new
loadtime:0.45412302017212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ninole' limit 1
loadtime:0.45416402816772 / seconds
Query Executed:select id FROM `hi` where city='Ninole' && SIC_code='5411'DB:business_master_new
loadtime:0.45561099052429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean View' limit 1
loadtime:0.45565414428711 / seconds
Query Executed:select id FROM `hi` where city='Ocean View' && SIC_code='5411'DB:business_master_new
loadtime:0.45629000663757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ookala' limit 1
loadtime:0.45633411407471 / seconds
Query Executed:select id FROM `hi` where city='Ookala' && SIC_code='5411'DB:business_master_new
loadtime:0.45832800865173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paauilo' limit 1
loadtime:0.45837712287903 / seconds
Query Executed:select id FROM `hi` where city='Paauilo' && SIC_code='5411'DB:business_master_new
loadtime:0.45903301239014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pahala' limit 1
loadtime:0.45907711982727 / seconds
Query Executed:select id FROM `hi` where city='Pahala' && SIC_code='5411'DB:business_master_new
loadtime:0.45974516868591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pahoa' limit 1
loadtime:0.45979619026184 / seconds
Query Executed:select id FROM `hi` where city='Pahoa' && SIC_code='5411'DB:business_master_new
loadtime:0.46058416366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paia' limit 1
loadtime:0.46071410179138 / seconds
Query Executed:select id FROM `hi` where city='Paia' && SIC_code='5411'DB:business_master_new
loadtime:0.46156120300293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Papaaloa' limit 1
loadtime:0.46170210838318 / seconds
Query Executed:select id FROM `hi` where city='Papaaloa' && SIC_code='5411'DB:business_master_new
loadtime:0.46621417999268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Papaikou' limit 1
loadtime:0.46626114845276 / seconds
Query Executed:select id FROM `hi` where city='Papaikou' && SIC_code='5411'DB:business_master_new
loadtime:0.46691918373108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl City' limit 1
loadtime:0.46698021888733 / seconds
Query Executed:select id FROM `hi` where city='Pearl City' && SIC_code='5411'DB:business_master_new
loadtime:0.46811413764954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pearl Harbor' limit 1
loadtime:0.46816921234131 / seconds
Query Executed:select id FROM `hi` where city='Pearl Harbor' && SIC_code='5411'DB:business_master_new
loadtime:0.46879410743713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pepeekeo' limit 1
loadtime:0.46882700920105 / seconds
Query Executed:select id FROM `hi` where city='Pepeekeo' && SIC_code='5411'DB:business_master_new
loadtime:0.47343420982361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:0.47347617149353 / seconds
Query Executed:select id FROM `hi` where city='Princeville' && SIC_code='5411'DB:business_master_new
loadtime:0.47417712211609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pukalani' limit 1
loadtime:0.47421717643738 / seconds
Query Executed:select id FROM `hi` where city='Pukalani' && SIC_code='5411'DB:business_master_new
loadtime:0.47481918334961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Puunene' limit 1
loadtime:0.47486805915833 / seconds
Query Executed:select id FROM `hi` where city='Puunene' && SIC_code='5411'DB:business_master_new
loadtime:0.4755220413208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield Barracks' limit 1
loadtime:0.47563409805298 / seconds
Query Executed:select id FROM `hi` where city='Schofield Barracks' && SIC_code='5411'DB:business_master_new
loadtime:0.47635817527771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Schofield Brrcks' limit 1
loadtime:0.47639513015747 / seconds
Query Executed:select id FROM `hi` where city='Schofield Brrcks' && SIC_code='5411'DB:business_master_new
loadtime:0.47711706161499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tamc' limit 1
loadtime:0.47715902328491 / seconds
Query Executed:select id FROM `hi` where city='Tamc' && SIC_code='5411'DB:business_master_new
loadtime:0.47854399681091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tripler Amc' limit 1
loadtime:0.47857403755188 / seconds
Query Executed:select id FROM `hi` where city='Tripler Amc' && SIC_code='5411'DB:business_master_new
loadtime:0.48009204864502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Volcano' limit 1
loadtime:0.48013305664062 / seconds
Query Executed:select id FROM `hi` where city='Volcano' && SIC_code='5411'DB:business_master_new
loadtime:0.48076701164246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wahiawa' limit 1
loadtime:0.48080515861511 / seconds
Query Executed:select id FROM `hi` where city='Wahiawa' && SIC_code='5411'DB:business_master_new
loadtime:0.4818480014801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waialua' limit 1
loadtime:0.4819061756134 / seconds
Query Executed:select id FROM `hi` where city='Waialua' && SIC_code='5411'DB:business_master_new
loadtime:0.48265504837036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waianae' limit 1
loadtime:0.48276519775391 / seconds
Query Executed:select id FROM `hi` where city='Waianae' && SIC_code='5411'DB:business_master_new
loadtime:0.48389220237732 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waikoloa' limit 1
loadtime:0.48396515846252 / seconds
Query Executed:select id FROM `hi` where city='Waikoloa' && SIC_code='5411'DB:business_master_new
loadtime:0.48469114303589 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wailuku' limit 1
loadtime:0.48482918739319 / seconds
Query Executed:select id FROM `hi` where city='Wailuku' && SIC_code='5411'DB:business_master_new
loadtime:0.49121618270874 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waimanalo' limit 1
loadtime:0.49126815795898 / seconds
Query Executed:select id FROM `hi` where city='Waimanalo' && SIC_code='5411'DB:business_master_new
loadtime:0.49207401275635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waimea' limit 1
loadtime:0.4921281337738 / seconds
Query Executed:select id FROM `hi` where city='Waimea' && SIC_code='5411'DB:business_master_new
loadtime:0.49283599853516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waipahu' limit 1
loadtime:0.49287509918213 / seconds
Query Executed:select id FROM `hi` where city='Waipahu' && SIC_code='5411'DB:business_master_new
loadtime:0.49909400939941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler Afb' limit 1
loadtime:0.49915909767151 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Afb' && SIC_code='5411'DB:business_master_new
loadtime:0.49954414367676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wheeler Army Airfield' limit 1
loadtime:0.49962615966797 / seconds
Query Executed:select id FROM `hi` where city='Wheeler Army Airfield' && SIC_code='5411'DB:business_master_new
loadtime:0.50031399726868 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.50039601325989 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.50054407119751 / seconds
Operation template executed (chunk cache operation)
loadtime:0.5006160736084 / seconds
template override:Default
loadtime:0.50063610076904 / 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.50151014328003 / seconds
Template Constructed, Array Rows:49
loadtime:0.50206208229065 / seconds
TOTAL EXECUTION TIME: 0.50161
loadtime:0.50216221809387 / 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] => grocery-stores [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.50216817855835
TOTAL KEY ARRAYS: 69