142 |
0.023 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
488 |
0.0022 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
349 |
0.0112 |
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` = "64"; |
1021 |
0.0037 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC; |
56 |
0.0037 |
SELECT * FROM `roster_addons_info_display` WHERE `member_id` = '64'; |
2095 |
0.0023 |
SELECT `main_id` FROM `roster_addons_memberslist_alts` WHERE `member_id` = 64; |
2105 |
0.0014 |
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` = 64; |
1568 |
0.0015 |
SELECT `skill_level` FROM `roster_skills` WHERE `member_id` = 64 AND `skill_name` = 'Défense'; |
1568 |
0.0005 |
SELECT `skill_level` FROM `roster_skills` WHERE `member_id` = 64 AND `skill_name` = 'Défense'; |
220 |
0.0044 |
SELECT * FROM `roster_buffs` WHERE `member_id` = '64'; |
709 |
0.0038 |
SELECT * FROM `roster_pets` WHERE `member_id` = '64'; |
1994 |
0.0189 |
SELECT * FROM `roster_reputation` WHERE `member_id` = '64' ORDER BY `faction` ASC, `name` ASC; |
1919 |
0.0009 |
SELECT * FROM `roster_skills` WHERE `member_id` = '64' ORDER BY `skill_order` ASC, `skill_name` ASC; |
1541 |
0.0425 |
SELECT * FROM `roster_items` WHERE `member_id` = '64' AND `item_parent` = 'equip' |
1356 |
0.0016 |
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` = '3117' AND `locale` = 'frFR'; |
1356 |
0.0099 |
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` = '3138' AND `locale` = 'frFR'; |
1356 |
0.001 |
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` = '3141' AND `locale` = 'frFR'; |
1445 |
0.0491 |
SELECT `item_name`, `item_parent` FROM `roster_items` WHERE `member_id` = '64' AND `item_name` IN ('Plastron de Cristalforge', 'Gants de Cristalforge', 'Grand heaume de Cristalforge', 'Jambières de Cristalforge', 'Espauliers de Cristalforge') |
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` = '3081' AND `locale` = 'frFR'; |
1356 |
0.0032 |
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` = '3086' AND `locale` = 'frFR'; |
1541 |
0.0011 |
SELECT * FROM `roster_items` WHERE `member_id` = '64' AND `item_parent` = 'equip' |
212 |
0.0059 |
SELECT `name`, `member_id` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `name` ASC; |
414 |
0.0016 |
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.0023 |
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.0027 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`; |