S2Framework Debug Console

Database Queries (13)

1. SET SQL_BIG_SELECTS=1
2. SHOW TABLES LIKE '%_jreviews_config'
3. SELECT value FROM zcik5_jreviews_config WHERE id = 'cms_secret'
4. SELECT name FROM zcik5_jreviews_addons WHERE state = 1 ORDER BY ordering
5. SELECT id, language FROM zcik5_menu WHERE link LIKE "%com_kunena&view=user" AND published = 1 AND type = "component"
6. SELECT listing_id, review_id, extension, Listing.created_by AS owner_id FROM zcik5_jreviews_media AS Media LEFT JOIN zcik5_content AS Listing ON Listing.id = Media.listing_id WHERE media_id = 5687
7. UPDATE zcik5_jreviews_media AS Media SET views = views + 1 WHERE media_id = 5687
8. SELECT Media.media_id AS `Media.media_id`, Media.media_type AS `Media.media_type`, IF ( Media.media_type = "video" AND Media.embed != "",Media.embed,Media.media_type) AS `Media.drive`, Media.media_function AS `Media.media_function`, Media.listing_id AS `Media.listing_id`, Media.extension AS `Media.extension`, Media.review_id AS `Media.review_id`, Media.name AS `Media.name`, Media.filename AS `Media.filename`, Media.file_extension AS `Media.file_extension`, Media.rel_path AS `Media.rel_path`, Media.media_info AS `Media.media_info`, Media.metadata AS `Media.metadata`, Media.embed AS `Media.embed`, Media.title AS `Media.title`, Media.description AS `Media.description`, Media.duration AS `Media.duration`, Media.filesize AS `Media.filesize`, Media.created AS `Media.created`, Media.modified AS `Media.modified`, Media.approved AS `Media.approved`, Media.published AS `Media.published`, Media.access AS `Media.access`, INET_NTOA(Media.ipaddress) AS `Media.ipaddress`, Media.views AS `Media.views`, Media.main_media AS `Media.main_media`, Media.likes_up AS `Media.likes_up`, Media.likes_total AS `Media.likes_total`, Media.likes_rank AS `Media.likes_rank`, Media.ordering AS `Media.ordering`, Media.user_id AS `Media.user_id`, Media.user_id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.block AS `User.block`, IF(User.email <> "", User.email, Media.email) AS `User.email` FROM zcik5_jreviews_media AS Media LEFT JOIN zcik5_users AS User ON Media.user_id = User.id WHERE 1 = 1 AND ( Media.listing_id = 1009 AND Media.media_type = "video" AND Media.extension = 'com_content' AND Media.published = 1 AND Media.approved = 1 ) ORDER BY `Media.media_type`, `Media.ordering`
9. 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 zcik5_content AS Listing LEFT JOIN zcik5_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN zcik5_jreviews_content AS Field ON Field.contentid = Listing.id LEFT JOIN zcik5_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN zcik5_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN zcik5_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN zcik5_users AS User ON User.id = Listing.created_by LEFT JOIN zcik5_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 (1009) )
10. SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM zcik5_jreviews_media AS media WHERE listing_id IN (1009) AND published = 1 AND approved = 1 AND access IN (1,5) AND main_media = 1
11. 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`, User.name AS `User.name`, User.username AS `User.username`, User.block As `User.block`, User.name AS `User.email` FROM zcik5_kunena_users AS Community LEFT JOIN zcik5_users AS User ON Community.userid = User.id WHERE 1 = 1 AND ( Community.userid IN (46) )
12. SELECT Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.description AS `Category.description`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id` FROM zcik5_categories AS Category INNER JOIN zcik5_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN zcik5_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE 1 = 1 AND ( Category.id=77 )
13. SELECT ListingType.id AS `ListingType.listing_type_id`, ListingType.title AS `ListingType.title`, ListingType.groupid AS `ListingType.group_id`, ListingType.state AS `ListingType.state`, ListingType.search AS `ListingType.search`, ListingType.config AS `ListingType.config` FROM zcik5_jreviews_criteria AS ListingType INNER JOIN zcik5_jreviews_categories AS JreviewCategory ON ListingType.id = JreviewCategory.criteriaid AND JreviewCategory.`option` = 'com_content' WHERE 1 = 1 AND ( JreviewCategory.id = 77 )