SEOClerks

Welcome to SEOClerks

Create an account below in 1 minute or less.

By joining, you agree to SEOClerks Terms of Service, Privacy Policy, as well as to receive emails.

Order Now
Process Time: 0.014863014221191

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip='216.73.216.114' AND querystring LIKE '%FAILED LOGIN%' AND added >= unix_timestamp(NOW())-432001SELECT COUNT(id) as total FROM members_ledger WHERE ip='216.73.216.114' AND querystring LIKE '%FAILED LOGIN%' AND added >= unix_timestamp(NOW())-43200

/opt/clerks-staging/docroot/include/functions/includes/security.php 522 CountBotLoginAttempts() ()

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.1098521SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% facebook %' OR A.tags LIKE 'facebook %' OR A.tags LIKE '% facebook' OR A.tags='facebook') LIMIT 10.1098520.109852
0.0910261SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=588219 LIMIT 10.0910260.091026
0.0787241SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=234841 LIMIT 10.0787240.078724
0.0775111SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=201559 LIMIT 10.0775110.077511
0.0750931SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Get order %' OR A.tags LIKE 'Get order %' OR A.tags LIKE '% Get order' OR A.tags='Get order') LIMIT 10.0750930.075093
0.0646641SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=588219 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 400.0646640.064664
0.0629161SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Businesscar%') 0.0629160.062916
0.0625811SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% facebook %' OR A.tags LIKE 'facebook %' OR A.tags LIKE '% facebook' OR A.tags='facebook') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 200, 400.0625810.062581
0.0612911SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND (A.tags LIKE '% Get order %' OR A.tags LIKE 'Get order %' OR A.tags LIKE '% Get order' OR A.tags='Get order') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 400.0612910.061291