SEOClerks

Answers from user alimalik87 Page 2

Order Now
Process Time: 0.04862380027771

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM seoclerks.members WHERE username='alimalik87' AND status='1'1SELECT USERID FROM seoclerks.members WHERE username='alimalik87' AND status='1'

/opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() ()

SELECT * FROM answers WHERE userid=125441SELECT distinct quesid FROM answers WHERE userid=12544

/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 (1598,1599,1603,1591,1585,1185,1184,1179,1181,1178,1176,1173,1171,1671,1880,1883,1919,1142,1817,1962,2501,2518,2695,2778,2775,2757,2749,2781,2753,2752,2009,2106,1105,1616,2774,2507,2785,2771,2820,2807,3281,3293,3294,3842,4096,10447,10470,10478) 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 (1598,1599,1603,1591,1585,1185,1184,1179,1181,1178,1176,1173,1171,1671,1880,1883,1919,1142,1817,1962,2501,2518,2695,2778,2775,2757,2749,2781,2753,2752,2009,2106,1105,1616,2774,2507,2785,2771,2820,2807,3281,3293,3294,3842,4096,10447,10470,10478) 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 (1598,1599,1603,1591,1585,1185,1184,1179,1181,1178,1176,1173,1171,1671,1880,1883,1919,1142,1817,1962,2501,2518,2695,2778,2775,2757,2749,2781,2753,2752,2009,2106,1105,1616,2774,2507,2785,2771,2820,2807,3281,3293,3294,3842,4096,10447,10470,10478) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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 (1598,1599,1603,1591,1585,1185,1184,1179,1181,1178,1176,1173,1171,1671,1880,1883,1919,1142,1817,1962,2501,2518,2695,2778,2775,2757,2749,2781,2753,2752,2009,2106,1105,1616,2774,2507,2785,2771,2820,2807,3281,3293,3294,3842,4096,10447,10470,10478) ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 40, 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='14337'1SELECT profilepicture FROM seoclerks.members WHERE USERID='14337'

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

SELECT * FROM seoclerks.members WHERE USERID='6509'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6509'

/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