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 (9588019, 9585866, 9582038, 9582037, 9552167, 9546536, 9539885, 9534936, 9490858, 9485718, 9461263, 9436456, 9412674, 9409693, 9409691, 9409690, 9408570, 9405110, 9402648, 9400382, 9398468, 9397422, 9395292, 9354037, 9352110, 9351186, 9332414, 9323409, 9323376, 9300314, 9296979, 9295198, 9290965, 9286307, 9286306, 9268079, 9268078, 9266714, 9266712, 9264268, 9264084, 9262191, 9257041, 9257040, 9243587, 9241263, 9241260, 9233865, 9233180, 9228562, 9226803, 9219641, 9216558, 9216250, 9211711, 9198960, 9194509, 9181352, 9177119, 9175833, 9170296, 9169433, 9145971, 9141739, 9134858, 9134857, 9134699, 9134036, 9128277, 9124657, 9115554, 9111069, 9111067, 9109146, 9107902, 9100556, 9089164, 9077790, 9077789, 9075628, 9067451, 9060769, 9060768, 9060766, 9047458, 9043100, 9040889, 9039584, 9039583, 9039187, 9035350, 9031633, 9026140, 9016610, 9009704, 9008873, 9002181, 9001163, 9000601, 8983643, 8965206, 8961855, 8961853, 8961852, 8961851, 8961653, 8956382, 8956381, 8948487, 8948486, 8948476, 8944437, 8943102, 8941639, 8925009, 8922444, 8922298, 8918853, 8918121, 8916510, 8914447, 8910932, 8908639, 8904580, 8901702, 8901485, 8897341, 8895649, 8895645, 8894916, 8893073, 8892803, 8892428, 8892426, 8891544, 8885468, 8884022, 8881471, 8877167, 8876693, 8874360, 8874359, 8871335, 8869505, 8869503, 8864476, 8864106, 8863220, 8862702, 8862688, 8861561, 8859747, 8856019, 8856018, 8855738, 8855503, 8855147, 8854799, 8854183, 8854025, 8853440, 8853430, 8852331, 8852330, 8852261, 8852027, 8848466, 8848062, 8848039, 8848038, 8848036, 8848035, 8847946, 8845377, 8845004, 8843551, 8842106, 8842012, 8840860, 8840213, 8837285, 8836694, 8834527, 8832783, 8831293, 8831291, 8830922, 8829759, 8829528, 8828636, 8828625, 8826828, 8826283, 8826281, 8826212, 8823474, 8822360, 8819242, 8818386, 8813057, 8811291, 8811191, 8811188, 8810215, 8810214, 8808962, 8808960, 8808954, 8808953, 8808951, 8808950, 8808156, 8806965, 8806964, 8802008, 8801595, 8797987, 8796419, 8796418, 8790378, 8789533, 8788917, 8788895, 8788833, 8787819, 8787719, 8787718, 8784451, 8780311, 8779196, 8775189, 8775187, 8774392, 8772402, 8771245, 8771236, 8771235, 8768603, 8767006, 8766013, 8765391, 8764976, 8763917, 8762910, 8760091, 8758485, 8756827, 8755832, 8755316, 8754349, 8754034, 8753859, 8751280, 8747584, 8747069, 8745399, 8740929, 8740444, 8739600, 8739592, 8739590, 8739588, 8739586, 8739016, 8737940, 8736688, 8733077, 8733076, 8732986, 8732985, 8732686, 8732452, 8732427, 8731360, 8730580, 8729895, 8729577, 8727246, 8726408, 8725462, 8722299, 8722030, 8722026, 8721642, 8720232, 8720137, 8719398, 8718926, 8717679, 8716383, 8715471, 8714437, 8714433, 8714414, 8713970, 8713969, 8713968, 8713929, 8713529, 8713528, 8713437, 8712463, 8710800, 8709492, 8709491, 8709490, 8708456, 8708436, 8707648, 8706034, 8704370, 8703489, 8703484, 8703176, 8701724, 8701722, 8701721, 8701720, 8701473, 8701184, 8699688, 8698383, 8697769, 8696575, 8695988, 8694154, 8691220, 8691194, 8690260, 8690247, 8689848, 8688672, 8688179, 8686023, 8685619, 8685025, 8682981, 8680997, 8680807, 8680272, 8680231, 8678106, 8677383, 8677187, 8675767, 8675756, 8675015, 8674847, 8672957, 8670177, 8669797, 8668013, 8667334, 8667323, 8665463, 8665462, 8662617, 8662401, 8661830, 8661523, 8661333, 8660709, 8659464, 8658537, 8657666, 8656450, 8655603, 8654327, 8654302, 8653842, 8653807, 8651796, 8651562, 8651081, 8649158, 8643236, 8643201, 8642975, 8641546, 8638574, 8634925, 8634877, 8631854, 8631853, 8631820, 8631819, 8631178, 8626516, 8624108, 8624100, 8620645, 8617762, 8617631, 8614135, 8612695, 8612184, 8612182, 8612181, 8612087, 8609135, 8609134, 8609122, 8608394, 8607499, 8606716, 8606241, 8605922, 8605321, 8605007, 8602219, 8602218, 8602216, 8601027, 8601024, 8601006, 8600988, 8598656, 8594545, 8594543, 8594542, 8594541, 8592202, 8592018, 8590992, 8589741, 8589247, 8589242, 8589227, 8586620, 8585391, 8584106, 8583505, 8583181, 8579107, 8575880, 8574217, 8574204, 8572462, 8572416, 8571325, 8569538, 8567236, 8565702, 8565481, 8562270, 8562268, 8562265, 8561741, 8561062, 8557429, 8552311, 8552080, 8548920, 8544613, 8542590, 8542582, 8542571, 8541758, 8541756, 8537078, 8536600, 8536595, 8536588, 8534374, 8533903, 8533859, 8533858, 8531195, 8531194, 8531190, 8530418, 8529825, 8527038, 8526568, 8526310, 8526271, 8523781, 8523182, 8521971, 8521878, 8521391, 8517427, 8496457, 8484458, 8481783, 8465233, 8453621, 8438497, 8438120, 8432837, 8423964, 8423893, 8414573, 8409715, 8399609, 8377594, 8375736, 8370306, 8370300, 8365218, 8364795, 8363636, 8351122, 8345131, 8342423, 8342174, 8340137, 8338084, 8337279, 8335653, 8333852, 8323505, 8317592, 8317331, 8317071, 8316808, 8315952, 8311986, 8310174, 8306319, 8301869, 8300108, 8299812, 8297995, 8297261, 8285723, 8283192, 8281350, 8281172, 8279718, 8277727, 8269055, 8268729, 8267773, 8264756, 8262571, 8260116, 8258141, 8257460)
Run Time: 0.009507
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 539 | 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: [["thread",9588019],["thread",9582038],["thread",9485718],["thread",9352110],["thread",9290965],["thread",9257041],["thread",9241260],["thread",9233865],["thread",9216558],["thread",9198960],["thread",9170296],["thread",9115554],["thread",9067451],["thread",9026140],["thread",9016610],["thread",9002181],["thread",9000601],["thread",8983643],["thread",8965206],["thread",8943102],["thread",8918121],["thread",8914447],["thread",8910932],["thread",8904580],["thread",8901702],["thread",8891544],["thread",8885468],["thread",8884022],["thread",8881471],["thread",8876693],["thread",8871335],["thread",8869505],["thread",8854025],["thread",8852261],["thread",8843551],["thread",8840860],["thread",8836694],["thread",8823474],["thread",8818386],["thread",8802008],["thread",8796419],["thread",8790378],["thread",8788833],["thread",8784451],["thread",8779196],["thread",8774392],["thread",8764976],["thread",8762910],["thread",8760091],["thread",8755832],["thread",8755316],["thread",8753859],["thread",8751280],["thread",8740444],["thread",8737940],["thread",8732986],["thread",8732686],["thread",8732427],["thread",8730580],["thread",8729577],["thread",8720232],["thread",8712463],["thread",8704370],["thread",8703176],["thread",8697769],["thread",8696575],["thread",8691220],["thread",8689848],["thread",8685619],["thread",8682981],["thread",8678106],["thread",8677187],["thread",8675015],["thread",8665463],["thread",8662617],["thread",8662401],["thread",8661830],["thread",8661523],["thread",8658537],["thread",8656450],["thread",8654327],["thread",8651796],["thread",8651562],["thread",8612184],["thread",8612087],["thread",8608394],["thread",8606716],["thread",8605321],["thread",8600988],["thread",8586620],["thread",8569538],["thread",8562270],["thread",8561741],["thread",8557429],["thread",8552080],["thread",8544613],["thread",8537078],["thread",8530418],["thread",8527038],["thread",8526568],["thread",8526310],["thread",8517427],["thread",8496457],["thread",8484458],["thread",8481783],["thread",8465233],["thread",8453621],["thread",8438497],["thread",8438120],["thread",8432837],["thread",8423893],["thread",8414573],["thread",8409715],["thread",8399609],["thread",8377594],["thread",8375736],["thread",8370306],["thread",8370300],["thread",8365218],["thread",8364795],["thread",8363636],["thread",8351122],["thread",8345131],["thread",8342174],["thread",8340137],["thread",8338084],["thread",8337279],["thread",8333852],["thread",8323505],["thread",8317592],["thread",8317331],["thread",8317071],["thread",8316808],["thread",8315952],["thread",8311986],["thread",8310174],["thread",8306319],["thread",8301869],["thread",8300108],["thread",8299812],["thread",8297995],["thread",8297261],["thread",8285723],["thread",8283192],["thread",8281350],["thread",8281172],["thread",8279718],["thread",8277727],["thread",8269055],["thread",8268729],["thread",8267773],["thread",8264756],["thread",8262571],["thread",8260116],["thread",8258141],["thread",8257460]], 156, tinhte_xentag_tag, , {"tags":["honda dylan"]}, date, 0, , [], 0, 1657213053, 68b0be3b9f9ab8ae9d82d6fe0f3853a4
Run Time: 0.000682