A better way to browse. Learn more.
A full-screen app on your home screen with push notifications, badges and more.
(write): Connected to the write database
(read): SELECT * FROM `core_dev`
(read): SELECT * FROM `core_theme_editor_settings`
(read): SELECT * FROM `core_sessions` WHERE id='jkooa4jofghpoic2dl1tmcd62f'
(read): SELECT word_key, word_default, word_custom FROM `core_sys_lang_words` WHERE lang_id=1 and word_export='0'
(read): SELECT * FROM `core_theme_editor_settings` WHERE (setting_app not in ('blog','calendar','cloud','cms','core','downloads','forums','gallery','nexus','convert','courses') OR (setting_set_id != 0 and setting_set_id=1) )
(read): SELECT * FROM `core_theme_editor_settings`
(read): SELECT * FROM `core_theme_editor_settings` WHERE (setting_app not in ('blog','calendar','cloud','cms','core','downloads','forums','gallery','nexus','convert','courses') OR (setting_set_id != 0 and setting_set_id=1) )
(read): SELECT downloads_files.*, author.*, SUBSTR( MD5( CONCAT( downloads_files.file_id, downloads_files.file_name ) ), 3 ) as _rand, core_tags_cache.tag_cache_text FROM `downloads_files` LEFT JOIN `downloads_categories` ON downloads_files.file_cat=downloads_categories.cid LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('downloads;downloads;',downloads_files.file_id)) LEFT JOIN `core_members` AS `author` ON author.member_id = downloads_files.file_submitter WHERE downloads_files.file_featured=1 AND downloads_categories.copen=1 AND downloads_files.file_open=1 AND (downloads_files.file_cat IN( SELECT perm_type_id FROM `core_permission_index` WHERE (( FIND_IN_SET(2,core_permission_index.perm_2) ) OR core_permission_index.perm_2='*') AND core_permission_index.app='downloads' AND core_permission_index.perm_type='category') ) ORDER BY _rand LIMIT 4
(read): SELECT COUNT(*) FROM `downloads_categories` LEFT JOIN `core_permission_index` ON core_permission_index.app='downloads' AND core_permission_index.perm_type='category' AND core_permission_index.perm_type_id=downloads_categories.cid WHERE ( FIND_IN_SET(2,core_permission_index.perm_3) ) OR core_permission_index.perm_3='*' AND copen=1
(read): SELECT * FROM `downloads_categories` LEFT JOIN `core_permission_index` ON core_permission_index.app='downloads' AND core_permission_index.perm_type='category' AND core_permission_index.perm_type_id=downloads_categories.cid WHERE cparent=0 AND cclub_id IS NULL AND (( FIND_IN_SET(2,core_permission_index.perm_view) ) OR core_permission_index.perm_view='*') AND copen=1 ORDER BY cposition
(read): SELECT * FROM `downloads_categories` LEFT JOIN `core_permission_index` ON core_permission_index.app='downloads' AND core_permission_index.perm_type='category' AND core_permission_index.perm_type_id=downloads_categories.cid WHERE cparent=1 AND (( FIND_IN_SET(2,core_permission_index.perm_view) ) OR core_permission_index.perm_view='*') AND copen=1 ORDER BY cposition
(read): SELECT downloads_files.*, author.*, core_tags_cache.tag_cache_text FROM `downloads_files` LEFT JOIN `downloads_categories` ON downloads_files.file_cat=downloads_categories.cid LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('downloads;downloads;',downloads_files.file_id)) LEFT JOIN `core_members` AS `author` ON author.member_id = downloads_files.file_submitter WHERE downloads_categories.copen=1 AND downloads_categories.cclub_id IS NULL AND downloads_categories.copen=1 AND downloads_files.file_open=1 AND (downloads_files.file_cat IN( SELECT perm_type_id FROM `core_permission_index` WHERE (( FIND_IN_SET(2,core_permission_index.perm_2) ) OR core_permission_index.perm_2='*') AND core_permission_index.app='downloads' AND core_permission_index.perm_type='category') ) ORDER BY downloads_files.file_submitted DESC LIMIT 14
(read): SELECT downloads_files.*, author.*, core_tags_cache.tag_cache_text FROM `downloads_files` LEFT JOIN `downloads_categories` ON downloads_files.file_cat=downloads_categories.cid LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('downloads;downloads;',downloads_files.file_id)) LEFT JOIN `core_members` AS `author` ON author.member_id = downloads_files.file_submitter WHERE downloads_categories.copen=1 AND file_rating > 0 AND downloads_categories.cclub_id IS NULL AND downloads_categories.copen=1 AND downloads_files.file_open=1 AND (downloads_files.file_cat IN( SELECT perm_type_id FROM `core_permission_index` WHERE (( FIND_IN_SET(2,core_permission_index.perm_2) ) OR core_permission_index.perm_2='*') AND core_permission_index.app='downloads' AND core_permission_index.perm_type='category') ) ORDER BY file_rating DESC, file_reviews DESC LIMIT 14
(read): SELECT downloads_files.*, author.*, core_tags_cache.tag_cache_text FROM `downloads_files` LEFT JOIN `downloads_categories` ON downloads_files.file_cat=downloads_categories.cid LEFT JOIN `core_tags_cache` ON tag_cache_key=MD5(CONCAT('downloads;downloads;',downloads_files.file_id)) LEFT JOIN `core_members` AS `author` ON author.member_id = downloads_files.file_submitter WHERE downloads_categories.copen=1 AND downloads_categories.copen=1 and file_downloads > 0 AND downloads_categories.cclub_id IS NULL AND downloads_categories.copen=1 AND downloads_files.file_open=1 AND (downloads_files.file_cat IN( SELECT perm_type_id FROM `core_permission_index` WHERE (( FIND_IN_SET(2,core_permission_index.perm_2) ) OR core_permission_index.perm_2='*') AND core_permission_index.app='downloads' AND core_permission_index.perm_type='category') ) ORDER BY file_downloads DESC LIMIT 14
(read): SELECT * FROM `core_widget_areas` WHERE (app='global' AND module='global' AND controller='global') OR (app='downloads' AND module='downloads' AND controller='browse')
(read): SELECT cms_pages.*, core_permission_index.perm_id, core_permission_index.perm_view, core_permission_index.perm_2, core_permission_index.perm_3, core_permission_index.perm_4, core_permission_index.perm_5, core_permission_index.perm_6, core_permission_index.perm_7 FROM `cms_pages` LEFT JOIN `core_permission_index` ON core_permission_index.app='cms' AND core_permission_index.perm_type='pages' AND core_permission_index.perm_type_id=cms_pages.page_id WHERE cms_pages.page_id=1
(read): SELECT cms_databases.*, core_permission_index.perm_id, core_permission_index.perm_view, core_permission_index.perm_2, core_permission_index.perm_3, core_permission_index.perm_4, core_permission_index.perm_5, core_permission_index.perm_6, core_permission_index.perm_7 FROM `cms_databases` LEFT JOIN `core_permission_index` ON core_permission_index.app='cms' AND core_permission_index.perm_type='databases' AND core_permission_index.perm_type_id=cms_databases.database_id WHERE cms_databases.database_page_id=1
(read): SELECT * FROM `core_themes` ORDER BY set_order