| 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 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 official_blogs as B JOIN categories_official_blog as C ON B.catid=C.CATID WHERE B.status=1 AND C.seo='Blogging' | 1 | SELECT count(B.blogid) AS total
FROM official_blogs as B
JOIN categories_official_blog as C ON B.catid=C.CATID
WHERE B.status=1 AND C.seo='Blogging'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
|
| 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 C.seo='Blogging' ORDER BY B.sticky desc, B.date_created desc LIMIT 40, 40 | 1 | SELECT B.userid, B.username, B.title, B.seo, B.catid, B.content,
B.tags, B.total_comments, B.date_created, B.combined_votes,
B.sticky, B.badges, B.blogid, B.image_id, A.s, A.fname
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 C.seo='Blogging'
ORDER BY B.sticky desc, B.date_created desc
LIMIT 40, 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 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()
|
