I’m at the performance tweaking stage of a project. We use an exp query for “locations” in the page footer with the disable parameter for member_data.
But viewing Output Profiler, it looks (to me) that the query is selecting member data (avatar, bio, bday…).
Am I reading Output Profiler correctly? Is this OK or am I having an issue?
This is the exp query:
{exp:channel:entries channel="locations" orderby="title" sort="asc" disable="categories|member_data|pagination"}
<a href="http://{site_url}locations/">{title}</a>
{address1}
{if address2}{address2}{/if}
{city}, {state} {zipcode}
{/exp:channel:entries}And this is what I’m seeing in Output Profiler.
SELECT channel_id FROM exp_channels WHERE channel_name = 'locations'
0.0020 SELECT t.entry_id FROM exp_channel_titles AS t
LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND t.entry_date < 1346160638 AND (t.expiration_date = 0 OR t.expiration_date > 1346160638) AND t.channel_id = '33' AND t.status = 'open' ORDER BY t.sticky desc, t.title asc, t.entry_id asc LIMIT 0, 100
0.0012 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.dst_enabled, 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.url, m.screen_name, m.location, m.occupation, m.interests, m.aol_im, m.yahoo_im, m.msn_im, m.icq, 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.group_id, m.member_id, m.bday_d, m.bday_m, m.bday_y, m.bio,
md.*,
wd.*
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_member_data AS md ON md.member_id = m.member_id WHERE t.entry_id IN (271,273,272) ORDER BY t.sticky desc, t.title asc, t.entry_id asc