SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_thread_field AS field
INNER JOIN xf_forum_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(69))
ORDER BY field.materialized_order

Run Time: 0.000157

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

ff

ref

PRIMARY,field_id

PRIMARY

4

const

1

Using index; Using temporary; Using filesort

SIMPLE

field

eq_ref

PRIMARY

PRIMARY

194

foromtb_www.ff.field_id

1

SELECT field.*
,
ff.field_id, ff.node_id
FROM xf_thread_field AS field
INNER JOIN xf_forum_field AS ff ON
(ff.field_id = field.field_id)
WHERE (ff.node_id IN(69))
ORDER BY field.materialized_order

Run Time: 0.000123

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

ff

ref

PRIMARY,field_id

PRIMARY

4

const

1

Using index; Using temporary; Using filesort

SIMPLE

field

eq_ref

PRIMARY

PRIMARY

194

foromtb_www.ff.field_id

1

SELECT category.*
,
permission.cache_value AS category_permission_cache
FROM xf_nflj_showcase_category AS category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'showcase_category'
AND permission.content_id = category.category_id)
ORDER BY category.lft