| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='backpage4u' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='backpage4u' AND status='1'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()
|
| SELECT * FROM answers WHERE userid=22379 | 1 | SELECT distinct quesid FROM answers WHERE userid=22379
| /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 (11409,11410,11418,19850,21392,21459,23712,23689,24009,24567,23211,25065,24637,23039,25293,23526,25331,25329,25290,25649,25364,25970,25962,24879,25887,26282,26232,26283,26148,26177,27581,27578,27563,27660,27891,27858,27983,28545,28539,28521,29913,29886,29951,29938,29931,29994,29992,30099,30097,30333,30331,30329,30313,30392,30389,30388,30016,30519,30517,30509,30563,30559,30556,30639,30626,30621,30607,30605,30692,30690,30686,30733,30777,30772,30771,30766,31233,31231,31560,31552,31559,31624,31766,31765,31758) 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 (11409,11410,11418,19850,21392,21459,23712,23689,24009,24567,23211,25065,24637,23039,25293,23526,25331,25329,25290,25649,25364,25970,25962,24879,25887,26282,26232,26283,26148,26177,27581,27578,27563,27660,27891,27858,27983,28545,28539,28521,29913,29886,29951,29938,29931,29994,29992,30099,30097,30333,30331,30329,30313,30392,30389,30388,30016,30519,30517,30509,30563,30559,30556,30639,30626,30621,30607,30605,30692,30690,30686,30733,30777,30772,30771,30766,31233,31231,31560,31552,31559,31624,31766,31765,31758) 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 (11409,11410,11418,19850,21392,21459,23712,23689,24009,24567,23211,25065,24637,23039,25293,23526,25331,25329,25290,25649,25364,25970,25962,24879,25887,26282,26232,26283,26148,26177,27581,27578,27563,27660,27891,27858,27983,28545,28539,28521,29913,29886,29951,29938,29931,29994,29992,30099,30097,30333,30331,30329,30313,30392,30389,30388,30016,30519,30517,30509,30563,30559,30556,30639,30626,30621,30607,30605,30692,30690,30686,30733,30777,30772,30771,30766,31233,31231,31560,31552,31559,31624,31766,31765,31758) 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 (11409,11410,11418,19850,21392,21459,23712,23689,24009,24567,23211,25065,24637,23039,25293,23526,25331,25329,25290,25649,25364,25970,25962,24879,25887,26282,26232,26283,26148,26177,27581,27578,27563,27660,27891,27858,27983,28545,28539,28521,29913,29886,29951,29938,29931,29994,29992,30099,30097,30333,30331,30329,30313,30392,30389,30388,30016,30519,30517,30509,30563,30559,30556,30639,30626,30621,30607,30605,30692,30690,30686,30733,30777,30772,30771,30766,31233,31231,31560,31552,31559,31624,31766,31765,31758)
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='289505' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='289505'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
| SELECT * FROM seoclerks.members WHERE USERID='147' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
| SELECT * FROM seoclerks.members WHERE USERID='17795' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17795'
| /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()
|