i had diahreaha 10 queries took 2584 ms NrQueryErrorAffectedNum. rowsTook (ms) 1SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`scratch_version_date`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE `Project`.`id` = 595850 LIMIT 1112351 2SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` = (595850) 0023 3SELECT COUNT(*) AS `count` FROM `blocked_ips` AS `BlockedIp` LEFT JOIN `users` AS `User` ON (`BlockedIp`.`user_id` = `User`.`id`) WHERE ip = 1252200227 1113 4SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content != '' 116 5SELECT COUNT(*) AS `count` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content = '' 1121 6SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE 1 = 1 3345 7SELECT COUNT( id ) AS count FROM `notifications` WHERE `to_user_id` = 234076 AND `status` = "UNREAD"1137 8SELECT COUNT( id ) AS count FROM `friend_requests` WHERE `to_id` = 234076 AND `status` = "pending" 1176 9SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 234076 LIMIT 1115 10SELECT `AdminTag`.`id`, `AdminTag`.`user_id`, `AdminTag`.`tag_id`, `AdminTag`.`status`, `AdminTag`.`timestamp`, `Tag`.`id`, `Tag`.`name`, `Tag`.`timestamp`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `admin_tags` AS `AdminTag` LEFT JOIN `tags` AS `Tag` ON (`AdminTag`.`tag_id` = `Tag`.`id`) LEFT JOIN `users` AS `User` ON (`AdminTag`.`user_id` = `User`.`id`) WHERE `AdminTag`.`status` = 'active' 777 carrots ilove carrots so much it made me happy
