142 |
0.003 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
488 |
0.0033 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
349 |
0.0063 |
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.0011 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '4' ORDER BY `id` ASC; |
152 |
0.0293 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_slot` = 'Tab1' |
185 |
0.0479 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_parent` = 'Tab1' |
152 |
0.0009 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_slot` = 'Tab2' |
185 |
0.0897 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_parent` = 'Tab2' |
152 |
0.0006 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_slot` = 'Tab3' |
185 |
0.0014 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_parent` = 'Tab3' |
152 |
0.0008 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_slot` = 'Tab4' |
185 |
0.001 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_parent` = 'Tab4' |
152 |
0.0011 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_slot` = 'Tab5' |
185 |
0.0011 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_parent` = 'Tab5' |
152 |
0.0008 |
SELECT * FROM `roster_addons_vault_items` WHERE `guild_id` = '1' AND `item_slot` = 'Tab6' |
164 |
0.0286 |
SELECT * FROM `roster_addons_vault_log` WHERE `parent` = 'Tab1' AND `guild_id` = '1' ORDER BY `log_id` DESC; |
164 |
0.0012 |
SELECT * FROM `roster_addons_vault_log` WHERE `parent` = 'Tab2' AND `guild_id` = '1' ORDER BY `log_id` DESC; |
164 |
0.0014 |
SELECT * FROM `roster_addons_vault_log` WHERE `parent` = 'Tab3' AND `guild_id` = '1' ORDER BY `log_id` DESC; |
164 |
0.0008 |
SELECT * FROM `roster_addons_vault_log` WHERE `parent` = 'Tab4' AND `guild_id` = '1' ORDER BY `log_id` DESC; |
164 |
0.0013 |
SELECT * FROM `roster_addons_vault_log` WHERE `parent` = 'Tab5' AND `guild_id` = '1' ORDER BY `log_id` DESC; |
166 |
0.0009 |
SELECT `guild_name`, CONCAT(`region`,'-',`server`), `guild_id` FROM `roster_guild` ORDER BY `region` ASC, `server` ASC, `guild_name` ASC; |
414 |
0.0015 |
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.0026 |
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.0009 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`; |