SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000450
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT active FROM xf_addon WHERE addon_id = 'NodesAsTabs'
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra,
0 AS xfa_extmod_trban_conf
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 47183
Run Time: 0.000400
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
forum_ban_conf, IF(forum_ban.forum_ban_user_id IS NULL, 0,
IF(forum_ban.forum_ban_expiry_date IS NULL OR forum_ban.forum_ban_expiry_date > 1576278936, 1, 0)) AS forum_banned
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
LEFT JOIN xfa_extmod_forum_ban AS forum_ban
ON (forum_ban.forum_ban_node_id = forum.node_id
AND forum_ban.forum_ban_user_id = 0)
WHERE node.node_id = ?
Params: 89
Run Time: 0.000419
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | forum_ban | const | node_id,user_id | node_id | 8 | const,const | 0 | unique row not found |
SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
FROM EWRporta2_articles
INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.thread_id = ?
Params: 47183
Run Time: 0.000785
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT post.*
,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 20)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 47183
Run Time: 0.000937
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 13 | Using index condition; Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.post.user_id | 1 | |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | db25061_47.post.user_id,func | 1 | Using where |
SELECT permission_combination_id, cache_value
FROM xf_permission_combination AS permission_combination
WHERE permission_combination_id in (?,?)
Params: 100, 122
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | permission_combination | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
INSERT DELAYED INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 47183
Run Time: 0.000090
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra,
0 AS xfa_extmod_trban_conf
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 47183
Run Time: 0.000209
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
forum_ban_conf, IF(forum_ban.forum_ban_user_id IS NULL, 0,
IF(forum_ban.forum_ban_expiry_date IS NULL OR forum_ban.forum_ban_expiry_date > 1576278936, 1, 0)) AS forum_banned
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
LEFT JOIN xfa_extmod_forum_ban AS forum_ban
ON (forum_ban.forum_ban_node_id = forum.node_id
AND forum_ban.forum_ban_user_id = 0)
WHERE node.node_id = ?
Params: 89
Run Time: 0.000226
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | forum_ban | const | node_id,user_id | node_id | 8 | const,const | 0 | unique row not found |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar,
NULL AS thread_read_date,
0 AS thread_reply_banned,
0 AS thread_is_watched,
'' AS draft_message, NULL AS draft_extra,
0 AS xfa_extmod_trban_conf
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE thread.thread_id = ?
Params: 47183
Run Time: 0.000185
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
forum_ban_conf, IF(forum_ban.forum_ban_user_id IS NULL, 0,
IF(forum_ban.forum_ban_expiry_date IS NULL OR forum_ban.forum_ban_expiry_date > 1576278936, 1, 0)) AS forum_banned
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
LEFT JOIN xfa_extmod_forum_ban AS forum_ban
ON (forum_ban.forum_ban_node_id = forum.node_id
AND forum_ban.forum_ban_user_id = 0)
WHERE node.node_id = ?
Params: 89
Run Time: 0.000216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | forum_ban | const | node_id,user_id | node_id | 8 | const,const | 0 | unique row not found |
SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
FROM EWRporta2_articles
INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.thread_id = ?
Params: 47183
Run Time: 0.000488
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT post.*
,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
session_activity.view_date AS last_view_date,
0 AS like_date
FROM xf_post AS post
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
WHERE post.thread_id = ?
AND (post.position >= 0 AND post.position < 1)
AND (post.message_state IN ('visible'))
ORDER BY post.position ASC, post.post_date ASC
Params: 47183
Run Time: 0.000829
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 1 | Using index condition; Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.post.user_id | 1 | |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | db25061_47.post.user_id,func | 1 | Using where |
INSERT INTO `xf_advog_log` (`log_date`, `user_id`, `content_id`, `message`) VALUES (?, ?, ?, ?)
Params: 1576278936, 0, 47183, Loaded cache and it was valid. Tasks finished!
Run Time: 0.000165
SELECT * FROM EWRporta2_features WHERE thread_id = ?
Params: 47183
Run Time: 0.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
FROM EWRporta2_articles
INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
WHERE EWRporta2_articles.thread_id = ?
Params: 47183
Run Time: 0.000491
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 75 | Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 76 | Using where |
SELECT params
FROM xf_session_activity
WHERE user_id = ?
AND controller_action = 'CreateThread'
Params: 0
Run Time: 0.000297
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | ref | PRIMARY | PRIMARY | 4 | const | 297 | Using where |
SELECT xf_thread.thread_id,
xf_thread.node_id,
xf_thread.title,
xf_thread.reply_count,
xf_thread.view_count,
xf_thread.username,
xf_thread.post_date,
xf_thread.last_post_date,
xf_thread.last_post_user_id,
xf_thread.last_post_username,
xf_thread.prefix_id,
xf_node.title AS nodeTitle,
xf_user.user_id,
xf_user.gender,
xf_user.avatar_date
FROM xf_thread
INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
WHERE xf_thread.title LIKE '%Besuch%'
AND xf_thread.title LIKE '%beim%'
AND xf_thread.title LIKE '%Winzer%'
AND xf_thread.discussion_state = 'visible'
AND xf_thread.discussion_type <> 'redirect'
AND xf_thread.post_date >= ?
AND (xf_thread.node_id = 4 OR xf_thread.node_id = 8 OR xf_thread.node_id = 9 OR xf_thread.node_id = 34 OR xf_thread.node_id = 22 OR xf_thread.node_id = 24 OR xf_thread.node_id = 3 OR xf_thread.node_id = 40 OR xf_thread.node_id = 16 OR xf_thread.node_id = 30 OR xf_thread.node_id = 29 OR xf_thread.node_id = 28 OR xf_thread.node_id = 25 OR xf_thread.node_id = 89 OR xf_thread.node_id = 7 OR xf_thread.node_id = 23 OR xf_thread.node_id = 43 OR xf_thread.node_id = 11 OR xf_thread.node_id = 35 OR xf_thread.node_id = 36 OR xf_thread.node_id = 37 OR xf_thread.node_id = 47 OR xf_thread.node_id = 38 OR xf_thread.node_id = 90 OR xf_thread.node_id = 26 OR xf_thread.node_id = 19 OR xf_thread.node_id = 27 OR xf_thread.node_id = 33 OR xf_thread.node_id = 46 OR xf_thread.node_id = 45 OR xf_thread.node_id = 31 OR xf_thread.node_id = 32 OR xf_thread.node_id = 10 OR xf_thread.node_id = 17 OR xf_thread.node_id = 48 OR xf_thread.node_id = 44 OR xf_thread.node_id = 41 OR xf_thread.node_id = 21 OR xf_thread.node_id = 20 OR xf_thread.node_id = 5 OR xf_thread.node_id = 14 OR xf_thread.node_id = 13 OR xf_thread.node_id = 93 OR xf_thread.node_id = 18 OR xf_thread.node_id = 54 OR xf_thread.node_id = 68 OR xf_thread.node_id = 69 OR xf_thread.node_id = 71 OR xf_thread.node_id = 72 OR xf_thread.node_id = 73 OR xf_thread.node_id = 82 OR xf_thread.node_id = 84 OR xf_thread.node_id = 86 OR xf_thread.node_id = 74 OR xf_thread.node_id = 75 OR xf_thread.node_id = 78 OR xf_thread.node_id = 79 OR xf_thread.node_id = 80 OR xf_thread.node_id = 92 OR xf_thread.node_id = 77 OR xf_thread.node_id = 76 OR xf_thread.node_id = 70 OR xf_thread.node_id = 64 OR xf_thread.node_id = 66 OR xf_thread.node_id = 67 OR xf_thread.node_id = 81 OR xf_thread.node_id = 87 OR xf_thread.node_id = 85 OR xf_thread.node_id = 60)
AND xf_thread.thread_id <> '47183'
AND (xf_thread.node_id <> 8 AND xf_thread.node_id <> 9 AND xf_thread.node_id <> 34 AND xf_thread.node_id <> 22 AND xf_thread.node_id <> 24 AND xf_thread.node_id <> 10 AND xf_thread.node_id <> 17 AND xf_thread.node_id <> 48 AND xf_thread.node_id <> 14 AND xf_thread.node_id <> 13 AND xf_thread.node_id <> 18 AND xf_thread.node_id <> 12 AND xf_thread.node_id <> 15 AND xf_thread.node_id <> 39)
ORDER BY xf_thread.post_date DESC
LIMIT ?
Params: 0, 5
Run Time: 0.003567
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_date | post_date | 4 | | 14924 | Using index condition; Using where |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.xf_thread.node_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.xf_thread.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: a324ad6cbb6c238a6d46ec7b08069e53, , 1576282536
Run Time: 0.000166
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=47183, 1576278936,
Run Time: 0.000143
SELECT *
FROM EWRporta2_layouts
WHERE (layout_template = ?
)
AND active = 1
ORDER BY layout_priority ASC
Params: thread_view
Run Time: 0.000111
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta2_layouts | ref | layout_template | layout_template | 302 | const | 1 | Using index condition; Using where; Using filesort |
SELECT EWRporta2_widlinks.*, EWRporta2_widgets.widget_values, EWRporta2_widopts.widopt_values,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.widopt_id, 0) AS widopt_id,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.locked, EWRporta2_widgets.locked) AS locked,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.display, EWRporta2_widgets.display) AS display,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.groups, EWRporta2_widgets.groups) AS groups,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.ctime, EWRporta2_widgets.ctime) AS ctime,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cdate, EWRporta2_widgets.cdate) AS cdate,
IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cache, EWRporta2_widgets.cache) AS cache
FROM EWRporta2_widlinks
INNER JOIN EWRporta2_widgets ON (EWRporta2_widgets.widget_id = EWRporta2_widlinks.widget_id)
LEFT JOIN EWRporta2_widopts ON (EWRporta2_widopts.widopt_id = EWRporta2_widlinks.widopt_id)
WHERE layout_id = ?
AND EWRporta2_widgets.active = 1
ORDER by widlink_order
Params: thread_view
Run Time: 0.000240
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta2_widlinks | ref | layout_id,widget_id | layout_id | 302 | const | 20 | Using index condition; Using where; Using filesort |
SIMPLE | EWRporta2_widopts | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.EWRporta2_widlinks.widopt_id | 1 | |
SIMPLE | EWRporta2_widgets | eq_ref | PRIMARY | PRIMARY | 302 | db25061_47.EWRporta2_widlinks.widget_id | 1 | Using where |
SELECT *
FROM bbm
ORDER BY tag
Run Time: 0.000374
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | bbm | ALL | | | | | 4 | Using filesort |
SELECT *
FROM xf_poll
WHERE poll_id = ?
Params: 0
Run Time: 0.000129
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
last_post_user.gender AS last_post_gender,
last_post_user.avatar_date AS last_post_avatar_date,
last_post_user.gravatar AS last_post_gravatar,
IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
node.title AS node_title, node.node_name,
forum.*,
forum.last_post_id AS forum_last_post_id,
forum.last_post_date AS forum_last_post_date,
forum.last_post_user_id AS forum_last_post_user_id,
forum.last_post_username AS forum_last_post_username,
forum.last_thread_title AS forum_last_thread_title,
thread.last_post_id,
thread.last_post_date,
thread.last_post_user_id,
thread.last_post_username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.node_id = thread.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE (thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1575674136) AND (forum.find_new = 1) AND 1=1 AND thread.node_id IN ('24', '3', '40', '49', '16', '30', '29', '28', '25', '89', '7', '23', '43', '11', '35', '36', '37', '47', '38', '90', '26', '19', '27', '33', '46', '45', '31', '32', '10', '17', '48', '44', '41', '21', '20')
ORDER BY thread.last_post_date DESC
LIMIT 20
Run Time: 0.001458
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | node_id_last_post_date,node_id_sticky_state_last_post,last_post_date | last_post_date | 4 | | 60 | Using index condition; Using where |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.node_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.user_id | 1 | |
SIMPLE | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.last_post_user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.thread.node_id | 1 | Using where |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 25, 0
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 25
Run Time: 0.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 23, 0
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 23
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 35, 0
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 35
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 20, 0
Run Time: 0.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 20
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 23, 0
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 37, 0
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 37
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 31, 0
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 31
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 11, 0
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 11
Run Time: 0.000069
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 19, 0
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 19
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 89, 0
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 11, 0
Run Time: 0.000074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 11, 0
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 20, 0
Run Time: 0.000075
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 31, 0
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 43, 0
Run Time: 0.000075
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 43
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 20, 0
Run Time: 0.000074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 16, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 16
Run Time: 0.000068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 19, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 16, 0
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT forum_ban_expiry_date,forum_ban_conf
FROM xfa_extmod_forum_ban
WHERE forum_ban_user_id = ?
AND forum_ban_user_id = ?
Params: 16, 0
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT content.*
,
album.category_id, album.album_state, album.album_type,
album.content_count, album.photo_count, album.video_count, album.audio_count,
album.album_privacy, album.album_location,
album.cover_content_id, album.cover_content_type,
album.latest_content_ids, album.latest_photo_ids, album.latest_video_ids, album.latest_audio_ids,
album.album_date, album.album_updated_date,
album.title AS album_title, album.description AS album_description,
album.user_id AS album_user_id, album.username AS album_username,
album.comment_count AS album_comment_count,
album.view_count AS album_view_count,
album.likes AS album_likes, album.like_users AS album_like_users,
album.latest_comment_ids AS album_latest_comment_ids,
album.collection_id AS album_collection_id,
category.category_privacy
,
0 AS following_0,
IF(user.username IS NULL, content.username, user.username) AS username, user.avatar_date, user.gravatar,
content_data.*,
0 AS following_0
FROM `sonnb_xengallery_content` AS content
INNER JOIN `sonnb_xengallery_album` AS album ON
(album.album_id = content.album_id)
LEFT JOIN `sonnb_xengallery_category` AS category ON
(album.category_id = category.category_id)
LEFT JOIN `xf_user` AS user ON
(user.user_id = content.user_id)
INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
(content.content_data_id = content_data.content_data_id)
WHERE (content.content_type = 'photo') AND (album.category_id = '1') AND (content.content_state = 'visible')
ORDER BY content.view_count DESC, content.position ASC
LIMIT 18
Run Time: 0.000470
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ref | PRIMARY,category_update_date | category_update_date | 4 | const | 46 | Using temporary; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.album.category_id | 1 | |
SIMPLE | content | ref | album_id_position | album_id_position | 4 | db25061_47.album.album_id | 7 | Using where |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | db25061_47.content.content_data_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.content.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: admon_affiliateLinks
Run Time: 0.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'quattro_bbcode_xtable', 'bbm_viewer_content_protected', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'sonnb_xengallery_bbcode_photo', 'sonnb_xengallery_bbcode_video', 'sonnb_xengallery_bbcode_album', 'doublepost_bb_code_tag', '__bbm_tool_template', 'EWRwidget_PollBlock', 'EWRwidget_RawHtml', 'EWRwidget_Threads', 'EWRwidget_FbLikeBox', 'EWRwidget_TwTimeline', 'EWRwidget_sonnbXenGalleryPhoto')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 20 | Using where |
SELECT options.*, node.*,
permission.cache_value AS node_permission_cache
FROM nat_options AS options
INNER JOIN xf_node AS node
ON (node.node_id = options.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = options.node_id)
WHERE nat_display_tab = 1
ORDER BY options.nat_display_order
ASC
Params: 1
Run Time: 0.000278
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | options | ALL | node_id | | | | 45 | Using where; Using filesort |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.options.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,db25061_47.options.node_id | 1 | 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 (68, 69, 71, 72, 73)
ORDER BY node.lft
ASC
Params: 1
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | range | PRIMARY | PRIMARY | 4 | | 5 | 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 title, template_compiled
FROM xf_template_compiled
WHERE title IN ('thread_view', 'nat_childlinks')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000199
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('atendo2_calendar', 'ld_nav_title')
Params: 4
Run Time: 0.000079
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.000147
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.000142
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.000140
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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000672
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('notice_cookies', 'EWRporta2_Navtabs', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_navbar_template', 'dark_taigachat_links', 'EWRatendo2_Navtabs', 'nat_linkstemplate', 'ld_sub_nav', 'sonnb_xengallery_nav_visitor', 'dark_taigachat', 'dark_taigachat_list', 'GritterNotifications', 'PAGE_CONTAINER', 'waindigo_thread_view_tabs_library')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000219
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 15 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('ld_thread_view_tools_links')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000085
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 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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000407
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000397
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000394
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000387
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000378
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000375
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000384
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000386
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000380
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000378
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000380
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000377
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000379
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000377
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000377
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000376
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000377
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000377
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000384
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000379
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000378
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000374
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000378
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000375
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000369
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000380
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000376
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000375
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000387
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000376
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000376
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000099
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 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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000406
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000387
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000379
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000384
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_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 < 1576278936 AND advertisement.end_date > 1576278936))) 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))
Run Time: 0.000389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | advertisement | ALL | | | | | 1 | Using where |
SIMPLE | zone | eq_ref | PRIMARY | PRIMARY | 52 | db25061_47.advertisement.advertisement_zone | 1 | Using where |
SIMPLE | purchase | eq_ref | PRIMARY | PRIMARY | 4 | db25061_47.advertisement.purchase_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRAFR_navigation_tabs_link')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000079
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 ('nat_bodyjs')
AND style_id = ?
AND language_id = ?
Params: 2, 4
Run Time: 0.000088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |