S2Framework Debug Console

Database Queries (9)

1. SET SQL_BIG_SELECTS=1
2. SHOW TABLES LIKE '%_jreviews_config'
3. SELECT value FROM j25_jreviews_config WHERE id = 'cms_secret'
4. SELECT name FROM j25_jreviews_addons WHERE state = 1 ORDER BY ordering
5. SELECT params FROM j25_community_config WHERE name = 'config'
6. SELECT COUNT(*) FROM j25_jreviews_reviewer_ranks
7. SELECT User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.block AS `User.block`, ReviewerRank.reviews AS `Review.count`, ReviewerRank.votes_percent_helpful AS `Vote.helpful`, ReviewerRank.votes_total AS `Vote.count` FROM j25_users AS User INNER JOIN j25_jreviews_reviewer_ranks AS ReviewerRank ON ReviewerRank.user_id = User.id ORDER BY ReviewerRank.`rank` LIMIT 630,10
8. SELECT Community.userid AS `Community.user_id`, Community.userid AS `Community.community_user_id`, Community.userid AS `User.user_id`, Community.avatar AS `Community.avatar`, Community.thumb AS `Community.avatar_thumb`, Community.storage AS `Community.storage`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block` FROM j25_community_users AS Community LEFT JOIN j25_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (39490,39471,24218,20536,13282,32741,8678,3869,524,34405) )
9. SELECT field.name, field.fieldcode, value.value, value.access, value.user_id FROM j25_community_fields AS field INNER JOIN j25_community_fields_values AS value ON field.id = value.field_id AND value.user_id IN (524,3869,8678,13282,20536,24218,32741,34405,39471,39490) WHERE field.published = 1 AND field.visible >= 1