| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='mandy' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='mandy' AND status='1'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()
|
| SELECT * FROM answers WHERE userid=128000 | 1 | SELECT distinct quesid FROM answers WHERE userid=128000
| /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 (10342,10487,10735,10736,10737,10743,10744,10745,10746,11099,11162,11163,11174,11292,11357,11358,11376,11399,11411,11691,11708,12085,12092,12109,12110,12111,12674,12675,12676,12678,12679,12682,12683,12686,12687,12690,12691,12696,12710,12798,12799,12802,12803,12859,12860,12861,12862,12867,12881,12888,12889,12893,12898,12900,12923,12930,12952,12953,12955,13034,13073,13090,13091,13491,13513,13528,13530,13531,13532,13609,14247,14289,14293,14507,14514,14516,14517,15331,16026,16030,16032,16034,16035,16157,17272) 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 (10342,10487,10735,10736,10737,10743,10744,10745,10746,11099,11162,11163,11174,11292,11357,11358,11376,11399,11411,11691,11708,12085,12092,12109,12110,12111,12674,12675,12676,12678,12679,12682,12683,12686,12687,12690,12691,12696,12710,12798,12799,12802,12803,12859,12860,12861,12862,12867,12881,12888,12889,12893,12898,12900,12923,12930,12952,12953,12955,13034,13073,13090,13091,13491,13513,13528,13530,13531,13532,13609,14247,14289,14293,14507,14514,14516,14517,15331,16026,16030,16032,16034,16035,16157,17272) 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 (10342,10487,10735,10736,10737,10743,10744,10745,10746,11099,11162,11163,11174,11292,11357,11358,11376,11399,11411,11691,11708,12085,12092,12109,12110,12111,12674,12675,12676,12678,12679,12682,12683,12686,12687,12690,12691,12696,12710,12798,12799,12802,12803,12859,12860,12861,12862,12867,12881,12888,12889,12893,12898,12900,12923,12930,12952,12953,12955,13034,13073,13090,13091,13491,13513,13528,13530,13531,13532,13609,14247,14289,14293,14507,14514,14516,14517,15331,16026,16030,16032,16034,16035,16157,17272) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 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 (10342,10487,10735,10736,10737,10743,10744,10745,10746,11099,11162,11163,11174,11292,11357,11358,11376,11399,11411,11691,11708,12085,12092,12109,12110,12111,12674,12675,12676,12678,12679,12682,12683,12686,12687,12690,12691,12696,12710,12798,12799,12802,12803,12859,12860,12861,12862,12867,12881,12888,12889,12893,12898,12900,12923,12930,12952,12953,12955,13034,13073,13090,13091,13491,13513,13528,13530,13531,13532,13609,14247,14289,14293,14507,14514,14516,14517,15331,16026,16030,16032,16034,16035,16157,17272)
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 80, 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='3' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
| SELECT * FROM seoclerks.members WHERE USERID='49771' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='49771'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
| SELECT * FROM seoclerks.members WHERE USERID='4022' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4022'
| /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()
|