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, session.view_date
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)LEFT OUTER JOIN xf_session_activity AS session ON post.user_id = session.user_id
WHERE post.post_id IN (810239, 809613, 806471, 806453, 806452, 806143, 806005, 806002, 806000, 805977, 805941, 805939, 805401, 805390, 805147, 804687, 804686, 798635, 798599, 797073, 793704, 793586, 791314, 790864, 790849, 789511, 789505, 789497, 789463, 788387, 788266, 788263, 788202, 788185, 788174, 786745, 784330, 784292, 783470, 783468, 780872, 778080, 777393, 768647, 768643, 768590, 768588, 765047, 765031, 762785, 760583, 760560, 757423, 757172, 756725, 752051, 751124, 742765, 742508, 739393, 738813, 738777, 738733, 738711, 737405, 731929, 728774, 728539, 728512, 726404, 726403, 722119, 713534, 713517, 713515, 713465, 713393, 713373, 712458, 712433, 711939, 711924, 710297, 710277, 708967, 699302, 696763, 694809, 692610, 692602, 692530, 687989, 687964, 683206, 682938, 682848, 682832, 682466, 682408, 682393, 681570, 681544, 680515, 675807, 675792, 675726, 673598, 673397, 672816, 672693, 669655, 667283, 660808, 660801, 656313, 656103, 654145, 654021, 650628, 647711, 647174, 647170, 636779, 634081, 621594, 621314, 621304, 609052, 605307, 605279, 604936, 601092, 600930, 593321, 593124, 591472, 585399, 585095, 583969, 583362, 583187, 582966, 581287, 581286, 581281, 580232, 580220, 576184, 571128, 570575, 570236, 567919, 567587, 567226, 567218, 566165, 566137, 562320, 560674, 560538, 559256, 556829, 552418, 551431, 549405, 549390, 549331, 549305, 549054, 549034, 549029, 549014, 544244, 543676, 529454, 527058, 519568, 519525, 517679, 515317, 515137, 515001, 514991, 500176, 499441, 497622, 497387, 493653, 492400, 491752, 486847, 486844, 483071, 481834, 481357, 481235, 481038, 475265)
Run Time: 0.005975
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 | | 198 | Using where |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | krainamaystriv.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | krainamaystriv.thread.node_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | krainamaystriv.post.user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,krainamaystriv.thread.node_id | 1 | Using where |
SIMPLE | session | ref | PRIMARY | PRIMARY | 4 | krainamaystriv.post.user_id | 22 | |
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",810239],["post",809613],["post",806471],["post",806453],["post",806452],["post",806143],["post",806005],["post",806002],["post",806000],["post",805977],["post",805941],["post",805939],["post",805401],["post",805390],["post",805147],["post",804687],["post",804686],["post",798635],["post",798599],["post",797073],["post",793704],["post",793586],["post",791314],["post",790864],["post",790849],["post",789511],["post",789505],["post",789497],["post",789463],["post",788387],["post",788266],["post",788263],["post",788202],["post",788185],["post",788174],["post",786745],["post",784330],["post",784292],["post",783470],["post",783468],["post",780872],["post",778080],["post",777393],["post",768647],["post",768643],["post",768590],["post",768588],["post",765047],["post",765031],["post",762785],["post",760583],["post",760560],["post",757423],["post",757172],["post",756725],["post",752051],["post",751124],["post",742765],["post",742508],["post",739393],["post",738813],["post",738777],["post",738733],["post",738711],["post",737405],["post",731929],["post",728774],["post",728539],["post",728512],["post",726404],["post",726403],["post",722119],["post",713534],["post",713517],["post",713515],["post",713465],["post",713393],["post",713373],["post",712458],["post",712433],["post",711939],["post",711924],["post",710297],["post",710277],["post",708967],["post",699302],["post",696763],["post",694809],["post",692610],["post",692602],["post",692530],["post",687989],["post",687964],["post",683206],["post",682938],["post",682848],["post",682832],["post",682466],["post",682408],["post",682393],["post",681570],["post",681544],["post",680515],["post",675807],["post",675792],["post",675726],["post",673598],["post",673397],["post",672816],["post",672693],["post",669655],["post",667283],["post",660808],["post",660801],["post",656313],["post",656103],["post",654145],["post",654021],["post",650628],["post",647711],["post",647174],["post",647170],["thread",26761],["post",634081],["post",621594],["post",621314],["post",621304],["post",609052],["post",605307],["post",605279],["post",604936],["post",601092],["post",600930],["post",593321],["post",593124],["post",591472],["post",585399],["post",585095],["post",583969],["post",583362],["post",583187],["post",582966],["post",581287],["post",581286],["post",581281],["post",580232],["post",580220],["post",576184],["post",571128],["post",570575],["post",570236],["post",567919],["post",567587],["post",567226],["post",567218],["post",566165],["post",566137],["post",562320],["post",560674],["post",560538],["post",559256],["post",556829],["post",552418],["post",551431],["post",549405],["post",549390],["post",549331],["post",549305],["thread",24385],["post",549034],["post",549029],["post",549014],["post",544244],["post",543676],["post",529454],["post",527058],["post",519568],["post",519525],["post",517679],["post",515317],["post",515137],["post",515001],["post",514991],["post",500176],["post",499441],["post",497622],["post",497387],["post",493653],["post",492400],["post",491752],["post",486847],["post",486844],["post",483071],["post",481834],["post",481357],["post",481235],["post",481038],["post",475265]], 198, , теплоаккумулятор, [], date, 0, , [], 0, 1715221861, d7746d044ad530eef8334f3760d64329
Run Time: 0.026769