SEOClerks

Clear
Sign In Join

Favorite Food

Poll
  • robertman11 Level 2
    • 0

    Write the reason you're deleting this FAQ

    Favorite Food

    I'm trying to figure out the best food. Please select your favorite food below.

    50%
    25%
    25%
    #cool Announcements
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join

    Order Now
    Process Time: 0.035259008407593

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    		/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='32737'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='32737'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='9'1SELECT * FROM seoclerks.members WHERE USERID='9'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM faq_poll WHERE quesid=? 6SELECT COUNT(pollID) as total FROM faq_poll WHERE quesid=?

    SELECT pos FROM faq_poll WHERE quesid=?

    SELECT COUNT(pollID) as total FROM faq_poll WHERE quesid=?

    SELECT pos FROM faq_poll WHERE quesid=?

    SELECT COUNT(pollID) as total FROM faq_poll WHERE quesid=?

    SELECT pos FROM faq_poll WHERE quesid=?

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 2590 pollCalculation() ()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2609 pollCalculation() ()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2590 pollCalculation() ()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2609 pollCalculation() ()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2590 pollCalculation() ()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2609 pollCalculation() ()

    SELECT * FROM seoclerks.members WHERE USERID=91SELECT googleplus_profile FROM seoclerks.members WHERE USERID=9

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=32737 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=32737 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='32737' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='32737' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='32737'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='32737'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='32737' AND status='1' AND (question like '%Favorite Food%' OR question like '%Favorite%' OR question like '%Food%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='32737' AND status='1' AND (question like '%Favorite Food%' OR question like '%Favorite%' OR question like '%Food%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='77426' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='77426' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='3764' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3764' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='6623' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='6623' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='390577' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='390577' limit 1

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

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=32737%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=32737%' 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 faq_poll WHERE quesid=? AND USERID=? AND pos=? 6SELECT COUNT(pos) as total FROM faq_poll WHERE quesid=? AND USERID=? AND pos=?

    SELECT COUNT(pos) as total FROM faq_poll WHERE quesid=? AND USERID=? AND pos=?

    SELECT COUNT(pos) as total FROM faq_poll WHERE quesid=? AND USERID=? AND pos=?

    SELECT COUNT(pos) as total FROM faq_poll WHERE quesid=? AND USERID=? AND pos=?

    SELECT COUNT(pos) as total FROM faq_poll WHERE quesid=? AND USERID=? AND pos=?

    SELECT COUNT(pos) as total FROM faq_poll WHERE quesid=? AND USERID=? AND pos=?

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 2660 votedForPoll() include()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2660 votedForPoll() include()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2660 votedForPoll() include()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2660 votedForPoll() include()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2660 votedForPoll() include()

    /opt/clerks-staging/docroot/include/functions/includes/member.php 2660 votedForPoll() include()

    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.3497791SELECT 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.bdays desc LIMIT 0,400.3497790.349779
    0.1989241SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1989240.198924