SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('home')

Params: 5

Run Time: 0.000117

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_phrase_compiled

const

PRIMARY

PRIMARY

231

const,const

1

SELECT n.*, u.avatar_date, u.gravatar, IF(d.notice_id IS NOT NULL, 1, 0) AS dismissed
FROM xfr_bn_notice AS n
LEFT JOIN xf_user AS u ON u.user_id = n.user_id
LEFT JOIN xfr_bn_dismission AS d ON (d.notice_id = n.notice_id AND d.user_id = 0)
WHERE n.archive = 0
ORDER BY n.notice_id

Run Time: 0.000257

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

Impossible WHERE noticed after reading const tables

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('tlk_usergroup_legend')
AND style_id = ?
AND language_id = ?

Params: 24, 5

Run Time: 0.000195

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

160

const,const,const

1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('xen_tr_com_who_has_visited')
AND style_id = ?
AND language_id = ?

Params: 24, 5

Run Time: 0.000189

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

160

const,const,const

1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('MinimalismSidebarArrow')
AND style_id = ?
AND language_id = ?

Params: 24, 5

Run Time: 0.000171

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

160

const,const,const

1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('vkontakte_login_bar_item')
AND style_id = ?
AND language_id = ?

Params: 24, 5

Run Time: 0.000140

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

160

const,const,const

1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('MinimalismSidebar_js')
AND style_id = ?
AND language_id = ?

Params: 24, 5

Run Time: 0.000138

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

160

const,const,const

1

SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('MinimalismToTop_js')
AND style_id = ?
AND language_id = ?