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 (35574, 101202, 100303, 99935, 101204, 56810, 101191, 55126, 101189, 77793, 101135, 101203, 100937, 101041, 98213, 101160, 101181, 68437, 101201, 90886, 101141, 101200, 101163, 101166, 101198, 101199, 101185, 101194, 101176, 101168, 101157, 101127, 101196, 100866, 99246, 101164, 101146, 101197, 101184, 101071, 101186, 101190, 101193, 100964, 98829, 101178, 101195, 101192, 101126, 101114, 101188, 100493, 101171, 101187, 101180, 101151, 101179, 134, 100948, 87947, 101172, 101177, 101174, 92042, 101165, 101175, 101148, 97293, 99814, 101173, 85940, 101169, 101091, 101075, 101170, 101138, 101131, 101137, 101129, 101161, 101162, 101136, 101145, 101132, 95333, 101094, 98182, 83478, 101152, 101033, 101119, 101120, 101133, 101061, 101159, 101158, 98593, 101055, 101156, 587, 101084, 101118, 101154, 101155, 101153, 101149, 101150, 101009, 101112, 101147, 101140, 101144, 101143, 101142, 101002, 101111, 101139, 101107, 35599, 101122, 101130, 101128, 101123, 101125, 100797, 101092, 101124, 101115, 100960, 101088, 101121, 101105, 101095, 101110, 101102, 101113, 91926, 101106, 101078, 101099, 101100, 101109, 101108, 101046, 101104, 101103, 101085, 101101, 101098, 97329, 101093, 101068, 73914, 101090, 101096, 101076, 101097, 100301, 100973, 101060, 13172, 100990, 99982, 98500, 101077, 99218, 61472, 101081, 100838, 101079, 101089, 101065, 101073, 99782, 53169, 101086, 101066, 101072, 101027, 100424, 101087, 101083, 101082, 101070, 101080, 100005, 100971, 100779, 100714, 101057, 100311, 101024, 85176, 101074, 101044, 101069, 101043, 100564, 100028, 101040)
Run Time: 0.003393
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",35574],["thread",101202],["thread",100303],["thread",99935],["thread",101204],["thread",56810],["thread",101191],["thread",55126],["thread",101189],["thread",77793],["thread",101135],["thread",101203],["thread",100937],["thread",101041],["thread",98213],["thread",101160],["thread",101181],["thread",68437],["thread",101201],["thread",90886],["thread",101141],["thread",101200],["thread",101163],["thread",101166],["thread",101198],["thread",101199],["thread",101185],["thread",101194],["thread",101176],["thread",101168],["thread",101157],["thread",101127],["thread",101196],["thread",100866],["thread",99246],["thread",101164],["thread",101146],["thread",101197],["thread",101184],["thread",101071],["thread",101186],["thread",101190],["thread",101193],["thread",100964],["thread",98829],["thread",101178],["thread",101195],["thread",101126],["thread",101114],["thread",101188],["thread",100493],["thread",101171],["thread",101187],["thread",101180],["thread",101151],["thread",101179],["thread",134],["thread",100948],["thread",87947],["thread",101172],["thread",101174],["thread",92042],["thread",101165],["thread",101175],["thread",101148],["thread",99814],["thread",101173],["thread",85940],["thread",101169],["thread",101091],["thread",101075],["thread",101170],["thread",101138],["thread",101131],["thread",101137],["thread",101129],["thread",101161],["thread",101162],["thread",101136],["thread",101145],["thread",101132],["thread",95333],["thread",101094],["thread",98182],["thread",83478],["thread",101152],["thread",101033],["thread",101119],["thread",101120],["thread",101133],["thread",101061],["thread",101159],["thread",101158],["thread",98593],["thread",101055],["thread",101156],["thread",587],["thread",101084],["thread",101118],["thread",101154],["thread",101155],["thread",101153],["thread",101149],["thread",101150],["thread",101009],["thread",101112],["thread",101147],["thread",101140],["thread",101144],["thread",101143],["thread",101142],["thread",101002],["thread",101111],["thread",101139],["thread",35599],["thread",101122],["thread",101130],["thread",101128],["thread",101123],["thread",101125],["thread",100797],["thread",101092],["thread",101124],["thread",101115],["thread",100960],["thread",101088],["thread",101121],["thread",101105],["thread",101095],["thread",101110],["thread",101102],["thread",101113],["thread",91926],["thread",101106],["thread",101078],["thread",101099],["thread",101100],["thread",101109],["thread",101108],["thread",101046],["thread",101104],["thread",101103],["thread",101085],["thread",101101],["thread",101098],["thread",97329],["thread",101093],["thread",101068],["thread",73914],["thread",101090],["thread",101096],["thread",101076],["thread",101097],["thread",100301],["thread",100973],["thread",101060],["thread",13172],["thread",100990],["thread",99982],["thread",98500],["thread",101077],["thread",99218],["thread",61472],["thread",101081],["thread",100838],["thread",101079],["thread",101089],["thread",101065],["thread",101073],["thread",99782],["thread",53169],["thread",101086],["thread",101066],["thread",101072],["thread",101027],["thread",101087],["thread",101083],["thread",101082],["thread",101070],["thread",101080],["thread",100005],["thread",100971],["thread",100779],["thread",100714],["thread",101057],["thread",100311],["thread",101024],["thread",85176],["thread",101044],["thread",101069],["thread",101043],["thread",100564],["thread",101040]], 193, recent-posts, , [], date, 0, , [], 0, 1713428176, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000206