| 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 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_theme WHERE seo=? | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_theme WHERE seo=?
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategoryInfoFromTypeSeo()
|
| SELECT * FROM categories_theme WHERE parentid=2 | 1 | SELECT CATID FROM categories_theme WHERE parentid=2
| /opt/clerks-staging/docroot/include/functions/main.php 6366 GetCategoryChildString() ()
|
| SELECT * FROM categories_theme WHERE parentid=2 ORDER BY total_items DESC LIMIT 8 | 1 | SELECT
name,
image_name,
seo,
h2header,
metatitle
FROM categories_theme
WHERE parentid=2
ORDER BY total_items DESC
LIMIT 8
| /opt/clerks-staging/docroot/include/functions/main.php 6426 GetCategoryChild() ()
|
| SELECT * FROM categories_theme WHERE CATID='1' | 1 | SELECT CATID, seo, name, h2header, metatitle, metakeywords, metadescription, metaheader, image_name FROM categories_theme WHERE CATID='1'
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
|
| 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 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 | 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 categories WHERE parentid = 0 | 1 | SELECT *
FROM categories
WHERE parentid = 0
| /opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()
|
