SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000266
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 = 'đồ chơi thông minh')
Run Time: 0.000521
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: 63278941
Run Time: 0.000309
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: 28
Run Time: 0.000583
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, 28
Run Time: 0.000188
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 (9693583, 9693578, 9693575, 9693571, 9692513, 9692099, 9687177, 9685880, 9685879, 9685877, 9685876, 9685875, 9685874, 9685873, 9685872, 9685871, 9685870, 9685867, 9685865, 9682622, 9680557, 9680199, 9668218, 9668134, 9668133, 9661709, 9645323, 9622931, 9622919, 9600041, 9594180, 9582977, 9580014, 9561966, 9560000, 9559154, 9557607, 9557606, 9555058, 9553122, 9551334, 9549861, 9549860, 9549859, 9549531, 9542850, 9539932, 9538988, 9538987, 9538986, 9536013, 9534036, 9533884, 9533883, 9530118, 9528252, 9528251, 9528133, 9528132, 9527136, 9523986, 9522613, 9521972, 9521971, 9520888, 9520886, 9519707, 9516847, 9516846, 9515694, 9514310, 9513900, 9510869, 9509065, 9509064, 9507699, 9506348, 9504807, 9500246, 9499592, 9499499, 9498023, 9493121, 9492085, 9491093, 9489126, 9488841, 9486017, 9485393, 9483725, 9481317, 9481020, 9479152, 9479150, 9478744, 9475340, 9474114, 9473274, 9472601, 9466722, 9460493, 9460492, 9459665, 9459664, 9459663, 9459276, 9456946, 9456945, 9456184, 9456180, 9452033, 9451369, 9451360, 9451358, 9450497, 9450232, 9447119, 9445476, 9442998, 9442997, 9442414, 9442159, 9440654, 9437384, 9436422, 9432705, 9430987, 9430986, 9426799, 9426388, 9426386, 9426380, 9425036, 9423493, 9421434, 9413979, 9412486, 9412485, 9412481, 9412479, 9411385, 9411377, 9411376, 9411150, 9409803, 9409765, 9409103, 9407646, 9407644, 9401682, 9401681, 9401676, 9401659, 9400998, 9399379, 9398601, 9398256, 9396856, 9389636, 9389563, 9389562, 9387428, 9386561, 9386558, 9385784, 9384886, 9384801, 9380527, 9380236, 9379161, 9379131, 9377505, 9377504, 9374475, 9374228, 9373608, 9373038, 9371796, 9369057, 9369056, 9367938, 9366001, 9365993, 9363745, 9361984, 9360980, 9360691, 9360620, 9360592, 9360591, 9360589, 9359642, 9359042, 9358733, 9358590, 9358575, 9358574, 9358035, 9357711, 9357374, 9357359, 9356476, 9355990, 9355741, 9353745, 9353598, 9352874, 9352271, 9351586, 9351272, 9351271, 9349676, 9349315, 9348523, 9348522, 9346232, 9339110, 9338917, 9338916, 9336313, 9335616, 9335202, 9334007, 9326512, 9325706, 9319172, 9318431, 9314930, 9314929, 9312689, 9311896, 9308335, 9306027, 9303134, 9303133, 9302668, 9301559, 9301023, 9301021, 9301020, 9300128, 9299808, 9299807, 9294703, 9293351, 9293350, 9293046, 9292850, 9288320, 9286137, 9285275, 9280771, 9278710, 9276926, 9275738, 9275735, 9274707, 9273513, 9273343, 9273291, 9271218, 9270565, 9270036, 9266273, 9264358, 9258909, 9258908, 9257283, 9257281, 9255972, 9255971, 9253512, 9252086, 9251063, 9250122, 9248747, 9248449, 9248019, 9239365, 9239341, 9238634, 9236997, 9236706, 9234446, 9234162, 9234161, 9233316, 9231466, 9231463, 9230943, 9230323, 9230322, 9230321, 9230319, 9230314, 9230300, 9230299, 9228742, 9228093, 9218732, 9213098, 9206110, 9205604, 9203485, 9202782, 9190434, 9190431, 9190188, 9188764, 9188762, 9187032, 9184998, 9184990, 9184496, 9183603, 9183602, 9182026, 9182017, 9182014, 9180354, 9180014, 9179990, 9176857, 9176855, 9176853, 9175832, 9174661, 9169778, 9169284, 9164775, 9164179, 9164137, 9163602, 9162896, 9161785, 9161747, 9158922, 9157471, 9157470, 9153373, 9151647, 9151646, 9150923, 9150365, 9149821, 9148546, 9147551, 9147173, 9147055, 9147028, 9146715, 9146258, 9146253, 9146234, 9146218, 9145134, 9145084, 9145069, 9145037, 9145019, 9144982, 9144981, 9144803, 9144777, 9144776, 9144773, 9144770, 9144768, 9144764, 9144092, 9144091, 9140992, 9140805, 9140804, 9140408, 9139995, 9138164, 9138002, 9137095, 9136123, 9136031, 9134761, 9134003, 9134000, 9133999, 9133038, 9131423, 9131213, 9131200, 9129644, 9129617, 9129610, 9128506, 9127997, 9125511, 9125437, 9123577, 9123576, 9122809, 9122066, 9121155, 9121154, 9121153, 9120721, 9120472, 9120009, 9119981, 9119721, 9119551, 9119423, 9118167, 9117969, 9117862, 9116816, 9114963, 9114818, 9113067, 9112326, 9112324, 9111312, 9110969, 9110968, 9110967, 9110149, 9109651, 9109628, 9107954, 9107951, 9107240, 9106707, 9106706, 9105124, 9103415, 9099790, 9098571, 9098568, 9098219, 9098218, 9097978, 9092153, 9091450, 9091443, 9091442, 9090019, 9090011, 9089999, 9089713, 9087706, 9087259, 9085983, 9085939, 9085030, 9084227, 9083367, 9082253, 9081701, 9081673, 9080312, 9080082, 9078991, 9078506, 9077966, 9077921, 9077860, 9074728, 9070221, 9069917, 9068969, 9067985, 9062589, 9052576, 9051703, 9051621, 9049992, 9049922, 9047069, 9047068, 9046617, 9046275, 9046271, 9046270, 9046269, 9046268, 9046159, 9045048, 9044354, 9044353, 9044266, 9044256, 9043521, 9043123, 9042847, 9042392, 9041285, 9041081, 9040182, 9038259, 9038256, 9036244, 9036242, 9035572, 9035481, 9034689, 9032498, 9032497, 9031914, 9031284, 9031278, 9031229, 9029868, 9029598, 9027286, 9027024, 9022566, 9022110, 9021989, 9021978, 9021971, 9021228, 9020754, 9020126, 9018030, 9017419, 9017405, 9016128, 9015555, 9014492, 9012013, 9011203, 9008599, 9004924, 9004887, 9004830, 9003225, 8997858, 8997856, 8997630, 8995432, 8994941, 8994938, 8992213, 8992212, 8990536, 8986734, 8981325, 8980195, 8978741, 8977839, 8977838, 8977236, 8975741, 8975734, 8975663, 8975517, 8975508, 8975498, 8975496, 8973988, 8973987, 8971274, 8971273, 8969883, 8969836, 8969831, 8969827, 8969813, 8968830, 8968161, 8968160, 8968159, 8967650, 8967647, 8967645, 8967333, 8967332, 8965388, 8963328, 8962513, 8961355, 8958598, 8955145, 8955141, 8955139, 8955137, 8955134, 8955132, 8955129, 8955127, 8952207, 8949748, 8947684, 8946983, 8946967, 8946955, 8946931, 8944702, 8943427, 8942942, 8942381, 8941820, 8940296, 8940118, 8939067, 8939006, 8938347, 8938136, 8937219, 8936799, 8936798, 8935934, 8934851, 8933259, 8933123, 8931115, 8931007, 8931006, 8931005, 8928218, 8928189, 8927480, 8926288, 8926284, 8925486, 8923436, 8923156, 8922522, 8922301, 8922096, 8921332, 8920859, 8920355, 8918407, 8916977, 8916976, 8916664, 8915276, 8915266, 8914934, 8914921, 8914295, 8914209, 8914065, 8913670, 8913375, 8913177, 8912852, 8912553, 8912331, 8912325, 8912308, 8912261, 8912247, 8912238, 8912083, 8911690, 8911689, 8911688, 8911687, 8910752, 8910746, 8910716, 8910600, 8909764, 8907900, 8907037, 8906730, 8906210, 8903510, 8903374, 8903057, 8902643, 8902082, 8901607, 8901606, 8901604, 8901520, 8901508, 8898923, 8898922, 8898049, 8897640, 8897040, 8896093, 8895540, 8895449, 8895307, 8894871, 8894342, 8893867, 8893856, 8891727, 8891557, 8889378, 8889238, 8887856, 8887836, 8887466, 8887465, 8887270, 8886906, 8886905, 8886561, 8885425, 8884176, 8883809, 8883723, 8882923, 8882089, 8881802, 8881594, 8881351, 8881350, 8880805, 8880804, 8880802, 8880799, 8880798, 8880797, 8880796, 8880795, 8875690, 8875144, 8875143, 8873879, 8872441, 8871188, 8870960, 8869935, 8869753, 8869752, 8869744, 8869444, 8868443, 8867466, 8867465, 8867464, 8866806, 8866805, 8866803, 8866799, 8866798, 8865245, 8865234, 8864981, 8864527, 8864050, 8863154, 8862995, 8862036, 8860938, 8860555, 8860343, 8860342, 8859312, 8859259, 8857515, 8857509, 8857040, 8856266, 8856260, 8856033, 8854563, 8854480, 8853681, 8853680, 8852867, 8852178, 8852177, 8852175, 8851346, 8850833, 8850832, 8849698, 8849662, 8849511, 8849510, 8849482, 8849245, 8849244, 8849160, 8849086, 8848702, 8848412, 8848411, 8847941, 8847021, 8846155, 8846154, 8845500, 8844912, 8844777, 8844080, 8843864, 8841510, 8840389, 8840388, 8840387, 8840236, 8838946, 8838943, 8838942, 8838328, 8838196, 8837259, 8835829, 8835052, 8834578, 8833443, 8832758, 8832452, 8830917, 8830915, 8830840, 8830682, 8829634, 8828608, 8827274, 8826750, 8826684, 8826668, 8826665, 8825109, 8824191, 8824090, 8823502, 8822971, 8822877, 8822769, 8821880, 8821651, 8821648, 8821364, 8821158, 8820738, 8818587, 8818171, 8818170, 8818075, 8814915, 8814443, 8814442, 8814433, 8813890, 8813889, 8813888, 8813639, 8811075, 8810463, 8810169, 8810167, 8810166, 8810164, 8810163, 8810162, 8810159, 8809753, 8809053, 8808985, 8808442, 8808440, 8808437, 8807645, 8806970, 8806969, 8806967, 8806889, 8806386, 8805911, 8805597, 8805596, 8805488, 8804480, 8804472, 8802513, 8802194, 8801328, 8800268, 8795820, 8795596, 8795103, 8794769, 8794767, 8794363, 8790937, 8788226, 8788171, 8787263, 8786767, 8785759, 8783977, 8778073, 8778064, 8777912, 8777654, 8777652, 8777650, 8777532, 8777245, 8776195, 8776142, 8775585, 8775385, 8774923, 8774466, 8773618, 8772944, 8771667, 8770776, 8770310, 8769638, 8769635, 8769240, 8767419, 8766897, 8766703, 8766513, 8765069, 8764886, 8764494, 8761926, 8761899, 8761898, 8761835, 8761047, 8758535, 8757264, 8757252, 8756519, 8756518, 8756496, 8755791, 8754550, 8753453, 8752155, 8751708, 8751305, 8750576, 8750572, 8749688, 8746477, 8744904, 8744669, 8743990, 8742928, 8742621, 8740184, 8740052, 8738718, 8738545, 8737798, 8736012, 8735099, 8733158, 8732561, 8731157, 8730608, 8728689, 8727225, 8727224, 8726172, 8725354, 8723965, 8721045, 8719656, 8719101, 8719098, 8719097, 8718678, 8718654, 8716831, 8716062, 8716061, 8715767, 8715766, 8715710, 8715709, 8715708, 8715688, 8715679, 8715678, 8714618, 8714160, 8713940, 8713717, 8713338, 8713331, 8712913, 8711533, 8711532, 8710903, 8709059, 8707137, 8706845, 8706766, 8704754, 8704266, 8702054, 8700663, 8699493, 8698326, 8698101, 8696437, 8695004, 8692692, 8690615, 8689875, 8689821, 8689797, 8689748, 8689747, 8689746, 8689642, 8689060, 8688322, 8688321, 8687119, 8687097, 8686969, 8686670, 8684440, 8682710, 8680308, 8679970, 8679326, 8677290, 8676627, 8676459, 8676118, 8675458, 8675053, 8674725, 8674485, 8672260, 8672053, 8671513, 8671141, 8671128, 8669829, 8669068, 8669066, 8668480, 8668069, 8662626, 8662625, 8660176, 8659675, 8658380, 8658378, 8654263, 8652657, 8650872, 8650059, 8649628, 8641301, 8640909, 8635939, 8633209, 8632901, 8630739, 8630724, 8630037, 8625001, 8622751, 8619130, 8618580, 8618579, 8618292, 8618003, 8616466, 8615295, 8613226, 8610556, 8607771, 8607045, 8606811, 8605824, 8605800, 8602597, 8601783, 8598937, 8596180, 8581860, 8580340, 8580171, 8579390, 8579229, 8578012, 8577620, 8577035, 8575950, 8575009, 8574570, 8574569, 8572861, 8572237, 8570766, 8570265, 8568868, 8567644, 8566570, 8566440, 8565882, 8565363, 8565361, 8565359, 8563933, 8561703, 8561471, 8561194, 8560123, 8560122, 8559216, 8556865, 8556864, 8556084, 8553618, 8552307, 8547925, 8547274, 8546408, 8544546, 8543872, 8543613, 8539974, 8535077, 8533665, 8533384, 8532741, 8532396, 8532271, 8530526, 8530027, 8527909, 8527624, 8527594, 8526863, 8526586, 8526582, 8524801, 8524797, 8521665, 8521494, 8520793, 8520785, 8520136, 8512793, 8512122, 8511938, 8510752, 8491874, 8491812, 8490580, 8487181, 8486756, 8484864, 8484045, 8482335, 8481523, 8451850, 8451666, 8443885, 8440533, 8434947, 8434209, 8428964, 8427114, 8421694, 8410764, 8410700, 8409343, 8409319, 8408397, 8404126, 8402945, 8400659, 8370974, 8369502, 8364340, 8363866, 8360750, 8354691, 8352846, 8351904, 8351767, 8351762, 8351761, 8349465, 8347684, 8347616, 8347587, 8347316, 8347235, 8347099, 8347010, 8346960, 8346285, 8295924, 8293555, 8267134, 8256811, 8252061, 8244811, 8244455, 8244043, 8243437, 8218206, 8216850, 8172046, 8139198, 8136165, 8009506, 7824999, 7794923, 7756285, 7736924, 7693111, 7580218, 7473431, 7204500, 7181994, 7171563, 7003212, 6973630, 6829525, 6829478, 5775363, 1987520)
Run Time: 0.036133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1227 | |
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 | | | | | 1227 | |
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: 28
Run Time: 0.000718
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",28],["thread",9693583],["thread",9693578],["thread",9693575],["thread",9693571],["thread",9692513],["thread",9692099],["thread",9685880],["thread",9685879],["thread",9685877],["thread",9685876],["thread",9685875],["thread",9685874],["thread",9685873],["thread",9685872],["thread",9685871],["thread",9685870],["thread",9685867],["thread",9685865],["thread",9682622],["thread",9668218],["thread",9668134],["thread",9661709],["thread",9645323],["thread",9622931],["thread",9622919],["thread",9600041],["thread",9594180],["thread",9580014],["thread",9561966],["thread",9560000],["thread",9559154],["thread",9557607],["thread",9555058],["thread",9553122],["thread",9551334],["thread",9549861],["thread",9549531],["thread",9539932],["thread",9538988],["thread",9536013],["thread",9534036],["thread",9533884],["thread",9530118],["thread",9528252],["thread",9528133],["thread",9527136],["thread",9523986],["thread",9522613],["thread",9521972],["thread",9520888],["thread",9519707],["thread",9516847],["thread",9515694],["thread",9514310],["thread",9513900],["thread",9509065],["thread",9507699],["thread",9506348],["thread",9504807],["thread",9500246],["thread",9499592],["thread",9499499],["thread",9492085],["thread",9491093],["thread",9489126],["thread",9486017],["thread",9485393],["thread",9483725],["thread",9478744],["thread",9475340],["thread",9472601],["thread",9460493],["thread",9459665],["thread",9459276],["thread",9456946],["thread",9451369],["thread",9450497],["thread",9442998],["thread",9442414],["thread",9440654],["thread",9437384],["thread",9436422],["thread",9432705],["thread",9430987],["thread",9426388],["thread",9426386],["thread",9426380],["thread",9421434],["thread",9413979],["thread",9411385],["thread",9409765],["thread",9409103],["thread",9401676],["thread",9400998],["thread",9399379],["thread",9398601],["thread",9398256],["thread",9396856],["thread",9389636],["thread",9386561],["thread",9386558],["thread",9385784],["thread",9384886],["thread",9384801],["thread",9380236],["thread",9379161],["thread",9374228],["thread",9373608],["thread",9369057],["thread",9366001],["thread",9365993],["thread",9363745],["thread",9361984],["thread",9360980],["thread",9360691],["thread",9360620],["thread",9360592],["thread",9359642],["thread",9359042],["thread",9358733],["thread",9358590],["thread",9358575],["thread",9358035],["thread",9357711],["thread",9357374],["thread",9357359],["thread",9355741],["thread",9352271],["thread",9351586],["thread",9351272],["thread",9351271],["thread",9349315],["thread",9346232],["thread",9334007],["thread",9326512],["thread",9325706],["thread",9319172],["thread",9318431],["thread",9314930],["thread",9311896],["thread",9306027],["thread",9301023],["thread",9299808],["thread",9293046],["thread",9288320],["thread",9280771],["thread",9278710],["thread",9276926],["thread",9275738],["thread",9275735],["thread",9273513],["thread",9273343],["thread",9273291],["thread",9270565],["thread",9270036],["thread",9266273],["thread",9255972],["thread",9250122],["thread",9239341],["thread",9236706],["thread",9234446],["thread",9233316],["thread",9231466],["thread",9228742],["thread",9228093],["thread",9213098],["thread",9205604],["thread",9203485],["thread",9202782],["thread",9190434],["thread",9190188],["thread",9184998],["thread",9184990],["thread",9184496],["thread",9183603],["thread",9175832],["thread",9174661],["thread",9169778],["thread",9169284],["thread",9163602],["thread",9162896],["thread",9161785],["thread",9161747],["thread",9157471],["thread",9153373],["thread",9151647],["thread",9150923],["thread",9150365],["thread",9149821],["thread",9147551],["thread",9147173],["thread",9147055],["thread",9147028],["thread",9146715],["thread",9146258],["thread",9146253],["thread",9144803],["thread",9138164],["thread",9136123],["thread",9136031],["thread",9129644],["thread",9129617],["thread",9129610],["thread",9127997],["thread",9123577],["thread",9121155],["thread",9117969],["thread",9117862],["thread",9116816],["thread",9114818],["thread",9112326],["thread",9110969],["thread",9109628],["thread",9107954],["thread",9107951],["thread",9107240],["thread",9106707],["thread",9105124],["thread",9099790],["thread",9098571],["thread",9098219],["thread",9092153],["thread",9091450],["thread",9091443],["thread",9091442],["thread",9090019],["thread",9090011],["thread",9089999],["thread",9085939],["thread",9085030],["thread",9081673],["thread",9080312],["thread",9077966],["thread",9077921],["thread",9074728],["thread",9070221],["thread",9069917],["thread",9068969],["thread",9067985],["thread",9062589],["thread",9052576],["thread",9051703],["thread",9051621],["thread",9049922],["thread",9047069],["thread",9044266],["thread",9044256],["thread",9043521],["thread",9042392],["thread",9041285],["thread",9041081],["thread",9040182],["thread",9036244],["thread",9032498],["thread",9031914],["thread",9031284],["thread",9031278],["thread",9031229],["thread",9029868],["thread",9027024],["thread",9021989],["thread",9021978],["thread",9021971],["thread",9020754],["thread",9018030],["thread",9017419],["thread",9017405],["thread",9014492],["thread",9012013],["thread",9011203],["thread",9008599],["thread",9004924],["thread",9003225],["thread",8995432],["thread",8992213],["thread",8986734],["thread",8978741],["thread",8975508],["thread",8973988],["thread",8969883],["thread",8968830],["thread",8967333],["thread",8961355],["thread",8958598],["thread",8955134],["thread",8952207],["thread",8949748],["thread",8947684],["thread",8943427],["thread",8942942],["thread",8940118],["thread",8939006],["thread",8938347],["thread",8938136],["thread",8937219],["thread",8936799],["thread",8931115],["thread",8931007],["thread",8928218],["thread",8927480],["thread",8926284],["thread",8925486],["thread",8923436],["thread",8918407],["thread",8916977],["thread",8916664],["thread",8915276],["thread",8915266],["thread",8914295],["thread",8913670],["thread",8913375],["thread",8912331],["thread",8912325],["thread",8912308],["thread",8911690],["thread",8910752],["thread",8910746],["thread",8910600],["thread",8906730],["thread",8903510],["thread",8902643],["thread",8898923],["thread",8895449],["thread",8894342],["thread",8891727],["thread",8887856],["thread",8887836],["thread",8885425],["thread",8884176],["thread",8883723],["thread",8880802],["thread",8875690],["thread",8873879],["thread",8872441],["thread",8871188],["thread",8870960],["thread",8866806],["thread",8865245],["thread",8865234],["thread",8862036],["thread",8859259],["thread",8857515],["thread",8857509],["thread",8857040],["thread",8856033],["thread",8854563],["thread",8854480],["thread",8852178],["thread",8851346],["thread",8849662],["thread",8848412],["thread",8847941],["thread",8847021],["thread",8844080],["thread",8841510],["thread",8838328],["thread",8837259],["thread",8835829],["thread",8832758],["thread",8832452],["thread",8830840],["thread",8829634],["thread",8826668],["thread",8824191],["thread",8822877],["thread",8821880],["thread",8821158],["thread",8818171],["thread",8814443],["thread",8814433],["thread",8813890],["thread",8811075],["thread",8810463],["thread",8808985],["thread",8808442],["thread",8806967],["thread",8806889],["thread",8805597],["thread",8805488],["thread",8804480],["thread",8802194],["thread",8801328],["thread",8800268],["thread",8795820],["thread",8795596],["thread",8794363],["thread",8790937],["thread",8788226],["thread",8787263],["thread",8786767],["thread",8785759],["thread",8777912],["thread",8777654],["thread",8777532],["thread",8777245],["thread",8775385],["thread",8774923],["thread",8772944],["thread",8771667],["thread",8770776],["thread",8769638],["thread",8769240],["thread",8766513],["thread",8765069],["thread",8764886],["thread",8761835],["thread",8761047],["thread",8758535],["thread",8757264],["thread",8752155],["thread",8751305],["thread",8750572],["thread",8746477],["thread",8744669],["thread",8742621],["thread",8740052],["thread",8738545],["thread",8737798],["thread",8736012],["thread",8730608],["thread",8728689],["thread",8726172],["thread",8725354],["thread",8723965],["thread",8719101],["thread",8718678],["thread",8718654],["thread",8716831],["thread",8716062],["thread",8715679],["thread",8714618],["thread",8714160],["thread",8713940],["thread",8713717],["thread",8713338],["thread",8713331],["thread",8707137],["thread",8706766],["thread",8704754],["thread",8704266],["thread",8699493],["thread",8698326],["thread",8698101],["thread",8695004],["thread",8692692],["thread",8690615],["thread",8689875],["thread",8689821],["thread",8689060],["thread",8688322],["thread",8688321],["thread",8687119],["thread",8687097],["thread",8686670],["thread",8679326],["thread",8677290],["thread",8676627],["thread",8676459],["thread",8676118],["thread",8675458],["thread",8675053],["thread",8674725],["thread",8674485],["thread",8672260],["thread",8672053],["thread",8671513],["thread",8669829],["thread",8669068],["thread",8668069],["thread",8662626],["thread",8660176],["thread",8659675],["thread",8658380],["thread",8652657],["thread",8650872],["thread",8650059],["thread",8649628],["thread",8641301],["thread",8640909],["thread",8635939],["thread",8633209],["thread",8632901],["thread",8630739],["thread",8630724],["thread",8630037],["thread",8625001],["thread",8618580],["thread",8618292],["thread",8616466],["thread",8615295],["thread",8613226],["thread",8610556],["thread",8607045],["thread",8606811],["thread",8605824],["thread",8605800],["thread",8602597],["thread",8601783],["thread",8598937],["thread",8581860],["thread",8580340],["thread",8580171],["thread",8579390],["thread",8579229],["thread",8578012],["thread",8577620],["thread",8577035],["thread",8575950],["thread",8575009],["thread",8570766],["thread",8570265],["thread",8568868],["thread",8567644],["thread",8566570],["thread",8566440],["thread",8565882],["thread",8565363],["thread",8563933],["thread",8561703],["thread",8561471],["thread",8561194],["thread",8560123],["thread",8559216],["thread",8556865],["thread",8556084],["thread",8552307],["thread",8547925],["thread",8547274],["thread",8546408],["thread",8544546],["thread",8543613],["thread",8539974],["thread",8535077],["thread",8533665],["thread",8533384],["thread",8532741],["thread",8530526],["thread",8530027],["thread",8527909],["thread",8527624],["thread",8527594],["thread",8526863],["thread",8526586],["thread",8524801],["thread",8524797],["thread",8521665],["thread",8521494],["thread",8520793],["thread",8520785],["thread",8520136],["thread",8512793],["thread",8512122],["thread",8511938],["thread",8510752],["thread",8491874],["thread",8491812],["thread",8490580],["thread",8487181],["thread",8486756],["thread",8484864],["thread",8484045],["thread",8482335],["thread",8481523],["thread",8451850],["thread",8451666],["thread",8440533],["thread",8434947],["thread",8434209],["thread",8428964],["thread",8427114],["thread",8421694],["thread",8410764],["thread",8410700],["thread",8409343],["thread",8409319],["thread",8408397],["thread",8404126],["thread",8402945],["thread",8400659],["thread",8370974],["thread",8369502],["thread",8364340],["thread",8363866],["thread",8354691],["thread",8352846],["thread",8351904],["thread",8351767],["thread",8351762],["thread",8349465],["thread",8347684],["thread",8347616],["thread",8347587],["thread",8347316],["thread",8347235],["thread",8347099],["thread",8347010],["thread",8346960],["thread",8346285],["thread",8295924],["thread",8267134],["thread",8256811],["thread",8252061],["thread",8244811],["thread",8244455],["thread",8244043],["thread",8218206],["thread",8216850],["thread",8139198],["thread",8136165],["thread",8009506],["thread",7824999],["thread",7794923],["thread",7756285],["thread",7736924],["thread",7693111],["thread",7580218],["thread",7473431],["thread",7204500],["thread",7003212],["thread",6973630],["thread",6829525],["thread",6829478],["thread",5775363],["thread",1987520]], 625, tinhte_xentag_tag, , {"tags":["\u0111\u1ed3 ch\u01a1i th\u00f4ng minh"]}, date, 0, , [], 0, 1660626511, 3439c4307b55fc5cee7ca0050e673001
Run Time: 0.000866
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 (9500246, 9499592, 9499499, 9492085, 9491093, 9489126, 9486017, 9485393, 9483725, 9478744, 9475340, 9472601, 9460493, 9459665, 9459276, 9456946, 9451369, 9450497, 9442998, 9442414)
Run Time: 0.001843
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 20 | 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: 512692
Run Time: 0.001001
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=%C4%91%E1%BB%93+ch%C6%A1i+th%C3%B4ng+minh&page=4, 1660626511,
Run Time: 0.000371
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000258
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 > 1660625611)
ORDER BY session_activity.view_date DESC
Run Time: 0.000894
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 3099 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |