SEOClerks

admin of www.drboxstore.com

Admin

The Professional tour guide, archaeologist, photographer, and interpreter.

TourismSalesManagementMarketingAdminAccounting

Hey, as you may already know, my name is Sean, I live in Glasgow, Scotland United Kingdom . I currently own 7 websites including a Xbox Forum, Gaming Blog, Car Q&A, SEO Web Tools Site, and last but not least, a couple of SEO Clerks Affiliate Stores. I like most sports, but love Football & Darts, I also enjoy watching reality TV, documentaries, & game shows. As well as owning, maintaining & promoting my websites, my other online hobbies include forum posting, blog writing, social networking & competition running. If you want to know something else about me? Just Ask!

ContentWritingAdministrationModerationForumPoster

I hold a Diploma in Computer Studies, Diploma in Accounting, and B Sc in Accounting from the University of Benin, I am also a certified Database Professional from Oracle University, USA, certified professional in Online Marketing from the eMarketing Institute.

DataentryAdministrativeProofreaderMicrosoftexcelVirtualMarketin

Hey, I am Shima292 from BD. Now working with Social Media. I am provide SEO service at cheap rate. Also I work honestly and very fast. I work with an active. Here You will get Those Services As - Facebook likes Facebook comments Facebook Reviews Facebook subscribers Facebook manager Twitter Followers Twitter Tweets Twitter Re-tweets Twitter Faborites Instagram Followers Instagram likes Real Youtube likes Youtube subscribers Youtube comments Youtube view Soundcloud Followers Soundcloud comment Soundcloud view And other act.

FacebooklikesFacebookfollowYoutubelikesYoutubeviewSoundcloudTwitter

Hey, This is Tharindu from Sri Lanka. I m a freelance system administrator. I have very good experience working with Ubuntu VPS, CentOS VPS, Apache2 Server, Nginx Server, MySQL and Wordpress.

Sysadmin

Founder and Admin of off topic forum The Offwalk www.offwalk.com Offering forums related services. Also offers signature selling renting, sponsor links at footer, sponsor threads, banners advertising for promotion of your blog, site, links, product or services. G!

ForumsForumAdviceGuidenceCommunityPost
Order Now
Process Time: 0.23999309539795

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 query_cache WHERE query= ? LIMIT 1 1SELECT `value`, `last_checked` FROM query_cache WHERE query= ? LIMIT 1

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

SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Admin%') ORDER BY total_recommendations desc LIMIT 0,401SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Admin%') ORDER BY total_recommendations desc LIMIT 0,40

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

SELECT * FROM posts WHERE USERID=1017131SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=101713

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

SELECT * FROM posts WHERE USERID=232851SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=23285

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

SELECT * FROM posts WHERE USERID=6246731SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=624673

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

SELECT * FROM posts WHERE USERID=869461SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=86946

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

SELECT * FROM posts WHERE USERID=18561SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=1856

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

SELECT * FROM posts WHERE USERID=7783701SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=778370

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

SELECT * FROM posts WHERE USERID=7017361SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=701736

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

SELECT * FROM posts WHERE USERID=3240271SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=324027

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

SELECT * FROM posts WHERE USERID=3066481SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=306648

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

SELECT * FROM posts WHERE USERID=2870451SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=287045

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

SELECT * FROM posts WHERE USERID=603101SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=60310

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

SELECT * FROM posts WHERE USERID=505821SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=50582

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

SELECT * FROM posts WHERE USERID=103811SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=10381

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

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()

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.3864011SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (36) AND gtags like'%all%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.3864010.386401
0.2033261SELECT 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 (36) AND gtags like'%all%' AND type !=99 0.2033260.203326
0.1169581SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Admin%') ORDER BY total_recommendations desc LIMIT 0,400.1169580.116958
0.1168281SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Autoretweet%') ORDER BY total_recommendations desc LIMIT 0,400.1168280.116828
0.1098691SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Wordpress-plugins%') ORDER BY total_recommendations desc LIMIT 0,400.1098690.109869