SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000220
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT tag.*
,
0 AS tag_is_watched
FROM `xf_tinhte_xentag_tag` AS tag
WHERE (tag.tag_text = 'bàn sofa')
Run Time: 0.000432
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: 63253086
Run Time: 0.000291
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: 119
Run Time: 0.000920
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, 119
Run Time: 0.000339
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 (9694561, 9694560, 9694558, 9694556, 9693353, 9690528, 9686062, 9673914, 9673199, 9673076, 9672168, 9671981, 9670707, 9670193, 9670039, 9669992, 9669527, 9669523, 9669522, 9669520, 9669519, 9667590, 9667364, 9662958, 9660623, 9659242, 9659239, 9657813, 9657791, 9657790, 9655555, 9655554, 9654577, 9654576, 9650561, 9649635, 9649220, 9649210, 9649208, 9649203, 9649197, 9649196, 9649194, 9649193, 9649190, 9649187, 9649185, 9649184, 9649180, 9649178, 9649175, 9649174, 9649167, 9649162, 9649158, 9649157, 9649154, 9649152, 9649144, 9649141, 9649140, 9649139, 9649138, 9648871, 9648284, 9647765, 9646625, 9645963, 9643690, 9643148, 9641943, 9641038, 9638959, 9638958, 9637859, 9637535, 9637427, 9637244, 9636575, 9631613, 9629937, 9629289, 9629288, 9628486, 9628485, 9628483, 9628482, 9628481, 9628477, 9628475, 9628474, 9628473, 9628471, 9628470, 9628468, 9628462, 9628460, 9628454, 9627424, 9626088, 9626087, 9625770, 9625758, 9625323, 9625231, 9623034, 9622424, 9622423, 9622399, 9622398, 9622397, 9622392, 9622390, 9622386, 9622383, 9622378, 9622377, 9622375, 9622370, 9622368, 9622364, 9622361, 9622358, 9622357, 9622355, 9620601, 9620600, 9618983, 9617893, 9615286, 9615285, 9614154, 9613138, 9612910, 9611970, 9610342, 9610341, 9610340, 9610339, 9610336, 9610334, 9610333, 9610331, 9610330, 9610329, 9610328, 9610326, 9610324, 9610321, 9610320, 9610317, 9610315, 9610311, 9610308, 9610228, 9610227, 9610224, 9610223, 9610222, 9610221, 9610219, 9610217, 9610211, 9610209, 9610207, 9610204, 9610113, 9609982, 9609981, 9609979, 9609977, 9609976, 9609974, 9609972, 9609971, 9609970, 9609969, 9609968, 9609965, 9609962, 9609960, 9609956, 9609955, 9609953, 9609952, 9609951, 9609950, 9609949, 9609574, 9609572, 9609449, 9609414, 9609329, 9609325, 9609321, 9609215, 9609211, 9609203, 9609196, 9609193, 9609191, 9609186, 9609179, 9609175, 9609169, 9609110, 9609107, 9609103, 9609102, 9609099, 9609098, 9609030, 9609029, 9609026, 9609025, 9609015, 9609014, 9609010, 9609007, 9609005, 9609004, 9609002, 9609001, 9608968, 9608964, 9608961, 9608959, 9608946, 9608942, 9608924, 9608915, 9608767, 9608632, 9608627, 9608621, 9608609, 9608607, 9608606, 9608595, 9608590, 9608583, 9608580, 9608577, 9608568, 9608564, 9608519, 9608514, 9608509, 9608338, 9608310, 9608306, 9608297, 9608295, 9608294, 9608293, 9608291, 9608289, 9608288, 9608287, 9608285, 9608279, 9608277, 9608276, 9608275, 9608274, 9608271, 9608270, 9608262, 9608261, 9608260, 9608257, 9608253, 9608251, 9608250, 9608249, 9608152, 9608151, 9608150, 9608147, 9608144, 9608142, 9608137, 9608135, 9608128, 9608126, 9608124, 9608120, 9608115, 9608112, 9608072, 9608070, 9608069, 9608066, 9608061, 9608055, 9607871, 9607866, 9607863, 9607861, 9607860, 9607858, 9607856, 9607852, 9607847, 9607829, 9607823, 9607817, 9607815, 9607813, 9607808, 9607802, 9607797, 9607795, 9607791, 9607754, 9607753, 9607752, 9607749, 9607748, 9607730, 9607604, 9607603, 9607602, 9606329, 9605964, 9604825, 9604813, 9604169, 9602734, 9602383, 9602294, 9601970, 9601903, 9601379, 9600817, 9600426, 9600168, 9599340, 9598739, 9594769, 9592302, 9592301, 9592300, 9589180, 9578784, 9578637, 9575094, 9572317, 9570809, 9569509, 9568336, 9568335, 9567808, 9560453, 9560452, 9560451, 9560450, 9560449, 9554916, 9552746, 9550850, 9549855, 9549854, 9548961, 9548959, 9548957, 9544077, 9544076, 9541701, 9540167, 9540165, 9540101, 9540095, 9540094, 9540092, 9540091, 9540085, 9538470, 9538469, 9535274, 9535237, 9530766, 9530695, 9530626, 9530454, 9530224, 9530208, 9529534, 9527482, 9527033, 9526376, 9526292, 9526230, 9526162, 9525889, 9525819, 9525775, 9523586, 9523488, 9522969, 9521665, 9521544, 9521455, 9520593, 9519574, 9519573, 9518926, 9518925, 9516045, 9514556, 9514555, 9514554, 9514238, 9513674, 9513673, 9511943, 9509518, 9508013, 9508010, 9508008, 9506789, 9506496, 9506495, 9506493, 9504558, 9503197, 9502775, 9502593, 9500556, 9500505, 9500504, 9499864, 9499651, 9499099, 9498687, 9498686, 9497714, 9497713, 9496543, 9494686, 9494546, 9494545, 9494544, 9493138, 9492597, 9492596, 9491585, 9491217, 9491216, 9490466, 9489869, 9486108, 9485536, 9483403, 9482796, 9482501, 9482500, 9482499, 9482498, 9482026, 9478576, 9477196, 9476241, 9476240, 9475619, 9475110, 9475105, 9474665, 9474534, 9474276, 9474197, 9473818, 9473459, 9472800, 9472756, 9472754, 9471082, 9470552, 9469663, 9469655, 9469650, 9469646, 9469271, 9469269, 9468581, 9468241, 9468216, 9468215, 9468214, 9468213, 9465244, 9465243, 9463746, 9461697, 9461228, 9455867, 9455866, 9454913, 9454772, 9454770, 9454729, 9454728, 9454727, 9454726, 9454711, 9454277, 9450562, 9450494, 9449893, 9449647, 9449645, 9449627, 9449525, 9449405, 9449404, 9448150, 9447743, 9447125, 9447124, 9444396, 9442312, 9442311, 9442021, 9442020, 9440417, 9440416, 9438933, 9437389, 9435651, 9435415, 9429125, 9428454, 9428452, 9425682, 9423215, 9422768, 9422273, 9421446, 9421445, 9421401, 9421284, 9421283, 9421169, 9420894, 9420051, 9420050, 9419604, 9416481, 9415510, 9415241, 9414896, 9414699, 9413945, 9413944, 9413943, 9413819, 9412509, 9412038, 9411597, 9411213, 9411212, 9410823, 9410808, 9410295, 9409315, 9409109, 9408698, 9408697, 9408441, 9408111, 9398458, 9397292, 9397291, 9392582, 9390924, 9389428, 9386413, 9386412, 9385615, 9385614, 9385007, 9382296, 9380791, 9379119, 9377950, 9377344, 9377343, 9376013, 9374412, 9373205, 9373204, 9373203, 9373202, 9372744, 9366502, 9366350, 9365767, 9364873, 9364375, 9364031, 9363481, 9362802, 9362530, 9362529, 9362369, 9360616, 9356880, 9355985, 9355733, 9354994, 9354712, 9349727, 9349561, 9349560, 9346243, 9346242, 9345289, 9345131, 9342552, 9337004, 9336004, 9334360, 9334359, 9332531, 9330742, 9330260, 9329831, 9329830, 9327536, 9326046, 9325445, 9325421, 9324825, 9324655, 9322582, 9322273, 9318287, 9318286, 9317828, 9317822, 9317482, 9316807, 9314811, 9314810, 9314809, 9313166, 9310152, 9309481, 9308718, 9308345, 9307666, 9306551, 9306534, 9306469, 9304762, 9304171, 9304149, 9303164, 9302662, 9302660, 9301404, 9298212, 9296971, 9293823, 9290759, 9289708, 9289707, 9289169, 9286873, 9285130, 9284992, 9282746, 9282684, 9282282, 9282100, 9281413, 9280743, 9280742, 9280741, 9279363, 9279244, 9278725, 9278586, 9277973, 9277970, 9277763, 9277527, 9277526, 9277523, 9277522, 9276805, 9273536, 9273250, 9272400, 9272398, 9271288, 9270330, 9269852, 9268859, 9268392, 9265788, 9265786, 9265071, 9263710, 9262776, 9262287, 9262278, 9259315, 9259314, 9258472, 9258106, 9258040, 9258039, 9257835, 9256128, 9253093, 9252434, 9249735, 9249734, 9248134, 9248133, 9244468, 9243461, 9241016, 9239374, 9236876, 9236875, 9236783, 9236263, 9236262, 9236260, 9236259, 9236258, 9236194, 9235635, 9235634, 9235581, 9232261, 9232256, 9231261, 9230195, 9228911, 9228871, 9228589, 9226837, 9226836, 9226835, 9223916, 9223915, 9223914, 9223515, 9223514, 9223135, 9219431, 9217317, 9217184, 9216839, 9215925, 9215922, 9215358, 9214927, 9213825, 9213823, 9213782, 9213781, 9213686, 9211856, 9211835, 9211834, 9210732, 9210378, 9209898, 9209481, 9209477, 9208544, 9206926, 9204845, 9204844, 9204333, 9201607, 9199705, 9198219, 9198217, 9198216, 9193211, 9192597, 9192502, 9189710, 9184683, 9183252, 9181344, 9181330, 9181168, 9181167, 9180979, 9179165, 9178636, 9176756, 9175792, 9175790, 9174420, 9172202, 9172181, 9172178, 9172176, 9172175, 9171803, 9170322, 9166160, 9166154, 9165467, 9165465, 9164875, 9164732, 9163048, 9162030, 9162028, 9162002, 9160900, 9160881, 9160869, 9160866, 9160865, 9160864, 9158998, 9158002, 9158001, 9158000, 9157995, 9157255, 9154367, 9154237, 9151169, 9150969, 9150967, 9149044, 9148253, 9147785, 9147391, 9146727, 9146717, 9146548, 9146463, 9143625, 9143255, 9143014, 9142520, 9140639, 9140293, 9140292, 9135343, 9135336, 9133299, 9133291, 9128269, 9127949, 9125434, 9125429, 9123352, 9123333, 9122375, 9121557, 9121555, 9119879, 9119874, 9119867, 9119866, 9119459, 9119334, 9118702, 9117426, 9114414, 9111423, 9110810, 9109895, 9109740, 9109591, 9109536, 9109535, 9109534, 9109532, 9109051, 9108591, 9108434, 9108433, 9107671, 9107669, 9107533, 9107433, 9107373, 9106879, 9105701, 9105700, 9105674, 9105672, 9101639, 9099052, 9099051, 9098903, 9097513, 9094249, 9094248, 9093313, 9089455, 9088879, 9088419, 9088411, 9087238, 9084560, 9081267, 9078334, 9077755, 9074904, 9072705, 9072704, 9072703, 9070795, 9069291, 9068902, 9064521, 9059374, 9059373, 9058636, 9058626, 9053931, 9053113, 9053111, 9052801, 9052050, 9049127, 9048873, 9048872, 9048268, 9047295, 9044212, 9043372, 9042932, 9042583, 9042281, 9040862, 9040384, 9039899, 9039589, 9038810, 9038231, 9037864, 9036356, 9036121, 9035178, 9035075, 9034437, 9034434, 9032471, 9032470, 9032469, 9031122, 9029821, 9028916, 9028838, 9027987, 9027888, 9027167, 9026997, 9025724, 9023851, 9023603, 9022814, 9022812, 9022406, 9022400, 9021502, 9021501, 9016978, 9016897, 9014027, 9012249, 9012204, 9012203, 9008651, 9007516, 9007044, 9007031, 9004702, 9004286, 9003161, 9002132, 9002131, 9001907, 8998853, 8997621, 8996661, 8996087, 8995831, 8995830, 8995170, 8994294, 8994293, 8993238, 8993118, 8993112, 8993110, 8992525, 8990901, 8985165, 8980688, 8979427, 8977458, 8977457, 8976539, 8976459, 8976159, 8974939, 8974938, 8970470, 8970469, 8969547, 8969474, 8969473, 8968209, 8967651, 8967649, 8967384, 8966958, 8966956, 8966906, 8966477, 8966476, 8965977, 8965976, 8965975, 8965974, 8965973, 8965292, 8964400, 8963974, 8963657, 8962534, 8961727, 8961662, 8961546, 8960535, 8960534, 8960505, 8959983, 8957205, 8956629, 8956227, 8954135, 8952751, 8951637, 8948825, 8947855, 8947853, 8947071, 8946385, 8946090, 8946088, 8945157, 8944693, 8939817, 8938851, 8938850, 8937155, 8936680, 8934347, 8931834, 8931633, 8928562, 8928560, 8928333, 8926386, 8926377, 8926376, 8924537, 8924536, 8924023, 8921476, 8919349, 8917927, 8916957, 8916672, 8913772, 8912995, 8912922, 8912075, 8908541, 8908270, 8908269, 8908062, 8907020, 8906686, 8906341, 8906317, 8905799, 8905053, 8904561, 8903554, 8901711, 8901262, 8900759, 8900640, 8900639, 8900519, 8900172, 8898907, 8894271, 8894270, 8894018, 8893669, 8893668, 8893010, 8891899, 8891389, 8891012, 8890045, 8889674, 8887183, 8886701, 8884291, 8883008, 8883006, 8881312, 8880187, 8880186, 8880185, 8880184, 8880183, 8880182, 8880181, 8880180, 8880179, 8879876, 8879780, 8879778, 8877871, 8877142, 8877140, 8876717, 8876716, 8876715, 8876714, 8873535, 8873407, 8868394, 8868057, 8867747, 8867624, 8867623, 8867548, 8865783, 8865727, 8862895, 8862892, 8862890, 8862782, 8862776, 8862683, 8862665, 8861113, 8861036, 8860011, 8860010, 8859313, 8859311, 8856068, 8855166, 8854986, 8853337, 8852257, 8851558, 8851494, 8849666, 8849269, 8849268, 8848377, 8847341, 8843175, 8842658, 8841738, 8841220, 8841160, 8840731, 8840728, 8840593, 8836523, 8836443, 8836417, 8836415, 8836413, 8835733, 8835732, 8834946, 8833600, 8832879, 8830370, 8830368, 8829847, 8829277, 8828857, 8828856, 8828452, 8828340, 8827715, 8827690, 8827664, 8827398, 8827041, 8827035, 8825598, 8825084, 8825062, 8824391, 8824291, 8824288, 8824281, 8824279, 8824209, 8824207, 8823662, 8821875, 8821356, 8820441, 8819193, 8818804, 8818337, 8817813, 8817080, 8815957, 8814432, 8814246, 8814053, 8813736, 8813735, 8813537, 8813535, 8813510, 8813421, 8813265, 8812262, 8812016, 8811829, 8810896, 8810895, 8810893, 8810886, 8809418, 8808870, 8808827, 8808526, 8808177, 8808164, 8808161, 8808154, 8808153, 8805993, 8803715, 8803711, 8803709, 8803648, 8802431, 8802178, 8802174, 8801309, 8801149, 8801146, 8800708, 8800021, 8799163, 8796303, 8794133, 8794132, 8794003, 8794002, 8790919, 8790908, 8790907, 8790764, 8788535, 8787456, 8787454, 8787252, 8786649, 8786160, 8785237, 8784193, 8784017, 8784008, 8782908, 8781394, 8781102, 8781101, 8781099, 8781096, 8780979, 8780850, 8780849, 8780848, 8780122, 8779474, 8779040, 8779039, 8779038, 8778496, 8778494, 8774488, 8773769, 8773646, 8773294, 8772361, 8772097, 8770352, 8769178, 8769177, 8768745, 8768743, 8767319, 8766912, 8766166, 8763383, 8763263, 8762650, 8762329, 8762187, 8761720, 8760939, 8759730, 8759638, 8758273, 8757345, 8757266, 8756989, 8756842, 8756325, 8753202, 8753201, 8753173, 8752444, 8751661, 8751659, 8749462, 8747869, 8747864, 8747861, 8747239, 8746395, 8746394, 8746122, 8746121, 8746120, 8746119, 8745459, 8745458, 8744745, 8744280, 8744279, 8743949, 8742739, 8742297, 8741406, 8741403, 8740276, 8740274, 8737542, 8734122, 8734121, 8733775, 8733246, 8729562, 8729094, 8728814, 8726968, 8726801, 8726800, 8726630, 8726122, 8726095, 8721464, 8720314, 8719739, 8712841, 8711677, 8707477, 8693262, 8689693, 8689473, 8689466, 8686462, 8684250, 8684072, 8681579, 8675810, 8674620, 8671846, 8664229, 8660278, 8659739, 8652834, 8651057, 8643548, 8640037, 8633563, 8629095, 8628505, 8622072, 8608108, 8603366, 8599994, 8590842, 8582751, 8565148, 8552245, 8548757, 8546312, 8522579, 8518549, 8498625, 8476605, 8452694, 8443992, 8443438, 8424029, 8403158, 8397583, 8348700, 8325557, 8323691, 8309620, 8293093, 8170058, 8145410, 8091694, 8000729, 7501868, 7460374, 7281268, 6121389, 4867048, 1961017)
Run Time: 0.026880
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | <subquery2> | ALL | distinct_key | | | | 1438 | |
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 | | | | | 1438 | |
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: 119
Run Time: 0.000688
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",119],["thread",9694561],["thread",9693353],["thread",9690528],["thread",9686062],["thread",9673914],["thread",9673199],["thread",9673076],["thread",9672168],["thread",9671981],["thread",9670707],["thread",9670193],["thread",9670039],["thread",9669527],["thread",9669523],["thread",9667590],["thread",9667364],["thread",9662958],["thread",9660623],["thread",9659242],["thread",9659239],["thread",9657813],["thread",9657791],["thread",9650561],["thread",9649635],["thread",9649220],["thread",9649210],["thread",9649208],["thread",9649203],["thread",9649197],["thread",9649196],["thread",9649194],["thread",9649193],["thread",9649190],["thread",9649187],["thread",9649185],["thread",9649184],["thread",9649180],["thread",9649178],["thread",9649175],["thread",9649174],["thread",9649167],["thread",9649162],["thread",9649158],["thread",9649157],["thread",9649154],["thread",9649152],["thread",9649144],["thread",9649141],["thread",9649140],["thread",9649139],["thread",9649138],["thread",9648284],["thread",9643148],["thread",9641943],["thread",9638959],["thread",9637859],["thread",9637535],["thread",9637427],["thread",9637244],["thread",9636575],["thread",9631613],["thread",9629937],["thread",9629289],["thread",9628486],["thread",9628485],["thread",9628483],["thread",9628482],["thread",9628481],["thread",9628477],["thread",9628475],["thread",9628474],["thread",9628473],["thread",9628471],["thread",9628470],["thread",9628468],["thread",9628462],["thread",9628460],["thread",9628454],["thread",9626088],["thread",9625770],["thread",9625323],["thread",9622424],["thread",9622423],["thread",9622399],["thread",9622398],["thread",9622397],["thread",9622392],["thread",9622390],["thread",9622386],["thread",9622383],["thread",9622378],["thread",9622377],["thread",9622375],["thread",9622370],["thread",9622364],["thread",9622361],["thread",9622358],["thread",9622357],["thread",9622355],["thread",9620601],["thread",9617893],["thread",9615286],["thread",9614154],["thread",9613138],["thread",9612910],["thread",9611970],["thread",9610342],["thread",9610341],["thread",9610340],["thread",9610339],["thread",9610336],["thread",9610334],["thread",9610333],["thread",9610331],["thread",9610330],["thread",9610329],["thread",9610328],["thread",9610326],["thread",9610324],["thread",9610321],["thread",9610320],["thread",9610317],["thread",9610315],["thread",9610311],["thread",9610308],["thread",9610228],["thread",9610227],["thread",9610224],["thread",9610223],["thread",9610222],["thread",9610221],["thread",9610219],["thread",9610217],["thread",9610211],["thread",9610209],["thread",9610207],["thread",9610204],["thread",9609982],["thread",9609981],["thread",9609979],["thread",9609977],["thread",9609976],["thread",9609974],["thread",9609972],["thread",9609971],["thread",9609970],["thread",9609969],["thread",9609968],["thread",9609965],["thread",9609962],["thread",9609960],["thread",9609956],["thread",9609955],["thread",9609953],["thread",9609952],["thread",9609951],["thread",9609950],["thread",9609949],["thread",9609574],["thread",9609572],["thread",9609449],["thread",9609414],["thread",9609329],["thread",9609325],["thread",9609321],["thread",9609215],["thread",9609211],["thread",9609203],["thread",9609196],["thread",9609193],["thread",9609191],["thread",9609186],["thread",9609179],["thread",9609175],["thread",9609169],["thread",9609110],["thread",9609107],["thread",9609103],["thread",9609102],["thread",9609030],["thread",9609029],["thread",9609026],["thread",9609025],["thread",9609015],["thread",9609014],["thread",9609010],["thread",9609007],["thread",9609005],["thread",9609004],["thread",9609002],["thread",9609001],["thread",9608968],["thread",9608964],["thread",9608961],["thread",9608959],["thread",9608946],["thread",9608942],["thread",9608924],["thread",9608915],["thread",9608767],["thread",9608632],["thread",9608627],["thread",9608621],["thread",9608609],["thread",9608607],["thread",9608606],["thread",9608595],["thread",9608590],["thread",9608583],["thread",9608580],["thread",9608577],["thread",9608568],["thread",9608564],["thread",9608519],["thread",9608514],["thread",9608509],["thread",9608338],["thread",9608310],["thread",9608306],["thread",9608297],["thread",9608295],["thread",9608294],["thread",9608293],["thread",9608291],["thread",9608289],["thread",9608288],["thread",9608287],["thread",9608285],["thread",9608279],["thread",9608277],["thread",9608276],["thread",9608275],["thread",9608274],["thread",9608271],["thread",9608270],["thread",9608262],["thread",9608261],["thread",9608260],["thread",9608257],["thread",9608253],["thread",9608251],["thread",9608250],["thread",9608249],["thread",9608152],["thread",9608151],["thread",9608150],["thread",9608147],["thread",9608144],["thread",9608142],["thread",9608137],["thread",9608135],["thread",9608128],["thread",9608124],["thread",9608120],["thread",9608115],["thread",9608112],["thread",9608072],["thread",9608070],["thread",9608069],["thread",9608066],["thread",9608061],["thread",9608055],["thread",9607871],["thread",9607866],["thread",9607863],["thread",9607861],["thread",9607860],["thread",9607858],["thread",9607856],["thread",9607852],["thread",9607847],["thread",9607829],["thread",9607823],["thread",9607817],["thread",9607815],["thread",9607813],["thread",9607808],["thread",9607802],["thread",9607797],["thread",9607795],["thread",9607791],["thread",9607754],["thread",9607730],["thread",9607604],["thread",9607602],["thread",9601379],["thread",9600817],["thread",9600426],["thread",9600168],["thread",9599340],["thread",9598739],["thread",9594769],["thread",9578637],["thread",9570809],["thread",9569509],["thread",9568336],["thread",9554916],["thread",9552746],["thread",9549855],["thread",9548961],["thread",9544077],["thread",9541701],["thread",9540101],["thread",9540095],["thread",9540094],["thread",9540092],["thread",9540091],["thread",9540085],["thread",9538470],["thread",9535237],["thread",9530224],["thread",9530208],["thread",9529534],["thread",9527482],["thread",9527033],["thread",9520593],["thread",9514556],["thread",9514238],["thread",9513674],["thread",9511943],["thread",9509518],["thread",9504558],["thread",9502775],["thread",9502593],["thread",9500505],["thread",9499864],["thread",9499099],["thread",9497714],["thread",9496543],["thread",9494546],["thread",9492597],["thread",9491585],["thread",9491217],["thread",9486108],["thread",9485536],["thread",9483403],["thread",9482501],["thread",9482026],["thread",9478576],["thread",9476241],["thread",9476240],["thread",9475619],["thread",9475110],["thread",9475105],["thread",9474665],["thread",9474534],["thread",9474276],["thread",9474197],["thread",9473818],["thread",9473459],["thread",9472800],["thread",9472756],["thread",9472754],["thread",9471082],["thread",9469271],["thread",9468581],["thread",9468241],["thread",9465244],["thread",9463746],["thread",9461228],["thread",9454913],["thread",9454772],["thread",9454711],["thread",9454277],["thread",9450562],["thread",9449893],["thread",9449647],["thread",9449645],["thread",9449627],["thread",9447125],["thread",9444396],["thread",9442312],["thread",9442021],["thread",9440417],["thread",9438933],["thread",9435651],["thread",9435415],["thread",9429125],["thread",9425682],["thread",9422273],["thread",9421446],["thread",9421284],["thread",9421169],["thread",9420894],["thread",9420051],["thread",9419604],["thread",9416481],["thread",9415510],["thread",9414896],["thread",9413819],["thread",9412509],["thread",9412038],["thread",9411597],["thread",9411213],["thread",9410823],["thread",9410808],["thread",9408111],["thread",9398458],["thread",9389428],["thread",9385615],["thread",9385007],["thread",9380791],["thread",9373205],["thread",9372744],["thread",9366502],["thread",9365767],["thread",9364375],["thread",9363481],["thread",9362530],["thread",9362369],["thread",9360616],["thread",9356880],["thread",9354712],["thread",9349727],["thread",9349561],["thread",9345289],["thread",9337004],["thread",9334360],["thread",9329831],["thread",9327536],["thread",9325445],["thread",9324825],["thread",9324655],["thread",9322273],["thread",9318287],["thread",9317828],["thread",9317822],["thread",9317482],["thread",9316807],["thread",9314811],["thread",9310152],["thread",9309481],["thread",9308345],["thread",9307666],["thread",9306551],["thread",9306534],["thread",9304762],["thread",9304171],["thread",9304149],["thread",9303164],["thread",9302662],["thread",9301404],["thread",9298212],["thread",9296971],["thread",9293823],["thread",9289708],["thread",9282282],["thread",9280743],["thread",9277973],["thread",9277970],["thread",9273250],["thread",9272400],["thread",9272398],["thread",9270330],["thread",9269852],["thread",9268859],["thread",9265788],["thread",9263710],["thread",9262776],["thread",9262287],["thread",9262278],["thread",9258106],["thread",9256128],["thread",9249735],["thread",9241016],["thread",9236783],["thread",9236263],["thread",9236194],["thread",9232256],["thread",9231261],["thread",9228589],["thread",9226837],["thread",9223515],["thread",9217184],["thread",9216839],["thread",9213825],["thread",9213782],["thread",9213781],["thread",9211856],["thread",9211835],["thread",9208544],["thread",9204845],["thread",9204333],["thread",9201607],["thread",9189710],["thread",9175792],["thread",9172202],["thread",9164875],["thread",9164732],["thread",9162030],["thread",9162002],["thread",9160900],["thread",9160881],["thread",9160869],["thread",9160866],["thread",9154237],["thread",9150969],["thread",9148253],["thread",9147785],["thread",9143255],["thread",9140293],["thread",9135343],["thread",9133291],["thread",9128269],["thread",9127949],["thread",9121557],["thread",9119879],["thread",9119874],["thread",9117426],["thread",9111423],["thread",9110810],["thread",9109591],["thread",9109536],["thread",9108591],["thread",9107671],["thread",9107433],["thread",9107373],["thread",9105674],["thread",9099052],["thread",9098903],["thread",9094249],["thread",9089455],["thread",9088419],["thread",9087238],["thread",9084560],["thread",9081267],["thread",9072705],["thread",9052801],["thread",9052050],["thread",9049127],["thread",9048268],["thread",9047295],["thread",9040862],["thread",9040384],["thread",9039589],["thread",9038231],["thread",9037864],["thread",9036121],["thread",9025724],["thread",9022814],["thread",9012249],["thread",9008651],["thread",9004702],["thread",9002132],["thread",9001907],["thread",8996087],["thread",8993118],["thread",8993112],["thread",8979427],["thread",8976539],["thread",8970470],["thread",8969474],["thread",8951637],["thread",8948825],["thread",8947855],["thread",8946090],["thread",8934347],["thread",8931633],["thread",8924023],["thread",8917927],["thread",8916957],["thread",8916672],["thread",8913772],["thread",8908270],["thread",8908062],["thread",8907020],["thread",8905799],["thread",8905053],["thread",8904561],["thread",8903554],["thread",8900640],["thread",8900519],["thread",8898907],["thread",8894271],["thread",8894018],["thread",8893010],["thread",8891389],["thread",8886701],["thread",8884291],["thread",8876716],["thread",8868394],["thread",8868057],["thread",8867747],["thread",8867624],["thread",8867548],["thread",8865727],["thread",8862683],["thread",8862665],["thread",8861113],["thread",8861036],["thread",8860011],["thread",8859313],["thread",8855166],["thread",8854986],["thread",8853337],["thread",8851494],["thread",8841220],["thread",8836523],["thread",8836443],["thread",8836417],["thread",8834946],["thread",8829847],["thread",8829277],["thread",8828452],["thread",8827690],["thread",8825598],["thread",8824391],["thread",8821356],["thread",8818337],["thread",8814053],["thread",8813736],["thread",8813537],["thread",8810896],["thread",8809418],["thread",8808870],["thread",8808177],["thread",8808164],["thread",8808154],["thread",8805993],["thread",8803715],["thread",8802431],["thread",8802178],["thread",8801149],["thread",8794133],["thread",8794003],["thread",8790764],["thread",8788535],["thread",8786649],["thread",8786160],["thread",8784193],["thread",8784008],["thread",8781394],["thread",8781102],["thread",8780979],["thread",8780122],["thread",8778496],["thread",8773769],["thread",8773646],["thread",8772097],["thread",8770352],["thread",8769178],["thread",8768745],["thread",8767319],["thread",8766912],["thread",8766166],["thread",8763263],["thread",8762329],["thread",8759730],["thread",8757345],["thread",8753202],["thread",8753173],["thread",8749462],["thread",8747239],["thread",8744745],["thread",8744280],["thread",8742297],["thread",8733246],["thread",8729094],["thread",8728814],["thread",8726968],["thread",8726801],["thread",8726095],["thread",8720314],["thread",8719739],["thread",8712841],["thread",8711677],["thread",8689693],["thread",8689473],["thread",8689466],["thread",8684250],["thread",8684072],["thread",8675810],["thread",8674620],["thread",8664229],["thread",8660278],["thread",8659739],["thread",8651057],["thread",8640037],["thread",8629095],["thread",8608108],["thread",8603366],["thread",8599994],["thread",8590842],["thread",8582751],["thread",8565148],["thread",8552245],["thread",8548757],["thread",8546312],["thread",8522579],["thread",8518549],["thread",8476605],["thread",8443992],["thread",8443438],["thread",8424029],["thread",8403158],["thread",8397583],["thread",8348700],["thread",8325557],["thread",8323691],["thread",8293093],["thread",8170058],["thread",8145410],["thread",8091694],["thread",7460374],["thread",7281268],["thread",6121389],["thread",4867048],["thread",1961017]], 709, tinhte_xentag_tag, , {"tags":["b\u00e0n sofa"]}, date, 0, , [], 0, 1660074165, d18b43ee41828658029ec8885c7ada18
Run Time: 0.000727
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: 119
Run Time: 0.000777
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 (9694561, 9693353, 9690528, 9686062, 9673914, 9673199, 9673076, 9672168, 9671981, 9670707, 9670193, 9670039, 9669527, 9669523, 9667590, 9667364, 9662958, 9660623, 9659242)
Run Time: 0.001534
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: 543027
Run Time: 0.011127
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , Tinhte_XenTag_ControllerPublic_Tag, View, valid, t=b%C3%A0n+sofa, 1660074165,
Run Time: 0.000423
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000239
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 > 1660073265)
ORDER BY session_activity.view_date DESC
Run Time: 0.006108
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 1801 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |