selectcount(1)
from mw_helpdesk_tickets
where status = 1567μs
selectcount(1)
from mw_helpdesk_tickets
where status = 2498μs
selectcount(1)
from mw_helpdesk_tickets
where status = 3457μs
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
2.79ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?1.24ms
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 = 0) AND (c.Class in(64,66,67)) ORDERBY 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 ASC20.31ms
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 desc770μs
Params
0
null
select *
from mw_polls
where active = 1and convert(date, getdate()) >= start_date
and (end_date isnullor convert(date, getdate()) <= end_date)
orderby id desc393μs
selectcount(1) as total from MEMB_INFO497μs
selectcount(1) as total
fromCharacter859μs
SELECTCOUNT(1) AS total FROM Guild
751μs
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 > 7728μs