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 (8693222, 8691830, 8691584, 8691239, 8690858, 8690808, 8690519, 8688876, 8688750, 8688530, 8687993, 8687191, 8687051, 8686787, 8686687, 8685164, 8680285, 8679226, 8679220, 8679217, 8675685, 8673178, 8672994, 8672330, 8670074, 8669255, 8667719, 8667294, 8666478, 8662452, 8662170, 8658612, 8657692, 8657516, 8654532, 8652968, 8651845, 8651723, 8651712, 8650896, 8649747, 8645698, 8645492, 8643061, 8640920, 8639974, 8638658, 8638566, 8638062, 8634625, 8633886, 8632798, 8632661, 8632614, 8631510, 8631509, 8631348, 8630957, 8630432, 8628496, 8625375, 8623678, 8622764, 8621745, 8621652, 8621638, 8621440, 8620986, 8620469, 8619784, 8619298, 8618723, 8617836, 8617297, 8617226, 8616527, 8616109, 8613590, 8612966, 8612834, 8612761, 8609291, 8609144, 8607649, 8607281, 8605750, 8605554, 8605523, 8604244, 8604130, 8602648, 8600162, 8599911, 8598609, 8598608, 8598581, 8598571, 8597460, 8595238, 8594328, 8592221, 8590716, 8590418, 8589131, 8585475, 8585272, 8584403, 8583749, 8582801, 8582763, 8581789, 8581473, 8580855, 8580089, 8578228, 8577017, 8576905, 8575252, 8573803, 8573522, 8573344, 8572568, 8570602, 8568701, 8568470, 8567730, 8567438, 8566613, 8566605, 8566565, 8565391, 8564473, 8564177, 8563944, 8563712, 8563656, 8562505, 8562309, 8560235, 8560094, 8558150, 8556920, 8551675, 8549563, 8549196, 8549143, 8548117, 8546686, 8546520, 8546022, 8544846, 8544218, 8543835, 8541899, 8541050, 8540308, 8537882, 8537332, 8536257, 8536228, 8534805, 8533772, 8532705, 8531681, 8530616, 8530534, 8529988, 8527772, 8527190, 8525219, 8523239, 8522912, 8522498, 8520753, 8520620, 8520250, 8519659, 8517547, 8517449, 8516894, 8516507, 8515244, 8514116, 8513852, 8510716, 8509719, 8509582, 8507964, 8506128, 8504946, 8503380, 8501503, 8496857, 8496810, 8494284, 8491943, 8491934, 8491654, 8490064, 8489637, 8489163, 8488705, 8488521, 8487630, 8487246, 8486237, 8485972, 8485902, 8485841, 8483710, 8483059, 8481377, 8479761, 8479469, 8479437, 8478836, 8477292, 8477251, 8472602, 8472049, 8471439, 8471433, 8470956, 8469770, 8468732, 8468251, 8466977, 8466974, 8465764, 8464290, 8463871, 8463841, 8463190, 8462555, 8462100, 8461153, 8460834, 8459854, 8459303, 8458569, 8458443, 8458440, 8458439, 8458194, 8457638, 8456320, 8456088, 8454586, 8454476, 8453172, 8451989, 8451711, 8446925, 8446658, 8443248, 8442700, 8442083, 8439841, 8438851, 8438747, 8437531, 8436700, 8436568, 8435130, 8435065, 8434287, 8433755, 8429465, 8428688, 8428228, 8425572, 8423153, 8420041, 8419483, 8418176, 8418071, 8417824, 8413671, 8412473, 8409401, 8407912, 8407692, 8407578, 8405963, 8405444, 8405302, 8403686, 8402616, 8401629, 8400992, 8400780, 8399366, 8399180, 8399179, 8397507, 8396145, 8394709, 8392396, 8391792, 8391728, 8391608, 8387449, 8385266, 8384302, 8383905, 8383482, 8380358, 8376635, 8372196, 8367429, 8366967, 8365643, 8363435, 8359393, 8356472, 8353050, 8350026, 8348714, 8348335, 8347889, 8347509, 8346698, 8345088, 8344704, 8344577, 8344481, 8344105, 8343206, 8341413, 8340029, 8338181, 8337285, 8335329, 8334416, 8333987, 8333291, 8332562, 8332297, 8330625, 8329475, 8329280, 8328911, 8328740, 8328597, 8327954, 8326961, 8325395, 8324341, 8323244, 8323126, 8321071, 8320390, 8319713, 8319670, 8318371, 8318346, 8318265, 8318144, 8315803, 8314508, 8311620, 8310685, 8310124, 8310116, 8310109, 8309599, 8309476, 8309194, 8308916, 8308085, 8307726, 8305581, 8304828, 8304433, 8301113, 8301110, 8300188, 8299873, 8298414, 8297722, 8297509, 8295934, 8295038, 8294446, 8293861, 8292742, 8292620, 8292352, 8291118, 8291039, 8290070, 8290003, 8289422, 8289254, 8288563, 8283955, 8283954, 8283952, 8283951, 8282410, 8281604, 8280839, 8280716, 8280420, 8280221, 8280170, 8279331, 8277993, 8277992, 8277991, 8277990, 8277968, 8276184, 8275673, 8275344, 8275212, 8273772, 8273432, 8273422, 8272165, 8272031, 8271821, 8271747, 8271744, 8271442, 8271270, 8271259, 8271257, 8270022, 8268823, 8268625, 8268026, 8266949, 8266769, 8266711, 8266710, 8266709, 8265500, 8265427, 8263078, 8263023, 8262847, 8262196, 8261998, 8261252, 8261214, 8261077, 8260603, 8259747, 8258699, 8257856, 8257325, 8257153, 8256968, 8256967, 8256894, 8256471, 8256269, 8255783, 8255672, 8255549, 8255029, 8254343, 8254164, 8254146, 8253523, 8252481, 8251886, 8251638, 8251294, 8251242, 8248207, 8248139, 8246920, 8246534, 8246482, 8246417, 8246283, 8246041, 8245605, 8244969, 8244200, 8243756, 8243744, 8242205, 8241200, 8240575, 8240534, 8240460, 8240335, 8239988, 8239938, 8238914, 8237314, 8236016, 8235278, 8235062, 8234999, 8234961, 8234872, 8234841, 8233796, 8233223, 8233216, 8232287, 8232162, 8232160, 8232154, 8232152, 8232151, 8231880, 8231116, 8230830, 8230828, 8230277, 8229978, 8228236, 8227918, 8225564, 8225506, 8225243, 8224596, 8224595, 8223931, 8223605, 8223500, 8223499, 8223497, 8223496, 8223385, 8221934, 8221847, 8221489, 8221397, 8220531, 8220424, 8220279, 8219698, 8219650, 8218575, 8218114, 8217889, 8217669, 8217073, 8216381, 8215434, 8215433, 8215087, 8215061, 8214579, 8213621, 8211945, 8210683, 8208982, 8208132, 8207938, 8207934, 8207517, 8205828, 8205048, 8203904, 8203888, 8203666, 8201460, 8199028, 8198659, 8198658, 8198016, 8197359, 8197358, 8196882, 8196433, 8196094, 8195619, 8195617, 8195616, 8195416, 8194416, 8194006, 8193134, 8192332, 8192331, 8192329, 8192050, 8190093, 8189516, 8189022, 8188471, 8187695, 8187047, 8186640, 8186035, 8185981, 8185660, 8184784, 8184557, 8183526, 8182973, 8182889, 8182402, 8182389, 8182345, 8182338, 8182120, 8181124, 8181122, 8180865, 8180584, 8180449, 8179550, 8179327, 8177002, 8175759, 8173737, 8173581, 8171245, 8171194, 8171193, 8171158, 8169772, 8168858, 8166184, 8165894, 8165581, 8164102, 8164048, 8163959, 8161873, 8161059, 8160894, 8159145, 8158726, 8158397, 8158395, 8158164, 8157645, 8154538, 8114853, 8082325, 8019923, 7891455, 7786816, 7241793, 7116117, 6576262, 707070)
Run Time: 0.030752
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 646 | 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",8693222],["thread",8691830],["thread",8691584],["thread",8691239],["thread",8690519],["thread",8688876],["thread",8688750],["thread",8687993],["thread",8686787],["thread",8686687],["thread",8685164],["thread",8680285],["thread",8675685],["thread",8673178],["thread",8672994],["thread",8672330],["thread",8670074],["thread",8669255],["thread",8667719],["thread",8667294],["thread",8658612],["thread",8657692],["thread",8654532],["thread",8651845],["thread",8651723],["thread",8651712],["thread",8649747],["thread",8645492],["thread",8643061],["thread",8640920],["thread",8639974],["thread",8638566],["thread",8638062],["thread",8632798],["thread",8632614],["thread",8631510],["thread",8631348],["thread",8630957],["thread",8630432],["thread",8628496],["thread",8625375],["thread",8623678],["thread",8622764],["thread",8621652],["thread",8621638],["thread",8620469],["thread",8619784],["thread",8619298],["thread",8617836],["thread",8617297],["thread",8617226],["thread",8616109],["thread",8613590],["thread",8612966],["thread",8612834],["thread",8609291],["thread",8609144],["thread",8607649],["thread",8607281],["thread",8605554],["thread",8605523],["thread",8604130],["thread",8602648],["thread",8600162],["thread",8598581],["thread",8598571],["thread",8595238],["thread",8590716],["thread",8590418],["thread",8585475],["thread",8584403],["thread",8583749],["thread",8582763],["thread",8581473],["thread",8580855],["thread",8580089],["thread",8578228],["thread",8577017],["thread",8575252],["thread",8573522],["thread",8573344],["thread",8572568],["thread",8570602],["thread",8568701],["thread",8568470],["thread",8567438],["thread",8564473],["thread",8564177],["thread",8563944],["thread",8563656],["thread",8562505],["thread",8560094],["thread",8558150],["thread",8556920],["thread",8551675],["thread",8549196],["thread",8549143],["thread",8548117],["thread",8546022],["thread",8544846],["thread",8543835],["thread",8541899],["thread",8537882],["thread",8534805],["thread",8533772],["thread",8532705],["thread",8530616],["thread",8530534],["thread",8529988],["thread",8527772],["thread",8527190],["thread",8525219],["thread",8523239],["thread",8522912],["thread",8522498],["thread",8520753],["thread",8520620],["thread",8520250],["thread",8519659],["thread",8517547],["thread",8517449],["thread",8516507],["thread",8515244],["thread",8514116],["thread",8513852],["thread",8510716],["thread",8509719],["thread",8509582],["thread",8506128],["thread",8504946],["thread",8501503],["thread",8496810],["thread",8494284],["thread",8491943],["thread",8491934],["thread",8491654],["thread",8489637],["thread",8488521],["thread",8487246],["thread",8486237],["thread",8485972],["thread",8485902],["thread",8483710],["thread",8479761],["thread",8479469],["thread",8479437],["thread",8477292],["thread",8477251],["thread",8472602],["thread",8472049],["thread",8471439],["thread",8471433],["thread",8470956],["thread",8469770],["thread",8468732],["thread",8468251],["thread",8465764],["thread",8464290],["thread",8463871],["thread",8463841],["thread",8463190],["thread",8462555],["thread",8462100],["thread",8461153],["thread",8459303],["thread",8458569],["thread",8458443],["thread",8458194],["thread",8457638],["thread",8456320],["thread",8456088],["thread",8454586],["thread",8454476],["thread",8451989],["thread",8451711],["thread",8446925],["thread",8443248],["thread",8442700],["thread",8442083],["thread",8439841],["thread",8438851],["thread",8438747],["thread",8437531],["thread",8436700],["thread",8436568],["thread",8435130],["thread",8435065],["thread",8434287],["thread",8433755],["thread",8429465],["thread",8428688],["thread",8425572],["thread",8423153],["thread",8420041],["thread",8419483],["thread",8418176],["thread",8418071],["thread",8417824],["thread",8413671],["thread",8412473],["thread",8409401],["thread",8407912],["thread",8407692],["thread",8405444],["thread",8403686],["thread",8402616],["thread",8401629],["thread",8400992],["thread",8400780],["thread",8399366],["thread",8399180],["thread",8397507],["thread",8396145],["thread",8394709],["thread",8392396],["thread",8391792],["thread",8391728],["thread",8391608],["thread",8387449],["thread",8385266],["thread",8383905],["thread",8376635],["thread",8372196],["thread",8366967],["thread",8365643],["thread",8363435],["thread",8359393],["thread",8356472],["thread",8353050],["thread",8350026],["thread",8348714],["thread",8348335],["thread",8347889],["thread",8347509],["thread",8346698],["thread",8345088],["thread",8344704],["thread",8344577],["thread",8344481],["thread",8344105],["thread",8343206],["thread",8341413],["thread",8340029],["thread",8338181],["thread",8337285],["thread",8334416],["thread",8333987],["thread",8333291],["thread",8332562],["thread",8332297],["thread",8329475],["thread",8329280],["thread",8328911],["thread",8328740],["thread",8328597],["thread",8327954],["thread",8326961],["thread",8325395],["thread",8323244],["thread",8323126],["thread",8321071],["thread",8320390],["thread",8319713],["thread",8319670],["thread",8318371],["thread",8318346],["thread",8318265],["thread",8318144],["thread",8315803],["thread",8314508],["thread",8311620],["thread",8310685],["thread",8310124],["thread",8310116],["thread",8310109],["thread",8309599],["thread",8309476],["thread",8309194],["thread",8308085],["thread",8307726],["thread",8305581],["thread",8304828],["thread",8301113],["thread",8301110],["thread",8300188],["thread",8299873],["thread",8298414],["thread",8297722],["thread",8297509],["thread",8295934],["thread",8295038],["thread",8294446],["thread",8293861],["thread",8292742],["thread",8292620],["thread",8292352],["thread",8291118],["thread",8291039],["thread",8290070],["thread",8290003],["thread",8289422],["thread",8289254],["thread",8283955],["thread",8282410],["thread",8281604],["thread",8280839],["thread",8280716],["thread",8280170],["thread",8279331],["thread",8277993],["thread",8276184],["thread",8275673],["thread",8275344],["thread",8275212],["thread",8273772],["thread",8273432],["thread",8273422],["thread",8272165],["thread",8272031],["thread",8271821],["thread",8271442],["thread",8271270],["thread",8271259],["thread",8270022],["thread",8268823],["thread",8268625],["thread",8268026],["thread",8266769],["thread",8266711],["thread",8265500],["thread",8265427],["thread",8263078],["thread",8263023],["thread",8262847],["thread",8262196],["thread",8261998],["thread",8261252],["thread",8261214],["thread",8261077],["thread",8260603],["thread",8259747],["thread",8258699],["thread",8257856],["thread",8257325],["thread",8257153],["thread",8256968],["thread",8256894],["thread",8256471],["thread",8256269],["thread",8255783],["thread",8255672],["thread",8255029],["thread",8254343],["thread",8254164],["thread",8254146],["thread",8253523],["thread",8252481],["thread",8251886],["thread",8251294],["thread",8251242],["thread",8248207],["thread",8248139],["thread",8246920],["thread",8246482],["thread",8246417],["thread",8246283],["thread",8246041],["thread",8245605],["thread",8244969],["thread",8244200],["thread",8243756],["thread",8243744],["thread",8242205],["thread",8241200],["thread",8240575],["thread",8240534],["thread",8240460],["thread",8240335],["thread",8239988],["thread",8239938],["thread",8238914],["thread",8237314],["thread",8236016],["thread",8235278],["thread",8234999],["thread",8234961],["thread",8234872],["thread",8234841],["thread",8233796],["thread",8233223],["thread",8233216],["thread",8232287],["thread",8231880],["thread",8231116],["thread",8230830],["thread",8230277],["thread",8229978],["thread",8228236],["thread",8227918],["thread",8225564],["thread",8225506],["thread",8225243],["thread",8224596],["thread",8223931],["thread",8223605],["thread",8223500],["thread",8223385],["thread",8221934],["thread",8221847],["thread",8221489],["thread",8221397],["thread",8220531],["thread",8220279],["thread",8219650],["thread",8218575],["thread",8218114],["thread",8217669],["thread",8217073],["thread",8216381],["thread",8215434],["thread",8215087],["thread",8215061],["thread",8214579],["thread",8213621],["thread",8211945],["thread",8210683],["thread",8208982],["thread",8208132],["thread",8207938],["thread",8207517],["thread",8205828],["thread",8205048],["thread",8203904],["thread",8203888],["thread",8203666],["thread",8201460],["thread",8199028],["thread",8198659],["thread",8198016],["thread",8196882],["thread",8196433],["thread",8195619],["thread",8195416],["thread",8193134],["thread",8192332],["thread",8192050],["thread",8190093],["thread",8189516],["thread",8188471],["thread",8187695],["thread",8187047],["thread",8186640],["thread",8186035],["thread",8185981],["thread",8185660],["thread",8184557],["thread",8183526],["thread",8182973],["thread",8182889],["thread",8182402],["thread",8182389],["thread",8182338],["thread",8181124],["thread",8180865],["thread",8180584],["thread",8180449],["thread",8179550],["thread",8179327],["thread",8177002],["thread",8175759],["thread",8173737],["thread",8171245],["thread",8171194],["thread",8171158],["thread",8169772],["thread",8168858],["thread",8166184],["thread",8165581],["thread",8164102],["thread",8164048],["thread",8163959],["thread",8161873],["thread",8161059],["thread",8160894],["thread",8159145],["thread",8158726],["thread",8158397],["thread",8158164],["thread",8157645],["thread",8154538],["thread",8114853],["thread",8019923],["thread",7891455],["thread",7786816],["thread",7241793],["thread",6576262],["thread",707070]], 497, tinhte_xentag_tag, , {"tags":["c\u00e1c lo\u1ea1i th\u00fa kh\u00e1c"]}, date, 0, , [], 0, 1656408925, 74f9cab5af901b00fe9d93159b0dab0c
Run Time: 0.000803