SEOClerks

Clear
Sign In Join

Long Password Generator

  • MendasDigital Level 1
    • 25

    Write the reason you're deleting this FAQ

    Long Password Generator

    The time of 8 character passwords is over. A 12-16 character long password is fairly standard these days, but more and more sites are allowing even longer passwords than that. Take Weebly.com for example which, allows up to 160 characters.

    Long Password Generator

    Most web browsers these days have a password manager which, takes away the pain of remembering long passwords, but that still leaves the difficulty of coming up with them in the first place. There are websites which will do it for you, but personally I prefer not to rely on 3rd parties.

    Below is a simple Bash script I use for generating passwords. It's not pretty, but it works. You'll need to change '10000' to the password length you need. The password will be outputted as plain-text to a file called "password" in the present working directory (eg: your home directory). This script depends on: head, base64, sed, and bash. It also uses the urandom block device.

    #!/bin/bash
    length='10000'
    head -c "$length" /dev/urandom | base64 -w 0 | sed 's/=//g' | sed 's///#/g' | sed 's/+/$/g' | head -c "$length" > password

    #Bash #Password #Linux #Website Programming
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    ninjasalesgroup

    ninjasalesgroup

    strongpasswordgenerator.com is what I have always used when needing to create passwords for customers in support. You may select the length of the password as well as what options are included. I hope this helps you out.
    7 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    Thanks for pointing that site out Long Password Generator.

    It appears to support passwords up to 4096 characters long, and generates them nice and quick too. I suspect one could edit the input form's "max" length setting to achieve longer passwords.

    Not all password websites are trustworthy, but I took a look a quick glance at the page code for this one, and it looks like they are using Crypto.getRandomValues() in javascript as part of the generation process. So the passwords themselves appear to be well constructed. I didn't check to see if passwords were logged, but the website claims they aren't.
    7 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    You may also like https://jamesdanielmarrsritchey.gitlab.io/ritchey-web-password-generator/ . The code is easy to vet for logging (or other malicious practices), because there isn't a ton to read through. It allows you to download your password as a text file Long Password Generator.
    7 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    I did not know weebly accepts upto 160 characters password, in fact I even did not not password could be as long as 160 character. Normally I work with 8 character. When I create password, I use punctuation marks, numbers, alphabets with upper case. My password is something liker a bitcoin address. I save password on my browsers, which takes away pain of remembering password.
    9 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    I was surprised as well that Weebly accepts 160 characters. I wonder how they arrived at a decision that 160 would be the max. Seems like a really random number.
    9 years ago

    Are you sure you want to delete this post?

    Tronia

    Tronia

    Damn, 160 characters? that's like a small essay, haha.

    I always have problems remembering my passwords from a lot of sites... then I have to keep resetting them and so on. I still find it hard to believe how many people use the same one password on every single page. Why would you ever use the same password for a forum and PayPal? makes no sense to me at all.

    I don't really think I need a password generator. My passwords are all 6+ characters, cap locks, and numbers. That should suffice.
    9 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    Most of my passwords aren't nearly that long, I even have a couple 6 character passwords, but I do have one that is over 600 characters Long Password Generator. Even if the site's database gets stolen, I doubt attackers will crack that one Long Password Generator.
    9 years ago

    Are you sure you want to delete this post?

    overcast

    overcast

    I personally use the LastPass. I think it is good enough for the long passwords. Also it can allow you the combination of letters, numbers and symbols. So it can be really good for many ways. I just don't think that long password generator would be good if you consider the password to write down somewhere. For me it can be hard to remember anything above 12 digit.
    9 years ago

    Are you sure you want to delete this post?

    johnfranklin1

    johnfranklin1

    I would prefer to generate the short password as I am too lazy for such things. I would love to have a short password, it dos not matter the combination of letters and numerics or the case sensitive. I don't know how people remember that long passwords. If they save it in explorer still they can have a problem if the windows crash.
    9 years ago

    Are you sure you want to delete this post?

    simplymh

    simplymh

    Wow that is crazy you can have up to 160 characters! I would have never imagined. I would think a 8 to 12 character password would be enough.
    9 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    My Twitter account password is 100,000 characters long Long Password Generator. I'm not sure what the maximum for Twitter is.
    9 years ago

    Are you sure you want to delete this post?

    wallet

    wallet

    Wow 160 characters is a long password that would take a lot of time to write it somewhere. I never use a password generator, i prefer to use a smaller and easy password to remember, ussualy I use something easy like my birth date or something important to me or my family!
    9 years ago

    Are you sure you want to delete this post?

    Fuzyon

    Fuzyon

    I do understand why there are character limits on passwords since it would take a lot more storage power to store them but some sites are really unconsiderate with their limit - I found some that didn't allow passwords longer than 20 characters, it's a good way of getting accounts on your site hacked.
    9 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    Plus if the password database is ever stolen, shorter passwords are more likely to be present in an attacker's rainbow table Long Password Generator.
    9 years ago

    Are you sure you want to delete this post?

    Okav1ator

    Okav1ator

    I've never really had the need to have huge passwords since I normally stick to 1-2 passwords in total. However, I'll be sure to check out your script and possibly implement it into my password routine. Cheers!
    9 years ago

    Are you sure you want to delete this post?

    Fuzyon

    Fuzyon

    I think 160 characters is good for the time being, but I reckon once hackers improve their scripts we will have passwords that will even reach 1000 characters. Password apps will be mandatory when that will inevitably happen. I think I'll just invest in some stocks for KeePass now that I think about it. Long Password Generator
    9 years ago

    Are you sure you want to delete this post?

    clara1993

    clara1993

    Seriously? ?? 160 characters? Personally I think that's too much, I would not even make A 50characters password for fear of forgetting it! But now I see people saying they have a 100 000character password for their Twitter accounts, I'm just surprised because all my passwords are between 15 and 20 characters and sometimes I havecto reset them when I change devices!
    9 years ago

    Are you sure you want to delete this post?

    Authord

    Authord

    I think The manytools.org password generator allows you to create random passwords that are highly secure and extremely difficult to crack or
    guess due to an optional combination of lower and upper case letters,
    numbers and punctuation symbols.
    9 years ago

    Are you sure you want to delete this post?

    fishbate

    fishbate

    Well i think it's too much for security, passwords are made to protect your content or files but having long passwords may not be the right way to protect it. There are some instances that it causes you delays specially when you forgot it because its too long. Also having long passwords will not guarantee you a full proof protections.

    There are many ways that a hacker can get access to your files like back logging and spywares. Having long passwords may keep key software away from your files for a long time but eventually they will get in.

    In my opinion awareness is the key for protection...
    8 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    Awareness is huge, and you're right, there is no 100% effective protection. The main advantage of long passwords is protection against rainbow table attacks, because your password is more likely to be unique to you in all the world. These days, users aren't just protecting against someone trying to brute force login to their account, it's also important to protect against password database thefts.
    8 years ago

    Are you sure you want to delete this post?

    stbrians

    stbrians

    A 160 character password! That is too long.Steemit has a 52 character password and you should not lose it. They do not generate or reolace passwords. If you lose it then you lose your money. Passwords are to be saved and backed up both electronically and virtually
    8 years ago

    Are you sure you want to delete this post?

    Corzhens

    Corzhens

    Pardon me for this comment because I am surprised by that long password generator that I’m sure was invented to give hackers a big headache. How could a hacker think of the right password when it is 100 characters long? But on the contrary, do you really think that it is practical to be using such a very long password for your own purpose? A short password that is a combination of letters and numbers would suffice for me because that would be easier to remember.
    7 years ago

    Are you sure you want to delete this post?

    MendasDigital

    MendasDigital

    Longer passwords are more likely to be unique which decreases the likely hood of them existing on any rainbow tables, or being created through on the fly computer guesses.

    A good password won't just protect you against some person typing in different passwords hoping one will grant access. It will also protect you against computerized brute force login attempts (which could be millions of guesses per second or more), and password database thefts.
    7 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 1.7523710727692

    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='22839'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='22839'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=4865321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=486532

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22839' 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='22839' 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=185725 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=185725 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=185776 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=185776 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=185789 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=185789 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=117936 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=117936 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=121763 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=121763 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=117977 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=117977 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=117989 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=117989 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=118147 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=118147 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=118178 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=118178 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=118991 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=118991 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=121762 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=121762 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=120864 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=120864 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=121645 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=121645 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=121688 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=121688 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=122190 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=122190 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=122540 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=122540 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=130023 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=130023 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=130268 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=130268 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=152859 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=152859 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=152899 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=152899 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=163382 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=163382 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=170886 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=170886 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=172097 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=172097 LIMIT 5

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

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

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

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

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

    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 seoclerks.members WHERE USERID='2255' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='4136' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='4136' 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='1323' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' 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=22839%' 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=22839%' 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='299892.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='299892.png'

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='614330.png'1SELECT 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='675722.gif'1SELECT profilepicture FROM seoclerks.members WHERE USERID='675722.gif'

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

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

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.2365181SELECT 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 (33) AND gtags like'%Profile%' AND type !=99 0.2365180.236518
    0.1953691SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Tok%' OR A.skills LIKE '%Tok%') ORDER BY A.lastgigedit desc LIMIT 0,400.1953690.195369
    0.1365991SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Tok%' OR A.skills LIKE '%Tok%')0.1365990.136599
    0.1188691SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%mapcitations%') ORDER BY total_recommendations desc LIMIT 0,400.1188690.118869