| 152 |
0.0017 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
| 523 |
0.0007 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
| 365 |
0.0015 |
SELECT guild.*, members.*, players.*, DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 0 HOUR ), "%a %b %D, %l:%i %p" ) AS "update_format" FROM `roster_players` players LEFT JOIN `roster_members` members ON `players`.`member_id` = `members`.`member_id` LEFT JOIN `roster_guild` guild ON `players`.`guild_id` = `guild`.`guild_id` WHERE `players`.`member_id` = "10"; |
| 36 |
0.0008 |
SELECT `main_id` FROM `roster_addons_memberslist_alts` WHERE `member_id` = 10; |
| 46 |
0.0019 |
SELECT `m`.`name`, `m`.`level`, `m`.`class`, `a`.* FROM `roster_addons_memberslist_alts` AS a, `roster_players` AS m WHERE `a`.`member_id` = `m`.`member_id` AND `a`.`main_id` = 10; |
| 91 |
0.0024 |
SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`classid`, `members`.`level`, `members`.`guild_title`, `members`.`guild_rank`, `players`.`race`, `players`.`raceid`, `players`.`sex`, `players`.`sexid` FROM `roster_members` AS members LEFT JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` WHERE `members`.`guild_id` = "1" ORDER BY `members`.`level` DESC, `members`.`name` ASC |
| 1028 |
0.0014 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '3' ORDER BY `id` ASC; |
| 57 |
0.0011 |
SELECT * FROM `roster_addons_info_default`; |
| 65 |
0.0007 |
SELECT * FROM `roster_addons_info_display` WHERE `member_id` = '10'; |
| 2250 |
0.001 |
SELECT `skill_level` FROM `roster_skills` WHERE `member_id` = 10 AND `skill_name` = 'Defense'; |
| 2250 |
0.0007 |
SELECT `skill_level` FROM `roster_skills` WHERE `member_id` = 10 AND `skill_name` = 'Defense'; |
| 166 |
0.0008 |
SELECT * FROM `roster_buffs` WHERE `member_id` = '10'; |
| 1389 |
0.0016 |
SELECT * FROM `roster_pets` WHERE `member_id` = '10'; |
| 703 |
0.0037 |
SELECT * FROM `roster_companions` WHERE `member_id` = '10' ORDER BY `type` ASC , `slot` ASC; |
| 1284 |
0.0015 |
SELECT * FROM `roster_reputation` WHERE `member_id` = '10' ORDER BY `faction` ASC, `name` ASC; |
| 1196 |
0.001 |
SELECT * FROM `roster_skills` WHERE `member_id` = '10' ORDER BY `skill_order` ASC, `skill_name` ASC; |
| 762 |
0.0009 |
SELECT * FROM `roster_talenttree` WHERE `member_id` = '10' ORDER BY `build`, `order`; |
| 890 |
0.0014 |
SELECT * FROM `roster_talents` WHERE `member_id` = '10' AND `build` = '0' AND `tree` = 'Holy' ORDER BY `row` ASC , `column` ASC |
| 890 |
0.0012 |
SELECT * FROM `roster_talents` WHERE `member_id` = '10' AND `build` = '0' AND `tree` = 'Protection' ORDER BY `row` ASC , `column` ASC |
| 890 |
0.0014 |
SELECT * FROM `roster_talents` WHERE `member_id` = '10' AND `build` = '0' AND `tree` = 'Retribution' ORDER BY `row` ASC , `column` ASC |
| 942 |
0.0012 |
SELECT * FROM `roster_glyphs` WHERE `member_id` = '10' ORDER BY `glyph_build`, `glyph_order`; |
| 972 |
0.0006 |
SELECT `build`, `tree`, `background`, `pointsspent` FROM `roster_talenttree` WHERE `member_id` = '10' ORDER BY `build`, `order`; |
| 561 |
0.0011 |
SELECT `spelltree`.*, `talenttree`.`order`
FROM `roster_spellbooktree` AS spelltree
LEFT JOIN `roster_talenttree` AS talenttree
ON `spelltree`.`member_id` = `talenttree`.`member_id`
AND `spelltree`.`spell_type` = `talenttree`.`tree`
WHERE `spelltree`.`member_id` = 10
ORDER BY `talenttree`.`order` ASC; |
| 587 |
0.0025 |
SELECT * FROM `roster_spellbook` WHERE `member_id` = '10' AND `spell_type` = 'General' ORDER BY `spell_name`; |
| 587 |
0.002 |
SELECT * FROM `roster_spellbook` WHERE `member_id` = '10' AND `spell_type` = 'Holy' ORDER BY `spell_name`; |
| 587 |
0.002 |
SELECT * FROM `roster_spellbook` WHERE `member_id` = '10' AND `spell_type` = 'Protection' ORDER BY `spell_name`; |
| 587 |
0.0019 |
SELECT * FROM `roster_spellbook` WHERE `member_id` = '10' AND `spell_type` = 'Retribution' ORDER BY `spell_name`; |
| 617 |
0.001 |
SELECT `spell`.*, `pet`.`name`
FROM `roster_pet_spellbook` as spell
LEFT JOIN `roster_pets` AS pet
ON `spell`.`pet_id` = `pet`.`pet_id`
WHERE `spell`.`member_id` = '10' ORDER BY `spell`.`spell_name`; |
| 1057 |
0.0013 |
SELECT * FROM `roster_currency` WHERE `member_id` = '10' ORDER BY `category` ASC, `order` ASC; |
| 1591 |
0.0017 |
SELECT * FROM `roster_items` WHERE `member_id` = '10' AND `item_parent` = 'equip' |
| 1406 |
0.0009 |
SELECT `gem_id` AS GemId, `gem_name` AS Name, `gem_color` AS Color, `gem_tooltip` AS Tooltip, `gem_texture` AS Icon, `gem_bonus` AS Bonus, `gem_socketid` AS SocketId, `locale` FROM `roster_gems` WHERE `gem_socketid` = '3743' AND `locale` = 'enUS'; |
| 1406 |
0.0006 |
SELECT `gem_id` AS GemId, `gem_name` AS Name, `gem_color` AS Color, `gem_tooltip` AS Tooltip, `gem_texture` AS Icon, `gem_bonus` AS Bonus, `gem_socketid` AS SocketId, `locale` FROM `roster_gems` WHERE `gem_socketid` = '3454' AND `locale` = 'enUS'; |
| 1406 |
0.0004 |
SELECT `gem_id` AS GemId, `gem_name` AS Name, `gem_color` AS Color, `gem_tooltip` AS Tooltip, `gem_texture` AS Icon, `gem_bonus` AS Bonus, `gem_socketid` AS SocketId, `locale` FROM `roster_gems` WHERE `gem_socketid` = '3502' AND `locale` = 'enUS'; |
| 1406 |
0.0005 |
SELECT `gem_id` AS GemId, `gem_name` AS Name, `gem_color` AS Color, `gem_tooltip` AS Tooltip, `gem_texture` AS Icon, `gem_bonus` AS Bonus, `gem_socketid` AS SocketId, `locale` FROM `roster_gems` WHERE `gem_socketid` = '3384' AND `locale` = 'enUS'; |
| 254 |
0.0016 |
SELECT `name`, `member_id` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `name` ASC; |
| 184 |
0.0017 |
SELECT count(`member_id`) AS `amount`, IF(`note` LIKE '%alt%',1,0) AS isalt, FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 AND `guild_id` = '1' GROUP BY isalt, label; |
| 364 |
0.0015 |
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; |
| 381 |
0.0009 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`; |