| 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() ()
|
| INSERT INTO search_stats (term, count) VALUES ('digital strategy', 1) ON DUPLICATE KEY UPDATE count=count+1 | 1 | INSERT INTO search_stats (term, count) VALUES ('digital strategy', 1) ON DUPLICATE KEY UPDATE count=count+1
| /opt/clerks-staging/docroot/include/functions/main.php 6521 InsertSearchTerm() ()
|
| 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 A.USERID=C.USERID AND A.USERID=C.USERID AND type !=99 AND ((A.gtitle like '%digital%' and gtitle like'%strategy%') OR (C.username like 'digital%' and C.USERNAME like'strategy%')) | 1 | SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND A.USERID=C.USERID AND type !=99 AND
((A.gtitle like '%digital%' and gtitle like'%strategy%')
OR (C.username like 'digital%' and C.USERNAME like'strategy%'))
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() queryCache()
|
| INSERT INTO query_cache ( `query`, `value`, `request_count`, `last_checked`, `time_added` ) VALUES (?, ?, 1, UNIX_TIMESTAMP(NOW()), UNIX_TIMESTAMP(NOW())) | 1 | INSERT INTO query_cache
(
`query`, `value`, `request_count`, `last_checked`, `time_added`
)
VALUES (?, ?, 1, UNIX_TIMESTAMP(NOW()), UNIX_TIMESTAMP(NOW()))
| /opt/clerks-staging/docroot/include/functions/includes/cache.php 316 queryCache() ()
|
| SELECT * from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND type !=99 AND ((A.gtitle like '%digital%' and gtitle like'%strategy%') OR (C.username like 'digital%' and C.USERNAME like'strategy%')) AND (A.feat=0 OR 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 type !=99 AND
((A.gtitle like '%digital%' and gtitle like'%strategy%')
OR (C.username like 'digital%' and C.USERNAME like'strategy%')) AND (A.feat=0 OR 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 type !=99 AND ((A.gtitle like '%digital%' and gtitle like'%strategy%') OR (C.username like 'digital%' and C.USERNAME like'strategy%')) AND A.feat=1 AND A.catfeatured_upgrade=0 | 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 type !=99 AND
((A.gtitle like '%digital%' and gtitle like'%strategy%')
OR (C.username like 'digital%' and C.USERNAME like'strategy%')) AND A.feat=1 AND A.catfeatured_upgrade=0
| /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()
|
