SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000871
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 = 'phụ kiện iphone')
Run Time: 0.000534
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ref | tag_text | tag_text | 302 | const | 3 | Using index condition |
SELECT *
FROM xf_search
WHERE search_id = ?
Params: 45506114
Run Time: 0.000316
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: 140
Run Time: 0.000825
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, 140
Run Time: 0.000185
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 (9675809, 9674235, 9673058, 9673057, 9672247, 9670456, 9667180, 9667177, 9666929, 9666507, 9666506, 9666505, 9666504, 9666503, 9665248, 9661174, 9657656, 9656923, 9653461, 9652957, 9652956, 9652955, 9650219, 9649534, 9648804, 9648452, 9647015, 9642326, 9642218, 9641581, 9638288, 9637905, 9637335, 9637334, 9637307, 9637305, 9637267, 9636594, 9636268, 9636266, 9636265, 9635682, 9635341, 9634639, 9634481, 9632321, 9632320, 9631188, 9631138, 9631124, 9626902, 9626628, 9626627, 9624855, 9624854, 9623141, 9622071, 9621340, 9616651, 9616649, 9616510, 9616180, 9615929, 9614815, 9614814, 9613257, 9603719, 9603001, 9599620, 9598459, 9597154, 9597153, 9595978, 9593901, 9593900, 9592336, 9592100, 9592091, 9591700, 9591686, 9591675, 9591674, 9591672, 9590805, 9588649, 9588648, 9588647, 9586262, 9586208, 9580672, 9579800, 9575443, 9573157, 9571772, 9571195, 9571158, 9570439, 9570401, 9570366, 9569941, 9568804, 9567302, 9567195, 9567194, 9565549, 9565420, 9565388, 9565282, 9564581, 9563745, 9562239, 9559427, 9559298, 9559293, 9558832, 9556964, 9556963, 9556797, 9556781, 9556770, 9556606, 9556605, 9555500, 9554969, 9552008, 9551909, 9551908, 9550957, 9550751, 9549498, 9540918, 9540904, 9537060, 9536809, 9536632, 9535623, 9534835, 9533782, 9533073, 9532828, 9531746, 9529649, 9529414, 9527752, 9527748, 9526159, 9525742, 9525065, 9524845, 9524346, 9523142, 9522956, 9522955, 9522878, 9522218, 9521769, 9520630, 9520520, 9520126, 9519484, 9519275, 9519244, 9518177, 9517666, 9517230, 9517227, 9517225, 9514660, 9513569, 9512791, 9512734, 9508797, 9508795, 9508688, 9508325, 9505285, 9504738, 9503617, 9503610, 9503607, 9503604, 9503601, 9503598, 9503596, 9503593, 9503580, 9503575, 9503570, 9503565, 9503058, 9503020, 9501020, 9500862, 9500684, 9500682, 9499147, 9499061, 9498263, 9496825, 9496635, 9496618, 9494766, 9494284, 9494062, 9494045, 9494043, 9494035, 9494034, 9494033, 9494032, 9493511, 9491096, 9490449, 9488828, 9485494, 9483142, 9482659, 9481987, 9481387, 9481165, 9480856, 9480784, 9480650, 9478239, 9474497, 9471976, 9471859, 9470393, 9469364, 9468757, 9467895, 9467814, 9467775, 9467479, 9467279, 9466681, 9464917, 9463865, 9463864, 9461880, 9461480, 9461366, 9461347, 9460920, 9460918, 9460727, 9460078, 9459623, 9459479, 9458694, 9454803, 9448299, 9447205, 9445794, 9445766, 9445407, 9444171, 9442212, 9442065, 9441924, 9441874, 9441868, 9441510, 9440977, 9440192, 9437895, 9437815, 9437689, 9437533, 9437117, 9437115, 9437061, 9436328, 9436181, 9435977, 9434951, 9434386, 9434090, 9434089, 9433360, 9433337, 9432024, 9431861, 9431528, 9428956, 9428676, 9428574, 9427133, 9426670, 9425224, 9424849, 9424812, 9424006, 9422150, 9422144, 9421552, 9420540, 9419135, 9419130, 9419054, 9418722, 9418389, 9417681, 9417118, 9415216, 9415214, 9415211, 9414416, 9413106, 9412621, 9412189, 9411402, 9410768, 9409788, 9409787, 9409267, 9408999, 9408995, 9408608, 9408236, 9407721, 9407635, 9407620, 9407228, 9407226, 9407184, 9407005, 9406969, 9406939, 9406615, 9405801, 9405563, 9404963, 9402735, 9402733, 9401668, 9399609, 9398585, 9397308, 9396864, 9396643, 9396642, 9396067, 9395077, 9394906, 9394764, 9392307, 9391297, 9390357, 9390321, 9389815, 9389292, 9389290, 9389063, 9388521, 9387846, 9387587, 9387243, 9386521, 9386520, 9386519, 9385451, 9385450, 9382954, 9382866, 9380631, 9380630, 9380327, 9377553, 9374524, 9374094, 9374093, 9373621, 9372836, 9368942, 9368581, 9366866, 9364452, 9364294, 9362730, 9362335, 9361660, 9361039, 9360305, 9359988, 9359377, 9358410, 9357465, 9357273, 9356801, 9356783, 9354978, 9354976, 9354117, 9354114, 9349513, 9349400, 9349397, 9349147, 9346269, 9344113, 9342496, 9341969, 9341017, 9340697, 9339673, 9339546, 9339284, 9338552, 9338278, 9336430, 9336429, 9336397, 9334373, 9333934, 9333363, 9333293, 9331070, 9329974, 9329752, 9329681, 9329523, 9328723, 9325354, 9325209, 9323317, 9322027, 9322026, 9321792, 9321248, 9321247, 9320393, 9320340, 9320339, 9319503, 9319203, 9319202, 9319200, 9318437, 9318131, 9317393, 9317391, 9315536, 9315189, 9315064, 9315045, 9315027, 9315002, 9314931, 9313690, 9313071, 9312719, 9312647, 9311982, 9311008, 9307780, 9306709, 9306592, 9306588, 9306475, 9306290, 9303573, 9303246, 9301811, 9298663, 9297204, 9295679, 9294991, 9294987, 9294411, 9294115, 9294111, 9293687, 9293013, 9291093, 9290393, 9288311, 9287198, 9286563, 9286562, 9285527, 9284595, 9283863, 9283830, 9283754, 9283493, 9282413, 9281404, 9281343, 9280616, 9276132, 9276131, 9276008, 9275467, 9274567, 9271356, 9271079, 9271078, 9271077, 9269843, 9267543, 9265813, 9264303, 9263422, 9262856, 9262282, 9260460, 9260445, 9260328, 9259115, 9257474, 9255097, 9254983, 9254959, 9254471, 9254059, 9254025, 9252023, 9249282, 9249280, 9248038, 9247599, 9245849, 9244892, 9242625, 9240319, 9236878, 9235892, 9235393, 9232372, 9232287, 9231048, 9231047, 9227817, 9226676, 9225074, 9225073, 9222100, 9221778, 9212000, 9210563, 9203611, 9202965, 9200371, 9200264, 9199378, 9198823, 9198466, 9198257, 9197731, 9197664, 9196887, 9190072, 9188194, 9188193, 9186519, 9186516, 9185823, 9185455, 9185207, 9182886, 9182819, 9179623, 9179591, 9178968, 9178682, 9176959, 9176188, 9175399, 9172699, 9172392, 9171707, 9169819, 9169818, 9169366, 9169365, 9166504, 9165962, 9165804, 9164167, 9161705, 9160509, 9159507, 9157241, 9157236, 9157235, 9157233, 9156730, 9155015, 9154454, 9152569, 9152567, 9152565, 9152200, 9151753, 9150356, 9149034, 9146859, 9145954, 9145910, 9145569, 9141219, 9135737, 9134679, 9133174, 9130591, 9130125, 9130009, 9129997, 9129943, 9129825, 9129816, 9129803, 9129788, 9129772, 9129764, 9129760, 9129756, 9129753, 9129740, 9125823, 9123179, 9121215, 9121214, 9119730, 9119506, 9119504, 9117867, 9117543, 9117518, 9116967, 9116832, 9116452, 9115221, 9114302, 9113498, 9112406, 9112368, 9112250, 9112249, 9111731, 9111726, 9111721, 9111716, 9111708, 9111686, 9109637, 9109626, 9109617, 9108858, 9108334, 9108323, 9107969, 9106189, 9105089, 9099013, 9096255, 9095948, 9095702, 9094896, 9094354, 9093527, 9092718, 9092717, 9089665, 9088664, 9088661, 9088111, 9087717, 9087502, 9086190, 9086171, 9086169, 9083520, 9083514, 9083481, 9083433, 9082314, 9081532, 9081067, 9080471, 9079316, 9079308, 9079236, 9079227, 9078641, 9077505, 9076961, 9075068, 9073687, 9071865, 9066589, 9066576, 9065882, 9064681, 9061932, 9061931, 9061169, 9060956, 9058848, 9058260, 9057235, 9051041, 9050474, 9050473, 9050295, 9050175, 9049251, 9046863, 9044149, 9043929, 9043928, 9043926, 9043925, 9043923, 9043614, 9043578, 9042337, 9039861, 9038159, 9038131, 9038121, 9038084, 9037985, 9037220, 9035119, 9030961, 9030959, 9030343, 9028899, 9028766, 9028544, 9028162, 9027034, 9026793, 9026384, 9023680, 9023641, 9023574, 9021753, 9020878, 9019362, 9016285, 9016053, 9013759, 9012465, 9010687, 9010686, 9010684, 9009373, 9009372, 9007771, 9006364, 9004904, 9001910, 9001891, 9000551, 8998535, 8996528, 8996526, 8995756, 8994709, 8993897, 8986394, 8984388, 8983235, 8982923, 8975014, 8971759, 8966819, 8966799, 8966074, 8965351, 8964824, 8964727, 8963319, 8963089, 8961501, 8961264, 8960709, 8956885, 8953426, 8952982, 8952977, 8952967, 8950876, 8950530, 8949299, 8948461, 8948460, 8947407, 8947056, 8946817, 8946657, 8945380, 8944214, 8944212, 8942668, 8941264, 8937198, 8937195, 8937194, 8937192, 8937191, 8937189, 8937186, 8936973, 8936433, 8931828, 8931372, 8931103, 8930466, 8929863, 8929016, 8928558, 8926709, 8926708, 8925817, 8925816, 8923869, 8923868, 8923867, 8921750, 8921088, 8919706, 8917705, 8915431, 8914474, 8913516, 8912838, 8911979, 8911856, 8911708, 8911686, 8910634, 8909755, 8908450, 8908293, 8907644, 8906722, 8905539, 8904793, 8904792, 8903624, 8903177, 8902927, 8901556, 8901171, 8900920, 8899879, 8898845, 8898074, 8898073, 8895774, 8894483, 8893587, 8893470, 8893307, 8891901, 8890978, 8889474, 8889000, 8888996, 8888992, 8888602, 8888601, 8887977, 8887957, 8887350, 8887349, 8886827, 8886824, 8886823, 8886821, 8885549, 8885488, 8885485, 8884348, 8883845, 8883842, 8883440, 8883439, 8883352, 8880913, 8880381, 8879371, 8878778, 8876839, 8874024, 8873738, 8873737, 8872925, 8869230, 8869227, 8868510, 8865149, 8864881, 8864526, 8862447, 8861632, 8861531, 8861051, 8858969, 8858836, 8858194, 8855287, 8854631, 8853216, 8853215, 8852290, 8852289, 8850745, 8850744, 8849548, 8848599, 8847785, 8847712, 8847710, 8847552, 8847487, 8847486, 8847382, 8846809, 8846755, 8846103, 8843486, 8843449, 8843448, 8843420, 8843419, 8843418, 8843228, 8843227, 8843113, 8843058, 8842742, 8842721, 8842551, 8842083, 8842082, 8842004, 8841842, 8841593, 8841212, 8840849, 8839548, 8837584, 8837067, 8837066, 8836906, 8836904, 8836161, 8835996, 8835994, 8835054, 8834300, 8833030, 8832680, 8832636, 8832257, 8831304, 8831303, 8831100, 8830624, 8830283, 8830280, 8829997, 8829995, 8829846, 8829688, 8829547, 8828875, 8828400, 8827962, 8826975, 8826059, 8825559, 8824266, 8824264, 8824259, 8823254, 8823252, 8822827, 8822071, 8821947, 8821938, 8821660, 8818103, 8817859, 8817820, 8817145, 8817144, 8816986, 8816190, 8816188, 8815001, 8814921, 8814919, 8812058, 8812028, 8811410, 8810068, 8808983, 8808804, 8808780, 8805248, 8805100, 8804725, 8804650, 8804401, 8802032, 8801703, 8801247, 8796408, 8796407, 8796406, 8796405, 8796404, 8795232, 8794998, 8794588, 8794574, 8794573, 8793500, 8793308, 8792674, 8792512, 8792366, 8789871, 8788064, 8788063, 8786637, 8785677, 8785186, 8784016, 8784015, 8783826, 8783823, 8783257, 8783223, 8783126, 8782844, 8782527, 8782294, 8781682, 8781681, 8781390, 8781389, 8780834, 8780282, 8780258, 8779661, 8777561, 8777560, 8777491, 8776901, 8776526, 8776481, 8776414, 8776412, 8775518, 8774569, 8774568, 8774541, 8774539, 8774536, 8773405, 8772699, 8772534, 8772533, 8771422, 8771175, 8770713, 8770710, 8770600, 8770596, 8770594, 8770592, 8769150, 8768838, 8768107, 8768106, 8768105, 8766991, 8766890, 8766584, 8766094, 8764713, 8764661, 8764593, 8763900, 8763795, 8763282, 8763278, 8763276, 8763022, 8763000, 8762996, 8762985, 8762983, 8762982, 8762977, 8761765, 8761529, 8760494, 8760317, 8757909, 8757899, 8757862, 8757392, 8757332, 8755499, 8753656, 8750990, 8750681, 8750680, 8749711, 8749374, 8748412, 8747944, 8747026, 8747025, 8745113, 8744136, 8741303, 8740751, 8738878, 8738081, 8736874, 8734209, 8734208, 8733187, 8730745, 8729697, 8729060, 8728328, 8725533, 8725344, 8723962, 8723960, 8723959, 8723327, 8723264, 8722382, 8722150, 8719925, 8719735, 8717505, 8717393, 8716671, 8715924, 8715771, 8714987, 8714986, 8714985, 8712945, 8712711, 8712694, 8711341, 8709340, 8709339, 8709228, 8709124, 8708961, 8708509, 8707928, 8707187, 8704492, 8704491, 8703335, 8703117, 8703116, 8703115, 8703082, 8702917, 8702010, 8701588, 8701583, 8700570, 8691979, 8691562, 8690134, 8686888, 8682524, 8679795, 8676820, 8676568, 8666813, 8622310, 8619823, 8615916, 8612218, 8609049, 8572577, 8563598, 8538572, 8524098, 8517761, 8494332, 8484389, 8475828, 8475484, 8474934, 8468878, 8456921, 8456443, 8451609, 8447077, 8442529, 8442183, 8414781, 8412842, 8411381, 8380422, 8375598, 8373873, 8367732, 8363809, 8362054, 8360787, 8360410, 8357694, 8356427, 8355275, 8346094, 8337681, 8324020, 8316907, 8310111, 8297558, 8295374, 8292120, 8291352, 8288578, 8285549, 8282175, 8281969, 8279157, 8278948, 8274115, 8272680, 8272679, 8264027, 8232973, 8226935, 8209242, 8209240, 8189917, 8163791, 8159239, 8152313, 8150187, 7492255, 7339130, 5823469, 5808454, 5517244, 2549113, 3198654, 1862549, 1857031, 66666)
Run Time: 0.037830
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1262 | |
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 | | | | | 1262 | |
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: 140
Run Time: 0.000753
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",140],["thread",9674235],["thread",9673058],["thread",9673057],["thread",9672247],["thread",9670456],["thread",9667180],["thread",9666929],["thread",9666507],["thread",9666506],["thread",9666505],["thread",9666504],["thread",9666503],["thread",9661174],["thread",9656923],["thread",9648804],["thread",9648452],["thread",9647015],["thread",9642326],["thread",9641581],["thread",9638288],["thread",9637905],["thread",9637335],["thread",9637334],["thread",9637305],["thread",9636268],["thread",9636266],["thread",9635682],["thread",9634639],["thread",9634481],["thread",9632321],["thread",9631188],["thread",9631138],["thread",9631124],["thread",9626628],["thread",9624855],["thread",9624854],["thread",9623141],["thread",9622071],["thread",9621340],["thread",9616651],["thread",9616180],["thread",9614815],["thread",9603719],["thread",9597154],["thread",9595978],["thread",9593901],["thread",9592100],["thread",9592091],["thread",9588649],["thread",9588648],["thread",9588647],["thread",9586262],["thread",9579800],["thread",9575443],["thread",9571772],["thread",9571158],["thread",9569941],["thread",9567302],["thread",9565549],["thread",9565282],["thread",9564581],["thread",9563745],["thread",9559427],["thread",9559298],["thread",9559293],["thread",9556963],["thread",9556797],["thread",9556781],["thread",9556770],["thread",9556605],["thread",9554969],["thread",9552008],["thread",9551909],["thread",9550957],["thread",9549498],["thread",9540904],["thread",9537060],["thread",9536809],["thread",9534835],["thread",9533782],["thread",9532828],["thread",9531746],["thread",9529649],["thread",9527752],["thread",9525742],["thread",9525065],["thread",9524845],["thread",9524346],["thread",9522956],["thread",9522878],["thread",9522218],["thread",9521769],["thread",9520630],["thread",9519484],["thread",9519244],["thread",9518177],["thread",9517666],["thread",9517230],["thread",9517225],["thread",9512734],["thread",9508688],["thread",9508325],["thread",9503617],["thread",9503610],["thread",9503607],["thread",9503604],["thread",9503601],["thread",9503598],["thread",9503596],["thread",9503593],["thread",9503580],["thread",9503575],["thread",9503570],["thread",9503565],["thread",9503058],["thread",9500862],["thread",9500684],["thread",9499147],["thread",9496635],["thread",9496618],["thread",9494284],["thread",9494045],["thread",9494035],["thread",9488828],["thread",9483142],["thread",9481165],["thread",9480856],["thread",9480650],["thread",9478239],["thread",9474497],["thread",9470393],["thread",9469364],["thread",9468757],["thread",9467814],["thread",9467775],["thread",9467479],["thread",9467279],["thread",9464917],["thread",9459623],["thread",9454803],["thread",9447205],["thread",9445794],["thread",9445766],["thread",9445407],["thread",9442065],["thread",9441924],["thread",9441874],["thread",9441868],["thread",9441510],["thread",9440977],["thread",9440192],["thread",9437895],["thread",9436328],["thread",9436181],["thread",9434951],["thread",9434386],["thread",9434090],["thread",9433360],["thread",9433337],["thread",9428574],["thread",9426670],["thread",9425224],["thread",9424849],["thread",9421552],["thread",9417118],["thread",9415216],["thread",9413106],["thread",9411402],["thread",9409788],["thread",9408999],["thread",9408995],["thread",9408236],["thread",9405801],["thread",9401668],["thread",9398585],["thread",9396864],["thread",9396643],["thread",9395077],["thread",9394906],["thread",9392307],["thread",9391297],["thread",9389815],["thread",9389292],["thread",9388521],["thread",9387846],["thread",9387587],["thread",9386521],["thread",9385451],["thread",9385450],["thread",9380631],["thread",9380327],["thread",9377553],["thread",9374524],["thread",9366866],["thread",9364452],["thread",9364294],["thread",9362335],["thread",9361660],["thread",9360305],["thread",9359377],["thread",9357465],["thread",9356801],["thread",9356783],["thread",9354978],["thread",9354117],["thread",9354114],["thread",9349513],["thread",9349400],["thread",9346269],["thread",9344113],["thread",9342496],["thread",9341969],["thread",9339546],["thread",9336430],["thread",9331070],["thread",9329974],["thread",9329752],["thread",9329523],["thread",9328723],["thread",9321792],["thread",9320393],["thread",9320340],["thread",9319503],["thread",9318131],["thread",9317393],["thread",9315536],["thread",9315064],["thread",9315027],["thread",9313071],["thread",9312719],["thread",9312647],["thread",9307780],["thread",9306709],["thread",9306592],["thread",9306588],["thread",9306475],["thread",9306290],["thread",9295679],["thread",9294991],["thread",9294987],["thread",9294115],["thread",9294111],["thread",9293687],["thread",9293013],["thread",9291093],["thread",9290393],["thread",9287198],["thread",9286563],["thread",9284595],["thread",9283863],["thread",9283754],["thread",9283493],["thread",9282413],["thread",9281404],["thread",9276132],["thread",9276008],["thread",9275467],["thread",9274567],["thread",9269843],["thread",9263422],["thread",9260328],["thread",9259115],["thread",9257474],["thread",9255097],["thread",9254983],["thread",9254959],["thread",9254471],["thread",9254025],["thread",9252023],["thread",9248038],["thread",9247599],["thread",9245849],["thread",9244892],["thread",9240319],["thread",9235892],["thread",9235393],["thread",9232372],["thread",9231048],["thread",9227817],["thread",9226676],["thread",9225074],["thread",9222100],["thread",9221778],["thread",9212000],["thread",9203611],["thread",9202965],["thread",9200371],["thread",9199378],["thread",9198257],["thread",9196887],["thread",9190072],["thread",9186519],["thread",9185823],["thread",9185455],["thread",9185207],["thread",9182886],["thread",9179623],["thread",9178682],["thread",9176959],["thread",9176188],["thread",9175399],["thread",9172699],["thread",9172392],["thread",9171707],["thread",9169366],["thread",9165962],["thread",9165804],["thread",9164167],["thread",9160509],["thread",9157241],["thread",9156730],["thread",9155015],["thread",9154454],["thread",9152569],["thread",9152200],["thread",9150356],["thread",9149034],["thread",9146859],["thread",9145954],["thread",9133174],["thread",9130591],["thread",9130125],["thread",9130009],["thread",9129997],["thread",9129943],["thread",9129825],["thread",9129816],["thread",9129803],["thread",9129772],["thread",9129764],["thread",9129740],["thread",9125823],["thread",9123179],["thread",9121215],["thread",9119730],["thread",9116832],["thread",9116452],["thread",9114302],["thread",9113498],["thread",9112406],["thread",9112250],["thread",9109637],["thread",9109626],["thread",9109617],["thread",9107969],["thread",9106189],["thread",9105089],["thread",9099013],["thread",9095948],["thread",9094354],["thread",9093527],["thread",9087502],["thread",9083520],["thread",9076961],["thread",9075068],["thread",9066589],["thread",9066576],["thread",9064681],["thread",9061932],["thread",9058848],["thread",9057235],["thread",9051041],["thread",9050474],["thread",9046863],["thread",9044149],["thread",9043929],["thread",9043928],["thread",9043926],["thread",9043923],["thread",9042337],["thread",9039861],["thread",9038159],["thread",9038131],["thread",9038121],["thread",9038084],["thread",9037985],["thread",9028899],["thread",9028766],["thread",9023680],["thread",9020878],["thread",9019362],["thread",9016285],["thread",9013759],["thread",9010687],["thread",9007771],["thread",9001910],["thread",9000551],["thread",8998535],["thread",8996528],["thread",8995756],["thread",8994709],["thread",8993897],["thread",8986394],["thread",8975014],["thread",8966819],["thread",8966799],["thread",8964824],["thread",8964727],["thread",8961264],["thread",8960709],["thread",8956885],["thread",8953426],["thread",8952982],["thread",8952977],["thread",8952967],["thread",8950876],["thread",8950530],["thread",8946817],["thread",8945380],["thread",8944214],["thread",8942668],["thread",8937198],["thread",8936973],["thread",8931828],["thread",8931372],["thread",8926709],["thread",8923869],["thread",8921088],["thread",8919706],["thread",8917705],["thread",8915431],["thread",8911979],["thread",8911856],["thread",8911708],["thread",8911686],["thread",8909755],["thread",8908450],["thread",8908293],["thread",8907644],["thread",8906722],["thread",8904793],["thread",8903624],["thread",8903177],["thread",8901556],["thread",8901171],["thread",8900920],["thread",8899879],["thread",8895774],["thread",8894483],["thread",8888992],["thread",8887957],["thread",8887350],["thread",8885549],["thread",8885485],["thread",8879371],["thread",8876839],["thread",8874024],["thread",8873738],["thread",8869230],["thread",8868510],["thread",8864526],["thread",8861531],["thread",8861051],["thread",8858969],["thread",8858836],["thread",8855287],["thread",8853216],["thread",8852290],["thread",8850745],["thread",8849548],["thread",8848599],["thread",8847785],["thread",8847552],["thread",8847487],["thread",8847382],["thread",8846809],["thread",8846755],["thread",8843486],["thread",8843449],["thread",8843420],["thread",8843419],["thread",8843113],["thread",8843058],["thread",8842742],["thread",8842551],["thread",8842004],["thread",8841593],["thread",8840849],["thread",8837584],["thread",8836906],["thread",8835996],["thread",8835054],["thread",8833030],["thread",8832680],["thread",8831304],["thread",8830280],["thread",8829997],["thread",8829846],["thread",8829688],["thread",8828400],["thread",8827962],["thread",8826975],["thread",8823254],["thread",8822071],["thread",8821947],["thread",8821660],["thread",8817859],["thread",8817820],["thread",8817145],["thread",8816188],["thread",8814921],["thread",8812058],["thread",8812028],["thread",8811410],["thread",8805100],["thread",8804725],["thread",8804650],["thread",8804401],["thread",8801703],["thread",8801247],["thread",8795232],["thread",8792512],["thread",8788064],["thread",8786637],["thread",8783826],["thread",8783223],["thread",8781682],["thread",8781390],["thread",8780834],["thread",8777561],["thread",8776414],["thread",8775518],["thread",8774569],["thread",8774541],["thread",8774536],["thread",8773405],["thread",8772534],["thread",8770710],["thread",8770600],["thread",8769150],["thread",8768838],["thread",8766991],["thread",8766094],["thread",8764713],["thread",8763900],["thread",8763795],["thread",8763282],["thread",8763278],["thread",8763022],["thread",8763000],["thread",8762985],["thread",8762983],["thread",8762982],["thread",8762977],["thread",8761765],["thread",8757862],["thread",8757392],["thread",8757332],["thread",8750990],["thread",8749711],["thread",8749374],["thread",8748412],["thread",8747944],["thread",8745113],["thread",8744136],["thread",8733187],["thread",8725533],["thread",8723962],["thread",8723264],["thread",8719925],["thread",8717505],["thread",8716671],["thread",8715924],["thread",8715771],["thread",8714987],["thread",8712945],["thread",8712711],["thread",8712694],["thread",8711341],["thread",8709340],["thread",8709228],["thread",8709124],["thread",8708509],["thread",8707928],["thread",8704492],["thread",8703335],["thread",8703117],["thread",8703082],["thread",8702917],["thread",8701588],["thread",8701583],["thread",8691979],["thread",8691562],["thread",8682524],["thread",8676820],["thread",8676568],["thread",8619823],["thread",8612218],["thread",8609049],["thread",8563598],["thread",8538572],["thread",8524098],["thread",8517761],["thread",8494332],["thread",8484389],["thread",8475828],["thread",8475484],["thread",8474934],["thread",8468878],["thread",8456921],["thread",8451609],["thread",8447077],["thread",8442529],["thread",8442183],["thread",8414781],["thread",8412842],["thread",8411381],["thread",8380422],["thread",8373873],["thread",8367732],["thread",8363809],["thread",8362054],["thread",8360787],["thread",8360410],["thread",8357694],["thread",8356427],["thread",8355275],["thread",8346094],["thread",8337681],["thread",8316907],["thread",8310111],["thread",8297558],["thread",8295374],["thread",8292120],["thread",8291352],["thread",8288578],["thread",8285549],["thread",8282175],["thread",8281969],["thread",8279157],["thread",8274115],["thread",8264027],["thread",8232973],["thread",8189917],["thread",8163791],["thread",8152313],["thread",8150187],["thread",7492255],["thread",7339130],["thread",5823469],["thread",5808454],["thread",5517244],["thread",2549113],["thread",1862549]], 645, tinhte_xentag_tag, , {"tags":["ph\u1ee5 ki\u1ec7n iphone"]}, date, 0, , [], 0, 1652836134, f3966b6a2308b271fd1ee2b8819b0a1c
Run Time: 0.000824
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 (9512734, 9508688, 9508325, 9503617, 9503610, 9503607, 9503604, 9503601, 9503598, 9503596, 9503593, 9503580, 9503575, 9503570, 9503565, 9503058, 9500862, 9500684, 9499147, 9496635)
Run Time: 0.001718
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: 519804
Run Time: 0.000262
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=ph%E1%BB%A5+ki%E1%BB%87n+iphone&page=6, 1652836134,
Run Time: 0.000411
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000226
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 > 1652835234)
ORDER BY session_activity.view_date DESC
Run Time: 0.000864
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 2531 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |