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 (9676283, 9671160, 9667189, 9666703, 9666378, 9665958, 9665957, 9654103, 9654096, 9654095, 9652440, 9648897, 9648881, 9632520, 9632245, 9629562, 9629561, 9614139, 9610671, 9607247, 9607245, 9604549, 9602897, 9602896, 9602798, 9602797, 9600258, 9600257, 9600256, 9600253, 9596259, 9596149, 9596148, 9596146, 9596142, 9592917, 9591123, 9586325, 9586323, 9584320, 9583546, 9565876, 9561466, 9559077, 9554874, 9554866, 9554858, 9554376, 9554130, 9547650, 9547379, 9547138, 9547070, 9546100, 9540220, 9538715, 9532201, 9530764, 9530763, 9526179, 9526177, 9526176, 9509911, 9503011, 9500526, 9499299, 9499298, 9499297, 9499296, 9497984, 9495590, 9476985, 9446567, 9437155, 9437154, 9437152, 9433483, 9433152, 9421314, 9421310, 9413709, 9412367, 9405884, 9391847, 9391840, 9378518, 9374365, 9374364, 9372166, 9372165, 9372164, 9372163, 9372162, 9371650, 9362801, 9355467, 9351740, 9343398, 9341948, 9340577, 9337123, 9335531, 9327448, 9315657, 9313102, 9311967, 9307267, 9307265, 9304457, 9304028, 9303161, 9291605, 9287237, 9283865, 9283864, 9283781, 9278420, 9256492, 9255951, 9255950, 9254845, 9254301, 9253719, 9249978, 9249464, 9243404, 9233528, 9227219, 9227183, 9226266, 9219872, 9217723, 9217722, 9217720, 9217719, 9217686, 9217389, 9216916, 9215451, 9213035, 9211299, 9202203, 9200046, 9199279, 9197209, 9196780, 9194669, 9193799, 9180736, 9180735, 9176513, 9174701, 9174479, 9174478, 9172975, 9168502, 9167801, 9167774, 9167743, 9167722, 9166929, 9164921, 9161038, 9161037, 9155891, 9151551, 9151549, 9150907, 9150458, 9149471, 9148555, 9147025, 9147023, 9147022, 9147017, 9147015, 9147003, 9146990, 9146697, 9146380, 9146379, 9144544, 9143779, 9140761, 9140739, 9131000, 9130719, 9130714, 9130711, 9129199, 9125133, 9125132, 9122691, 9112056, 9106471, 9101336, 9091907, 9091894, 9074761, 9073865, 9067361, 9062533, 9062478, 9061927, 9059692, 9059372, 9059371, 9058685, 9058210, 9054152, 9052957, 9043615, 9043474, 9036834, 9036547, 9036546, 9032402, 9028632, 9028086, 9028085, 9026886, 9016913, 9015956, 9012052, 9009742, 9009739, 9005956, 9001939, 8996560, 8996325, 8996140, 8995610, 8991155, 8990703, 8990702, 8990701, 8990314, 8990312, 8989520, 8988380, 8988378, 8988377, 8987345, 8984664, 8982574, 8980320, 8976115, 8965911, 8963846, 8963845, 8963278, 8962461, 8958124, 8957727, 8954688, 8953757, 8953756, 8952165, 8950822, 8950734, 8947226, 8942206, 8940670, 8940318, 8940317, 8937509, 8935858, 8935856, 8932102, 8931988, 8927622, 8927365, 8926320, 8926319, 8924884, 8924883, 8924880, 8922378, 8920059, 8919334, 8918155, 8914009, 8913269, 8912961, 8912249, 8909304, 8905785, 8905648, 8900266, 8899424, 8896976, 8896975, 8896973, 8895803, 8895801, 8891775, 8890925, 8889410, 8885098, 8884359, 8883896, 8882646, 8879476, 8879471, 8879462, 8875828, 8874939, 8872084, 8870540, 8870486, 8870483, 8870467, 8866986, 8866985, 8863904, 8863528, 8863527, 8863525, 8862988, 8861335, 8859025, 8858375, 8857210, 8857205, 8857150, 8857134, 8856310, 8850092, 8850091, 8849719, 8849280, 8849264, 8846147, 8842014, 8837876, 8837751, 8837000, 8836953, 8836179, 8831187, 8829262, 8827911, 8827909, 8825134, 8822673, 8822132, 8820969, 8820968, 8819964, 8818336, 8818335, 8817138, 8817107, 8815904, 8815863, 8812921, 8812030, 8811186, 8808928, 8802356, 8802354, 8801350, 8801344, 8800634, 8793963, 8793962, 8789346, 8788891, 8788889, 8788776, 8788774, 8788383, 8786698, 8786340, 8783810, 8783776, 8783570, 8783566, 8781993, 8781121, 8780854, 8778445, 8778429, 8778398, 8778132, 8778130, 8775103, 8775102, 8775099, 8771909, 8771495, 8770395, 8769977, 8769975, 8768187, 8766984, 8766983, 8766982, 8764624, 8758857, 8758856, 8757740, 8756795, 8756794, 8754122, 8749893, 8749239, 8749238, 8747620, 8747619, 8747618, 8747617, 8742703, 8742698, 8742675, 8741623, 8741621, 8741457, 8736403, 8736402, 8736263, 8734360, 8733902, 8730081, 8725433, 8723863, 8723712, 8722429, 8722282, 8721538, 8721112, 8718267, 8717080, 8709260, 8709031, 8707570, 8706403, 8706321, 8706320, 8705858, 8702941, 8701332, 8699775, 8694216, 8693170, 8691649, 8689587, 8688354, 8681169, 8681168, 8667088, 8666427, 8665131, 8664318, 8663948, 8662871, 8662435, 8662425, 8662417, 8662396, 8662377, 8661041, 8659572, 8657397, 8657395, 8655355, 8651891, 8644697, 8644696, 8644672, 8643536, 8643411, 8643410, 8635441, 8635194, 8635078, 8635077, 8631748, 8631411, 8631361, 8630561, 8625490, 8624282, 8620659, 8620038, 8613815, 8611275, 8609057, 8607825, 8607097, 8605971, 8604258, 8603666, 8603665, 8603663, 8602336, 8600898, 8600715, 8598526, 8598362, 8598359, 8594779, 8591389, 8590984, 8588514, 8587768, 8580750, 8579639, 8575891, 8571162, 8571161, 8567873, 8567518, 8567517, 8566263, 8565475, 8565465, 8565071, 8564546, 8564300, 8563320, 8563263, 8560068, 8556300, 8550075, 8549061, 8549060, 8548662, 8547892, 8547891, 8544901, 8543825, 8539108, 8539107, 8539015, 8539013, 8539011, 8538173, 8538172, 8538170, 8538003, 8537206, 8537197, 8536894, 8533743, 8532664, 8528073, 8527994, 8526091, 8523133, 8523081, 8521174, 8515210, 8514294, 8514009, 8512721, 8512269, 8510588, 8501718, 8500585, 8488510, 8486121, 8484566, 8481190, 8480066, 8480061, 8480060, 8480054, 8479141, 8478356, 8478355, 8478354, 8477109, 8471268, 8468867, 8468362, 8463535, 8461381, 8461135, 8458213, 8458212, 8457865, 8456350, 8455937, 8454724, 8445495, 8444744, 8443418, 8435589, 8423391, 8417648, 8417583, 8415355, 8415186, 8413318, 8410111, 8409795, 8409794, 8408569, 8408189, 8406684, 8394225, 8393872, 8393767, 8382702, 8375773, 8375151, 8374433, 8373649, 8356185, 8346879, 8345529, 8339790, 8335061, 8333923, 8333355, 8330504, 8329242, 8328890, 8324939, 8324554, 8322034, 8321699, 8320917, 8318192, 8316904, 8316903, 8313239, 8313236, 8310578, 8310530, 8309784, 8307234, 8305292, 8305117, 8303146, 8301524, 8297182, 8296964, 8295789, 8294930, 8294929, 8294926, 8294640, 8292871, 8292801, 8290525, 8289899, 8289013, 8286733, 8286348, 8280814, 8276107, 8275015, 8273246, 8271894, 8267617, 8265822, 8265821, 8259695, 8256850, 8256119, 8255772, 8255771, 8255759, 8253221, 8250810, 8239439, 8239279, 8239276, 8237381, 8237315, 8237099, 8236540, 8235209, 8229944, 8229856, 8229303, 8228916, 8227349, 8222244, 8220011, 8218874, 8218171, 8217396, 8212858, 8212857, 8211763, 8210917, 8210640, 8210046, 8204701, 8203796, 8203609, 8202593, 8201701, 8198369, 8198366, 8198305, 8197788, 8193992, 8193985, 8190124, 8188345, 8188344, 8187063, 8187062, 8187061, 8187060, 8186580, 8184919, 8183132, 8183131, 8181605, 8180420, 8177464, 8175956, 8175955, 8175954, 8173759, 8173203, 8173157, 8169184, 8168538, 8164484, 8164482, 8164447, 8164379, 8163829, 8159569, 8158443, 8158135, 8140192, 8116807, 8096680, 8096679, 8091712, 7795254, 7714314, 6007953, 5670874, 4228662, 2767295, 2366802, 2244350, 1868371, 1613095)
Run Time: 0.018609
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 747 | 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",97],["thread",9676283],["thread",9671160],["thread",9667189],["thread",9666703],["thread",9666378],["thread",9665958],["thread",9654103],["thread",9654096],["thread",9652440],["thread",9648897],["thread",9648881],["thread",9632520],["thread",9632245],["thread",9629562],["thread",9614139],["thread",9602897],["thread",9602798],["thread",9596148],["thread",9591123],["thread",9565876],["thread",9561466],["thread",9559077],["thread",9554376],["thread",9547650],["thread",9547379],["thread",9547138],["thread",9547070],["thread",9546100],["thread",9503011],["thread",9500526],["thread",9499299],["thread",9497984],["thread",9446567],["thread",9437155],["thread",9421314],["thread",9413709],["thread",9412367],["thread",9405884],["thread",9391847],["thread",9378518],["thread",9372166],["thread",9372165],["thread",9372164],["thread",9372163],["thread",9372162],["thread",9351740],["thread",9343398],["thread",9341948],["thread",9337123],["thread",9315657],["thread",9313102],["thread",9307267],["thread",9304028],["thread",9287237],["thread",9283781],["thread",9278420],["thread",9256492],["thread",9255951],["thread",9254301],["thread",9253719],["thread",9249978],["thread",9249464],["thread",9243404],["thread",9227219],["thread",9217723],["thread",9217686],["thread",9216916],["thread",9193799],["thread",9180736],["thread",9174479],["thread",9172975],["thread",9168502],["thread",9167743],["thread",9167722],["thread",9166929],["thread",9155891],["thread",9149471],["thread",9146697],["thread",9146380],["thread",9144544],["thread",9140761],["thread",9131000],["thread",9130719],["thread",9130714],["thread",9130711],["thread",9125133],["thread",9106471],["thread",9101336],["thread",9074761],["thread",9067361],["thread",9062533],["thread",9062478],["thread",9061927],["thread",9059692],["thread",9059372],["thread",9058685],["thread",9058210],["thread",9054152],["thread",9052957],["thread",9032402],["thread",9028632],["thread",9028086],["thread",9015956],["thread",9005956],["thread",9001939],["thread",8996560],["thread",8996140],["thread",8990703],["thread",8990314],["thread",8987345],["thread",8982574],["thread",8980320],["thread",8963846],["thread",8962461],["thread",8953757],["thread",8952165],["thread",8950822],["thread",8950734],["thread",8942206],["thread",8940318],["thread",8935856],["thread",8932102],["thread",8931988],["thread",8927365],["thread",8924884],["thread",8922378],["thread",8920059],["thread",8919334],["thread",8918155],["thread",8914009],["thread",8912961],["thread",8912249],["thread",8909304],["thread",8905785],["thread",8899424],["thread",8896976],["thread",8895803],["thread",8891775],["thread",8885098],["thread",8884359],["thread",8879476],["thread",8879471],["thread",8879462],["thread",8875828],["thread",8872084],["thread",8870540],["thread",8870486],["thread",8870467],["thread",8866986],["thread",8866985],["thread",8863904],["thread",8863528],["thread",8858375],["thread",8856310],["thread",8850092],["thread",8846147],["thread",8842014],["thread",8837751],["thread",8837000],["thread",8836953],["thread",8829262],["thread",8822673],["thread",8822132],["thread",8820969],["thread",8818336],["thread",8817138],["thread",8817107],["thread",8815904],["thread",8815863],["thread",8812921],["thread",8811186],["thread",8802356],["thread",8801350],["thread",8801344],["thread",8800634],["thread",8793963],["thread",8789346],["thread",8788776],["thread",8786698],["thread",8786340],["thread",8781993],["thread",8781121],["thread",8780854],["thread",8778429],["thread",8778398],["thread",8778132],["thread",8775103],["thread",8771495],["thread",8769977],["thread",8749893],["thread",8749239],["thread",8747620],["thread",8742703],["thread",8741623],["thread",8734360],["thread",8733902],["thread",8723863],["thread",8723712],["thread",8722429],["thread",8721538],["thread",8721112],["thread",8717080],["thread",8709260],["thread",8709031],["thread",8707570],["thread",8706321],["thread",8705858],["thread",8702941],["thread",8701332],["thread",8699775],["thread",8694216],["thread",8693170],["thread",8691649],["thread",8689587],["thread",8688354],["thread",8667088],["thread",8666427],["thread",8664318],["thread",8663948],["thread",8662435],["thread",8662425],["thread",8662417],["thread",8662396],["thread",8662377],["thread",8661041],["thread",8659572],["thread",8657397],["thread",8655355],["thread",8651891],["thread",8644697],["thread",8643536],["thread",8643411],["thread",8635194],["thread",8635078],["thread",8631748],["thread",8631411],["thread",8631361],["thread",8630561],["thread",8625490],["thread",8624282],["thread",8620659],["thread",8620038],["thread",8613815],["thread",8611275],["thread",8607825],["thread",8607097],["thread",8605971],["thread",8604258],["thread",8603666],["thread",8602336],["thread",8600898],["thread",8600715],["thread",8598526],["thread",8598362],["thread",8591389],["thread",8590984],["thread",8588514],["thread",8580750],["thread",8579639],["thread",8575891],["thread",8571162],["thread",8566263],["thread",8565475],["thread",8565071],["thread",8564546],["thread",8563320],["thread",8563263],["thread",8560068],["thread",8556300],["thread",8549061],["thread",8548662],["thread",8544901],["thread",8543825],["thread",8539015],["thread",8538173],["thread",8538003],["thread",8537206],["thread",8536894],["thread",8527994],["thread",8526091],["thread",8523081],["thread",8521174],["thread",8515210],["thread",8514294],["thread",8512721],["thread",8501718],["thread",8500585],["thread",8488510],["thread",8486121],["thread",8484566],["thread",8481190],["thread",8480066],["thread",8480061],["thread",8480060],["thread",8480054],["thread",8479141],["thread",8478356],["thread",8477109],["thread",8468867],["thread",8468362],["thread",8463535],["thread",8461381],["thread",8461135],["thread",8458213],["thread",8457865],["thread",8456350],["thread",8455937],["thread",8454724],["thread",8445495],["thread",8444744],["thread",8443418],["thread",8435589],["thread",8423391],["thread",8417648],["thread",8413318],["thread",8410111],["thread",8409795],["thread",8408569],["thread",8406684],["thread",8394225],["thread",8393872],["thread",8382702],["thread",8375773],["thread",8375151],["thread",8374433],["thread",8373649],["thread",8356185],["thread",8346879],["thread",8345529],["thread",8339790],["thread",8335061],["thread",8333923],["thread",8333355],["thread",8330504],["thread",8329242],["thread",8328890],["thread",8324554],["thread",8322034],["thread",8321699],["thread",8320917],["thread",8318192],["thread",8316904],["thread",8313239],["thread",8313236],["thread",8310578],["thread",8310530],["thread",8309784],["thread",8307234],["thread",8305292],["thread",8303146],["thread",8301524],["thread",8297182],["thread",8296964],["thread",8294930],["thread",8294929],["thread",8294926],["thread",8294640],["thread",8292871],["thread",8292801],["thread",8289899],["thread",8289013],["thread",8286733],["thread",8286348],["thread",8280814],["thread",8276107],["thread",8275015],["thread",8273246],["thread",8271894],["thread",8267617],["thread",8265822],["thread",8259695],["thread",8256850],["thread",8255772],["thread",8255759],["thread",8253221],["thread",8250810],["thread",8239439],["thread",8239279],["thread",8237381],["thread",8237315],["thread",8237099],["thread",8236540],["thread",8235209],["thread",8229944],["thread",8229856],["thread",8229303],["thread",8228916],["thread",8227349],["thread",8222244],["thread",8220011],["thread",8218874],["thread",8218171],["thread",8217396],["thread",8212858],["thread",8211763],["thread",8210917],["thread",8210640],["thread",8204701],["thread",8203796],["thread",8203609],["thread",8202593],["thread",8201701],["thread",8198369],["thread",8198366],["thread",8197788],["thread",8193992],["thread",8190124],["thread",8188345],["thread",8187063],["thread",8186580],["thread",8184919],["thread",8183132],["thread",8181605],["thread",8180420],["thread",8177464],["thread",8173759],["thread",8173203],["thread",8168538],["thread",8164484],["thread",8164482],["thread",8164447],["thread",8164379],["thread",8163829],["thread",8159569],["thread",8158443],["thread",8158135],["thread",8140192],["thread",8096680],["thread",7795254],["thread",7714314],["thread",5670874],["thread",1613095]], 433, tinhte_xentag_tag, , {"tags":["v\u00ed n\u1eef"]}, date, 0, , [], 0, 1653788500, 115a558d06b892367c880bccafbc7b2d
Run Time: 0.000831