70 |
0.0005 |
SELECT * FROM `roster_account` ORDER BY `account_id` DESC; |
1083 |
0.0006 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '22' ORDER BY `id` ASC; |
23 |
0.0008 |
SELECT `guild_id`, `guild_name` AS `Name` FROM `roster_guild` as guild |
36 |
0.002 |
SELECT `guild_id`, `member_id`, `name` AS `Name`, `note` AS `Note`, `officer_note` AS `OfficerNote` FROM `roster_members` as members |
95 |
0.0005 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 1; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '4'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=4 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='4' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '4', `main_id` = '4', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '4' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '5'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=5 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='5' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '5', `main_id` = '5', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '5' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '10'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=10 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='10' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '10', `main_id` = '10', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '10' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '11'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=11 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='11' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '11', `main_id` = '11', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '11' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '12'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=12 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='12' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '12', `main_id` = '12', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '12' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '15'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=15 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='15' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '15', `main_id` = '15', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '15' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '18'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=18 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='18' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '18', `main_id` = '18', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '18' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '19'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=19 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='19' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '19', `main_id` = '19', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '19' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '21'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=21 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='21' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '21', `main_id` = '21', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '21' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '22'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=22 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='22' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '22', `main_id` = '22', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '22' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '28'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=28 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='28' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '28', `main_id` = '28', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '28' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '30'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=30 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='30' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '30', `main_id` = '30', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '30' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '36'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Evillotjuh' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=10 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='36' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '36', `main_id` = '10', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '36' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '45'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=45 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='45' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '45', `main_id` = '45', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '45' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '47'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=47 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='47' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '47', `main_id` = '47', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '47' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '48'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=48 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='48' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '48', `main_id` = '48', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '48' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '49'; |
253 |
0.0008 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Rugor' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=28 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='49' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '49', `main_id` = '28', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '49' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '52'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=52 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='52' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '52', `main_id` = '52', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '52' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '57'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=57 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='57' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '57', `main_id` = '57', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '57' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '58'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=58 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='58' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '58', `main_id` = '58', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '58' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '61'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Garukh' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=188 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='61' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '61', `main_id` = '188', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '61' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '62'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=62 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='62' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '62', `main_id` = '62', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '62' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '63'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=63 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='63' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '63', `main_id` = '63', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '63' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '64'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=64 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='64' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '64', `main_id` = '64', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '64' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '65'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Evillotjuh' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=10 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='65' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '65', `main_id` = '10', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '65' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '67'; |
253 |
0.0008 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Aureact' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=48 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='67' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '67', `main_id` = '48', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '67' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '68'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Zhurox' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=64 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='68' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '68', `main_id` = '64', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '68' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '70'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Cerlion' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=62 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='70' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '70', `main_id` = '62', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '70' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '76'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=76 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='76' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '76', `main_id` = '76', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '76' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '80'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Rugor' |
275 |
0.0003 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=28 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='80' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '80', `main_id` = '28', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '80' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '81'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=81 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='81' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '81', `main_id` = '81', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '81' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '83'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=83 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='83' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '83', `main_id` = '83', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '83' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '84'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=84 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='84' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '84', `main_id` = '84', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '84' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '90'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=90 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='90' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '90', `main_id` = '90', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '90' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '91'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Ranubis' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=12 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='91' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '91', `main_id` = '12', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '91' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '94'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=94 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='94' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '94', `main_id` = '94', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '94' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '96'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Evillotjuh' |
275 |
0.0003 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=10 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='96' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '96', `main_id` = '10', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '96' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '101'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Oho' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=30 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='101' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '101', `main_id` = '30', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '101' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '102'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Cerlion' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=62 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='102' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '102', `main_id` = '62', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '102' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '108'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Cerlion' |
275 |
0.0003 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=62 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='108' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '108', `main_id` = '62', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '108' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '103'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=103 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='103' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '103', `main_id` = '103', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '103' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '129'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=129 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='129' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '129', `main_id` = '129', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '129' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '141'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=141 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='141' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '141', `main_id` = '141', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '141' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '158'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=158 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='158' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '158', `main_id` = '158', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '158' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '115'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Rugor' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=28 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='115' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '115', `main_id` = '28', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '115' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '122'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Owthathurt' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=57 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='122' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '122', `main_id` = '57', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '122' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '189'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Missbovine' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=22 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='189' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '189', `main_id` = '22', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '189' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '148'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=148 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='148' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '148', `main_id` = '148', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '148' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '159'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Selenne' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=15 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='159' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '159', `main_id` = '15', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '159' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '190'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Luniatic' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=194 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='190' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '190', `main_id` = '194', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '190' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '143'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Grimmjow' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=81 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='143' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '143', `main_id` = '81', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '143' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '139'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=139 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='139' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '139', `main_id` = '139', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '139' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '142'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=142 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='142' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '142', `main_id` = '142', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '142' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '184'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Kaeden' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=147 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='184' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '184', `main_id` = '147', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '184' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '233'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Centaurion' |
275 |
0.0007 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=103 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='233' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '233', `main_id` = '103', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '233' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '152'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=152 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='152' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '152', `main_id` = '152', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '152' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '154'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=154 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='154' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '154', `main_id` = '154', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '154' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '155'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Kaeden' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=147 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='155' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '155', `main_id` = '147', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '155' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '156'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Inidra' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=11 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='156' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '156', `main_id` = '11', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '156' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '157'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Jitterbugged' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=83 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='157' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '157', `main_id` = '83', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '157' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '162'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=162 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='162' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '162', `main_id` = '162', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '162' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '166'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Egamil' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=52 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='166' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '166', `main_id` = '52', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '166' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '188'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=188 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='188' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '188', `main_id` = '188', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '188' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '175'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=175 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='175' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '175', `main_id` = '175', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '175' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '173'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Munck' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=138 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='173' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '173', `main_id` = '138', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '173' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '177'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=177 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='177' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '177', `main_id` = '177', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '177' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '196'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=196 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='196' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '196', `main_id` = '196', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '196' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '179'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=179 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='179' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '179', `main_id` = '179', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '179' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '204'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=204 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='204' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '204', `main_id` = '204', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '204' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '186'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Eucalyptus' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=139 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='186' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '186', `main_id` = '139', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '186' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '194'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=194 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='194' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '194', `main_id` = '194', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '194' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '187'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Danz' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=90 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='187' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '187', `main_id` = '90', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '187' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '209'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=209 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='209' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '209', `main_id` = '209', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '209' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '192'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=192 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='192' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '192', `main_id` = '192', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '192' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '197'; |
253 |
0.0008 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Gorgonnoth' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=175 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='197' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '197', `main_id` = '175', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '197' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '217'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=217 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='217' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '217', `main_id` = '217', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '217' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '200'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=200 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='200' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '200', `main_id` = '200', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '200' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '202'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=202 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='202' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '202', `main_id` = '202', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '202' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '218'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=218 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='218' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '218', `main_id` = '218', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '218' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '206'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Robson' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=192 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='206' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '206', `main_id` = '192', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '206' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '207'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Grong' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=4 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='207' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '207', `main_id` = '4', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '207' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '231'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=231 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='231' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '231', `main_id` = '231', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '231' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '220'; |
221 |
0.0007 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=220 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='220' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '220', `main_id` = '220', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '220' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '210'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Tenzhou' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=21 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='210' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '210', `main_id` = '21', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '210' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '211'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Gorgonnoth' |
275 |
0.0003 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=175 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='211' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '211', `main_id` = '175', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '211' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '216'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Gorgonnoth' |
275 |
0.0003 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=175 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='216' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '216', `main_id` = '175', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '216' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '212'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Norgeerbest' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=213 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='212' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '212', `main_id` = '213', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '212' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '213'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=213 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='213' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '213', `main_id` = '213', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '213' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '228'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=228 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='228' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '228', `main_id` = '228', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '228' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '221'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Madara' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=204 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='221' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '221', `main_id` = '204', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '221' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '222'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=222 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='222' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '222', `main_id` = '222', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '222' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '224'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Stanhope' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=202 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='224' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '224', `main_id` = '202', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '224' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '225'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Bloodface' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=141 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='225' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '225', `main_id` = '141', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '225' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '226'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Edenia' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=200 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='226' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '226', `main_id` = '200', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '226' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '229'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Cerlion' |
275 |
0.0003 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=62 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='229' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '229', `main_id` = '62', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '229' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '241'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=241 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='241' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '241', `main_id` = '241', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '241' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '234'; |
253 |
0.0008 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Sanguiine' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=179 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='234' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '234', `main_id` = '179', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '234' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '243'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=243 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='243' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '243', `main_id` = '243', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '243' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '237'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Garukh' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=188 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='237' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '237', `main_id` = '188', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '237' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '236'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Luniatic' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=194 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='236' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '236', `main_id` = '194', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '236' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '238'; |
221 |
0.0006 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=238 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='238' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '238', `main_id` = '238', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '238' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '289'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Zhurox' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=64 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='289' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '289', `main_id` = '64', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '289' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '247'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Benv' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=63 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='247' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '247', `main_id` = '63', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '247' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '239'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Toern' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=222 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='239' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '239', `main_id` = '222', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '239' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '240'; |
253 |
0.0008 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Ãawn' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=241 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='240' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '240', `main_id` = '241', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '240' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '290'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=290 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='290' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '290', `main_id` = '290', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '290' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '242'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=242 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='242' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '242', `main_id` = '242', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '242' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '244'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=244 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='244' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '244', `main_id` = '244', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '244' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '245'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=245 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='245' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '245', `main_id` = '245', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '245' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '246'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=246 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='246' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '246', `main_id` = '246', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '246' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '308'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Trejne' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=58 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='308' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '308', `main_id` = '58', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '308' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '260'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=260 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='260' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '260', `main_id` = '260', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '260' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '310'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=310 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='310' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '310', `main_id` = '310', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '310' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '262'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=262 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='262' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '262', `main_id` = '262', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '262' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '307'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Xzudike' |
275 |
0.0006 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=76 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='307' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '307', `main_id` = '76', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '307' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '309'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=309 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='309' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '309', `main_id` = '309', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '309' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '315'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Qeldor' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=158 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='315' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '315', `main_id` = '158', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '315' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '323'; |
253 |
0.0004 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Madara' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=204 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='323' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '323', `main_id` = '204', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '323' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '324'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=324 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='324' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '324', `main_id` = '324', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '324' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '325'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Rotgar' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=220 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='325' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '325', `main_id` = '220', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '325' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '326'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Lazaro' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=324 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='326' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '326', `main_id` = '324', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '326' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '327'; |
253 |
0.0007 |
SELECT `members`.`member_id`, `members`.`name` FROM `roster_members` as `members` WHERE `members`.`name`='Finchy' |
275 |
0.0004 |
SELECT `member_id`, `main_id`, `alt_type` FROM `roster_addons_memberslist_alts` WHERE `member_id`=18 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='327' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '327', `main_id` = '18', `alt_type` = 'ALTMONITOR_ALT_WITH_MAIN' WHERE `member_id` = '327' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 17; |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '317'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=317 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='317' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '317', `main_id` = '317', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '317' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 5; |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '261'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=261 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='261' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '261', `main_id` = '261', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '261' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 2; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '110'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=110 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='110' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '110', `main_id` = '110', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '110' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '112'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=112 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='112' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '112', `main_id` = '112', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '112' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '113'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=113 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='113' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '113', `main_id` = '113', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '113' |
157 |
0.0004 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '116'; |
221 |
0.0003 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=116 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='116' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '116', `main_id` = '116', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '116' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '117'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=117 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='117' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '117', `main_id` = '117', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '117' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '119'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=119 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='119' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '119', `main_id` = '119', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '119' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '120'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=120 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='120' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '120', `main_id` = '120', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '120' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '121'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=121 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='121' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '121', `main_id` = '121', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '121' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '123'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=123 |
386 |
0.0003 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='123' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '123', `main_id` = '123', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '123' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '125'; |
221 |
0.0004 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=125 |
386 |
0.0004 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='125' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '125', `main_id` = '125', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '125' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 3; |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '9'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=9 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='9' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '9', `main_id` = '9', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '9' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '31'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=31 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='31' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '31', `main_id` = '31', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '31' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '53'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=53 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='53' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '53', `main_id` = '53', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '53' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '78'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=78 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='78' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '78', `main_id` = '78', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '78' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '79'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=79 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='79' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '79', `main_id` = '79', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '79' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '99'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=99 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='99' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '99', `main_id` = '99', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '99' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '104'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=104 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='104' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '104', `main_id` = '104', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '104' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '109'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=109 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='109' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '109', `main_id` = '109', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '109' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '105'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=105 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='105' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '105', `main_id` = '105', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '105' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '126'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=126 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='126' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '126', `main_id` = '126', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '126' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '150'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=150 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='150' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '150', `main_id` = '150', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '150' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '111'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=111 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='111' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '111', `main_id` = '111', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '111' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '114'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=114 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='114' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '114', `main_id` = '114', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '114' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '118'; |
221 |
0.0012 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=118 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='118' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '118', `main_id` = '118', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '118' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '124'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=124 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='124' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '124', `main_id` = '124', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '124' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '130'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=130 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='130' |
408 |
0.0008 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '130', `main_id` = '130', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '130' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '138'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=138 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='138' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '138', `main_id` = '138', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '138' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '191'; |
221 |
0.0014 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=191 |
386 |
0.0007 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='191' |
408 |
0.0009 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '191', `main_id` = '191', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '191' |
157 |
0.0008 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '140'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=140 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='140' |
408 |
0.0043 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '140', `main_id` = '140', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '140' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '171'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=171 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='171' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '171', `main_id` = '171', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '171' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '145'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=145 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='145' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '145', `main_id` = '145', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '145' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '147'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=147 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='147' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '147', `main_id` = '147', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '147' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '168'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=168 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='168' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '168', `main_id` = '168', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '168' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '164'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=164 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='164' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '164', `main_id` = '164', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '164' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '161'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=161 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='161' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '161', `main_id` = '161', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '161' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '170'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=170 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='170' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '170', `main_id` = '170', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '170' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '182'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=182 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='182' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '182', `main_id` = '182', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '182' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '248'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=248 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='248' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '248', `main_id` = '248', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '248' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '183'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=183 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='183' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '183', `main_id` = '183', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '183' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '199'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=199 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='199' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '199', `main_id` = '199', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '199' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '205'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=205 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='205' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '205', `main_id` = '205', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '205' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '201'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=201 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='201' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '201', `main_id` = '201', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '201' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '193'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=193 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='193' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '193', `main_id` = '193', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '193' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '195'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=195 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='195' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '195', `main_id` = '195', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '195' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '198'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=198 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='198' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '198', `main_id` = '198', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '198' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '203'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=203 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='203' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '203', `main_id` = '203', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '203' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '215'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=215 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='215' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '215', `main_id` = '215', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '215' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '208'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=208 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='208' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '208', `main_id` = '208', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '208' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '219'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=219 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='219' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '219', `main_id` = '219', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '219' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '214'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=214 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='214' |
408 |
0.0016 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '214', `main_id` = '214', `alt_type` = 'ALTMONITOR_MAIN_ALTS' WHERE `member_id` = '214' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '227'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=227 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='227' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '227', `main_id` = '227', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '227' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '223'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=223 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='223' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '223', `main_id` = '223', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '223' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '232'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=232 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='232' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '232', `main_id` = '232', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '232' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '306'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=306 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='306' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '306', `main_id` = '306', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '306' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '230'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=230 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='230' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '230', `main_id` = '230', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '230' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '235'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=235 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='235' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '235', `main_id` = '235', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '235' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '294'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=294 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='294' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '294', `main_id` = '294', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '294' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '249'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=249 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='249' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '249', `main_id` = '249', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '249' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '250'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=250 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='250' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '250', `main_id` = '250', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '250' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '251'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=251 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='251' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '251', `main_id` = '251', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '251' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '252'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=252 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='252' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '252', `main_id` = '252', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '252' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '253'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=253 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='253' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '253', `main_id` = '253', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '253' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '254'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=254 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='254' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '254', `main_id` = '254', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '254' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '255'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=255 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='255' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '255', `main_id` = '255', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '255' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '256'; |
221 |
0.0011 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=256 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='256' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '256', `main_id` = '256', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '256' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '257'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=257 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='257' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '257', `main_id` = '257', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '257' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '259'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=259 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='259' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '259', `main_id` = '259', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '259' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '263'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=263 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='263' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '263', `main_id` = '263', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '263' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '264'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=264 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='264' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '264', `main_id` = '264', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '264' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '267'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=267 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='267' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '267', `main_id` = '267', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '267' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '270'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=270 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='270' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '270', `main_id` = '270', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '270' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '271'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=271 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='271' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '271', `main_id` = '271', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '271' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '274'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=274 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='274' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '274', `main_id` = '274', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '274' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '275'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=275 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='275' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '275', `main_id` = '275', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '275' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '279'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=279 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='279' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '279', `main_id` = '279', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '279' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '280'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=280 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='280' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '280', `main_id` = '280', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '280' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '281'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=281 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='281' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '281', `main_id` = '281', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '281' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '282'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=282 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='282' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '282', `main_id` = '282', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '282' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '283'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=283 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='283' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '283', `main_id` = '283', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '283' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '284'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=284 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='284' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '284', `main_id` = '284', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '284' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '286'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=286 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='286' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '286', `main_id` = '286', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '286' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '287'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=287 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='287' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '287', `main_id` = '287', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '287' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '291'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=291 |
386 |
0.0007 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='291' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '291', `main_id` = '291', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '291' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '292'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=292 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='292' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '292', `main_id` = '292', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '292' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '295'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=295 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='295' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '295', `main_id` = '295', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '295' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '296'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=296 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='296' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '296', `main_id` = '296', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '296' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '297'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=297 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='297' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '297', `main_id` = '297', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '297' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '298'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=298 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='298' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '298', `main_id` = '298', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '298' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '301'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=301 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='301' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '301', `main_id` = '301', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '301' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '302'; |
221 |
0.0012 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=302 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='302' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '302', `main_id` = '302', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '302' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '304'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=304 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='304' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '304', `main_id` = '304', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '304' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '305'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=305 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='305' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '305', `main_id` = '305', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '305' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '312'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=312 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='312' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '312', `main_id` = '312', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '312' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '313'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=313 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='313' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '313', `main_id` = '313', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '313' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '314'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=314 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='314' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '314', `main_id` = '314', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '314' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '316'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=316 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='316' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '316', `main_id` = '316', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '316' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '318'; |
221 |
0.0011 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=318 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='318' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '318', `main_id` = '318', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '318' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '319'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=319 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='319' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '319', `main_id` = '319', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '319' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '320'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=320 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='320' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '320', `main_id` = '320', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '320' |
157 |
0.0008 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '321'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=321 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='321' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '321', `main_id` = '321', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '321' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '322'; |
221 |
0.0009 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=322 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='322' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '322', `main_id` = '322', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '322' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '328'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=328 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='328' |
408 |
0.0022 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '328', `main_id` = '328', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '329'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=329 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='329' |
408 |
0.0006 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '329', `main_id` = '329', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '330'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=330 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='330' |
408 |
0.0006 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '330', `main_id` = '330', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '332'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=332 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='332' |
408 |
0.0006 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '332', `main_id` = '332', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '333'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=333 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='333' |
408 |
0.0007 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '333', `main_id` = '333', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '334'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=334 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='334' |
408 |
0.0007 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '334', `main_id` = '334', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '335'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=335 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='335' |
408 |
0.0006 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '335', `main_id` = '335', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '336'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=336 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='336' |
408 |
0.0006 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '336', `main_id` = '336', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '337'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=337 |
386 |
0.0007 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='337' |
408 |
0.0007 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '337', `main_id` = '337', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 4; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '258'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=258 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='258' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '258', `main_id` = '258', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '258' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 6; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '265'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=265 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='265' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '265', `main_id` = '265', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '265' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '266'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=266 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='266' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '266', `main_id` = '266', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '266' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '311'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=311 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='311' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '311', `main_id` = '311', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '311' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 7; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '268'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=268 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='268' |
408 |
0.0007 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '268', `main_id` = '268', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '268' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '269'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=269 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='269' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '269', `main_id` = '269', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '269' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 8; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '272'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=272 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='272' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '272', `main_id` = '272', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '272' |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '273'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=273 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='273' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '273', `main_id` = '273', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '273' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 9; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '276'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=276 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='276' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '276', `main_id` = '276', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '276' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 10; |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '277'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=277 |
386 |
0.0005 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='277' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '277', `main_id` = '277', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '277' |
157 |
0.0006 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '278'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=278 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='278' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '278', `main_id` = '278', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '278' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 11; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '285'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=285 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='285' |
408 |
0.0006 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '285', `main_id` = '285', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '285' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 12; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '288'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=288 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='288' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '288', `main_id` = '288', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '288' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 13; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '293'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=293 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='293' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '293', `main_id` = '293', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '293' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 14; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '299'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=299 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='299' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '299', `main_id` = '299', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '299' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 15; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '300'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=300 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='300' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '300', `main_id` = '300', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '300' |
450 |
0.0021 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 16; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '303'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=303 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='303' |
408 |
0.0005 |
UPDATE `roster_addons_memberslist_alts` SET `member_id` = '303', `main_id` = '303', `alt_type` = 'ALTMONITOR_MAIN_NO_ALTS' WHERE `member_id` = '303' |
450 |
0.0025 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
95 |
0.0501 |
SELECT `config_name`, `config_value` FROM `roster_addons_memberslist_config_guild` WHERE `guild_id` = 18; |
157 |
0.0007 |
SELECT `alt`.*, `member`.`name` FROM `roster_members` member LEFT JOIN `roster_addons_memberslist_alts` alt ON `alt`.`member_id` = `member`.`member_id` WHERE `member`.`member_id` = '331'; |
221 |
0.001 |
SELECT COUNT(member_id) FROM `roster_addons_memberslist_alts` as `alts` WHERE `alts`.`main_id`=331 |
386 |
0.0006 |
SELECT `member_id` FROM `roster_addons_memberslist_alts` WHERE `member_id`='331' |
408 |
0.0016 |
INSERT INTO `roster_addons_memberslist_alts` SET `member_id` = '331', `main_id` = '331', `alt_type` = 'ALTMONITOR_MAIN_ALTS' |
450 |
0.0022 |
DELETE `roster_addons_memberslist_alts` FROM `roster_addons_memberslist_alts` LEFT JOIN `roster_members` USING (`member_id`) WHERE `roster_members`.`member_id` IS NULL |
414 |
0.0005 |
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 GROUP BY isalt, label; |
608 |
0.0008 |
SELECT `mb`.*, `a`.`basename` FROM `roster_menu_button` AS mb LEFT JOIN `roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1; |
625 |
0.0004 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`; |
36 |
0.0008 |
SELECT `member_id`, `name` FROM `roster_members` ORDER BY `name`; |
36 |
0.0018 |
SELECT `zone`, `quest_name` FROM `roster_quests` ORDER BY `quest_name`; |