25 statements were executed, 8 of which were duplicates, 17 unique25.35ms
select * from mw_config1.42ms
selectcount(1)
from mw_helpdesk_tickets
where status = 1721μs
selectcount(1)
from mw_helpdesk_tickets
where status = 2873μs
selectcount(1)
from mw_helpdesk_tickets
where status = 3856μs
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
2.2ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?975μs
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, ds.Deaths AS score, 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 NovoMuOnline.dbo.MEMB_INFO where memb___id = c.AccountID) as vipType, mi.country as country, c.Leadership AS command, ml.MasterLevel as masterLevel FROM NovoMuOnline.dbo.RankingCastleSiege ds LEFTJOINCharacter c ON ds.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 ds.Deaths DESC, 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 ASC1.11ms
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.91ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?895μs
Params
0
MasterSkillTree
WITH dctrn_cte AS (SELECT TOP 10 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, c.Name AS id, c.Name AS name, c.cLevel ASlevel, c.ResetCount AS score, 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, 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 NovoMuOnline.dbo.MEMB_INFO where memb___id = c.AccountID) as vipType, mi.country as country, c.Leadership AS command, ml.MasterLevel as masterLevel FROMCharacter c 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 c.ResetCount DESC, c.cLevel DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 10ORDERBY doctrine_rownum ASC1.38ms
WITH dctrn_cte AS (SELECT TOP 10 g.G_Name as name, g.G_Name as id, g.G_Mark as mark, ds.Wins as score, (selectcount(1) from GuildMember where G_Name = g.G_Name) as members, g.G_Master as master FROM NovoMuOnline.dbo.RankingCastleSiegeWins ds LEFTJOIN Guild g ON ds.Guild = g.G_Name ORDERBY Wins DESC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 10ORDERBY doctrine_rownum ASC656μs
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.27ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?839μs
Params
0
MasterSkillTree
WITH dctrn_cte AS (SELECT TOP 10 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, ds.Kills AS score, 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 NovoMuOnline.dbo.MEMB_INFO where memb___id = c.AccountID) as vipType, mi.country as country, c.Leadership AS command, ml.MasterLevel as masterLevel FROM NovoMuOnline.dbo.RankingCastleSiege ds LEFTJOINCharacter c ON ds.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 ds.Kills DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 10ORDERBY doctrine_rownum ASC915μs
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.3ms
Params
0
Character
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?813μs
Params
0
MasterSkillTree
WITH dctrn_cte AS (SELECT TOP 10 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, ds.Deaths AS score, 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 NovoMuOnline.dbo.MEMB_INFO where memb___id = c.AccountID) as vipType, mi.country as country, c.Leadership AS command, ml.MasterLevel as masterLevel FROM NovoMuOnline.dbo.RankingCastleSiege ds LEFTJOINCharacter c ON ds.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 ds.Deaths DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 10ORDERBY doctrine_rownum ASC906μs
WITH dctrn_cte AS (SELECT TOP 10 G_Name as name, G_Name as id, G_Mark as mark, G_Score as score, (selectcount(1) from GuildMember where G_Name = g.G_Name) as members, G_Master as master FROM Guild g ORDERBY G_Score DESC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 10ORDERBY doctrine_rownum ASC658μs
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 desc813μs
Params
0
null
selectcount(1) as total from MEMB_INFO524μs
selectcount(1) as total
fromCharacter980μs
SELECTCOUNT(1) AS total FROM Guild
892μ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 > 7990μs
select
cs.CASTLE_OCCUPY as occupy,
cs.SIEGE_START_DATE asstart,
cs.SIEGE_END_DATE as finish,
cs.OWNER_GUILD as guild_owner,
g.G_Master as guild_owner_master,
g.G_Mark as guild_owner_mark,
(selectcount(1) from GuildMember where G_Name = cs.OWNER_GUILD) as guild_members,
c.Avatar as avatar
from MuCastle_DATA cs
leftjoin Guild g on g.G_Name = cs.OWNER_GUILD collate DATABASE_DEFAULT
leftjoinCharacter c on c.Name = g.G_Master collate DATABASE_DEFAULT
557μs
select *
from mw_polls
where active = 1and convert(date, getdate()) >= start_date
and (end_date isnullor convert(date, getdate()) <= end_date)
orderby id desc886μs
