• Titulo
Titulo

Client download

Vip Mercado
Doação Webshop

Ranking Resets

MasterResets Pk Resets Guild BloodCastle ChaosCastle DevilSquare Gens Hero Character
# Personagem Classe Guilda Score
1 LouisSM Grand Master testeGG 0 -
2 MGTeste Duel Master Teste5 0 -
3 SUMM Dimension Master 0 -
4 Trade2 Dark Knight 0 -
5 LouisMK Muse Elf Teste2 0 -
6 MKSEMPRE Lord Emperor 0 -
7 SuperLouis Dark Knight Teste3 0 -
8 Party Dark Knight 0 -
9 Magrela Fairy Elf 0 -
10 TesteDL Dark Lord 0 -
11 Cont5 Dark Knight 0 -
12 Criandooo Dark Knight 0 -
13 DLDL Dark Lord 0 -
14 LouisTeste Summoner 0 -
15 TesteMap Summoner 0 -
16 TradeDL Dark Lord 0 -
17 TradeMG Magic Gladiator 0 -
18 TradRF Rage Fighter 0 -
19 KmmR Fist Master Teste6 0 -
20 Conta4 Vip Dark Lord 0 -
Server: offline 0 Players

Top players

Tempo real
# Guilda Score
1 Teste2 0
Equipe
  • LuisADM Offline
Preferem 97D ou Season 20?
Resultado
Top class

Top Grand Master

LouisSM
Score: 0
Guilda: testeGG

Top Blade Master

LuisADM
Score: 50
Guilda: Teste3

Top Muse Elf

LouisMK
Score: 0
Guilda: Teste2

Top Duel Master

MGTeste
Score: 0
Guilda: Teste5

Top Lord Emperor

MKSEMPRE
Score: 0
Guilda: -

Top Dimension Master

SUMM
Score: 0
Guilda: -

Top Rage Fighter

TradRF
Score: 0
Guilda: -

Error

Not found top class GL

Error

Not found top class RW

Error

Not found top class SY

Error

Not found top class GC

Error

Not found top class LIW

Error

Not found top class LEM

Error

Not found top class ILK

Castle siege
Dono do Castelo
Teste2



Master
LouisMK
MessagesRequestTimelineExceptionsDatabase77Config
7.4.33Version384.26msRequest Duration13.66MBMemory Usage
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:3 [ "csrf_token" => "27726b7f2e0955e8ba02fc7e52a31de2ad06cd4ef6837a36c5cce84067a54a7f" "sl...
    $_COOKIE
    []
    $_SERVER
    array:55 [ "CONTEXT_DOCUMENT_ROOT" => "/home/demomw/public_html" "CONTEXT_PREFIX" => "" "DOCUM...
        77 statements were executed, 42 of which were duplicates, 35 unique84.41ms
        • select * from mw_config1.7ms
        • select count(1) from mw_helpdesk_tickets where status = 1 516μs
        • select count(1) from mw_helpdesk_tickets where status = 2 645μs
        • select count(1) from mw_helpdesk_tickets where status = 3 573μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 4.97ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?903μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 99 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.ResetMon 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 Demov5.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.ResetMon 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 <= 99 ORDER BY doctrine_rownum ASC1.56ms
        • select * from mw_slides where active = 1 and type = ? order by sequence 698μs
          Params
          0slide
        • 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 629μs
          Params
          0null
        • WITH dctrn_cte AS (SELECT TOP 1 G_Name as name, G_Name as id, G_Mark as mark, G_Score as score, (select count(1) from GuildMember where G_Name = g.G_Name) as members, G_Master as master FROM Guild g ORDER BY 1 asc) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY (SELECT 0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 1 ORDER BY doctrine_rownum ASC492μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.54ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?803μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 1 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.PkCount 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 Demov5.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.PkCount 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 <= 1 ORDER BY doctrine_rownum ASC602μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.45ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?745μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 1 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 Demov5.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 <= 1 ORDER BY doctrine_rownum ASC702μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.32ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?776μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 1 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.PkCount 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 Demov5.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.PkCount 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 <= 1 ORDER BY doctrine_rownum ASC689μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.78ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?800μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 1 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 Demov5.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 <= 1 ORDER BY doctrine_rownum ASC683μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.39ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?871μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 1 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 Demov5.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 <= 1 ORDER BY doctrine_rownum ASC701μs
        • select 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 496μs
        • select * 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 382μs
        • select * from mw_polls_answers where poll_id = ? order by sequence 1.45ms
          Params
          03
        • select count(1) from mw_polls_answers_persons where answer_id = ? 386μs
          Params
          06
        • select * from mw_polls_answers_persons where answer_id = ? and ip = ? 907μs
          Params
          06
          13.141.14.210
        • select count(1) from mw_polls_answers_persons where answer_id = ? 356μs
          Params
          07
        • select * from mw_polls_answers_persons where answer_id = ? and ip = ? 818μs
          Params
          07
          13.141.14.210
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.56ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?807μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (0,1,2,3) 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 <= 50 ORDER BY doctrine_rownum ASC775μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.95ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?757μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (16,17,18,19) 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 <= 50 ORDER BY doctrine_rownum ASC1.49ms
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 2.5ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?749μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (32,33,34,35) 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 <= 50 ORDER BY doctrine_rownum ASC730μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 3.11ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?721μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (48,50,51) 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 <= 50 ORDER BY doctrine_rownum ASC1.22ms
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.72ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?754μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (64,66,67) 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 <= 50 ORDER BY doctrine_rownum ASC724μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.43ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?755μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (80,81,82,83) 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 <= 50 ORDER BY doctrine_rownum ASC631μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.59ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?726μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (96,98,99) 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 <= 50 ORDER BY doctrine_rownum ASC604μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.52ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?1.61ms
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (112,114,115) 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 <= 50 ORDER BY doctrine_rownum ASC861μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.28ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?719μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (128,129,130,131) 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 <= 50 ORDER BY doctrine_rownum ASC523μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.43ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?3.4ms
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (144,145,146,147) 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 <= 50 ORDER BY doctrine_rownum ASC602μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.81ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?921μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (160,161,162,163) 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 <= 50 ORDER BY doctrine_rownum ASC557μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.46ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?838μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (176,177,178,179) 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 <= 50 ORDER BY doctrine_rownum ASC571μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.27ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?820μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (192,193,194,195) 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 <= 50 ORDER BY doctrine_rownum ASC582μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ? 1.37ms
          Params
          0Character
        • SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ?769μs
          Params
          0MasterSkillTree
        • WITH dctrn_cte AS (SELECT TOP 50 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 Demov5.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.Class in (208,209,210,211) 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 <= 50 ORDER BY doctrine_rownum ASC563μs
        • select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ?1.06ms
          Params
          0MuCastle_DATA
        • select 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 479μs
        • select * from mw_slides where active = 1 and type = ? order by sequence 1.76ms
          Params
          0modal
        timezone
        America/Bahia
        base_path
        template
        aries
        url_rewrite
        true
        debug
        true
        admin_prefix
        admin
        ranking
        array:3 [ "show_search_classes" => true "limit" => 99 "cache_time" => 60 ]
        auth
        array:2 [ "max_tries" => 5 "time_new_try" => 600 ]
        settingsCheck
        true
        linkForum
        http://forum.com
        linkFacebook
        http://facebook.com
        linkTwitter
        http://twitter.com
        linkInstagram
        http://instagram.com
        linkGooglePlus
        http://googleplus.com
        linkYoutube
        http://youtube.com
        linkTwitch
        http://twitch.com
        enableShopHeader
        true
        enableMarketHeader
        true
        enableShopFooter
        true
        enableMarketFooter
        false
        popUp
        1
        descriptionSite
        BB Mu Web - Plataforma para servidor de MuOnline.
        enableCountdownHome
        true
        titleCountdownHome
        inauguration in
        dataCountdownHome
        Jan 01, 2020 00:00:00
        enableArcaWar
        false
        tableArcaWar
        IGC_ARCA_BATTLE_WIN_GUILD_INFO
        columnArcaWar
        ObeliskGroup
        naxtConfrontation
        Sábado 16h
        countdownArcaWar
        Dec 14, 2019 22:00:00
        enableTopGens
        false
        tableGens
        IGC_Gens
        columnRankGens
        Rank
        columnNameGens
        Name
        columnPointsGens
        Points
        enableTopClass
        true
        nameTopClass
        ResetCount
        tableTopClass
        RESETCount
        nameTopClassSecundary
        Level
        tableTopClassSecundary
        cLevel
        classDW
        true
        classDW1
        0
        classDW2
        1
        classDW3
        3
        classDW4
        7
        classDK
        true
        classDK1
        16
        classDK2
        17
        classDK3
        19
        classDK4
        23
        classFE
        true
        classFE1
        32
        classFE2
        33
        classFE3
        35
        classFE4
        39
        classMG
        true
        classMG1
        48
        classMG2
        50
        classMG3
        54
        classDL
        true
        classDL1
        64
        classDL2
        55
        classDL3
        70
        classSU
        true
        classSU1
        80
        classSU2
        81
        classSU3
        83
        classSU4
        87
        classRF
        false
        classRF1
        96
        classRF2
        98
        classRF3
        102
        classGL
        false
        classGL1
        112
        classGL2
        114
        classGL3
        118
        classRW
        false
        classRW1
        0
        classRW2
        0
        classRW3
        0
        classRW4
        0
        characters
        array:3 [ "code_types" => array:4 [ 0 => "Normal" 1 => "Banned" 8 => "Game Master" ...
        maps
        array:103 [ 0 => array:2 [ "name" => "Lorencia" "born" => "147x127" ] 1 => array:2 [ ...
        item
        array:13 [ "tooltip_file" => "item.php" "use_option_file" => true "serial_mode" => 0 "db_ver...
        columns
        array:7 [ "credit" => "credits" "token" => "memb_token" "avatar" => "Avatar" "resets" => "Re...
        use_vi_curr_info
        false
        use_md5
        false
        generate_guid
        false
        server
        array:8 [ "team" => "muemu" "season" => "18" "name" => "Demo Morpheus MuWeb" "version_name" ...
        servers
        []
        site
        array:2 [ "logo" => "" "title" => "Demo Morpheus MuWeb" ]
        players-online
        array:1 [ "show_type" => "all" ]
        smtp
        array:6 [ "host" => "demo.morpheusmuweb.com" "username" => "email@demo.morpheusmuweb.com" "pas...
        castlesiege
        array:1 [ "next_confrontation" => "17/06/2024" ]
        connectserver
        array:2 [ "host" => "" "port" => "" ]
        joinserver
        array:2 [ "host" => "" "port" => "" ]
        warehouse
        array:2 [ "extended" => true "ext" => array:7 [ "active" => true "database" => "Demov5" ...
        force_https
        true
        maintenance
        false
        locale
        pt_BR
        vip
        array:6 [ "database" => "Demov5" "table" => "MEMB_INFO" "column_account" => "memb___id" "col...
        coins
        array:3 [ "goblinpoint" => array:8 [ "id" => "goblinpoint" "name" => "GoblinPoint" "da...
        rankings
        array:14 [ "MasterResets" => array:7 [ "sequence" => 0 "name" => "MasterResets" "is_gu...
        register
        array:9 [ "terms" => "" "countries_flag_column" => "country" "confirm_email" => false "creat...
        plugins
        array:28 [ 0 => "Achievements" 2 => "AuthRemember" 3 => "Avatar" 4 => "Donate" 5 => "Event...
        donate
        array:4 [ "allow_payment_confirmation" => true "conversion" => array:3 [ "USD" => array:2 [ ...
        hallfame
        array:3 [ "rankings" => array:10 [ "Guild" => array:5 [ "active" => true "name" =>...
        helpdesk
        array:4 [ "rules" => "aguarde o retorno da equipe" "departments" => array:3 [ 0 => "suporte"...
        posts
        array:4 [ "limit" => "5" "types" => array:4 [ 0 => array:2 [ "name" => "IMPORTANTE" ...
        profile
        array:2 [ "show_equipments" => true "column_hours" => "profile_blocked_until" ]
        workshop
        array:16 [ "max_level" => "12" "max_option" => "16" "max_excellent_category" => array:22 [ ...
        sn
        array:2 [ "facebook" => array:2 [ "login" => true "keys" => array:2 [ "id" => "72655...
        market
        array:12 [ "allow_credits" => false "allow_zen" => false "allowed_coins" => array:1 [ 0 =>...
        downloads
        array:2 [ 0 => array:4 [ "name" => "Source Full" "size" => "200MB" "desc" => "Install ...
        account-market
        array:5 [ "gateways" => array:3 [ 0 => "picpay" 1 => "paghiper" 2 => "mercadopago" ]...
        events
        array:1 [ "timezone" => "America/Sao_Paulo" ]
        patent
        array:4 [ "database" => "" "table" => "" "column_code" => null "column_name" => null ]
        direct-market
        array:3 [ "rescue_percentage" => "10" "min_price" => 5 "gateways" => array:5 [ 0 => "pagse...
        forum
        array:3 [ "conn" => "forum" "topics" => array:4 [ "limit" => "5" "type" => "phpbb" "...
        auction
        array:2 [ "pusher" => array:3 [ "auth_key" => "" "secret_key" => "" "app_id" => "" ]...
        rewards
        array:1 [ "rankings" => array:9 [ "Resets" => array:4 [ "normal" => array:2 [ "r...
        streamer
        array:3 [ "token" => "rez8iqj96w5nic6c0ft7vz3e64zqah" "client_id" => "3t01atwbquj71gkdzebm707zw8...
        webshop
        array:1 [ "blocked_recover_items" => "" ]
        custom
        array:1 [ "rankings" => [] ]
        avatar
        array:3 [ "use_type" => "2" "filesize" => "100" "allow_gif" => true ]
        change_class
        array:3 [ "classes" => array:1 [ 0 => "96" ] "equalize_points" => true "reset_master_lev...
        exchange
        array:2 [ "coins" => array:1 [ "wcoinc" => array:3 [ "tax" => "10" "coin" => "wcoi...
        change-nick
        array:1 [ "regex_validation" => "/[^a-z_0-9]/i" ]