SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_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 post.post_id IN (598573, 598278, 597344, 597054, 596875, 596371, 596364, 596362, 596308, 596305, 596289, 596278, 595626, 595625, 595541, 594978, 594882, 594786, 594524, 594099, 592480, 591407, 589784, 589434, 587597, 586258, 586152, 585580, 585094, 584958, 584878, 584767, 584724, 584713, 584685, 584675, 583561, 583526, 583525, 582591, 581787, 581675, 580245, 579914, 579908, 578282, 577388, 577381, 577301, 577033, 576934, 576280, 576014, 575992, 575810, 575592, 575375, 574502, 573699, 572284, 572268, 572091, 571961, 571675, 571254, 571158, 570883, 570516, 570391, 569653, 569125, 569118, 569012, 568849, 566918, 565370, 565008, 564416, 564306, 563227, 563226, 562767, 562699, 562554, 562550, 562479, 561173, 560416, 559938, 559739, 559732, 559552, 559538, 559475, 558063, 557079, 556889, 556863, 556179, 556037, 555746, 555586, 555496, 555356, 555353, 555110, 555096, 555042, 553623, 552989, 552573, 552571, 552297, 551998, 551229, 551227, 551195, 551186, 551144, 550916, 550669, 550565, 549667, 549028, 548235, 548231, 547875, 546507, 545661, 545660, 544257, 544090, 543231, 541768, 541346, 541015, 540999, 540965, 540300, 539778, 539730, 539646, 538849, 538847, 538776, 538756, 538729, 538728, 537538, 535894, 535374, 534887, 534864, 534511, 533563, 533478, 532949, 532935, 532773, 532542, 532123, 531527, 530432, 530036, 529282, 527838, 527582, 527440, 526052, 525904, 525638, 525291, 525274, 525260, 525246, 524866, 524795, 524161, 524157, 524083, 524082, 523949, 522928, 522282, 521085, 520508, 519808, 519776, 518948, 518560, 518194, 517646, 517079, 516547, 516513, 515253, 515157, 515007, 513437)
Run Time: 0.008573
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 199 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | degreeinfo_xenforo.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,degreeinfo_xenforo.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: [["post",598573],["post",598278],["post",597344],["post",597054],["post",596875],["post",596371],["post",596364],["post",596362],["post",596308],["post",596305],["post",596289],["post",596278],["post",595626],["post",595625],["post",595541],["post",594978],["post",594882],["post",594786],["post",594524],["post",594099],["post",592480],["post",591407],["post",589784],["post",589434],["post",587597],["post",586258],["post",586152],["post",585580],["post",585094],["post",584958],["post",584878],["post",584767],["post",584724],["post",584713],["post",584685],["post",584675],["post",583561],["post",583526],["post",583525],["post",582591],["post",581787],["post",581675],["post",580245],["post",579914],["post",579908],["post",578282],["post",577388],["post",577381],["post",577301],["thread",61581],["post",576934],["post",576280],["post",576014],["post",575992],["post",575810],["post",575592],["post",575375],["post",574502],["post",573699],["post",572284],["post",572268],["post",572091],["post",571961],["post",571675],["post",571254],["post",571158],["post",570883],["post",570516],["post",570391],["post",569653],["post",569125],["post",569118],["post",569012],["post",568849],["post",566918],["post",565370],["post",565008],["post",564416],["post",564306],["post",563227],["post",563226],["post",562767],["post",562699],["post",562554],["post",562550],["post",562479],["post",561173],["post",560416],["post",559938],["post",559739],["post",559732],["post",559552],["post",559538],["post",559475],["post",558063],["post",557079],["post",556889],["post",556863],["post",556179],["post",556037],["post",555746],["post",555586],["post",555496],["post",555356],["post",555353],["post",555110],["post",555096],["post",555042],["post",553623],["post",552989],["post",552573],["post",552571],["post",552297],["post",551998],["post",551229],["post",551227],["post",551195],["post",551186],["post",551144],["post",550916],["post",550669],["post",550565],["post",549667],["post",549028],["post",548235],["post",548231],["post",547875],["post",546507],["post",545661],["post",545660],["post",544257],["post",544090],["post",543231],["post",541768],["post",541346],["post",541015],["post",540999],["post",540965],["post",540300],["post",539778],["post",539730],["post",539646],["post",538849],["post",538847],["post",538776],["post",538756],["post",538729],["post",538728],["post",537538],["post",535894],["post",535374],["post",534887],["post",534864],["post",534511],["post",533563],["post",533478],["post",532949],["post",532935],["post",532773],["post",532542],["post",532123],["post",531527],["post",530432],["post",530036],["post",529282],["post",527838],["post",527582],["post",527440],["post",526052],["post",525904],["post",525638],["post",525291],["post",525274],["post",525260],["post",525246],["post",524866],["post",524795],["post",524161],["post",524157],["post",524083],["post",524082],["post",523949],["post",522928],["post",522282],["post",521085],["post",520508],["post",519808],["post",519776],["post",518948],["post",518560],["post",518194],["post",517646],["post",517079],["post",516547],["post",516513],["post",515253],["post",515157],["post",515007],["post",513437]], 199, , american college education, [], date, 0, , [], 0, 1716023612, a7c7f5e0e698357ba850ee456c311e3f
Run Time: 0.000638