Flag counter for your website

iamawriter Level 1

July 11, 2017, 12:28 am

25

Write the reason you're deleting this FAQ

Flag counter for your website

A flag counter indicating from which country a visitor comes to your website will give you an idea of whether there is global interest. I have a flag counter on my blog and each time a visitor arrives I either get to see a new flag or they are added to the existing flags of those countries.

You can download it here

https://flagcounter.com/

Comments

Please login or sign up to leave a comment

Join

overcast

This looks good for the personal websites but for the professional website this may not look good. Also the analytics can be much better through the google analytics. As you can see such flag counters are good for showing off. But I think personally google analytics is more than enough. It just gets kind of harder to use other options.

9 years ago

Are you sure you want to delete this post?

cmoneyspinner

I have the flag counter at one of my blogs. I like it! I think it's reflects the spirit of the worldwide web. It's nice to know that people come from places I will likely never ever visit, just to read something written at my blog. It's way cool!!

Flag counter for your website

9 years ago

Are you sure you want to delete this post?

iamawriter

The joy of just getting back periodically and discovering either a few new flags or the number against the existing flags having increased is truly so satisfying. It is also kind of a data bank from where we can gather more information - even knowing about the flags that represent different countries.

9 years ago

Are you sure you want to delete this post?

cmoneyspinner

I was doing some house cleaning with my blog and deleted the flag counter. I was going to reinstall it but first I'm going to try some other "counter" widgets and see what kind of information I can glean from them about visitors to my site.

9 years ago

Are you sure you want to delete this post?

iamawriter

There are always upgrades. What I have is pretty old too.
I too have a lot of cleaning to do mainly because of the main title of my blog is gardening and there are other topics in there. I will start a new blog and transfer gardening under a sub heading.

9 years ago

Are you sure you want to delete this post?

Gina145

Are you able to change the name of your blog without starting a new one? It would save a lot of work and you'd be able to retain the view count and any comments you already have.

9 years ago

Are you sure you want to delete this post?

mdkarimkhan

Nice option to now from which country getting users. i am also using it from my blog

9 years ago

Are you sure you want to delete this post?

mcbryan080990

I believe that's a good feature for a website. Aside from giving you information what country the visitor live it can avoid intruders or scammers also. Another thing is that you can use that information when you need to collect your visitors addresses and their country.

9 years ago

Are you sure you want to delete this post?

iamawriter

I like to see those flags there adding colour to my blog (lol) That is a good thought about keeping intruders at bay. I have not gone there in a while but should be doing it if not for anything else just to check on those flags!!!

9 years ago

Are you sure you want to delete this post?

Gina145

I used it on my old domain at BlogJob, but there was a period when it wasn't working properly, so when I moved my blog to Blogger I chose to use their default view counter. I'm able to see from which countries I'm getting the most traffic on their stats page, but it's not as nice as being able to see all those flags, so maybe I should try flagcounter again. I just wish I'd done it when I first moved my blog because if I start now nearly 80,000 views won't be included in those stats.

9 years ago

Are you sure you want to delete this post?

TsuyoyRival

I had a similar feature on my previous blog, and it is very interesting. If I open another blog, i will take your feature into consideration ;)

9 years ago

Are you sure you want to delete this post?

PedroP

It's a great little asset. Don't you think however that it distorts the theme of the site? My blog uses a darker theme don't you think it would stand out too much?

9 years ago

Are you sure you want to delete this post?

Tronia

Oh, yes. I have seen those flags before on a blog and I thought it was a cool feature. It is always interesting seeing where other people are from... it feels like you know them a bit more even if that's not the case. It can be a good feature on forums too. Thank you for the link!

9 years ago

Are you sure you want to delete this post?

zeedollar

It looks good for monitoring your visitors geo lacation. It will afford you to know the country where your most traffic come from. It certainly is a good addition to any website.

9 years ago

Are you sure you want to delete this post?

Neiltarquin

That's definitely a great help to track down which country my have taken interest to your site.

9 years ago

Are you sure you want to delete this post?

keen2write

Great thank you for the share I will try this with my websites and blogs. There are similar websites as well which offer free HTML and PHP codes for your website like visitor counters and other great tools which help a website.

For example, there is http://100widgets.com/ which gives different tools and cool format base tools for your blog and websites there are tons of great things on the internet these days.

9 years ago

Are you sure you want to delete this post?

wallet

Hi, Iamawidon't have a flag counter on my blog and I don't intend to download it because it doesn't matter from where a user comes. If he appreciates my blog and writes a positive or critical review it will matter more than its status!
Thank you for sharing your link with us!

9 years ago

Are you sure you want to delete this post?

thart

It's a nice thing to know where your visitors are from. It's really a nice feature to have it in your blog, Thank for sharing the link with us.

9 years ago

Are you sure you want to delete this post?

djwaruna

Thanks for sharing.keep it up

9 years ago

Are you sure you want to delete this post?

kgord

I used to have that feature on my old blog. I think it was a feedjit widget. I have had difficulty with Blogger loading things though so I haven't tried to add any extra widgets. I am not sure if it is just my computer or if it is happening across the board.

9 years ago

Are you sure you want to delete this post?

Authord

Flag counters are actually good and fancy as well for personal websites, i have been using it in one of my blogs and i can say it's cool.
if you want to add Flag Counter in your blog or website Click Here to get your code for Flag Counter.
Then Choose settings for Flag counter and click on Get your Flag Counter and copy the code "Code for Websites".
Now go to your Blogger layout followed by Add a gadget ---->HTML\JavaScript and Paste the code and save.And view your
blog.You can also add it in Your Website also.

9 years ago

Are you sure you want to delete this post?

Corzhens

Thank you for sharing the information about the country’s flag of the visitor but I think most of the sites that I know have that in their control panel. Pardon me if I am wrong on my assumption because I had been checking the site of my husband’s office and another 2 sites of my friends more than a decade ago and I remember seeing flags in the demographic chart.

7 years ago

Are you sure you want to delete this post?

Process Time: 0.31842994689941

Possible Duplicate queries found!

Match	Count	SQL	Script
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='23434'	1	SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='23434'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='590421'	1	SELECT * FROM seoclerks.members WHERE USERID='590421'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='42'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=590421	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=590421	/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23434 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=23434 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='23434' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='23434' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	/opt/clerks-staging/docroot/viewfaq.php 1245 () ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123813 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123813 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124232 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124232 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124279 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124279 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126230 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126230 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126267 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126267 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=128149 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=128149 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=128154 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=128154 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123636 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123636 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126270 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=126270 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123644 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123644 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123657 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123657 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123677 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123677 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123707 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123707 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123731 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123731 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123738 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123738 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123741 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123741 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123846 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=123846 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124128 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124128 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124337 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=124337 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125090 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=125090 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=130430 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=130430 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172257 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=172257 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='23434'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='23434'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='23434' AND status='1' AND (question like '%Flag counter website%' OR question like '%Flag%' OR question like '%counter%' OR question like '%website%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='23434' AND status='1' AND (question like '%Flag counter website%' OR question like '%Flag%' OR question like '%counter%' OR question like '%website%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='3160' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3160' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3489' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3489' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='231' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='231' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='9' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1607' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1607' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23434%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=23434%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='596028.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='596028.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='590421.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='590421.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='597212.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='597212.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='368555.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='368555.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='603001.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='603001.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='584702.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='584702.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='601783.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='601783.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='322073.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='322073.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='598707.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598707.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='598676.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='598676.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='561850.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='561850.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='614330.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='614330.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.242119	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (89) AND gtags like'%Websitemarketing%' AND type !=99	0.242119	0.242119