SEOClerks

Onpage optimization



Write the reason you're deleting this FAQ

Onpage optimization

Please share your Best on-page optimization Technique?

Comments

Please login or sign up to leave a comment

Join
Beverly
Lots and lots of really high quality content published daily, if possible. Also, do keyword research and integrate your keywords into titles of blog posts/pages and even tags.



Are you sure you want to delete this post?

Tommy Matalino
Please share your Best on-page optimization Technique?

Writing unique articles is the first and foremost thing you need to do. Of course, you need to have the main keywords of your article on your title and URL. Doing this will help you get higher in search results (still, it depends on the keyword's competitions).



Are you sure you want to delete this post?

Beverly
Writing unique articles is the first and foremost thing you need to do. Of course, you need to have the main keywords of your article on your title and URL. Doing this will help you get higher in search results (still, it depends on the keyword's competitions).


And, Google wants to help searchers find sites that provide a great user experience and fulfill their information needs. So sites that publish high quality articles are rewarded with higher search engine rankings as this meets Google's goals.



Are you sure you want to delete this post?

Tommy Matalino
And, Google wants to help searchers find sites that provide a great user experience and fulfill their information needs. So sites that publish high quality articles are rewarded with higher search engine rankings as this meets Google's goals.

As long as you have a quality site and you abide by the rules, you will loved by Google. Am I right?



Are you sure you want to delete this post?

Beverly
As long as you have a quality site and you abide by the rules, you will loved by Google. Am I right?


That's what Google says, though I still see sites that are not best quality content ranking high. Most likely, they are using blackhat tricks to rank high. Slowly, Google is closing the blackhat loop-holes



Are you sure you want to delete this post?

sierner5701
On-page optimization increase the visibility of webpage by optimizing your webpage content. It includes meta tags, alt image tag, h1 tag, site map, robot,txt file, url optimization, internal linking, w3 validation....



Are you sure you want to delete this post?

Beverly
On-page optimization increase the visibility of webpage by optimizing your webpage content. It includes meta tags, alt image tag, h1 tag, site map, robot,txt file, url optimization, internal linking, w3 validation....


I've heard of w3 validation but not given it much thought before as i get really good rankings anyway, assuming i'm targeting attainable keywords.



Are you sure you want to delete this post?

Arianna
There are many technique are available for onpage optimization.I think keyword research,site map,h1 tag etc...



Are you sure you want to delete this post?

Tommy Matalino
I've heard of w3 validation but not given it much thought before as i get really good rankings anyway, assuming i'm targeting attainable keywords.

I think w3 validation is needed to check if your site have unneeded codes and if it can load faster than it presently can. But As long as your site runs fast and doesn't have these "unnecessary codes", you are good to go.



Are you sure you want to delete this post?

stanelly
Keyword research is most important part of the on-Page optimization as it helps to get targeted traffic & visitors to your website



Are you sure you want to delete this post?

wowmadam
Keyword research is most important part of the on-Page optimization as it helps to get targeted traffic & visitors to your website.



Are you sure you want to delete this post?

Tommy Matalino
How about if we don't do keyword research and just focus on creating quality articles?



Are you sure you want to delete this post?

Tommy Matalino
Robots.txt creation? What advantages it could give your site?
And how can we create one?



Are you sure you want to delete this post?

shopeez
yes.. you are giving us best information..

I Mentioned Some On Page Optimization Activities Are Below:-

Number of Optimized Pages
Keywords Analysis
URL Optimization
Competitor Research
Content & Image Optimization
Meta Tag creation & HTML optimization
Sitemap Creation(XML,HTML)
Robots.txt Creation
RSS Creation
Google Analytics & Webmaster Tools Set Up
Check Keyword Density
W3C Validation
H1,H2,H3,H4 Tags ( Include Your Main Keywords)



Are you sure you want to delete this post?

Beverly
Robots.txt creation? What advantages it could give your site?
And how can we create one?

This file gives robots specific instructions.

You can read more here:

http://www.robotstxt.org/robotstxt.html



Are you sure you want to delete this post?

ihspain
Yes you are absolutely right.....



Are you sure you want to delete this post?

anurag
I use all of the on page optimization techniques and all of them were best for me.



Are you sure you want to delete this post?

Tommy Matalino
This file gives robots specific instructions.

What's the advantage of having one? More search engine presence?



Are you sure you want to delete this post?

thanishtha12
Hi,
On page optimisation technique consist of keyword research, on page elements.Avoid using duplicate content and avoid using hidden or invisible text also avoid cloaking or sneaky redirects.



Are you sure you want to delete this post?

peterhood1234
There are many activities need in onpage submissions:

• Url optimization
• XMl sitemap
• Keyword Analysis
• Robots.txt



Are you sure you want to delete this post?

narasimmarao
On-page echniques
1 Tital tag
2 Keywords meta tag
3 home page link
4 Meta description
5 Meta tag
6 Proper Use of Heading Tags
7 XML Sitemap



Are you sure you want to delete this post?

Beverly
On-page echniques
1 Tital tag
2 Keywords meta tag
3 home page link
4 Meta description
5 Meta tag
6 Proper Use of Heading Tags
7 XML Sitemap


And, content? That's on page SEO too. Or, at least without it, you don't have much reason for the site.



Are you sure you want to delete this post?

johnmith
As per my experience am using the below On-page techniques i.e.:

- Meta Tags
Title tag
Description tag
Keyword tag
- Alt Tags
- Canonical Tags
- Bold Tags
- Heading Tags
- Robot.txt
- Sitemap
- Keyword Density
- Keyword Prominence
- Deep link Analysis
- Internal Linkage
- Unique Content
- Competitors Analysis



Are you sure you want to delete this post?

localnumberone
HelloOnpage optimization
On page optimization is basically what you do on your site to make it search engine friendly
eg:
Site Analysis
Keyword Research
Keyword Density
Title tags
Meta Tags
Meta Description
H1 Tags
ALT Tags
URL Structure
Internal Linking
Sitemaps
Robot.Txt
W3C Validation
Track of target keywords etc.



Are you sure you want to delete this post?

Peetter123
hi,
I think on page is the use of programming techniques to do seo but how can we create site map with it?



Are you sure you want to delete this post?

uniquecontent
cant you optimize the page for more than a keyword because i believe it is possible to optimize for more than 100 keywords on a page without incuring the wrath of search engines especially google.



Are you sure you want to delete this post?

Linksdepth
And, content? That's on page SEO too. Or, at least without it, you don't have much reason for the site.


And, Use Alt tag for Images otherwise crawler will not visit your images of site.



Are you sure you want to delete this post?

laven
Onpage optimization means what are activities you did in your site.



Are you sure you want to delete this post?

swapnil
That's what Google says, though I still see sites that are not best quality content ranking high. Most likely, they are using blackhat tricks to rank high. Slowly, Google is closing the blackhat loop-holes

Slowly and gradually you will see those rankings deteriorate as soon as google notices such practices of those sites.
Yes, good quality content and proper keyword research and use also do not forget to add to the list use of all the formating tags like Heading tags, and Bold Italics and underline, the text color, alt tags for images etc they are also important on page factors for getting a good ranking on the SERPS



Are you sure you want to delete this post?

Beverly
Slowly and gradually you will see those rankings deteriorate as soon as google notices such practices of those sites.
Yes, good quality content and proper keyword research and use also do not forget to add to the list use of all the formating tags like Heading tags, and Bold Italics and underline, the text color, alt tags for images etc they are also important on page factors for getting a good ranking on the SERPS


Hopefully, Google will not fall for blackhat tricks which is unfair to the legitimate blogger/site owner that plays by the Google TOS and does not break any rules.



Are you sure you want to delete this post?

anirban09P
SEO has traditionally divided into two main areas; on-page optimisation which covers what can be done on the pages of the website itself, and off-page optimisation which covers activity that takes place elsewhere (e.g. link-building).



Are you sure you want to delete this post?

jaysh4922
I would like to say that On page techniques are below

Meta tag optimization.
Keyword Analysis
Competitor Analysis
Key Word Density
Sitemap xml & Robot.txt
H1 to H6 Tag
Title Tag optimization.



Are you sure you want to delete this post?

agarwalaman404
On page Optimization means the process of preparing website pages search engine friendly. On page optimization is gaining popularity by leaps and bounds as Google crawls in to check all the availabilities of a site.



Are you sure you want to delete this post?

anirban09P
On-Page SEO is the SEO on your actual page or blog. One of the most popular ways that search engines worldwide tend to rank websites is by looking for the prominence and frequency of certain keywords and phrases on various facets of your site, and assigning an appropriate degree of weight accordingly. More weight is given to keywords and phrases that are used in prominent places such as headings, page titles, domain names, and images.



Are you sure you want to delete this post?

longemagazine
how do once add code from Google on the page to check conversion rate?



Are you sure you want to delete this post?

Corzhens
What I can share is the basic on-page optimization which is the uploading of contents that is of good quality so the ranking in the search engine will be boosted. Good quality content is unique in the sense that there is no copied portion from another site and it is well written and has no grammar mistakes. Much more it should be directly related to the niche of the site. Add to that the keywords that you can tag the content with which should be directly relevant to the topic of the content.



Are you sure you want to delete this post?

Order Now
Process Time: 0.41478300094604

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

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='15432'1SELECT 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='15432'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='8537'1SELECT * FROM seoclerks.members WHERE USERID='8537'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM seoclerks.members WHERE USERID=85371SELECT googleplus_profile FROM seoclerks.members WHERE USERID=8537

/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=15432 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=15432 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='15432' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='15432' 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=82663 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82663 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=82664 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82664 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=82665 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82665 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=82666 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82666 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=82667 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82667 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=82668 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82668 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=82669 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82669 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=82670 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82670 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=82671 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82671 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=82672 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82672 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=82673 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82673 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=82674 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82674 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=82675 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82675 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=82676 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82676 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=82677 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82677 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=82678 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82678 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=82679 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82679 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=82680 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82680 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=82681 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82681 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=82682 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82682 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=82683 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82683 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=82684 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82684 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=82685 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82685 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=82686 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82686 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=82687 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82687 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=82688 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82688 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=82689 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82689 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=82690 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82690 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=82691 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82691 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=82692 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82692 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=82693 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82693 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=82694 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82694 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=82695 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82695 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=82696 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=82696 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=165862 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=165862 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=183091 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=183091 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='15432'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='15432'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='15432' AND status='1' AND (question like '%Onpage optimization%' OR question like '%Onpage%' OR question like '%optimization%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='15432' AND status='1' AND (question like '%Onpage optimization%' OR question like '%Onpage%' OR question like '%optimization%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='17130' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='17130' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='3321' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3321' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='147' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='43' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='43' 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 11SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=15432%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=15432%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='147.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='147.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='43.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='43.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='27997.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='27997.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='30564.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='30564.jpg'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='600657.jpg'1SELECT 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 asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin
0.1506612SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600 0.0779920.072669

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
4.9446251SELECT 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 (23,48,53,103) AND gtags like'%Document%' AND type !=99 4.9446254.944625
0.1103711SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%indicator%') ORDER BY total_recommendations desc LIMIT 0,400.1103710.110371
0.0753312SELECT A.*, C.username, C.userlevel, C.lastlogin, C.ip, C.lip FROM posts A, seoclerks.members C WHERE A.USERID!='' AND A.active=1 AND A.type=0 AND A.USERID=C.USERID AND sold_out=0 AND C.userlevel>1 AND A.viewcount > 10000 AND A.positive_ratings > 100 LIMIT 600 0.0779920.072669