| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='tanjina' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='tanjina' AND status='1'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()
|
| SELECT * FROM answers WHERE userid=42499 | 1 | SELECT distinct quesid FROM answers WHERE userid=42499
| /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 (5379,5339,5331,5334,5332,5328,5307,5283,5278,5277,5274,5267,5259,5749,5785,5784,6026,5962,5899,5845,5817,5661,5640,5628,5586,5619,5539,5504,5459,5437,5443,6364,6426,6429,6341,6371,6908,6925,7035,7025,5862,6318,6042,6041,5863,6083,5380,5212,3619,3570,7135,7122,7085,7053,6968,6899,7219,7218,7214,7234,7232,7048,5872,5859,5778,5746,7327,7315,7314,7311,7301,7341,7336,10337,10340,10343,10344,10468,10470,10473,10474,10475,10476,10480,10481,10482,10487,10489,10490,10491,10493,10504,10514,12111) 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 (5379,5339,5331,5334,5332,5328,5307,5283,5278,5277,5274,5267,5259,5749,5785,5784,6026,5962,5899,5845,5817,5661,5640,5628,5586,5619,5539,5504,5459,5437,5443,6364,6426,6429,6341,6371,6908,6925,7035,7025,5862,6318,6042,6041,5863,6083,5380,5212,3619,3570,7135,7122,7085,7053,6968,6899,7219,7218,7214,7234,7232,7048,5872,5859,5778,5746,7327,7315,7314,7311,7301,7341,7336,10337,10340,10343,10344,10468,10470,10473,10474,10475,10476,10480,10481,10482,10487,10489,10490,10491,10493,10504,10514,12111) 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 (5379,5339,5331,5334,5332,5328,5307,5283,5278,5277,5274,5267,5259,5749,5785,5784,6026,5962,5899,5845,5817,5661,5640,5628,5586,5619,5539,5504,5459,5437,5443,6364,6426,6429,6341,6371,6908,6925,7035,7025,5862,6318,6042,6041,5863,6083,5380,5212,3619,3570,7135,7122,7085,7053,6968,6899,7219,7218,7214,7234,7232,7048,5872,5859,5778,5746,7327,7315,7314,7311,7301,7341,7336,10337,10340,10343,10344,10468,10470,10473,10474,10475,10476,10480,10481,10482,10487,10489,10490,10491,10493,10504,10514,12111) 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 (5379,5339,5331,5334,5332,5328,5307,5283,5278,5277,5274,5267,5259,5749,5785,5784,6026,5962,5899,5845,5817,5661,5640,5628,5586,5619,5539,5504,5459,5437,5443,6364,6426,6429,6341,6371,6908,6925,7035,7025,5862,6318,6042,6041,5863,6083,5380,5212,3619,3570,7135,7122,7085,7053,6968,6899,7219,7218,7214,7234,7232,7048,5872,5859,5778,5746,7327,7315,7314,7311,7301,7341,7336,10337,10340,10343,10344,10468,10470,10473,10474,10475,10476,10480,10481,10482,10487,10489,10490,10491,10493,10504,10514,12111)
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='26777' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='26777'
| /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()
|
