142 |
0.0029 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
488 |
0.0023 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
349 |
0.0057 |
SELECT guild.*, members.*, players.*, DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 0 HOUR ), "%d/%m/%Y %H:%i:%s" ) 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` = "172"; |
1021 |
0.0037 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC; |
56 |
0.0242 |
SELECT * FROM `roster_addons_info_display` WHERE `member_id` = '172'; |
2095 |
0.016 |
SELECT `main_id` FROM `roster_addons_memberslist_alts` WHERE `member_id` = 172; |
2105 |
0.0008 |
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` = 121; |
1568 |
0.0038 |
SELECT `skill_level` FROM `roster_skills` WHERE `member_id` = 172 AND `skill_name` = 'Défense'; |
1568 |
0.0004 |
SELECT `skill_level` FROM `roster_skills` WHERE `member_id` = 172 AND `skill_name` = 'Défense'; |
220 |
0.0094 |
SELECT * FROM `roster_buffs` WHERE `member_id` = '172'; |
709 |
0.0059 |
SELECT * FROM `roster_pets` WHERE `member_id` = '172'; |
1994 |
0.018 |
SELECT * FROM `roster_reputation` WHERE `member_id` = '172' ORDER BY `faction` ASC, `name` ASC; |
1919 |
0.0008 |
SELECT * FROM `roster_skills` WHERE `member_id` = '172' ORDER BY `skill_order` ASC, `skill_name` ASC; |
1541 |
0.0531 |
SELECT * FROM `roster_items` WHERE `member_id` = '172' AND `item_parent` = 'equip' |
1356 |
0.013 |
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` = '2726' AND `locale` = 'frFR'; |
1356 |
0.0017 |
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` = '2735' AND `locale` = 'frFR'; |
1445 |
0.0358 |
SELECT `item_name`, `item_parent` FROM `roster_items` WHERE `member_id` = '172' AND `item_name` IN ('Gants du gladiateur impitoyable en cuir', 'Garde-jambes du gladiateur impitoyable en cuir', 'Casque de gladiateur en cuir', 'Spallières de gladiateur en cuir', 'Tunique du gladiateur impitoyable en cuir') |
1356 |
0.0007 |
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` = '3107' AND `locale` = 'frFR'; |
1356 |
0.003 |
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` = '2758' AND `locale` = 'frFR'; |
1356 |
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` = '2739' AND `locale` = 'frFR'; |
1541 |
0.0006 |
SELECT * FROM `roster_items` WHERE `member_id` = '172' AND `item_parent` = 'equip' |
212 |
0.0008 |
SELECT `name`, `member_id` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `name` ASC; |
414 |
0.0012 |
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%Reroll%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 1 AND `guild_id` = '1' GROUP BY isalt, label; |
608 |
0.0038 |
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.0034 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`; |