SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?125.48ms
Params
0
Gens_Rank
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
127.25ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?125.45ms
Params
0
MasterSkillTree
WITH dctrn_cte AS (SELECT TOP 99 g.Name AS id, g.Name AS name, g.Family AS family, g.Contribution AS contribution, g.Contribution AS score, gm.G_Name AS guild, c.cLevel AS subscore, 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, CASEWHEN s.ConnectStat > 0and ac.GameIDC = c.Name THEN1ELSE0ENDAS status, c.ResetCount as resets, 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 Gens_Rank g LEFTJOINCharacter c ON c.Name = g.Name COLLATE DATABASE_DEFAULT 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 g.Contribution DESC, g.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 ASC133.59ms
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 desc130.19ms
Params
0
null
selectcount(1) as total from MEMB_INFO124.79ms
selectcount(1) as total
fromCharacter253.75ms
SELECTCOUNT(1) AS total FROM Guild
253.01ms
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 > 7252.16ms
