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 (9667091, 9622616, 9620380, 9581163, 9568784, 9563869, 9561820, 9551936, 9548923, 9543882, 9507012, 9506906, 9505315, 9501604, 9425714, 9405453, 9371227, 9371226, 9371225, 9350721, 9345870, 9324172, 9289385, 9275398, 9275397, 9249794, 9236257, 9201840, 9200083, 9176565, 9173339, 9155225, 9142280, 9117393, 9117387, 9117386, 9115485, 9108766, 9104770, 9099165, 9088688, 9064163, 9052949, 9028063, 9010072, 9010071, 9009885, 9009884, 8991805, 8963659, 8959751, 8952219, 8942552, 8899022, 8897899, 8897697, 8887852, 8839499, 8839498, 8825456, 8824502, 8796090, 8791597, 8783214, 8781767, 8773421, 8771692, 8771691, 8756983, 8735525, 8735522, 8722980, 8722395, 8720189, 8719975, 8713239, 8703813, 8700879, 8696062, 8696060, 8685690, 8680216, 8679838, 8675387, 8655991, 8653217, 8652047, 8649289, 8648406, 8625616, 8622353, 8604256, 8595954, 8578712, 8564768, 8559554, 8559553, 8558897, 8555879, 8538671, 8536617, 8536616, 8536614, 8534584, 8531246, 8528914, 8528100, 8526791, 8522673, 8511239, 8509186, 8508640, 8506651, 8506078, 8502876, 8500521, 8494691, 8491442, 8481962, 8462298, 8462285, 8457862, 8456912, 8452848, 8449698, 8441170, 8440672, 8437367, 8437352, 8437075, 8435771, 8433524, 8432770, 8429781, 8419486, 8419485, 8417711, 8412181, 8401849, 8400956, 8398061, 8396792, 8395208, 8382334, 8374276, 8373091, 8360933, 8354386, 8349290, 8343500, 8334985, 8333613, 8328287, 8324793, 8323448, 8322786, 8318235, 8315907, 8312969, 8310788, 8310752, 8309740, 8308647, 8303358, 8300701, 8297250, 8293904, 8292736, 8291529, 8291278, 8288590, 8288168, 8288167, 8280147, 8279437, 8276133, 8275573, 8274831, 8274279, 8274021, 8274008, 8272833, 8272832, 8269873, 8267880, 8267738, 8266800, 8263907, 8263509, 8263255, 8261292, 8261268, 8258844, 8255513, 8250990, 8250652, 8249890, 8249881, 8248512, 8247288, 8244931, 8241317, 8238790, 8231430, 8231227, 8230835, 8230500, 8229591, 8228598, 8225151, 8223017, 8222754, 8221916, 8219715, 8218678, 8217331, 8215857, 8214725, 8213118, 8212170, 8211710, 8211567, 8206433, 8204895, 8204507, 8201929, 8201188, 8199024, 8197461, 8194172, 8193523, 8192609, 8182742, 8182735, 8181118, 8178077, 8177645, 8176273, 8175579, 8173933, 8172569, 8171505, 8170025, 8166665, 8165802, 8165140, 8162646, 8161160, 8160172, 8156836, 8155866, 8153840, 8151903, 8143684, 8134752, 8132769, 8130072, 8126949, 8123680, 8116408, 8114636, 8113944, 8110927, 8097679, 8091398, 8089738, 8088358, 8084619, 8082273, 8078147, 8078120, 8063495, 8058420, 8058106, 8057060, 8051545, 8038800, 8030970, 8027880, 8007023, 8002633, 7992407, 7990804, 7966114, 7924562, 7915840, 7856312, 7851617, 7845903, 7835906, 7832356, 7776116, 7772029, 7738444, 7732947, 7713013, 7708553, 7696077, 7679937, 7661114, 7661014, 7660904, 7659938, 7653220, 7646432, 7636143, 7631165, 7624910, 7623057, 7612974, 7598098, 7596681, 7590262, 7585099, 7585069, 7584589, 7582537, 7582395, 7579640, 7579138, 7577552, 7569980, 7566409, 7562082, 7556183, 7553786, 7552815, 7550902)
Run Time: 0.008953
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 328 | 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",9667091],["thread",9622616],["thread",9620380],["thread",9581163],["thread",9568784],["thread",9563869],["thread",9561820],["thread",9551936],["thread",9548923],["thread",9543882],["thread",9501604],["thread",9289385],["thread",9249794],["thread",9200083],["thread",9117393],["thread",9117387],["thread",9115485],["thread",9099165],["thread",9088688],["thread",9010072],["thread",8824502],["thread",8796090],["thread",8791597],["thread",8720189],["thread",8703813],["thread",8685690],["thread",8675387],["thread",8655991],["thread",8649289],["thread",8648406],["thread",8622353],["thread",8595954],["thread",8559554],["thread",8555879],["thread",8538671],["thread",8528914],["thread",8522673],["thread",8509186],["thread",8508640],["thread",8506651],["thread",8506078],["thread",8500521],["thread",8456912],["thread",8452848],["thread",8437367],["thread",8437352],["thread",8433524],["thread",8432770],["thread",8419486],["thread",8412181],["thread",8401849],["thread",8400956],["thread",8398061],["thread",8396792],["thread",8382334],["thread",8373091],["thread",8360933],["thread",8354386],["thread",8349290],["thread",8343500],["thread",8334985],["thread",8328287],["thread",8323448],["thread",8322786],["thread",8318235],["thread",8315907],["thread",8312969],["thread",8310788],["thread",8310752],["thread",8309740],["thread",8308647],["thread",8303358],["thread",8300701],["thread",8293904],["thread",8292736],["thread",8291529],["thread",8291278],["thread",8288590],["thread",8288168],["thread",8279437],["thread",8276133],["thread",8275573],["thread",8274831],["thread",8274279],["thread",8274021],["thread",8274008],["thread",8272833],["thread",8269873],["thread",8267738],["thread",8266800],["thread",8263907],["thread",8263509],["thread",8263255],["thread",8261292],["thread",8261268],["thread",8258844],["thread",8255513],["thread",8250990],["thread",8250652],["thread",8249890],["thread",8249881],["thread",8248512],["thread",8247288],["thread",8244931],["thread",8238790],["thread",8231430],["thread",8231227],["thread",8230500],["thread",8229591],["thread",8228598],["thread",8225151],["thread",8222754],["thread",8221916],["thread",8219715],["thread",8218678],["thread",8217331],["thread",8215857],["thread",8214725],["thread",8213118],["thread",8212170],["thread",8211710],["thread",8206433],["thread",8204895],["thread",8204507],["thread",8201929],["thread",8201188],["thread",8199024],["thread",8197461],["thread",8193523],["thread",8192609],["thread",8182742],["thread",8182735],["thread",8181118],["thread",8178077],["thread",8177645],["thread",8176273],["thread",8175579],["thread",8173933],["thread",8172569],["thread",8171505],["thread",8170025],["thread",8166665],["thread",8165802],["thread",8165140],["thread",8162646],["thread",8161160],["thread",8160172],["thread",8155866],["thread",8153840],["thread",8151903],["thread",8143684],["thread",8134752],["thread",8132769],["thread",8130072],["thread",8126949],["thread",8123680],["thread",8116408],["thread",8114636],["thread",8113944],["thread",8110927],["thread",8097679],["thread",8091398],["thread",8089738],["thread",8088358],["thread",8084619],["thread",8082273],["thread",8078147],["thread",8078120],["thread",8063495],["thread",8058420],["thread",8058106],["thread",8057060],["thread",8051545],["thread",8038800],["thread",8030970],["thread",8027880],["thread",8007023],["thread",8002633],["thread",7992407],["thread",7990804],["thread",7966114],["thread",7924562],["thread",7915840],["thread",7856312],["thread",7851617],["thread",7845903],["thread",7835906],["thread",7772029],["thread",7738444],["thread",7732947],["thread",7713013],["thread",7708553],["thread",7696077],["thread",7679937],["thread",7661114],["thread",7661014],["thread",7660904],["thread",7659938],["thread",7653220],["thread",7646432],["thread",7636143],["thread",7631165],["thread",7624910],["thread",7623057],["thread",7612974],["thread",7598098],["thread",7596681],["thread",7590262],["thread",7585099],["thread",7585069],["thread",7582537],["thread",7582395],["thread",7579640],["thread",7579138],["thread",7577552],["thread",7569980],["thread",7566409],["thread",7562082],["thread",7556183],["thread",7553786],["thread",7552815],["thread",7550902]], 223, tinhte_xentag_tag, , {"tags":["m\u00e1y t\u00ednh b\u1ea3ng acer"]}, date, 0, , [], 0, 1656373499, f427f4463ee06eb97f0dd59036f48077
Run Time: 0.000751