| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.112' | 1 | SELECT count(id) as total FROM seoclerks.banned_bot_ip WHERE ip='216.73.216.112'
| /opt/clerks-staging/docroot/include/functions/includes/security.php 1090 IsIPBannedBot() include_once()
|
| 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 members WHERE username = ? AND status='1' | 1 | SELECT *
FROM members
WHERE username = ?
AND status='1'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM ratings WHERE USERID = ? AND RATER != 0 AND NOT (good = 0 AND bad = 0) | 1 | SELECT COUNT(RID) as total,
SUM(bad) as badTotal,
SUM(good) as goodTotal
FROM ratings
WHERE USERID = ?
AND RATER != 0
AND NOT (good = 0
AND bad = 0)
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1 | 1 | SELECT time
FROM inbox2
WHERE MSGFROM = ?
AND action = 'delivery'
ORDER BY time
DESC LIMIT 1
| /opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() ()
|
| 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=? | 1 | SELECT usergroup
FROM seoclerks.members
WHERE USERID=?
| /opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()
|
