SEOClerks

Clear
Sign In Join

How long will Google keep old URLs indexed after a change of address?

  • Cristian Level X3
    • 18

    Write the reason you're deleting this FAQ

    How long will Google keep old URLs indexed after a change of address?

    Ok, so this question is only directed to the SEOs here that dealt with a website migration from one domain to another at least once. 

    I want us to share our experiences and maybe find answers.

    I personally coordinated a few dozen domain changes over the years, and I simply had no problem with the old URLs, most of them were out of the index in a few weeks. 

    But with my last client, I ran into a pickle. 

    It's been three months already, and ALL the old URLs are still indexed, and I believe I did everything by the books.

    Here is what I've implemented so far, let me know if I missed anything:

    • Redirected 301 all URLs from the old domain to the new domain.
    • The content remained the same, only the domain changed.
    • The website had only 60 or so index pages, nothing complicated, the structure was straightforward. 
    • Made sure to submit a change of address in Search Console to let Google officially know about the change.
    • I moved the old sitemap to the new domain and implemented a 301 redirect. Basically, olddomain.com/sitemap.xml now redirects to newdomain.com/old_sitemap.xml
    • Submitted newdomain.com/old_sitemap.xml in the Search Console of the new domain so that Google can understand the move. 
    • Submitted a new fresh sitemap to Search Console with all the new links. (newdomain.com/sitemap.xml)

    In the past, all of my change of address migrations were fairly uncomplicated because the new domain was freshly bought and I always insist on a server/hosting change also. 

    The current client I'm currently having problems with has the following weird factors:

    • The new domain used to 301 redirect into the old one (for at least six months). 
    • The server is the same.
    • The IP hasn't changed.
    • Basically, everything is identical from hosting point and folders point of view, the only thing that changed was the domain.
    • Olddomain.com/robots.txt is still accessible.
    What am I doing wrong? The server/hosting change is off the table. If you think there is something I missed, please let me know. Do you think it just takes a lot more time because of the shared similarities, or will I still be seeing the old domain index one year from now?
    What do you think I should do about the old domain robots.txt? Because I've read some messed up stories about people messing with the old robots.txt which in turn affected and influenced their new domain because Google for some reason,n still saw the old domain robots.txt as the main robots.txt and applied the same rules to both domains, new and old. 
    Also, how much should I keep the old sitemap around? Because I know for sure, Google recommends keeping it around for a few months. But when should I remove it, and should I just delete it completely? 

    Again, if any of you know what I'm talking about and had similar experiences, let me know and let's discuss! 
     

    #Redirect #301 #Site #Migration #Change #Of #Address #Old #Url #Index #Google Website Management
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    cmoneyspinner

    cmoneyspinner

    Since the website didn't have that many indexed pages, why don't you just manually request removal of the URL using the Google webmaster tool for removing URLs. It's a lot of work but still … it might work!
    8 years ago

    Are you sure you want to delete this post?

    SiamSEO

    SiamSEO

    It's better to leave the old URL's there instead, because they should get removed by Google after they handle the redirect, removing them yourself will negate the benefit. Changing domains is always a very drastic measure, and many things can and probably will go wrong, so it's better to just leave the old stuff wth 301 redirect.
    8 years ago

    Are you sure you want to delete this post?

    kgord

    kgord

    This might be the simplest thing to do, and if you haven't tried it then I think that you should do so. It doesn't hurt to try and it might actually take care of the problem. Best of luck!
    8 years ago

    Are you sure you want to delete this post?

    seoconsul

    seoconsul

    Respected Sir,
    SImply write to them. They will certainly help you.
    Contact them either within Search Console Or Google Webmaster forum

    With regards,
    8 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    That may be a good idea, but I'm afraid Google as well as their webmaster forum, will give me some generic answers I already know. Like: it can take time, read this resource and that resource (which I already did and know about).
    8 years ago

    Are you sure you want to delete this post?

    seoconsul

    seoconsul

    If its still there, then, may be the related links has been providing some value, to user of Google search better than the current one.

    Better contact within Search Console. First reply may be generic
    Then, they may reply the proper solution ,,,takes 2-4 days
    8 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    I think in some cases they usually index new URLs pretty fast. And the traffic is properly diverted. And usually if the account is properly managed on the webmaster console. Then it's possible that they can do it quickly. And old urls get vanished. Now that they have data rules. You can see that it is going to have more impact on their retention rates.
    8 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    The new URLs and the new domain, in general, got indexed in Google without any problem! Most of the organic traffic actually comes on the new domain and not the old.

    The only problem I'm having is the old domains being still in Google's index. I feel like the authority of the old domain wasn't completely redirected to the new domain as long as the old URLs are still indexed.
    8 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    Does it mean that the indexing of new URLs will treat the new address as a new website? If that is the case then the old URL will still be in existence until it is tagged stagnant and removed from the index. Anyway, my idea of a change of domain for a website is like getting a new website altogether that the old one will have no bearing anymore because the backlinks will not be working like before since it had changed address already.
    7 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    In my experience, your new links will be indexed pretty soon. I have found my new link index on the next day. However, the outdated links tale time to get de-indexed. Sometimes it might take more than 6 months. Usually, I go to Google Search console and submit my links for removal. When submitted, your link will be removed within 24 hours.
    8 years ago

    Are you sure you want to delete this post?

    seoman2013

    seoman2013

    not more one week as i think
    8 years ago

    Are you sure you want to delete this post?

    Judas2018

    Judas2018

    Google is usually very prompt about this sort of thing. I think you will see your new url(s) indexed and crawled then listed, within two weeks or less of the initial changeover.
    8 years ago

    Are you sure you want to delete this post?

    Martinsx1

    Martinsx1

    It should be taken care of in at least not less than 24 to 48 hours but if it goes beyond that time gap, then I suggest that you should contact support as it would give you an immediate response to taking care of it.
    8 years ago

    Are you sure you want to delete this post?

    EfficientNinja

    EfficientNinja

    In my experience, the longest it took must be about 2-3 weeks. I just let the old URLs sit in Google's database and let them do their work. But if you are in a hurry or it has taken longer than that, you should follow other people's advice above and ask Google for assistance.
    8 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    Where do I do that exactly?
    8 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    This is an issue that was discussed in our office last year. There was a plan to change the URL of our office website and we were evaluating the pros and cons. But in the end, we decided to stick to the present URL since it is working all right. I remember my boss saying that why fix it when it ain’t broke. When the website addressed is changed, it will have an issue with the search engines that the ranking will be affected.
    8 years ago

    Are you sure you want to delete this post?

    yantramstudio

    yantramstudio

    Hi,

    A change of address notifies Google about the new URLs for your existing content, so that we can update our index to reflect the new domain for your pages. This updated index status remains in effect for 180 days, by which time Googlebot will have crawled and indexed the pages at the new address.

    http://www.yantramstudio.com/
    8 years ago

    Are you sure you want to delete this post?

    Derpx9

    Derpx9

    HI,

    Google Waits (15) Days.
    And Re Creates New Cache.
    8 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.12697911262512

    Possible Duplicate queries found!
    MatchCountSQLScript
    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='25908'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='25908'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=1341SELECT googleplus_profile FROM seoclerks.members WHERE USERID=134

    		/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=25908 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=25908 LIMIT 5

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='25908' 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='25908' 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=154151 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=154151 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=154175 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=154175 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=154248 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=154248 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=154117 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=154117 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=154139 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=154139 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=154219 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=154219 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=154123 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=154123 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=154140 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=154140 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=180261 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=180261 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=154169 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=154169 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=154178 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=154178 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=154196 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=154196 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=154208 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=154208 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=154242 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=154242 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=154286 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=154286 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=154320 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=154320 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=154388 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=154388 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=154450 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=154450 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='25908' AND status='1' AND (question like '%How long Google URLs indexed change address? %' OR question like '%long%' OR question like '%Google%' OR question like '%URLs%' OR question like '%indexed%' OR question like '%change%' OR question like '%address?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='25908' AND status='1' AND (question like '%How long Google URLs indexed change address? %' OR question like '%long%' OR question like '%Google%' OR question like '%URLs%' OR question like '%indexed%' OR question like '%change%' OR question like '%address?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=25908%' 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=25908%' 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='596028.jpg'1SELECT 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='337405.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='337405.png'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='134.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png'

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

    SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'1SELECT 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='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 seoclerks.members WHERE USERID='585810.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg'

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='648563.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='648563.png'

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

    SELECT * FROM seoclerks.members WHERE USERID='685879.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='685879.png'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='582757.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='582757.png'

    		/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

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.1008701SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Uploader%') ORDER BY total_recommendations desc LIMIT 0,400.1008700.100870