Page Time: 3.0965s

Memory: 9.3993 MB (Peak: 10.5302 MB)

Queries (261, time: 2.4771s, 80.0%)

  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.000692
    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.000107
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 2Using where
  3. SELECT data_value
    FROM xf_data_registry
    WHERE data_key = ?
    Params: brmsModernStatisticCache
    Run Time: 0.000114
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 
  4. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  5. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: d2777517862ffe0bdf8cdee08a0a6b39, a:7:{s:12:"sessionStart";i:1542458826;s:2:"ip";s:4:"6R]t";s:11:"sessionCsrf";s:16:"JEfrcvkDRFCtS0wa";s:9:"userAgent";s:40:"CCBot/2.0 (https://commoncrawl.org/faq/)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1431379682;}}, 1542462426
    Run Time: 0.000263
  6. 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, 6R]t, 6R]t, EWRporta_ControllerPublic_Portal, Index, valid, , 1542458826,
    Run Time: 0.000161
  7. SELECT *
    	FROM EWRporta_layouts
    WHERE layout_id = ?
    Params: portal
    Run Time: 0.005459
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta_layoutsconstPRIMARYPRIMARY77const1 
  8. SELECT *, 'disabled' AS position
    	FROM EWRporta_blocks
    WHERE active = 1
    ORDER BY block_id ASC
    Run Time: 0.004980
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta_blocksindex PRIMARY77 27Using where
  9. SELECT * FROM EWRporta_caches
    Run Time: 0.001133
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta_cachesALL    19 
  10. SELECT * FROM EWRporta_options
    Run Time: 0.000352
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta_optionsALL    240 
  11. SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title, 
    	IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
    	IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
    	EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
    FROM xf_thread
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
    	LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
    
    WHERE (xf_thread.node_id IN ('108', '54', '188', '56', '216', '96', '70', '129', '182', '74', '217', '166', '173', '171', '185', '151', '149', '199', '242', '244', '58', '197', '202', '203', '204', '143', '144', '145', '146', '187', '240', '241', '238', '181', '135', '18', '178', '179', '225', '230', '183', '136', '4', '5', '6', '8', '147') OR EWRporta_promotes.promote_date < ?)
    	AND xf_thread.discussion_state = 'visible'
    	AND (? - xf_thread.post_date) < ?*86400
    	AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
    ORDER BY  view_count DESC, promote_date DESC
    LIMIT ?, ?
    Params: 1542458826, 1542458826, 3, 1542458826, 0, 10
    Run Time: 0.127347
    <
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALLPRIMARY   85Using temporary; Using filesort
    SIMPLExf_threadrefnode_id_last_post_date,node_id_sticky_state_last_postnode_id_last_post_date4widchan1_hmo.xf_node.node_id58Using where
    SIMPLEEWRporta_promoteseq_refPRIMARYPRIMARY4widchan1_hmo.xf_thread.thread_id1Using where
    SIMPLExf_usereq_refPRIMARYPRIMARY4widchan1_hmo.xf_thread.user_id1 
    SIMPLExf_posteq_refPRIMARYPRIMARY4widchan1_hmo.xf_thread.first_post_id1