Ticket #4060: slow_snip.txt

SELECT DISTINCT u.ID as id, u.user_registered, u.user_nicename, u.user_login, u.display_name, u.user_email , um.meta_value as last_activity FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID WHERE u.user_status = 0 AND um.meta_key = 'last_activity' ORDER BY um.meta_value DESC LIMIT 0, 24;
# Time: 120305  8:00:09
# User@Host: [deleted]
# Query_time: 7.912240  Lock_time: 0.000120 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_options` SET `option_value` = '23138' WHERE `option_name` = 'membership_communication_last_user_processed';
# User@Host: [deleted]
# Query_time: 6.931275  Lock_time: 0.000084 Rows_sent: 1  Rows_examined: 1
SET timestamp=1330956009;
SELECT * FROM wp_users WHERE ID = 26216 LIMIT 1;
# User@Host: [deleted]
# Query_time: 6.926485  Lock_time: 0.000045 Rows_sent: 1  Rows_examined: 1
SET timestamp=1330956009;
SELECT * FROM wp_users WHERE ID = 26556 LIMIT 1;
# User@Host: [deleted]
# Query_time: 6.922382  Lock_time: 0.000032 Rows_sent: 1  Rows_examined: 1
SET timestamp=1330956009;
SELECT * FROM wp_users WHERE ID = 26305 LIMIT 1;
# User@Host: [deleted]
# Query_time: 5.646373  Lock_time: 0.000104 Rows_sent: 1  Rows_examined: 1
SET timestamp=1330956009;
SELECT * FROM wp_users WHERE user_login = 'sixcentz';
# User@Host: [deleted]
# Query_time: 7.048709  Lock_time: 0.000033 Rows_sent: 1  Rows_examined: 34
SET timestamp=1330956009;
SELECT * FROM wp_usermeta WHERE user_id = 23164 AND meta_key LIKE 'start_current_%';
# User@Host: [deleted]
# Query_time: 6.073389  Lock_time: 0.000103 Rows_sent: 10  Rows_examined: 10
SET timestamp=1330956009;
SELECT option_name AS name, option_value AS value FROM wp_options WHERE option_name IN ('bp-deactivated-components','bp-blogs-first-install','bp-disable-blog-forum-comments','bp-xprofile-base-group-name','bp-xprofile-fullname-field-name','bp-disable-profile-sync','bp-disable-avatar-uploads','bp-disable-account-deletion','bp-disable-forum-directory','bp-disable-blogforum-comments','bb-config-location','hide-loggedout-adminbar','user-avatar-default','tags_blog_id','registration','fileupload_maxk');
# User@Host: [deleted]
# Query_time: 7.587342  Lock_time: 0.000046 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_adrotate_stats_tracker` SET `impressions` = `impressions` + 1 WHERE `id` = '741';
# User@Host: [deleted]
# Query_time: 7.578059  Lock_time: 0.000055 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_adrotate_stats_tracker` SET `impressions` = `impressions` + 1 WHERE `id` = '740';
# User@Host: [deleted]
# Query_time: 7.318937  Lock_time: 0.000049 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_options` SET `option_value` = '23163' WHERE `option_name` = 'membership_communication_last_user_processed';
# User@Host: [deleted]
# Query_time: 7.299126  Lock_time: 0.000042 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_options` SET `option_value` = '23163' WHERE `option_name` = 'membership_communication_last_user_processed';
# User@Host: [deleted]
# Query_time: 7.071989  Lock_time: 0.000049 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_options` SET `option_value` = '23138' WHERE `option_name` = 'membership_communication_last_user_processed';
# User@Host: [deleted]
# Query_time: 7.916475  Lock_time: 0.000285 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;
UPDATE `wp_options` SET `option_value` = 'a:5:{i:0;b:0;s:48:\"bp-profile-privacy/bp-profile-privacy-loader.php\";s:28:\"bp_profile_privacy_uninstall\";s:25:\"buddyvents/buddyvents.php\";a:2:{i:0;O:12:\"EVENT_Loader\":11:{s:7:\"version\";s:3:\"1.6\";s:9:\"dbversion\";s:3:\"2.0\";s:6:\"min_wp\";s:5:\"3.0.1\";s:6:\"min_bp\";s:5:\"1.2.6\";s:7:\"min_php\";s:5:\"5.0.0\";s:8:\"home_url\";s:21:\"http://shabushabu.eu/\";s:11:\"plugin_name\";s:25:\"buddyvents/buddyvents.php\";s:5:\"admin\";N;s:7:\"options\";O:8:\"stdClass\":65:{s:10:\"week_start\";s:1:\"7\";s:10:\"clock_type\";s:2:\"12\";s:14:\"enable_address\";b:0;s:14:\"approve_events\";b:1;s:12:\"map_location\";a:2:{s:3:\"lat\";s:1:\"5\";s:3:\"lng\";s:2:\"30\";}s:14:\"map_zoom_level\";s:1:\"1\";s:8:\"map_type\";s:6:\"HYBRID\";s:17:\"restrict_creation\";b:0;s:13:\"enable_oembed\";b:1;s:4:\"slug\";s:6:\"events\";s:11:\"active_slug\";s:6:\"active\";s:12:\"archive_slug\";s:7:\"archive\";s:10:\"month_slug\";s:5:\"month\";s:8:\"day_slug\";s:3:\"day\";s:13:\"calendar_slug\";s:8:\"calendar\";s:8:\"map_slug\";s:3:\"map\";s:14:\"attending_slug\";s:9:\"attending\";s:11:\"create_slug\";s:6:\"create\";s:11:\"invite_slug\";s:6:\"invite\";s:13:\"schedule_slug\";s:8:\"schedule\";s:9:\"edit_slug\";s:4:\"edit\";s:13:\"category_slug\";s:8:\"category\";s:13:\"attendee_slug\";s:9:\"attendees\";s:15:\"directions_slug\";s:10:\"directions\";s:11:\"search_slug\";s:6:\"search\";s:12:\"results_slug\";s:7:\"results\";s:9:\"list_slug\";s:4:\"list\";s:9:\"grid_slug\";s:4:\"grid\";s:9:\"view_slug\";s:4:\"view\";s:9:\"feed_slug\";s:4:\"feed\";s:8:\"api_slug\";s:3:\"api\";s:12:\"api_key_slug\";s:6:\"apikey\";s:14:\"default_avatar\";a:2:{s:3:\"mid\";s:71:\"/wp-content/uploads/events/1/1296543206-1296455365-bc_nopic-mid-mid.jpg\";s:4:\"mini\";s:72:\"/wp-content/uploads/events/1/1296543206-1296455365-bc_nopic-mid-mini.jpg\";}s:12:\"default_view\";s:4:\"list\";s:6:\"system\";s:1:\"m\";s:8:\"field_id\";s:0:\"\";s:9:\"timestamp\";s:6:\"-1 day\";s:19:\"enable_achievements\";b:0;s:17:\"enable_directions\";b:1;s:10:\"enable_api\";b:0;s:11:\"default_tab\";s:6:\"active\";s:11:\"date_format\";s:6:\"F j, Y\";s:16:\"deactivated_tabs\";a:5:{s:7:\"archive\";s:7:\"archive\";s:8:\"calendar\";s:8:\"calendar\";s:3:\"map\";s:3:\"map\";s:6:\"search\";s:6:\"search\";s:6:\"create\";s:6:\"create\";}s:21:\"default_tab_attending\";b:0;s:8:\"map_lang\";s:0:\"\";s:9:\"ical_tzid\";s:13:\"Europe/Berlin\";s:15:\"localize_months\";b:0;s:9:\"tab_order\";a:2:{s:6:\"active\";i:1;s:9:\"attending\";i:3;}s:13:\"backend_order\";a:7:{s:6:\"active\";i:1;s:7:\"archive\";i:2;s:9:\"attending\";i:3;s:8:\"calendar\";i:4;s:3:\"map\";i:5;s:6:\"create\";i:6;s:6:\"search\";i:7;}s:16:\"enable_api_check\";b:0;s:23:\"enable_api_domain_check\";b:0;s:17:\"restrict_api_hits\";s:2:\"10\";s:21:\"restrict_api_timespan\";s:4:\"3600\";s:14:\"enable_twitter\";b:0;s:20:\"twitter_consumer_key\";s:0:\"\";s:23:\"twitter_consumer_secret\";s:0:\"\";s:11:\"bitly_login\";s:0:\"\";s:9:\"bitly_key\";s:0:\"\";s:15:\"enable_facebook\";b:0;s:14:\"facebook_appid\";s:0:\"\";s:15:\"facebook_secret\";s:0:\"\";s:16:\"use_event_images\";b:0;s:17:\"enable_eventbrite\";b:0;s:17:\"eventbrite_appkey\";s:0:\"\";s:3:\"img\";s:0:\"\";}s:6:\"tables\";O:8:\"stdClass\":8:{s:6:\"events\";s:13:\"wp_bpe_events\";s:7:\"members\";s:14:\"wp_bpe_members\";s:9:\"schedules\";s:16:\"wp_bpe_schedules\";s:11:\"events_meta\";s:17:\"wp_bpe_event_meta\";s:10:\"categories\";s:23:\"wp_bpe_event_categories\";s:6:\"coords\";s:14:\"wp_mapo_coords\";s:13:\"notifications\";s:20:\"wp_bpe_notifications\";s:3:\"api\";s:10:\"wp_bpe_api\";}s:6:\"config\";O:8:\"stdClass\":3:{s:10:\"bp_enabled\";b:1;s:11:\"view_styles\";a:2:{i:0;s:4:\"list\";i:1;s:4:\"grid\";}s:15:\"forbidden_slugs\";a:13:{i:0;s:6:\"create\";i:1;s:4:\"edit\";i:2;s:8:\"calendar\";i:3;s:3:\"map\";i:4;s:8:\"category\";i:5;s:7:\"archive\";i:6;s:6:\"active\";i:7;s:5:\"month\";i:8;s:3:\"day\";i:9;s:4:\"view\";i:10;s:4:\"feed\";i:11;s:6:\"apikey\";i:12;s:3:\"api\";}}}i:1;s:9:\"uninstall\";}s:33:\"bp-xtra-signup/bp-xtra-signup.php\";a:2:{i:0;O:11:\"BPXS_Loader\":8:{s:7:\"version\";s:3:\"1.6\";s:6:\"min_wp\";s:3:\"3.0\";s:6:\"min_bp\";s:3:\"1.2\";s:7:\"min_php\";s:5:\"5.0.0\";s:8:\"home_url\";s:21:\"http://shabushabu.eu/\";s:11:\"plugin_name\";s:33:\"bp-xtra-signup/bp-xtra-signup.php\";s:10:\"bpxs_admin\";O:17:\"BPXS_Admin_Loader\":0:{}s:7:\"options\";O:8:\"stdClass\":18:{s:3:\"tos\";b:1;s:18:\"email_confirmation\";b:0;s:10:\"newsletter\";b:0;s:12:\"psw_strength\";b:0;s:14:\"u_availability\";b:1;s:11:\"email_check\";b:0;s:13:\"date_of_birth\";b:1;s:9:\"dob_field\";s:1:\"2\";s:7:\"dob_age\";s:2:\"18\";s:13:\"mcapi_list_id\";s:0:\"\";s:9:\"mcapi_key\";s:0:\"\";s:12:\"signup_title\";s:13:\"Don\\\'t forget\";s:15:\"newsletter_text\";s:67:\"Uncheck this box if you do not want to subscribe to our newsletter.\";s:8:\"tos_text\";s:92:\"Please make sure to read our {url}Terms of Service{/url} and then check this box (required).\";s:14:\"tos_error_text\";s:51:\"You have to check our Terms Of Service to continue.\";s:15:\"email_recipient\";s:25:\"christophersturner@me.com\";s:13:\"email_subject\";s:30:\"Unsuccessful newsletter signup\";s:13:\"email_message\";s:314:\"Hello,\r\n   \r\nthere has been an error with a new subscriber to your newsletter! Check the error and send a message to the user if signup to the newsletter has been unsuccessful.\r\n\r\nUnable to load listSubscribe()!\r\n\r\nUserID: {USER_ID}\r\nName: {USER_NAME}\r\nEmail: {USER_EMAIL}\r\n\r\nCode: {ERROR_CODE}\r\nMsg: {ERROR_MESSAGE}\";}}i:1;s:9:\"uninstall\";}s:21:\"adrotate/adrotate.php\";s:18:\"adrotate_uninstall\";}' WHERE `option_name` = 'uninstall_plugins';
# User@Host: [deleted]
# Query_time: 7.598616  Lock_time: 0.000053 Rows_sent: 0  Rows_examined: 1
SET timestamp=1330956009;