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 (9937744, 9826111, 9603340, 9602440, 9602439, 9602438, 9602436, 9602435, 9602433, 9600030, 9588019, 9585866, 9582038, 9582037, 9576733, 9574444, 9574432, 9574425, 9569564, 9563473, 9561346, 9547901, 9547545, 9546536, 9539885, 9527019, 9516844, 9514893, 9514892, 9506089, 9504986, 9495131, 9494594, 9493721, 9490858, 9489592, 9460171, 9460166, 9460165, 9460164, 9458662, 9458287, 9456205, 9454264, 9452643, 9451738, 9451413, 9449921, 9449919, 9448285, 9446861, 9445410, 9445409, 9445408, 9445049, 9444828, 9444279, 9437748, 9437190, 9433489, 9429137, 9428911, 9425954, 9423987, 9423601, 9420681, 9416780, 9416737, 9415442, 9414452, 9413894, 9413191, 9413124, 9411943, 9409693, 9409691, 9409690, 9408120, 9407404, 9406434, 9405111, 9405110, 9403875, 9403397, 9400212, 9399756, 9399721, 9399016, 9397593, 9393439, 9392645, 9388304, 9381296, 9373682, 9370939, 9370937, 9370936, 9365624, 9361873, 9361872, 9361267, 9356929, 9350232, 9346617, 9344359, 9338830, 9335756, 9333855, 9320277, 9319736, 9319735, 9314988, 9313518, 9308208, 9307049, 9305290, 9303699, 9301444, 9295999, 9290495, 9290494, 9288529, 9287380, 9276814, 9275251, 9275219, 9272316, 9267521, 9257041, 9257040, 9255758, 9255216, 9252688, 9242624, 9237967, 9232008, 9231302, 9231301, 9228982, 9223311, 9221052, 9212749, 9211402, 9211401, 9210089, 9210022, 9204229, 9201334, 9196380, 9193593, 9193592, 9188658, 9187677, 9185599, 9180622, 9177120, 9177119, 9175975, 9175512, 9175314, 9174953, 9173229, 9172628, 9170374, 9170296, 9169433, 9163185, 9162826, 9161214, 9149026, 9147680, 9142185, 9136498, 9134876, 9134036, 9133803, 9125701, 9120117, 9111369, 9109638, 9103515, 9100556, 9098529, 9098395, 9090833, 9090832, 9089256, 9076459, 9073171, 9073170, 9070353, 9066857, 9064514, 9060769, 9060768, 9059299, 9057605, 9056407, 9053209, 9051037, 9049239, 9048256, 9046505, 9039565, 9035816, 9032461, 9031633, 9028762, 9024089, 9023208, 9021584, 9021583, 9021486, 9020823, 9018748, 9017509, 9017507, 9015369, 9014442, 9008873, 9001686, 9001163, 8998678, 8991006, 8986333, 8986331, 8985830, 8984102, 8977534, 8972977, 8969534, 8968757, 8965493, 8965492, 8963479, 8962950, 8962933, 8962895, 8961856, 8961855, 8961853, 8961852, 8961851, 8961653, 8956385, 8956384, 8956383, 8956382, 8956381, 8955746, 8955602, 8954420, 8952555, 8950397, 8948951, 8948905, 8947524, 8946304, 8945221, 8945220, 8945219, 8943102, 8942924, 8942923, 8941639, 8932778, 8928235, 8925014, 8925009, 8924952, 8924940, 8922444, 8919609, 8913586, 8911859, 8907334, 8906304, 8906246, 8904580, 8903703, 8902937, 8901485, 8897525, 8897342, 8897341, 8894490, 8893381, 8892431, 8892428, 8892426, 8892407, 8891994, 8891843, 8891842, 8891624, 8889850, 8889754, 8887727, 8887254, 8885309, 8885031, 8884729, 8884641, 8884227, 8884133, 8883037, 8882354, 8881700, 8881471, 8881404, 8880535, 8879646, 8879307, 8879304, 8876047, 8876046, 8876045, 8874932, 8874359, 8874307, 8874306, 8873683, 8873682, 8873466, 8871112, 8870205, 8866931, 8866563, 8866126, 8864107, 8864106, 8864023, 8863993, 8862136, 8860964, 8860442, 8860431, 8859657, 8859630, 8857456, 8857455, 8856971, 8856683, 8855530, 8855150, 8855148, 8855147, 8853440, 8853439, 8852773, 8852561, 8852331, 8852330, 8852191, 8851803, 8851306, 8850100, 8848039, 8848038, 8848036, 8848035, 8848018, 8847409, 8847292, 8845539, 8845537, 8841351, 8841064, 8838983, 8833776, 8833193, 8832789, 8832785, 8832784, 8832783, 8831291, 8830922, 8829656, 8829528, 8829002, 8828625, 8828577, 8828304, 8826148, 8824095, 8823474, 8820881, 8819967, 8819098, 8818867, 8818386, 8814287, 8814146, 8813978, 8813043, 8811191, 8811188, 8811184, 8810503, 8810475, 8810045, 8809933, 8809932, 8808962, 8808960, 8808954, 8808953, 8808951, 8808950, 8808605, 8807562, 8806965, 8806964, 8805296, 8803918, 8803666, 8802008, 8800158, 8800157, 8799328, 8795728, 8794130, 8792876, 8791522, 8791348, 8790468, 8788871, 8788557, 8788007, 8787896, 8787852, 8787792, 8787560, 8785407, 8783991, 8782788, 8781249, 8781202, 8780311, 8778239, 8775189, 8775187, 8774538, 8773895, 8772682, 8771494, 8771255, 8771245, 8771239, 8771236, 8771235, 8770286, 8765092, 8761160, 8760358, 8758702, 8757557, 8757141, 8754611, 8752748, 8752308, 8751686, 8751539, 8751280, 8750335, 8749919, 8749646, 8744738, 8742101, 8740194, 8739784, 8738355, 8733077, 8733076, 8732986, 8732985, 8732427, 8732231, 8730481, 8729279, 8729108, 8729005, 8728920, 8728913, 8728763, 8727246, 8727240, 8726897, 8726730, 8726408, 8725431, 8725049, 8724676, 8724519, 8723727, 8722299, 8720100, 8719147, 8718824, 8718769, 8718065, 8717213, 8716953, 8716951, 8716940, 8716743, 8716383, 8715471, 8715382, 8715119, 8713994, 8713993, 8713736, 8713437, 8713218, 8710800, 8710041, 8708857, 8708835, 8708456, 8707782, 8705685, 8703037, 8701828, 8701473, 8698652, 8697769, 8696697, 8696361, 8688544, 8685025, 8683557, 8680971, 8680433, 8679696, 8678439, 8678438, 8677187, 8676947, 8676946, 8676634, 8675489, 8675130, 8673534, 8673153, 8669797, 8666995, 8666763, 8666761, 8665463, 8665462, 8665178, 8665137, 8664322, 8662639, 8661333, 8658999, 8657666, 8655243, 8653807, 8651857, 8651081, 8650253, 8649468, 8649398, 8649159, 8649158, 8644950, 8642975, 8642758, 8641546, 8639749, 8639747, 8639745, 8638441, 8634032, 8632618, 8631854, 8631853, 8631821, 8631820, 8631819, 8625164, 8624366, 8622232, 8621898, 8621762, 8621370, 8618476, 8614135, 8613510, 8612087, 8609832, 8605494, 8603503, 8603306, 8602585, 8602219, 8602218, 8602216, 8598656, 8598554, 8598257, 8594545, 8594543, 8594542, 8594541, 8591540, 8590992, 8588073, 8587568, 8585188, 8584534, 8578738, 8575881, 8575880, 8575416, 8573907, 8572875, 8572462, 8571060, 8567236, 8567125, 8565481, 8565164, 8564447, 8562294, 8562270, 8562268, 8562265, 8559569, 8557429, 8556728, 8555915, 8548920, 8548632, 8541286, 8536473, 8534376, 8534375, 8534374, 8533861, 8533859, 8533858, 8529613, 8529556, 8527686, 8524710, 8524613, 8524609, 8523781, 8521391, 8501021, 8498860, 8487920, 8487229, 8484361, 8483963, 8481780, 8481730, 8479851, 8449768, 8439314, 8439306, 8428122, 8399243, 8393978, 8387091, 8384263, 8379964, 8364812, 8361163, 8359417, 8347195, 8345856, 8343704, 8340575, 8335937, 8334279, 8331445, 8328495, 8328336, 8327242, 8321839, 8317283, 8309826, 8308389, 8306596, 8305844, 8304867, 8295412, 8291183, 8283840, 8280762, 8278120, 8274959, 8274957, 8274168, 8272416, 8272071, 8271087, 8269693, 8269462, 8264299, 8259853, 8258033, 8232839, 8227609, 8209637, 8205293, 8171196, 8169518, 8156998, 8140472, 8133468, 8124875, 8086285, 8085487, 8030661, 8017502, 8007159, 7964108, 7857153, 7706847, 7702667, 7690509, 7681108, 7594135, 7488943, 7486145, 7479087, 7412577, 7342393)
Run Time: 0.023810
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 733 | 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",9603340],["thread",9602436],["thread",9602435],["thread",9602433],["thread",9600030],["thread",9588019],["thread",9582038],["thread",9574444],["thread",9569564],["thread",9527019],["thread",9495131],["thread",9493721],["thread",9458287],["thread",9456205],["thread",9423987],["thread",9416737],["thread",9413124],["thread",9411943],["thread",9408120],["thread",9406434],["thread",9405111],["thread",9403875],["thread",9397593],["thread",9392645],["thread",9356929],["thread",9313518],["thread",9275219],["thread",9257041],["thread",9232008],["thread",9231302],["thread",9211402],["thread",9204229],["thread",9196380],["thread",9188658],["thread",9177120],["thread",9175975],["thread",9170296],["thread",9142185],["thread",9109638],["thread",9089256],["thread",9076459],["thread",9070353],["thread",9064514],["thread",9057605],["thread",9048256],["thread",9023208],["thread",9021584],["thread",9017509],["thread",9014442],["thread",8998678],["thread",8991006],["thread",8985830],["thread",8965493],["thread",8963479],["thread",8962950],["thread",8961856],["thread",8950397],["thread",8946304],["thread",8943102],["thread",8913586],["thread",8904580],["thread",8897342],["thread",8892431],["thread",8891624],["thread",8887727],["thread",8884641],["thread",8884227],["thread",8881471],["thread",8879304],["thread",8873683],["thread",8871112],["thread",8870205],["thread",8864107],["thread",8863993],["thread",8859630],["thread",8852561],["thread",8852191],["thread",8851803],["thread",8823474],["thread",8818386],["thread",8813978],["thread",8810475],["thread",8805296],["thread",8802008],["thread",8795728],["thread",8791522],["thread",8790468],["thread",8788871],["thread",8787896],["thread",8781202],["thread",8760358],["thread",8751280],["thread",8739784],["thread",8732986],["thread",8732427],["thread",8729279],["thread",8720100],["thread",8718824],["thread",8718769],["thread",8718065],["thread",8713736],["thread",8713218],["thread",8707782],["thread",8703037],["thread",8697769],["thread",8696697],["thread",8696361],["thread",8683557],["thread",8680433],["thread",8678439],["thread",8676947],["thread",8675489],["thread",8675130],["thread",8673534],["thread",8673153],["thread",8666995],["thread",8665463],["thread",8665178],["thread",8665137],["thread",8662639],["thread",8658999],["thread",8655243],["thread",8650253],["thread",8642758],["thread",8638441],["thread",8625164],["thread",8622232],["thread",8621898],["thread",8621762],["thread",8612087],["thread",8609832],["thread",8605494],["thread",8602585],["thread",8598554],["thread",8598257],["thread",8591540],["thread",8588073],["thread",8587568],["thread",8585188],["thread",8584534],["thread",8575881],["thread",8575416],["thread",8571060],["thread",8562294],["thread",8562270],["thread",8559569],["thread",8557429],["thread",8556728],["thread",8555915],["thread",8548632],["thread",8541286],["thread",8536473],["thread",8534376],["thread",8527686],["thread",8524613],["thread",8501021],["thread",8498860],["thread",8487920],["thread",8487229],["thread",8483963],["thread",8481780],["thread",8481730],["thread",8479851],["thread",8449768],["thread",8439306],["thread",8428122],["thread",8399243],["thread",8393978],["thread",8387091],["thread",8384263],["thread",8379964],["thread",8364812],["thread",8361163],["thread",8359417],["thread",8347195],["thread",8345856],["thread",8343704],["thread",8340575],["thread",8335937],["thread",8334279],["thread",8331445],["thread",8328495],["thread",8328336],["thread",8327242],["thread",8321839],["thread",8317283],["thread",8309826],["thread",8308389],["thread",8306596],["thread",8305844],["thread",8304867],["thread",8295412],["thread",8291183],["thread",8283840],["thread",8280762],["thread",8274959],["thread",8274168],["thread",8272416],["thread",8272071],["thread",8271087],["thread",8269693],["thread",8269462],["thread",8264299],["thread",8259853],["thread",8258033],["thread",8232839],["thread",8209637],["thread",8205293],["thread",8171196],["thread",8169518],["thread",8156998],["thread",8140472],["thread",8133468],["thread",8124875],["thread",8086285],["thread",8085487],["thread",8030661],["thread",8017502],["thread",8007159],["thread",7964108],["thread",7857153],["thread",7706847],["thread",7702667],["thread",7690509],["thread",7681108],["thread",7594135],["thread",7488943],["thread",7486145],["thread",7479087],["thread",7412577],["thread",7342393]], 232, tinhte_xentag_tag, , {"tags":["honda lead"]}, date, 0, , [], 0, 1715386580, c8bd2c1f5d94c4a2d41b6dc0e498d8fe
Run Time: 0.000717