| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='clara1993' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='clara1993' AND status='1'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()
|
| SELECT * FROM answers WHERE userid=591586 | 1 | SELECT distinct quesid FROM answers WHERE userid=591586
| /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 (22882,22890,22901,22899,22884,22897,22895,22877,22883,22734,22835,22920,22871,22865,22852,22868,22885,22862,22881,22863,22914,22919,22880,14302,23182,11093,23189,23186,22583,23207,22584,22291,22172,23250,21879,21886,21655,21633,18088,20100,10399,19827,17527,23261,23230,23280,22269,23259,23233,23012,23272,23036,23305,22806,22303,22562,23304,22933,23006,22930,22916,22700,23295,23322,23296,23310,23213,23248,22923,23222,23014,23037,23243,23337,23152,23242,23324,23241,23046,23120,23355,23255,23175,23025,23138,23234,23024,22995,23027,22950,23538,23509,23714,23654,23629,23591,23545,23774,23775,23773,23409,23677,23610,23781,23752,23807,23821,23621,23799,23645,23820,23801,23643,23607,23655,23592,23556,23498,23421,23359,23386,23840,23448,23404,23287,23269,23148,22436,22276,23867,23866,23788,23786,23687,23608,23597,23351,23432,23394,23338,23894,23895,23888,23891,23837,23732,23897,23847,23902,23908,23883,23632,23688,23680,23653,23547,23524,23523,23376,23916,23144,1186,23939,23928,23930,23080,22839,23240,23346,20947,20059,23940,23934,23194,23922,23846,23816,23546,23465,23947,22864,22746,23948,23495,23449,23726,23841,23415,23345,23944,23491,18521,17471,18231,17480,23951,23336,23942,23890,23622,23813,23879) 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 (22882,22890,22901,22899,22884,22897,22895,22877,22883,22734,22835,22920,22871,22865,22852,22868,22885,22862,22881,22863,22914,22919,22880,14302,23182,11093,23189,23186,22583,23207,22584,22291,22172,23250,21879,21886,21655,21633,18088,20100,10399,19827,17527,23261,23230,23280,22269,23259,23233,23012,23272,23036,23305,22806,22303,22562,23304,22933,23006,22930,22916,22700,23295,23322,23296,23310,23213,23248,22923,23222,23014,23037,23243,23337,23152,23242,23324,23241,23046,23120,23355,23255,23175,23025,23138,23234,23024,22995,23027,22950,23538,23509,23714,23654,23629,23591,23545,23774,23775,23773,23409,23677,23610,23781,23752,23807,23821,23621,23799,23645,23820,23801,23643,23607,23655,23592,23556,23498,23421,23359,23386,23840,23448,23404,23287,23269,23148,22436,22276,23867,23866,23788,23786,23687,23608,23597,23351,23432,23394,23338,23894,23895,23888,23891,23837,23732,23897,23847,23902,23908,23883,23632,23688,23680,23653,23547,23524,23523,23376,23916,23144,1186,23939,23928,23930,23080,22839,23240,23346,20947,20059,23940,23934,23194,23922,23846,23816,23546,23465,23947,22864,22746,23948,23495,23449,23726,23841,23415,23345,23944,23491,18521,17471,18231,17480,23951,23336,23942,23890,23622,23813,23879) 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 (22882,22890,22901,22899,22884,22897,22895,22877,22883,22734,22835,22920,22871,22865,22852,22868,22885,22862,22881,22863,22914,22919,22880,14302,23182,11093,23189,23186,22583,23207,22584,22291,22172,23250,21879,21886,21655,21633,18088,20100,10399,19827,17527,23261,23230,23280,22269,23259,23233,23012,23272,23036,23305,22806,22303,22562,23304,22933,23006,22930,22916,22700,23295,23322,23296,23310,23213,23248,22923,23222,23014,23037,23243,23337,23152,23242,23324,23241,23046,23120,23355,23255,23175,23025,23138,23234,23024,22995,23027,22950,23538,23509,23714,23654,23629,23591,23545,23774,23775,23773,23409,23677,23610,23781,23752,23807,23821,23621,23799,23645,23820,23801,23643,23607,23655,23592,23556,23498,23421,23359,23386,23840,23448,23404,23287,23269,23148,22436,22276,23867,23866,23788,23786,23687,23608,23597,23351,23432,23394,23338,23894,23895,23888,23891,23837,23732,23897,23847,23902,23908,23883,23632,23688,23680,23653,23547,23524,23523,23376,23916,23144,1186,23939,23928,23930,23080,22839,23240,23346,20947,20059,23940,23934,23194,23922,23846,23816,23546,23465,23947,22864,22746,23948,23495,23449,23726,23841,23415,23345,23944,23491,18521,17471,18231,17480,23951,23336,23942,23890,23622,23813,23879) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 200, 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 (22882,22890,22901,22899,22884,22897,22895,22877,22883,22734,22835,22920,22871,22865,22852,22868,22885,22862,22881,22863,22914,22919,22880,14302,23182,11093,23189,23186,22583,23207,22584,22291,22172,23250,21879,21886,21655,21633,18088,20100,10399,19827,17527,23261,23230,23280,22269,23259,23233,23012,23272,23036,23305,22806,22303,22562,23304,22933,23006,22930,22916,22700,23295,23322,23296,23310,23213,23248,22923,23222,23014,23037,23243,23337,23152,23242,23324,23241,23046,23120,23355,23255,23175,23025,23138,23234,23024,22995,23027,22950,23538,23509,23714,23654,23629,23591,23545,23774,23775,23773,23409,23677,23610,23781,23752,23807,23821,23621,23799,23645,23820,23801,23643,23607,23655,23592,23556,23498,23421,23359,23386,23840,23448,23404,23287,23269,23148,22436,22276,23867,23866,23788,23786,23687,23608,23597,23351,23432,23394,23338,23894,23895,23888,23891,23837,23732,23897,23847,23902,23908,23883,23632,23688,23680,23653,23547,23524,23523,23376,23916,23144,1186,23939,23928,23930,23080,22839,23240,23346,20947,20059,23940,23934,23194,23922,23846,23816,23546,23465,23947,22864,22746,23948,23495,23449,23726,23841,23415,23345,23944,23491,18521,17471,18231,17480,23951,23336,23942,23890,23622,23813,23879)
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 200, 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='10194' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='10194'
| /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()
|