selectcount(1)
from mw_helpdesk_tickets
where status = 1705μs
selectcount(1)
from mw_helpdesk_tickets
where status = 2650μs
selectcount(1)
from mw_helpdesk_tickets
where status = 3483μs
SELECTcount(1) as total FROM mw_market_items WHERE bought_by isnulland item_section = ?2.29ms
Params
0
16
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 ASC1.88ms
Params
0
16
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 desc695μs
Params
0
null
selectcount(1) as total from MEMB_INFO477μs
selectcount(1) as total
fromCharacter676μs
SELECTCOUNT(1) AS total FROM Guild
547μs
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 desc538μs
select *
from mw_polls
where active = 1and convert(date, getdate()) >= start_date
and (end_date isnullor convert(date, getdate()) <= end_date)
orderby id desc290μ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 > 7365μs
select *
from mw_slides
where active = 1and type = ?
orderby sequence
479μs