SEOClerks

How to divide work load if you hire a virtual assistant?



Write the reason you're deleting this FAQ

How to divide work load if you hire a virtual assistant?

I would just love some guidance and tips here on how to split my work load if I hire a virtual assistant.

What exactly do you do if you hire someone?

Right now I have so much to get done and I don't have close to the amount of available time in my day to get even close to half way through what I would like to.

I am a control freak and worry about how other people will perform my work.

When you first hired a Virtual Assistant what tasks did you give them?

Comments

Please login or sign up to leave a comment

Join
idealmike
What exactly do you do if you hire someone?
Communicate! Either in person, on the telephone, instant chat, fb chat, skype etc or email at least. But I want a va that is responsive. Is English or good at English. Is reliable and punctual and not someone that wants to cheat me and do sloppy work. So I like to "vet" my va's somehow using one or either or all of these communication methods. I like to get a feel for a person. Get to know their personality and that before hiring them. I like to hire va's that are bouncy, positive people. Even though sometimes, even people who seem like they have a mean personality can still be va's. So I like to ask them about the skills and experience they have and talk to them about the work I need doing and whether or not they can do it how it needs to be done.

But when you're deciding to hire a va to outsource your work to, you also need to think about whether you're going to be outsourcing the whole job to someone and pay them for that and you get your cut/profit. Or whether you are going to be giving them only parts of it to do. Whether whole or part, you will have to break down all the steps involved for them to do that work. It helps then to brainstorm this! Just open notepad or even whop out a pen and paper and start writing down in steps what needs to be done and how it needs to be done.
  • List out in steps everything that needs to be done to get the service done and delivered.
  • Then work out which steps you can delegate to your va's and or do yourself.
  • Set a delivery deadline for them to get paid after you've received the work.
  • Pay them fast on time or like clockwork if you pay out on Friday's or something.
  • Try to streamline that process as much as possible so its less and less work.

When you first hired a Virtual Assistant what tasks did you give them?
I think it was for some links! lol Typical me back then learning the hard way! But it was when it was much easier to rank a site in the SERPS before all the latest Google Algo updates of today so was much easier to rank a site back then and you only needed tons of links and it would do the trick. Oh if only it was still like that today! I think in fact that a lot of VA's lose out on a lot of work that all those webmasters and bloggers and affiliate marketers and things would have needed if it wasn't for all the Google updates. But you can still find a good VA today. Just make sure to find out who it is you're hiring first before you put them on your payroll! How to divide work load if you hire a virtual assistant?



Are you sure you want to delete this post?

Lynne
Thanks Mike, this is making it much easier for me to get my head around, thank you for all these awesome tips. Yes I can see now that I will be needing to put some serious time and thought into exactly what it is that I want and what I expect of someone before I can expect them to do anything for me!



Are you sure you want to delete this post?

TommyCarey
The tasks I give the VA depends on what I need done. I'll never let a VA log into my accounts because that basically lets them into my system even if it's on a social platform.

I usually hire VAs to do lead generation for me. I will hire them for specific platforms like Facebook, LinkedIn or even Google Plus if I'm fealing lucky lol How to divide work load if you hire a virtual assistant?

I've also hired a VA in the past to submit information to one of my forms. Basically all he would do is submit information that I had scraped together, into my own form. The form would auto generate an SEO report and email it to whatever email was put into my form. And since I only used paid emails and not something like @gmail and @yahoo then I could almost guarantee that the emails with the reports were going to the right person or company.

If you have to do other stuff like content posting to your blogs, then you'll have to let them log in. You can work around this by setting up an author profile for them which will limit their use of the internal dashboard if you're using Wordpress. They can log in, post content and edit what they posted. They won't be able to touch anything else besides their own content, which I love How to divide work load if you hire a virtual assistant?



Are you sure you want to delete this post?

Lynne
Thanks Razzy. Do you know if there is a way for me to block them actually posting the content live on my website? So they would have to save as a draft so I can do a final check and publish it myself?

I don't want anyone to be able to have the final push since this also immediately sends out that content via my newsletters! Imagine it is a dogs breakfast and I don't get to check it first?

So if they don't log into your accounts how do they do your LinkedIn stuff for you? How do I work around this?

The stuff I think I want done is preparing images for me (I suck at that and it is easy enough to do) and maybe load up content (including images) to my websites but saving it. Not writing content but uploading the content I have created to my websites. Then once I have published the content the VA can share it everywhere.



Are you sure you want to delete this post?

anwebservices
Yes you can block them to auto publish contents before you approve! For this you will need to create separate account for your VA and give it a "contributor" access. In that case, every post will wait for your approval to be published. so you can make sure, it's ok to go live. If you decide your VA is OK and could do auto-publishing latter, you just change his access level to "Author" so in that case, he don't have all administration capabilities, but is able to publish live contents right away.



Are you sure you want to delete this post?

Lynne
Thanks Anwebservices, I will have at adding a Contributor user.



Are you sure you want to delete this post?

idealmike
Hi Lynne. If you're using WordPress and letting people create accounts and post content then you can set it so that all posts need approving by you (Admin) first anyway I think. I can't remember now but I think there was an option for that. Or it's just default that all posts (like comments) will require Admin approval. There's tons of social login plugins you can use for that which lets them login to your site with fb, twitter etc etc and it creates an account for them in the same way as it would if they registered by email and you can set what rights they have for posting and if stuff requires approval first etc.



Are you sure you want to delete this post?

hitmeasap
When I first hired people I didn't give them tasks at all. I trained them the first couple of days. I spent time writing a guide of what I expected, I sent them the guide and I answered their questions. That took about 3 days in total. After that, I gave them tasks. I hired them for my brand building services so I wanted them to find good threads and make posts in specific niches I gave them.

The first 10 or 15 posts was a pure test. So I could decide how good they where. I picked a few members and asked for 25 or 50 posts.. I stepped up the game, one step after another.

However, before I paid any of them, I reviewed all of their posts. One by one. And I paid them only for the highest quality ones, that was the most related etc. I also explained this to them right from the start, just so it wouldn't be any troubles further on.

Best Regards,
hitmeasap



Are you sure you want to delete this post?

idealmike
Good Strategy. What you say upfront matters in an ultimatum. Tell them that all their work is reviewed for high quality control before payment and then they don't have a leg to stand on should they try to question your decision not to pay them when they deliver it. Do you still keep in touch with those VA's that you could hire at any time? It's all about upscaling though. Upscale the mother out of it! How to divide work load if you hire a virtual assistant?



Are you sure you want to delete this post?

hitmeasap
I can't say for sure, but I believe I could hire them anytime I want. Due to my loss of a few big clients I had to let some of them go.. And due to my life being a bit crappy right now (which is the main reason for not being active right now).. I haven't been able to bring in new clients. Hopefully, I'll be able to do this in the nearest future.



Are you sure you want to delete this post?

Lynne
I'm so sorry things aren't great for you right now Andre How to divide work load if you hire a virtual assistant? I am sure things will pick up soon and all will be well again.



Are you sure you want to delete this post?

Lynne
Thanks for explaining step by step how you go about it Andre, that really is appreciated. I think this is a great way to go about it too.

This gives me a chance to really see what they are capable of without any risk.



Are you sure you want to delete this post?

ajlancer
Hi Lynne Thanks for your question. I think hiring virtual assistance depend on what type of work will you want to make by him. I mean it is depend on task. I am hiring specially for SEO work. Because I have load job for SEO and I cannot manage everything by one hand. Before hiring someone I am talking with him with my requirements. And If I see he is able to do work my task then I hire him and my some virtual assistance work with me last 4-5 years. And I think you are expecting content writing assistance. So, for that before hiring anyone, just check him skill about writing and observe him for few day by making few content by him, If you satisfy them hire for long.

Regards by Ajlancer



Are you sure you want to delete this post?

Lynne
Ajlancer, not so much content writing. I have started buying services from EliteWriter and so far I am very happy so I won't be changing that anytime soon.

I think more the process of taking the content that is provided and loading it onto a Wordpress post, finding stock images and creating original images...

Then tasks like social media - interacting with my followers would be nice because I hardly ever get time to do that!



Are you sure you want to delete this post?

EliteWriter
It depends on what you need to get done. I would prefer to stick to assigning the mundane and repetitive tasks, which tend to be time consuming but fairly easy. In such a way I can assure myself that the virtual assistant is totally capable of completing them properly without the need for me to spend a lot of time explaining things. I suggest you make a list of tasks that need to be completed, and the deadlines you have in mind, and then prioritize accordingly. Seeing what needs to get done as a list helps me a lot in deciding what to tackle, or in your case, what to assign.



Are you sure you want to delete this post?

Lynne
Thank you, yes I can see now that is the way to go. I do need to set out everything that needs to be done and then choose which tasks can be outsourced!

I think next week will be a week for organizing myself How to divide work load if you hire a virtual assistant?



Are you sure you want to delete this post?

Cristian
Simple and boring tasks. Because he won't have any choice.
I don't have the time to teach him very complicated stuff that I can do faster and better. So everything boring and tedious that requires a lot of time but not a lot of brain, I give to a virtual assistant.



Are you sure you want to delete this post?

keyanage
Yes boring and reptetive tasks, but even then it can be hard to get them to do because they are boring & reptitive and not paid well. I pay local people well when I need local work, it seems the only way. I struggle with virtual assistant there can be too many communication issues.



Are you sure you want to delete this post?

Lynne
Yes I can certainly understand that there could be some communication difficulties and that is one of the concerns that I have.

I know that Razzy has offered some really valuable tips for hiring a virtual assistant that might help you.

I think you are and Cristian are so right, it is the boring and tedious things that I need to outsource to a VA. Thanks for your input.



Are you sure you want to delete this post?

Barida
I would suggest you hire someone that is willing to work with all the desire to see you succeed. I have been betrayed while outsourcing job to someone that went behind me to take my clients away from me. Diving the work in hours per day should do and try to know when the virtual assistance would be free to work as well.



Are you sure you want to delete this post?

Corzhens
I don’t think it’s a good idea to hire a virtual assistant if you are a control freak who will supervise every work that the VA will be doing. I know that it is better to monitor but monitoring is different from controlling. Anyway, as a VA, he is supposed to do any task that you will assign to him as long as it is not impossible. And the payment should be commensurate to the work done. It is you who dictates the division of work and as long as the work of the VA is good then you pay him good as well.



Are you sure you want to delete this post?

Order Now
Process Time: 1.1665048599243

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=3066321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=306632

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19162' 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='19162' 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=105600 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=105600 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=105627 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=105627 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=105574 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=105574 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=105576 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=105576 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=105615 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=105615 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=105623 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=105623 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=105579 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=105579 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=105599 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=105599 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=105602 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=105602 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=105604 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=105604 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=105626 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=105626 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=105625 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=105625 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=105616 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=105616 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=105628 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=105628 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=105622 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=105622 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=105629 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=105629 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=105838 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=105838 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=106210 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=106210 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=106220 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=106220 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=134001 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=134001 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=154629 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=154629 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='19162' AND status='1' AND (question like '%How divide work load hire virtual assistant? %' OR question like '%divide%' OR question like '%work%' OR question like '%load%' OR question like '%hire%' OR question like '%virtual%' OR question like '%assistant?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19162' AND status='1' AND (question like '%How divide work load hire virtual assistant? %' OR question like '%divide%' OR question like '%work%' OR question like '%load%' OR question like '%hire%' OR question like '%virtual%' OR question like '%assistant?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='2077' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' 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=19162%' 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=19162%' 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='272.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg'

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

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

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

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

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

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

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

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

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

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

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

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