SELECT COUNT(*)
FROM xf_thread AS thread
WHERE (thread.node_id = 319) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))

Run Time: 0.000233

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

thread

ref

node_id_last_post_date,node_id_sticky_state_last_post

node_id_sticky_state_last_post

6

const,const,const

31

Using where; Using index

SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id = 319) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
LIMIT 20

Run Time: 0.000859

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

thread

ref

node_id_last_post_date,node_id_sticky_state_last_post

node_id_sticky_state_last_post

6

const,const,const

31

Using index condition; Using where; Using filesort

SIMPLE

user

eq_ref

PRIMARY

PRIMARY

4

affdog_xforum.thread.user_id

1

SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id = 319) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC

SELECT sensi_payments.payment_date
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=54
AND sensi_payments.company_uid=594
AND sensi_payments.payment_date > DATE_SUB(CURDATE(),INTERVAL 12 MONTH)
ORDER BY DAYOFMONTH(sensi_payments.payment_date) ASC
LIMIT 1

Run Time: 0.000407

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

ref

paymentIdx,compantIdx

compantIdx

4

const

41

Using where; Using filesort

SELECT sensi_payments.payment_date
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=54
AND sensi_payments.company_uid=594
AND sensi_payments.payment_date > DATE_SUB(CURDATE(),INTERVAL 12 MONTH)
ORDER BY DAYOFMONTH(sensi_payments.payment_date) DESC
LIMIT 1

Run Time: 0.000379

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

ref

paymentIdx,compantIdx

compantIdx

4

const

41

Using where; Using filesort

SELECT sensi_payments.payment_date, COUNT(sensi_payments.payment_date) AS counted
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=54
AND sensi_payments.company_uid=594
AND sensi_payments.payment_date > DATE_SUB(CURDATE(),INTERVAL 12 MONTH)
GROUP BY sensi_payments.payment_date
ORDER BY counted DESC
LIMIT 1

Run Time: 0.000447

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

ref

paymentIdx,compantIdx

compantIdx

4

const

41

Using where; Using temporary; Using filesort

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

Params: 14, 1

Run Time: 0.000228

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

60

const,const,const

1

SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xcas_custom_hook_name', 'xcas_custom_hook', 'xcas_custom_hook_name_explain')

Params: 1

Run Time: 0.000103

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_phrase_compiled

range

PRIMARY

PRIMARY

106

3

Using where

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

Params: 14, 1

Run Time: 0.000179

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_template_compiled

const

PRIMARY

PRIMARY

60

const,const,const

1

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