SEOClerks

Top 10 Video Content Ideas for Small Businesses to Adopt Today



Write the reason you're deleting this FAQ

Top 10 Video Content Ideas for Small Businesses to Adopt Today

Top 10 Video Content Ideas for Small Businesses to Adopt Today
There's no doubt and no question now that video is the leader when it comes to content that is viewed on the web. Both online and offline! And while many businesses, young and old, are picking up video marketing more and more, there are still many businesses, both online and offline types, that haven't yet fully got to grips with and adopted video marketing. And with all the ways that videos can be beneficial to you and your business, and with all the different types of videos one can make a video on, there's not really any excuse not to adopt video marketing is there?

However, sometimes, it can just be knowing how and where and what kind of videos you can actually make, that can be enough for you to know. And then knowing is half way to doing. Fortunately, I'm going to share with you here Top 10 Video Content Ideas for Small Businesses to Adopt and Make today. A little about what they are and how they can be used and useful by, to and for you!

1. Product Review Videos
Product review videos are similar to customer testimonial videos in that a product review is one where a customer reviews on or more of your products or services but does so in a recorded video of it. These types of videos help potential customers and clients to make a better, more informed decision on whether to purchase said product/service.

2. Tour Videos
Tour videos let you get up close and personal with your prospective clients and customers and unveil your company to let them see who you are and how you operate. These types of videos can help people to relate to your business or company and build trust through transparency.

3. How It's Made Videos
Everyone loves to watch that How It's Made show right? Well, sometimes anyway. But How It's Made videos are videos that literally show how something has been made! You can make a video that shows how a certain product or service is made or comes together, the people and processes involved behind it. It's only limited to certain types of businesses though.

4. Photo Slides / Show Videos
Some businesses or companies products and services can be represented in images. If you have images or photos of your products or services and the steps that make them come to be, you probably put together a video montage of them in PowerPoint and turn it into a video slide show!

5. Staff Introduction Videos
As a great way to not only show the great people that work for your business or company, but as a way to show you have a real human side to it, which people really like these days. You can help your prospective clients to connect with those people, your staff, before they even come in to your premises or purchase your products or services by introducing them on video.

6. Industry Interview Videos
You can provide extra value to prospective clients and customers by interviewing various industry experts in your niche and industry. These types of videos can be really useful for discussion the most important or pressing issues that people in that industry face and can go on to earn you a lot of credibility from your prospective clients and peers.

7. Helpful Tips Videos
As another way to show off your expertise and authority in your niche, helpful tips videos can do that and build credibility and authority status amongst those in your industry. Not to mention just be really helpful to the people that need to know such things. You can compile a list of top 10 tips or just answer some of the most common questions people ask about your niche or industry, products or services etc and turn it into a video pretty easily. 

8. Article Videos
Have you got a blog with a lot of blog post articles on it? You can repurpose them and bring them back to life by converting them to video format and then sharing them on the Internet. Eg; YouTube etc etc. You can use some article to video software for this or get someone to do it for you and be your voiceover so they speak it out while showing images or something simultaneously.

9. Vlogging Videos
Vlogs are catching on like wildfire right now! More and more people are vlogging as opposed to just straight up blogging! Vlog is short for "Video blog". So instead of just posting a written article to your blog, you would post a video instead. Vlogs are often great ways to document things like the day in the life of something or anything else of such nature.

10. Tutorial Videos
Tutorials videos or even animated explainer videos can provide your targeted audience with value packed training that's specifically related to your niche or industry. Most businesses and companies have products or services that can be better explained with a tutorial of sorts. So by creating a step by step video tutorial it will help them out and that swings sales!

And that's my top 10 video content ideas that small and large businesses can adopt and use today! You can probably do one of them, if not all of them! And by doing so, you will definitely notice more business, traffic and sales coming your way. Seriously, any one business not adopting any of these video content ideas today, is just leaving money on the table to their rivals!

Do you or have you ever made any of these video types?

What other video content ideas do you know of?

Thanks!

Mike.

Comments

Please login or sign up to leave a comment

Join
coconutcountry
Great article, Mate. Thanks for the tips about 5G too. Our Masonic masters don't really give a flip about us. Hopefully we can get them a little time in the quarry or maybe even the guillotine if they've been super naughty. ; )



Are you sure you want to delete this post?

Tronia
I agree with you, Mike. Videos are definitely the right way to go if you want to get quickly noticed and it is, therefore, an ideal thing for smaller and even big businesses. Out of these ten suggestions, I think that the hottest trending right now is product reviews, tutorials and how it's made. They're incredible because they attract a large amount of viewers - if done correctly, the person that first watches them will link them to his friend and his friend to his friend and so on!

My own content suggestions for small businesses would be:
- event videos - if you throw any sort of events, make sure to record it and make it into a nice montage where people can see how it was. They will instantly feel closer to you and your business.
- questions and answers videos - who doesn't enjoy a little Q&A once in a while? your customers often have many interesting questions and you can turn it into content for videos!



Are you sure you want to delete this post?

idealmike
That's a great point, people pay much more attention to what's said to them or asked of them in a video over text on a page. And when just one person does it, and their mates see that, they usually just automatically like and reshare it. But that's just natural. Top 10 Video Content Ideas for Small Businesses to Adopt Today That's a good idea too and would work well for the freelance affiliate niche. That's what it's all about eh!? lol cheers! Top 10 Video Content Ideas for Small Businesses to Adopt Today



Are you sure you want to delete this post?

Corzhens
On the contrary with videos you have to take note of the majority of internet users with a short attention span because I am one of them and I don’t have the habit of watching videos. I was invited to a site that purportedly pays good that I could earn so much but what was sent to me were explainer videos. I think I received 6 videos but I did not watch any and that was the reason why I haven’t joined that site .



Are you sure you want to delete this post?

TsuyoyRival
Tour and vlogging videos are such a good idea! As a customer, i really enjoy seeing what's behind the scenes, the effort made by the professionals, and the sense of teamwork. Good article by the way! Keep the good work!



Are you sure you want to delete this post?

idealmike
Thanks mate I agree! Definitely got to get cracking on making some of them and seeing what the come back is! Top 10 Video Content Ideas for Small Businesses to Adopt Today



Are you sure you want to delete this post?

keen2write
Excellent post-Mike and really enjoyed reading it. I also agree as these day's everywhere I turn there's someone watching a video online mainly YouTube Even kids watch it on their own tablet. But yeah video is the best format these days you can get more chance appearing high in ranks on youtube rather than google.



Are you sure you want to delete this post?

idealmike
Cheers Kev! And I enjoy you reading it lol no jk! Top 10 Video Content Ideas for Small Businesses to Adopt Today But yeah, you know it! I was just saying to my mate then and talking about 5G and the dangers of it but you know they're going to push that even though it could basically fry your brain! lol listening to Max Igan talking about "smart dust" and saying how we need to be careful of AI as it will eventually become "self aware" and turn against us. Smells like Skynet doesn't it!? Lol Top 10 Video Content Ideas for Small Businesses to Adopt Today And it's just how technology is so integrated and becoming much more into our lives and our whole insatiable need to watch videos. Video definitely killed the radio star! ;)



Are you sure you want to delete this post?

cmoneyspinner
5G? It's dangerous? Oh my poor children! Not worried about myself. My brain is already fried. Top 10 Video Content Ideas for Small Businesses to Adopt Today I'm from the generation when the television was supposed to turn us into zombie idiots. Top 10 Video Content Ideas for Small Businesses to Adopt Today Thanks for pointing me to this video.



Are you sure you want to delete this post?

djwaruna
Thank you very much Mike Top 10 Video Content Ideas for Small Businesses to Adopt Today



Are you sure you want to delete this post?

zeedollar
This is a totally complete break down on videos and how small businesses can tap into the band wagon. I totally love promotion video as it resonates more trust to your products as compared to products with out videos. I also love how its made videos, as its getting really popular these days and everyone has the chance of adding their own unique touch to look different.



Are you sure you want to delete this post?

overcast
I have seen that tour and the food videos are getting traction. Many people want to know how the place is around the world. Same with the food. They want to see that thing up and close. I guess this would something worth checking out how much it can earn. I have seen that ads on games and related channel often may not convert. So it'd be fair to say that other niches may thrive.



Are you sure you want to delete this post?

arachnophobik
Great article man! As for photo slides, I think it could be good and it could be bad also. There are good photo slides that look very professional, in which the photos and their transitions look very interactive, but then there are those who simply put on a photo with a fade in/fade out transitions and I think those are quite unprofessional. Overall, I like what you listed on this thread, keep up the good work mate!



Are you sure you want to delete this post?

wallet
This is an interesting point of view, I like this idea. I guess that a tour video and tutorial videos are the best choices from your list to start a business. I think there are many people to watch this kind of videos before going on a trip. The tutorial videos help a lot to people to make ideas about a business, how to start or how to maintain one!
Good post, educative and interesting to read, thanks for sharing!



Are you sure you want to delete this post?

amazingsteven
This is a well comprehensive guidelines to Vlogging. Vlogging are very popular now and it would be unwise not to tap into this. Thanks Mike for sharing this great and informative articles.



Are you sure you want to delete this post?

gelotologist
Agreed, vlogging are the new ways for you to be millionaire, but you must have an awesome and interesting content as well,so people or watcher would love it in any other ways. Not just it lets you do whatever you want to do for a day but it also gives you money by just capturing every thing you do, everyday in your life. This is actually a great way to start a YouTube channel or probably to make YouTube as your part time job.



Are you sure you want to delete this post?

airfightermax
Nice write up! With how users interact with the internet today, incorporating videos to your content is a really good idea especially since product reviews are all the rage today on youtube!

I am sure a lot of people will find your article very useful.



Are you sure you want to delete this post?

Corzhens
I like that staff introduction. It is like selling the people real people inside of your organization. When I was new in the bank that I work for, I remember an advertisement that came out in the newspapers. There were photos of the top officers of the bank that included a short description of their expertise. I guess that style is good enough for introducing the staff of your company.



Are you sure you want to delete this post?

cmoneyspinner
I was Googling stuff about watching videos and this discussion showed up in the search results. Visited here a year ago but I had forgotten. I love your list. I now have a YouTube channel because Google changed its policy and I had to create a channel. I have not used it. But even before I created a YT channel other people recommended to me that if I was going to use YouTube, Number 4. Photo Slides / Show Videos and Number 8. Article Videos were probably a good way to get started. It's on my To Do List.



Are you sure you want to delete this post?

jaymish2
Video content is definitely the way to go. I think it is the way of communicating in today's world and for years to come. Most small businesses these days are getting website because it's essential to communicate with their customers. It also showcases their businesses to their customers.I think that most important video content to have his tutorials. Most people that go online always looking for better ways to do certain things. if you can provide tutorials in your niche you will attract a sizable audience.



Are you sure you want to delete this post?

Order Now
Process Time: 1.7194530963898

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

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

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

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

SELECT * FROM categories_faq WHERE CATID='55'1SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='55'

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

SELECT * FROM seoclerks.members WHERE USERID=2721SELECT googleplus_profile FROM seoclerks.members WHERE USERID=272

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='23128' 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='23128' 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=125203 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=125203 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=125127 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=125127 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=125167 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=125167 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=172629 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=172629 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=125150 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=125150 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=125168 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=125168 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=125164 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=125164 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=125170 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=125170 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=125812 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=125812 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=125782 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=125782 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=125251 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=125251 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=125255 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=125255 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=125351 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=125351 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=125630 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=125630 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=125662 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=125662 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=147294 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=147294 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=125732 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=125732 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=150911 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=150911 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=161036 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=161036 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=171053 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=171053 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='23128' AND status='1' AND (question like '%Top 10 Video Content Ideas Small Businesses Adopt Today%' OR question like '%Video%' OR question like '%Content%' OR question like '%Ideas%' OR question like '%Small%' OR question like '%Businesses%' OR question like '%Adopt%' OR question like '%Today%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='23128' AND status='1' AND (question like '%Top 10 Video Content Ideas Small Businesses Adopt Today%' OR question like '%Video%' OR question like '%Content%' OR question like '%Ideas%' OR question like '%Small%' OR question like '%Businesses%' OR question like '%Adopt%' OR question like '%Today%') -- 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='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='7' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='7' 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 seoclerks.members WHERE USERID='840' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='840' 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=23128%' 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=23128%' 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='576613.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='576613.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='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='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='322073.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='322073.png'

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='602499.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='602499.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.2939901SELECT 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 ORDER BY A.bdays desc LIMIT 0,400.2939900.293990
0.1793981SELECT 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 0.1793980.179398