S2Framework Debug Console

Database Queries (17)

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 Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `Review.user_id`, User.id AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, User.block AS `User.block`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, ReviewerRank.`rank` AS `User.reviewer_rank`, ReviewerRank.reviews AS `User.review_count`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, IF(Review.rating=0,"na",Review.rating) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*Review.vote_helpful AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved`, Review.owner_reply_created AS `Review.owner_reply_created`, Review.media_count AS `Review.media_count`, Review.video_count AS `Review.video_count`, Review.photo_count AS `Review.photo_count`, Review.audio_count AS `Review.audio_count`, Review.attachment_count AS `Review.attachment_count`, Review.listing_type_id AS `ListingType.listing_type_id` FROM j25_jreviews_comments AS Review INNER JOIN j25_content AS Listing ON Listing.id = Review.pid AND Listing.state = 1 INNER JOIN j25_categories AS Category ON Listing.catid = Category.id AND Category.published = 1 LEFT JOIN j25_users AS User ON Review.userid = User.id LEFT JOIN j25_jreviews_reviewer_ranks AS ReviewerRank ON Review.userid = ReviewerRank.user_id WHERE 1 = 1 AND ( Review.published = 1 AND Review.mode = 'com_content' ) GROUP BY Review.id ORDER BY `Review.created` DESC LIMIT 20
7. SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM j25_content AS Listing LEFT JOIN j25_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN j25_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN j25_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN j25_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN j25_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN j25_users AS User ON User.id = Listing.created_by LEFT JOIN j25_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( Listing.id IN (27529,16444,27510,27501,27534,27533,27500,27532,27531,27503,27530,27499,27463,27509,7531,27474,27145) )
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 (20239,14999,37527,6874) )
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 (6874,14999,20239,37527) WHERE field.published = 1 AND field.visible >= 1
10. 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 (37527,14999,19817) )
11. 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 (14999,19817,37527) WHERE field.published = 1 AND field.visible >= 1
12. SELECT review_id, criteria_id, IF(rating=0,'na',rating) AS rating FROM j25_jreviews_review_ratings WHERE review_id IN (170452,170451,170450,170449,170448,170447,170446,170445,170444,170443,170442,170441,170440,170439,170438,170437,170436,170435,170434,170433)
13. SELECT groupid FROM j25_jreviews_groups WHERE groupid IN (18,2,20,1) AND type = 'review'
14. SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM j25_jreviews_fields AS Field LEFT JOIN j25_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'review' AND Field.groupid IN ( 1)
15. SELECT Review.reviewid AS element_id,jr_data,jr_envase,jr_volume,jr_comprou,jr_ondebebeu,jr_preco FROM j25_jreviews_review_fields AS Review WHERE Review.reviewid IN (170452,170451,170450,170449,170448,170447,170446,170445,170444,170443,170442,170441,170440,170439,170438,170437,170436,170435,170434,170433)
16. SELECT * FROM j25_jreviews_fieldoptions WHERE fieldid IN ( 23) AND value IN ( 'lata','garrafa') ORDER BY ordering ASC ,optionid ASC
17. SELECT COUNT(Review.id) FROM j25_jreviews_comments AS Review INNER JOIN j25_content AS Listing ON Listing.id = Review.pid AND Listing.state = 1 INNER JOIN j25_categories AS Category ON Listing.catid = Category.id AND Category.published = 1 WHERE 1 = 1 AND ( Review.published = 1 AND Review.mode = 'com_content' )