-
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
#system/ee/legacy/core/Loader.php L:944 EE_Extensions::__construct()
-
SELECT Session_sessions.session_id as Session__session_id, Session_sessions.member_id as Session__member_id, Session_sessions.admin_sess as Session__admin_sess, Session_sessions.ip_address as Session__ip_address, Session_sessions.user_agent as Session__user_agent, Session_sessions.login_state as Session__login_state, Session_sessions.fingerprint as Session__fingerprint, Session_sessions.sess_start as Session__sess_start, Session_sessions.auth_timeout as Session__auth_timeout, Session_sessions.last_activity as Session__last_activity, Session_sessions.can_debug as Session__can_debug, Session_sessions.mfa_flag as Session__mfa_flag, Session_sessions.pro_banner_seen as Session__pro_banner_seen
FROM (`exp_sessions` as Session_sessions)
WHERE (
`Session_sessions`.`session_id` = '7a85ed71dac3b1890684adc70b88fc1c670bb910'
)
LIMIT 1
#system/ee/legacy/libraries/Session.php L:179 EE_Session::fetch_session_data()
-
SELECT *
FROM (`exp_members` m, `exp_role_settings` g)
WHERE `g`.`site_id` = 1
AND m.role_id = g.role_id
AND `member_id` = 1
#system/ee/legacy/libraries/Session.php L:591 EE_Session::_do_member_query()
-
SHOW COLUMNS FROM `exp_member_data`
#system/ee/ExpressionEngine/Service/Model/MetaDataReader.php L:174 ExpressionEngine\Model\Content\VariableColumnGateway::getFieldList()
-
SELECT COUNT(*) AS `numrows`
FROM (`exp_member_fields` as MemberField_member_fields)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Service/Model/Query/Select.php L:100 ExpressionEngine\Library\Data\Entity::getMetaData()
-
SELECT Member_members.member_id as Member__member_id, Member_members.role_id as Member__role_id, Member_members.pending_role_id as Member__pending_role_id, Member_members.username as Member__username, Member_members.screen_name as Member__screen_name, Member_members.password as Member__password, Member_members.salt as Member__salt, Member_members.unique_id as Member__unique_id, Member_members.crypt_key as Member__crypt_key, Member_members.backup_mfa_code as Member__backup_mfa_code, Member_members.authcode as Member__authcode, Member_members.email as Member__email, Member_members.signature as Member__signature, Member_members.avatar_filename as Member__avatar_filename, Member_members.avatar_width as Member__avatar_width, Member_members.avatar_height as Member__avatar_height, Member_members.photo_filename as Member__photo_filename, Member_members.photo_width as Member__photo_width, Member_members.photo_height as Member__photo_height, Member_members.sig_img_filename as Member__sig_img_filename, Member_members.sig_img_width as Member__sig_img_width, Member_members.sig_img_height as Member__sig_img_height, Member_members.ignore_list as Member__ignore_list, Member_members.private_messages as Member__private_messages, Member_members.accept_messages as Member__accept_messages, Member_members.last_view_bulletins as Member__last_view_bulletins, Member_members.last_bulletin_date as Member__last_bulletin_date, Member_members.ip_address as Member__ip_address, Member_members.join_date as Member__join_date, Member_members.last_visit as Member__last_visit, Member_members.last_activity as Member__last_activity, Member_members.total_entries as Member__total_entries, Member_members.total_comments as Member__total_comments, Member_members.total_forum_topics as Member__total_forum_topics, Member_members.total_forum_posts as Member__total_forum_posts, Member_members.last_entry_date as Member__last_entry_date, Member_members.last_comment_date as Member__last_comment_date, Member_members.last_forum_post_date as Member__last_forum_post_date, Member_members.last_email_date as Member__last_email_date, Member_members.in_authorlist as Member__in_authorlist, Member_members.accept_admin_email as Member__accept_admin_email, Member_members.accept_user_email as Member__accept_user_email, Member_members.notify_by_default as Member__notify_by_default, Member_members.notify_of_pm as Member__notify_of_pm, Member_members.display_signatures as Member__display_signatures, Member_members.parse_smileys as Member__parse_smileys, Member_members.smart_notifications as Member__smart_notifications, Member_members.language as Member__language, Member_members.timezone as Member__timezone, Member_members.time_format as Member__time_format, Member_members.date_format as Member__date_format, Member_members.week_start as Member__week_start, Member_members.include_seconds as Member__include_seconds, Member_members.profile_theme as Member__profile_theme, Member_members.forum_theme as Member__forum_theme, Member_members.tracker as Member__tracker, Member_members.template_size as Member__template_size, Member_members.notepad as Member__notepad, Member_members.notepad_size as Member__notepad_size, Member_members.bookmarklets as Member__bookmarklets, Member_members.quick_links as Member__quick_links, Member_members.quick_tabs as Member__quick_tabs, Member_members.show_sidebar as Member__show_sidebar, Member_members.pmember_id as Member__pmember_id, Member_members.cp_homepage as Member__cp_homepage, Member_members.cp_homepage_channel as Member__cp_homepage_channel, Member_members.cp_homepage_custom as Member__cp_homepage_custom, Member_members.dismissed_banner as Member__dismissed_banner, Member_members.enable_mfa as Member__enable_mfa, Member_member_data.m_field_id_1 as Member__m_field_id_1, Member_member_data.m_field_ft_1 as Member__m_field_ft_1, Member_member_data.m_field_id_2 as Member__m_field_id_2, Member_member_data.m_field_ft_2 as Member__m_field_ft_2, Member_member_data.m_field_id_3 as Member__m_field_id_3, Member_member_data.m_field_ft_3 as Member__m_field_ft_3, PrimaryRole_roles.role_id as PrimaryRole__role_id, PrimaryRole_roles.name as PrimaryRole__name, PrimaryRole_roles.short_name as PrimaryRole__short_name, PrimaryRole_roles.description as PrimaryRole__description, PrimaryRole_roles.highlight as PrimaryRole__highlight, PrimaryRole_roles.total_members as PrimaryRole__total_members, PrimaryRole_roles.is_locked as PrimaryRole__is_locked, RoleSettings_role_settings.id as RoleSettings__id, RoleSettings_role_settings.role_id as RoleSettings__role_id, RoleSettings_role_settings.site_id as RoleSettings__site_id, RoleSettings_role_settings.menu_set_id as RoleSettings__menu_set_id, RoleSettings_role_settings.mbr_delete_notify_emails as RoleSettings__mbr_delete_notify_emails, RoleSettings_role_settings.exclude_from_moderation as RoleSettings__exclude_from_moderation, RoleSettings_role_settings.search_flood_control as RoleSettings__search_flood_control, RoleSettings_role_settings.prv_msg_send_limit as RoleSettings__prv_msg_send_limit, RoleSettings_role_settings.prv_msg_storage_limit as RoleSettings__prv_msg_storage_limit, RoleSettings_role_settings.include_in_authorlist as RoleSettings__include_in_authorlist, RoleSettings_role_settings.include_in_memberlist as RoleSettings__include_in_memberlist, RoleSettings_role_settings.cp_homepage as RoleSettings__cp_homepage, RoleSettings_role_settings.cp_homepage_channel as RoleSettings__cp_homepage_channel, RoleSettings_role_settings.cp_homepage_custom as RoleSettings__cp_homepage_custom, RoleSettings_role_settings.require_mfa as RoleSettings__require_mfa, RoleSettings_role_settings.show_field_names as RoleSettings__show_field_names, Roles_roles.role_id as Roles__role_id, Roles_roles.name as Roles__name, Roles_roles.short_name as Roles__short_name, Roles_roles.description as Roles__description, Roles_roles.highlight as Roles__highlight, Roles_roles.total_members as Roles__total_members, Roles_roles.is_locked as Roles__is_locked, RoleGroups_role_groups.group_id as RoleGroups__group_id, RoleGroups_role_groups.name as RoleGroups__name
FROM (`exp_members` as Member_members)
LEFT JOIN `exp_member_data` as Member_member_data ON `Member_member_data`.`member_id` = `Member_members`.`member_id`
LEFT JOIN `exp_roles` AS PrimaryRole_roles ON `PrimaryRole_roles`.`role_id` = `Member_members`.`role_id`
LEFT JOIN `exp_role_settings` AS RoleSettings_role_settings ON `RoleSettings_role_settings`.`role_id` = `PrimaryRole_roles`.`role_id`
LEFT JOIN `exp_members_roles` as Member_Roles_members_roles ON `Member_Roles_members_roles`.`member_id` = `Member_members`.`member_id`
LEFT JOIN `exp_roles` as Roles_roles ON `Roles_roles`.`role_id` = `Member_Roles_members_roles`.`role_id`
LEFT JOIN `exp_members_role_groups` as Member_RoleGroups_members_role_groups ON `Member_RoleGroups_members_role_groups`.`member_id` = `Member_members`.`member_id`
LEFT JOIN `exp_role_groups` as RoleGroups_role_groups ON `RoleGroups_role_groups`.`group_id` = `Member_RoleGroups_members_role_groups`.`group_id`
WHERE (
`Member_members`.`member_id` = 1
AND `RoleSettings_role_settings`.`site_id` = '1'
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Session.php L:1210 EE_Session::_setupMemberModel()
-
SELECT MemberField_member_fields.m_field_id as MemberField__m_field_id, MemberField_member_fields.m_field_name as MemberField__m_field_name, MemberField_member_fields.m_field_label as MemberField__m_field_label, MemberField_member_fields.m_field_description as MemberField__m_field_description, MemberField_member_fields.m_field_type as MemberField__m_field_type, MemberField_member_fields.m_field_list_items as MemberField__m_field_list_items, MemberField_member_fields.m_field_ta_rows as MemberField__m_field_ta_rows, MemberField_member_fields.m_field_maxl as MemberField__m_field_maxl, MemberField_member_fields.m_field_width as MemberField__m_field_width, MemberField_member_fields.m_field_search as MemberField__m_field_search, MemberField_member_fields.m_field_required as MemberField__m_field_required, MemberField_member_fields.m_field_public as MemberField__m_field_public, MemberField_member_fields.m_field_reg as MemberField__m_field_reg, MemberField_member_fields.m_field_cp_reg as MemberField__m_field_cp_reg, MemberField_member_fields.m_field_fmt as MemberField__m_field_fmt, MemberField_member_fields.m_field_show_fmt as MemberField__m_field_show_fmt, MemberField_member_fields.m_field_exclude_from_anon as MemberField__m_field_exclude_from_anon, MemberField_member_fields.m_field_order as MemberField__m_field_order, MemberField_member_fields.m_field_text_direction as MemberField__m_field_text_direction, MemberField_member_fields.m_field_settings as MemberField__m_field_settings, MemberField_member_fields.m_legacy_field_data as MemberField__m_legacy_field_data
FROM (`exp_member_fields` as MemberField_member_fields)
WHERE (
`MemberField_member_fields`.`m_legacy_field_data` = 'n'
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Session.php L:1210 EE_Session::_setupMemberModel()
-
SELECT exp_members.member_id as Member__member_id, Member_field_id_4.m_field_id_4 as Member__m_field_id_4, Member_field_id_4.m_field_ft_4 as Member__m_field_ft_4, Member_field_id_5.m_field_id_5 as Member__m_field_id_5, Member_field_id_5.m_field_ft_5 as Member__m_field_ft_5, Member_field_id_6.m_field_id_6 as Member__m_field_id_6, Member_field_id_6.m_field_ft_6 as Member__m_field_ft_6, Member_field_id_7.m_field_id_7 as Member__m_field_id_7, Member_field_id_7.m_field_ft_7 as Member__m_field_ft_7
FROM (`exp_members`)
LEFT JOIN `exp_member_data_field_4` AS Member_field_id_4 ON `Member_field_id_4`.`member_id` = `exp_members`.`member_id`
LEFT JOIN `exp_member_data_field_5` AS Member_field_id_5 ON `Member_field_id_5`.`member_id` = `exp_members`.`member_id`
LEFT JOIN `exp_member_data_field_6` AS Member_field_id_6 ON `Member_field_id_6`.`member_id` = `exp_members`.`member_id`
LEFT JOIN `exp_member_data_field_7` AS Member_field_id_7 ON `Member_field_id_7`.`member_id` = `exp_members`.`member_id`
WHERE `exp_members`.`member_id` IN ('1')
#system/ee/legacy/libraries/Session.php L:1210 EE_Session::_setupMemberModel()
-
SELECT ee_m_Role_roles.role_id as ee_m_Role__role_id, ee_m_Role_roles.name as ee_m_Role__name, ee_m_Role_roles.short_name as ee_m_Role__short_name, ee_m_Role_roles.description as ee_m_Role__description, ee_m_Role_roles.highlight as ee_m_Role__highlight, ee_m_Role_roles.total_members as ee_m_Role__total_members, ee_m_Role_roles.is_locked as ee_m_Role__is_locked
FROM (`exp_roles` as ee_m_Role_roles)
LEFT JOIN `exp_roles_role_groups` as ee_m_RoleGroup_ee_m_Role_roles_role_groups ON `ee_m_RoleGroup_ee_m_Role_roles_role_groups`.`role_id` = `ee_m_Role_roles`.`role_id`
WHERE `ee_m_RoleGroup_ee_m_Role_roles_role_groups`.`group_id` = 0
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Model/Member/Member.php L:1152 ExpressionEngine\Model\Member\Member::getAllRoles()
-
SELECT Permission_permissions.permission_id as Permission__permission_id, Permission_permissions.role_id as Permission__role_id, Permission_permissions.site_id as Permission__site_id, Permission_permissions.permission as Permission__permission
FROM (`exp_permissions` as Permission_permissions)
WHERE (
`Permission_permissions`.`site_id` = '1'
AND `Permission_permissions`.`role_id` IN (1)
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Session.php L:625 ExpressionEngine\Model\Member\Member::getPermissions()
-
UPDATE `exp_sessions` SET `session_id` = '7a85ed71dac3b1890684adc70b88fc1c670bb910', `fingerprint` = 'de8f7a3bdc056126568350efe63f00e4', `member_id` = 1, `admin_sess` = 1, `mfa_flag` = 'skip', `ip_address` = '45.144.114.147', `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', `last_activity` = 1780584324, `sess_start` = '1780583962', `can_debug` = 0 WHERE session_id = '7a85ed71dac3b1890684adc70b88fc1c670bb910'
#system/ee/legacy/libraries/Session.php L:190 EE_Session::update_session()
-
SELECT *
FROM (`exp_security_hashes`)
WHERE `session_id` = '7a85ed71dac3b1890684adc70b88fc1c670bb910'
#system/ee/legacy/libraries/Csrf.php L:165 Csrf_database::fetch_token()
-
SELECT Snippet_snippets.snippet_id as Snippet__snippet_id, Snippet_snippets.site_id as Snippet__site_id, Snippet_snippets.snippet_name as Snippet__snippet_name, Snippet_snippets.snippet_contents as Snippet__snippet_contents, Snippet_snippets.edit_date as Snippet__edit_date
FROM (`exp_snippets` as Snippet_snippets)
WHERE (
`Snippet_snippets`.`site_id` = '1'
OR `Snippet_snippets`.`site_id` = 0
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Core.php L:463 ExpressionEngine\Model\Template\Snippet::loadAll()
-
SELECT Site_sites.site_id as Site__site_id, Site_sites.site_name as Site__site_name
FROM (`exp_sites` as Site_sites)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Model/Template/Snippet.php L:170 ExpressionEngine\Model\Template\Snippet::getFolderPath()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = '1'
AND `exp_templates`.`template_name` = 'index'
AND `exp_template_groups`.`is_site_default` = 'y'
#system/ee/legacy/libraries/Template.php L:2200 EE_Template::fetch_template()
-
SELECT DISTINCT `role_id`
FROM (`exp_permissions`)
WHERE `permission` = 'can_access_cp'
#system/ee/ExpressionEngine/Addons/pro/Service/Access/Access.php L:120 ExpressionEngine\Addons\Pro\Service\Access\Access::requiresValidLicense()
-
SELECT COUNT(DISTINCT(exp_members.member_id)) AS count
FROM exp_members
LEFT JOIN exp_members_roles ON (exp_members.member_id = exp_members_roles.member_id)
LEFT JOIN exp_members_role_groups ON (exp_members.member_id = exp_members_role_groups.member_id)
LEFT JOIN exp_roles_role_groups ON (exp_members_role_groups.group_id = exp_roles_role_groups.group_id)
WHERE exp_members.role_id IN (1, 7, 6, 9)
OR exp_members_roles.role_id IN (1, 7, 6, 9)
OR exp_roles_role_groups.role_id IN (1, 7, 6, 9)
#system/ee/ExpressionEngine/Addons/pro/Service/Access/Access.php L:120 ExpressionEngine\Addons\Pro\Service\Access\Access::requiresValidLicense()
-
SELECT Role_roles.role_id as Role__role_id, Role_roles.short_name as Role__short_name
FROM (`exp_roles` as Role_roles)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Template.php L:376 EE_Template::getMemberVariables()
-
SELECT `field_id`, `field_type`, `field_fmt`, `field_name`, `site_id`, `field_settings`
FROM (`exp_channel_fields`)
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:338 Api_channel_fields::fetch_custom_channel_fields()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.search_excerpt as Channel__search_excerpt
FROM (`exp_channels` as Channel_channels)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id NOT IN (45) AND t.status = 'Home1' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 3
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('91824', '93841', '96434')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('32', '8', '22')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (91824,93841,96434)ORDER BY FIELD(t.entry_id, 91824,93841,96434)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT *
FROM (`exp_fieldtypes`)
#system/ee/legacy/libraries/api/Api_channel_fields.php L:126 EE_Addons::get_installed()
-
SELECT Plugin_plugins.plugin_id as Plugin__plugin_id, Plugin_plugins.plugin_name as Plugin__plugin_name, Plugin_plugins.plugin_package as Plugin__plugin_package, Plugin_plugins.plugin_version as Plugin__plugin_version, Plugin_plugins.is_typography_related as Plugin__is_typography_related
FROM (`exp_plugins` as Plugin_plugins)
WHERE (
`Plugin_plugins`.`is_typography_related` = 'y'
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/Typography.php L:227 Addons_model::get_plugin_formatting()
-
SELECT *
FROM (`exp_upload_prefs`)
ORDER BY `name`
#system/ee/legacy/models/file_upload_preferences_model.php L:225 File_upload_preferences_model::get_file_upload_preferences()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id NOT IN (45) AND t.status = 'Home3' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 3
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('91752', '102372', '101004')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('29', '8', '12')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (91752,102372,101004)ORDER BY FIELD(t.entry_id, 91752,102372,101004)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT File_files.file_id as File__file_id, File_files.model_type as File__model_type, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.directory_id as File__directory_id, File_files.mime_type as File__mime_type, File_files.file_type as File__file_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, File_files.total_records as File__total_records, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`model_type` = 'File'
AND binary `File_files`.`file_name` IN ('cruise-center-photo.jpg', 'bonaire_parakeet.jpg')
AND `File_files`.`upload_location_id` IN ('11', '35')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:538 File_field::get_files_by_name()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , exp_channels.channel_id , t.sticky FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id IN (10,16,52,43) AND (exp_categories.cat_id NOT IN ('304','1311') OR exp_categories.cat_id IS NULL) AND t.status = 'open' ORDER BY rand(), t.entry_id desc LIMIT 0, 1
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('770')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('16')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (770)ORDER BY FIELD(t.entry_id, 770)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , exp_channels.channel_id , t.sticky FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id IN (82) AND (exp_categories.cat_id NOT IN ('304','1260') OR exp_categories.cat_id IS NULL) AND t.status = 'open' ORDER BY rand(), t.entry_id desc LIMIT 0, 1
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('105865')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('82')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (105865)ORDER BY FIELD(t.entry_id, 105865)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT File_files.file_id as File__file_id, File_files.model_type as File__model_type, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.directory_id as File__directory_id, File_files.mime_type as File__mime_type, File_files.file_type as File__file_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, File_files.total_records as File__total_records, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`model_type` = 'File'
AND binary `File_files`.`file_name` IN ('kenai_fjords_boating.jpg')
AND `File_files`.`upload_location_id` IN ('46')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:538 File_field::get_files_by_name()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT t.entry_id , exp_channels.channel_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id NOT IN (45) AND t.status = 'Home3' AND t.status != 'closed' ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 3, 3
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('532', '96526')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('9', '18')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (532,96526)ORDER BY FIELD(t.entry_id, 532,96526)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT File_files.file_id as File__file_id, File_files.model_type as File__model_type, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.directory_id as File__directory_id, File_files.mime_type as File__mime_type, File_files.file_type as File__file_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, File_files.total_records as File__total_records, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`model_type` = 'File'
AND binary `File_files`.`file_name` IN ('barbados_catamaran.jpg')
AND `File_files`.`upload_location_id` IN ('3')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:538 File_field::get_files_by_name()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , exp_channels.channel_id , t.sticky FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id IN (80) AND exp_categories.cat_id IN ('1307','1308','1311') AND t.status = 'open' ORDER BY rand(), t.entry_id desc LIMIT 0, 1
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('107104')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('80')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (107104)ORDER BY FIELD(t.entry_id, 107104)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , exp_channels.channel_id , t.sticky FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id IN (80) AND exp_categories.cat_id = '1310' AND t.status = 'open' ORDER BY rand(), t.entry_id desc LIMIT 0, 1
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('107115')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (107115)ORDER BY FIELD(t.entry_id, 107115)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT File_files.file_id as File__file_id, File_files.model_type as File__model_type, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.directory_id as File__directory_id, File_files.mime_type as File__mime_type, File_files.file_type as File__file_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, File_files.total_records as File__total_records, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`model_type` = 'File'
AND binary `File_files`.`file_name` IN ('river_cruise_440.jpg')
AND `File_files`.`upload_location_id` IN ('45')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:538 File_field::get_files_by_name()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , exp_channels.channel_id , t.sticky FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id IN (62) AND (exp_categories.cat_id NOT IN ('304','1260','1311','1323') OR exp_categories.cat_id IS NULL) AND t.status = 'open' ORDER BY rand(), t.entry_id desc LIMIT 0, 1
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('107151')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('62')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (107151)ORDER BY FIELD(t.entry_id, 107151)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT File_files.file_id as File__file_id, File_files.model_type as File__model_type, File_files.site_id as File__site_id, File_files.title as File__title, File_files.upload_location_id as File__upload_location_id, File_files.directory_id as File__directory_id, File_files.mime_type as File__mime_type, File_files.file_type as File__file_type, File_files.file_name as File__file_name, File_files.file_size as File__file_size, File_files.description as File__description, File_files.credit as File__credit, File_files.location as File__location, File_files.uploaded_by_member_id as File__uploaded_by_member_id, File_files.upload_date as File__upload_date, File_files.modified_by_member_id as File__modified_by_member_id, File_files.modified_date as File__modified_date, File_files.file_hw_original as File__file_hw_original, File_files.total_records as File__total_records, UploadDestination_upload_prefs.id as UploadDestination__id, UploadDestination_upload_prefs.site_id as UploadDestination__site_id, UploadDestination_upload_prefs.name as UploadDestination__name, UploadDestination_upload_prefs.adapter as UploadDestination__adapter, UploadDestination_upload_prefs.adapter_settings as UploadDestination__adapter_settings, UploadDestination_upload_prefs.server_path as UploadDestination__server_path, UploadDestination_upload_prefs.url as UploadDestination__url, UploadDestination_upload_prefs.allowed_types as UploadDestination__allowed_types, UploadDestination_upload_prefs.allow_subfolders as UploadDestination__allow_subfolders, UploadDestination_upload_prefs.subfolders_on_top as UploadDestination__subfolders_on_top, UploadDestination_upload_prefs.default_modal_view as UploadDestination__default_modal_view, UploadDestination_upload_prefs.max_size as UploadDestination__max_size, UploadDestination_upload_prefs.max_height as UploadDestination__max_height, UploadDestination_upload_prefs.max_width as UploadDestination__max_width, UploadDestination_upload_prefs.properties as UploadDestination__properties, UploadDestination_upload_prefs.pre_format as UploadDestination__pre_format, UploadDestination_upload_prefs.post_format as UploadDestination__post_format, UploadDestination_upload_prefs.file_properties as UploadDestination__file_properties, UploadDestination_upload_prefs.file_pre_format as UploadDestination__file_pre_format, UploadDestination_upload_prefs.file_post_format as UploadDestination__file_post_format, UploadDestination_upload_prefs.cat_group as UploadDestination__cat_group, UploadDestination_upload_prefs.batch_location as UploadDestination__batch_location, UploadDestination_upload_prefs.module_id as UploadDestination__module_id
FROM (`exp_files` as File_files)
LEFT JOIN `exp_upload_prefs` AS UploadDestination_upload_prefs ON `UploadDestination_upload_prefs`.`id` = `File_files`.`upload_location_id`
WHERE (
`File_files`.`model_type` = 'File'
AND binary `File_files`.`file_name` IN ('queen_mary_440.jpg')
AND `File_files`.`upload_location_id` IN ('45')
)
LIMIT 18446744073709551615
#system/ee/legacy/libraries/File_field.php L:538 File_field::get_files_by_name()
-
SELECT count(*) AS count
FROM exp_channel_titles
WHERE exp_channel_titles.site_id IN ('1') AND exp_channel_titles.url_title = 'index'
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT DISTINCT t.entry_id , exp_channels.channel_id , t.sticky FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id
LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id != '' AND t.site_id IN ('1') AND t.entry_date <= 1780584324 AND (t.expiration_date = 0 OR t.expiration_date > 1780584324) AND t.channel_id IN (4) AND (exp_categories.cat_id != '304' OR exp_categories.cat_id IS NULL) AND t.status != 'closed'ORDER BY rand(), t.entry_id desc LIMIT 0, 5
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT `entry_id`, `field_id`
FROM (`exp_channel_entry_hidden_fields`)
WHERE `entry_id` IN ('91809', '93048', '107319', '94797', '94649')
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:221 Channel::build_sql_query()
-
SELECT Channel_channels.channel_id as Channel__channel_id, Channel_channels.site_id as Channel__site_id, Channel_channels.channel_name as Channel__channel_name, Channel_channels.channel_title as Channel__channel_title, Channel_channels.channel_url as Channel__channel_url, Channel_channels.channel_description as Channel__channel_description, Channel_channels.channel_lang as Channel__channel_lang, Channel_channels.total_entries as Channel__total_entries, Channel_channels.total_records as Channel__total_records, Channel_channels.total_comments as Channel__total_comments, Channel_channels.last_entry_date as Channel__last_entry_date, Channel_channels.last_comment_date as Channel__last_comment_date, Channel_channels.cat_group as Channel__cat_group, Channel_channels.deft_status as Channel__deft_status, Channel_channels.search_excerpt as Channel__search_excerpt, Channel_channels.deft_category as Channel__deft_category, Channel_channels.deft_comments as Channel__deft_comments, Channel_channels.channel_require_membership as Channel__channel_require_membership, Channel_channels.channel_max_chars as Channel__channel_max_chars, Channel_channels.channel_html_formatting as Channel__channel_html_formatting, Channel_channels.channel_allow_img_urls as Channel__channel_allow_img_urls, Channel_channels.channel_auto_link_urls as Channel__channel_auto_link_urls, Channel_channels.channel_notify as Channel__channel_notify, Channel_channels.channel_notify_emails as Channel__channel_notify_emails, Channel_channels.comment_url as Channel__comment_url, Channel_channels.sticky_enabled as Channel__sticky_enabled, Channel_channels.enable_entry_cloning as Channel__enable_entry_cloning, Channel_channels.comment_system_enabled as Channel__comment_system_enabled, Channel_channels.comment_require_membership as Channel__comment_require_membership, Channel_channels.comment_moderate as Channel__comment_moderate, Channel_channels.comment_max_chars as Channel__comment_max_chars, Channel_channels.comment_timelock as Channel__comment_timelock, Channel_channels.comment_require_email as Channel__comment_require_email, Channel_channels.comment_text_formatting as Channel__comment_text_formatting, Channel_channels.comment_html_formatting as Channel__comment_html_formatting, Channel_channels.comment_allow_img_urls as Channel__comment_allow_img_urls, Channel_channels.comment_auto_link_urls as Channel__comment_auto_link_urls, Channel_channels.comment_notify as Channel__comment_notify, Channel_channels.comment_notify_authors as Channel__comment_notify_authors, Channel_channels.comment_notify_emails as Channel__comment_notify_emails, Channel_channels.comment_expiration as Channel__comment_expiration, Channel_channels.search_results_url as Channel__search_results_url, Channel_channels.rss_url as Channel__rss_url, Channel_channels.enable_versioning as Channel__enable_versioning, Channel_channels.max_revisions as Channel__max_revisions, Channel_channels.default_entry_title as Channel__default_entry_title, Channel_channels.title_field_label as Channel__title_field_label, Channel_channels.title_field_instructions as Channel__title_field_instructions, Channel_channels.url_title_prefix as Channel__url_title_prefix, Channel_channels.enforce_auto_url_title as Channel__enforce_auto_url_title, Channel_channels.max_entries as Channel__max_entries, Channel_channels.preview_url as Channel__preview_url, Channel_channels.allow_preview as Channel__allow_preview, Channel_channels.conditional_sync_required as Channel__conditional_sync_required, FieldGroups_field_groups.group_id as FieldGroups__group_id, FieldGroups_field_groups.site_id as FieldGroups__site_id, FieldGroups_field_groups.group_name as FieldGroups__group_name, FieldGroups_field_groups.short_name as FieldGroups__short_name, FieldGroups_field_groups.group_description as FieldGroups__group_description, CustomFields_channel_fields.field_id as CustomFields__field_id, CustomFields_channel_fields.site_id as CustomFields__site_id, CustomFields_channel_fields.field_name as CustomFields__field_name, CustomFields_channel_fields.field_label as CustomFields__field_label, CustomFields_channel_fields.field_instructions as CustomFields__field_instructions, CustomFields_channel_fields.field_type as CustomFields__field_type, CustomFields_channel_fields.field_list_items as CustomFields__field_list_items, CustomFields_channel_fields.field_pre_populate as CustomFields__field_pre_populate, CustomFields_channel_fields.field_pre_channel_id as CustomFields__field_pre_channel_id, CustomFields_channel_fields.field_pre_field_id as CustomFields__field_pre_field_id, CustomFields_channel_fields.field_ta_rows as CustomFields__field_ta_rows, CustomFields_channel_fields.field_maxl as CustomFields__field_maxl, CustomFields_channel_fields.field_required as CustomFields__field_required, CustomFields_channel_fields.field_text_direction as CustomFields__field_text_direction, CustomFields_channel_fields.field_search as CustomFields__field_search, CustomFields_channel_fields.field_is_hidden as CustomFields__field_is_hidden, CustomFields_channel_fields.field_is_conditional as CustomFields__field_is_conditional, CustomFields_channel_fields.field_fmt as CustomFields__field_fmt, CustomFields_channel_fields.field_show_fmt as CustomFields__field_show_fmt, CustomFields_channel_fields.field_order as CustomFields__field_order, CustomFields_channel_fields.field_content_type as CustomFields__field_content_type, CustomFields_channel_fields.field_settings as CustomFields__field_settings, CustomFields_channel_fields.legacy_field_data as CustomFields__legacy_field_data, CustomFields_channel_fields.enable_frontedit as CustomFields__enable_frontedit
FROM (`exp_channels` as Channel_channels)
LEFT JOIN `exp_channels_channel_field_groups` as Channel_FieldGroups_channels_channel_field_groups ON `Channel_FieldGroups_channels_channel_field_groups`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_field_groups` as FieldGroups_field_groups ON `FieldGroups_field_groups`.`group_id` = `Channel_FieldGroups_channels_channel_field_groups`.`group_id`
LEFT JOIN `exp_channels_channel_fields` as Channel_CustomFields_channels_channel_fields ON `Channel_CustomFields_channels_channel_fields`.`channel_id` = `Channel_channels`.`channel_id`
LEFT JOIN `exp_channel_fields` as CustomFields_channel_fields ON `CustomFields_channel_fields`.`field_id` = `Channel_CustomFields_channels_channel_fields`.`field_id`
WHERE (
`Channel_channels`.`channel_id` IN ('4')
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2108 Channel::generateSQLForEntries()
-
SELECT ee_m_ChannelField_channel_fields.field_id as ee_m_ChannelField__field_id, ee_m_ChannelField_channel_fields.site_id as ee_m_ChannelField__site_id, ee_m_ChannelField_channel_fields.field_name as ee_m_ChannelField__field_name, ee_m_ChannelField_channel_fields.field_label as ee_m_ChannelField__field_label, ee_m_ChannelField_channel_fields.field_instructions as ee_m_ChannelField__field_instructions, ee_m_ChannelField_channel_fields.field_type as ee_m_ChannelField__field_type, ee_m_ChannelField_channel_fields.field_list_items as ee_m_ChannelField__field_list_items, ee_m_ChannelField_channel_fields.field_pre_populate as ee_m_ChannelField__field_pre_populate, ee_m_ChannelField_channel_fields.field_pre_channel_id as ee_m_ChannelField__field_pre_channel_id, ee_m_ChannelField_channel_fields.field_pre_field_id as ee_m_ChannelField__field_pre_field_id, ee_m_ChannelField_channel_fields.field_ta_rows as ee_m_ChannelField__field_ta_rows, ee_m_ChannelField_channel_fields.field_maxl as ee_m_ChannelField__field_maxl, ee_m_ChannelField_channel_fields.field_required as ee_m_ChannelField__field_required, ee_m_ChannelField_channel_fields.field_text_direction as ee_m_ChannelField__field_text_direction, ee_m_ChannelField_channel_fields.field_search as ee_m_ChannelField__field_search, ee_m_ChannelField_channel_fields.field_is_hidden as ee_m_ChannelField__field_is_hidden, ee_m_ChannelField_channel_fields.field_is_conditional as ee_m_ChannelField__field_is_conditional, ee_m_ChannelField_channel_fields.field_fmt as ee_m_ChannelField__field_fmt, ee_m_ChannelField_channel_fields.field_show_fmt as ee_m_ChannelField__field_show_fmt, ee_m_ChannelField_channel_fields.field_order as ee_m_ChannelField__field_order, ee_m_ChannelField_channel_fields.field_content_type as ee_m_ChannelField__field_content_type, ee_m_ChannelField_channel_fields.field_settings as ee_m_ChannelField__field_settings, ee_m_ChannelField_channel_fields.legacy_field_data as ee_m_ChannelField__legacy_field_data, ee_m_ChannelField_channel_fields.enable_frontedit as ee_m_ChannelField__enable_frontedit
FROM (`exp_channel_fields` as ee_m_ChannelField_channel_fields)
LEFT JOIN `exp_channel_field_groups_fields` as ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields ON `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`field_id` = `ee_m_ChannelField_channel_fields`.`field_id`
WHERE `ee_m_ChannelFieldGroup_ee_m_ChannelField_channel_field_groups_fields`.`group_id` = '1'
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Addons/channel/mod.channel.php L:2175 ExpressionEngine\Model\Channel\Channel::getAllCustomFields()
-
SELECT DISTINCT(t.entry_id), t.entry_id, t.channel_id, t.forum_topic_id, t.author_id, t.ip_address, t.title, t.url_title, t.status, t.view_count_one, t.view_count_two, t.view_count_three, t.view_count_four, t.allow_comments, t.comment_expiration_date, t.sticky, t.entry_date, t.year, t.month, t.day, t.edit_date, t.expiration_date, t.recent_comment_date, t.comment_total, t.site_id as entry_site_id,
w.channel_title, w.channel_name, w.channel_url, w.comment_url, w.comment_moderate, w.channel_html_formatting, w.channel_allow_img_urls, w.channel_auto_link_urls, w.comment_system_enabled,
m.username, m.email, m.screen_name, m.signature, m.sig_img_filename, m.sig_img_width, m.sig_img_height, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.role_id, m.member_id,
wd.*, exp_channel_data_field_137.field_id_137, exp_channel_data_field_137.field_ft_137 FROM exp_channel_titles AS t
LEFT JOIN exp_channels AS w ON t.channel_id = w.channel_id
LEFT JOIN exp_channel_data AS wd ON t.entry_id = wd.entry_id
LEFT JOIN exp_members AS m ON m.member_id = t.author_id LEFT JOIN exp_channel_data_field_137 ON t.entry_id = exp_channel_data_field_137.entry_id WHERE t.entry_id IN (91809,93048,107319,94797,94649)ORDER BY FIELD(t.entry_id, 91809,93048,107319,94797,94649)
#system/ee/legacy/libraries/Template.php L:1841 Channel::entries()
-
SELECT `exp_templates`.*, `exp_template_groups`.`group_name`
FROM (`exp_templates`)
JOIN `exp_template_groups` ON `exp_template_groups`.`group_id` = `exp_templates`.`group_id`
WHERE `exp_template_groups`.`site_id` = '1'
AND `exp_templates`.`template_name` = 'header'
AND `exp_template_groups`.`group_name` = 'embeds'
#system/ee/legacy/libraries/Template.php L:228 EE_Template::fetch_template()
-
SELECT GlobalVariable_global_variables.variable_id as GlobalVariable__variable_id, GlobalVariable_global_variables.site_id as GlobalVariable__site_id, GlobalVariable_global_variables.variable_name as GlobalVariable__variable_name, GlobalVariable_global_variables.variable_data as GlobalVariable__variable_data, GlobalVariable_global_variables.edit_date as GlobalVariable__edit_date
FROM (`exp_global_variables` as GlobalVariable_global_variables)
WHERE (
`GlobalVariable_global_variables`.`site_id` = '1'
OR `GlobalVariable_global_variables`.`site_id` = 0
)
LIMIT 18446744073709551615
#system/ee/ExpressionEngine/Service/Template/Variables/StandardGlobals.php L:43 ExpressionEngine\Model\Template\GlobalVariable::loadAll()
Aruba cruise beaches are among the best in the Caribbean because of their size and location.
Shore excursions abound for cruises that go to the Bahamas, especially to Nassau and Freeport.
Montego Bay in Jamaica offers visitors a wide variety of tourist attractions beyond just its famous beaches.
The Grand Turk cruise port is not in a city like most cruise ports but a cruise center built by Carnival.
The best times to visit Bonaire include nine full months of the year.
Seward may end many cruises to Alaska. But it makes up for its small size with big excursions.
Barbados visitors will find a busy commercialized island. But it also is full of great experiences.
Visitors to Dominica will find that hiking to waterfalls is one of the island’s most popular attractions.
The best time to cruise to New England depends on warmth or color.
The best time to cruise the Mississippi depends on passengers who want warm temperatures.
Mexican Riviera cruises begin at one of four major embarkation ports in California.