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 (9619292, 9558756, 9558567, 9558566, 9557974, 9557973, 9557807, 9557802, 9530443, 9530441, 9529584, 9522475, 9518679, 9518659, 9517809, 9517269, 9516296, 9516237, 9516230, 9516229, 9514878, 9503024, 9503023, 9501562, 9501559, 9501554, 9501547, 9501544, 9501542, 9500217, 9499203, 9499202, 9492205, 9492189, 9492180, 9492176, 9491941, 9491939, 9491833, 9491435, 9491421, 9491414, 9487285, 9486749, 9486748, 9486539, 9486538, 9486534, 9486533, 9486532, 9486531, 9486530, 9486094, 9484375, 9475581, 9472221, 9472219, 9472217, 9472208, 9472207, 9471491, 9471490, 9467903, 9467901, 9460195, 9460193, 9460189, 9460183, 9460182, 9460180, 9460173, 9460167, 9454771, 9447104, 9447027, 9432547, 9430621, 9430597, 9426860, 9426842, 9426241, 9425562, 9412564, 9412563, 9408731, 9406294, 9404112, 9402569, 9402234, 9400949, 9400938, 9399754, 9399751, 9399741, 9399738, 9394658, 9394645, 9393390, 9391702, 9388867, 9388857, 9387875, 9386834, 9385997, 9383021, 9383018, 9379585, 9378072, 9376376, 9376180, 9376179, 9376045, 9375805, 9375754, 9375276, 9375236, 9375205, 9375201, 9374676, 9374669, 9374606, 9372232, 9372056, 9371912, 9371911, 9371910, 9371907, 9371897, 9371884, 9371871, 9370306, 9370284, 9370243, 9369644, 9369643, 9369642, 9369641, 9369640, 9369639, 9369638, 9367210, 9367155, 9366974, 9362618, 9360137, 9360134, 9360133, 9358479, 9358475, 9358474, 9355386, 9350379, 9350367, 9348720, 9347628, 9347627, 9344893, 9344824, 9344199, 9344198, 9342223, 9341632, 9341629, 9341107, 9341097, 9340739, 9338706, 9338656, 9338655, 9338654, 9338653, 9337167, 9329225, 9325600, 9324394, 9324135, 9324134, 9323363, 9323362, 9321471, 9321459, 9321150, 9321097, 9320908, 9320907, 9320906, 9318479, 9316238, 9314084, 9313511, 9313483, 9312871, 9312019, 9311187, 9310543, 9309881, 9308987, 9308945, 9308540, 9307635, 9307614, 9307527, 9307363, 9307308, 9306723, 9305358, 9304950, 9304845, 9304822, 9304585, 9304396, 9304395, 9303569, 9303568, 9302974, 9302821, 9302407, 9296180, 9296179, 9296178, 9292766, 9292668, 9291351, 9291350, 9291348, 9291347, 9291344, 9290253, 9290252, 9284996, 9284076, 9284062, 9282349, 9281092, 9280365, 9280363, 9280358, 9280353, 9279968, 9279872, 9279871, 9279870, 9279869, 9279868, 9279838, 9279834, 9279832, 9279218, 9278693, 9278155, 9278151, 9277666, 9277662, 9277657, 9277654, 9277650, 9274446, 9273683, 9272586, 9271418, 9270575, 9270406, 9270387, 9268004, 9268000, 9267228, 9266898, 9266897, 9266699, 9264630, 9263684, 9263384, 9260848, 9260540, 9256519, 9256512, 9256506, 9255769, 9255178, 9255177, 9254561, 9254430, 9253226, 9251749, 9250510, 9248964, 9248947, 9248946, 9248945, 9248858, 9246744, 9244902, 9243978, 9242949, 9242263, 9241267, 9241258, 9240332, 9239874, 9235767, 9235663, 9235010, 9234176, 9234103, 9234078, 9232959, 9232946, 9232775, 9232731, 9232729, 9228996, 9228987, 9228972, 9228961, 9227324, 9226902, 9226799, 9226798, 9226797, 9226289, 9223547, 9222217, 9221894, 9220929, 9220558, 9220557, 9220556, 9219012, 9218630, 9218221, 9217494, 9216429, 9215381, 9214223, 9213901, 9212424, 9212189, 9211778, 9208373, 9207447, 9207308, 9207299, 9207296, 9207294, 9204761, 9203944, 9203068, 9202924, 9201068, 9200882, 9200293, 9200166, 9200089, 9199443, 9199432, 9198400, 9197755, 9196997, 9195705, 9193284, 9193012, 9190808, 9190611, 9189310, 9187493, 9187489, 9187487, 9186737, 9185501, 9183728, 9183355, 9183353, 9183351, 9183266, 9183265, 9182983, 9180779, 9180776, 9180669, 9180646, 9178908, 9178902, 9178208, 9177456, 9175924, 9173185, 9173184, 9173088, 9173010, 9166584, 9166503, 9166502, 9166478, 9165560, 9164478, 9164434, 9163481, 9163473, 9163468, 9163464, 9163423, 9162627, 9160886, 9158490, 9157374, 9156603, 9155468, 9152554, 9152551, 9150464, 9149453, 9148653, 9146949, 9146890, 9145268, 9144896, 9141762, 9141613, 9139930, 9137362, 9136675, 9136673, 9135786, 9135785, 9135777, 9135344, 9133917, 9133743, 9133029, 9132792, 9131746, 9131741, 9131150, 9131061, 9129540, 9128985, 9128302, 9128281, 9126961, 9126628, 9126226, 9125484, 9124982, 9124976, 9124880, 9122772, 9122217, 9122216, 9122203, 9118377, 9116154, 9115650, 9114744, 9114740, 9113295, 9113293, 9112192, 9109491, 9109344, 9107857, 9106397, 9105706, 9105597, 9104546, 9102771, 9101869, 9100554, 9099424, 9098619, 9097915, 9097914, 9097712, 9095122, 9092568, 9091515, 9090808, 9090141, 9087768, 9087508, 9085889, 9084941, 9084399, 9084231, 9083642, 9083515, 9082651, 9081899, 9081562, 9077916, 9071690, 9069242, 9069105, 9069094, 9066253, 9064890, 9064438, 9061944, 9056887, 9056710, 9051850, 9050019, 9048940, 9046855, 9046237, 9045097, 9044639, 9043763, 9041670, 9041356, 9041324, 9041323, 9041322, 9039454, 9038335, 9037751, 9037371, 9036870, 9033840, 9030528, 9029574, 9027633, 9026696, 9026650, 9022606, 9022584, 9019748, 9018846, 9018527, 9016727, 9015086, 9014409, 9014373, 9013021, 9012403, 9011437, 9011433, 9011199, 9008331, 9007598, 9007292, 9007291, 9006856, 9006836, 9005472, 9005471, 9005171, 9004832, 9004460, 9003471, 9002565, 9001285, 9000989, 9000988, 9000972, 9000603, 8999563, 8999231, 8998211, 8998197, 8998194, 8998193, 8998191, 8998054, 8995678, 8995677, 8994479, 8993424, 8991025, 8988772, 8984276, 8984067, 8983981, 8981993, 8981704, 8981159, 8980204, 8979498, 8977326, 8974764, 8974554, 8974140, 8973279, 8972471, 8971890, 8971674, 8970925, 8970240, 8970214, 8968758, 8968734, 8967550, 8966658, 8966129, 8965830, 8965318, 8964849, 8964559, 8964550, 8964318, 8964109, 8962787, 8962191, 8960801, 8959499, 8957626, 8957504, 8957501, 8957498, 8957266, 8955539, 8954890, 8954573, 8954240, 8953890, 8952878, 8952757, 8952659, 8951348, 8949578, 8949115, 8949114, 8949111, 8949108, 8949104, 8949091, 8949087, 8949081, 8948661, 8948364, 8948307, 8947702, 8947701, 8947520, 8943017, 8943015, 8943014, 8942016, 8940768, 8940767, 8940437, 8940251, 8939991, 8939758, 8938989, 8937401, 8934740, 8932326, 8929641, 8928028, 8926638, 8925779, 8925775, 8925771, 8925661, 8925393, 8924615, 8924020, 8923743, 8923681, 8923680, 8921926, 8920738, 8920736, 8919269, 8919124, 8918666, 8918665, 8918482, 8918466, 8918464, 8917801, 8917228, 8915006, 8914518, 8914517, 8914514, 8914382, 8913986, 8913476, 8913341, 8911490, 8910272, 8907543, 8907472, 8906158, 8906157, 8901964, 8901963, 8901953, 8901951, 8901513, 8900426, 8900419, 8899578, 8898578, 8898119, 8897642, 8896957, 8895785, 8895248, 8893995, 8893994, 8893993, 8890913, 8889853, 8889767, 8889766, 8889217, 8889008, 8888805, 8888003, 8887850, 8887290, 8887247, 8887228, 8886094, 8885174, 8884989, 8884103, 8884102, 8884097, 8883254, 8882291, 8882133, 8882012, 8881830, 8880271, 8878629, 8878353, 8876732, 8876721, 8875438, 8875433, 8875420, 8875405, 8875393, 8875385, 8875365, 8875091, 8874558, 8874030, 8874028, 8873968, 8873366, 8872701, 8872454, 8872238, 8872017, 8871179, 8871176, 8871172, 8871165, 8871161, 8871155, 8870356, 8870024, 8870015, 8870011, 8869831, 8869593, 8868058, 8867971, 8867367, 8867339, 8867338, 8867337, 8867108, 8866736, 8866176, 8866175, 8865914, 8865210, 8864494, 8863554, 8863551, 8863507, 8863282, 8861918, 8860791, 8860300, 8860299, 8859703, 8859599, 8858858, 8858695, 8858297, 8857984, 8857012, 8856299, 8855448, 8855218, 8854999, 8854826, 8854825, 8854144, 8852664, 8852661, 8852608, 8852103, 8852102, 8852101, 8850344, 8849652, 8849651, 8849091, 8849049, 8849018, 8847965, 8847964, 8847962, 8847008, 8846624, 8846523, 8846521, 8846518, 8846516, 8846428, 8846322, 8845351, 8845349, 8844326, 8844081, 8844044, 8844041, 8842851, 8842536, 8841912, 8839172, 8837671, 8837653, 8835985, 8835760, 8835003, 8834406, 8833329, 8832690, 8830499, 8828942, 8828630, 8828607, 8828582, 8828337, 8828140, 8828138, 8827654, 8827651, 8826826, 8826825, 8824137, 8824082, 8824077, 8821884, 8820846, 8820600, 8819953, 8819913, 8816024, 8815965, 8815892, 8815829, 8814848, 8814846, 8812989, 8812415, 8812226, 8812026, 8810304, 8810225, 8809360, 8808076, 8806772, 8805557, 8803437, 8802556, 8802258, 8801099, 8801077, 8800520, 8800516, 8800506, 8800483, 8799884, 8799463, 8799446, 8797802, 8796676, 8795021, 8794748, 8794326, 8793567, 8793420, 8793419, 8792669, 8792131, 8792047, 8792044, 8791358, 8791352, 8790874, 8788526, 8787951, 8786238, 8782858, 8782847, 8782846, 8782830, 8782688, 8782339, 8782338, 8781163, 8780535, 8780035, 8780027, 8779703, 8779702, 8779608, 8779222, 8779150, 8778161, 8778016, 8777439, 8777343, 8775502, 8773572, 8773473, 8772541, 8771670, 8770309, 8769692, 8769413, 8769220, 8766803, 8765682, 8765256, 8765255, 8764483, 8763835, 8763786, 8760989, 8759787, 8759577, 8759539, 8759353, 8758566, 8758218, 8757876, 8757534, 8756550, 8754663, 8754264, 8753539, 8752375, 8752374, 8752364, 8752261, 8752066, 8751824, 8750170, 8749682, 8749463, 8747805, 8747436, 8747414, 8746592, 8746357, 8746096, 8745881, 8745851, 8745533, 8745530, 8744752, 8743979, 8743396, 8742747, 8742032, 8740349, 8738635, 8736483, 8736050, 8735768, 8734952, 8734484, 8732968, 8732967, 8731802, 8731801, 8729734, 8729230, 8729228, 8727335, 8727331, 8727271, 8727102, 8726850, 8726827, 8726731, 8725482, 8725350, 8725298, 8724525, 8724512, 8724511, 8724450, 8724166, 8723773, 8722652, 8721416, 8721415, 8720871, 8720379, 8719382, 8719199, 8718855, 8718274, 8717936, 8717935, 8715282, 8715279, 8715271, 8714343, 8714342, 8714341, 8714288, 8714196, 8713950, 8713408, 8713159, 8713158, 8710701, 8708972, 8708902, 8708901, 8708900, 8705743, 8705085, 8704402, 8703840, 8697587, 8696460, 8696288, 8695950, 8694880, 8692907, 8690879, 8688666, 8686956, 8684848, 8684731, 8683789, 8683736, 8682612, 8682310, 8682309, 8682183, 8679248, 8679245, 8679243, 8679237, 8679236, 8679233, 8674358, 8673321, 8672472, 8672021, 8670635, 8666745, 8661113, 8659671, 8658773, 8658199, 8657952, 8654231, 8652435, 8651566, 8650678, 8650554, 8646813, 8646627, 8645832, 8644394, 8644252, 8644147, 8642060, 8642059, 8638630, 8638627, 8638624, 8638620, 8636560, 8633789, 8633430, 8632759, 8632389, 8631727, 8630195, 8629265, 8628973, 8628851, 8627598, 8625705, 8625704, 8624858, 8619798, 8619789, 8619317, 8619039, 8618488, 8618487, 8616904, 8615352, 8611288, 8607473, 8604302, 8603591, 8602210, 8601212, 8599425, 8596708, 8595960, 8595957, 8595211, 8594397, 8592647, 8592271, 8590415, 8590052, 8589948, 8589103, 8586153, 8585771, 8585432, 8584424, 8582982, 8581489, 8581488, 8581487, 8574218, 8572615, 8572552, 8571302, 8571075, 8570767, 8570001, 8569582, 8567287, 8566230, 8563543, 8562817, 8561404, 8560530, 8559845, 8558331, 8557182, 8556834, 8555852, 8552696, 8552280, 8551153, 8549910, 8549780, 8547574, 8547213, 8544429, 8544428, 8543783, 8542851, 8542422, 8542102, 8538998, 8538581, 8538580, 8535669, 8533264, 8533253, 8532546, 8532543, 8531808, 8530324, 8529117, 8527443, 8526610, 8524966, 8523096, 8515335, 8513935, 8502680, 8501742, 8501365, 8498327, 8495123, 8494726, 8488530, 8472686, 8458646, 8411733, 8411732, 8411731, 8393920, 8393918, 8379686, 8379255, 8379182, 8360243, 8355339, 8345225, 8332947, 8306065, 8299624, 8286387, 8266507, 8264188, 8260167, 8241697, 8218632, 8209490, 8203741, 8203740, 8203739, 8199273, 8198068, 8181585, 8166625, 8134768, 8123657, 8118255, 8099100, 8097565, 8090271, 8089684, 7750109, 7748348)
Run Time: 0.036432
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1231 | |
PRIMARY | thread | eq_ref | PRIMARY | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
PRIMARY | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
PRIMARY | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
PRIMARY | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
MATERIALIZED | <derived3> | ALL | | | | | 1231 | |
DERIVED | | | | | | | | No tables used |
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",9619292],["thread",9558756],["thread",9558567],["thread",9558566],["thread",9557974],["thread",9557807],["thread",9557802],["thread",9522475],["thread",9518679],["thread",9518659],["thread",9517809],["thread",9517269],["thread",9516296],["thread",9516237],["thread",9516230],["thread",9514878],["thread",9503024],["thread",9475581],["thread",9454771],["thread",9430597],["thread",9406294],["thread",9402569],["thread",9383021],["thread",9376376],["thread",9372232],["thread",9344824],["thread",9324394],["thread",9321097],["thread",9318479],["thread",9306723],["thread",9304396],["thread",9291348],["thread",9290253],["thread",9279218],["thread",9270406],["thread",9254561],["thread",9246744],["thread",9223547],["thread",9222217],["thread",9220929],["thread",9189310],["thread",9173185],["thread",9163481],["thread",9160886],["thread",9105597],["thread",9104546],["thread",9099424],["thread",9098619],["thread",9095122],["thread",9090141],["thread",9087768],["thread",9087508],["thread",9085889],["thread",9084941],["thread",9064438],["thread",9050019],["thread",9046855],["thread",9041356],["thread",9041324],["thread",9039454],["thread",9036870],["thread",9033840],["thread",9026650],["thread",9022584],["thread",9014409],["thread",9014373],["thread",9011199],["thread",9007292],["thread",9005472],["thread",9003471],["thread",9000989],["thread",9000972],["thread",8999563],["thread",8999231],["thread",8998054],["thread",8994479],["thread",8984067],["thread",8981993],["thread",8981704],["thread",8981159],["thread",8980204],["thread",8979498],["thread",8974140],["thread",8973279],["thread",8970925],["thread",8968734],["thread",8967550],["thread",8965830],["thread",8964559],["thread",8964550],["thread",8962787],["thread",8962191],["thread",8957504],["thread",8957501],["thread",8955539],["thread",8954573],["thread",8954240],["thread",8953890],["thread",8952659],["thread",8949578],["thread",8948364],["thread",8947702],["thread",8947520],["thread",8943017],["thread",8942016],["thread",8940768],["thread",8939991],["thread",8938989],["thread",8937401],["thread",8934740],["thread",8929641],["thread",8928028],["thread",8924020],["thread",8923681],["thread",8920738],["thread",8919124],["thread",8917228],["thread",8915006],["thread",8911490],["thread",8906158],["thread",8901951],["thread",8900426],["thread",8895248],["thread",8893995],["thread",8889767],["thread",8889008],["thread",8888003],["thread",8887850],["thread",8887290],["thread",8887247],["thread",8887228],["thread",8885174],["thread",8884989],["thread",8884103],["thread",8883254],["thread",8880271],["thread",8878353],["thread",8876721],["thread",8875091],["thread",8874030],["thread",8873968],["thread",8867367],["thread",8867339],["thread",8866176],["thread",8865210],["thread",8863551],["thread",8860791],["thread",8860300],["thread",8857012],["thread",8855448],["thread",8854999],["thread",8852664],["thread",8852608],["thread",8849652],["thread",8846624],["thread",8846428],["thread",8842851],["thread",8835760],["thread",8835003],["thread",8833329],["thread",8828630],["thread",8828582],["thread",8820846],["thread",8814848],["thread",8812989],["thread",8808076],["thread",8806772],["thread",8803437],["thread",8800520],["thread",8800506],["thread",8799884],["thread",8797802],["thread",8796676],["thread",8795021],["thread",8794326],["thread",8793420],["thread",8782858],["thread",8782847],["thread",8782830],["thread",8782688],["thread",8782339],["thread",8779703],["thread",8777439],["thread",8772541],["thread",8770309],["thread",8763835],["thread",8763786],["thread",8759577],["thread",8759353],["thread",8757876],["thread",8754264],["thread",8752364],["thread",8752066],["thread",8751824],["thread",8750170],["thread",8747436],["thread",8745533],["thread",8738635],["thread",8732968],["thread",8729230],["thread",8725298],["thread",8724512],["thread",8724450],["thread",8723773],["thread",8715282],["thread",8713408],["thread",8713159],["thread",8710701],["thread",8705743],["thread",8705085],["thread",8704402],["thread",8697587],["thread",8696460],["thread",8696288],["thread",8694880],["thread",8684731],["thread",8683736],["thread",8682310],["thread",8679248],["thread",8672021],["thread",8670635],["thread",8666745],["thread",8659671],["thread",8658773],["thread",8658199],["thread",8657952],["thread",8654231],["thread",8651566],["thread",8650554],["thread",8645832],["thread",8644252],["thread",8638630],["thread",8632389],["thread",8631727],["thread",8629265],["thread",8628973],["thread",8628851],["thread",8625705],["thread",8624858],["thread",8619798],["thread",8619789],["thread",8619317],["thread",8615352],["thread",8611288],["thread",8601212],["thread",8599425],["thread",8596708],["thread",8595960],["thread",8595211],["thread",8592647],["thread",8592271],["thread",8590052],["thread",8589948],["thread",8585771],["thread",8574218],["thread",8571302],["thread",8567287],["thread",8566230],["thread",8562817],["thread",8561404],["thread",8558331],["thread",8557182],["thread",8555852],["thread",8552696],["thread",8552280],["thread",8551153],["thread",8542851],["thread",8542102],["thread",8538998],["thread",8532546],["thread",8530324],["thread",8527443],["thread",8515335],["thread",8502680],["thread",8501742],["thread",8495123],["thread",8488530],["thread",8472686],["thread",8411733],["thread",8411732],["thread",8411731],["thread",8393920],["thread",8379686],["thread",8379182],["thread",8360243],["thread",8355339],["thread",8345225],["thread",8306065],["thread",8299624],["thread",8198068],["thread",8134768],["thread",8123657],["thread",8118255],["thread",8099100],["thread",8097565],["thread",8090271],["thread",8089684],["thread",7750109],["thread",7748348]], 299, tinhte_xentag_tag, , {"tags":["moto"]}, date, 0, , [], 0, 1653792161, b51ca0f82b9e72a2dfe0f57b5c8e7a88
Run Time: 0.000764