gistfile1.txt

# Query_time: 5  Lock_time: 0  Rows_sent: 4477  Rows_examined: 37504
SELECT (users.id * 9 + 4) AS id, 0 AS id, '' AS authors, '' AS body, 'User' AS class, 4 AS class_id, '' AS comment, '' AS content, countries.name AS country_name, country_translations.name AS country_tname, '' AS dedicated_to, '' AS description, '' AS id_title, location.name AS location_name, location_translations.name AS location_tname, users.login AS login, '' AS name, '' AS stripped_content, '' AS thought_for, '' AS title, users.user_location_name AS user_location_name FROM users LEFT OUTER JOIN locations AS location ON location.id = users.location_id LEFT JOIN ( location_translations ) ON ( users.location_id = location_translations.location_id ) LEFT JOIN ( locations l2,countries ) ON ( users.location_id=l2.id and l2.country_id=countries.id ) LEFT JOIN (locations l3, country_translations) ON (users.location_id=l3.id and l3.country_id=country_translations.country_id ) WHERE users.id >= 5001 AND users.id <= 10000 AND (users.deleted_at is null AND users.activated_at is not null) GROUP BY users.id;
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 1
SELECT * FROM `locales`     WHERE (`locales`.`code` = 'en-US') AND (locales.deleted_at IS NULL OR locales.deleted_at > '2009-03-30 11:55:17')  LIMIT 1;
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT * FROM `user_attachments`     WHERE (`user_attachments`.user_id = 8892);
# User@Host: ideas4all[ideas4all] @ ifaws1 [10.20.0.126]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET insert_id=7714919;
INSERT INTO `site_activities` (`item_id`, `updated_at`, `site_activity_type_id`, `user_id`, `created_at`, `item_type`) VALUES(NULL, '2009-03-30 11:55:17', 3, 2912, '2009-03-30 11:55:17', NULL);
# Time: 090330  4:55:25
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]
# Query_time: 9  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
COMMIT;
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]
# Query_time: 4  Lock_time: 0  Rows_sent: 1  Rows_examined: 20902
SELECT id, language_id FROM `ideas`     WHERE (ideas.created_at > '2009-03-23 04:55:21' and ideas.hidden_by_selective_category = 0) AND ((ideas.deleted_at IS NULL OR ideas.deleted_at > '2009-03-30 11:55:21') AND (ideas.draft IS NULL))  LIMIT 1;
# User@Host: ideas4all[ideas4all] @ ifaws1 [10.20.0.126]
# Query_time: 9  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
COMMIT;
# Time: 090330  4:55:26
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]
# Query_time: 5  Lock_time: 0  Rows_sent: 4984  Rows_examined: 41357
SELECT (users.id * 9 + 4) AS id, 0 AS id, '' AS authors, '' AS body, 'User' AS class, 4 AS class_id, '' AS comment, '' AS content, countries.name AS country_name, country_translations.name AS country_tname, '' AS dedicated_to, '' AS description, '' AS id_title, location.name AS location_name, location_translations.name AS location_tname, users.login AS login, '' AS name, '' AS stripped_content, '' AS thought_for, '' AS title, users.user_location_name AS user_location_name FROM users LEFT OUTER JOIN locations AS location ON location.id = users.location_id LEFT JOIN ( location_translations ) ON ( users.location_id = location_translations.location_id ) LEFT JOIN ( locations l2,countries ) ON ( users.location_id=l2.id and l2.country_id=countries.id ) LEFT JOIN (locations l3, country_translations) ON (users.location_id=l3.id and l3.country_id=country_translations.country_id ) WHERE users.id >= 10001 AND users.id <= 15000 AND (users.deleted_at is null AND users.activated_at is not null) GROUP BY users.id;
# User@Host: ideas4all[ideas4all] @ ifaws1 [10.20.0.126]
# Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
COMMIT;
# Time: 090330  4:56:07
# User@Host: ideas4all[ideas4all] @ ifaws2 [10.20.0.125]
# Query_time: 4  Lock_time: 0  Rows_sent: 4477  Rows_examined: 37504
SELECT (users.id * 9 + 4) AS id, 0 AS id, '' AS authors, '' AS body, 'User' AS class, 4 AS class_id, '' AS comment, '' AS content, countries.name AS country_name, country_translations.name AS country_tname, '' AS dedicated_to, '' AS description, '' AS id_title, location.name AS location_name, location_translations.name AS location_tname, users.login AS login, '' AS name, '' AS stripped_content, '' AS thought_for, '' AS title, users.user_location_name AS user_location_name FROM users LEFT OUTER JOIN locations AS location ON location.id = users.location_id LEFT JOIN ( location_translations ) ON ( users.location_id = location_translations.location_id ) LEFT JOIN ( locations l2,countries ) ON ( users.location_id=l2.id and l2.country_id=countries.id ) LEFT JOIN (locations l3, country_translations) ON (users.location_id=l3.id and l3.country_id=country_translations.country_id ) WHERE users.id >= 5001 AND users.id <= 10000 AND (users.deleted_at is null AND users.activated_at is not null) GROUP BY users.id;
# Time: 090330  4:56:09
# User@Host: ideas4all[ideas4all] @ ifaws1 [10.20.0.126]
# Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
COMMIT;
# User@Host: ideas4all[ideas4all] @ ifaws1 [10.20.0.126]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
COMMIT;