There are so many ways webmasters use to protect their website from getting spammed by irresponsible posters. I was researching last night and came across Akismet spam filter which was said to reduce or eliminate spam po...
Each forum software comes with a a distinct features that makes it unique and different from other softwares used for either blog or forum purposes. What features of any forum or blog softwares do you love most? Min...
Whether I am writing for other writing online sites or my own blogs, I usually have the habit of using my own images that I had taken photos with my smartphone, Lenovo S860. I prefer to take pictures of my recipes, thing...
A lot of forums have these added benefits that they offer when you donate to them and these benefits increase depending on the amount that your donation is. Do you think that this is an effective way to get donations and...
We all know that it is tough at the start to get people to visit your site, join it or even comment on different discussions. So we tend to advertise on different platforms to try and attract people to the site. But is a...
Custom themes can be quite expensive especially if you are a start-up. But the benefit is that your website could look a lot more professional if it has a custom and unique theme that no other business or website uses. I...
What I mean with dead website is a website that has noupdates for 1 year. And since it has become static for a long time, most likely there are no more visitors excepts the usual bots. Given the task to revive the dead...
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT 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 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 '% Website Forum %' OR A.tags LIKE 'Website Forum %' OR A.tags LIKE '% Website Forum' OR A.tags='Website Forum') LIMIT 1 | 1 | SELECT 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 '% Website Forum %' OR A.tags LIKE 'Website Forum %' OR A.tags LIKE '% Website Forum' OR A.tags='Website Forum') LIMIT 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * 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 '% Website Forum %' OR A.tags LIKE 'Website Forum %' OR A.tags LIKE '% Website Forum' OR A.tags='Website Forum') ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | 1 | SELECT 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 '% Website Forum %' OR A.tags LIKE 'Website Forum %' OR A.tags LIKE '% Website Forum' OR A.tags='Website Forum')
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from questions as A where A.status='1' | 1 | SELECT count(A.quesid) as total from questions as A
where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM answers as A where A.status='1' | 1 | SELECT count(A.ansid) as total
FROM answers as A where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE (script='/opt/clerks-staging/docroot/faq.php'
OR script='/opt/clerks-staging/docroot/viewfaq.php')
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * 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 asc | 1 | select * 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 asc | 1 | select * 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='648563' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='648563' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='598910' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='598910' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='599711' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='599711' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
| 0.103243 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%head%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.103243 | 0.103243 |
