SEOClerks

Answers from user clara1993 Page 6

Order Now
Process Time: 0.051342010498047

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM seoclerks.members WHERE username='clara1993' AND status='1'1SELECT 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=5915861SELECT 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 11SELECT 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, 401SELECT 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' 1SELECT 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' 1SELECT 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 1SELECT 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 categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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'1SELECT 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 asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.3346181SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.3346180.334618