selectcount(1)
from mw_helpdesk_tickets
where status = 1643μs
selectcount(1)
from mw_helpdesk_tickets
where status = 2720μs
selectcount(1)
from mw_helpdesk_tickets
where status = 31.66ms
SELECTcount(1) as total FROM mw_market_items WHERE bought_by isnulland item_section = ?1.26ms
Params
0
11
WITH dctrn_cte AS (SELECT TOP 15 * FROM mw_market_items WHERE bought_by isnulland item_section = ?) SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDERBY (SELECT0)) AS doctrine_rownum FROM dctrn_cte) AS doctrine_tbl WHERE doctrine_rownum <= 15ORDERBY doctrine_rownum ASC3.38ms
Params
0
11
select *
from mw_countdowns
where active = 1713μ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 desc779μs
Params
0
null
selectcount(1) as total from MEMB_INFO983μs
selectcount(1) as total
fromCharacter1.09ms
SELECTCOUNT(1) AS total FROM Guild
1.31ms
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 > 7937μs
select *
from mw_slides
where active = 1and type = ?
orderby sequence
690μs