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 (9671191, 9668732, 9656794, 9656793, 9655466, 9652141, 9646852, 9646851, 9646676, 9642200, 9639349, 9639338, 9632470, 9626624, 9618759, 9599789, 9599380, 9597732, 9596247, 9595934, 9584402, 9583014, 9577984, 9573101, 9571422, 9569936, 9566992, 9563815, 9563014, 9560754, 9560707, 9558773, 9555747, 9554673, 9554608, 9553839, 9553838, 9553837, 9553530, 9552678, 9548862, 9547521, 9547086, 9546208, 9544567, 9539963, 9539109, 9539107, 9538320, 9536914, 9536205, 9535758, 9535391, 9534622, 9533203, 9532864, 9532676, 9532344, 9531806, 9531586, 9530211, 9527245, 9522694, 9522612, 9522474, 9522371, 9519375, 9516474, 9516301, 9516284, 9512409, 9510326, 9506499, 9500668, 9499633, 9496369, 9496124, 9495699, 9492308, 9491076, 9488786, 9487582, 9486866, 9485836, 9484336, 9482882, 9481304, 9480748, 9480314, 9477072, 9477065, 9476599, 9475201, 9473674, 9471204, 9470239, 9469398, 9466826, 9464877, 9464364, 9457517, 9442025, 9441782, 9440796, 9438763, 9438349, 9436981, 9432290, 9432107, 9429798, 9429685, 9427764, 9427320, 9425630, 9422460, 9422457, 9418481, 9410568, 9409505, 9406391, 9405326, 9399043, 9398537, 9398532, 9396778, 9396470, 9393471, 9393204, 9389734, 9389241, 9389053, 9388686, 9388583, 9385420, 9384768, 9383504, 9381657, 9380773, 9380610, 9379820, 9378929, 9377948, 9376969, 9376715, 9376564, 9375751, 9374596, 9374594, 9373768, 9373330, 9372605, 9369065, 9367467, 9366963, 9366923, 9364266, 9364265, 9364044, 9363360, 9362325, 9361202, 9360328, 9359349, 9359347, 9359149, 9357248, 9356747, 9354769, 9354561, 9354369, 9350929, 9350914, 9350912, 9346444, 9345204, 9343827, 9341296, 9339900, 9339455, 9339231, 9337839, 9337460, 9334228, 9331877, 9325368, 9325366, 9323315, 9321408, 9317667, 9315249, 9313665, 9313663, 9309310, 9307367, 9306264, 9305960, 9298022, 9297010, 9296884, 9296382, 9296023, 9293021, 9291451, 9288231, 9288114, 9288021, 9286521, 9285990, 9282516, 9280041, 9279856, 9279855, 9279819, 9279334, 9274175, 9272392, 9265461, 9264999, 9262557, 9261815, 9261810, 9261542, 9257482, 9254552, 9253250, 9252378, 9244951, 9244866, 9244865, 9244312, 9243862, 9243824, 9243606, 9241295, 9238838, 9236918, 9236204, 9232416, 9229928, 9229438, 9224325, 9223145, 9223144, 9220940, 9220107, 9218051, 9217024, 9214743, 9214306, 9209714, 9206796, 9203306, 9200575, 9197410, 9193829, 9193762, 9193173, 9191915, 9178080, 9177742, 9174134, 9173517, 9171761, 9168598, 9167031, 9164455, 9160294, 9159769, 9153621, 9152385, 9151353, 9150234, 9149009, 9149008, 9149005, 9149004, 9148357, 9148213, 9147956, 9147297, 9147290, 9147289, 9147288, 9136943, 9136597, 9127592, 9126567, 9126566, 9121837, 9117035, 9115200, 9115199, 9107282, 9107133, 9107132, 9106232, 9105621, 9103326, 9098093, 9097410, 9097102, 9095472, 9092696, 9091076, 9088168, 9082641, 9082640, 9080066, 9074872, 9073327, 9073051, 9065571, 9056359, 9051468, 9046831, 9046079, 9037505, 9037073, 9029423, 9029422, 9028492, 9015902, 9015901, 9014237, 9012892, 9012889, 9012664, 9010363, 9008720, 9004712, 9002964, 8998021, 8998020, 8988565, 8988303, 8988273, 8986695, 8986308, 8985636, 8985630, 8981677, 8981676, 8981674, 8979799, 8975197, 8971860, 8965711, 8962367, 8952188, 8950122, 8949632, 8948793, 8948459, 8945780, 8942853, 8940506, 8939922, 8938036, 8937853, 8937658, 8936299, 8934613, 8934612, 8934611, 8934609, 8934608, 8934606, 8934604, 8934503, 8934502, 8934501, 8934498, 8933995, 8933991, 8927082, 8922919, 8918822, 8915014, 8911023, 8908939, 8907459, 8900019, 8895119, 8891626, 8889147, 8889029, 8888923, 8888086, 8887230, 8887153, 8884261, 8884260, 8884259, 8884258, 8884257, 8883600, 8883591, 8882953, 8879116, 8877704, 8877702, 8876807, 8875820, 8873564, 8873151, 8873150, 8867847, 8866943, 8866290, 8865475, 8864818, 8863052, 8862034, 8860787, 8860722, 8858213, 8853344, 8852614, 8852572, 8852002, 8850848, 8850354, 8849853, 8848175, 8848025, 8847251, 8845047, 8844943, 8844180, 8842517, 8842516, 8839872, 8839780, 8838705, 8837669, 8837668, 8835875, 8835238, 8833564, 8831703, 8831700, 8830843, 8829557, 8828626, 8826351, 8825832, 8825417, 8823749, 8822698, 8822695, 8822693, 8822687, 8821931, 8820902, 8820645, 8820644, 8820560, 8817709, 8815299, 8815216, 8813432, 8812323, 8811624, 8811106, 8811103, 8811101, 8811098, 8811097, 8810785, 8810093, 8807264, 8806013, 8804986, 8802685, 8800629, 8800375, 8799890, 8799073, 8798567, 8796807, 8796635, 8796605, 8794266, 8793088, 8791623, 8791575, 8791573, 8790525, 8790240, 8790239, 8790085, 8789654, 8787505, 8785166, 8785165, 8784914, 8784906, 8784468, 8782953, 8782949, 8782552, 8782505, 8782314, 8780691, 8780686, 8779324, 8779323, 8778855, 8778854, 8778330, 8776957, 8776863, 8775846, 8775791, 8775446, 8775445, 8774038, 8773946, 8773902, 8773819, 8772937, 8771760, 8770701, 8770673, 8768658, 8767405, 8767396, 8766930, 8766349, 8765748, 8765727, 8765606, 8764478, 8763348, 8763329, 8760813, 8760811, 8759876, 8759749, 8759091, 8759089, 8758804, 8757382, 8757365, 8757285, 8757120, 8757114, 8756391, 8756177, 8756071, 8756070, 8756027, 8755221, 8755047, 8754942, 8753700, 8753046, 8752048, 8751900, 8751898, 8751605, 8750925, 8750823, 8749951, 8749709, 8748970, 8748964, 8748869, 8747875, 8747851, 8746767, 8745995, 8745879, 8745128, 8744643, 8744552, 8744544, 8744413, 8743663, 8742148, 8742140, 8741335, 8741185, 8740947, 8740124, 8739363, 8739344, 8738219, 8738118, 8738076, 8737898, 8737776, 8737746, 8737328, 8737090, 8737068, 8736054, 8735593, 8735584, 8734909, 8734844, 8734841, 8733985, 8733403, 8733394, 8732439, 8732438, 8731920, 8731917, 8730885, 8730884, 8730756, 8730755, 8730559, 8730139, 8728204, 8727483, 8726367, 8725673, 8725615, 8725522, 8723651, 8722756, 8721899, 8721784, 8721675, 8721420, 8717240, 8716051, 8716050, 8713738, 8713395, 8712580, 8712290, 8711589, 8711428, 8710539, 8710312, 8710311, 8709893, 8708165, 8708144, 8708059, 8707138, 8706839, 8706425, 8706417, 8706166, 8705586, 8705582, 8704722, 8703956, 8703953, 8702843, 8701178, 8698002, 8697391, 8697293, 8697099, 8696232, 8695993, 8695963, 8693146, 8693143, 8691661, 8690836, 8689590, 8688678, 8687241, 8687107, 8686322, 8686280, 8686279, 8685917, 8684255, 8680943, 8680604, 8680559, 8680465, 8680334, 8680219, 8680063, 8676896, 8676411, 8676400, 8675361, 8674870, 8674828, 8673348, 8672189, 8669725, 8669723, 8669467, 8669081, 8668793, 8668027, 8667711, 8667454, 8666456, 8666415, 8666269, 8666264, 8664295, 8663548, 8663046, 8662996, 8660521, 8658666, 8658296, 8657945, 8657566, 8655299, 8654567, 8654417, 8650918, 8648388, 8641302, 8639573, 8636183, 8635956, 8635247, 8633743, 8633705, 8633380, 8632872, 8629176, 8627274, 8626867, 8626441, 8624669, 8622741, 8621677, 8620815, 8620360, 8618604, 8617294, 8616550, 8615666, 8613927, 8612253, 8611656, 8610363, 8610361, 8610360, 8606852, 8605264, 8601049, 8599546, 8598989, 8597823, 8597536, 8597214, 8597063, 8595728, 8593947, 8593711, 8591944, 8591790, 8586761, 8584305, 8584079, 8579909, 8577546, 8576372, 8574811, 8573622, 8573606, 8570623, 8570002, 8569938, 8569734, 8567015, 8566727, 8564386, 8561286, 8559661, 8559081, 8558861, 8557100, 8555511, 8555282, 8555114, 8552899, 8551679, 8551463, 8551213, 8546722, 8543721, 8541305, 8538020, 8537519, 8536733, 8536136, 8533725, 8531844, 8531279, 8530204, 8528204, 8527217, 8526098, 8524992, 8524145, 8524142, 8524141, 8524140, 8524139, 8509137, 8507827, 8492009, 8489007, 8488388, 8480704, 8476831, 8470560, 8462962, 8461894, 8459165, 8456784, 8454967, 8449592, 8446965, 8444602, 8444329, 8444085, 8441462, 8432427, 8431415, 8430182, 8429025, 8422645, 8412471, 8407763, 8400182, 8396715, 8385653, 8380554, 8376762, 8373424, 8367641, 8363706, 8359877, 8355611, 8345845, 8341162, 8339112, 8337684, 8335428, 8325321, 8322234, 8317901, 8317893, 8317727, 8317234, 8315405, 8304691, 8301960, 8297826, 8294771, 8287968, 8286759, 8286758, 8286031, 8285222, 8276414, 8275900, 8267033, 8264875, 8262351, 8261083, 8259158, 8259122, 8258409, 8257615, 8256596, 8256060, 8254257, 8248698, 8246851, 8246577, 8240549, 8239960, 8237010, 8236204, 8232772, 8232369, 8229603, 8228787, 8228511, 8228476, 8228111, 8227414, 8226685, 8224878, 8224592, 8223420, 8216713, 8210253, 8208452, 8207784, 8204424, 8203176, 8203175, 8203174, 8184948, 8173792, 8112866, 8108829, 8093819, 8030513, 8000081)
Run Time: 0.023197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 910 | 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",9668732],["thread",9656794],["thread",9626624],["thread",9599789],["thread",9599380],["thread",9584402],["thread",9573101],["thread",9554673],["thread",9554608],["thread",9553839],["thread",9546208],["thread",9538320],["thread",9536205],["thread",9510326],["thread",9500668],["thread",9485836],["thread",9440796],["thread",9432290],["thread",9429798],["thread",9396778],["thread",9380610],["thread",9379820],["thread",9374594],["thread",9366963],["thread",9357248],["thread",9354769],["thread",9350914],["thread",9339900],["thread",9321408],["thread",9317667],["thread",9309310],["thread",9307367],["thread",9297010],["thread",9296884],["thread",9288021],["thread",9264999],["thread",9244312],["thread",9243862],["thread",9238838],["thread",9223145],["thread",9200575],["thread",9178080],["thread",9177742],["thread",9153621],["thread",9147956],["thread",9117035],["thread",9098093],["thread",9097410],["thread",9097102],["thread",9092696],["thread",9073327],["thread",9056359],["thread",9046079],["thread",9029423],["thread",9028492],["thread",9015902],["thread",9012664],["thread",9010363],["thread",8988303],["thread",8971860],["thread",8962367],["thread",8949632],["thread",8942853],["thread",8937658],["thread",8911023],["thread",8889029],["thread",8888923],["thread",8884261],["thread",8883600],["thread",8883591],["thread",8882953],["thread",8877704],["thread",8860787],["thread",8860722],["thread",8858213],["thread",8848175],["thread",8845047],["thread",8839780],["thread",8838705],["thread",8835238],["thread",8831703],["thread",8822698],["thread",8820645],["thread",8799890],["thread",8799073],["thread",8784468],["thread",8773946],["thread",8756071],["thread",8752048],["thread",8746767],["thread",8732439],["thread",8730559],["thread",8722756],["thread",8721784],["thread",8712290],["thread",8710539],["thread",8686280],["thread",8680604],["thread",8680559],["thread",8680063],["thread",8675361],["thread",8667454],["thread",8666456],["thread",8666269],["thread",8664295],["thread",8660521],["thread",8658296],["thread",8657566],["thread",8655299],["thread",8639573],["thread",8636183],["thread",8635956],["thread",8629176],["thread",8627274],["thread",8626867],["thread",8626441],["thread",8621677],["thread",8620815],["thread",8617294],["thread",8616550],["thread",8613927],["thread",8612253],["thread",8606852],["thread",8599546],["thread",8598989],["thread",8597536],["thread",8597214],["thread",8597063],["thread",8591944],["thread",8591790],["thread",8584305],["thread",8584079],["thread",8576372],["thread",8573622],["thread",8570623],["thread",8570002],["thread",8569734],["thread",8567015],["thread",8564386],["thread",8555282],["thread",8546722],["thread",8543721],["thread",8541305],["thread",8537519],["thread",8536136],["thread",8533725],["thread",8531844],["thread",8530204],["thread",8527217],["thread",8524145],["thread",8524142],["thread",8507827],["thread",8492009],["thread",8489007],["thread",8488388],["thread",8476831],["thread",8470560],["thread",8462962],["thread",8461894],["thread",8459165],["thread",8456784],["thread",8454967],["thread",8449592],["thread",8446965],["thread",8444602],["thread",8444329],["thread",8441462],["thread",8432427],["thread",8431415],["thread",8429025],["thread",8422645],["thread",8412471],["thread",8407763],["thread",8400182],["thread",8385653],["thread",8380554],["thread",8376762],["thread",8367641],["thread",8363706],["thread",8359877],["thread",8355611],["thread",8345845],["thread",8341162],["thread",8339112],["thread",8337684],["thread",8335428],["thread",8325321],["thread",8322234],["thread",8317901],["thread",8317893],["thread",8317727],["thread",8317234],["thread",8304691],["thread",8297826],["thread",8294771],["thread",8286759],["thread",8286031],["thread",8285222],["thread",8276414],["thread",8267033],["thread",8264875],["thread",8261083],["thread",8259158],["thread",8259122],["thread",8258409],["thread",8257615],["thread",8256596],["thread",8256060],["thread",8254257],["thread",8248698],["thread",8246851],["thread",8246577],["thread",8240549],["thread",8237010],["thread",8236204],["thread",8232772],["thread",8232369],["thread",8229603],["thread",8228511],["thread",8228476],["thread",8228111],["thread",8227414],["thread",8226685],["thread",8224878],["thread",8223420],["thread",8216713],["thread",8210253],["thread",8208452],["thread",8207784],["thread",8204424],["thread",8093819],["thread",8030513],["thread",8000081]], 233, tinhte_xentag_tag, , {"tags":["laptop toshiba"]}, date, 0, , [], 0, 1653252767, 74cd880cd6ae9b080ce0efdffb5a6aa0
Run Time: 0.000609