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 (9603651, 9601350, 9577070, 9519154, 9518735, 9516677, 9514965, 9479355, 9459065, 9459064, 9451116, 9448365, 9445885, 9445090, 9442265, 9437841, 9420560, 9419456, 9407445, 9397166, 9383361, 9376117, 9376037, 9370248, 9366643, 9365916, 9362565, 9359374, 9359373, 9354224, 9350133, 9340285, 9336255, 9334464, 9334133, 9332574, 9332473, 9332472, 9332295, 9331500, 9331499, 9329161, 9327467, 9327346, 9325923, 9325382, 9325023, 9323890, 9323131, 9321751, 9319669, 9318689, 9316647, 9316635, 9314690, 9314573, 9313416, 9312214, 9311753, 9310820, 9305313, 9303239, 9298626, 9296611, 9291717, 9290051, 9282298, 9281821, 9278758, 9277349, 9277145, 9275889, 9271296, 9266826, 9264544, 9257583, 9256877, 9255006, 9253080, 9245912, 9243612, 9241010, 9237119, 9236221, 9236217, 9236208, 9236205, 9236197, 9236191, 9233665, 9233637, 9232538, 9231433, 9230851, 9230096, 9230026, 9229658, 9228910, 9227804, 9226502, 9224023, 9223205, 9223141, 9222013, 9221618, 9221463, 9220901, 9220010, 9219701, 9219316, 9218466, 9217934, 9217292, 9215703, 9215046, 9212120, 9210568, 9209464, 9209024, 9207848, 9206809, 9205680, 9204973, 9202266, 9202232, 9198873, 9198580, 9195933, 9195033, 9188563, 9188504, 9188490, 9188445, 9187506, 9187030, 9187029, 9185190, 9184112, 9183998, 9183997, 9183431, 9183406, 9182993, 9182201, 9180744, 9180743, 9180569, 9179434, 9178771, 9177645, 9177059, 9176807, 9176023, 9175669, 9175189, 9175129, 9173868, 9172640, 9172637, 9171476, 9170718, 9169382, 9169357, 9169133, 9169002, 9164877, 9164843, 9164842, 9164840, 9162769, 9162369, 9162368, 9162111, 9159685, 9159492, 9159129, 9158484, 9156745, 9155912, 9155894, 9155396, 9151504, 9146709, 9146708, 9146707, 9146705, 9145931, 9145927, 9145895, 9143455, 9142422, 9141402, 9140134, 9139270, 9138134, 9137284, 9137090, 9131701, 9131055, 9131054, 9130316, 9130109, 9129006, 9129005, 9128842, 9128299, 9126852, 9126422, 9125618, 9125019, 9123254, 9121737, 9121563, 9118914, 9118533, 9115857, 9114692, 9114575, 9114243, 9114224, 9112645, 9111752, 9110971, 9110187, 9108358, 9104518, 9103319, 9102855, 9102146, 9101368, 9100427, 9100359, 9100271, 9099563, 9098736, 9097686, 9097099, 9097061, 9095271, 9095268, 9094900, 9094217, 9093055, 9092933, 9092552, 9092548, 9092346, 9092070, 9091667, 9090688, 9089081, 9087377, 9086332, 9086293, 9086284, 9083856, 9082935, 9082419, 9080611, 9080536, 9078504, 9076469, 9076466, 9076067, 9075805, 9075473, 9075435, 9075305, 9075094, 9073174, 9072915, 9072322, 9072174, 9072170, 9070567, 9070079, 9069912, 9069117, 9068895, 9067365, 9066676, 9066429, 9065583, 9063499, 9061197, 9061115, 9058622, 9058347, 9058089, 9057668, 9056964, 9056877, 9056824, 9056802, 9055860, 9055832, 9052337, 9052336, 9050799, 9048513, 9048352, 9048351, 9048350, 9047036, 9045981, 9045907, 9044177, 9043106, 9039932, 9039124, 9038519, 9037959, 9035080, 9032545, 9032537, 9031328, 9031031, 9030860, 9030350, 9030349, 9026396, 9025730, 9025135, 9024219, 9023074, 9022482, 9021232, 9021231, 9020118, 9018674, 9017191, 9015311, 9014484, 9014258, 9013182, 9012000, 9010770, 9010098, 9009395, 9009039, 9009038, 9004915, 9004437, 8996199, 8994754, 8993177, 8990270, 8989263, 8987721, 8986614, 8984997, 8984839, 8984758, 8978425, 8978411, 8978403, 8976041, 8974971, 8972623, 8967297, 8967296, 8967220, 8964483, 8962411, 8961231, 8952398, 8951443, 8950795, 8950791, 8950444, 8950230, 8949791, 8949790, 8949403, 8948975, 8948662, 8945439, 8945217, 8944724, 8944721, 8941598, 8940033, 8939961, 8939591, 8933602, 8933560, 8933550, 8931676, 8931166, 8930042, 8929591, 8927955, 8927953, 8927532, 8926896, 8926895, 8926081, 8925774, 8922165, 8922157, 8921921, 8916009, 8915925, 8915731, 8915725, 8912873, 8908985, 8907880, 8906438, 8906434, 8903664, 8902162, 8901123, 8901054, 8898015, 8897762, 8897761, 8897633, 8896747, 8894830, 8894581, 8894366, 8893460, 8892199, 8892084, 8891907, 8891019, 8890945, 8890392, 8890306, 8890203, 8889570, 8889568, 8889094, 8888727, 8888581, 8888438, 8888319, 8888154, 8887783, 8887646, 8887554, 8887553, 8887259, 8887252, 8886865, 8886861, 8886591, 8886590, 8886443, 8886442, 8886147, 8886146, 8885932, 8885931, 8885790, 8885720, 8885670, 8885668, 8885563, 8885561, 8885533, 8885404, 8885398, 8885085, 8884578, 8884464, 8884458, 8884453, 8884452, 8884094, 8884033, 8884017, 8883805, 8883717, 8883217, 8883194, 8883156, 8882899, 8881210, 8881209, 8881107, 8879534, 8879077, 8877361, 8877122, 8876851, 8876428, 8876148, 8875981, 8875508, 8875135, 8874149, 8872018, 8871333, 8870920, 8870556, 8870555, 8870473, 8870223, 8869940, 8869761, 8869363, 8869316, 8869315, 8869314, 8869092, 8868350, 8868333, 8867641, 8867138, 8866942, 8866431, 8866220, 8866119, 8866113, 8866030, 8866018, 8865960, 8865957, 8865568, 8865403, 8865298, 8864866, 8864786, 8864593, 8864449, 8864342, 8864340, 8864164, 8864161, 8864096, 8864045, 8864043, 8864037, 8862601, 8862597, 8861272, 8860728, 8860727, 8860224, 8860208, 8859405, 8859197, 8858979, 8858946, 8858943, 8858809, 8858386, 8858264, 8858258, 8857979, 8857822, 8857819, 8857311, 8857309, 8857066, 8857065, 8857062, 8857057, 8856854, 8856851, 8856622, 8856618, 8856491, 8856488, 8856486, 8856045, 8856043, 8855833, 8855831, 8855793, 8855459, 8855457, 8855454, 8855300, 8855297, 8854965, 8854899, 8854731, 8854544, 8854535, 8854045, 8853556, 8853284, 8853074, 8853072, 8852824, 8852005, 8851946, 8851775, 8851739, 8851628, 8851602, 8851391, 8851177, 8851062, 8850793, 8850543, 8850328, 8850321, 8850012, 8849764, 8849500, 8849237, 8849020, 8848942, 8848439, 8848380, 8848267, 8848136, 8847913, 8847882, 8847831, 8847685, 8847649, 8847466, 8847443, 8847178, 8846886, 8846416, 8846150, 8845600, 8845470, 8845228, 8845089, 8844939, 8844884, 8844876, 8844836, 8844721, 8844491, 8844172, 8843200, 8843050, 8843033, 8842316, 8842314, 8842312, 8841992, 8841368, 8841361, 8841157, 8840945, 8840815, 8840613, 8840367, 8839547, 8839160, 8839113, 8838736, 8838734, 8838576, 8837040, 8836993, 8836990, 8836940, 8836823, 8836787, 8836786, 8836274, 8835911, 8835445, 8834894, 8834515, 8834053, 8833499, 8832150, 8831742, 8831435, 8831416, 8830428, 8830372, 8829892, 8828867, 8828765, 8828602, 8828081, 8827305, 8826858, 8826276, 8825605, 8825402, 8824938, 8824625, 8824449, 8824354, 8824241, 8824027, 8823632, 8823579, 8822763, 8822650, 8822612, 8822162, 8821389, 8821335, 8821334, 8821333, 8821160, 8820804, 8820802, 8820801, 8820230, 8818786, 8818655, 8817931, 8817574, 8816957, 8816679, 8816523, 8816474, 8816266, 8815361, 8814225, 8813923, 8813810, 8813231, 8813088, 8811425, 8811424, 8811380, 8810584, 8810433, 8810408, 8810308, 8809209, 8809057, 8809056, 8808971, 8808925, 8808383, 8808116, 8808102, 8808017, 8807872, 8807487, 8807302, 8807300, 8806976, 8806665, 8805957, 8805722, 8805584, 8805086, 8805074, 8805050, 8804763, 8804605, 8804331, 8804060, 8803596, 8803566, 8803388, 8803374, 8803315, 8803297, 8803251, 8802845, 8802526, 8802496, 8802487, 8802286, 8802131, 8802104, 8801787, 8801733, 8801524, 8801354, 8801348, 8801103, 8801068, 8800671, 8800657, 8800484, 8800430, 8800429, 8800401, 8800373, 8800259, 8800131, 8799951, 8799717, 8799655, 8799531, 8799512, 8799042, 8798527, 8798345, 8798283, 8797910, 8796887, 8796630, 8796548, 8796479, 8796251, 8796166, 8795234, 8795007, 8794966, 8794945, 8794135, 8794028, 8793723, 8793639, 8793251, 8792473, 8791977, 8791975, 8791224, 8790410, 8789811, 8789161, 8789160, 8787305, 8786283, 8785979, 8785846, 8785608, 8784622, 8784330, 8782967, 8781697, 8781259, 8779960, 8779958, 8779664, 8779497, 8779169, 8778834, 8778649, 8778268, 8778264, 8778200, 8777762, 8776752, 8776177, 8775697, 8774995, 8774401, 8774398, 8774238, 8774229, 8774183, 8774177, 8773932, 8773656, 8771866, 8771864, 8771706, 8771266, 8770751, 8770731, 8770442, 8769795, 8769646, 8769437, 8769279, 8768321, 8767679, 8767667, 8767174, 8766951, 8766853, 8766851, 8766698, 8766669, 8766599, 8766372, 8766347, 8766302, 8765649, 8765628, 8765355, 8765071, 8765055, 8764856, 8764842, 8764702, 8764654, 8764474, 8764305, 8764304, 8764138, 8764017, 8763907, 8763906, 8763577, 8763566, 8763552, 8763307, 8763064, 8762672, 8762629, 8762563, 8762512, 8761820, 8761805, 8761126, 8760990, 8760683, 8760682, 8760464, 8760463, 8759912, 8759881, 8759568, 8759042, 8758475, 8758154, 8757910, 8757832, 8757627, 8757459, 8756981, 8756376, 8755577, 8755409, 8754520, 8754075, 8753894, 8753331, 8753330, 8753205, 8753197, 8753171, 8752975, 8752423, 8752318, 8752108, 8751877, 8751761, 8751672, 8751619, 8751482, 8751425, 8751365, 8751123, 8750155, 8749210, 8748088, 8747322, 8746326, 8745661, 8745293, 8744556, 8743968, 8743760, 8742819, 8742426, 8742256, 8742245, 8742170, 8742052, 8742051, 8741537, 8739438, 8738838, 8738582, 8738174, 8737811, 8737803, 8737800, 8737215, 8737039, 8737016, 8736982, 8736774, 8736766, 8735940, 8735939, 8735938, 8735937, 8735878, 8735785, 8735673, 8735666, 8735334, 8735330, 8734927, 8734848, 8734846, 8734827, 8734633, 8734207, 8734162, 8734132, 8734118, 8734056, 8733932, 8733680, 8733575, 8733574, 8733557, 8733443, 8733349, 8733164, 8733150, 8733119, 8733102, 8733008, 8732888, 8732811, 8732763, 8732738, 8732341, 8732293, 8732067, 8732058, 8732055, 8732040, 8732028, 8731697, 8731691, 8731688, 8731372, 8731367, 8731249, 8731099, 8731094, 8731049, 8730936, 8730563, 8730522, 8730228, 8729631, 8729520, 8729293, 8728898, 8728645, 8728617, 8728482, 8728458, 8728448, 8728415, 8728230, 8728227, 8728186, 8727686, 8727676, 8727623, 8727597, 8727531, 8727520, 8727486, 8727193, 8727067, 8727066, 8726941, 8726718, 8726616, 8726485, 8726484, 8726483, 8726482, 8726481, 8726480, 8726437, 8726169, 8726150, 8725987, 8725883, 8725810, 8725785, 8725781, 8725658, 8725499, 8725497, 8725496, 8725494, 8725278, 8725269, 8725248, 8725100, 8725044, 8724993, 8724837, 8724804, 8724802, 8724759, 8724749, 8724567, 8724448, 8724047, 8724009, 8723989, 8723934, 8723908, 8723864, 8723456, 8722987, 8722875, 8722874, 8722851, 8722850, 8722522, 8722521, 8722519, 8722482, 8722269, 8721880, 8721878, 8721854, 8721802, 8721708, 8721576, 8721554, 8721385, 8721379, 8721354, 8720917, 8720903, 8720698, 8719737, 8719709, 8719668, 8719050, 8718693, 8718684, 8718525, 8718521, 8718519, 8718486, 8718188, 8717840, 8717651, 8717586, 8717561, 8717344, 8717335, 8717300, 8716880, 8716855, 8716379, 8716242, 8715462, 8715461, 8715458, 8715457, 8715455, 8715363, 8715285, 8715076, 8714521, 8714269, 8714203, 8714051, 8712983, 8712975, 8712967, 8712966, 8712963, 8712961, 8712951, 8712918, 8712917, 8712863, 8712209, 8712208, 8711335, 8710836, 8710714, 8710502, 8708740, 8708560, 8708559, 8708558, 8708362, 8706049, 8705980, 8705237, 8704053, 8702685, 8702441, 8701866, 8700256, 8697934, 8697760, 8697289, 8696679, 8696145, 8694871, 8693847, 8693188, 8692210, 8692137, 8690684, 8690681, 8690641, 8690631, 8689445, 8688918, 8688335, 8687695, 8686617, 8683871, 8683606, 8682802, 8682796, 8682713, 8682557, 8679242, 8675809, 8675764, 8675745, 8674426, 8672268, 8672266, 8671210, 8670957, 8670264, 8669698, 8668779, 8667319, 8666771, 8666486, 8665424, 8662649, 8662080, 8659443, 8657833, 8657213, 8656069, 8654252, 8653530, 8653079, 8652321, 8650617, 8650404, 8650401, 8650158, 8650147, 8647502, 8647415, 8645940, 8645555, 8643224, 8643174, 8642645, 8640522, 8640451, 8640421, 8639766, 8639719, 8637933, 8636261, 8634994, 8634941, 8633378, 8632778, 8632182, 8631415, 8631079, 8630494, 8630111, 8629700, 8629699, 8629698, 8627793, 8627342, 8624692, 8624457, 8623829, 8623362, 8622185, 8622089, 8622088, 8620629, 8620443, 8618961, 8617805, 8615077, 8614053, 8612768, 8612767, 8611674, 8609123, 8608804, 8606777, 8605145, 8605143, 8605142, 8604660, 8601608, 8601030, 8601023, 8598146, 8597619, 8597076, 8596051, 8595616, 8595266, 8594905, 8594643, 8593878, 8593537, 8592723, 8592316, 8591051, 8590701, 8590647, 8589236, 8588901, 8586810, 8585926, 8585844, 8584754, 8584753, 8583673, 8583509, 8583483, 8583481, 8582990, 8582614, 8582163, 8581334, 8578465, 8578362, 8577767, 8577652, 8576086, 8575834, 8575707, 8575665, 8575526, 8575122, 8575064, 8574509, 8574508, 8574507, 8574308, 8573410, 8572093, 8572025, 8571340, 8571305, 8570107, 8569400, 8568769, 8567323, 8567064, 8565596, 8564429, 8564311, 8564241, 8563127, 8563119, 8562967, 8560716, 8560250, 8560184, 8559911, 8559733, 8559024, 8558905, 8558903, 8557520, 8553998, 8551535, 8551534, 8551023, 8550922, 8550177, 8549148, 8548514, 8548357, 8547796, 8546608, 8546301, 8546005, 8545967, 8543794, 8543793, 8543782, 8543781, 8543166, 8543052, 8542723, 8542108, 8542045, 8541763, 8538079, 8537610, 8537609, 8537584, 8536602, 8535107, 8534824, 8534816, 8534716, 8533397, 8531957, 8531582, 8530291, 8528755, 8528139, 8526893, 8526892, 8526703, 8526303, 8526243, 8511770, 8509068, 8508397, 8506553, 8506194, 8502093, 8502089, 8502079, 8502078, 8498791, 8488862, 8478786, 8478695, 8470484, 8449455, 8446352, 8445095, 8426581, 8419560, 8418397, 8410722, 8405317, 8401501, 8386333, 8386332, 8284397, 8224967, 8217798, 8217028, 8212301, 7283610)
Run Time: 0.038134
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1432 | |
PRIMARY | thread | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
PRIMARY | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
PRIMARY | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
PRIMARY | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 1432 | |
DERIVED | | | | | | | | No tables used |
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",126],["thread",9601350],["thread",9577070],["thread",9459065],["thread",9359374],["thread",9354224],["thread",9334464],["thread",9334133],["thread",9329161],["thread",9325023],["thread",9314573],["thread",9291717],["thread",9271296],["thread",9255006],["thread",9241010],["thread",9237119],["thread",9230851],["thread",9221618],["thread",9218466],["thread",9217292],["thread",9188445],["thread",9187030],["thread",9182201],["thread",9162369],["thread",9156745],["thread",9143455],["thread",9138134],["thread",9137284],["thread",9131055],["thread",9104518],["thread",9103319],["thread",9102146],["thread",9101368],["thread",9099563],["thread",9097686],["thread",9097099],["thread",9087377],["thread",9083856],["thread",9073174],["thread",9056964],["thread",9048352],["thread",9045981],["thread",9043106],["thread",9038519],["thread",9032545],["thread",9031031],["thread",9020118],["thread",9015311],["thread",9010770],["thread",9010098],["thread",9009039],["thread",8967297],["thread",8967220],["thread",8962411],["thread",8961231],["thread",8952398],["thread",8950795],["thread",8949791],["thread",8949403],["thread",8945439],["thread",8945217],["thread",8931166],["thread",8930042],["thread",8929591],["thread",8927955],["thread",8927953],["thread",8927532],["thread",8926896],["thread",8912873],["thread",8901054],["thread",8898015],["thread",8891907],["thread",8890945],["thread",8890392],["thread",8884458],["thread",8869316],["thread",8865403],["thread",8864449],["thread",8864037],["thread",8853074],["thread",8849500],["thread",8842316],["thread",8836993],["thread",8836787],["thread",8828602],["thread",8822763],["thread",8821335],["thread",8821160],["thread",8816523],["thread",8810433],["thread",8807302],["thread",8805074],["thread",8803388],["thread",8800430],["thread",8799042],["thread",8796548],["thread",8794135],["thread",8791977],["thread",8789161],["thread",8778649],["thread",8778268],["thread",8771266],["thread",8766347],["thread",8762563],["thread",8752975],["thread",8751123],["thread",8742819],["thread",8733164],["thread",8733150],["thread",8728898],["thread",8727676],["thread",8727193],["thread",8727067],["thread",8726485],["thread",8725658],["thread",8725278],["thread",8724993],["thread",8724804],["thread",8722850],["thread",8715363],["thread",8710714],["thread",8706049],["thread",8705980],["thread",8702441],["thread",8697760],["thread",8697289],["thread",8696145],["thread",8693188],["thread",8692210],["thread",8690684],["thread",8690681],["thread",8689445],["thread",8688335],["thread",8687695],["thread",8682802],["thread",8682713],["thread",8682557],["thread",8675809],["thread",8672268],["thread",8669698],["thread",8668779],["thread",8666486],["thread",8659443],["thread",8656069],["thread",8653079],["thread",8650404],["thread",8650158],["thread",8650147],["thread",8642645],["thread",8639766],["thread",8639719],["thread",8636261],["thread",8634994],["thread",8632182],["thread",8631079],["thread",8630111],["thread",8629700],["thread",8627342],["thread",8624457],["thread",8623362],["thread",8618961],["thread",8606777],["thread",8605145],["thread",8597619],["thread",8595266],["thread",8594643],["thread",8593878],["thread",8592316],["thread",8591051],["thread",8590647],["thread",8588901],["thread",8586810],["thread",8585926],["thread",8583673],["thread",8582990],["thread",8582614],["thread",8582163],["thread",8581334],["thread",8578465],["thread",8578362],["thread",8577652],["thread",8575707],["thread",8575665],["thread",8574509],["thread",8574308],["thread",8573410],["thread",8572093],["thread",8569400],["thread",8568769],["thread",8567323],["thread",8565596],["thread",8564429],["thread",8563119],["thread",8560250],["thread",8559911],["thread",8559733],["thread",8559024],["thread",8551535],["thread",8549148],["thread",8548357],["thread",8546608],["thread",8546301],["thread",8546005],["thread",8543794],["thread",8543052],["thread",8542723],["thread",8538079],["thread",8537610],["thread",8537584],["thread",8534816],["thread",8533397],["thread",8531957],["thread",8528139],["thread",8526893],["thread",8526703],["thread",8509068],["thread",8508397],["thread",8506194],["thread",8498791],["thread",8478786],["thread",8478695],["thread",8449455],["thread",8445095],["thread",8426581],["thread",8419560],["thread",8418397],["thread",8410722],["thread",8405317],["thread",8401501],["thread",7283610]], 230, tinhte_xentag_tag, , {"tags":["iphone 6s 64gb"]}, date, 0, , [], 0, 1657128469, 7872935180f5f9ccb5a82e51db80c51a
Run Time: 0.000550