142 |
0.0037 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
488 |
0.0027 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
349 |
0.0043 |
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.0035 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '5' ORDER BY `id` ASC; |
1021 |
0.0006 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '6' ORDER BY `id` ASC; |
1021 |
0.0014 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '2' ORDER BY `id` ASC; |
1021 |
0.0006 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '4' ORDER BY `id` ASC; |
51 |
0.0143 |
SELECT * FROM `roster_addons_info_default`; |
414 |
0.0011 |
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 GROUP BY isalt, label; |
608 |
0.0018 |
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.0028 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`; |