I have a blog created using Blogger platform. I am using Sora Template . Th...
I want a AIA file made for kodular. I will give you the mail and password y...
I have a simple news blog . Created on blogspot platform. I want to change ...
I have a PHP website with 5 pages. It uses one main CSS , stylesheet. The w...
Let me explain what I want I have a PHP page with few images and few texts....
I want a simple TRUE or FALSE game. The game will be Timer-based. How many ...
I want an HTML js PHP page where will be two columns shown. The user has to...
I want an HTML js PHP page where will be two columns shown. The user has to...
I have a MySQL Database with theses five columns 1. Unique ID 2. Name 3. Ex...
I want a one-page PHP code where no MySQL needed . Just the page where ther...
I have an Age calculator web page. It has HTML, CSS and JS codes in differe...
As you can see my blog posts have a specific look. They are Boxed. I want t...
I have purchased an android sticker app code from code canyon. I want someo...
I have a simple android app . I want to publish it to Google plystore . I h...
I have a website http: jcbnsm.com The website is live . No issue . But when...
Hello, I have a small PHP based webpage. The page has nothing but a Databas...
I have an App . complete and Ready to Publish , I want someone to publish t...
I need a Simple age calculator with the following DOB : DATE: Current date ...
I need a php html hit counter for my web page . I need a php html hit count...
I want 2 Java Script code 1. Simple Hit counter for my html page 2. Good lo...
I will provide everything , Logo , Screen Shots , Banner , App Details , Co...
Hi , I want a HTML Javascript code for my website like this I have a image ...
I want a java Script Code for this if the Date is between 01 11 2017 to 30 ...
All Info Given according . I need a Javscript form. Kindly see the image be...
I want a java script html form where the users have to input date of birth ...
Hello, I have a MySql database with category and news list. Now I want a Ph...
I have a web page connected to the mySQL database. Now I want to show all D...
I have some text files written inside HTML codes. This is a mobile web page...
I want a simple javascript code: the details are following on a page, there...
Hello , I want a scanned copy of Bangladeshi calendar of Bengali Months Rem...
Hello I want a very simple Java Script code . Here is the details Input Box...
I have 2 Ready apps , Both are Live wallpaper app . I want someone to Publi...
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='nadiaonline' AND status='1' | 1 | SELECT *
FROM seoclerks.members
WHERE username='nadiaonline'
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='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}' WHERE USERID='488757' | 1 | UPDATE seoclerks.members
SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}'
WHERE USERID='488757' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE codeclerks.members SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}' WHERE USERID='488757' | 1 | UPDATE codeclerks.members
SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}'
WHERE USERID='488757' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE listingdock.members SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}' WHERE USERID='488757' | 1 | UPDATE listingdock.members
SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}'
WHERE USERID='488757' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE pixelclerks.members SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}' WHERE USERID='488757' | 1 | UPDATE pixelclerks.members
SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}'
WHERE USERID='488757' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| UPDATE wordclerks.members SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}' WHERE USERID='488757' | 1 | UPDATE wordclerks.members
SET profile_data='{\"themeUni\":1,\"pic\":\"488757.png\",\"userRatingUpdated\":1686305389,\"userLevelUpdated\":1625304466,\"userTypeUpdated\":1772564622,\"userType\":{\"main\":\"seller\",\"0\":\"seller\",\"1\":\"buyer\"}}'
WHERE USERID='488757' | /opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData() |
| SELECT * FROM seoclerks.members WHERE USERID='488757' | 1 | SELECT lastlogin FROM seoclerks.members WHERE USERID='488757' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetUserLastLoginDays() |
| SELECT * FROM posts WHERE USERID=488757 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=488757 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| SELECT * FROM follow F, members M WHERE F.FOLLOWING=488757 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=488757
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=488757 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=488757
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=488757 | 1 | SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=488757 | /opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() () |
| SELECT * FROM follow WHERE USERID=488757 | 1 | SELECT COUNT(FID) AS total FROM follow WHERE USERID=488757 | /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='76062' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='76062' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Programming' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Programming' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='75345' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='75345' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='74128' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74128' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='73136' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='73136' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='72652' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72652' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='72576' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72576' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='72356' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72356' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='72355' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72355' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='72316' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72316' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='72003' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='72003' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='71868' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71868' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='71225' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='71225' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='70962' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='70962' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='69907' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='69907' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='68842' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='68842' | /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='59730' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='59730' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='58156' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='58156' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM categories_wanttotrade WHERE seo='Buy-Forum-Posts' | 1 | SELECT name FROM categories_wanttotrade WHERE seo='Buy-Forum-Posts' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='57473' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57473' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='57455' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57455' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='57334' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='57334' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='56683' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56683' | /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='56657' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='56657' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='55702' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55702' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='55674' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55674' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='55381' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='55381' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='54612' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54612' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='54055' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='54055' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='53682' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='53682' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='52946' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52946' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='52887' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='52887' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='51992' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='51992' | /opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData() |
| SELECT * FROM wantbids WHERE active=1 AND wantid='44245' | 1 | SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='44245' | /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='488757' 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='488757'
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='488757' 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='488757'
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='488757' 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='488757'
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='488757' 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='488757'
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='488757' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='488757' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM codeclerks.ratings WHERE USERID='488757' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='488757' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM listingdock.ratings WHERE USERID='488757' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='488757' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM pixelclerks.ratings WHERE USERID='488757' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='488757' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM wordclerks.ratings WHERE USERID='488757' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='488757' 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 |