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 (5082, 5081, 5080, 5078, 5077, 5075, 5074, 5072, 5071, 5070, 5069, 5068, 5066, 5065, 5064, 5063, 5062, 5061, 5060, 5059, 5058, 5057, 5056, 5055, 5054, 5053, 5052, 5050, 5049, 5048, 5047, 5045, 5044, 5043, 5042, 5040, 5038, 5037, 5036, 5035, 5034, 5032, 5031, 5029, 5028, 5027, 5024, 5023, 5022, 5021, 5020, 5019, 5018, 5017, 5016, 5015, 5009, 5008, 5007, 5006, 5005, 5004, 5002, 5001, 5000, 4999, 4998, 4997, 4996, 4995, 4994, 4993, 4992, 4991, 4990, 4989, 4988, 4987, 4986, 4985, 4984, 4983, 4981, 4980, 4979, 4978, 4977, 4976, 4975, 4974, 4972, 4971, 4970, 4969, 4968, 4967, 4966, 4965, 4963, 4962, 4961, 4960, 4959, 4958, 4957, 4956, 4955, 4954, 4953, 4952, 4951, 4950, 4949, 4946, 4945, 4944, 4943, 4942, 4939, 4938, 4937, 4936, 4935, 4934, 4933, 4932, 4931, 4930, 4929, 4928, 4927, 4926, 4925, 4924, 4923, 4922, 4921, 4920, 4919, 4918, 4917, 4916, 4915, 4914, 4911, 4910, 4909, 4908, 4907, 4906, 4905, 4904, 4903, 4902, 4901, 4900, 4899, 4898, 4895, 4893, 4892, 4890, 4888, 4887, 4886, 4885, 4883, 4882, 4881, 4880, 4879, 4878, 4877, 4876, 4875, 4874, 4873, 4872, 4871, 4870, 4869, 4868, 4867, 4865, 4864, 4862, 4861, 4860, 4859, 4858, 4857, 4854, 4853, 4852, 4851)
Run Time: 0.000650
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 195 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | chiase_org_b978.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chiase_org_b978.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chiase_org_b978.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",5082],["thread",5081],["thread",5080],["thread",5078],["thread",5077],["thread",5075],["thread",5074],["thread",5072],["thread",5071],["thread",5070],["thread",5069],["thread",5068],["thread",5066],["thread",5065],["thread",5064],["thread",5063],["thread",5062],["thread",5061],["thread",5060],["thread",5059],["thread",5058],["thread",5057],["thread",5056],["thread",5055],["thread",5054],["thread",5053],["thread",5052],["thread",5050],["thread",5049],["thread",5048],["thread",5047],["thread",5045],["thread",5044],["thread",5043],["thread",5042],["thread",5040],["thread",5038],["thread",5037],["thread",5036],["thread",5035],["thread",5034],["thread",5032],["thread",5031],["thread",5029],["thread",5028],["thread",5027],["thread",5024],["thread",5023],["thread",5022],["thread",5021],["thread",5020],["thread",5019],["thread",5018],["thread",5017],["thread",5016],["thread",5015],["thread",5009],["thread",5008],["thread",5007],["thread",5006],["thread",5005],["thread",5004],["thread",5002],["thread",5001],["thread",5000],["thread",4999],["thread",4998],["thread",4997],["thread",4996],["thread",4995],["thread",4994],["thread",4993],["thread",4992],["thread",4991],["thread",4990],["thread",4989],["thread",4988],["thread",4987],["thread",4986],["thread",4985],["thread",4984],["thread",4983],["thread",4981],["thread",4980],["thread",4979],["thread",4978],["thread",4977],["thread",4976],["thread",4975],["thread",4974],["thread",4972],["thread",4971],["thread",4970],["thread",4969],["thread",4968],["thread",4967],["thread",4966],["thread",4965],["thread",4963],["thread",4962],["thread",4961],["thread",4960],["thread",4959],["thread",4958],["thread",4957],["thread",4956],["thread",4955],["thread",4954],["thread",4953],["thread",4952],["thread",4951],["thread",4950],["thread",4949],["thread",4946],["thread",4945],["thread",4944],["thread",4943],["thread",4942],["thread",4939],["thread",4938],["thread",4937],["thread",4936],["thread",4935],["thread",4934],["thread",4933],["thread",4932],["thread",4931],["thread",4930],["thread",4929],["thread",4928],["thread",4927],["thread",4926],["thread",4925],["thread",4924],["thread",4923],["thread",4922],["thread",4921],["thread",4920],["thread",4919],["thread",4918],["thread",4917],["thread",4916],["thread",4915],["thread",4914],["thread",4911],["thread",4910],["thread",4909],["thread",4908],["thread",4907],["thread",4906],["thread",4905],["thread",4904],["thread",4903],["thread",4902],["thread",4901],["thread",4900],["thread",4899],["thread",4898],["thread",4895],["thread",4893],["thread",4892],["thread",4890],["thread",4888],["thread",4887],["thread",4886],["thread",4885],["thread",4883],["thread",4882],["thread",4881],["thread",4880],["thread",4879],["thread",4878],["thread",4877],["thread",4876],["thread",4875],["thread",4874],["thread",4873],["thread",4872],["thread",4871],["thread",4870],["thread",4869],["thread",4868],["thread",4867],["thread",4865],["thread",4864],["thread",4862],["thread",4861],["thread",4860],["thread",4859],["thread",4858],["thread",4857],["thread",4854],["thread",4853],["thread",4852],["thread",4851]], 195, recent-posts, , [], date, 0, , [], 0, 1619165865, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000218