SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000297
| 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 = 'cho thuê văn phòng')
Run Time: 0.000493
| 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: 62929613
Run Time: 0.000354
| 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: 44
Run Time: 0.000894
| 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, 44
Run Time: 0.000200
| 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 (9694603, 9694602, 9692855, 9691182, 9689983, 9688375, 9684958, 9683870, 9681356, 9680911, 9679910, 9679890, 9679141, 9679139, 9679064, 9678823, 9678822, 9678767, 9678342, 9677966, 9677856, 9677855, 9677394, 9677316, 9676928, 9676568, 9676559, 9676325, 9676245, 9676243, 9676180, 9675311, 9675309, 9674929, 9674353, 9674352, 9673947, 9673743, 9673643, 9673311, 9672416, 9671720, 9671565, 9671221, 9671136, 9671103, 9671030, 9670563, 9670171, 9670064, 9670000, 9669831, 9669130, 9668129, 9667944, 9667804, 9666479, 9666016, 9665823, 9663427, 9661343, 9659886, 9658768, 9658767, 9658520, 9658109, 9653196, 9653195, 9651359, 9651358, 9650120, 9648330, 9648306, 9647871, 9647869, 9645934, 9641609, 9639152, 9637572, 9637331, 9637130, 9636630, 9636629, 9636049, 9627134, 9627133, 9624544, 9616367, 9616090, 9612386, 9608832, 9608831, 9605364, 9597835, 9592989, 9592986, 9590782, 9589884, 9588164, 9585965, 9583920, 9583036, 9582478, 9582128, 9577956, 9575771, 9573518, 9570031, 9568951, 9567701, 9565840, 9565019, 9564324, 9562890, 9561807, 9561719, 9561050, 9559844, 9559530, 9559524, 9557214, 9556578, 9556190, 9555961, 9551872, 9548147, 9547284, 9547283, 9543706, 9539749, 9539108, 9538728, 9537497, 9535639, 9535616, 9533059, 9532020, 9531623, 9530167, 9527299, 9526082, 9522579, 9520382, 9520371, 9519556, 9519426, 9518482, 9518447, 9518432, 9516778, 9514129, 9514127, 9513182, 9513097, 9510956, 9508296, 9508294, 9508100, 9503299, 9503292, 9503290, 9502768, 9501479, 9500928, 9500600, 9500001, 9500000, 9499998, 9499692, 9497837, 9497187, 9496439, 9495593, 9495301, 9495183, 9493773, 9493691, 9493689, 9493687, 9493485, 9493483, 9493482, 9491626, 9491349, 9487054, 9486507, 9486329, 9485733, 9485708, 9485565, 9485454, 9485453, 9484358, 9483776, 9483699, 9483413, 9483396, 9483331, 9483116, 9483102, 9483088, 9483087, 9483086, 9483068, 9482128, 9480989, 9479736, 9477185, 9475525, 9475524, 9475523, 9475140, 9474131, 9471690, 9470498, 9470497, 9468664, 9466759, 9466755, 9466700, 9466696, 9466166, 9465587, 9464375, 9461182, 9460297, 9460178, 9460144, 9459744, 9458650, 9456211, 9455573, 9454358, 9452738, 9452709, 9452708, 9452552, 9452172, 9452162, 9451821, 9450471, 9450380, 9450260, 9450170, 9450087, 9450085, 9450076, 9449985, 9448414, 9448412, 9448411, 9446093, 9446092, 9445904, 9443114, 9442711, 9442022, 9442017, 9440991, 9440409, 9439068, 9438281, 9438280, 9436068, 9434934, 9433853, 9433851, 9433804, 9432602, 9432562, 9430591, 9429954, 9429628, 9428893, 9426288, 9425703, 9425702, 9424927, 9424630, 9422931, 9421702, 9420626, 9420255, 9419610, 9419608, 9417521, 9417062, 9416308, 9414953, 9413474, 9413073, 9412775, 9410637, 9410087, 9408297, 9406019, 9404797, 9404316, 9402333, 9400700, 9398973, 9398336, 9396400, 9396073, 9395363, 9389974, 9389579, 9389499, 9388975, 9387883, 9387736, 9387735, 9387465, 9387248, 9384716, 9382391, 9381442, 9381441, 9380822, 9377071, 9375990, 9375857, 9374501, 9374065, 9374009, 9373346, 9372865, 9372548, 9372209, 9371568, 9371358, 9371096, 9370820, 9370023, 9369978, 9369976, 9369974, 9369803, 9369632, 9369460, 9369342, 9369339, 9368826, 9368295, 9368069, 9367373, 9365758, 9364115, 9363105, 9362803, 9361808, 9360954, 9359607, 9358893, 9358698, 9358465, 9358356, 9356425, 9356238, 9355965, 9355964, 9355378, 9355338, 9353720, 9352532, 9352470, 9351687, 9351078, 9350871, 9349789, 9348118, 9346360, 9345105, 9344997, 9344048, 9341775, 9341111, 9341110, 9337767, 9337766, 9337157, 9337001, 9336997, 9336957, 9335797, 9331467, 9331277, 9331276, 9330250, 9327853, 9326881, 9326880, 9326838, 9325719, 9325715, 9325578, 9325217, 9325216, 9325159, 9324867, 9324866, 9323690, 9323093, 9322928, 9322927, 9321663, 9321652, 9321586, 9321585, 9320204, 9319570, 9318770, 9317493, 9315525, 9315524, 9313349, 9313111, 9311848, 9311677, 9310870, 9310364, 9309962, 9309888, 9309887, 9309707, 9308929, 9308926, 9308641, 9308245, 9306345, 9306329, 9303781, 9299879, 9299878, 9299848, 9299847, 9299846, 9299845, 9298125, 9295351, 9292474, 9292195, 9291544, 9291543, 9291542, 9291340, 9289999, 9289994, 9289500, 9288863, 9286748, 9286747, 9286211, 9285924, 9284494, 9283099, 9283098, 9282457, 9282090, 9282083, 9282082, 9282080, 9281486, 9280753, 9280747, 9280599, 9280166, 9279689, 9279536, 9278924, 9278820, 9278672, 9278671, 9276587, 9276586, 9276342, 9275786, 9275420, 9275208, 9275193, 9274705, 9274615, 9274590, 9274565, 9274554, 9273953, 9273271, 9272915, 9272572, 9272531, 9271744, 9271533, 9271532, 9271531, 9271530, 9271419, 9271260, 9270996, 9270266, 9270156, 9269764, 9269747, 9269582, 9267922, 9267555, 9267554, 9267552, 9266234, 9265493, 9265492, 9264314, 9264143, 9263909, 9262782, 9261711, 9261704, 9261689, 9260853, 9259863, 9258496, 9258008, 9258007, 9255014, 9254340, 9254171, 9254021, 9254019, 9253923, 9253442, 9253315, 9253219, 9252999, 9252049, 9252040, 9251759, 9250695, 9249060, 9248973, 9248754, 9248493, 9247698, 9247306, 9246518, 9246307, 9246298, 9246176, 9245699, 9245118, 9244643, 9244642, 9244636, 9244618, 9244220, 9243594, 9243582, 9243516, 9243515, 9243513, 9243512, 9243484, 9243187, 9243129, 9243044, 9242392, 9242233, 9241713, 9240998, 9240997, 9240790, 9240766, 9240099, 9239826, 9239608, 9239503, 9239419, 9239395, 9239119, 9238659, 9238083, 9238040, 9237879, 9237859, 9237844, 9237682, 9237183, 9236580, 9236579, 9236193, 9236109, 9236101, 9236051, 9235985, 9235242, 9235227, 9235221, 9234404, 9234362, 9234360, 9234152, 9234025, 9234024, 9233785, 9233623, 9233205, 9233126, 9232650, 9232541, 9232396, 9232390, 9232389, 9231287, 9231286, 9230596, 9230522, 9230446, 9230163, 9230020, 9229469, 9229121, 9229109, 9228863, 9228861, 9228860, 9228291, 9227975, 9227945, 9226650, 9225975, 9225652, 9225592, 9225580, 9225166, 9224982, 9224555, 9222449, 9222030, 9221776, 9221772, 9221509, 9221054, 9221053, 9220932, 9220768, 9220570, 9220284, 9220225, 9219461, 9218265, 9216819, 9216026, 9215336, 9214807, 9214801, 9214291, 9211538, 9210544, 9210425, 9210246, 9209779, 9209694, 9209296, 9209294, 9208332, 9208331, 9207921, 9207919, 9207918, 9207915, 9206284, 9206181, 9205645, 9205525, 9205274, 9205246, 9204678, 9204046, 9204004, 9203827, 9203786, 9203740, 9203739, 9202690, 9202544, 9202376, 9202375, 9202060, 9201766, 9201765, 9201248, 9201104, 9200796, 9200157, 9200092, 9199996, 9199994, 9199991, 9199988, 9199722, 9199104, 9198859, 9198847, 9198349, 9197943, 9197189, 9197150, 9197114, 9196664, 9196630, 9196629, 9196627, 9196626, 9196300, 9195972, 9195567, 9195492, 9195273, 9195272, 9195271, 9195235, 9195234, 9195069, 9195020, 9194522, 9194355, 9193397, 9193268, 9192892, 9191275, 9190929, 9190880, 9190876, 9190537, 9190368, 9190367, 9189797, 9189317, 9188708, 9188067, 9187458, 9187398, 9186844, 9186676, 9186082, 9186081, 9185883, 9185726, 9185564, 9185309, 9185120, 9185119, 9185117, 9185048, 9185047, 9185046, 9184885, 9184794, 9184277, 9183596, 9183595, 9183499, 9183323, 9183320, 9182722, 9182710, 9182705, 9182702, 9181473, 9181257, 9181256, 9181255, 9181036, 9181035, 9180991, 9180702, 9180440, 9180439, 9180166, 9180165, 9180164, 9178582, 9177670, 9177601, 9177117, 9177115, 9177073, 9176952, 9176942, 9176861, 9176117, 9173445, 9173307, 9172686, 9172293, 9171798, 9171765, 9171726, 9171702, 9171687, 9171384, 9171266, 9171119, 9170104, 9168634, 9168569, 9167824, 9167220, 9166804, 9166539, 9166538, 9166121, 9164946, 9164945, 9164717, 9164599, 9164457, 9164393, 9164054, 9162876, 9162321, 9162299, 9162274, 9162250, 9161355, 9161350, 9159651, 9158075, 9156278, 9156277, 9156276, 9156009, 9156007, 9155266, 9155078, 9154562, 9153923, 9153659, 9153418, 9153364, 9153196, 9153170, 9152737, 9152732, 9152731, 9152575, 9152354, 9152131, 9151935, 9151873, 9151710, 9151520, 9151101, 9150566, 9150543, 9150359, 9150346, 9150110, 9149542, 9148764, 9147928, 9146749, 9145225, 9144431, 9143509, 9143030, 9142627, 9142327, 9142264, 9141838, 9141837, 9140766, 9138825, 9138304, 9137464, 9137244, 9136945, 9136637, 9136346, 9135546, 9135545, 9135108, 9135066, 9134489, 9134439, 9134183, 9134181, 9133832, 9133831, 9133354, 9132558, 9130832, 9130831, 9130327, 9129019, 9128042, 9127971, 9127740, 9127175, 9127163, 9127162, 9127161, 9126917, 9125991, 9125571, 9122894, 9122891, 9122621, 9122083, 9121669, 9121485, 9119021, 9119016, 9118552, 9118474, 9117863, 9117384, 9113418, 9113417, 9112021, 9111596, 9111595, 9111594, 9111373, 9111145, 9110462, 9110395, 9110206, 9107370, 9107317, 9106672, 9104948, 9102893, 9102892, 9101453, 9101358, 9101320, 9101103, 9101055, 9100447, 9100428, 9100205, 9099817, 9099665, 9099062, 9097014, 9096313, 9096311, 9096294, 9096019, 9095830, 9095772, 9095771, 9095081, 9094599, 9094209, 9093538, 9092684, 9092628, 9092618, 9092253, 9092000, 9091238, 9091237, 9090977, 9090280, 9090268, 9089263, 9089260, 9089245, 9088505, 9088330, 9088289, 9088166, 9088165, 9087771, 9087769, 9087311, 9086915, 9086487, 9086270, 9086050, 9086045, 9086036, 9086032, 9085479, 9085103, 9084957, 9084646, 9083237, 9083204, 9083070, 9083057, 9082259, 9082206, 9082020, 9081155, 9081114, 9080509, 9080492, 9080442, 9079921, 9079798, 9079765, 9079650, 9079645, 9079640, 9079420, 9078745, 9078703, 9078699, 9078474, 9078304, 9078070, 9077818, 9077711, 9076625, 9076205, 9076204, 9072678, 9070799, 9069257, 9068441, 9068424, 9067471, 9067456, 9066897, 9066359, 9065890, 9065579, 9062329, 9060037, 9059810, 9058965, 9058486, 9058350, 9057974, 9057871, 9057857, 9057562, 9057555, 9057508, 9056847, 9056520, 9056489, 9056288, 9054980, 9054398, 9054389, 9054112, 9054111, 9054108, 9054107, 9053994, 9053602, 9053234, 9053070, 9053069, 9053068, 9052833, 9052776, 9052225, 9052221, 9051446, 9051432, 9051327, 9051207, 9051115, 9050693, 9050056, 9050053, 9049755, 9049754, 9049446, 9049445, 9049444, 9049011, 9048785, 9048273, 9048272, 9048270, 9047762, 9046714, 9046636, 9046107, 9046094, 9046092, 9046007, 9045992, 9045374, 9043970, 9043958, 9043512, 9043327, 9043285, 9043136, 9042951, 9042862, 9042568, 9042433, 9042409, 9041235, 9041231, 9041217, 9041007, 9040986, 9040829, 9040785, 9040235, 9040232, 9040142, 9040140, 9039856, 9039441, 9039313, 9039312, 9039178, 9037627, 9036296, 9035983, 9035901, 9035900, 9035898, 9035897, 9035589, 9035538, 9035529, 9035140, 9034990, 9034588, 9034504, 9034232, 9033212, 9033202, 9032202, 9032157, 9032046, 9031712, 9031477, 9031474, 9031298, 9031292, 9031289, 9031285, 9031243, 9030992, 9030877, 9030835, 9030307, 9030174, 9029733, 9029395, 9029299, 9029255, 9029240, 9029224, 9029223, 9029222, 9029005, 9028997, 9028978, 9028803, 9028252, 9028212, 9028022, 9027928, 9027896, 9027891, 9027859, 9026607, 9026531, 9025926, 9025469, 9025392, 9024985, 9024357, 9023804, 9023372, 9022942, 9022593, 9022460, 9022175, 9022121, 9021936, 9021360, 9020478, 9019598, 9019558, 9019153, 9019143, 9019083, 9018930, 9018393, 9018278, 9018277, 9018209, 9018167, 9018153, 9017591, 9017394, 9016919, 9016917, 9016595, 9016507, 9016506, 9016328, 9016294, 9015948, 9015940, 9015907, 9015889, 9015888, 9015882, 9015879, 9015841, 9015408, 9015372, 9015370, 9015367, 9015337, 9015283, 9015253, 9015252, 9015248, 9015242, 9014765, 9014761, 9014727, 9014017, 9013992, 9013581, 9013554, 9013553, 9013499, 9013497, 9013209, 9013139, 9013059, 9012972, 9012970, 9012835, 9012827, 9012821, 9012693, 9012683, 9012646, 9012636, 9012129, 9012122, 9012043, 9012039, 9012034, 9012031, 9012024, 9012023, 9012014, 9012010, 9011705, 9011698, 9011695, 9011625, 9011396, 9011395, 9011388, 9011316, 9010866, 9010857, 9010851, 9010824, 9010636, 9009714, 9009173, 9008806, 9007422, 9007386, 9007183, 9007151, 9006930, 9006443, 9006126, 9006050, 9005805, 9005586, 9005585, 9005540, 9005155, 9005076, 9005064, 9005058, 9005035, 9005034, 9004978, 9004973, 9004676, 9004640, 9004554, 9004194, 9004170, 9003920, 9003891, 9003869, 9003634, 9002831, 9002269, 9001764, 9000084, 9000083, 8999771, 8999767, 8999636, 8999633, 8999612, 8999606, 8999500, 8998827, 8996915, 8993441, 8992562, 8991259, 8991169, 8990775, 8990761, 8990419, 8990002, 8989149, 8988458, 8988032, 8987506, 8987264, 8987263, 8987180, 8987175, 8987173, 8987165, 8987027, 8986610, 8986577, 8986527, 8986438, 8986388, 8986293, 8986284, 8986280, 8986270, 8986247, 8986237, 8985698, 8985658, 8985578, 8985517, 8985489, 8985468, 8985198, 8985193, 8985182, 8985170, 8984888, 8984297, 8984263, 8984258, 8984255, 8984252, 8984246, 8983182, 8982037, 8982030, 8982029, 8982025, 8982014, 8981603, 8981588, 8981544, 8981520, 8981504, 8981287, 8981263, 8980745, 8980560, 8980548, 8980494, 8980188, 8980183, 8980178, 8980172, 8980169, 8979789, 8979729, 8979717, 8979716, 8979714, 8979390, 8979388, 8979385, 8979382, 8979381, 8979364, 8979152, 8979134, 8979081, 8978763, 8978689, 8978395, 8978390, 8977611, 8976420, 8976419, 8976359, 8975084, 8975083, 8975082, 8974141, 8973618, 8973546, 8973497, 8973365, 8972685, 8972178, 8970698, 8970697, 8970360, 8969985, 8969540, 8968984, 8968941, 8968836, 8967620, 8967177, 8966711, 8964429, 8964396, 8962620, 8960169, 8959023, 8958843, 8958842, 8958841, 8957171, 8956138, 8956118, 8956075, 8956073, 8956069, 8956056, 8956052, 8955904, 8955413, 8954883, 8954424, 8954423, 8954226, 8953746, 8953304, 8953247, 8951715, 8951215, 8950755, 8950464, 8950334, 8950333, 8950100, 8949588, 8948962, 8948618, 8948617, 8948102, 8944601, 8944466, 8944465, 8944459, 8944362, 8944355, 8944347, 8944325, 8944279, 8944266, 8944204, 8943989, 8943987, 8943389, 8940193, 8938578, 8938569, 8938568, 8938450, 8937507, 8937426, 8937004, 8936822, 8935945, 8935722, 8935721, 8934162, 8933419, 8932093, 8932092, 8931809, 8931650, 8930595, 8930545, 8930500, 8930396, 8929487, 8929485, 8929483, 8929448, 8929207, 8928665, 8927305, 8927240, 8927083, 8926645, 8926362, 8926360, 8925419, 8925259, 8925036, 8925034, 8924954, 8924391, 8923371, 8922126, 8921595, 8921594, 8920616, 8920374, 8919651, 8919647, 8919643, 8919382, 8919260, 8919259, 8919032, 8918997, 8918829, 8918795, 8917989, 8917987, 8916161, 8916158, 8915257, 8913978, 8912953, 8912881, 8912880, 8912801, 8912623, 8912242, 8912199, 8912196, 8911043, 8910112, 8909602, 8909416, 8909126, 8909081, 8908590, 8908589, 8908169, 8908167, 8907948, 8907906, 8907905, 8907901, 8907866, 8907524, 8907328, 8907276, 8906400, 8906395, 8906375, 8906365, 8906347, 8906261, 8905092, 8905080, 8905077, 8905074, 8905072, 8905067, 8905020, 8905018, 8905014, 8904883, 8904871, 8904867, 8904861, 8904857, 8904263, 8904154, 8904150, 8904144, 8904122, 8904112, 8903746, 8902736, 8902280, 8902279, 8901168, 8901146, 8901145, 8900492, 8900490, 8900489, 8900487, 8900482, 8900478, 8900341, 8899874, 8897953, 8897933, 8897930, 8897668, 8897220, 8897122, 8897046, 8896918, 8896113, 8895622, 8895619, 8895618, 8895617, 8895177, 8893917, 8893891, 8893362, 8892164, 8891299, 8890269, 8890266, 8887821, 8887537, 8887421, 8887151, 8886958, 8886954, 8885878, 8885871, 8883057, 8882893, 8882892, 8881952, 8881951, 8881949, 8881490, 8881048, 8881034, 8880865, 8879519, 8879107, 8877552, 8877125, 8873933, 8869638, 8867622, 8867593, 8866054, 8865288, 8865081, 8865080, 8864567, 8864504, 8864278, 8863681, 8863676, 8863464, 8862199, 8862102, 8861344, 8860664, 8859179, 8858762, 8857926, 8857923, 8857398, 8857192, 8857123, 8857122, 8856906, 8855995, 8855978, 8854607, 8854427, 8852360, 8851913, 8851912, 8850472, 8850317, 8849781, 8849780, 8849740, 8849739, 8849614, 8849234, 8848866, 8848708, 8848423, 8847985, 8847984, 8847933, 8847926, 8847825, 8847301, 8847152, 8845134, 8845133, 8844726, 8844725, 8844124, 8842458, 8842093, 8842092, 8842091, 8841569, 8841339, 8840923, 8840916, 8840915, 8840761, 8840760, 8840405, 8840080, 8838657, 8838641, 8838640, 8838575, 8838182, 8838181, 8837581, 8836070, 8835550, 8835104, 8835092, 8834668, 8834626, 8834244, 8833651, 8833155, 8832801, 8832799, 8832685, 8832683, 8832607, 8831945, 8831274, 8830734, 8830031, 8828635, 8828528, 8828481, 8826565, 8826443, 8825675, 8825653, 8825182, 8825151, 8824763, 8824713, 8824261, 8824023, 8823969, 8823933, 8823868, 8823722, 8823657, 8822804, 8822314, 8821913, 8818997, 8817699, 8817383, 8817239, 8814938, 8814920, 8814878, 8814836, 8814534, 8814451, 8813759, 8812359, 8811962, 8811954, 8811180, 8811129, 8809545, 8809377, 8809183, 8809055, 8808712, 8808185, 8807271, 8807183, 8806264, 8805940, 8805921, 8805800, 8805578, 8805028, 8803994, 8803930, 8803833, 8803620, 8803234, 8803095, 8802014, 8801240, 8800491, 8799705, 8798930, 8798214, 8797649, 8797400, 8797108, 8797107, 8796391, 8795607, 8795606, 8795604, 8795602, 8794240, 8792790, 8792068, 8791845, 8790875, 8790738, 8790736, 8790691, 8789952, 8789788, 8789511, 8789269, 8789265, 8788643, 8788524, 8787617, 8787361, 8786827, 8786679, 8786655, 8786290, 8786173, 8785259, 8785130, 8784999, 8784796, 8784218, 8783952, 8783783, 8783752, 8783654, 8783362, 8782384, 8781669, 8780597, 8780301, 8780213, 8779514, 8779486, 8779485, 8779340, 8778815, 8778802, 8778778, 8778440, 8778405, 8778404, 8778298, 8778295, 8778018, 8777321, 8776532, 8776503, 8776293, 8775967, 8775961, 8775222, 8774812, 8774532, 8774483, 8773444, 8772224, 8772185, 8772184, 8771054, 8770768, 8770202, 8770200, 8770199, 8769622, 8769297, 8768945, 8767272, 8766911, 8766454, 8766290, 8766066, 8765102, 8763397, 8760353, 8758725, 8758724, 8758557, 8756586, 8756342, 8755518, 8754890, 8754514, 8754406, 8753948, 8752874, 8751896, 8751746, 8750903, 8749395, 8749392, 8749213, 8748974, 8748973, 8748883, 8748849, 8748846, 8748845, 8748780, 8748323, 8747877, 8747713, 8747693, 8747332, 8746327, 8745754, 8744532, 8744459, 8744458, 8743857, 8743856, 8743855, 8743853, 8743800, 8743742, 8743605, 8743579, 8743343, 8743342, 8742973, 8742495, 8742439, 8741377, 8741113, 8740729, 8740582, 8740575, 8740224, 8740222, 8739823, 8739822, 8738625, 8738624, 8738622, 8738069, 8737554, 8737254, 8735749, 8729225, 8729194, 8729174, 8727724, 8725546, 8717976, 8715945, 8715926, 8704777, 8700631, 8700134, 8690017, 8680359, 8663033, 8661028, 8650880, 8648320, 8646052, 8644589, 8635523, 8610519, 8550628, 8544204, 8542936, 8526482, 8517457, 8511103, 8504587, 8493674, 8483919, 8473086, 8469530, 8459469, 8456746, 8455553, 8445897, 8443186, 8433765, 8424012, 8404737, 8404735, 8404733, 8398822, 8398818, 8398809, 8388671, 8369741, 8366352, 8366335, 8366050, 8362411, 8349139, 8346350, 8335668, 8326505, 8314357, 8298832, 8294866, 8293186, 8280352, 8248837, 8240303, 8234509, 8233605, 8230555, 8225533, 8222642, 8218620, 8211578, 8198891, 8196908, 8195034, 8193498, 8193495, 8188861, 8169945, 8157153, 8157152, 8133033, 8114174, 7757888, 7569263, 1872878)
Run Time: 0.033493
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | <subquery2> | ALL | distinct_key | | | | 2042 | |
| 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 | | | | | 2042 | |
| 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: 44
Run Time: 0.000882
| 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",44],["thread",9694603],["thread",9692855],["thread",9689983],["thread",9688375],["thread",9684958],["thread",9683870],["thread",9681356],["thread",9680911],["thread",9679910],["thread",9679890],["thread",9679141],["thread",9679064],["thread",9678823],["thread",9678767],["thread",9678342],["thread",9677856],["thread",9677394],["thread",9677316],["thread",9676568],["thread",9676559],["thread",9676325],["thread",9676180],["thread",9675311],["thread",9675309],["thread",9674929],["thread",9674353],["thread",9673947],["thread",9673743],["thread",9673643],["thread",9673311],["thread",9671720],["thread",9671565],["thread",9671103],["thread",9671030],["thread",9670563],["thread",9670171],["thread",9670064],["thread",9670000],["thread",9669831],["thread",9669130],["thread",9668129],["thread",9667804],["thread",9666479],["thread",9666016],["thread",9665823],["thread",9663427],["thread",9661343],["thread",9659886],["thread",9658768],["thread",9658767],["thread",9658520],["thread",9658109],["thread",9653196],["thread",9651359],["thread",9650120],["thread",9648330],["thread",9647869],["thread",9645934],["thread",9641609],["thread",9637572],["thread",9637331],["thread",9636630],["thread",9636049],["thread",9627134],["thread",9624544],["thread",9616090],["thread",9612386],["thread",9608832],["thread",9605364],["thread",9597835],["thread",9589884],["thread",9588164],["thread",9583036],["thread",9582478],["thread",9582128],["thread",9577956],["thread",9575771],["thread",9573518],["thread",9570031],["thread",9568951],["thread",9567701],["thread",9565840],["thread",9561807],["thread",9561719],["thread",9561050],["thread",9559524],["thread",9557214],["thread",9556578],["thread",9551872],["thread",9548147],["thread",9547284],["thread",9543706],["thread",9539749],["thread",9535639],["thread",9535616],["thread",9532020],["thread",9531623],["thread",9530167],["thread",9527299],["thread",9526082],["thread",9522579],["thread",9520371],["thread",9519556],["thread",9519426],["thread",9518447],["thread",9516778],["thread",9514129],["thread",9513182],["thread",9510956],["thread",9508296],["thread",9508294],["thread",9508100],["thread",9503299],["thread",9503292],["thread",9502768],["thread",9501479],["thread",9500928],["thread",9500600],["thread",9499692],["thread",9497187],["thread",9495593],["thread",9495183],["thread",9493773],["thread",9493691],["thread",9491626],["thread",9491349],["thread",9485733],["thread",9485708],["thread",9484358],["thread",9483776],["thread",9483413],["thread",9483396],["thread",9483331],["thread",9483116],["thread",9483102],["thread",9483088],["thread",9483068],["thread",9482128],["thread",9480989],["thread",9479736],["thread",9475525],["thread",9475523],["thread",9475140],["thread",9474131],["thread",9471690],["thread",9470498],["thread",9468664],["thread",9466759],["thread",9466755],["thread",9466700],["thread",9466696],["thread",9465587],["thread",9460297],["thread",9460178],["thread",9460144],["thread",9459744],["thread",9458650],["thread",9454358],["thread",9452738],["thread",9452709],["thread",9452552],["thread",9452172],["thread",9450471],["thread",9450380],["thread",9450087],["thread",9450085],["thread",9450076],["thread",9449985],["thread",9448414],["thread",9448412],["thread",9445904],["thread",9440991],["thread",9439068],["thread",9438281],["thread",9436068],["thread",9434934],["thread",9430591],["thread",9429954],["thread",9428893],["thread",9426288],["thread",9425703],["thread",9424927],["thread",9424630],["thread",9422931],["thread",9421702],["thread",9420255],["thread",9417521],["thread",9413474],["thread",9413073],["thread",9412775],["thread",9410087],["thread",9408297],["thread",9404797],["thread",9404316],["thread",9400700],["thread",9398973],["thread",9398336],["thread",9396400],["thread",9396073],["thread",9395363],["thread",9389974],["thread",9388975],["thread",9387883],["thread",9387736],["thread",9387248],["thread",9382391],["thread",9381442],["thread",9380822],["thread",9377071],["thread",9375857],["thread",9374501],["thread",9374065],["thread",9374009],["thread",9373346],["thread",9372865],["thread",9372548],["thread",9371568],["thread",9371358],["thread",9369978],["thread",9369976],["thread",9369974],["thread",9369632],["thread",9369342],["thread",9368069],["thread",9367373],["thread",9365758],["thread",9362803],["thread",9361808],["thread",9359607],["thread",9358893],["thread",9358698],["thread",9358465],["thread",9356238],["thread",9355965],["thread",9353720],["thread",9352532],["thread",9352470],["thread",9351687],["thread",9350871],["thread",9349789],["thread",9348118],["thread",9341775],["thread",9341111],["thread",9337157],["thread",9337001],["thread",9336997],["thread",9336957],["thread",9331467],["thread",9330250],["thread",9325719],["thread",9325715],["thread",9325578],["thread",9325217],["thread",9325159],["thread",9324867],["thread",9323093],["thread",9321663],["thread",9321652],["thread",9321586],["thread",9318770],["thread",9315525],["thread",9313349],["thread",9311677],["thread",9310870],["thread",9310364],["thread",9309962],["thread",9309888],["thread",9309707],["thread",9306345],["thread",9306329],["thread",9303781],["thread",9299879],["thread",9292195],["thread",9289999],["thread",9289994],["thread",9289500],["thread",9288863],["thread",9286748],["thread",9283099],["thread",9282090],["thread",9282083],["thread",9278820],["thread",9278672],["thread",9276587],["thread",9275786],["thread",9275420],["thread",9275208],["thread",9275193],["thread",9274705],["thread",9274615],["thread",9274565],["thread",9274554],["thread",9272915],["thread",9271744],["thread",9271533],["thread",9270266],["thread",9269764],["thread",9269582],["thread",9266234],["thread",9260853],["thread",9258496],["thread",9258008],["thread",9255014],["thread",9254171],["thread",9252999],["thread",9252049],["thread",9252040],["thread",9251759],["thread",9248973],["thread",9247698],["thread",9246307],["thread",9246298],["thread",9246176],["thread",9245118],["thread",9244643],["thread",9244220],["thread",9243594],["thread",9243582],["thread",9242392],["thread",9242233],["thread",9241713],["thread",9240998],["thread",9240099],["thread",9239503],["thread",9239395],["thread",9239119],["thread",9238659],["thread",9238083],["thread",9237879],["thread",9237859],["thread",9237844],["thread",9236109],["thread",9236101],["thread",9236051],["thread",9235985],["thread",9235242],["thread",9235221],["thread",9234404],["thread",9234025],["thread",9233785],["thread",9233623],["thread",9233126],["thread",9232541],["thread",9232396],["thread",9232390],["thread",9232389],["thread",9231287],["thread",9230596],["thread",9230522],["thread",9230163],["thread",9230020],["thread",9229121],["thread",9229109],["thread",9226650],["thread",9225975],["thread",9225652],["thread",9225166],["thread",9224982],["thread",9222449],["thread",9221776],["thread",9221509],["thread",9221054],["thread",9220932],["thread",9220284],["thread",9219461],["thread",9216026],["thread",9214807],["thread",9214801],["thread",9211538],["thread",9210246],["thread",9209779],["thread",9209694],["thread",9208332],["thread",9206181],["thread",9205274],["thread",9204678],["thread",9204004],["thread",9203827],["thread",9203786],["thread",9203740],["thread",9202690],["thread",9201248],["thread",9201104],["thread",9200157],["thread",9199996],["thread",9199994],["thread",9199722],["thread",9198859],["thread",9198847],["thread",9198349],["thread",9197943],["thread",9197189],["thread",9197150],["thread",9197114],["thread",9196664],["thread",9196300],["thread",9195567],["thread",9195492],["thread",9195273],["thread",9195234],["thread",9195069],["thread",9192892],["thread",9190929],["thread",9190876],["thread",9190537],["thread",9190368],["thread",9189797],["thread",9189317],["thread",9188708],["thread",9188067],["thread",9187458],["thread",9187398],["thread",9186844],["thread",9186676],["thread",9185564],["thread",9185309],["thread",9185120],["thread",9185117],["thread",9184885],["thread",9184794],["thread",9184277],["thread",9183596],["thread",9182710],["thread",9181473],["thread",9181036],["thread",9180991],["thread",9180702],["thread",9180166],["thread",9177601],["thread",9177117],["thread",9177073],["thread",9176952],["thread",9176942],["thread",9176861],["thread",9173445],["thread",9172293],["thread",9171765],["thread",9171726],["thread",9171702],["thread",9171687],["thread",9171384],["thread",9171119],["thread",9170104],["thread",9167824],["thread",9167220],["thread",9166804],["thread",9166539],["thread",9166121],["thread",9164599],["thread",9164457],["thread",9164393],["thread",9164054],["thread",9162876],["thread",9162321],["thread",9162299],["thread",9162274],["thread",9162250],["thread",9161355],["thread",9161350],["thread",9159651],["thread",9158075],["thread",9156278],["thread",9155266],["thread",9155078],["thread",9154562],["thread",9153923],["thread",9153659],["thread",9153418],["thread",9153364],["thread",9153170],["thread",9152732],["thread",9152354],["thread",9151935],["thread",9151710],["thread",9151520],["thread",9151101],["thread",9150566],["thread",9150543],["thread",9150359],["thread",9150346],["thread",9149542],["thread",9148764],["thread",9147928],["thread",9145225],["thread",9143509],["thread",9143030],["thread",9142327],["thread",9137244],["thread",9136945],["thread",9136637],["thread",9136346],["thread",9135546],["thread",9135108],["thread",9135066],["thread",9128042],["thread",9127971],["thread",9127740],["thread",9126917],["thread",9125571],["thread",9122894],["thread",9122621],["thread",9122083],["thread",9121669],["thread",9121485],["thread",9119021],["thread",9119016],["thread",9118474],["thread",9113418],["thread",9112021],["thread",9111373],["thread",9110395],["thread",9110206],["thread",9106672],["thread",9102893],["thread",9101453],["thread",9101358],["thread",9101320],["thread",9100428],["thread",9099817],["thread",9099062],["thread",9096311],["thread",9096019],["thread",9095830],["thread",9095772],["thread",9095081],["thread",9093538],["thread",9092684],["thread",9092618],["thread",9092253],["thread",9092000],["thread",9091238],["thread",9090977],["thread",9090280],["thread",9089263],["thread",9089260],["thread",9089245],["thread",9088505],["thread",9087771],["thread",9086915],["thread",9086050],["thread",9086045],["thread",9086036],["thread",9086032],["thread",9085103],["thread",9084957],["thread",9083237],["thread",9083204],["thread",9083070],["thread",9083057],["thread",9082259],["thread",9082206],["thread",9082020],["thread",9081114],["thread",9080509],["thread",9079798],["thread",9079650],["thread",9079640],["thread",9078745],["thread",9078703],["thread",9078699],["thread",9078070],["thread",9077818],["thread",9077711],["thread",9072678],["thread",9070799],["thread",9068441],["thread",9067456],["thread",9066897],["thread",9066359],["thread",9065890],["thread",9065579],["thread",9062329],["thread",9060037],["thread",9059810],["thread",9058486],["thread",9058350],["thread",9057871],["thread",9057857],["thread",9057562],["thread",9057555],["thread",9054980],["thread",9054112],["thread",9054111],["thread",9054108],["thread",9054107],["thread",9053994],["thread",9053602],["thread",9053070],["thread",9052833],["thread",9052225],["thread",9052221],["thread",9051446],["thread",9051432],["thread",9051115],["thread",9050693],["thread",9049446],["thread",9049011],["thread",9046714],["thread",9046636],["thread",9046094],["thread",9046092],["thread",9046007],["thread",9045992],["thread",9043327],["thread",9043285],["thread",9043136],["thread",9042951],["thread",9042862],["thread",9042568],["thread",9042433],["thread",9042409],["thread",9041235],["thread",9041231],["thread",9041217],["thread",9040142],["thread",9040140],["thread",9039856],["thread",9039441],["thread",9039313],["thread",9037627],["thread",9036296],["thread",9035983],["thread",9035901],["thread",9035589],["thread",9035538],["thread",9034504],["thread",9032202],["thread",9031477],["thread",9031474],["thread",9031298],["thread",9030877],["thread",9029733],["thread",9029395],["thread",9029299],["thread",9029240],["thread",9028997],["thread",9028978],["thread",9028252],["thread",9028212],["thread",9028022],["thread",9027928],["thread",9027859],["thread",9026531],["thread",9025469],["thread",9024985],["thread",9023804],["thread",9023372],["thread",9022460],["thread",9021360],["thread",9020478],["thread",9019598],["thread",9019153],["thread",9018278],["thread",9018209],["thread",9018167],["thread",9017394],["thread",9016595],["thread",9015948],["thread",9015940],["thread",9015907],["thread",9015879],["thread",9015367],["thread",9015337],["thread",9015283],["thread",9015248],["thread",9015242],["thread",9014765],["thread",9014761],["thread",9014727],["thread",9014017],["thread",9013992],["thread",9013499],["thread",9013209],["thread",9013139],["thread",9013059],["thread",9012972],["thread",9012970],["thread",9012835],["thread",9012693],["thread",9012683],["thread",9012646],["thread",9012636],["thread",9012129],["thread",9012043],["thread",9012039],["thread",9012023],["thread",9012014],["thread",9012010],["thread",9011698],["thread",9011625],["thread",9011388],["thread",9011316],["thread",9010866],["thread",9010851],["thread",9010824],["thread",9008806],["thread",9007422],["thread",9007183],["thread",9007151],["thread",9006050],["thread",9005586],["thread",9005540],["thread",9005076],["thread",9005064],["thread",9005058],["thread",9005035],["thread",9004978],["thread",9004194],["thread",9004170],["thread",9003869],["thread",9003634],["thread",9002831],["thread",9000084],["thread",8999636],["thread",8999612],["thread",8999500],["thread",8996915],["thread",8993441],["thread",8992562],["thread",8990002],["thread",8988032],["thread",8987264],["thread",8986388],["thread",8984888],["thread",8984297],["thread",8983182],["thread",8981520],["thread",8981263],["thread",8980548],["thread",8979717],["thread",8978763],["thread",8977611],["thread",8976359],["thread",8975084],["thread",8973365],["thread",8972685],["thread",8969985],["thread",8968984],["thread",8968941],["thread",8967177],["thread",8964396],["thread",8962620],["thread",8957171],["thread",8956138],["thread",8956118],["thread",8956075],["thread",8956073],["thread",8956069],["thread",8956056],["thread",8956052],["thread",8954883],["thread",8954424],["thread",8953304],["thread",8953247],["thread",8950464],["thread",8950334],["thread",8949588],["thread",8948618],["thread",8948102],["thread",8944347],["thread",8944325],["thread",8944266],["thread",8943989],["thread",8940193],["thread",8938450],["thread",8937507],["thread",8937426],["thread",8937004],["thread",8936822],["thread",8935945],["thread",8935722],["thread",8934162],["thread",8933419],["thread",8931809],["thread",8931650],["thread",8930545],["thread",8930396],["thread",8929207],["thread",8928665],["thread",8927305],["thread",8926645],["thread",8926362],["thread",8926360],["thread",8925419],["thread",8925036],["thread",8924954],["thread",8924391],["thread",8923371],["thread",8921595],["thread",8919382],["thread",8919032],["thread",8918829],["thread",8916161],["thread",8916158],["thread",8915257],["thread",8913978],["thread",8912199],["thread",8910112],["thread",8909126],["thread",8908590],["thread",8907948],["thread",8907906],["thread",8907866],["thread",8907524],["thread",8907328],["thread",8907276],["thread",8906261],["thread",8904263],["thread",8903746],["thread",8902736],["thread",8901146],["thread",8899874],["thread",8897953],["thread",8897933],["thread",8897220],["thread",8897122],["thread",8897046],["thread",8896918],["thread",8896113],["thread",8895177],["thread",8893917],["thread",8893362],["thread",8892164],["thread",8890269],["thread",8887821],["thread",8887537],["thread",8887151],["thread",8886954],["thread",8885878],["thread",8883057],["thread",8882893],["thread",8881490],["thread",8881048],["thread",8881034],["thread",8880865],["thread",8879519],["thread",8877125],["thread",8867622],["thread",8867593],["thread",8866054],["thread",8864278],["thread",8863681],["thread",8863676],["thread",8863464],["thread",8862199],["thread",8860664],["thread",8858762],["thread",8857923],["thread",8856906],["thread",8855978],["thread",8854427],["thread",8852360],["thread",8850472],["thread",8849781],["thread",8849234],["thread",8848866],["thread",8848423],["thread",8847985],["thread",8847933],["thread",8847926],["thread",8847825],["thread",8847152],["thread",8844726],["thread",8841569],["thread",8840923],["thread",8840916],["thread",8840761],["thread",8838182],["thread",8835550],["thread",8835104],["thread",8835092],["thread",8833651],["thread",8833155],["thread",8832801],["thread",8832685],["thread",8832607],["thread",8831945],["thread",8830031],["thread",8828635],["thread",8826565],["thread",8825675],["thread",8825182],["thread",8825151],["thread",8824261],["thread",8818997],["thread",8814878],["thread",8814836],["thread",8813759],["thread",8812359],["thread",8811180],["thread",8809055],["thread",8808712],["thread",8807271],["thread",8807183],["thread",8805578],["thread",8805028],["thread",8803234],["thread",8803095],["thread",8800491],["thread",8797649],["thread",8794240],["thread",8790875],["thread",8790738],["thread",8790691],["thread",8789952],["thread",8789788],["thread",8789269],["thread",8789265],["thread",8788524],["thread",8787361],["thread",8786827],["thread",8785259],["thread",8785130],["thread",8784796],["thread",8783752],["thread",8783654],["thread",8783362],["thread",8780213],["thread",8779340],["thread",8778298],["thread",8778018],["thread",8777321],["thread",8776503],["thread",8775967],["thread",8775961],["thread",8775222],["thread",8774812],["thread",8774532],["thread",8774483],["thread",8773444],["thread",8772224],["thread",8771054],["thread",8770202],["thread",8770200],["thread",8770199],["thread",8769297],["thread",8768945],["thread",8766911],["thread",8766454],["thread",8765102],["thread",8763397],["thread",8758725],["thread",8754514],["thread",8754406],["thread",8752874],["thread",8751896],["thread",8751746],["thread",8749395],["thread",8748974],["thread",8748849],["thread",8748846],["thread",8748780],["thread",8748323],["thread",8747693],["thread",8746327],["thread",8745754],["thread",8744532],["thread",8743579],["thread",8742439],["thread",8741377],["thread",8741113],["thread",8740575],["thread",8740224],["thread",8738069],["thread",8737554],["thread",8737254],["thread",8729225],["thread",8729194],["thread",8729174],["thread",8727724],["thread",8725546],["thread",8717976],["thread",8704777],["thread",8700134],["thread",8690017],["thread",8680359],["thread",8661028],["thread",8650880],["thread",8648320],["thread",8646052],["thread",8644589],["thread",8635523],["thread",8610519],["thread",8550628],["thread",8544204],["thread",8542936],["thread",8526482],["thread",8517457],["thread",8511103],["thread",8504587],["thread",8493674],["thread",8483919],["thread",8473086],["thread",8469530],["thread",8459469],["thread",8456746],["thread",8455553],["thread",8445897],["thread",8443186],["thread",8433765],["thread",8424012],["thread",8404737],["thread",8398822],["thread",8398818],["thread",8398809],["thread",8388671],["thread",8369741],["thread",8366352],["thread",8366335],["thread",8366050],["thread",8362411],["thread",8349139],["thread",8346350],["thread",8335668],["thread",8326505],["thread",8298832],["thread",8248837],["thread",8240303],["thread",8234509],["thread",8198891],["thread",8193498],["thread",8169945],["thread",8157153],["thread",8133033],["thread",8114174],["thread",7757888],["thread",7569263],["thread",1872878]], 1029, tinhte_xentag_tag, , {"tags":["cho thu\u00ea v\u0103n ph\u00f2ng"]}, date, 0, , [], 0, 1660184795, 91dae262ad692fffb9ed69ceda501a3a
Run Time: 0.000960
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 (9669130, 9668129, 9667804, 9666479, 9666016, 9665823, 9663427, 9661343, 9659886, 9658768, 9658767, 9658520, 9658109, 9653196, 9651359, 9650120, 9648330, 9647869, 9645934, 9641609)
Run Time: 0.001722
| 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: 501168
Run Time: 0.000250
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=cho+thu%C3%AA+v%C4%83n+ph%C3%B2ng&page=3, 1660184795,
Run Time: 0.000314
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000232
| 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 > 1660183895)
ORDER BY session_activity.view_date DESC
Run Time: 0.005802
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | session_activity | ALL | view_date | | | | 2150 | Using where; Using filesort |
| SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |