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

Params: 4

Run Time: 0.000058

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

xf_phrase_compiled

range

PRIMARY

PRIMARY

106

2

Using where

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (66, 67, 81, 87, 85, 60)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000135

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

node

range

PRIMARY

PRIMARY

4

6

Using where; Using filesort

SIMPLE

permission

eq_ref

PRIMARY

PRIMARY

35

const,const,db25061_47.node.node_id

1

Using where

SIMPLE

options

eq_ref

node_id

node_id

4

db25061_47.node.node_id

1

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (75, 78, 79, 80, 92, 77, 76)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000135

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

node

range

PRIMARY

PRIMARY

4

7

Using where; Using filesort

SIMPLE

permission

eq_ref

PRIMARY

PRIMARY

35

const,const,db25061_47.node.node_id

1

Using where

SIMPLE

options

eq_ref

node_id

node_id

4

db25061_47.node.node_id

1

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (84, 86)
ORDER BY node.lft
ASC

Params: 1

Run Time: 0.000130

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

node

range

PRIMARY

PRIMARY

4

2

Using where; Using filesort

SIMPLE

permission

eq_ref

PRIMARY

PRIMARY

35

const,const,db25061_47.node.node_id

1

Using where

SIMPLE

options

eq_ref

node_id

node_id

4

db25061_47.node.node_id

1

SELECT advertisement.*
,
zone.*,
zone.name AS zone_name,
purchase.*
FROM admon_advertisement AS advertisement
LEFT JOIN admon_advertisement_zone AS zone ON
(zone.zone_id = advertisement.advertisement_zone)
LEFT JOIN admon_advertisement_purchase AS purchase ON
(purchase.purchase_id = advertisement.purchase_id)
WHERE (advertisement.active = 1) AND ((advertisement.indefinite=1 OR (advertisement.start_date < 1591524871 AND advertisement.end_date > 1591524871))) AND ((advertisement.impressions < advertisement.impression_limit OR advertisement.impression_limit=0)) AND ((advertisement.clicks < advertisement.click_limit OR advertisement.click_limit=0)) AND ((advertisement.paused = 0))