Page Time: 0.3749s

Memory: 14.3150 MB (Peak: 15.7131 MB)

Queries (167, time: 0.1589s, 42.4%)

  1. 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.000424
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 26Using where
  2. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 2Using where
  3. SELECT active FROM xf_addon WHERE addon_id = 'NodesAsTabs'
    Run Time: 0.000072
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_addonconstPRIMARYPRIMARY27const1 
  4. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000093
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  5. 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: 48732
    Run Time: 0.000375
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  6. 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 > 1573729614, 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: 43
    Run Time: 0.000406
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
    SIMPLEforum_banconstnode_id,user_idnode_id8const,const0unique row not found
  7. 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: 48732
    Run Time: 0.000782
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  8. 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: 48732
    Run Time: 0.000745
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpostrangethread_id_post_date,thread_id_positionthread_id_position8 19Using index condition; Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4db25061_47.post.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4db25061_47.post.user_id1 
    SIMPLEuser_privacyeq_refPRIMARYPRIMARY4db25061_47.post.user_id1 
    SIMPLEsession_activityeq_refPRIMARYPRIMARY22db25061_47.post.user_id,func1Using where
  9.                 SELECT permission_combination_id, cache_value
                    FROM xf_permission_combination AS permission_combination
                    WHERE permission_combination_id in (?,?)
    Params: 2, 122
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpermission_combinationrangePRIMARYPRIMARY4 2Using where
  10. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 48732
    Run Time: 0.000083
  11. 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: 48732
    Run Time: 0.000208
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  12. 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 > 1573729614, 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: 43
    Run Time: 0.000217
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
    SIMPLEforum_banconstnode_id,user_idnode_id8const,const0unique row not found
  13. 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: 48732
    Run Time: 0.000174
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  14. 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 > 1573729614, 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: 43
    Run Time: 0.000205
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
    SIMPLEforum_banconstnode_id,user_idnode_id8const,const0unique row not found
  15. 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: 48732
    Run Time: 0.000487
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  16. 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: 48732
    Run Time: 0.000740
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpostrangethread_id_post_date,thread_id_positionthread_id_position8 1Using index condition; Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4db25061_47.post.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4db25061_47.post.user_id1 
    SIMPLEuser_privacyeq_refPRIMARYPRIMARY4db25061_47.post.user_id1 
    SIMPLEsession_activityeq_refPRIMARYPRIMARY22db25061_47.post.user_id,func1Using where
  17. INSERT INTO `xf_advog_log` (`log_date`, `user_id`, `content_id`, `message`) VALUES (?, ?, ?, ?)
    Params: 1573729614, 0, 48732, Loaded cache and it was valid. Tasks finished!
    Run Time: 0.000161
  18. SELECT * FROM EWRporta2_features WHERE thread_id = ?
    Params: 48732
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  19. 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: 48732
    Run Time: 0.000491
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  20. SELECT *
    FROM xf_node
    
    ORDER BY lft ASC
    Run Time: 0.000134
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALL    75Using filesort
  21. SELECT content_id, cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = 'node'
    Params: 1
    Run Time: 0.000109
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentrefPRIMARYPRIMARY31const,const76Using where
  22. SELECT params
    FROM xf_session_activity
    WHERE user_id = ?
    AND controller_action = 'CreateThread'
    Params: 0
    Run Time: 0.000371
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityrefPRIMARYPRIMARY4const657Using where
  23. 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 '%Interesse%'
    AND xf_thread.title LIKE '%Auswanderung%'
    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 <> '48732'
    
    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.047303
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_datepost_date4 14891Using index condition; Using where
    SIMPLExf_nodeeq_refPRIMARYPRIMARY4db25061_47.xf_thread.node_id1 
    SIMPLExf_usereq_refPRIMARYPRIMARY4db25061_47.xf_thread.user_id1 
  24. 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 '%Interesse%'
    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 <> '48732'
    
    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.048217
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_datepost_date4 14891Using index condition; Using where
    SIMPLExf_nodeeq_refPRIMARYPRIMARY4db25061_47.xf_thread.node_id1 
    SIMPLExf_usereq_refPRIMARYPRIMARY4db25061_47.xf_thread.user_id1 
  25. 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 '%Auswanderung%'
    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 <> '48732'
    
    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)
    
    
    AND xf_thread.thread_id <> 33839 AND xf_thread.thread_id <> 31551 AND xf_thread.thread_id <> 7575
    ORDER BY xf_thread.post_date DESC
    LIMIT ?
    Params: 0, 2
    Run Time: 0.017434
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_datepost_date4 14891Using index condition; Using where
    SIMPLExf_nodeeq_refPRIMARYPRIMARY4db25061_47.xf_thread.node_id1 
    SIMPLExf_usereq_refPRIMARYPRIMARY4db25061_47.xf_thread.user_id1 
  26. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: c8a21b215c6df67d320690a0f8761532, , 1573733214
    Run Time: 0.000224
  27. 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=48732, 1573729614,
    Run Time: 0.000163
  28. SELECT *
    	FROM EWRporta2_layouts
    WHERE (layout_template = ?
    	)
    	AND active = 1
    ORDER BY layout_priority ASC
    Params: thread_view
    Run Time: 0.000153
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_layoutsreflayout_templatelayout_template302const1Using index condition; Using where; Using filesort
  29. 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.000212
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_widlinksreflayout_id,widget_idlayout_id302const20Using index condition; Using where; Using filesort
    SIMPLEEWRporta2_widoptseq_refPRIMARYPRIMARY4db25061_47.EWRporta2_widlinks.widopt_id1 
    SIMPLEEWRporta2_widgetseq_refPRIMARYPRIMARY302db25061_47.EWRporta2_widlinks.widget_id1Using where
  30. SELECT *
    FROM bbm
    ORDER BY tag
    Run Time: 0.000366
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEbbmALL    4Using filesort
  31. SELECT *
    FROM xf_poll
    WHERE poll_id = ?
    Params: 0
    Run Time: 0.000122
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  32. 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 > 1573124814) 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.001241
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadrangenode_id_last_post_date,node_id_sticky_state_last_post,last_post_datelast_post_date4 65Using index condition; Using where
    SIMPLEforumeq_refPRIMARYPRIMARY4db25061_47.thread.node_id1Using where
    SIMPLEusereq_refPRIMARYPRIMARY4db25061_47.thread.user_id1 
    SIMPLElast_post_usereq_refPRIMARYPRIMARY4db25061_47.thread.last_post_user_id1 
    SIMPLEnodeeq_refPRIMARYPRIMARY4db25061_47.thread.node_id1 
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,db25061_47.thread.node_id1Using where
  33.     				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.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  34. 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  35.     				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.000058
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  36. 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.000055
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  37.     				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.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  38.     				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.000057
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  39.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 28, 0
    Run Time: 0.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  40. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 28
    Run Time: 0.000054
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  41.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 45, 0
    Run Time: 0.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  42. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 45
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  43.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 45, 0
    Run Time: 0.000055
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  44.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 7, 0
    Run Time: 0.000059
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  45. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 7
    Run Time: 0.000053
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  46.     				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.000055
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  47. 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.000053
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  48.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 7, 0
    Run Time: 0.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  49.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 45, 0
    Run Time: 0.000057
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  50.     				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.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  51. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 89
    Run Time: 0.000053
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  52.     				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.000054
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  53.     				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.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  54.     				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.000055
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  55.     				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.000054
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  56. 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.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  57.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 30, 0
    Run Time: 0.000053
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  58. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 30
    Run Time: 0.000052
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  59.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 7, 0
    Run Time: 0.000056
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  60.     				SELECT forum_ban_expiry_date,forum_ban_conf
        				FROM xfa_extmod_forum_ban
        				WHERE forum_ban_user_id = ?
        					AND forum_ban_user_id = ?
    Params: 40, 0
    Run Time: 0.000055
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  61. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 40
    Run Time: 0.000054
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  62.     				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.000054
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  63.                    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.000451
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEalbumrefPRIMARY,category_update_datecategory_update_date4const46Using temporary; Using filesort
    SIMPLEcategoryeq_refPRIMARYPRIMARY4db25061_47.album.category_id1 
    SIMPLEcontentrefalbum_id_positionalbum_id_position4db25061_47.album.album_id7Using where
    SIMPLEcontent_dataeq_refPRIMARY,content_type_idPRIMARY4db25061_47.content.content_data_id1 
    SIMPLEusereq_refPRIMARYPRIMARY4db25061_47.content.user_id1 
  64. SELECT data_value
    FROM xf_data_registry
    WHERE data_key = ?
    Params: admon_affiliateLinks
    Run Time: 0.000090
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 
  65. 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.000127
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 20Using where
  66. 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.000287
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEoptionsALLnode_id   45Using where; Using filesort
    SIMPLEnodeeq_refPRIMARYPRIMARY4db25061_47.options.node_id1 
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,db25061_47.options.node_id1Using where
  67. 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.000135
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnoderangePRIMARYPRIMARY4 5Using where; Using filesort
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,db25061_47.node.node_id1Using where
    SIMPLEoptionseq_refnode_idnode_id4db25061_47.node.node_id1 
  68. 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.000179
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 2Using where
  69. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('atendo2_calendar', 'ld_nav_title')
    Params: 4
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 2Using where
  70. 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.000145
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnoderangePRIMARYPRIMARY4 6Using where; Using filesort
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,db25061_47.node.node_id1Using where
    SIMPLEoptionseq_refnode_idnode_id4db25061_47.node.node_id1 
  71. 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnoderangePRIMARYPRIMARY4 7Using where; Using filesort
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,db25061_47.node.node_id1Using where
    SIMPLEoptionseq_refnode_idnode_id4db25061_47.node.node_id1 
  72. 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.000136
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnoderangePRIMARYPRIMARY4 2Using where; Using filesort
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,db25061_47.node.node_id1Using where
    SIMPLEoptionseq_refnode_idnode_id4db25061_47.node.node_id1 
  73. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000661
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  74. 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.000208
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 15Using where
  75. 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.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 
  76. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000415
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  77. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  78. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  79. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000368
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  80. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  81. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000366
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  82. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  83. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  84. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  85. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  86. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  87. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000364
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  88. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  89. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000363
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  90. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  91. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  92. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  93. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000355
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  94. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000368
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  95. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000357
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  96. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  97. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000350
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  98. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  99. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  100. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000354
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  101. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000363
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  102. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000363
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  103. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  104. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  105. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000346
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  106. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000360
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  107. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  108. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000348
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  109. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000344
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  110. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000359
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  111. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000347
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  112. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000344
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  113. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000353
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  114. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000359
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  115. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000350
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  116. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000345
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  117. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000341
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  118. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000357
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  119. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000354
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  120. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000345
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  121. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000342
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  122. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000356
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  123. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000355
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  124. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  125. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000350
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  126. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000357
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  127. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000350
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  128. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000346
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  129. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  130. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000437
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  131. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  132. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  133. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000347
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  134. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  135. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000360
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  136. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  137. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000345
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  138. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  139. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  140. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000349
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  141. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000350
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  142. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  143. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000354
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  144. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000349
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  145. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000347
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  146. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  147. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000362
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  148. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  149. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000360
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  150. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000359
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  151. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000347
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  152. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000357
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  153. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000357
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  154. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  155. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000361
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  156. 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.000097
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 
  157. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000470
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  158. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000399
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  159. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  160. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  161. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  162. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  163. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  164. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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 TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  165. 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 < 1573729614 AND advertisement.end_date > 1573729614))) 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.000372
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEadvertisementALL    1Using where
    SIMPLEzoneeq_refPRIMARYPRIMARY52db25061_47.advertisement.advertisement_zone1Using where
    SIMPLEpurchaseeq_refPRIMARYPRIMARY4db25061_47.advertisement.purchase_id1 
  166. 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.000080
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 
  167. 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.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 

Included Files (264, XenForo Classes: 75)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Db.php
  19. library/Zend/Db/Adapter/Mysqli.php
  20. library/Zend/Db/Adapter/Abstract.php
  21. library/Zend/Db/Select.php
  22. library/Zend/Db/Expr.php
  23. library/Zend/Db/Profiler.php
  24. library/Zend/Db/Statement/Mysqli.php
  25. library/Zend/Db/Statement.php
  26. library/Zend/Db/Statement/Interface.php
  27. library/Zend/Db/Profiler/Query.php
  28. library/XenForo/CodeEvent.php
  29. library/XenForo/Options.php
  30. library/XenForo/Link.php
  31. library/XenForo/Template/Helper/Core.php
  32. library/phc/EUCookie/Listener/Listener.php
  33. library/XenForo/ControllerPublic/Abstract.php
  34. library/XenForo/Controller.php
  35. library/phc/EUCookie/Extend/XenForo/Helper/Cookie.php
  36. library/phc/LinkDirectory/Listener/Listener.php
  37. library/EWRatendo2/Listener/Init.php
  38. library/TPUSigPic/Listener.php
  39. library/Waindigo/Listener/InitDependencies.php
  40. library/Waindigo/Listener/InitDependencies/20150106.php
  41. library/XenDACH/GDPR/Listener.php
  42. library/Waindigo/Listener/ControllerPreDispatch/20150106.php
  43. library/EWRporta2/Listener/Init.php
  44. library/XFA/ExtendedModeration/Proxy.php
  45. library/Brivium/BriviumHelper/EventListeners.php
  46. library/Brivium/BriviumHelper/1010071/EventListeners.php
  47. library/TMS/Listener.php
  48. library/sonnb/XenGallery/Listener.php
  49. library/bdPaygate/Listener.php
  50. library/Dark/TaigaChat/EventListener/Listener.php
  51. library/phc/HideLinks/Listener/Listener.php
  52. library/BBM/Listeners/AllInOne.php
  53. library/Waindigo/Library/Listener/InitDependencies.php
  54. library/XenForo/CacheRebuilder/Abstract.php
  55. library/NodesAsTabs/Listen.php
  56. library/Audentio/AdManager/Listener/CodeEvent.php
  57. library/bdPaygate/ShippableHelper/Updater.php
  58. library/bdPaygate/Option.php
  59. library/Sedo/TinyQuattro/Listener/AllInOne.php
  60. library/XenForo/Router.php
  61. library/XenForo/Route/Filter.php
  62. library/XenForo/Route/Interface.php
  63. library/XenForo/Route/ResponseSuffix.php
  64. library/XenForo/Route/Prefix.php
  65. library/XenForo/Route/Prefix/Threads.php
  66. library/XenForo/RouteMatch.php
  67. library/BBM/Protection/Helper/ContentProtection.php
  68. library/XenForo/ControllerPublic/Thread.php
  69. library/Waindigo/Library/Listener/LoadClass.php
  70. library/Waindigo/Listener/LoadClass.php
  71. library/Waindigo/Listener/LoadClass/20150106.php
  72. library/TagEss/Listener.php
  73. library/WMTech/UserSelfDeleteLite/Listener.php
  74. library/LimitLanguageUsage/Static.php
  75. library/sonnbSmilesBulkImporter/Listener.php
  76. library/EWRatendo2/Listener/Controller.php
  77. library/EndlessHorizon/AdvOG/Listener.php
  78. library/WMTech/DoublePost/Listener.php
  79. library/EWRporta2/Listener/Controller.php
  80. library/RainDD/UserActivity/Listener.php
  81. library/Andy/SimilarThreads/Listener.php
  82. library/ChangeThreadStarter/Listener.php
  83. library/HidePollResults/Listener.php
  84. library/Waindigo/Library/Extend/XenForo/ControllerPublic/Thread.php
  85. library/Audentio/AdManager/Extend/XenForo/ControllerPublic/Thread.php
  86. library/TagEss/XenForo/ControllerPublic/Thread.php
  87. library/phc/LinkDirectory/Extend/XenForo/ControllerPublic/Thread.php
  88. library/Brivium/AdvancedRules/ControllerPublic/Thread.php
  89. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  90. library/NodesAsTabs/ControllerPublic/Thread.php
  91. library/EWRatendo2/ControllerPublic/Thread.php
  92. library/EndlessHorizon/AdvOG/ControllerPublic/Thread.php
  93. library/WMTech/DoublePost/ControllerPublic/Thread.php
  94. library/EWRporta2/ControllerPublic/Thread.php
  95. library/XFA/ExtendedModeration/ControllerPublic/Thread.php
  96. library/RainDD/UserActivity/Controller/ThreadViewers.php
  97. library/RainDD/UserActivity/Controller/ThreadReaders.php
  98. library/Andy/SimilarThreads/ControllerPublic/Thread.php
  99. library/ChangeThreadStarter/ControllerPublic/Thread.php
  100. library/HidePollResults/ControllerPublic/Thread.php
  101. library/XenForo/Input.php
  102. library/XenForo/Session.php
  103. library/XenForo/Helper/Ip.php
  104. library/XenForo/Visitor.php
  105. library/XenForo/Model/User.php
  106. library/EWRporta2/Listener/Model.php
  107. library/SV/CanWarnStaff/Listener.php
  108. library/sonnb/XenGallery/XenForo/Model/User.php
  109. library/EWRporta2/Model/User.php
  110. library/XFA/ExtendedModeration/Model/User.php
  111. library/SV/CanWarnStaff/XenForo/Model/User.php
  112. library/XenForo/Permission.php
  113. library/XenForo/Helper/Php.php
  114. library/XenForo/Phrase.php
  115. library/XenForo/Locale.php
  116. library/XFA/ExtendedModeration/Visitor.php
  117. library/EWRatendo2/Model/Perms.php
  118. library/EWRporta2/Model/Perms.php
  119. library/GritterNotifications/Listener.php
  120. library/UnreadPostCount/Listener.php
  121. library/TemplateSyntax/Listen.php
  122. library/XenForo/ControllerHelper/ForumThreadPost.php
  123. library/XenForo/ControllerHelper/Abstract.php
  124. library/XenForo/Model/Thread.php
  125. library/Waindigo/IgnoreNewPosts/Listener/LoadClass.php
  126. library/Waindigo/IgnoreNewPosts/Extend/XenForo/Model/Thread.php
  127. library/Waindigo/Library/Extend/XenForo/Model/Thread.php
  128. library/bdPaygate/XenForo/Model/Thread.php
  129. library/XFA/ExtendedModeration/Model/Thread.php
  130. library/UnreadPostCount/Model/Thread.php
  131. library/SV/CanWarnStaff/XenForo/Model/Thread.php
  132. library/TagEss/XenForo/Model/Thread.php
  133. library/XenForo/Model/Forum.php
  134. library/XFA/ExtendedModeration/Model/Forum.php
  135. library/XenForo/Helper/String.php
  136. library/XenForo/Helper/Discussion.php
  137. library/XenForo/Model/Post.php
  138. library/phc/HideLinks/Extend/Model/Post.php
  139. library/EWRporta2/Model/Post.php
  140. library/XFA/ExtendedModeration/Model/Post.php
  141. library/SV/CanWarnStaff/XenForo/Model/Post.php
  142. library/EWRporta2/Model/Articles.php
  143. library/XenForo/Model/Attachment.php
  144. library/XFA/ExtendedModeration/Model/Attachment.php
  145. library/XenForo/Model/Node.php
  146. library/XenForo/Route/Prefix/Categories.php
  147. library/XenForo/Route/Prefix/Forums.php
  148. library/XenForo/ControllerResponse/View.php
  149. library/XenForo/ControllerResponse/Abstract.php
  150. library/EndlessHorizon/AdvOG/Model/Log.php
  151. library/EWRporta2/Model/Features.php
  152. library/Andy/SimilarThreads/Model.php
  153. library/XenForo/NodeHandler/Category.php
  154. library/XenForo/NodeHandler/Abstract.php
  155. library/XenForo/NodeHandler/Forum.php
  156. library/Waindigo/Library/NodeHandler/Library.php
  157. library/XenForo/NodeHandler/LinkForum.php
  158. library/XenForo/NodeHandler/Page.php
  159. library/XenForo/Model/Category.php
  160. library/Waindigo/Library/Model/Library.php
  161. library/XenForo/Model/LinkForum.php
  162. library/XenForo/Model/Page.php
  163. library/XenForo/Db.php
  164. library/NodesAsTabs/API.php
  165. library/NodesAsTabs/Model/Options.php
  166. library/XenForo/ViewRenderer/HtmlPublic.php
  167. library/XenForo/ViewRenderer/Abstract.php
  168. library/XenForo/Template/Public.php
  169. library/XenForo/Template/Abstract.php
  170. library/XenForo/ViewPublic/Thread/View.php
  171. library/XenForo/ViewPublic/Base.php
  172. library/XenForo/View.php
  173. library/EWRporta2/Listener/ViewPublic.php
  174. library/ControlNoFollow/Listener.php
  175. library/EWRporta2/ViewPublic/Global.php
  176. library/ControlNoFollow/ViewPublic/Thread/View.php
  177. library/phc/HideLinks/Extend/ViewPublic/Threads.php
  178. library/EWRporta2/Model/Layouts.php
  179. library/EWRporta2/Model/Widlinks.php
  180. library/XenForo/BbCode/Parser.php
  181. library/XenForo/BbCode/Formatter/Base.php
  182. library/Waindigo/KeywordReplace/Listener/LoadClass.php
  183. library/EWRatendo2/Listener/BbCode.php
  184. library/EWRporta2/Listener/BbCode.php
  185. library/Waindigo/KeywordReplace/Extend/XenForo/BbCode/Formatter/Base.php
  186. library/Audentio/AdManager/Extend/XenForo/BbCode/Formatter/Base.php
  187. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  188. library/phc/HideLinks/Extend/BbCode/Formatter/Base.php
  189. library/EWRatendo2/BbCode/Formatter.php
  190. library/WMTech/DoublePost/BbCode/Formatter/Base.php
  191. library/TPUSigPic/BbCodeFormatterBase.php
  192. library/EWRporta2/BbCode/Formatter.php
  193. library/BBM/BbCode/Formatter/Base.php
  194. library/Sedo/TinyQuattro/BbCode/Formatter/Base.php
  195. library/BBM/Helper/Bbm.php
  196. library/BBM/Model/BbCodes.php
  197. library/Sedo/TinyQuattro/Helper/Quattro.php
  198. library/Sedo/TinyQuattro/Helper/BbCodes.php
  199. library/rellect/AdblockDetector/Listener/Hook.php
  200. library/XFA/ExtendedModeration/Template.php
  201. library/EWRporta2/Widget/PollBlock.php
  202. library/XenForo/Model/Poll.php
  203. library/HidePollResults/Model/Poll.php
  204. library/EWRporta2/Widget/Threads.php
  205. library/XenForo/Model/PermissionCache.php
  206. library/EWRporta2/Widget/TwTimeline.php
  207. library/EWRporta2/Widget/sonnbXenGalleryPhoto.php
  208. library/sonnb/XenGallery/Model/Content.php
  209. library/sonnb/XenGallery/Model/Abstract.php
  210. library/sonnb/XenGallery/Model/Photo.php
  211. library/sonnb/XenGallery/Model/Collection.php
  212. library/sonnb/XenGallery/Route/Prefix/XenGallery.php
  213. library/sonnb/XenGallery/Model/ContentData.php
  214. library/sonnb/XenGallery/Model/Video.php
  215. library/sonnb/XenGallery/Model/Album.php
  216. library/sonnb/XenGallery/Model/Category.php
  217. library/sonnb/XenGallery/Model/Gallery.php
  218. library/XenForo/ViewPublic/Helper/Message.php
  219. library/XenForo/BbCode/TextWrapper.php
  220. library/phc/HideLinks/Helper/Helper.php
  221. library/phc/HideLinks/Model/HideLinks.php
  222. library/Waindigo/KeywordReplace/Helper/String.php
  223. library/Audentio/AdManager/Helper/String.php
  224. library/Audentio/AdManager/Model/AffiliateLink.php
  225. library/ITM/ctSSB/Listener.php
  226. library/SolidMean/ForumBackup/Listener/Template.php
  227. library/Waindigo/Library/Listener/TemplatePostRender.php
  228. library/Waindigo/Listener/TemplatePostRender.php
  229. library/Waindigo/Listener/TemplatePostRender/20140711.php
  230. library/Waindigo/Listener/Template.php
  231. library/Waindigo/Listener/Template/20141020.php
  232. library/Audentio/AdManager/Model/Advertisement.php
  233. library/XenForo/Route/Prefix/Members.php
  234. library/memberMap/Listener/Navigation.php
  235. library/memberMap/Model/ViewMap.php
  236. library/EWRporta2/Listener/NavTabs.php
  237. library/XenDACH/GDPR/Listener/LegalPolicy.php
  238. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  239. library/EWRatendo2/Listener/NavTabs.php
  240. library/phc/LinkDirectory/Model/Links.php
  241. library/phc/LinkDirectory/Route/Prefix/LD.php
  242. library/NodesAsTabs/NavTabs.php
  243. library/XenForo/Route/Prefix/LinkForums.php
  244. library/Waindigo/Library/Route/Prefix/Libraries.php
  245. library/XenForo/Route/Prefix/Pages.php
  246. library/rellect/AdblockDetector/Model/AdBlock.php
  247. library/Sedo/TinyQuattro/Listener/Templates/Preloader.php
  248. library/XenForo/Route/Prefix/Tags.php
  249. library/Brivium/AdvancedRules/Listener.php
  250. library/EWRporta2/Listener/Template.php
  251. library/XenFacil/BirthdayGreetings/Listener/Listener.php
  252. library/Waindigo/Library/Listener/TemplateHook.php
  253. library/Waindigo/Listener/TemplateHook.php
  254. library/Waindigo/Listener/TemplateHook/20141020.php
  255. library/Audentio/AdManager/Template/Helper/Core.php
  256. library/XenForo/Route/Prefix/Posts.php
  257. library/XenForo/Model/Avatar.php
  258. library/XenForo/Helper/Criteria.php
  259. library/XenForo/Debug.php
  260. library/BBM/Helper/BbCodes.php
  261. library/BBM/Listeners/Templates/Public.php
  262. library/XenForo/ViewRenderer/Json.php
  263. library/GritterNotifications/Template/Callback.php
  264. library/GritterNotifications/Model/Notification.php