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 (9676009, 9676007, 9676006, 9675299, 9675019, 9674859, 9674680, 9674442, 9673950, 9672822, 9672020, 9670688, 9669196, 9668525, 9668302, 9668301, 9668201, 9667091, 9666501, 9666496, 9663662, 9663413, 9656796, 9656749, 9653529, 9651351, 9651349, 9651348, 9651347, 9651346, 9651292, 9646449, 9645122, 9643722, 9643721, 9643720, 9641300, 9641179, 9641012, 9638975, 9635523, 9630668, 9615735, 9614857, 9613725, 9607355, 9606717, 9601952, 9599805, 9599804, 9595382, 9594061, 9593180, 9589448, 9583567, 9583509, 9582402, 9581662, 9577516, 9575491, 9573072, 9568784, 9567909, 9563198, 9562266, 9561820, 9561509, 9559059, 9558066, 9555604, 9554417, 9554065, 9553483, 9552650, 9552006, 9551936, 9551490, 9549888, 9548726, 9548375, 9543882, 9543040, 9538124, 9536216, 9533427, 9525609, 9514718, 9514664, 9513382, 9513373, 9513372, 9513348, 9507012, 9506906, 9505315, 9503713, 9503525, 9503516, 9498877, 9495442, 9484063, 9482176, 9471932, 9453959, 9449281, 9447953, 9447136, 9446499, 9443987, 9437270, 9435987, 9434332, 9434033, 9429874, 9423224, 9423012, 9422625, 9420590, 9417204, 9415408, 9415085, 9408325, 9404911, 9403730, 9403341, 9400763, 9396162, 9392838, 9387741, 9374534, 9374533, 9371227, 9371226, 9371225, 9368042, 9368033, 9358572, 9358532, 9357908, 9353926, 9350721, 9350663, 9350423, 9341364, 9337828, 9337823, 9337822, 9337634, 9337633, 9333973, 9329923, 9322567, 9317971, 9315132, 9310994, 9308658, 9308578, 9308049, 9301292, 9301290, 9301289, 9292925, 9289385, 9280590, 9278804, 9275398, 9275397, 9254966, 9254956, 9254909, 9246343, 9246332, 9246306, 9236257, 9235955, 9223769, 9223743, 9218034, 9209222, 9198485, 9189876, 9189685, 9181745, 9175258, 9173836, 9173825, 9173609, 9173595, 9173584, 9173579, 9173339, 9172888, 9172777, 9158926, 9155225, 9151671, 9146525, 9145233, 9145232, 9143363, 9141003, 9133642, 9133036, 9132912, 9132903, 9132845, 9132230, 9132176, 9131824, 9131543, 9131421, 9131393, 9121290, 9116598, 9113310, 9113305, 9111318, 9108932, 9107080, 9106075, 9105413, 9102576, 9098519, 9098493, 9097405, 9092020, 9089399, 9088688, 9077839, 9076116, 9072519, 9068238, 9064266, 9056509, 9056501, 9056488, 9056482, 9056472, 9056467, 9055074, 9053646, 9051426, 9051009, 9043916, 9043914, 9043607, 9042189, 9041070, 9041063, 9040701, 9035953, 9035318, 9017661, 9015735, 9011178, 9010281, 9010072, 9010071, 9009884, 9009587, 9004038, 9002845, 8998548, 8991807, 8991805, 8989014, 8985139, 8985138, 8983525, 8983524, 8980570, 8970145, 8970115, 8969287, 8969136, 8959363, 8956204, 8956189, 8955046, 8950283, 8945042, 8942950, 8942091, 8941388, 8938472, 8937625, 8937616, 8937225, 8936449, 8932248, 8927839, 8922325, 8920429, 8914227, 8913155, 8911567, 8911162, 8909586, 8904779, 8902740, 8898154, 8897898, 8897263, 8897262, 8885715, 8885690, 8884993, 8884992, 8876520, 8865119, 8862029, 8862027, 8862026, 8862024, 8862022, 8858980, 8858214, 8857269, 8856734, 8856732, 8829663, 8819491, 8804411, 8803628, 8785662, 8777089, 8771691, 8747333, 8736542, 8730931, 8729184, 8724776, 8721867, 8721452, 8721003, 8709204, 8707337, 8704962, 8704260, 8703813, 8696062, 8696060, 8695659, 8693335, 8689551, 8688820, 8684923, 8683666, 8679832, 8677570, 8674952, 8673957, 8673051, 8664195, 8661850, 8661291, 8654560, 8654468, 8653217, 8648088, 8647841, 8646379, 8633797, 8633390, 8629186, 8628283, 8621672, 8619390, 8615529, 8615266, 8614872, 8607686, 8603837, 8595954, 8591181, 8584453, 8582013, 8580359, 8580357, 8579044, 8578345, 8564102, 8561236, 8559554, 8559553, 8557513, 8556080, 8555879, 8551526, 8547160, 8540836, 8538215, 8536617, 8536616, 8536614, 8533770, 8528100, 8526791, 8525611, 8524622, 8522752, 8522116, 8519010, 8512364, 8512319, 8511239, 8511183, 8510843, 8510182, 8509758, 8509186, 8508640, 8508052, 8506651, 8506185, 8505835, 8504450, 8502876, 8496571, 8496205, 8493446, 8491656, 8491197, 8488407, 8484446, 8483399, 8482291, 8480205, 8480089, 8479806, 8478671, 8478269, 8477929, 8475511, 8474141, 8473153, 8470969, 8468113, 8462298, 8462285, 8459944, 8459679, 8459634, 8458170, 8458049, 8457948, 8457862, 8456123, 8452250, 8449855, 8449698, 8449276, 8448957, 8448940, 8442262, 8440672, 8440021, 8437958, 8437352, 8437075, 8435771, 8433781, 8433540, 8433524, 8433412, 8431282, 8431280, 8430603, 8430329, 8430021, 8429781, 8423590, 8421893, 8419486, 8419485, 8417711, 8417499, 8412181, 8406909, 8404404, 8404282, 8401849, 8401256, 8397458, 8397245, 8396792, 8395724, 8395208, 8394665, 8391240, 8388479, 8387959, 8386282, 8383439, 8380302, 8379869, 8378358, 8377757, 8374276, 8371637, 8369023, 8369020, 8368210, 8363766, 8363689, 8354386, 8354221, 8352465, 8350038, 8349290, 8345282, 8343500, 8339195, 8337043, 8336829, 8335816, 8335667, 8333613, 8332825, 8332648, 8329902, 8324793, 8323185, 8322786, 8321093, 8319997, 8315066, 8313460, 8313259, 8312969, 8310788, 8309386, 8307373, 8304920, 8303751, 8300974, 8300701, 8297996, 8297250, 8291278, 8290229, 8288168, 8288167, 8287850, 8285716, 8282533, 8281312, 8279720, 8279023, 8276163, 8276133, 8275573, 8274831, 8274786, 8274759, 8274350, 8274279, 8274021, 8274008, 8272833, 8272831, 8272830, 8272824, 8269792, 8267880, 8267708, 8267049, 8267048, 8267047, 8266111, 8265642, 8265641, 8263907, 8263509, 8263255, 8261292, 8261268, 8260572, 8260346, 8258844, 8256377, 8255987, 8255513, 8254219, 8252769, 8252381, 8252307, 8251327, 8250652, 8249890, 8249881, 8249822, 8249819, 8249660, 8249635, 8249481, 8248512, 8247288, 8246833, 8244145, 8241486, 8241317, 8238790, 8238271, 8235306, 8232554, 8231682, 8231430, 8230835, 8229025, 8228811, 8228598, 8226940, 8225914, 8225913, 8225792, 8225241, 8223017, 8222754, 8222270, 8222265, 8221916, 8221423, 8220600, 8219890, 8218678, 8217331, 8217268, 8216608, 8215857, 8214725, 8213118, 8211710, 8211550, 8210680, 8210334, 8209283, 8208999, 8207626, 8206433, 8204895, 8204507, 8201188, 8200650, 8199155, 8197461, 8196586, 8195939, 8195472, 8194559, 8190385, 8189696, 8187785, 8185591, 8184735, 8182742, 8182735, 8181627, 8180702, 8176273, 8174553, 8173933, 8172569, 8171505, 8170025, 8169257, 8168358, 8168226, 8167990, 8167489, 8165947, 8165802, 8165140, 8164046, 8163779, 8163448, 8163447, 8162646, 8162316, 8162077, 8161160, 8160842, 8160356, 8160172, 8157191, 8156837, 8156836, 8155876, 8155875, 8155874, 8155872, 8152567, 8150025, 8149731, 8144994, 8142929, 8140306, 8133043, 8131304, 8130303, 8127983, 8127323, 8124288, 8116538, 8115025, 8112756, 8110927, 8107103, 8101626, 8101532, 8095890, 8094907, 8090888, 8089738, 8088807, 8087807, 8087291, 8084445, 8083048, 8080787, 8077014, 8067106, 8065362, 8064341, 8060734, 8059687, 8057431, 8055766, 8054910, 8044186, 8001991, 8000646, 7988130, 7983506, 7979456, 7976887, 7976304, 7960156, 7959803, 7954364, 7939198, 7909840, 7907822, 7890717, 7860864, 7858826, 7851635, 7833304, 7830552, 7819437, 7737586, 7733955, 7733574, 7729143, 7704036, 7683581, 7676607, 7668993, 7666297, 7656230, 7653897, 7646797, 7646366, 7639408, 7612949, 7607222, 7601673, 7598212, 7595378, 7594733, 7588451, 7586104, 7584947, 7584098, 7581049, 7580139, 7579585, 7572573, 7572250, 7563796, 7558986, 7557384, 7557323, 7556647, 7549725, 5693390, 5597114, 5521956, 5426934, 5070968, 4897704, 4883907, 3266762)
Run Time: 0.021230
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 793 | 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",145],["thread",9676009],["thread",9676007],["thread",9676006],["thread",9675299],["thread",9675019],["thread",9674859],["thread",9674680],["thread",9674442],["thread",9673950],["thread",9672822],["thread",9672020],["thread",9669196],["thread",9668525],["thread",9668302],["thread",9667091],["thread",9666501],["thread",9666496],["thread",9656796],["thread",9651292],["thread",9641300],["thread",9641179],["thread",9641012],["thread",9638975],["thread",9635523],["thread",9630668],["thread",9615735],["thread",9614857],["thread",9613725],["thread",9607355],["thread",9606717],["thread",9583509],["thread",9582402],["thread",9568784],["thread",9567909],["thread",9563198],["thread",9562266],["thread",9561820],["thread",9559059],["thread",9558066],["thread",9555604],["thread",9553483],["thread",9552006],["thread",9551936],["thread",9549888],["thread",9548375],["thread",9543882],["thread",9543040],["thread",9538124],["thread",9513373],["thread",9513372],["thread",9513348],["thread",9447953],["thread",9434033],["thread",9429874],["thread",9423224],["thread",9423012],["thread",9420590],["thread",9368042],["thread",9368033],["thread",9357908],["thread",9350663],["thread",9329923],["thread",9322567],["thread",9315132],["thread",9308658],["thread",9301292],["thread",9289385],["thread",9280590],["thread",9254966],["thread",9254956],["thread",9246343],["thread",9246332],["thread",9223769],["thread",9223743],["thread",9218034],["thread",9209222],["thread",9189685],["thread",9175258],["thread",9173836],["thread",9173825],["thread",9173609],["thread",9173584],["thread",9173579],["thread",9172888],["thread",9172777],["thread",9158926],["thread",9146525],["thread",9145233],["thread",9143363],["thread",9141003],["thread",9133642],["thread",9133036],["thread",9132912],["thread",9132903],["thread",9132845],["thread",9132230],["thread",9132176],["thread",9131543],["thread",9131421],["thread",9108932],["thread",9107080],["thread",9106075],["thread",9105413],["thread",9102576],["thread",9098519],["thread",9098493],["thread",9097405],["thread",9088688],["thread",9077839],["thread",9064266],["thread",9056509],["thread",9056501],["thread",9056488],["thread",9056482],["thread",9056472],["thread",9056467],["thread",9055074],["thread",9053646],["thread",9051426],["thread",9051009],["thread",9043607],["thread",9041070],["thread",9041063],["thread",9040701],["thread",9035953],["thread",9035318],["thread",9015735],["thread",9010281],["thread",9010072],["thread",9004038],["thread",9002845],["thread",8998548],["thread",8991807],["thread",8989014],["thread",8983525],["thread",8970145],["thread",8956204],["thread",8956189],["thread",8950283],["thread",8942950],["thread",8941388],["thread",8938472],["thread",8937625],["thread",8937616],["thread",8937225],["thread",8932248],["thread",8927839],["thread",8920429],["thread",8913155],["thread",8911567],["thread",8911162],["thread",8909586],["thread",8902740],["thread",8898154],["thread",8897898],["thread",8897263],["thread",8876520],["thread",8862029],["thread",8857269],["thread",8856734],["thread",8819491],["thread",8804411],["thread",8777089],["thread",8747333],["thread",8704962],["thread",8703813],["thread",8693335],["thread",8689551],["thread",8661850],["thread",8654560],["thread",8648088],["thread",8647841],["thread",8633390],["thread",8621672],["thread",8619390],["thread",8615529],["thread",8615266],["thread",8614872],["thread",8607686],["thread",8603837],["thread",8595954],["thread",8584453],["thread",8582013],["thread",8580359],["thread",8580357],["thread",8579044],["thread",8561236],["thread",8559554],["thread",8555879],["thread",8551526],["thread",8547160],["thread",8540836],["thread",8533770],["thread",8525611],["thread",8524622],["thread",8522752],["thread",8522116],["thread",8519010],["thread",8512364],["thread",8512319],["thread",8511183],["thread",8510843],["thread",8510182],["thread",8509758],["thread",8509186],["thread",8508640],["thread",8508052],["thread",8506651],["thread",8506185],["thread",8505835],["thread",8496205],["thread",8491197],["thread",8488407],["thread",8484446],["thread",8482291],["thread",8480205],["thread",8479806],["thread",8478269],["thread",8477929],["thread",8475511],["thread",8473153],["thread",8468113],["thread",8459944],["thread",8459679],["thread",8459634],["thread",8458170],["thread",8458049],["thread",8457948],["thread",8456123],["thread",8452250],["thread",8449855],["thread",8442262],["thread",8440021],["thread",8437352],["thread",8433781],["thread",8433540],["thread",8433524],["thread",8433412],["thread",8430603],["thread",8430329],["thread",8423590],["thread",8421893],["thread",8419486],["thread",8417499],["thread",8412181],["thread",8406909],["thread",8404404],["thread",8401849],["thread",8401256],["thread",8397458],["thread",8397245],["thread",8396792],["thread",8395724],["thread",8394665],["thread",8388479],["thread",8387959],["thread",8386282],["thread",8380302],["thread",8379869],["thread",8378358],["thread",8377757],["thread",8371637],["thread",8369020],["thread",8354386],["thread",8354221],["thread",8352465],["thread",8350038],["thread",8349290],["thread",8345282],["thread",8343500],["thread",8339195],["thread",8337043],["thread",8336829],["thread",8335816],["thread",8332825],["thread",8332648],["thread",8322786],["thread",8321093],["thread",8319997],["thread",8315066],["thread",8313259],["thread",8312969],["thread",8310788],["thread",8309386],["thread",8307373],["thread",8304920],["thread",8303751],["thread",8300974],["thread",8300701],["thread",8297996],["thread",8291278],["thread",8290229],["thread",8288168],["thread",8287850],["thread",8282533],["thread",8281312],["thread",8279720],["thread",8276163],["thread",8276133],["thread",8275573],["thread",8274831],["thread",8274786],["thread",8274759],["thread",8274350],["thread",8274279],["thread",8274021],["thread",8274008],["thread",8272833],["thread",8269792],["thread",8267708],["thread",8266111],["thread",8265642],["thread",8263907],["thread",8263509],["thread",8263255],["thread",8261292],["thread",8261268],["thread",8258844],["thread",8256377],["thread",8255513],["thread",8254219],["thread",8252769],["thread",8252381],["thread",8252307],["thread",8251327],["thread",8250652],["thread",8249890],["thread",8249881],["thread",8249660],["thread",8249635],["thread",8249481],["thread",8248512],["thread",8247288],["thread",8244145],["thread",8241486],["thread",8238790],["thread",8238271],["thread",8235306],["thread",8232554],["thread",8231430],["thread",8229025],["thread",8228811],["thread",8228598],["thread",8225914],["thread",8225792],["thread",8225241],["thread",8222754],["thread",8222270],["thread",8221916],["thread",8221423],["thread",8220600],["thread",8218678],["thread",8217331],["thread",8217268],["thread",8216608],["thread",8215857],["thread",8214725],["thread",8213118],["thread",8211710],["thread",8211550],["thread",8210680],["thread",8210334],["thread",8209283],["thread",8208999],["thread",8207626],["thread",8206433],["thread",8204895],["thread",8204507],["thread",8201188],["thread",8200650],["thread",8199155],["thread",8197461],["thread",8196586],["thread",8195939],["thread",8194559],["thread",8190385],["thread",8189696],["thread",8187785],["thread",8185591],["thread",8184735],["thread",8182742],["thread",8182735],["thread",8181627],["thread",8176273],["thread",8174553],["thread",8173933],["thread",8172569],["thread",8171505],["thread",8170025],["thread",8169257],["thread",8168358],["thread",8168226],["thread",8167990],["thread",8165947],["thread",8165802],["thread",8165140],["thread",8164046],["thread",8163779],["thread",8163448],["thread",8162646],["thread",8162316],["thread",8161160],["thread",8160842],["thread",8160356],["thread",8160172],["thread",8157191],["thread",8155876],["thread",8152567],["thread",8150025],["thread",8149731],["thread",8144994],["thread",8142929],["thread",8133043],["thread",8131304],["thread",8130303],["thread",8127983],["thread",8127323],["thread",8124288],["thread",8116538],["thread",8115025],["thread",8112756],["thread",8110927],["thread",8107103],["thread",8101626],["thread",8101532],["thread",8095890],["thread",8094907],["thread",8090888],["thread",8089738],["thread",8088807],["thread",8087807],["thread",8087291],["thread",8084445],["thread",8083048],["thread",8080787],["thread",8077014],["thread",8065362],["thread",8064341],["thread",8060734],["thread",8059687],["thread",8057431],["thread",8044186],["thread",8001991],["thread",8000646],["thread",7988130],["thread",7983506],["thread",7979456],["thread",7976887],["thread",7976304],["thread",7960156],["thread",7959803],["thread",7954364],["thread",7939198],["thread",7909840],["thread",7907822],["thread",7890717],["thread",7860864],["thread",7851635],["thread",7833304],["thread",7830552],["thread",7819437],["thread",7737586],["thread",7733955],["thread",7733574],["thread",7729143],["thread",7704036],["thread",7683581],["thread",7676607],["thread",7668993],["thread",7666297],["thread",7653897],["thread",7646797],["thread",7646366],["thread",7639408],["thread",7612949],["thread",7607222],["thread",7601673],["thread",7598212],["thread",7595378],["thread",7594733],["thread",7588451],["thread",7586104],["thread",7584947],["thread",7584098],["thread",7581049],["thread",7580139],["thread",7579585],["thread",7572573],["thread",7572250],["thread",7563796],["thread",7558986],["thread",7557384],["thread",7557323],["thread",7556647],["thread",7549725],["thread",5597114],["thread",5426934],["thread",5070968],["thread",4897704],["thread",4883907]], 501, tinhte_xentag_tag, , {"tags":["ph\u1ee5 ki\u1ec7n m\u00e1y t\u00ednh b\u1ea3ng"]}, date, 0, , [], 0, 1652834912, 4a2c92693eec12c29021f98bd7511f43
Run Time: 0.000757