SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000199
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 điện thoại')
Run Time: 0.000431
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ref | tag_text | tag_text | 302 | const | 1 | Using index condition |
SELECT *
FROM xf_search
WHERE search_id = ?
Params: 49006131
Run Time: 0.000301
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.000484
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.000167
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 (9686304, 9685917, 9685916, 9685141, 9685140, 9685139, 9684545, 9681416, 9680328, 9677536, 9677535, 9677312, 9674235, 9674227, 9673057, 9666506, 9666505, 9663979, 9661174, 9656795, 9643933, 9636268, 9636266, 9636265, 9632321, 9632320, 9626628, 9626627, 9619573, 9616649, 9615929, 9615542, 9613257, 9608435, 9605308, 9603678, 9603001, 9592100, 9586208, 9583330, 9582404, 9580672, 9580535, 9575443, 9570439, 9570401, 9570379, 9570366, 9567195, 9567194, 9565420, 9565388, 9564081, 9563203, 9560679, 9559302, 9558832, 9556797, 9556781, 9556770, 9556606, 9556605, 9552738, 9552329, 9551908, 9549937, 9544796, 9544795, 9542281, 9541190, 9540918, 9537060, 9536561, 9533782, 9533073, 9533071, 9529415, 9529414, 9526382, 9525742, 9525065, 9524845, 9524346, 9522878, 9522428, 9521769, 9521343, 9520630, 9520126, 9519484, 9519244, 9518464, 9517230, 9517225, 9514652, 9512202, 9509768, 9508429, 9503058, 9502483, 9501952, 9500682, 9498994, 9494145, 9492931, 9490549, 9480856, 9477432, 9474494, 9472083, 9471251, 9469659, 9467279, 9460192, 9459418, 9458694, 9458515, 9457777, 9456965, 9456124, 9455487, 9454685, 9454195, 9453110, 9445766, 9445492, 9445487, 9443126, 9441868, 9440750, 9440192, 9438672, 9437895, 9435977, 9432399, 9432398, 9431528, 9430009, 9429170, 9427077, 9425874, 9424849, 9420316, 9418827, 9417118, 9415216, 9411527, 9411276, 9411275, 9411272, 9410768, 9408608, 9407620, 9402735, 9402733, 9396067, 9387243, 9387238, 9386521, 9386520, 9386519, 9384991, 9380327, 9371002, 9370985, 9366866, 9361295, 9361293, 9354149, 9354117, 9350968, 9349507, 9349397, 9349263, 9346649, 9345702, 9345014, 9336760, 9336430, 9336429, 9330737, 9330736, 9328627, 9324096, 9322027, 9322026, 9320339, 9319108, 9317560, 9315064, 9315045, 9315002, 9313071, 9312719, 9311008, 9308504, 9307817, 9307780, 9301811, 9300261, 9294991, 9294111, 9292837, 9292722, 9289404, 9288928, 9286563, 9286562, 9283754, 9282413, 9280827, 9278279, 9276132, 9276131, 9271708, 9271078, 9271077, 9268612, 9265235, 9264303, 9263147, 9259735, 9259733, 9259115, 9257474, 9254983, 9254471, 9251661, 9247599, 9246837, 9241275, 9236878, 9235404, 9229228, 9225074, 9225073, 9224211, 9224210, 9219970, 9210258, 9206022, 9204625, 9203611, 9202985, 9202984, 9202982, 9202981, 9199378, 9196883, 9196882, 9195253, 9189206, 9188193, 9186519, 9186516, 9185207, 9185203, 9182444, 9180339, 9180338, 9179623, 9179591, 9178968, 9178682, 9176964, 9176108, 9175862, 9174679, 9169818, 9168503, 9166674, 9166673, 9166603, 9166504, 9162045, 9160093, 9158321, 9155639, 9155638, 9154454, 9150356, 9150021, 9146859, 9145954, 9145910, 9141959, 9141957, 9141956, 9141955, 9136347, 9136281, 9134690, 9130591, 9121891, 9120639, 9119506, 9119504, 9117544, 9117543, 9117518, 9116967, 9112997, 9112996, 9112406, 9112368, 9112249, 9109637, 9109626, 9109617, 9108858, 9108334, 9108323, 9108317, 9108307, 9107969, 9107147, 9103543, 9099015, 9097218, 9094896, 9092827, 9091886, 9091788, 9088352, 9088346, 9084853, 9083485, 9083483, 9081067, 9079316, 9079308, 9079210, 9078602, 9076961, 9075066, 9072510, 9061932, 9061931, 9059936, 9053026, 9043926, 9043925, 9034251, 9030961, 9030343, 9028544, 9028093, 9027034, 9022145, 9020587, 9019362, 9013935, 9012465, 9007688, 9004904, 9002491, 8996230, 8991595, 8989134, 8989125, 8986377, 8985566, 8985562, 8981399, 8980604, 8975014, 8974759, 8973587, 8972254, 8967556, 8966833, 8966074, 8965351, 8961264, 8961169, 8960709, 8948460, 8947056, 8946501, 8945053, 8945052, 8941871, 8937242, 8931144, 8931143, 8931129, 8930364, 8929864, 8929863, 8925748, 8923869, 8923868, 8923867, 8919026, 8913516, 8912213, 8909755, 8908450, 8908293, 8907439, 8906722, 8906244, 8905806, 8904793, 8904792, 8903177, 8897289, 8894927, 8894926, 8894925, 8891781, 8891187, 8891089, 8891087, 8891086, 8889992, 8889474, 8889172, 8889169, 8888914, 8887959, 8887957, 8887742, 8887350, 8887349, 8886827, 8886824, 8886823, 8886821, 8885709, 8884348, 8884092, 8883938, 8882778, 8881649, 8880576, 8879885, 8879078, 8878778, 8877797, 8877308, 8876436, 8875792, 8875503, 8875251, 8874728, 8874686, 8874680, 8873380, 8872822, 8872728, 8872727, 8871597, 8870415, 8869477, 8869410, 8868213, 8867478, 8867081, 8866426, 8865765, 8864759, 8863547, 8862777, 8862726, 8861911, 8860554, 8859872, 8859299, 8858179, 8857774, 8856151, 8856122, 8856120, 8855307, 8855020, 8854700, 8854631, 8854542, 8854333, 8853438, 8853215, 8852441, 8852095, 8851548, 8850420, 8850062, 8849548, 8849531, 8848385, 8847785, 8847552, 8847482, 8847382, 8846669, 8846660, 8846511, 8846103, 8845702, 8844628, 8844409, 8843583, 8843419, 8843418, 8842741, 8842117, 8841904, 8841498, 8841281, 8840849, 8840041, 8838695, 8837716, 8837067, 8837066, 8836422, 8835054, 8834300, 8834097, 8832680, 8832257, 8831303, 8829995, 8829846, 8829688, 8829553, 8829547, 8826975, 8826258, 8826059, 8825110, 8823779, 8823252, 8823162, 8822909, 8822120, 8822119, 8821660, 8819667, 8818887, 8818886, 8816313, 8816312, 8816147, 8815595, 8815001, 8814921, 8814919, 8812028, 8809901, 8809600, 8808983, 8804506, 8804503, 8803296, 8802774, 8802376, 8802032, 8801703, 8801221, 8801031, 8801029, 8788539, 8788063, 8786428, 8785218, 8785186, 8784998, 8784997, 8783257, 8782850, 8782844, 8782294, 8781389, 8780878, 8780209, 8776901, 8776652, 8776354, 8774531, 8772711, 8771388, 8771175, 8770222, 8769736, 8769707, 8769699, 8769670, 8769471, 8769150, 8768840, 8768107, 8768106, 8768105, 8766991, 8764874, 8763276, 8763000, 8762985, 8762983, 8762982, 8760317, 8758944, 8758687, 8757862, 8756931, 8756929, 8754137, 8749390, 8749387, 8747944, 8747845, 8747025, 8745113, 8739328, 8738081, 8737812, 8734209, 8734208, 8731664, 8731662, 8729698, 8729697, 8729060, 8726112, 8725345, 8725344, 8723264, 8722382, 8719900, 8718558, 8716671, 8716532, 8716531, 8715924, 8714524, 8712945, 8709509, 8709340, 8709339, 8708961, 8707928, 8707187, 8705855, 8704492, 8704491, 8704331, 8704147, 8703335, 8703115, 8703082, 8702010, 8701583, 8700711, 8699940, 8697938, 8693211, 8691153, 8690871, 8688535, 8684801, 8681914, 8681271, 8681270, 8680953, 8680478, 8680477, 8680474, 8671656, 8668385, 8666613, 8665593, 8665000, 8662194, 8658873, 8658463, 8656646, 8656260, 8656257, 8655524, 8655517, 8654014, 8650386, 8649932, 8649931, 8649928, 8648850, 8648725, 8646772, 8646771, 8646250, 8643509, 8642213, 8641548, 8640138, 8639667, 8638152, 8635389, 8634652, 8634142, 8633919, 8633918, 8630409, 8628134, 8627017, 8625267, 8623408, 8622255, 8618210, 8617925, 8616355, 8613515, 8613513, 8611451, 8611449, 8610234, 8609800, 8609749, 8608026, 8604259, 8601201, 8598412, 8593002, 8591897, 8591895, 8589174, 8588751, 8585715, 8582707, 8582581, 8581636, 8581536, 8580748, 8580514, 8580445, 8580444, 8580442, 8579579, 8579578, 8579577, 8578422, 8578030, 8577445, 8576831, 8574337, 8572489, 8572488, 8572228, 8571470, 8571100, 8568756, 8566537, 8566535, 8566433, 8563186, 8562466, 8561075, 8559865, 8557581, 8554956, 8554950, 8552834, 8552556, 8552346, 8551850, 8547434, 8547389, 8544890, 8544626, 8543122, 8542641, 8542490, 8542476, 8537486, 8535063, 8535062, 8535061, 8535058, 8534600, 8534264, 8533396, 8533394, 8533393, 8532915, 8532319, 8532022, 8531403, 8529709, 8528598, 8527709, 8526424, 8525465, 8524727, 8523824, 8521989, 8521322, 8521321, 8521095, 8518217, 8517731, 8514680, 8513289, 8512603, 8510511, 8508778, 8508087, 8471412, 8469936, 8468658, 8468213, 8467933, 8467390, 8466115, 8465898, 8465848, 8464404, 8463925, 8442698, 8438178, 8386370, 8386147, 8385896, 8385361, 8384850, 8372947, 8365873, 8365867, 8365856, 8364177, 8357470, 8351581, 8349724, 8349705, 8348016, 8344526, 8342298, 8341626, 8340274, 8336719, 8335968, 8335906, 8308797, 8307181, 8303748, 8298903, 8296538, 8290581, 8260074, 8242247, 8242246, 8241859, 8240798, 8217458, 8217457, 8217176, 8216158, 8215163, 8169377, 8159152, 8158965, 8158827, 8158037, 8157198, 8157173, 8156880, 8156639, 8156493, 8155939, 8155938, 8155811, 8155810, 8155774, 8155748, 8154979, 8154542, 8154489, 8153645, 7976040, 7283598)
Run Time: 0.019169
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 879 | 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 |
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.000573
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",9686304],["thread",9685917],["thread",9685141],["thread",9685140],["thread",9685139],["thread",9684545],["thread",9681416],["thread",9677536],["thread",9673057],["thread",9666506],["thread",9666505],["thread",9661174],["thread",9656795],["thread",9643933],["thread",9636268],["thread",9636266],["thread",9632321],["thread",9626628],["thread",9605308],["thread",9603678],["thread",9592100],["thread",9583330],["thread",9582404],["thread",9580535],["thread",9575443],["thread",9560679],["thread",9559302],["thread",9556797],["thread",9556781],["thread",9556770],["thread",9556605],["thread",9552738],["thread",9552329],["thread",9544796],["thread",9541190],["thread",9537060],["thread",9533782],["thread",9525742],["thread",9525065],["thread",9524845],["thread",9524346],["thread",9522878],["thread",9522428],["thread",9521769],["thread",9521343],["thread",9520630],["thread",9519484],["thread",9519244],["thread",9518464],["thread",9517230],["thread",9517225],["thread",9503058],["thread",9502483],["thread",9501952],["thread",9494145],["thread",9490549],["thread",9480856],["thread",9474494],["thread",9472083],["thread",9471251],["thread",9467279],["thread",9460192],["thread",9459418],["thread",9458515],["thread",9457777],["thread",9456965],["thread",9456124],["thread",9455487],["thread",9454685],["thread",9453110],["thread",9445766],["thread",9445492],["thread",9443126],["thread",9441868],["thread",9440192],["thread",9438672],["thread",9437895],["thread",9430009],["thread",9429170],["thread",9427077],["thread",9424849],["thread",9418827],["thread",9417118],["thread",9415216],["thread",9411275],["thread",9386521],["thread",9384991],["thread",9380327],["thread",9366866],["thread",9354117],["thread",9350968],["thread",9349263],["thread",9336430],["thread",9330737],["thread",9328627],["thread",9324096],["thread",9319108],["thread",9315064],["thread",9313071],["thread",9312719],["thread",9307780],["thread",9294991],["thread",9294111],["thread",9292837],["thread",9292722],["thread",9286563],["thread",9283754],["thread",9282413],["thread",9280827],["thread",9278279],["thread",9276132],["thread",9265235],["thread",9259115],["thread",9257474],["thread",9254983],["thread",9254471],["thread",9251661],["thread",9247599],["thread",9246837],["thread",9235404],["thread",9225074],["thread",9210258],["thread",9204625],["thread",9203611],["thread",9202985],["thread",9199378],["thread",9196883],["thread",9189206],["thread",9186519],["thread",9185207],["thread",9180339],["thread",9179623],["thread",9178682],["thread",9176108],["thread",9158321],["thread",9155639],["thread",9154454],["thread",9150356],["thread",9146859],["thread",9145954],["thread",9130591],["thread",9121891],["thread",9120639],["thread",9117544],["thread",9112406],["thread",9109637],["thread",9109626],["thread",9109617],["thread",9108307],["thread",9107969],["thread",9103543],["thread",9099015],["thread",9091886],["thread",9076961],["thread",9072510],["thread",9061932],["thread",9053026],["thread",9043926],["thread",9020587],["thread",9019362],["thread",9007688],["thread",9002491],["thread",8991595],["thread",8989125],["thread",8986377],["thread",8985566],["thread",8981399],["thread",8980604],["thread",8975014],["thread",8973587],["thread",8972254],["thread",8967556],["thread",8966833],["thread",8961264],["thread",8961169],["thread",8960709],["thread",8946501],["thread",8945053],["thread",8937242],["thread",8930364],["thread",8929864],["thread",8925748],["thread",8923869],["thread",8919026],["thread",8912213],["thread",8909755],["thread",8908450],["thread",8908293],["thread",8907439],["thread",8906722],["thread",8904793],["thread",8903177],["thread",8894927],["thread",8891781],["thread",8889169],["thread",8887957],["thread",8887350],["thread",8885709],["thread",8884092],["thread",8883938],["thread",8875503],["thread",8874728],["thread",8874686],["thread",8874680],["thread",8872727],["thread",8863547],["thread",8856122],["thread",8855307],["thread",8854700],["thread",8850062],["thread",8849548],["thread",8847785],["thread",8847552],["thread",8847382],["thread",8846669],["thread",8846660],["thread",8843419],["thread",8842117],["thread",8840849],["thread",8836422],["thread",8835054],["thread",8834097],["thread",8832680],["thread",8829846],["thread",8829688],["thread",8829553],["thread",8826975],["thread",8825110],["thread",8823779],["thread",8823162],["thread",8822909],["thread",8822120],["thread",8821660],["thread",8818887],["thread",8816147],["thread",8815595],["thread",8814921],["thread",8812028],["thread",8809600],["thread",8804506],["thread",8803296],["thread",8802376],["thread",8801703],["thread",8801221],["thread",8801031],["thread",8785218],["thread",8776652],["thread",8774531],["thread",8769736],["thread",8769707],["thread",8769699],["thread",8769670],["thread",8769471],["thread",8769150],["thread",8768840],["thread",8766991],["thread",8763000],["thread",8762985],["thread",8762983],["thread",8762982],["thread",8757862],["thread",8756931],["thread",8754137],["thread",8749390],["thread",8747944],["thread",8745113],["thread",8739328],["thread",8731664],["thread",8726112],["thread",8723264],["thread",8718558],["thread",8716671],["thread",8715924],["thread",8712945],["thread",8709509],["thread",8709340],["thread",8707928],["thread",8705855],["thread",8704492],["thread",8704331],["thread",8704147],["thread",8703335],["thread",8703082],["thread",8701583],["thread",8700711],["thread",8699940],["thread",8697938],["thread",8693211],["thread",8691153],["thread",8690871],["thread",8688535],["thread",8684801],["thread",8681271],["thread",8680953],["thread",8671656],["thread",8668385],["thread",8666613],["thread",8665593],["thread",8665000],["thread",8658873],["thread",8658463],["thread",8656646],["thread",8656260],["thread",8656257],["thread",8655524],["thread",8655517],["thread",8654014],["thread",8650386],["thread",8649932],["thread",8648850],["thread",8648725],["thread",8646772],["thread",8646250],["thread",8643509],["thread",8642213],["thread",8641548],["thread",8640138],["thread",8639667],["thread",8638152],["thread",8635389],["thread",8634652],["thread",8634142],["thread",8633919],["thread",8630409],["thread",8627017],["thread",8625267],["thread",8623408],["thread",8622255],["thread",8618210],["thread",8617925],["thread",8610234],["thread",8609800],["thread",8609749],["thread",8608026],["thread",8601201],["thread",8598412],["thread",8593002],["thread",8589174],["thread",8588751],["thread",8585715],["thread",8582581],["thread",8581636],["thread",8581536],["thread",8580748],["thread",8580514],["thread",8580445],["thread",8579579],["thread",8576831],["thread",8574337],["thread",8572228],["thread",8571100],["thread",8568756],["thread",8566537],["thread",8566433],["thread",8562466],["thread",8561075],["thread",8559865],["thread",8557581],["thread",8552834],["thread",8552556],["thread",8551850],["thread",8547434],["thread",8544890],["thread",8544626],["thread",8543122],["thread",8542490],["thread",8542476],["thread",8537486],["thread",8535063],["thread",8534600],["thread",8534264],["thread",8533396],["thread",8532915],["thread",8532319],["thread",8529709],["thread",8528598],["thread",8527709],["thread",8523824],["thread",8521989],["thread",8521322],["thread",8521095],["thread",8517731],["thread",8514680],["thread",8513289],["thread",8508778],["thread",8508087],["thread",8471412],["thread",8469936],["thread",8468658],["thread",8468213],["thread",8467933],["thread",8467390],["thread",8466115],["thread",8465898],["thread",8465848],["thread",8464404],["thread",8463925],["thread",8442698],["thread",8438178],["thread",8386147],["thread",8384850],["thread",8372947],["thread",8365867],["thread",8364177],["thread",8357470],["thread",8351581],["thread",8349724],["thread",8349705],["thread",8344526],["thread",8342298],["thread",8340274],["thread",8336719],["thread",8335968],["thread",8335906],["thread",8308797],["thread",8303748],["thread",8298903],["thread",8296538],["thread",8290581],["thread",8260074],["thread",8242247],["thread",8241859],["thread",8240798],["thread",8217458],["thread",8217176],["thread",8216158],["thread",8215163],["thread",8169377],["thread",8159152],["thread",8158965],["thread",8158827],["thread",8158037],["thread",8157198],["thread",8157173],["thread",8156880],["thread",8156639],["thread",8156493],["thread",8155939],["thread",8155811],["thread",8155810],["thread",8155774],["thread",8155748],["thread",8154979],["thread",8154542],["thread",8153645],["thread",7976040],["thread",7283598]], 448, tinhte_xentag_tag, , {"tags":["\u0111\u1ed3 ch\u01a1i \u0111i\u1ec7n tho\u1ea1i"]}, date, 0, , [], 0, 1657124767, dafb72efb4277d21be5b81b31ad21b7b
Run Time: 0.000560
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 (9471251, 9467279, 9460192, 9459418, 9458515, 9457777, 9456965, 9456124, 9455487, 9454685, 9453110, 9445766, 9445492, 9443126, 9441868, 9440192, 9438672, 9437895, 9430009, 9429170)
Run Time: 0.001445
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: 520304
Run Time: 0.000263
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+%C4%91i%E1%BB%87n+tho%E1%BA%A1i&page=4, 1657124767,
Run Time: 0.000422
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000208
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 > 1657123867)
ORDER BY session_activity.view_date DESC
Run Time: 0.003456
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 1859 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |