| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='staging' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='staging' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| SELECT * FROM categories WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories WHERE seo=? | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo() |
| SELECT * FROM categories WHERE parentid=37 | 1 | SELECT CATID FROM categories WHERE parentid=37 | /opt/clerks-staging/docroot/include/functions/main.php 6366 GetCategoryChildString() () |
| SELECT * FROM categories WHERE parentid=37 ORDER BY total_items DESC LIMIT 8 | 1 | SELECT
name,
image_name,
seo,
h2header,
metatitle
FROM categories
WHERE parentid=37
ORDER BY total_items DESC
LIMIT 8 | /opt/clerks-staging/docroot/include/functions/main.php 6426 GetCategoryChild() () |
| SELECT * FROM query_cache WHERE query= ? LIMIT 1 | 1 | SELECT `value`, `last_checked`
FROM query_cache
WHERE query= ?
LIMIT 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() queryCache() |
| SELECT * from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (37) AND gtags like'%boots%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40 | 1 | SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (37) AND gtags like'%boots%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (37) AND gtags like'%boots%' AND type !=99 AND A.feat=1 | 1 | SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (37) AND gtags like'%boots%' AND type !=99 AND A.feat=1 | /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 promotions as p WHERE p.date_expire > UNIX_TIMESTAMP(NOW()) AND p.date_added < UNIX_TIMESTAMP(NOW()) ORDER BY p.date_added DESC | 1 | SELECT p.*
FROM promotions as p
WHERE p.date_expire > UNIX_TIMESTAMP(NOW())
AND p.date_added < UNIX_TIMESTAMP(NOW())
ORDER BY p.date_added DESC
| /opt/clerks-staging/docroot/index.php 2756 () () |
| 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() |
| 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, 'address Document Reject', 'address Document Rejected', 'a:1:{s:4:"lang";s:0:"";}', '', 'cronAIAnalyzeMemDocs.php', '', '', 'Subject: Your address document "" was rejected on Body: Hi We are sorry to inform you that your address verification document has been rejected. Please review the reason for rejection below and resubmit at https://rtest.seoclerks.com/settings/files/address. Reason for rejection: The address document you uploaded is more than 3 months old or not a valid address document. Please upload a valid address document that is within the last 3 months.', 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, 'address Document Reject', 'address Document Rejected', 'a:1:{s:4:"lang...' at line 2 rtest.seoclerks.comcronAIAnalyzeMemDocs.php |
| Load | Count | SQL | Max | Min |
