MovableType管理画面が遅いのを何とかしたい その1 ブログ記事の作成画面

ブログ記事の作成画面が吐き出すSQLログを調べてみました。

画面表示が遅いと思ったら、ずいぶんとたくさんのSQLを発行していたんですね。。
(画面表示が遅い原因がこれらSQLにあるのかかどうかは、これから調査します。)

それにしても複雑ですなぁ。
120430  8:11:01     6 Query     SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allo
w_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive
_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_class, blog_convert_paras, blog_convert_p
aras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, b
log_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comm
ents, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_parent_id, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblog
s, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_theme_id
, blog_use_comment_confirmation, blog_use_revision, blog_welcome_msg, blog_words_in_excerpt
FROM mt_blog
WHERE (blog_id = '20')
LIMIT 1
                    6 Query     SELECT author_meta_type
FROM mt_author_meta
WHERE (author_meta_author_id = '1')
                    6 Query     SELECT author_meta_author_id, author_meta_type
FROM mt_author_meta
WHERE (author_meta_author_id = '1') AND (author_meta_type = 'favorite_blogs')
                    6 Query     SELECT author_meta_author_id, author_meta_type, author_meta_vchar, author_meta_vchar_idx, author_meta_vdatetime, author_meta_vdatetime_idx, author_meta_vinteger, author_meta_vint
eger_idx, author_meta_vfloat, author_meta_vfloat_idx, author_meta_vblob, author_meta_vclob
FROM mt_author_meta
WHERE (author_meta_author_id = '1') AND (author_meta_type = 'favorite_blogs')
LIMIT 1
                    6 Query     SELECT blog_id
FROM mt_blog
WHERE (blog_class = 'blog') AND (blog_parent_id = '20')
                    6 Query     SELECT blog_id, blog_allow_anon_comments, blog_allow_comment_html, blog_allow_commenter_regist, blog_allow_comments_default, blog_allow_pings, blog_allow_pings_default, blog_allow_reg_comments, blog_allow_unreg_comments, blog_archive_path, blog_archive_tmpl_category, blog_archive_tmpl_daily, blog_archive_tmpl_individual, blog_archive_tmpl_monthly, blog_archive_tmpl_weekly, blog_archive_type, blog_archive_type_preferred, blog_archive_url, blog_autodiscover_links, blog_autolink_urls, blog_basename_limit, blog_cc_license, blog_children_modified_on, blog_class, blog_convert_paras, blog_convert_paras_comments, blog_created_by, blog_created_on, blog_custom_dynamic_templates, blog_days_on_index, blog_description, blog_email_new_comments, blog_email_new_pings, blog_entries_on_index, blog_file_extension, blog_google_api_key, blog_internal_autodiscovery, blog_is_dynamic, blog_junk_folder_expiry, blog_junk_score_threshold, blog_language, blog_manual_approve_commenters, blog_moderate_pings, blog_moderate_unreg_comments, blog_modified_by, blog_modified_on, blog_mt_update_key, blog_name, blog_old_style_archive_links, blog_parent_id, blog_ping_blogs, blog_ping_google, blog_ping_others, blog_ping_technorati, blog_ping_weblogs, blog_remote_auth_token, blog_require_comment_emails, blog_sanitize_spec, blog_server_offset, blog_site_path, blog_site_url, blog_sort_order_comments, blog_sort_order_posts, blog_status_default, blog_theme_id, blog_use_comment_confirmation, blog_use_revision, blog_welcome_msg, blog_words_in_excerpt
FROM mt_blog
WHERE (blog_id = '20')
LIMIT 1
                    6 Query     SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id IN ('0','20'))
                    6 Query     SELECT permission_id, permission_author_id, permission_blog_id, permission_blog_prefs, permission_created_by, permission_created_on, permission_entry_prefs, permission_modified_by, permission_modified_on, permission_page_prefs, permission_permissions, permission_restrictions, permission_role_mask, permission_template_prefs
FROM mt_permission
WHERE (permission_id IN ('15'))
                    6 Query     SELECT author_meta_author_id, author_meta_type
FROM mt_author_meta
WHERE (author_meta_author_id = '1') AND (author_meta_type = 'favorite_websites')
                    6 Query     SELECT author_meta_author_id, author_meta_type, author_meta_vchar, author_meta_vchar_idx, author_meta_vdatetime, author_meta_vdatetime_idx, author_meta_vinteger, author_meta_vinteger_idx, author_meta_vfloat, author_meta_vfloat_idx, author_meta_vblob, author_meta_vclob
FROM mt_author_meta
WHERE (author_meta_author_id = '1') AND (author_meta_type = 'favorite_websites')
LIMIT 1
                    6 Query     SELECT blog_id
FROM mt_blog
WHERE (blog_class = 'blog') AND (blog_parent_id >0)
LIMIT 6
                    6 Query     SELECT blog_id
FROM mt_blog
WHERE (blog_id IN ('20'))
                    6 Query     SELECT blog_id
FROM mt_blog
WHERE (blog_class = 'website') AND (blog_id NOT IN ('20','20'))
LIMIT 2
                    6 Query     SELECT blog_id
FROM mt_blog
WHERE (blog_class = 'blog') AND (blog_parent_id = '20')
                    6 Query     SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id IN ('20','5'))
                    6 Query     SELECT permission_id
FROM mt_permission
WHERE (permission_author_id = '1') AND (permission_blog_id IN ('20','5'))
                    6 Query     SELECT plugindata_id
FROM mt_plugindata
WHERE (plugindata_plugin = 'Zemanta') AND (plugindata_key = 'configuration:blog:5')
LIMIT 1
                    6 Query     SELECT plugindata_id, plugindata_data, plugindata_key, plugindata_plugin
FROM mt_plugindata
WHERE (plugindata_id IN ('126'))
120430  8:11:02     6 Quit
カテゴリ:

人気記事