| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=423361 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=423361
| /opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()
|
| SELECT * FROM categories | 1 | SELECT * FROM categories
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
|
| SELECT * FROM seoclerks.members WHERE USERID='436125' | 1 | SELECT * FROM seoclerks.members WHERE USERID='436125'
| /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
|
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='423361' AND A.RATER=B.USERID | 1 | SELECT COUNT(A.RID) as total,
SUM(bad) as badTotal,
SUM(good) as goodTotal
FROM
ratings A,
seoclerks.members B
WHERE A.PID='423361'
AND A.RATER=B.USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM portfolio WHERE PID='423361' ORDER BY id ASC LIMIT 10 | 1 | SELECT
*
FROM
portfolio
WHERE PID='423361'
ORDER BY id ASC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| SELECT * FROM orders WHERE PID='423361' AND status in (1, 4, 6) | 1 | SELECT
OID,
stime,
extradays1,
extradays2,
extradays3,
extra1ordered,
extra2ordered,
extra3ordered,
days,
status,
quantity,
extras_data
FROM
orders
WHERE PID='423361'
AND status in (1, 4, 6)
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| UPDATE posts SET viewcount = viewcount + 1 WHERE PID='423361' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='423361'
| /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()
|
| SELECT * FROM seoclerks.ratings WHERE USERID='436125' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='436125' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM codeclerks.ratings WHERE USERID='436125' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='436125' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM listingdock.ratings WHERE USERID='436125' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='436125' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM pixelclerks.ratings WHERE USERID='436125' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='436125' AND PID != 0
| /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
|
| SELECT * FROM wordclerks.ratings WHERE USERID='436125' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='436125' 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()
|
| SELECT * FROM categories WHERE parentid = 0 | 1 | SELECT *
FROM categories
WHERE parentid = 0
| /opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()
|
| SELECT * FROM seoclerks.members WHERE USERID=? | 1 | SELECT usergroup
FROM seoclerks.members
WHERE USERID=?
| /opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()
|
ear beloved customer, im so sorry we will not online for 1 week later, cause we have offline business, we will not close this gig, we will not offline forever, we only offline for 1 week later, and about pending order, dont worry we ll still deliver yours with xtra ordinary bonus for 14 days. and about your current service, if you want to renew em, do it after 1 week, dont worry we will not shutdown your service. thank you for your patience.
