SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000227
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT tag.*
,
0 AS tag_is_watched
FROM `xf_tinhte_xentag_tag` AS tag
WHERE (tag.tag_text = 'bếp từ')
Run Time: 0.000544
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | tag | ref | tag_text | tag_text | 302 | const | 2 | Using index condition |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 62
Run Time: 0.000800
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 62
Run Time: 0.000284
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
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 (9685197, 9685100, 9680825, 9680747, 9680678, 9680342, 9680247, 9680243, 9680242, 9680162, 9678819, 9675831, 9675830, 9674057, 9669536, 9669092, 9668916, 9666046, 9661224, 9661223, 9660999, 9660996, 9660688, 9659893, 9659313, 9658588, 9657759, 9656801, 9655118, 9653560, 9653558, 9653557, 9653009, 9649700, 9649095, 9648324, 9642297, 9640252, 9640229, 9640118, 9639265, 9638226, 9637039, 9636163, 9635018, 9624521, 9624519, 9624518, 9623668, 9622517, 9621889, 9621817, 9621312, 9619462, 9616388, 9614382, 9613462, 9613461, 9612877, 9612048, 9611464, 9611461, 9610809, 9610092, 9609840, 9609058, 9605001, 9604765, 9602162, 9600947, 9600444, 9599618, 9598477, 9596963, 9596846, 9596387, 9595876, 9595781, 9595565, 9594425, 9594389, 9594191, 9593289, 9592358, 9592357, 9592259, 9589970, 9589968, 9588321, 9585549, 9581917, 9581912, 9581909, 9581492, 9581239, 9580247, 9578448, 9577835, 9577529, 9572416, 9572105, 9571597, 9569544, 9565284, 9564266, 9564265, 9562580, 9562525, 9561663, 9561661, 9560929, 9559238, 9558665, 9558631, 9558275, 9558274, 9558234, 9555882, 9548074, 9546157, 9543086, 9540850, 9540383, 9540359, 9540358, 9540070, 9540069, 9540056, 9538482, 9538481, 9538322, 9538154, 9534869, 9534361, 9534360, 9534359, 9533080, 9531685, 9531313, 9531298, 9531297, 9530741, 9529506, 9529505, 9528460, 9528383, 9527913, 9527498, 9526210, 9525568, 9525362, 9525335, 9525319, 9525318, 9524615, 9524612, 9523963, 9523023, 9520300, 9519561, 9519162, 9517499, 9517498, 9516411, 9516396, 9515940, 9515860, 9515655, 9514825, 9514122, 9514121, 9514048, 9513638, 9511963, 9511245, 9510311, 9510133, 9510122, 9509559, 9509205, 9509204, 9509203, 9509199, 9509122, 9508873, 9508870, 9508868, 9508698, 9504847, 9504735, 9504160, 9503817, 9502895, 9489650, 9489649, 9489648, 9489644, 9489643, 9489595, 9489348, 9487735, 9487026, 9486950, 9481712, 9480078, 9480076, 9479465, 9476660, 9475522, 9475286, 9475285, 9474151, 9473926, 9473596, 9473547, 9473209, 9473100, 9473099, 9472683, 9472549, 9472361, 9472352, 9472099, 9471755, 9471741, 9471608, 9471393, 9471264, 9470967, 9470869, 9470739, 9470583, 9469827, 9469796, 9469723, 9469454, 9469368, 9469233, 9468722, 9468651, 9468529, 9468519, 9468227, 9468133, 9468061, 9467764, 9467658, 9467621, 9467195, 9467047, 9466999, 9466449, 9466437, 9466384, 9466247, 9466078, 9466077, 9466076, 9465781, 9465757, 9465434, 9465367, 9465350, 9465239, 9465162, 9465042, 9465017, 9464775, 9464079, 9464068, 9464053, 9463917, 9463791, 9463704, 9463619, 9463400, 9463296, 9463230, 9461902, 9461901, 9461546, 9461490, 9460978, 9460538, 9460174, 9460066, 9459935, 9459264, 9458935, 9458761, 9458746, 9458470, 9458312, 9457785, 9457654, 9454653, 9454054, 9454052, 9454044, 9454034, 9454031, 9453377, 9451423, 9450893, 9446473, 9445296, 9444723, 9444494, 9442378, 9441251, 9441011, 9440774, 9440453, 9440092, 9439258, 9439250, 9438633, 9438492, 9437833, 9437293, 9436481, 9436444, 9436326, 9434801, 9434430, 9432942, 9432407, 9432191, 9431787, 9430299, 9429209, 9428175, 9428173, 9428130, 9427472, 9425056, 9424185, 9424184, 9423792, 9420697, 9418450, 9417964, 9417528, 9415709, 9414360, 9414358, 9413651, 9413116, 9412027, 9410603, 9407195, 9405337, 9405076, 9404096, 9403864, 9402116, 9401700, 9400837, 9400456, 9398036, 9398035, 9398019, 9397551, 9396189, 9394005, 9394000, 9393999, 9393993, 9393992, 9393990, 9393989, 9393925, 9393527, 9393334, 9391625, 9389476, 9387743, 9387202, 9386456, 9386429, 9386280, 9386273, 9385272, 9383916, 9383915, 9382551, 9382428, 9382403, 9381232, 9381231, 9379145, 9378200, 9373411, 9373181, 9372561, 9372560, 9372264, 9372261, 9372258, 9370987, 9370545, 9369375, 9369075, 9369073, 9368247, 9367377, 9367207, 9366894, 9366760, 9366327, 9365200, 9364860, 9364859, 9360384, 9359681, 9359496, 9358525, 9358524, 9357577, 9357388, 9354538, 9354285, 9353729, 9350643, 9345526, 9345299, 9343873, 9343778, 9343777, 9343775, 9337334, 9335805, 9333981, 9333980, 9333978, 9333753, 9333752, 9333270, 9333104, 9332481, 9332085, 9331912, 9328542, 9328541, 9328420, 9327516, 9323163, 9322009, 9321046, 9316862, 9316773, 9314870, 9314340, 9314176, 9314175, 9314010, 9312929, 9312467, 9312465, 9312329, 9312312, 9310301, 9308516, 9305499, 9305477, 9303871, 9303870, 9303488, 9302336, 9300605, 9297842, 9296278, 9292717, 9291798, 9274476, 9273436, 9273433, 9270937, 9267420, 9264708, 9259592, 9257300, 9257291, 9257233, 9257181, 9255402, 9254651, 9250670, 9249637, 9249021, 9245378, 9242354, 9241672, 9241146, 9241144, 9239544, 9237901, 9237273, 9237204, 9236212, 9233943, 9232632, 9231529, 9231528, 9230316, 9230307, 9225862, 9224992, 9224941, 9224009, 9224007, 9219514, 9217068, 9216553, 9215192, 9214845, 9214622, 9213745, 9213744, 9213743, 9213174, 9212987, 9211474, 9211212, 9211187, 9208926, 9206886, 9206754, 9206661, 9205825, 9204367, 9199082, 9199079, 9198950, 9197971, 9197969, 9197963, 9197740, 9194635, 9192446, 9192077, 9188509, 9185000, 9182351, 9181063, 9180895, 9180894, 9180811, 9179897, 9173616, 9172886, 9172370, 9169692, 9168918, 9168882, 9168850, 9168846, 9168840, 9167881, 9167865, 9167856, 9167803, 9167153, 9165415, 9161366, 9160200, 9160199, 9160197, 9151968, 9150928, 9150126, 9145228, 9145094, 9144626, 9143324, 9140169, 9138783, 9138775, 9138769, 9138006, 9137826, 9135628, 9135627, 9134772, 9132312, 9131634, 9130520, 9129539, 9127926, 9127623, 9126747, 9125729, 9125092, 9125091, 9124621, 9120808, 9118618, 9116699, 9113319, 9111403, 9110786, 9109740, 9108441, 9108079, 9106708, 9102476, 9101083, 9098856, 9098853, 9097882, 9096231, 9095797, 9095787, 9095786, 9095785, 9094976, 9093489, 9090117, 9087380, 9086856, 9082928, 9082354, 9082353, 9082321, 9081089, 9081088, 9072830, 9072158, 9069903, 9068637, 9068490, 9060431, 9060429, 9059417, 9055818, 9055757, 9055754, 9055526, 9055413, 9055412, 9054829, 9054342, 9054084, 9052946, 9052830, 9052131, 9052108, 9052107, 9051428, 9051218, 9051060, 9049330, 9049162, 9049149, 9047267, 9042396, 9040348, 9040304, 9037228, 9036406, 9036350, 9036309, 9036253, 9036064, 9035855, 9035341, 9035323, 9035237, 9035219, 9033780, 9033139, 9033137, 9033136, 9031233, 9031210, 9029173, 9029168, 9025814, 9023222, 9022081, 9021930, 9021929, 9015318, 9014367, 9012954, 9012142, 9012141, 9012140, 9012139, 9011714, 9006886, 9006853, 9000788, 9000581, 8998898, 8996530, 8996507, 8994680, 8994019, 8993477, 8993227, 8993070, 8991953, 8990910, 8989713, 8988532, 8988493, 8988271, 8986279, 8986274, 8986238, 8985622, 8984649, 8984595, 8984049, 8983457, 8983279, 8982050, 8981598, 8977258, 8977191, 8976572, 8976571, 8976570, 8976513, 8976511, 8976312, 8976211, 8975454, 8975451, 8975450, 8969530, 8967662, 8966724, 8964176, 8961378, 8959470, 8955708, 8955707, 8954569, 8954566, 8954214, 8953897, 8953236, 8953226, 8953217, 8953216, 8953215, 8953214, 8953208, 8953188, 8953186, 8953184, 8953182, 8953179, 8952862, 8952859, 8952844, 8952841, 8952838, 8952831, 8952688, 8952566, 8950872, 8950871, 8950869, 8950208, 8944396, 8942697, 8942695, 8942686, 8941608, 8941607, 8941596, 8941559, 8941547, 8941538, 8939983, 8939980, 8938714, 8938713, 8937654, 8936227, 8936226, 8935488, 8932950, 8932872, 8932862, 8931308, 8925837, 8922784, 8922611, 8922608, 8921460, 8920752, 8920061, 8919511, 8917110, 8915727, 8912896, 8912877, 8911194, 8910734, 8909535, 8909364, 8908970, 8908707, 8908706, 8906068, 8905304, 8904676, 8904276, 8900840, 8900684, 8900186, 8899758, 8896039, 8896038, 8895558, 8894362, 8893521, 8893519, 8893518, 8893516, 8891586, 8890969, 8889201, 8885729, 8885728, 8883051, 8881784, 8879633, 8877971, 8876707, 8876705, 8876704, 8876702, 8875233, 8875231, 8874749, 8874288, 8873869, 8873842, 8873830, 8872247, 8872245, 8870314, 8868562, 8868561, 8867751, 8867105, 8867007, 8864499, 8864314, 8864312, 8864311, 8863363, 8863362, 8863361, 8862713, 8860689, 8860134, 8860099, 8857554, 8855763, 8855097, 8851885, 8850292, 8848581, 8848577, 8847820, 8847613, 8847433, 8847368, 8845885, 8844401, 8844090, 8843748, 8843468, 8843467, 8842947, 8842945, 8839311, 8838932, 8837926, 8837874, 8835944, 8835560, 8835395, 8832763, 8832593, 8832592, 8831082, 8829989, 8829768, 8829009, 8828738, 8825023, 8824269, 8824268, 8823856, 8822007, 8822001, 8819225, 8818843, 8818607, 8818606, 8817870, 8817869, 8817147, 8816935, 8816862, 8816728, 8816727, 8813786, 8812840, 8812838, 8812771, 8811278, 8810090, 8805888, 8805887, 8804615, 8803758, 8802750, 8801470, 8800243, 8799489, 8798812, 8798726, 8796476, 8796471, 8795479, 8794318, 8794203, 8792478, 8789363, 8789140, 8787217, 8785700, 8785699, 8784276, 8783269, 8782647, 8782622, 8779592, 8777265, 8776507, 8776506, 8776361, 8776358, 8774548, 8772543, 8772527, 8771914, 8771166, 8770668, 8770653, 8768600, 8767902, 8766996, 8766995, 8766212, 8765006, 8765001, 8764949, 8764945, 8763157, 8760638, 8760423, 8759248, 8759247, 8758405, 8758339, 8758337, 8757150, 8756703, 8753370, 8751522, 8750305, 8750207, 8749809, 8749756, 8749380, 8749379, 8749113, 8749111, 8748880, 8747690, 8745065, 8740769, 8739007, 8739002, 8739001, 8737483, 8734483, 8731392, 8731390, 8731389, 8725052, 8725051, 8724156, 8723681, 8722817, 8722735, 8720976, 8720829, 8720806, 8720327, 8717571, 8717520, 8717519, 8717518, 8717515, 8717513, 8717512, 8715256, 8709370, 8707760, 8707417, 8706891, 8700718, 8699744, 8699740, 8697523, 8697489, 8697470, 8693126, 8693125, 8693122, 8689437, 8689427, 8687134, 8687075, 8682197, 8681367, 8681365, 8681010, 8677568, 8674365, 8674069, 8673741, 8671941, 8670932, 8670792, 8669805, 8668535, 8668076, 8666018, 8664906, 8663997, 8662907, 8661656, 8660263, 8659515, 8659414, 8659151, 8659056, 8659036, 8657385, 8656744, 8655790, 8655788, 8655787, 8655429, 8655053, 8652260, 8649950, 8648478, 8648476, 8647774, 8645641, 8645095, 8645094, 8645093, 8645090, 8643755, 8643547, 8642848, 8641614, 8639287, 8639286, 8639285, 8639278, 8637585, 8637567, 8636395, 8634608, 8633820, 8633811, 8633782, 8629684, 8628779, 8628700, 8626641, 8625644, 8624752, 8622025, 8614689, 8614345, 8614113, 8613913, 8612148, 8611904, 8611901, 8607490, 8605529, 8604400, 8602207, 8601849, 8601816, 8601811, 8601806, 8601795, 8600954, 8597383, 8594654, 8594652, 8592088, 8592075, 8592053, 8572930, 8569473, 8565750, 8552771, 8543940, 8519489, 8516084, 8509643, 8507434, 8503845, 8492939, 8491144, 8487249, 8481287, 8478840, 8477575, 8476380, 8474992, 8471937, 8470803, 8466027, 8464637, 8462508, 8459561, 8456862, 8456853, 8454806, 8454801, 8454799, 8452581, 8440532, 8439709, 8431684, 8431170, 8428631, 8428449, 8427437, 8426418, 8420247, 8418914, 8417436, 8402112, 8397069, 8393604, 8393543, 8393228, 8391834, 8391818, 8377168, 8376066, 8375067, 8373506, 8366185, 8366104, 8361662, 8358700, 8352814, 8352501, 8338725, 8338690, 8336235, 8321804, 8309370, 8303418, 8300900, 8295584, 8293433, 8291298, 8291269, 8291268, 8275199, 8273900, 8272935, 8272334, 8269894, 8261021, 8259722, 8252554, 8247468, 8246958, 8246956, 8239949, 8237513, 8235957, 8230963, 8226569, 8223070, 8216590, 8215914, 8214350, 8210826, 8210721, 8210053, 8210052, 8208965, 8202445, 8195721, 8191403, 8191106, 8188559, 8153388, 8138253, 8138252, 8138251, 8138250, 8138249, 8138233, 8138232, 8138231, 8116848, 7484027)
Run Time: 0.029742
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | <subquery2> | ALL | distinct_key | | | | 1232 | |
| 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 | | | | | 1232 | |
| DERIVED | | | | | | | | No tables used |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 62
Run Time: 0.000741
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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",62],["thread",9685197],["thread",9680747],["thread",9680342],["thread",9680247],["thread",9680243],["thread",9680162],["thread",9674057],["thread",9669536],["thread",9668916],["thread",9661224],["thread",9660999],["thread",9660996],["thread",9660688],["thread",9659893],["thread",9658588],["thread",9656801],["thread",9655118],["thread",9653560],["thread",9649095],["thread",9648324],["thread",9642297],["thread",9640229],["thread",9640118],["thread",9639265],["thread",9638226],["thread",9637039],["thread",9624521],["thread",9623668],["thread",9622517],["thread",9621889],["thread",9621817],["thread",9621312],["thread",9619462],["thread",9613462],["thread",9612048],["thread",9611464],["thread",9611461],["thread",9610092],["thread",9602162],["thread",9599618],["thread",9598477],["thread",9596963],["thread",9595781],["thread",9594425],["thread",9594389],["thread",9592357],["thread",9592259],["thread",9585549],["thread",9581917],["thread",9581909],["thread",9581492],["thread",9581239],["thread",9580247],["thread",9572416],["thread",9572105],["thread",9565284],["thread",9562580],["thread",9562525],["thread",9560929],["thread",9559238],["thread",9558665],["thread",9558631],["thread",9558275],["thread",9548074],["thread",9546157],["thread",9540850],["thread",9540383],["thread",9540070],["thread",9538482],["thread",9538322],["thread",9534869],["thread",9534361],["thread",9531685],["thread",9531313],["thread",9531298],["thread",9530741],["thread",9529506],["thread",9528460],["thread",9528383],["thread",9527498],["thread",9525568],["thread",9525362],["thread",9525335],["thread",9525319],["thread",9524615],["thread",9524612],["thread",9523963],["thread",9523023],["thread",9520300],["thread",9519561],["thread",9519162],["thread",9517499],["thread",9516411],["thread",9516396],["thread",9515940],["thread",9515860],["thread",9515655],["thread",9514122],["thread",9513638],["thread",9511963],["thread",9511245],["thread",9510133],["thread",9510122],["thread",9509559],["thread",9509205],["thread",9509199],["thread",9509122],["thread",9508873],["thread",9508870],["thread",9508698],["thread",9504735],["thread",9489650],["thread",9489649],["thread",9489648],["thread",9489644],["thread",9489643],["thread",9489595],["thread",9489348],["thread",9487735],["thread",9487026],["thread",9486950],["thread",9480078],["thread",9479465],["thread",9476660],["thread",9475286],["thread",9474151],["thread",9473926],["thread",9473596],["thread",9473209],["thread",9473100],["thread",9472352],["thread",9472099],["thread",9471741],["thread",9471608],["thread",9471393],["thread",9469827],["thread",9469796],["thread",9468133],["thread",9467764],["thread",9466449],["thread",9466247],["thread",9466078],["thread",9465434],["thread",9465367],["thread",9465350],["thread",9464079],["thread",9464068],["thread",9464053],["thread",9463619],["thread",9460174],["thread",9459935],["thread",9459264],["thread",9457654],["thread",9454054],["thread",9454052],["thread",9454044],["thread",9454034],["thread",9454031],["thread",9451423],["thread",9444723],["thread",9444494],["thread",9442378],["thread",9441251],["thread",9441011],["thread",9440774],["thread",9440453],["thread",9440092],["thread",9439258],["thread",9439250],["thread",9437833],["thread",9437293],["thread",9436481],["thread",9436444],["thread",9434430],["thread",9432407],["thread",9432191],["thread",9430299],["thread",9424185],["thread",9423792],["thread",9420697],["thread",9417964],["thread",9415709],["thread",9414360],["thread",9413651],["thread",9407195],["thread",9405076],["thread",9404096],["thread",9403864],["thread",9400837],["thread",9400456],["thread",9398036],["thread",9398035],["thread",9398019],["thread",9397551],["thread",9396189],["thread",9394005],["thread",9394000],["thread",9393999],["thread",9393993],["thread",9393992],["thread",9393990],["thread",9393527],["thread",9387202],["thread",9386456],["thread",9386429],["thread",9385272],["thread",9383916],["thread",9382428],["thread",9382403],["thread",9379145],["thread",9378200],["thread",9373411],["thread",9373181],["thread",9372561],["thread",9372264],["thread",9372261],["thread",9372258],["thread",9369075],["thread",9367377],["thread",9364860],["thread",9360384],["thread",9358525],["thread",9354538],["thread",9353729],["thread",9350643],["thread",9343873],["thread",9343778],["thread",9343777],["thread",9343775],["thread",9333981],["thread",9333980],["thread",9333978],["thread",9333753],["thread",9333104],["thread",9332481],["thread",9332085],["thread",9331912],["thread",9328542],["thread",9328420],["thread",9323163],["thread",9316862],["thread",9316773],["thread",9314870],["thread",9314340],["thread",9314010],["thread",9312929],["thread",9312465],["thread",9312329],["thread",9312312],["thread",9310301],["thread",9305499],["thread",9303871],["thread",9303488],["thread",9302336],["thread",9300605],["thread",9297842],["thread",9292717],["thread",9274476],["thread",9273436],["thread",9273433],["thread",9270937],["thread",9264708],["thread",9259592],["thread",9257291],["thread",9257181],["thread",9254651],["thread",9249021],["thread",9245378],["thread",9242354],["thread",9237901],["thread",9237273],["thread",9233943],["thread",9231529],["thread",9224009],["thread",9219514],["thread",9216553],["thread",9214845],["thread",9214622],["thread",9213745],["thread",9212987],["thread",9211212],["thread",9211187],["thread",9206886],["thread",9206661],["thread",9205825],["thread",9204367],["thread",9198950],["thread",9197971],["thread",9194635],["thread",9181063],["thread",9180895],["thread",9179897],["thread",9172886],["thread",9169692],["thread",9168850],["thread",9168846],["thread",9168840],["thread",9167881],["thread",9167865],["thread",9167856],["thread",9167803],["thread",9167153],["thread",9161366],["thread",9160200],["thread",9150928],["thread",9150126],["thread",9145228],["thread",9144626],["thread",9143324],["thread",9140169],["thread",9138783],["thread",9138775],["thread",9138769],["thread",9138006],["thread",9137826],["thread",9135628],["thread",9134772],["thread",9131634],["thread",9129539],["thread",9118618],["thread",9113319],["thread",9108441],["thread",9108079],["thread",9106708],["thread",9101083],["thread",9098856],["thread",9097882],["thread",9095797],["thread",9095787],["thread",9095786],["thread",9094976],["thread",9093489],["thread",9090117],["thread",9086856],["thread",9082928],["thread",9082354],["thread",9081089],["thread",9072830],["thread",9069903],["thread",9068490],["thread",9059417],["thread",9054829],["thread",9054342],["thread",9052108],["thread",9049330],["thread",9022081],["thread",9015318],["thread",9014367],["thread",9012142],["thread",9011714],["thread",8996507],["thread",8993477],["thread",8991953],["thread",8988532],["thread",8988493],["thread",8986238],["thread",8985622],["thread",8984595],["thread",8984049],["thread",8983279],["thread",8982050],["thread",8977258],["thread",8977191],["thread",8976572],["thread",8976513],["thread",8976312],["thread",8975454],["thread",8969530],["thread",8954569],["thread",8954214],["thread",8952688],["thread",8944396],["thread",8942697],["thread",8942686],["thread",8939983],["thread",8938714],["thread",8936227],["thread",8925837],["thread",8917110],["thread",8915727],["thread",8910734],["thread",8909535],["thread",8908707],["thread",8900186],["thread",8896039],["thread",8894362],["thread",8893521],["thread",8875233],["thread",8874288],["thread",8867751],["thread",8867105],["thread",8864499],["thread",8864314],["thread",8860689],["thread",8860099],["thread",8855763],["thread",8855097],["thread",8848581],["thread",8847820],["thread",8847613],["thread",8847433],["thread",8847368],["thread",8845885],["thread",8843748],["thread",8842947],["thread",8838932],["thread",8837926],["thread",8835944],["thread",8835395],["thread",8832763],["thread",8831082],["thread",8829989],["thread",8829768],["thread",8825023],["thread",8824269],["thread",8823856],["thread",8822001],["thread",8818843],["thread",8817147],["thread",8816862],["thread",8812840],["thread",8805888],["thread",8800243],["thread",8798812],["thread",8798726],["thread",8796476],["thread",8796471],["thread",8794318],["thread",8794203],["thread",8792478],["thread",8789363],["thread",8789140],["thread",8785700],["thread",8783269],["thread",8779592],["thread",8776507],["thread",8776361],["thread",8772527],["thread",8771166],["thread",8770668],["thread",8770653],["thread",8766996],["thread",8765006],["thread",8765001],["thread",8764949],["thread",8764945],["thread",8763157],["thread",8760423],["thread",8758405],["thread",8757150],["thread",8756703],["thread",8750305],["thread",8750207],["thread",8749809],["thread",8749113],["thread",8745065],["thread",8739001],["thread",8737483],["thread",8725052],["thread",8724156],["thread",8723681],["thread",8720976],["thread",8720829],["thread",8720806],["thread",8720327],["thread",8717520],["thread",8709370],["thread",8707760],["thread",8707417],["thread",8700718],["thread",8699744],["thread",8697523],["thread",8697489],["thread",8697470],["thread",8693126],["thread",8689437],["thread",8689427],["thread",8687134],["thread",8682197],["thread",8681010],["thread",8674365],["thread",8674069],["thread",8673741],["thread",8671941],["thread",8669805],["thread",8666018],["thread",8664906],["thread",8663997],["thread",8662907],["thread",8661656],["thread",8660263],["thread",8659151],["thread",8659056],["thread",8659036],["thread",8657385],["thread",8656744],["thread",8655790],["thread",8655429],["thread",8655053],["thread",8649950],["thread",8648476],["thread",8647774],["thread",8645641],["thread",8645095],["thread",8643755],["thread",8643547],["thread",8642848],["thread",8639287],["thread",8637585],["thread",8636395],["thread",8634608],["thread",8633820],["thread",8633811],["thread",8633782],["thread",8629684],["thread",8628779],["thread",8628700],["thread",8626641],["thread",8625644],["thread",8624752],["thread",8622025],["thread",8614689],["thread",8614345],["thread",8614113],["thread",8613913],["thread",8612148],["thread",8611904],["thread",8607490],["thread",8605529],["thread",8604400],["thread",8602207],["thread",8601849],["thread",8601816],["thread",8601811],["thread",8601806],["thread",8601795],["thread",8600954],["thread",8597383],["thread",8594654],["thread",8594652],["thread",8592088],["thread",8592075],["thread",8592053],["thread",8572930],["thread",8569473],["thread",8565750],["thread",8543940],["thread",8519489],["thread",8516084],["thread",8509643],["thread",8507434],["thread",8503845],["thread",8491144],["thread",8487249],["thread",8481287],["thread",8478840],["thread",8477575],["thread",8476380],["thread",8474992],["thread",8471937],["thread",8470803],["thread",8466027],["thread",8464637],["thread",8462508],["thread",8459561],["thread",8456862],["thread",8456853],["thread",8452581],["thread",8440532],["thread",8439709],["thread",8431684],["thread",8431170],["thread",8428631],["thread",8428449],["thread",8427437],["thread",8426418],["thread",8420247],["thread",8417436],["thread",8397069],["thread",8393604],["thread",8393543],["thread",8393228],["thread",8391834],["thread",8391818],["thread",8377168],["thread",8376066],["thread",8375067],["thread",8373506],["thread",8366185],["thread",8366104],["thread",8361662],["thread",8358700],["thread",8352814],["thread",8352501],["thread",8338725],["thread",8338690],["thread",8336235],["thread",8321804],["thread",8303418],["thread",8300900],["thread",8293433],["thread",8291269],["thread",8273900],["thread",8272334],["thread",8261021],["thread",8259722],["thread",8252554],["thread",8247468],["thread",8246958],["thread",8246956],["thread",8239949],["thread",8237513],["thread",8235957],["thread",8230963],["thread",8226569],["thread",8216590],["thread",8215914],["thread",8210826],["thread",8210053],["thread",8202445],["thread",8195721],["thread",8191403],["thread",8191106],["thread",8188559],["thread",8116848],["thread",7484027]], 627, tinhte_xentag_tag, , {"tags":["b\u1ebfp t\u1eeb"]}, date, 0, , [], 0, 1656448666, 552efbf406749d7df00122ef2d096334
Run Time: 0.000735
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 62
Run Time: 0.000739
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 (9685197, 9680747, 9680342, 9680247, 9680243, 9680162, 9674057, 9669536, 9668916, 9661224, 9660999, 9660996, 9660688, 9659893, 9658588, 9656801, 9655118, 9653560, 9649095)
Run Time: 0.001628
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 19 | 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_tinhte_xentag_tag_view
(tag_id)
VALUES
(?)
Params: 373
Run Time: 0.000302
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , Tinhte_XenTag_ControllerPublic_Tag, View, valid, t=b%E1%BA%BFp+t%E1%BB%AB, 1656448666,
Run Time: 0.000328
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000250
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_widget | ALL | | | | | 17 | Using where; Using filesort |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1656447766)
ORDER BY session_activity.view_date DESC
Run Time: 0.001303
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | ALL | view_date | | | | 1571 | Using where; Using filesort |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |