need website design service - ads posting website can you help me for it. s...
Hello i need Bulk shared hosting different IPs . i have 10 domains just nee...
Hello i need php custom holiday script to install in my website. please sha...
Hello i need wordpress real state theme or plugin so can u help me for it g...
hello i want travel affiliate website so can u make for me. please give me ...
Hello every one... i need Logo Design person for long time... and now i nee...
Hello every one i need twitter foloower 2500 ... can u give me ?? no more b...
i need easy video maker software or other mp4 video maker software i need e...
i need easy video maker software or other mp4 video maker software i need e...
i have already purchased whm account so now need my WHM account migrate to ...
Hello i need USA freelancer worker for some work like backlinks, blog posti...
Hello i need video maker best software.. can u give me so please give me vi...
Hello can u help me for instant 500 backlinks Dofillow good backlinks Do-Fo...
Hello i need Twitter flowers 3000 non drop down so can u help me... give me...
i need wordpress membership plug in can u give me wordpress membership regi...
Hello i need 200 Dentists records sheet Including name, email, website, con...
Hello i need promotional video maker software or other. can you give me pro...
need instructional videos for advertising on youtube. I don t have any text...
hello i need my website on google 1st or 2nd page so can you help me choose...
I have two email accounts that I received CVs and Resumes , Certificates . ...
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='fivewebsol' AND status='1' | 1 | SELECT *
FROM seoclerks.members
WHERE username='fivewebsol'
AND status='1'
| /opt/clerks-staging/docroot/user.php 54 () () |
| SELECT * FROM seoclerks.orders WHERE seller_USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE seller_USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() () |
| SELECT * FROM seoclerks.orders WHERE affiliateUserId = ? | 1 | SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE affiliateUserId = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() () |
| SELECT * FROM seoclerks.orders WHERE USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() () |
| SELECT * FROM codeclerks.orders WHERE seller_USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE seller_USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() () |
| SELECT * FROM codeclerks.orders WHERE affiliateUserId = ? | 1 | SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE affiliateUserId = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() () |
| SELECT * FROM codeclerks.orders WHERE USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() () |
| SELECT * FROM listingdock.orders WHERE seller_USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE seller_USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() () |
| SELECT * FROM listingdock.orders WHERE affiliateUserId = ? | 1 | SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE affiliateUserId = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() () |
| SELECT * FROM listingdock.orders WHERE USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() () |
| SELECT * FROM pixelclerks.orders WHERE seller_USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE seller_USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() () |
| SELECT * FROM pixelclerks.orders WHERE affiliateUserId = ? | 1 | SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE affiliateUserId = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() () |
| SELECT * FROM pixelclerks.orders WHERE USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() () |
| SELECT * FROM wordclerks.orders WHERE seller_USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE seller_USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() () |
| SELECT * FROM wordclerks.orders WHERE affiliateUserId = ? | 1 | SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE affiliateUserId = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() () |
| SELECT * FROM wordclerks.orders WHERE USERID = ? | 1 | SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE USERID = ? | /opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() () |
| UPDATE seoclerks.members SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}' WHERE USERID='121253' | 1 | UPDATE seoclerks.members
SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}'
WHERE USERID='121253' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE codeclerks.members SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}' WHERE USERID='121253' | 1 | UPDATE codeclerks.members
SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}'
WHERE USERID='121253' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE listingdock.members SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}' WHERE USERID='121253' | 1 | UPDATE listingdock.members
SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}'
WHERE USERID='121253' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE pixelclerks.members SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}' WHERE USERID='121253' | 1 | UPDATE pixelclerks.members
SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}'
WHERE USERID='121253' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE wordclerks.members SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}' WHERE USERID='121253' | 1 | UPDATE wordclerks.members
SET profile_data='{\"advanced_editor\":1,\"themeUni\":0,\"userRatingUpdated\":1686305378,\"userLevelUpdated\":1625304360,\"workFrom\":\"1:00 AM\",\"workTo\":\"12:51 PM\",\"userBoostLoginUpdated\":1614874004,\"userTypeUpdated\":1772665288,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"affiliate\",\"2\":\"buyer\"}}'
WHERE USERID='121253' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| SELECT * FROM seoclerks.members WHERE USERID='121253' | 1 | SELECT lastlogin FROM seoclerks.members WHERE USERID='121253' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetUserLastLoginDays() |
| SELECT * FROM posts WHERE USERID=121253 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=121253 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| SELECT * FROM follow F, members M WHERE F.FOLLOWING=121253 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4 | 1 | SELECT F.USERID,
M.profilepicture,
M.username,
M.userlevel,
M.status
FROM follow F, members M
WHERE F.FOLLOWING=121253
AND F.USERID = M.USERID
ORDER BY F.time_added
DESC LIMIT 4 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower() |
| SELECT * FROM follow F, members M WHERE F.USERID=121253 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4 | 1 | SELECT F.FOLLOWING AS USERID,
M.profilepicture,
M.username,
M.userlevel,
M.status
FROM follow F, members M
WHERE F.USERID=121253
AND F.FOLLOWING = M.USERID
ORDER BY F.time_added
DESC LIMIT 4 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower() |
| SELECT * FROM follow WHERE FOLLOWING=121253 | 1 | SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=121253 | /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() () |
| SELECT * FROM follow WHERE USERID=121253 | 1 | SELECT COUNT(FID) AS total FROM follow WHERE USERID=121253 | /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() () |
| SELECT * FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99 | 1 | SELECT
count(A.PID) AS total
FROM
posts A,
seoclerks.members C
WHERE A.active = '1'
AND A.USERID = C.USERID
AND A.USERID = ?
AND A.type != 99
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 | 1 | SELECT
A.*,
C.userlevel,
C.username,
C.ip,
C.lip,
C.profilepicture
FROM
posts A,
seoclerks.members C
WHERE A.active = 1
AND A.type != 99
AND A.USERID = C.USERID
AND A.USERID = ?
ORDER BY lastgigedit DESC
LIMIT 0, 40
| /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 wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? | 1 | SELECT
count(A.wantid) AS total
FROM
wanttobuy A,
seoclerks.members C
WHERE A.active = 1
AND A.USERID = C.USERID
AND A.USERID = ?
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 | 1 | SELECT
A.*,
C.userlevel,
C.username,
C.ip,
C.lip,
D.seo
FROM
wanttobuy A,
seoclerks.members C,
categories_wanttobuy D
WHERE A.active = 1
AND A.USERID = C.USERID
AND D.CATID = A.category
AND A.USERID = ?
ORDER BY lastgigedit DESC
LIMIT 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wantbids WHERE active=1 AND wantid='64729' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='64729' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='design' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='design' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='63355' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='63355' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='shared-webhosting' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='shared-webhosting' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='62753' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62753' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='62663' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62663' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='59753' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59753' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='56762' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56762' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='56732' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56732' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Social-Networks' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Social-Networks' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='55570' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55570' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='video' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='video' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='55569' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55569' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='54951' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54951' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Other' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Other' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='53144' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53144' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Link-Building' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Link-Building' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='53019' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53019' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='52510' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52510' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Social-Bookmarks' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Social-Bookmarks' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='52216' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52216' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='51782' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51782' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='51263' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51263' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Data-Entry' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Data-Entry' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='50342' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='50342' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='49117' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='49117' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='47440' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47440' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='SEO-Reports' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='SEO-Reports' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='47404' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='47404' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC | 1 | SELECT
count(A.tradeid) AS total
FROM
wanttotrade A,
seoclerks.members C
WHERE A.active = 1
AND A.USERID = C.USERID
AND A.USERID = ?
ORDER BY A.tradeid DESC | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40 | 1 | SELECT
A.*,
C.userlevel,
C.username,
C.ip,
C.lip,
D.seo
FROM
wanttotrade A,
seoclerks.members C,
categories_wanttotrade D
WHERE A.active = '1'
AND A.USERID = C.USERID
AND D.CATID = A.category
AND A.USERID = ?
ORDER BY lastgigedit DESC
LIMIT 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='121253' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
codeclerks.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='121253'
ORDER BY A.lastgigedit DESC
LIMIT 10 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='121253' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
listingdock.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='121253'
ORDER BY A.lastgigedit DESC
LIMIT 10 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='121253' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
pixelclerks.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='121253'
ORDER BY A.lastgigedit DESC
LIMIT 10 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='121253' ORDER BY A.lastgigedit DESC LIMIT 10 | 1 | SELECT
A.*, C.userlevel,
C.username,
C.ip,
C.lip,
A.lastgigedit
FROM
wordclerks.posts A,
seoclerks.members C
WHERE A.active='1'
AND A.type!=99
AND A.USERID=C.USERID
AND A.USERID='121253'
ORDER BY A.lastgigedit DESC
LIMIT 10 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1 | 1 | SELECT time
FROM inbox2
WHERE MSGFROM = ?
AND action = 'delivery'
ORDER BY time
DESC LIMIT 1 | /opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() () |
| SELECT * FROM seoclerks.ratings WHERE USERID='121253' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='121253' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM codeclerks.ratings WHERE USERID='121253' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='121253' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM listingdock.ratings WHERE USERID='121253' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='121253' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM pixelclerks.ratings WHERE USERID='121253' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='121253' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM wordclerks.ratings WHERE USERID='121253' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='121253' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| 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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
| 0.189295 | 1 | SELECT 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.189295 | 0.189295 |
