| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=911251 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=911251 | /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='510982' | 1 | SELECT * FROM seoclerks.members WHERE USERID='510982' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='911251' 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='911251'
AND A.RATER=B.USERID | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM portfolio WHERE PID='911251' ORDER BY id ASC LIMIT 10 | 1 | SELECT
*
FROM
portfolio
WHERE PID='911251'
ORDER BY id ASC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM orders WHERE PID='911251' 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='911251'
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='911251' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='911251' | /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() () |
| SELECT * FROM seoclerks.ratings WHERE USERID='510982' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='510982' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM codeclerks.ratings WHERE USERID='510982' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='510982' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM listingdock.ratings WHERE USERID='510982' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='510982' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM pixelclerks.ratings WHERE USERID='510982' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='510982' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM wordclerks.ratings WHERE USERID='510982' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='510982' 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() |
| count(*) | sql1 | error_msg |
|---|---|---|
| 1 | INSERT INTO seoclerks.moderator_log (dateline, USERID, editid, type, actiontext, postdata, ipaddress, script, querystring, agent, reason, front_end_mod)
VALUES (UNIX_TIMESTAMP(NOW()), , 4, 'identity Document Reject', 'identity Document Rejected', 'a:1:{s:4:"lang";s:0:"";}', '', 'cronAIAnalyzeMemDocs.php', '', '', 'Subject: Your identity document "" was rejected on Body: Hi We are sorry to inform you that your identification document has been rejected. Please review the reason for rejection below and resubmit at https://rtest.seoclerks.com/settings/files/identity. Reason for rejection: Invalid 'input[0].content[1].image_url'. Expected a base64-encoded data URL with an image MIME type (e.g. 'data:image/png;base64,aW1nIGJ5dGVzIGhlcmU='), but got empty base64-encoded bytes.', 1) |
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 4, 'identity Document Reject', 'identity Document Rejected', 'a:1:{s:4:"lan...' at line 2 rtest.seoclerks.comcronAIAnalyzeMemDocs.php |
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
