| 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 seoclerks.members WHERE username='Jingling' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='Jingling' AND status='1'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()
|
| SELECT * FROM answers WHERE userid=59863 | 1 | SELECT distinct quesid FROM answers WHERE userid=59863
| /opt/clerks-staging/docroot/faq.php 258 () ()
|
| 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.quesid IN (5660,5703,5751,5745,5871,6677,6675,6726,6672,6741,6920,6913,6921,6906,6919,6748,6958,6720,6997,6995,7009,7010,7005,7004,7006,7257,7256,7254,7277,7276,7275,7274,7273,7357,7356,7352,7353,7347,7309,7337,1798,7358,7361,7362,7348,7336,7282,6739,7375,7370,7376,7428,7685,7686,14504,14683) 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.quesid IN (5660,5703,5751,5745,5871,6677,6675,6726,6672,6741,6920,6913,6921,6906,6919,6748,6958,6720,6997,6995,7009,7010,7005,7004,7006,7257,7256,7254,7277,7276,7275,7274,7273,7357,7356,7352,7353,7347,7309,7337,1798,7358,7361,7362,7348,7336,7282,6739,7375,7370,7376,7428,7685,7686,14504,14683) 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.quesid IN (5660,5703,5751,5745,5871,6677,6675,6726,6672,6741,6920,6913,6921,6906,6919,6748,6958,6720,6997,6995,7009,7010,7005,7004,7006,7257,7256,7254,7277,7276,7275,7274,7273,7357,7356,7352,7353,7347,7309,7337,1798,7358,7361,7362,7348,7336,7282,6739,7375,7370,7376,7428,7685,7686,14504,14683) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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.quesid IN (5660,5703,5751,5745,5871,6677,6675,6726,6672,6741,6920,6913,6921,6906,6919,6748,6958,6720,6997,6995,7009,7010,7005,7004,7006,7257,7256,7254,7277,7276,7275,7274,7273,7357,7356,7352,7353,7347,7309,7337,1798,7358,7361,7362,7348,7336,7282,6739,7375,7370,7376,7428,7685,7686,14504,14683)
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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='51999' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='51999'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
| SELECT * FROM seoclerks.members WHERE USERID='35786' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='35786'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
| SELECT * FROM seoclerks.members WHERE USERID='17457' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17457'
| /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()
|
