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

Run Time: 0.000958

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

43

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

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

Run Time: 0.000912

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

43

Using intersect(compantIdx,paymentIdx); 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=57
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.000935

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

43

Using intersect(compantIdx,paymentIdx); Using where; Using temporary; Using filesort

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

Run Time: 0.000494

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

30

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

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

Run Time: 0.000545

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

30

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

SELECT sensi_payments.payment_date, COUNT(sensi_payments.payment_date) AS counted
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=56
AND sensi_payments.company_uid=57
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.000600

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

30

Using intersect(compantIdx,paymentIdx); Using where; Using temporary; Using filesort

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

Run Time: 0.000395

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

12

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

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

Run Time: 0.000434

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

12

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

SELECT sensi_payments.payment_date, COUNT(sensi_payments.payment_date) AS counted
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=60
AND sensi_payments.company_uid=57
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.000451

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

12

Using intersect(compantIdx,paymentIdx); Using where; Using temporary; Using filesort

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

Run Time: 0.000493

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

19

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

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

Run Time: 0.000499

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

19

Using intersect(compantIdx,paymentIdx); Using where; Using filesort

SELECT sensi_payments.payment_date, COUNT(sensi_payments.payment_date) AS counted
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=105
AND sensi_payments.company_uid=57
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.000564

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

compantIdx,paymentIdx

4,4

19

Using intersect(compantIdx,paymentIdx); Using where; Using temporary; Using filesort

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

Run Time: 0.000338

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

paymentIdx,compantIdx

4,4

1

Using intersect(paymentIdx,compantIdx); Using where; Using filesort

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

Run Time: 0.000362

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

paymentIdx,compantIdx

4,4

1

Using intersect(paymentIdx,compantIdx); Using where; Using filesort

SELECT sensi_payments.payment_date, COUNT(sensi_payments.payment_date) AS counted
FROM sensi_payments
WHERE sensi_payments.paymentmethod_uid=107
AND sensi_payments.company_uid=57
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.000367

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

sensi_payments

index_merge

paymentIdx,compantIdx

paymentIdx,compantIdx

4,4

1

Using intersect(paymentIdx,compantIdx); 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: 11, 1

Run Time: 0.000133

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.000113

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: 11, 1

Run Time: 0.000117

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 = ?