TheGame - Season 6
select * from mw_config1.8msselect count(1)
from mw_helpdesk_tickets
where status = 1
621μsselect count(1)
from mw_helpdesk_tickets
where status = 2
827μsselect count(1)
from mw_helpdesk_tickets
where status = 3
1.2msselect *
from mw_slides
where active = 1
and type = ?
order by sequence
1.51ms| Params | |
|---|---|
| 0 | modal |
select
ac.GameIDC as character,
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
join Character c ON ms.memb___id = c.AccountID collate DATABASE_DEFAULT
left join GuildMember gm ON c.Name = gm.Name collate DATABASE_DEFAULT
where ms.ConnectStat > 0
and ac.GameIDC = c.Name
order by ConnectTM desc
796μs| Params | |
|---|---|
| 0 | null |
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.55ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?953μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 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 AS level, c.cLevel AS score, c.Experience AS experience, c.Experience AS subscore, 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.cLevel DESC, c.Experience DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC986μsselect *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
3.21ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?889μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 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 AS level, c.MasterResetCount AS score, c.ResetCount 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.MasterResetCount DESC, c.ResetCount DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC891μsselect *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.22ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?935μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 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 AS level, 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.ResetCount DESC, c.cLevel DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC824μsselect *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.24ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?831μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 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 AS level, c.HeroCount AS score, 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.HeroCount DESC, c.cLevel DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC977μsselect *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.25ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?821μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, c.ResetDay AS score, c.Name AS id, c.Name AS name, c.cLevel AS level, 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 MuOnline.dbo.Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.ResetDay DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC959μsselect *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.17ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?818μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, c.ResetWek AS score, c.Name AS id, c.Name AS name, c.cLevel AS level, 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 MuOnline.dbo.Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.ResetWek DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC925μsselect *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = ?
1.33ms| Params | |
|---|---|
| 0 | Character |
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ?886μs| Params | |
|---|---|
| 0 | MasterSkillTree |
WITH dctrn_cte AS (SELECT TOP 5 s.ConnectStat AS connectStat, s.ConnectTM AS lastConnection, s.ServerName AS server, ac.GameIDC AS gameIdc, c.ResetMon AS score, c.Name AS id, c.Name AS name, c.cLevel AS level, 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, CASE WHEN s.ConnectStat > 0 and ac.GameIDC = c.Name THEN 1 ELSE 0 END as 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 MuOnline.dbo.Character c LEFT JOIN AccountCharacter ac ON c.AccountID = ac.Id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_INFO mi ON c.AccountID = mi.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN MEMB_STAT s ON c.AccountID = s.memb___id COLLATE DATABASE_DEFAULT LEFT JOIN GuildMember gm ON c.Name = gm.Name COLLATE DATABASE_DEFAULT LEFT JOIN MasterSkillTree ml ON c.Name = ml.Name COLLATE DATABASE_DEFAULT WHERE c.CtlCode = 0 ORDER BY c.ResetMon DESC, c.Name ASC) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 5 ORDER BY doctrine_rownum ASC882μsselect
count(1) as total from MEMB_INFO522μsselect
count(1) as total
from Character
1.01msSELECT
COUNT(1) AS total FROM Guild
1.04msselect
cs.CASTLE_OCCUPY as occupy,
cs.SIEGE_START_DATE as start,
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,
(select count(1) from GuildMember where G_Name = cs.OWNER_GUILD) as guild_members,
c.Avatar as avatar
from MuCastle_DATA cs
left join Guild g on g.G_Name = cs.OWNER_GUILD collate DATABASE_DEFAULT
left join Character c on c.Name = g.G_Master collate DATABASE_DEFAULT
1.19msselect
c.Name as name,
c.Class as class,
c.CtlCode as code,
case when s.ConnectStat > 0 and ac.GameIDC = c.Name then 1 else 0 end as status
from MEMB_STAT s
join AccountCharacter ac on s.memb___id = ac.Id collate DATABASE_DEFAULT
join Character c on s.memb___id = c.AccountID collate DATABASE_DEFAULT
where c.CtlCode > 7
955μsselect *
from mw_polls
where active = 1
and convert(date, getdate()) >= start_date
and (end_date is null or convert(date, getdate()) <= end_date)
order by id desc
498μsselect *
from mw_event_categories
order by sequence
547μs