SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000212
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 = 'máy in')
Run Time: 0.000497
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 *
FROM xf_search
WHERE search_id = ?
Params: 85604543
Run Time: 0.000296
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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: 14
Run Time: 0.000770
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, 14
Run Time: 0.000337
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 (9971541, 9941755, 9925114, 9880005, 9880004, 9850436, 9813723, 9813722, 9813721, 9813720, 9786222, 9778594, 9778590, 9778589, 9778583, 9774790, 9759045, 9759008, 9758985, 9758887, 9758872, 9758836, 9758817, 9758784, 9758763, 9752812, 9749957, 9744830, 9740165, 9739488, 9738395, 9738394, 9735335, 9732638, 9727222, 9727010, 9722567, 9720383, 9720257, 9720249, 9718645, 9716593, 9715501, 9714086, 9706902, 9700492, 9700484, 9700483, 9700005, 9699721, 9699720, 9697673, 9686835, 9682097, 9682079, 9678926, 9678019, 9673216, 9671190, 9669208, 9667161, 9667112, 9666498, 9666497, 9666495, 9666494, 9666493, 9666492, 9666491, 9664784, 9664141, 9663128, 9662965, 9659116, 9659115, 9658882, 9658881, 9654323, 9653444, 9652378, 9652041, 9641572, 9641386, 9641301, 9638823, 9637043, 9637042, 9636401, 9635636, 9623579, 9619480, 9617910, 9615738, 9611269, 9611186, 9611182, 9608619, 9608586, 9608585, 9605040, 9605038, 9598122, 9588319, 9587006, 9581877, 9581843, 9581817, 9580005, 9579872, 9579560, 9579333, 9578004, 9577995, 9577640, 9577405, 9576523, 9574562, 9574561, 9574023, 9573679, 9573098, 9572876, 9572702, 9572701, 9572492, 9572491, 9572490, 9572489, 9572488, 9566755, 9566754, 9566753, 9565567, 9565566, 9563462, 9563461, 9562608, 9561490, 9560893, 9558749, 9554891, 9554092, 9550411, 9549825, 9549280, 9549022, 9548763, 9546456, 9543807, 9536083, 9532830, 9532594, 9527313, 9526015, 9520321, 9515590, 9514914, 9513523, 9510442, 9507523, 9507471, 9499668, 9499660, 9499659, 9499106, 9499105, 9498738, 9498734, 9498723, 9498720, 9498717, 9498710, 9498705, 9498699, 9494220, 9493461, 9491294, 9491291, 9491079, 9490111, 9490110, 9490108, 9489798, 9488569, 9488115, 9487843, 9486661, 9485991, 9485355, 9485335, 9482344, 9482343, 9481388, 9481381, 9481380, 9481379, 9479969, 9479955, 9479902, 9478790, 9477760, 9476499, 9474092, 9473999, 9473984, 9471349, 9470063, 9468196, 9464941, 9459922, 9459889, 9459887, 9459113, 9451494, 9449150, 9448359, 9445733, 9443893, 9443241, 9441975, 9436803, 9436496, 9434488, 9434487, 9434485, 9432943, 9431471, 9431378, 9431371, 9431370, 9430433, 9428785, 9428776, 9428768, 9428756, 9428748, 9428738, 9427798, 9426062, 9425973, 9425920, 9425879, 9425683, 9425143, 9425016, 9425008, 9425005, 9424693, 9424689, 9424592, 9424461, 9424460, 9424250, 9421978, 9421976, 9421970, 9421969, 9421326, 9421316, 9421087, 9421084, 9418925, 9416333, 9416332, 9415874, 9413898, 9413349, 9413348, 9413347, 9413344, 9413343, 9411766, 9410676, 9410636, 9408294, 9407765, 9406072, 9404585, 9402110, 9399677, 9399656, 9396790, 9396295, 9396294, 9393602, 9391057, 9390079, 9389266, 9389145, 9384437, 9378455, 9376982, 9376943, 9376499, 9376231, 9373351, 9373350, 9371725, 9368631, 9364927, 9364340, 9364338, 9364309, 9364243, 9364230, 9364197, 9364005, 9362710, 9362705, 9362695, 9362688, 9362673, 9362666, 9360416, 9360203, 9360202, 9357848, 9350437, 9349474, 9348710, 9346710, 9344642, 9343062, 9342753, 9340236, 9339942, 9339934, 9339927, 9339924, 9339907, 9339246, 9336527, 9336526, 9326622, 9326620, 9326619, 9326616, 9326614, 9325239, 9324047, 9321811, 9321693, 9321579, 9320568, 9320543, 9320038, 9320032, 9319526, 9319518, 9319513, 9319501, 9319474, 9319343, 9318469, 9318467, 9318459, 9318444, 9317913, 9317351, 9316856, 9316851, 9316848, 9316845, 9316830, 9316820, 9316702, 9316584, 9316572, 9316563, 9316309, 9313636, 9313633, 9313630, 9312942, 9312935, 9312934, 9312933, 9312921, 9312919, 9312918, 9312866, 9309795, 9308901, 9308357, 9308231, 9308011, 9307525, 9307081, 9307068, 9306675, 9306596, 9306503, 9305523, 9305172, 9305171, 9304800, 9304682, 9304681, 9304086, 9303801, 9303800, 9303799, 9303798, 9303787, 9302656, 9300737, 9300736, 9300274, 9300105, 9296092, 9290955, 9290109, 9287176, 9285522, 9280874, 9277883, 9275228, 9275212, 9275202, 9274966, 9274965, 9273949, 9272885, 9271803, 9263383, 9263382, 9263381, 9263087, 9263086, 9262250, 9252088, 9251957, 9248229, 9247541, 9247540, 9247197, 9247196, 9247195, 9243569, 9242813, 9239393, 9238765, 9238187, 9236870, 9235283, 9235282, 9233917, 9233428, 9231689, 9227374, 9226068, 9224111, 9224086, 9224085, 9222985, 9222983, 9222868, 9221474, 9221009, 9217603, 9213293, 9212385, 9208888, 9205304, 9200658, 9197968, 9196403, 9194747, 9194167, 9188665, 9188623, 9187565, 9183542, 9183540, 9178048, 9177910, 9170172, 9163996, 9163811, 9160577, 9158591, 9155212, 9154357, 9154219, 9150841, 9150840, 9150839, 9144954, 9144382, 9144380, 9143280, 9140567, 9136259, 9131011, 9131010, 9128350, 9127210, 9126833, 9126127, 9123830, 9123827, 9123823, 9122724, 9122723, 9122484, 9120965, 9120020, 9120019, 9119559, 9119521, 9118000, 9117949, 9117870, 9116989, 9116528, 9113066, 9112861, 9112859, 9112202, 9112198, 9112185, 9112184, 9112182, 9111260, 9110388, 9110386, 9098999, 9098974, 9095546, 9095532, 9095527, 9087319, 9087060, 9085666, 9085663, 9085300, 9084588, 9084587, 9083585, 9083130, 9080475, 9078845, 9078843, 9078313, 9078236, 9077054, 9075260, 9072609, 9069949, 9066796, 9063872, 9062499, 9061393, 9061295, 9061181, 9054252, 9054221, 9054219, 9054217, 9049378, 9047690, 9044369, 9043939, 9042326, 9041599, 9041584, 9040877, 9038417, 9034303, 9032422, 9032253, 9032245, 9031082, 9030952, 9030449, 9029812, 9029811, 9029391, 9024648, 9024647, 9024577, 9024340, 9024339, 9018395, 9018336, 9016927, 9014877, 9014713, 9012370, 9007569, 9006309, 9005026, 9001434, 9000433, 8999848, 8999662, 8999650, 8999443, 8999351, 8998584, 8998583, 8998581, 8996793, 8994840, 8991305, 8991164, 8991163, 8987578, 8984172, 8982994, 8979763, 8979110, 8978487, 8977159, 8976003, 8975985, 8975984, 8973120, 8973119, 8973118, 8972408, 8971760, 8970051, 8965820, 8962883, 8962881, 8961428, 8961209, 8959733, 8958967, 8957568, 8951186, 8946713, 8944987, 8943924, 8943853, 8943727, 8943432, 8943415, 8942872, 8940111, 8938367, 8937893, 8937240, 8936325, 8936104, 8936056, 8936055, 8935242, 8934857, 8934344, 8932956, 8931787, 8931786, 8930717, 8930716, 8929835, 8929832, 8929831, 8928843, 8928606, 8927994, 8927993, 8927950, 8927140, 8926713, 8925645, 8925489, 8924881, 8923721, 8923684, 8923682, 8923502, 8921493, 8920985, 8920510, 8920353, 8920348, 8920334, 8917138, 8916541, 8916437, 8914736, 8914707, 8914668, 8914667, 8914593, 8913699, 8913697, 8913695, 8913639, 8913632, 8913538, 8912854, 8912533, 8912077, 8911665, 8911159, 8910364, 8910363, 8910358, 8908003, 8907607, 8907521, 8907517, 8907511, 8907510, 8907498, 8907157, 8906853, 8905541, 8905536, 8904126, 8903949, 8903623, 8902983, 8901675, 8900025, 8899168, 8899155, 8898710, 8898709, 8897205, 8896395, 8894377, 8894153, 8890998, 8890832, 8889773, 8889771, 8889669, 8889394, 8889089, 8888509, 8886903, 8886043, 8886041, 8885169, 8885132, 8884946, 8883002, 8881021, 8881019, 8877153, 8875093, 8874957, 8874240, 8873244, 8872134, 8871764, 8871222, 8871199, 8870570, 8870119, 8868345, 8868108, 8867543, 8867542, 8867541, 8867538, 8866421, 8863256, 8862868, 8859268, 8859256, 8859247, 8859138, 8858654, 8858653, 8858614, 8858563, 8858095, 8857717, 8857706, 8857697, 8857686, 8857668, 8857664, 8857543, 8857381, 8856771, 8856040, 8855511, 8854689, 8854272, 8850633, 8849298, 8845954, 8845195, 8841036, 8840614, 8840090, 8831567, 8830916, 8830257, 8829265, 8827266, 8825539, 8825538, 8824196, 8819985, 8819984, 8818817, 8816710, 8816119, 8816117, 8815981, 8815644, 8815406, 8812173, 8811415, 8809676, 8805558, 8805201, 8804009, 8804008, 8802295, 8801766, 8800223, 8798231, 8797828, 8793393, 8791331, 8791329, 8791328, 8791327, 8791326, 8788148, 8786529, 8786228, 8786225, 8783763, 8781245, 8781242, 8781241, 8781240, 8781238, 8781237, 8780662, 8778550, 8777920, 8777113, 8777108, 8776854, 8776852, 8776848, 8776846, 8774219, 8773551, 8773550, 8772424, 8772423, 8771417, 8771416, 8771048, 8767797, 8767168, 8763582, 8762844, 8760738, 8758955, 8756921, 8755074, 8754813, 8754812, 8753130, 8752148, 8749830, 8748160, 8745569, 8743125, 8739965, 8736894, 8736885, 8735124, 8734174, 8729973, 8729177, 8728942, 8728937, 8728934, 8728928, 8728922, 8728919, 8728918, 8728916, 8728908, 8728906, 8728766, 8726588, 8726224, 8725750, 8725748, 8724507, 8724237, 8723828, 8723826, 8721975, 8721714, 8721096, 8720012, 8719679, 8719678, 8716779, 8714593, 8713847, 8712783, 8712316, 8711174, 8709050, 8707709, 8706593, 8706242, 8705045, 8704948, 8703759, 8703730, 8703411, 8703155, 8701304, 8700654, 8695928, 8692178, 8689703, 8689336, 8688353, 8686809, 8686795, 8686763, 8686389, 8686240, 8685771, 8685764, 8685757, 8685751, 8685740, 8685732, 8685728, 8685724, 8685720, 8685565, 8685564, 8685557, 8685548, 8685524, 8685250, 8685212, 8685001, 8684925, 8684620, 8684541, 8684125, 8683773, 8683564, 8683229, 8682736, 8680134, 8679395, 8678055, 8676808, 8675889, 8675414, 8675411, 8675409, 8674189, 8672690, 8670938, 8668656, 8667764, 8665019, 8663951, 8663949, 8663946, 8663944, 8663941, 8663938, 8663931, 8663926, 8663923, 8663922, 8663781, 8663408, 8661847, 8661530, 8661517, 8661516, 8661511, 8661506, 8661501, 8660754, 8660196, 8660193, 8660189, 8660181, 8660174, 8660011, 8658786, 8658276, 8658256, 8657848, 8656405, 8651113, 8650200, 8648194, 8648186, 8648185, 8648165, 8647532, 8647329, 8647176, 8646129, 8646124, 8646111, 8645953, 8644724, 8643605, 8643377, 8639106, 8638978, 8638168, 8637421, 8636359, 8635987, 8634971, 8634787, 8632459, 8632005, 8632002, 8631811, 8631671, 8630710, 8629551, 8628524, 8627653, 8626535, 8626518, 8626318, 8626307, 8625849, 8625658, 8625657, 8625654, 8625651, 8625649, 8625642, 8625641, 8625637, 8625627, 8625620, 8625449, 8624265, 8619941, 8618700, 8617763, 8617438, 8616933, 8612039, 8612021, 8610184, 8610026, 8607312, 8607311, 8604641, 8601801, 8600681, 8597829, 8597017, 8596976, 8596949, 8596939, 8593800, 8593348, 8592887, 8592810, 8589133, 8587811, 8587486, 8586759, 8586758, 8586456, 8586406, 8586270, 8586224, 8585990, 8583629, 8583428, 8582777, 8582629, 8577023, 8576779, 8573667, 8573046, 8570780, 8568690, 8568517, 8568281, 8568220, 8566882, 8566178, 8565617, 8565581, 8564834, 8563342, 8561775, 8561532, 8561410, 8560986, 8559592, 8558655, 8558635, 8557013, 8555666, 8554607, 8553773, 8553723, 8553136, 8549068, 8549067, 8545849, 8545824, 8545410, 8539338, 8539016, 8538283, 8536431, 8535556, 8534827, 8530968, 8529340, 8529079, 8528481, 8525799, 8520559, 8520011, 8517905, 8516303, 8506769, 8505890, 8505594, 8505593, 8503065, 8502797, 8502012, 8499095, 8489775, 8488080, 8487616, 8486026, 8485298, 8485090, 8481639, 8475182, 8473574, 8465529, 8459137, 8458817, 8456988, 8455453, 8454234, 8453149, 8452943, 8452149, 8448414, 8444522, 8444521, 8442792, 8436696, 8430876, 8430380, 8429655, 8426557, 8414287, 8409040, 8405337, 8398639, 8397077, 8393811, 8393613, 8391051, 8388827, 8388285, 8386454, 8382508, 8380671, 8380543, 8380148, 8379171, 8378839, 8377899, 8377842, 8377776, 8377509, 8376619, 8375448, 8375405, 8375333, 8375276, 8374517, 8373989, 8373528, 8373386, 8371003, 8369651, 8369331, 8369310, 8368015, 8367862, 8367343, 8365745, 8365714, 8365186, 8361703, 8361686, 8360838, 8360152, 8360147, 8360146, 8359796, 8359793, 8359444, 8357717, 8356252, 8355194, 8353807, 8352939, 8352307, 8351990, 8351404, 8350799, 8350796, 8350784, 8349867, 8348480, 8345780, 8343714, 8343480, 8343472, 8341506, 8340210, 8339874, 8339811, 8338938, 8338038, 8338023, 8337840, 8336291, 8334806, 8334103, 8332623, 8332186, 8329792, 8326827, 8326129, 8325815, 8325429, 8323874, 8323768, 8322675, 8322056, 8315012, 8314498, 8314244, 8314242, 8312129, 8310515, 8309477, 8307210, 8306409, 8305750, 8305304, 8304954, 8304936, 8304244, 8303462, 8301677, 8301607, 8299325, 8299318, 8295117, 8289344, 8288391, 8284521, 8279211, 8266384, 8262975, 8253191, 8249424, 8249259, 8246144, 8244304, 8242747, 8241941, 8239284, 8238260, 8230440, 8230044, 8230043, 8229623, 8219925, 8219923, 8217554, 8212094, 8211952, 8205719, 8197681, 8197680, 8180565, 8174964, 8173895, 8159437, 8158217, 8151748, 8151184, 8150881, 8144943, 8138567, 8138551, 8136515, 8121434, 8110715, 8098563, 8096830, 8096828, 8081767, 7350307, 4711394, 3728480, 2267393, 2240658)
Run Time: 0.039800
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1329 | |
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 | | | | | 1329 | |
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: 14
Run Time: 0.000786
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",14],["thread",9971541],["thread",9941755],["thread",9925114],["thread",9880005],["thread",9850436],["thread",9813723],["thread",9778594],["thread",9778589],["thread",9778583],["thread",9774790],["thread",9759045],["thread",9759008],["thread",9758985],["thread",9758887],["thread",9758872],["thread",9758836],["thread",9758817],["thread",9758784],["thread",9758763],["thread",9752812],["thread",9749957],["thread",9744830],["thread",9740165],["thread",9739488],["thread",9738395],["thread",9735335],["thread",9732638],["thread",9727222],["thread",9722567],["thread",9720257],["thread",9720249],["thread",9716593],["thread",9714086],["thread",9706902],["thread",9700492],["thread",9700005],["thread",9699721],["thread",9697673],["thread",9682097],["thread",9682079],["thread",9673216],["thread",9671190],["thread",9669208],["thread",9659116],["thread",9641572],["thread",9641386],["thread",9641301],["thread",9619480],["thread",9617910],["thread",9615738],["thread",9611186],["thread",9611182],["thread",9608586],["thread",9605040],["thread",9588319],["thread",9579560],["thread",9578004],["thread",9577640],["thread",9574562],["thread",9573098],["thread",9572876],["thread",9572702],["thread",9566755],["thread",9565567],["thread",9562608],["thread",9561490],["thread",9554891],["thread",9554092],["thread",9550411],["thread",9549825],["thread",9549280],["thread",9549022],["thread",9546456],["thread",9532594],["thread",9527313],["thread",9514914],["thread",9513523],["thread",9510442],["thread",9499106],["thread",9498738],["thread",9498734],["thread",9498723],["thread",9498720],["thread",9498717],["thread",9498710],["thread",9498705],["thread",9498699],["thread",9491079],["thread",9490111],["thread",9490110],["thread",9490108],["thread",9489798],["thread",9486661],["thread",9482344],["thread",9481388],["thread",9481381],["thread",9479969],["thread",9479955],["thread",9479902],["thread",9477760],["thread",9474092],["thread",9473999],["thread",9473984],["thread",9470063],["thread",9468196],["thread",9459922],["thread",9451494],["thread",9443893],["thread",9441975],["thread",9436803],["thread",9436496],["thread",9434488],["thread",9432943],["thread",9431471],["thread",9431378],["thread",9430433],["thread",9428785],["thread",9428776],["thread",9428768],["thread",9428748],["thread",9425920],["thread",9425683],["thread",9425016],["thread",9424689],["thread",9424592],["thread",9421978],["thread",9421976],["thread",9421970],["thread",9421969],["thread",9421326],["thread",9421316],["thread",9421084],["thread",9416333],["thread",9413349],["thread",9413348],["thread",9413347],["thread",9413344],["thread",9411766],["thread",9410676],["thread",9410636],["thread",9407765],["thread",9404585],["thread",9402110],["thread",9391057],["thread",9389145],["thread",9373351],["thread",9371725],["thread",9364340],["thread",9364338],["thread",9364309],["thread",9364197],["thread",9364005],["thread",9362710],["thread",9362705],["thread",9362695],["thread",9362688],["thread",9362673],["thread",9362666],["thread",9360203],["thread",9350437],["thread",9349474],["thread",9344642],["thread",9342753],["thread",9340236],["thread",9339942],["thread",9339934],["thread",9339927],["thread",9339924],["thread",9339907],["thread",9339246],["thread",9336527],["thread",9326622],["thread",9326620],["thread",9326619],["thread",9326616],["thread",9326614],["thread",9325239],["thread",9321579],["thread",9320038],["thread",9320032],["thread",9319474],["thread",9318469],["thread",9318467],["thread",9318459],["thread",9318444],["thread",9317913],["thread",9317351],["thread",9316856],["thread",9316851],["thread",9316848],["thread",9316845],["thread",9316830],["thread",9316820],["thread",9316584],["thread",9316572],["thread",9316563],["thread",9316309],["thread",9313636],["thread",9313633],["thread",9313630],["thread",9312942],["thread",9312935],["thread",9312934],["thread",9312933],["thread",9312921],["thread",9312919],["thread",9312866],["thread",9308011],["thread",9307081],["thread",9307068],["thread",9306675],["thread",9305523],["thread",9305172],["thread",9304682],["thread",9300737],["thread",9290955],["thread",9290109],["thread",9280874],["thread",9275228],["thread",9275212],["thread",9275202],["thread",9274966],["thread",9263087],["thread",9262250],["thread",9252088],["thread",9238187],["thread",9235283],["thread",9231689],["thread",9224111],["thread",9224086],["thread",9222985],["thread",9222868],["thread",9221474],["thread",9217603],["thread",9212385],["thread",9208888],["thread",9200658],["thread",9197968],["thread",9196403],["thread",9194747],["thread",9183542],["thread",9183540],["thread",9163996],["thread",9163811],["thread",9160577],["thread",9158591],["thread",9154219],["thread",9150841],["thread",9144382],["thread",9140567],["thread",9136259],["thread",9131011],["thread",9128350],["thread",9127210],["thread",9120965],["thread",9120020],["thread",9118000],["thread",9117949],["thread",9116989],["thread",9113066],["thread",9112202],["thread",9112198],["thread",9110388],["thread",9098999],["thread",9095546],["thread",9095527],["thread",9087319],["thread",9087060],["thread",9085666],["thread",9085300],["thread",9078845],["thread",9078313],["thread",9075260],["thread",9072609],["thread",9066796],["thread",9061393],["thread",9061295],["thread",9054252],["thread",9049378],["thread",9047690],["thread",9038417],["thread",9032253],["thread",9031082],["thread",9030449],["thread",9029812],["thread",9029391],["thread",9024648],["thread",9016927],["thread",9014877],["thread",9014713],["thread",9006309],["thread",8999848],["thread",8999662],["thread",8999351],["thread",8987578],["thread",8984172],["thread",8979110],["thread",8978487],["thread",8977159],["thread",8976003],["thread",8973120],["thread",8971760],["thread",8970051],["thread",8961428],["thread",8958967],["thread",8951186],["thread",8946713],["thread",8943924],["thread",8943853],["thread",8943727],["thread",8943432],["thread",8943415],["thread",8942872],["thread",8940111],["thread",8937893],["thread",8937240],["thread",8936325],["thread",8936104],["thread",8936056],["thread",8931787],["thread",8930717],["thread",8928606],["thread",8927994],["thread",8925645],["thread",8925489],["thread",8923721],["thread",8923684],["thread",8923502],["thread",8921493],["thread",8920985],["thread",8920510],["thread",8920353],["thread",8920348],["thread",8917138],["thread",8916541],["thread",8916437],["thread",8913699],["thread",8913697],["thread",8913695],["thread",8913639],["thread",8913632],["thread",8913538],["thread",8912533],["thread",8912077],["thread",8911665],["thread",8910364],["thread",8910363],["thread",8910358],["thread",8908003],["thread",8907607],["thread",8907517],["thread",8907511],["thread",8907510],["thread",8907498],["thread",8907157],["thread",8905541],["thread",8902983],["thread",8900025],["thread",8896395],["thread",8894377],["thread",8894153],["thread",8890998],["thread",8890832],["thread",8889773],["thread",8889669],["thread",8889394],["thread",8886043],["thread",8885169],["thread",8885132],["thread",8884946],["thread",8883002],["thread",8877153],["thread",8875093],["thread",8874957],["thread",8874240],["thread",8873244],["thread",8872134],["thread",8871222],["thread",8871199],["thread",8870570],["thread",8870119],["thread",8868345],["thread",8868108],["thread",8867542],["thread",8867541],["thread",8867538],["thread",8859256],["thread",8859247],["thread",8859138],["thread",8857717],["thread",8857706],["thread",8857697],["thread",8857686],["thread",8857668],["thread",8849298],["thread",8845954],["thread",8840090],["thread",8831567],["thread",8827266],["thread",8825539],["thread",8818817],["thread",8816710],["thread",8816119],["thread",8815981],["thread",8812173],["thread",8805558],["thread",8804009],["thread",8802295],["thread",8801766],["thread",8797828],["thread",8793393],["thread",8791331],["thread",8788148],["thread",8786228],["thread",8783763],["thread",8773551],["thread",8771417],["thread",8767168],["thread",8763582],["thread",8762844],["thread",8754813],["thread",8753130],["thread",8752148],["thread",8745569],["thread",8739965],["thread",8735124],["thread",8734174],["thread",8729973],["thread",8729177],["thread",8728942],["thread",8728928],["thread",8728922],["thread",8728919],["thread",8728918],["thread",8728916],["thread",8728766],["thread",8726224],["thread",8724237],["thread",8723828],["thread",8720012],["thread",8713847],["thread",8706593],["thread",8706242],["thread",8704948],["thread",8692178],["thread",8689336],["thread",8688353],["thread",8686809],["thread",8686795],["thread",8686763],["thread",8686389],["thread",8686240],["thread",8685564],["thread",8685557],["thread",8685548],["thread",8685524],["thread",8685001],["thread",8684925],["thread",8684620],["thread",8684125],["thread",8682736],["thread",8679395],["thread",8675414],["thread",8674189],["thread",8672690],["thread",8670938],["thread",8665019],["thread",8663938],["thread",8663931],["thread",8663926],["thread",8663923],["thread",8663922],["thread",8661530],["thread",8660196],["thread",8660193],["thread",8660189],["thread",8660181],["thread",8660174],["thread",8658276],["thread",8658256],["thread",8657848],["thread",8656405],["thread",8648165],["thread",8647329],["thread",8645953],["thread",8644724],["thread",8643377],["thread",8639106],["thread",8638168],["thread",8637421],["thread",8636359],["thread",8635987],["thread",8634971],["thread",8632459],["thread",8630710],["thread",8628524],["thread",8627653],["thread",8625849],["thread",8625658],["thread",8625657],["thread",8625654],["thread",8625651],["thread",8625449],["thread",8618700],["thread",8616933],["thread",8612021],["thread",8610184],["thread",8610026],["thread",8601801],["thread",8600681],["thread",8597829],["thread",8596949],["thread",8593348],["thread",8592887],["thread",8587811],["thread",8587486],["thread",8586456],["thread",8586406],["thread",8586270],["thread",8585990],["thread",8582777],["thread",8576779],["thread",8573667],["thread",8568517],["thread",8566882],["thread",8566178],["thread",8565581],["thread",8564834],["thread",8563342],["thread",8561775],["thread",8561532],["thread",8561410],["thread",8558655],["thread",8557013],["thread",8555666],["thread",8554607],["thread",8553773],["thread",8553723],["thread",8553136],["thread",8545849],["thread",8545824],["thread",8545410],["thread",8539338],["thread",8539016],["thread",8538283],["thread",8536431],["thread",8534827],["thread",8530968],["thread",8529340],["thread",8529079],["thread",8528481],["thread",8525799],["thread",8517905],["thread",8506769],["thread",8505890],["thread",8503065],["thread",8502797],["thread",8502012],["thread",8499095],["thread",8489775],["thread",8488080],["thread",8487616],["thread",8486026],["thread",8485298],["thread",8485090],["thread",8473574],["thread",8465529],["thread",8458817],["thread",8456988],["thread",8455453],["thread",8453149],["thread",8448414],["thread",8444522],["thread",8442792],["thread",8436696],["thread",8430876],["thread",8430380],["thread",8429655],["thread",8426557],["thread",8414287],["thread",8409040],["thread",8405337],["thread",8398639],["thread",8397077],["thread",8393613],["thread",8388827],["thread",8386454],["thread",8380671],["thread",8380543],["thread",8380148],["thread",8379171],["thread",8378839],["thread",8377899],["thread",8377842],["thread",8377509],["thread",8376619],["thread",8375448],["thread",8375405],["thread",8375333],["thread",8375276],["thread",8373386],["thread",8371003],["thread",8369651],["thread",8369331],["thread",8369310],["thread",8368015],["thread",8367862],["thread",8367343],["thread",8365186],["thread",8361703],["thread",8360838],["thread",8359444],["thread",8357717],["thread",8356252],["thread",8355194],["thread",8353807],["thread",8352307],["thread",8351990],["thread",8351404],["thread",8349867],["thread",8348480],["thread",8343714],["thread",8343480],["thread",8343472],["thread",8341506],["thread",8340210],["thread",8339874],["thread",8339811],["thread",8338038],["thread",8338023],["thread",8337840],["thread",8336291],["thread",8334806],["thread",8334103],["thread",8332186],["thread",8326827],["thread",8326129],["thread",8325815],["thread",8325429],["thread",8323874],["thread",8323768],["thread",8322675],["thread",8322056],["thread",8315012],["thread",8314498],["thread",8314244],["thread",8314242],["thread",8312129],["thread",8310515],["thread",8309477],["thread",8307210],["thread",8306409],["thread",8305750],["thread",8305304],["thread",8304954],["thread",8304244],["thread",8303462],["thread",8301677],["thread",8301607],["thread",8299325],["thread",8299318],["thread",8295117],["thread",8289344],["thread",8288391],["thread",8279211],["thread",8249259],["thread",8242747],["thread",8241941],["thread",8239284],["thread",8238260],["thread",8230440],["thread",8219925],["thread",8217554],["thread",8212094],["thread",8211952],["thread",8174964],["thread",8159437],["thread",8151184],["thread",8144943],["thread",8138567],["thread",8138551],["thread",8121434],["thread",8110715],["thread",8098563],["thread",8096830],["thread",8081767],["thread",7350307],["thread",4711394],["thread",3728480],["thread",2267393]], 691, tinhte_xentag_tag, , {"tags":["m\u00e1y in"]}, date, 0, , [], 0, 1715379231, 0d2fd258b661fda32cb45b29acca0b08
Run Time: 0.000791
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: 14
Run Time: 0.000742
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 (9971541, 9941755, 9925114, 9880005, 9850436, 9813723, 9778594, 9778589, 9778583, 9774790, 9759045, 9759008, 9758985, 9758887, 9758872, 9758836, 9758817, 9758784, 9758763)
Run Time: 0.001600
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: 3001
Run Time: 0.000306
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=m%C3%A1y+in, 1715379231,
Run Time: 0.000291
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000248
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 > 1715378331)
ORDER BY session_activity.view_date DESC
Run Time: 0.003503
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 1664 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |