SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
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_post AS post ON
(post.post_id = thread.first_post_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 (9650734, 9610591, 9610190, 9604616, 9603213, 9603212, 9602752, 9602440, 9602439, 9602438, 9602433, 9600375, 9597271, 9592427, 9582037, 9574425, 9572797, 9572793, 9572791, 9571181, 9570724, 9570450, 9569014, 9567713, 9567040, 9567039, 9563694, 9561078, 9560580, 9560577, 9558220, 9552168, 9539885, 9520187, 9514894, 9514893, 9514892, 9490858, 9486085, 9464536, 9460665, 9460166, 9460165, 9460164, 9459461, 9457884, 9454261, 9453368, 9453362, 9451917, 9451741, 9451738, 9451544, 9449921, 9449919, 9448478, 9445409, 9445408, 9437748, 9431692, 9423476, 9417693, 9413795, 9410282, 9405816, 9404304, 9403649, 9402659, 9399511, 9398981, 9397593, 9395834, 9395025, 9394594, 9388546, 9388545, 9388544, 9388543, 9370939, 9370937, 9370936, 9354635, 9318245, 9313837, 9313831, 9305290, 9298674, 9287857, 9287380, 9284659, 9284460, 9284459, 9268441, 9260245, 9257538, 9248157, 9241477, 9232128, 9226363, 9220957, 9211401, 9211281, 9210090, 9210089, 9204250, 9203258, 9196923, 9193078, 9192686, 9192097, 9189595, 9188942, 9188534, 9188129, 9188126, 9185087, 9184432, 9184190, 9183274, 9183259, 9177119, 9166694, 9165854, 9155632, 9155627, 9153871, 9152995, 9150697, 9150689, 9150031, 9150028, 9149681, 9149026, 9147693, 9144732, 9142185, 9139444, 9133805, 9133803, 9129576, 9125318, 9124355, 9121804, 9113527, 9111172, 9111171, 9106769, 9104452, 9100969, 9098188, 9095491, 9090799, 9077789, 9077155, 9070699, 9069796, 9068239, 9067518, 9067517, 9062463, 9060766, 9054599, 9047460, 9047458, 9046352, 9041488, 9039584, 9039583, 9034465, 9029850, 9028103, 9022221, 9021961, 9021242, 9021241, 9019351, 9007528, 9002594, 9002181, 8989977, 8986333, 8986331, 8986242, 8985951, 8984102, 8976816, 8975460, 8975459, 8969093, 8967920, 8967340, 8967339, 8967338, 8964169, 8963699, 8963201, 8961856, 8961855, 8961853, 8961852, 8961851, 8960610, 8956385, 8956384, 8956383, 8956382, 8956381, 8953113, 8949048, 8948951, 8948905, 8944439, 8944437, 8943102, 8943075, 8943074, 8943071, 8934560, 8934531, 8930589, 8925178, 8918162, 8918121, 8918029, 8918028, 8915667, 8915580, 8908426, 8908029, 8908028, 8907072, 8902937, 8902753, 8902599, 8902594, 8901487, 8901486, 8901485, 8901070, 8898555, 8896179, 8895842, 8895626, 8895513, 8894629, 8894400, 8892587, 8892428, 8892426, 8891461, 8890556, 8890301, 8887213, 8886976, 8886553, 8886136, 8886127, 8885281, 8885272, 8885033, 8885031, 8885030, 8885029, 8884740, 8884739, 8884729, 8883442, 8882958, 8882739, 8882533, 8882311, 8882303, 8882289, 8882060, 8881404, 8881293, 8880932, 8880569, 8880063, 8880062, 8878905, 8877709, 8877457, 8877167, 8876439, 8876409, 8876276, 8876045, 8875150, 8874845, 8873682, 8871437, 8870196, 8869503, 8868623, 8867359, 8867085, 8866563, 8866024, 8865868, 8864023, 8863511, 8862626, 8861562, 8861561, 8860154, 8858934, 8855491, 8855252, 8853932, 8853849, 8853439, 8852693, 8852377, 8852331, 8852330, 8851805, 8851797, 8848442, 8848167, 8847402, 8846978, 8846977, 8845977, 8845764, 8845100, 8843657, 8841458, 8841053, 8840170, 8837298, 8835536, 8834316, 8832789, 8832785, 8832784, 8832783, 8831114, 8830922, 8830226, 8829961, 8829785, 8829450, 8829310, 8829301, 8827003, 8827001, 8826284, 8826283, 8826281, 8825702, 8823606, 8822439, 8819378, 8813470, 8809932, 8808512, 8808511, 8808156, 8807785, 8807391, 8806965, 8806964, 8803655, 8801943, 8801653, 8800712, 8800056, 8798657, 8797711, 8796425, 8791122, 8788665, 8787752, 8787751, 8787722, 8787719, 8787718, 8787670, 8787142, 8786288, 8785628, 8785409, 8785407, 8783928, 8781978, 8781584, 8781183, 8779421, 8771245, 8771236, 8771235, 8769200, 8768386, 8768278, 8768064, 8767651, 8766655, 8765623, 8763857, 8762343, 8760130, 8758336, 8758335, 8756562, 8753580, 8753366, 8752669, 8751539, 8751412, 8751149, 8751102, 8750355, 8747850, 8747477, 8746687, 8745675, 8744214, 8744208, 8744194, 8743970, 8742597, 8741955, 8741558, 8740195, 8740194, 8740178, 8739369, 8738433, 8738273, 8738040, 8737088, 8736538, 8735591, 8734539, 8733056, 8732985, 8731894, 8730471, 8729894, 8728195, 8727433, 8726982, 8726965, 8726618, 8726277, 8725617, 8724900, 8724670, 8724519, 8723687, 8723653, 8723354, 8722747, 8722531, 8721682, 8720374, 8720225, 8717237, 8717120, 8716953, 8716951, 8716467, 8715555, 8715471, 8715217, 8714817, 8714807, 8714724, 8714553, 8713972, 8713750, 8712289, 8712288, 8712287, 8710422, 8710364, 8710193, 8709491, 8709490, 8708869, 8708857, 8707150, 8706035, 8706034, 8705685, 8704696, 8703495, 8703176, 8701473, 8697810, 8694143, 8693898, 8693121, 8689848, 8688672, 8687140, 8685025, 8684237, 8683105, 8683060, 8682284, 8681862, 8681557, 8681235, 8680949, 8680938, 8680544, 8680276, 8680275, 8680272, 8677187, 8676947, 8676946, 8676941, 8674472, 8674414, 8673653, 8673119, 8672957, 8671405, 8668498, 8666763, 8666761, 8665064, 8664936, 8664322, 8662983, 8662617, 8661678, 8661482, 8661359, 8661333, 8661164, 8660085, 8660075, 8659093, 8657666, 8656568, 8655631, 8654232, 8653156, 8651742, 8651293, 8650539, 8648412, 8646126, 8645924, 8644947, 8644794, 8639780, 8639749, 8639747, 8639745, 8639016, 8638574, 8638321, 8634195, 8634189, 8634185, 8634181, 8632805, 8632618, 8632153, 8631854, 8631853, 8631821, 8631820, 8631819, 8630746, 8630640, 8629629, 8629610, 8628338, 8621898, 8618476, 8614441, 8614168, 8613510, 8611662, 8611618, 8611224, 8606735, 8603695, 8602842, 8602250, 8602219, 8602218, 8602216, 8602208, 8600664, 8598956, 8598656, 8598562, 8598353, 8597279, 8594895, 8594022, 8591117, 8590483, 8589306, 8586465, 8586382, 8585426, 8583056, 8580858, 8579469, 8578984, 8577151, 8575881, 8575880, 8574480, 8567556, 8567236, 8566735, 8562270, 8562268, 8562265, 8558406, 8556681, 8555977, 8555671, 8551500, 8550955, 8548920, 8546963, 8545361, 8545184, 8544604, 8542915, 8539014, 8538682, 8537041, 8536078, 8535419, 8534376, 8534375, 8534374, 8533859, 8533858, 8532670, 8532424, 8531707, 8531468, 8531194, 8531190, 8528969, 8524613, 8524609, 8521973, 8521971, 8521580, 8521391, 8508541, 8507365, 8506088, 8503822, 8502367, 8501454, 8500419, 8500148, 8493240, 8491329, 8489151, 8480954, 8469816, 8465247, 8455610, 8454296, 8449302, 8449066, 8448017, 8447927, 8444075, 8441753, 8410387, 8393171, 8382766, 8368173, 8357924, 8349054, 8346881, 8345941, 8344625, 8338838, 8338127, 8331614, 8321917, 8319973, 8308650, 8305508, 8304806, 8304149, 8299800, 8282810, 8280509, 8278583, 8273733, 8272102, 8268050, 8263483, 8242095, 8242094)
Run Time: 0.015536
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 703 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.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: [["tinhte_xentag_forum",43],["thread",9650734],["thread",9610190],["thread",9602433],["thread",9572797],["thread",9572793],["thread",9572791],["thread",9552168],["thread",9486085],["thread",9460665],["thread",9451544],["thread",9423476],["thread",9404304],["thread",9403649],["thread",9397593],["thread",9287857],["thread",9248157],["thread",9226363],["thread",9211281],["thread",9210090],["thread",9142185],["thread",9125318],["thread",9124355],["thread",9111172],["thread",9100969],["thread",9067518],["thread",9062463],["thread",9054599],["thread",9034465],["thread",9007528],["thread",9002181],["thread",8985951],["thread",8976816],["thread",8969093],["thread",8967920],["thread",8963201],["thread",8961856],["thread",8953113],["thread",8943102],["thread",8934560],["thread",8934531],["thread",8918121],["thread",8915667],["thread",8908029],["thread",8895513],["thread",8886976],["thread",8886136],["thread",8886127],["thread",8882958],["thread",8882289],["thread",8880063],["thread",8878905],["thread",8876439],["thread",8874845],["thread",8862626],["thread",8860154],["thread",8855252],["thread",8845764],["thread",8835536],["thread",8834316],["thread",8827003],["thread",8813470],["thread",8803655],["thread",8797711],["thread",8791122],["thread",8787752],["thread",8787722],["thread",8786288],["thread",8785628],["thread",8781584],["thread",8769200],["thread",8763857],["thread",8760130],["thread",8753366],["thread",8751149],["thread",8751102],["thread",8747850],["thread",8747477],["thread",8746687],["thread",8744194],["thread",8742597],["thread",8741558],["thread",8738040],["thread",8734539],["thread",8730471],["thread",8722531],["thread",8716467],["thread",8713750],["thread",8710193],["thread",8706035],["thread",8704696],["thread",8703176],["thread",8697810],["thread",8693898],["thread",8689848],["thread",8684237],["thread",8683060],["thread",8682284],["thread",8681862],["thread",8681557],["thread",8680949],["thread",8680938],["thread",8680544],["thread",8677187],["thread",8676947],["thread",8673119],["thread",8671405],["thread",8662983],["thread",8662617],["thread",8661678],["thread",8659093],["thread",8656568],["thread",8654232],["thread",8639016],["thread",8634195],["thread",8632153],["thread",8629610],["thread",8628338],["thread",8621898],["thread",8614441],["thread",8606735],["thread",8602842],["thread",8600664],["thread",8598956],["thread",8598562],["thread",8598353],["thread",8597279],["thread",8589306],["thread",8586465],["thread",8585426],["thread",8583056],["thread",8580858],["thread",8579469],["thread",8578984],["thread",8575881],["thread",8567556],["thread",8566735],["thread",8562270],["thread",8558406],["thread",8556681],["thread",8555671],["thread",8550955],["thread",8545361],["thread",8542915],["thread",8539014],["thread",8538682],["thread",8537041],["thread",8536078],["thread",8535419],["thread",8534376],["thread",8532424],["thread",8531707],["thread",8528969],["thread",8524613],["thread",8507365],["thread",8503822],["thread",8502367],["thread",8501454],["thread",8500419],["thread",8500148],["thread",8493240],["thread",8491329],["thread",8489151],["thread",8480954],["thread",8469816],["thread",8454296],["thread",8449302],["thread",8448017],["thread",8447927],["thread",8441753],["thread",8410387],["thread",8393171],["thread",8382766],["thread",8368173],["thread",8357924],["thread",8349054],["thread",8346881],["thread",8345941],["thread",8344625],["thread",8338838],["thread",8338127],["thread",8331614],["thread",8321917],["thread",8319973],["thread",8308650],["thread",8305508],["thread",8304806],["thread",8304149],["thread",8299800],["thread",8282810],["thread",8280509],["thread",8278583],["thread",8273733],["thread",8272102],["thread",8268050],["thread",8263483]], 196, tinhte_xentag_tag, , {"tags":["vespa sprint"]}, date, 0, , [], 0, 1653203711, e7f9028f76fd2b7464f3f27226b25ea7
Run Time: 0.000696