SEOClerks

Clear
Sign In Join

Recommendations Response Time User Level
Join Date Last Login Username

WebresearchDataminingFacebooktrafficYoutubescrapperMsexcel

Welcome to my Profile. Hi, my name is Md Shawon Ahmed and I love working on Seoclerks.com,I ve been working as an executive Data Entry operator for more than 3 years. I am an innovative, highly motivated, extremely organized and detail oriented person. I have worked with several executives, entrepreneurs, startups and other business. I produce a product that is memorable, clean and stand out. I believe that high quality and customer satisfaction is of most importance. I am interested in working with companies or individuals both. Feel free to drop a message for discussing your needs and obje

DataentryDatacolactionOnlinedataentryTypingMswordMsexcel

FacebookYoutubeTwitterPrinterestSmmInstagram

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

Order Now
Process Time: 0.19384002685547

Possible Duplicate queries found!
MatchCountSQLScript
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 '%MSexcel%') ORDER BY total_recommendations desc LIMIT 0,401SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%MSexcel%') ORDER BY total_recommendations desc LIMIT 0,40

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

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

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

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

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

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

/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 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.4590951SELECT 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 (47) AND gtags like'%Safe%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4590950.459095
0.2021621SELECT 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 '%video%' OR A.skills LIKE '%video%') ORDER BY A.lastgigedit desc LIMIT 0,400.2021620.202162
0.1828651SELECT 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 '%remover%' OR A.skills LIKE '%remover%') ORDER BY A.lastgigedit desc LIMIT 0,400.1828650.182865
0.1424721SELECT 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 '%video%' OR A.skills LIKE '%video%')0.1424720.142472
0.1328781SELECT 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 '%remover%' OR A.skills LIKE '%remover%')0.1328780.132878
0.1247971SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Weeks%') ORDER BY total_recommendations desc LIMIT 0,400.1247970.124797
0.1159941SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%MSexcel%') ORDER BY total_recommendations desc LIMIT 0,400.1159940.115994