| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400
| /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
|
| SELECT * FROM official_blogs as b, categories_official_blog as c, members_attachments as a WHERE b.status=1 AND b.catid=c.CATID AND a.MAID=b.image_id AND b.blogid='27093' | 1 | SELECT b.*, c.seo as CatSEO, c.name as CatName, c.parentid, a.s, a.fname, b.combined_votes
FROM official_blogs as b,
categories_official_blog as c,
members_attachments as a
WHERE b.status=1
AND b.catid=c.CATID
AND a.MAID=b.image_id
AND b.blogid='27093'
| /opt/clerks-staging/docroot/viewblog.php 31 () ()
|
| SELECT * FROM official_blogs as b, categories_official_blog as c, members_attachments as a WHERE b.blogid > '27093' AND b.status=1 AND b.catid=c.CATID AND a.MAID=b.image_id ORDER BY b.blogid ASC LIMIT 1 ) | 1 | SELECT blogid, seo
FROM official_blogs
WHERE blogid=(
SELECT blogid
FROM official_blogs as b,
categories_official_blog as c,
members_attachments as a
WHERE b.blogid > '27093'
AND b.status=1
AND b.catid=c.CATID
AND a.MAID=b.image_id
ORDER BY b.blogid ASC
LIMIT 1
)
| /opt/clerks-staging/docroot/viewblog.php 136 () ()
|
| SELECT * FROM official_blogs as b, categories_official_blog as c, members_attachments as a WHERE b.blogid < '27093' AND b.status=1 AND b.catid=c.CATID AND a.MAID=b.image_id ORDER BY b.blogid DESC LIMIT 1 ) | 1 | SELECT blogid, seo
FROM official_blogs
WHERE blogid=(
SELECT blogid
FROM official_blogs as b,
categories_official_blog as c,
members_attachments as a
WHERE b.blogid < '27093'
AND b.status=1
AND b.catid=c.CATID
AND a.MAID=b.image_id
ORDER BY b.blogid DESC
LIMIT 1
)
| /opt/clerks-staging/docroot/viewblog.php 154 () ()
|
| SELECT * FROM official_blogs as b, categories_official_blog as c, members_attachments as a WHERE b.blogid!='27093' AND b.status='1' AND a.MAID=b.image_id AND (b.title like '%Great Moms Deserve Great Deals!%' OR b.title like '%Great%' OR b.title like '%Moms%' OR b.title like '%Deserve%' OR b.title like '%Great%' OR b.title like '%Deals!%') GROUP BY b.blogid LIMIT 15 | 1 | SELECT b.blogid, b.title, b.seo, b.userid, a.s, a.fname
FROM official_blogs as b,
categories_official_blog as c,
members_attachments as a
WHERE b.blogid!='27093'
AND b.status='1'
AND a.MAID=b.image_id
AND (b.title like '%Great Moms Deserve Great Deals!%' OR b.title like '%Great%' OR b.title like '%Moms%' OR b.title like '%Deserve%' OR b.title like '%Great%' OR b.title like '%Deals!%')
GROUP BY b.blogid
LIMIT 15
| /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 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 seoclerks.members WHERE USERID='17' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
|
