SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
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_node AS node ON
(node.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.thread_id IN (100303, 101078, 35574, 55126, 101081, 101088, 101090, 101091, 101084, 100838, 101079, 56810, 101089, 101065, 100990, 101085, 101073, 101068, 92042, 101046, 99982, 99782, 53169, 100960, 101086, 101066, 101072, 101027, 77793, 100424, 101087, 101083, 101082, 101070, 101061, 98500, 101080, 100493, 99246, 100005, 100971, 100779, 100714, 101077, 100301, 101057, 100948, 101041, 101076, 100311, 101024, 101071, 85176, 101074, 101075, 101044, 101069, 101043, 100564, 101060, 101009, 100028, 101040, 101054, 100465, 100937, 101042, 101029, 101008, 101064, 101037, 101049, 101062, 100862, 101053, 101036, 101050, 100998, 101031, 100900, 99218, 101058, 101059, 101055, 100961, 101056, 99748, 35599, 101052, 100558, 85940, 100959, 100919, 101051, 100923, 101002, 101047, 99935, 101022, 98829, 101048, 20121, 101033, 100929, 101045, 101013, 100785, 61472, 101035, 100818, 91926, 101025, 101039, 101019, 101038, 100866, 101032, 101034, 100958, 101026, 100972, 101003, 100454, 100994, 101000, 101011, 101005, 101028, 101007, 101012, 100976, 83478, 101010, 101023, 101004, 101021, 101020, 101018, 101017, 101016, 101015, 101014, 100999, 101006, 99677, 101001, 100991, 100997, 100995, 96226, 100964, 13172, 100992, 90886, 100989, 100986, 100993, 97429, 100973, 85862, 100987, 100970, 100954, 100975, 100981, 100984, 100793, 100968, 100974, 100827, 100969, 100965, 100950, 100955, 100962, 100966, 6652, 100857, 100917, 11492, 100952, 100384, 100963, 100953, 92789, 100951, 100949, 100957, 100944, 100956, 100932, 100947, 100131, 100895, 100262, 100946, 100722, 97293, 100884, 100945)
Run Time: 0.004494
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using index condition |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | thelatebayv2_.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | thelatebayv2_.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thelatebayv2_.thread.node_id | 1 | Using where |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["thread",100303],["thread",101078],["thread",35574],["thread",55126],["thread",101081],["thread",101088],["thread",101090],["thread",101091],["thread",101084],["thread",100838],["thread",101079],["thread",56810],["thread",101089],["thread",101065],["thread",100990],["thread",101085],["thread",101073],["thread",101068],["thread",92042],["thread",101046],["thread",99982],["thread",99782],["thread",53169],["thread",100960],["thread",101086],["thread",101066],["thread",101072],["thread",101027],["thread",77793],["thread",101087],["thread",101083],["thread",101082],["thread",101070],["thread",101061],["thread",98500],["thread",101080],["thread",100493],["thread",99246],["thread",100005],["thread",100971],["thread",100779],["thread",100714],["thread",101077],["thread",100301],["thread",101057],["thread",100948],["thread",101041],["thread",101076],["thread",100311],["thread",101024],["thread",101071],["thread",85176],["thread",101075],["thread",101044],["thread",101069],["thread",101043],["thread",100564],["thread",101060],["thread",101009],["thread",101040],["thread",101054],["thread",100465],["thread",100937],["thread",101042],["thread",101029],["thread",101008],["thread",101064],["thread",101037],["thread",101049],["thread",101062],["thread",101053],["thread",101036],["thread",101050],["thread",100998],["thread",101031],["thread",100900],["thread",99218],["thread",101058],["thread",101059],["thread",101055],["thread",100961],["thread",101056],["thread",99748],["thread",35599],["thread",101052],["thread",100558],["thread",85940],["thread",100959],["thread",100919],["thread",101051],["thread",100923],["thread",101002],["thread",101047],["thread",99935],["thread",101022],["thread",98829],["thread",101048],["thread",20121],["thread",101033],["thread",100929],["thread",101045],["thread",101013],["thread",100785],["thread",61472],["thread",101035],["thread",100818],["thread",91926],["thread",101025],["thread",101039],["thread",101019],["thread",101038],["thread",100866],["thread",101032],["thread",101034],["thread",100958],["thread",101026],["thread",100972],["thread",101003],["thread",100454],["thread",100994],["thread",101000],["thread",101011],["thread",101005],["thread",101028],["thread",101007],["thread",101012],["thread",100976],["thread",83478],["thread",101010],["thread",101023],["thread",101004],["thread",101021],["thread",101020],["thread",101018],["thread",101017],["thread",101016],["thread",101015],["thread",101014],["thread",100999],["thread",101006],["thread",99677],["thread",101001],["thread",100991],["thread",100997],["thread",100995],["thread",96226],["thread",100964],["thread",13172],["thread",100992],["thread",90886],["thread",100989],["thread",100986],["thread",97429],["thread",100973],["thread",85862],["thread",100987],["thread",100970],["thread",100954],["thread",100975],["thread",100981],["thread",100984],["thread",100793],["thread",100968],["thread",100974],["thread",100827],["thread",100969],["thread",100965],["thread",100950],["thread",100955],["thread",100962],["thread",100966],["thread",6652],["thread",100857],["thread",100917],["thread",11492],["thread",100952],["thread",100384],["thread",100963],["thread",100953],["thread",92789],["thread",100951],["thread",100949],["thread",100957],["thread",100944],["thread",100956],["thread",100932],["thread",100947],["thread",100131],["thread",100895],["thread",100262],["thread",100946],["thread",100722],["thread",100884],["thread",100945]], 194, recent-posts, , [], date, 0, , [], 0, 1711617862, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000251