selectcount(1)
from mw_helpdesk_tickets
where status = 1810μs
selectcount(1)
from mw_helpdesk_tickets
where status = 2833μs
selectcount(1)
from mw_helpdesk_tickets
where status = 3707μs
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
3.26ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?1.58ms
Params
0
MasterSkillTree
WITH dctrn_cte AS (SELECT TOP 99 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, d.WinScore AS score, d.LoseScore AS subscore, c.Name AS id, c.Name AS name, c.cLevel ASlevel, c.Experience AS experience, c.Class AS class, c.PkLevel AS pkLevel, c.PkCount AS pkCount, c.AccountID AS account, c.LevelUpPoint AS points, c.MapNumber AS map, c.MapPosY AS positionY, c.MapPosX AS positionX, c.CtlCode AS code, c.Strength AS strength, c.Dexterity AS agility, c.Vitality AS vitality, c.Energy AS energy, c.Money AS money, gm.G_Name AS guild, CASEWHEN s.ConnectStat > 0and ac.GameIDC = c.Name THEN1ELSE0ENDas status, c.Resetcount as resets, c.MasterResetCount as masterResets, c.Avatar as avatar, (select top 1 AccountLevel from MuOnline.dbo.MEMB_INFO where memb___id = c.AccountID) as vipType, mi.country as country, c.Leadership AS command, ml.MasterLevel as masterLevel FROM RankingDuel d LEFTJOINCharacter c ON d.Name = c.Name LEFTJOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFTJOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFTJOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFTJOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFTJOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0ORDERBY d.WinScore DESC, d.LoseScore ASC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 99ORDERBY doctrine_rownum ASC13.81ms
select
ac.GameIDC ascharacter,
ms.IP as ip,
ms.memb___id as account,
ms.ConnectStat as connect_stat,
c.MapNumber as map,
c.MapPosX as x,
c.MapPosY as y,
c.Class as character_class,
ms.ServerName as server_name,
(select top 1 AccountLevel from MEMB_INFO where memb___id = c.AccountID) as vipType,
ms.ConnectTM as connected_at,
ms.DisConnectTM as disconnected_at,
gm.G_Name as guild
from MEMB_STAT ms
join AccountCharacter ac ON ms.memb___id = ac.Id collate DATABASE_DEFAULT
joinCharacter c ON ms.memb___id = c.AccountID collate DATABASE_DEFAULT
leftjoin GuildMember gm ON c.Name = gm.Name collate DATABASE_DEFAULT
where ms.ConnectStat > 0and ac.GameIDC = c.Name
orderby ConnectTM desc1.08ms
Params
0
null
selectcount(1) as total from MEMB_INFO833μs
selectcount(1) as total
fromCharacter1.85ms
SELECTCOUNT(1) AS total FROM Guild
1.09ms
select
c.Name as name,
c.Class as class,
c.CtlCode as code,
casewhen s.ConnectStat > 0and ac.GameIDC = c.Name then1else0endas status
from MEMB_STAT s
join AccountCharacter ac on s.memb___id = ac.Id collate DATABASE_DEFAULT
joinCharacter c on s.memb___id = c.AccountID collate DATABASE_DEFAULT
where c.CtlCode > 7954μs
