selectcount(1)
from mw_helpdesk_tickets
where status = 11.99ms
selectcount(1)
from mw_helpdesk_tickets
where status = 2721μs
selectcount(1)
from mw_helpdesk_tickets
where status = 3674μs
SELECTcount(1) as total FROM mw_market_items WHERE bought_by isnulland item_section = ?3.85ms
Params
0
18
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 ASC2.65ms
Params
0
18
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 desc11.39ms
Params
0
null
selectcount(1) as total from MEMB_INFO830μs
selectcount(1) as total
fromCharacter1.21ms
SELECTCOUNT(1) AS total FROM Guild
1.37ms
select top 5 i.*
, s.coin
, c.slug as category_slug
, s.slug as shop_slug
from mw_shop_items i
join mw_shop_categories c on c.id = i.category_id
join mw_shops s on s.id = c.shop_id
where i.offer = 1and i.shop_item_id isnullorderby i.solds desc4.32ms
select *
from mw_polls
where active = 1and convert(date, getdate()) >= start_date
and (end_date isnullor convert(date, getdate()) <= end_date)
orderby id desc1.29ms
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 > 71.77ms
select *
from mw_slides
where active = 1and type = ?
orderby sequence
1.42ms