Page Time: 1.8022s

Memory: 29.2094 MB (Peak: 35.8391 MB)

Queries (224, time: 0.3487s, 19.3%)

  1. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
    Run Time: 0.000721
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 26Using where
  2. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
    Run Time: 0.000204
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 2Using where
  3. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000173
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  4. SELECT profile_post.*
    	,
    	posting_user.*,
    	IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username,
    	receiving_user.username
    		AS profile_username,
    	receiving_user.gender
    		AS profile_gender,
    	receiving_user.user_state
    		AS profile_user_state,
    	receiving_user.user_group_id
    		AS profile_user_group_id,
    	receiving_user.secondary_group_ids
    		AS profile_secondary_group_ids,
    	receiving_user.display_style_group_id
    		AS profile_display_style_group_id,
    	receiving_user.is_banned
    		AS profile_is_banned,
    	receiving_user.is_admin
    		AS profile_is_admin,
    	receiving_user.is_moderator
    		AS profile_is_moderator,
    	receiving_user.avatar_date
    		AS profile_avatar_date,
    	receiving_user.gravatar
    		AS profile_gravatar,
    	receiving_user.warning_points
    		AS profile_warning_points,
    	receiving_user.permission_combination_id
    		AS profile_permission_combination_id,
    	receiving_user_privacy.allow_view_profile
    		AS profile_allow_view_profile,
    	receiving_user_privacy.allow_post_profile
    		AS profile_allow_post_profile,
    	receiving_user_privacy.allow_send_personal_conversation
    		AS profile_allow_send_personal_conversation,
    	receiving_user_privacy.allow_view_identities
    		AS profile_allow_view_identities,
    	receiving_user_privacy.allow_receive_news_feed
    		AS profile_allow_allow_receive_news_feed,
    	IF (receiving_user_follow.follow_user_id, 1, 0)
    		AS following_0
    FROM xf_profile_post AS profile_post
    
    	LEFT JOIN xf_user AS posting_user ON
    		(posting_user.user_id = profile_post.user_id)
    	LEFT JOIN xf_user AS receiving_user ON
    		(receiving_user.user_id = profile_post.profile_user_id)
    	LEFT JOIN xf_user_privacy AS receiving_user_privacy ON
    		(receiving_user_privacy.user_id = profile_post.profile_user_id)
    	LEFT JOIN xf_user_follow AS receiving_user_follow ON
    		(receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 0)
    WHERE (profile_post.message_state IN ('visible'))
    ORDER BY profile_post.post_date DESC
     LIMIT 20
    Run Time: 0.001203
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEprofile_postALL    8Using where; Using filesort
    SIMPLEposting_usereq_refPRIMARYPRIMARY4admin_tez.profile_post.user_id1 
    SIMPLEreceiving_usereq_refPRIMARYPRIMARY4admin_tez.profile_post.profile_user_id1 
    SIMPLEreceiving_user_privacyeq_refPRIMARYPRIMARY4admin_tez.profile_post.profile_user_id1 
    SIMPLEreceiving_user_followeq_refPRIMARY,follow_user_idPRIMARY8admin_tez.profile_post.profile_user_id,const1Using index
  5. SELECT *
    FROM xf_node
    WHERE display_in_list = 1
    ORDER BY lft ASC
    Run Time: 0.001567
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALLdisplay_in_list   1114Using where; Using filesort
  6. SELECT content_id, cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = 'node'
    Params: 1
    Run Time: 0.007723
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentrefPRIMARYPRIMARY31const,const2218Using where
  7. SELECT forum.*
    	,
    		NULL AS forum_read_date
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE forum.node_id IN (1261, 97, 178, 517, 384, 385, 386, 179, 1234, 399, 400, 401, 446, 1213, 1214, 1215, 1216, 98, 176, 516, 387, 388, 389, 177, 1235, 402, 403, 404, 445, 1217, 1218, 1219, 1220, 99, 174, 515, 390, 391, 392, 175, 1236, 405, 406, 407, 444, 1221, 1222, 1223, 1224, 100, 172, 514, 393, 394, 395, 173, 1237, 408, 409, 410, 443, 1225, 1226, 1227, 1228, 101, 170, 513, 396, 397, 398, 171, 1238, 411, 412, 413, 442, 1229, 1230, 1231, 1232, 102, 162, 512, 1170, 414, 222, 223, 224, 704, 705, 706, 707, 708, 910, 163, 524, 1171, 421, 243, 244, 245, 809, 810, 811, 812, 813, 911, 164, 536, 433, 279, 280, 281, 814, 815, 816, 817, 818, 1172, 912, 165, 1175, 300, 301, 302, 819, 820, 821, 822, 823, 1173, 1174, 913, 166, 1177, 321, 322, 323, 824, 825, 826, 827, 828, 1176, 914, 167, 543, 342, 343, 344, 829, 830, 831, 832, 833, 1178, 915, 168, 550, 363, 364, 365, 834, 835, 836, 837, 838, 1179, 916, 169, 1180, 1181, 1182, 1183, 1184, 1186, 1187, 1188, 1189, 1190, 1185, 207, 1191, 1192, 1193, 1194, 1195, 1197, 1198, 1199, 1200, 1201, 1196, 214, 1202, 1203, 1204, 1205, 1206, 1208, 1209, 1210, 1211, 1212, 1207, 103, 154, 511, 1127, 415, 225, 226, 227, 699, 700, 701, 702, 703, 903, 155, 523, 1128, 422, 246, 247, 248, 779, 780, 781, 782, 783, 904, 156, 535, 434, 282, 283, 284, 784, 785, 786, 787, 788, 1129, 905, 157, 1132, 303, 304, 305, 789, 790, 791, 792, 793, 1130, 1131, 906, 158, 1133, 324, 325, 326, 794, 795, 796, 797, 798, 1134, 907, 159, 542, 345, 346, 347, 799, 800, 801, 802, 803, 1135, 908, 160, 549, 366, 367, 368, 804, 805, 806, 807, 808, 1136, 909, 161, 1137, 1138, 1139, 1140, 1141, 1143, 1144, 1145, 1146, 1147, 1142, 208, 1148, 1149, 1150, 1151, 1152, 1154, 1155, 1156, 1157, 1158, 1153, 215, 1159, 1160, 1161, 1162, 1163, 1165, 1166, 1167, 1168, 1169, 1164, 104, 145, 510, 1084, 416, 228, 229, 230, 694, 695, 696, 697, 698, 895, 146, 522, 1085, 423, 249, 250, 251, 744, 745, 746, 747, 748, 896, 147, 529, 428, 264, 265, 266, 749, 750, 751, 752, 753, 1086, 897, 148, 534, 435, 285, 286, 287, 754, 755, 756, 757, 758, 1087, 898, 149, 306, 307, 308, 759, 760, 761, 762, 763, 1088, 1089, 899, 150, 1091, 1090, 327, 328, 329, 768, 764, 765, 766, 767, 900, 151, 541, 1092, 348, 349, 350, 769, 770, 771, 772, 773, 901, 152, 548, 1093, 369, 370, 371, 774, 775, 776, 777, 778, 902, 153, 1094, 1095, 1096, 1097, 1098, 1100, 1101, 1102, 1103, 1104, 1099, 209, 1105, 1106, 1107, 1108, 1109, 1111, 1112, 1113, 1114, 1115, 1110, 216, 1116, 1117, 1118, 1119, 1120, 1122, 1123, 1124, 1125, 1126, 1121, 105, 136, 509, 417, 231, 232, 233, 689, 690, 691, 692, 693, 887, 137, 521, 424, 252, 253, 254, 709, 710, 711, 712, 713, 888, 138, 528, 267, 268, 269, 714, 715, 716, 717, 718, 429, 889, 139, 533, 436, 288, 289, 290, 719, 720, 721, 722, 723, 890, 140, 1046, 1045, 309, 310, 311, 724, 725, 726, 727, 728, 891, 141, 1047, 1048, 330, 331, 332, 729, 730, 731, 732, 733, 892, 142, 540, 1049, 351, 352, 353, 734, 735, 736, 737, 738, 893, 143, 547, 1050, 372, 373, 374, 739, 740, 741, 742, 743, 894, 144, 1051, 1052, 1053, 1054, 1055, 1057, 1058, 1059, 1060, 1061, 1056, 210, 1062, 1063, 1064, 1065, 1066, 1068, 1069, 1070, 1071, 1072, 1067, 217, 1073, 1074, 1075, 1076, 1077, 1079, 1080, 1081, 1082, 1083, 1078, 106, 127, 508, 418, 449, 467, 468, 469, 470, 471, 472, 473, 474, 234, 235, 236, 569, 570, 571, 572, 573, 879, 128, 520, 425, 1003, 255, 256, 257, 654, 655, 656, 657, 658, 880, 129, 527, 430, 1004, 270, 271, 272, 659, 660, 661, 662, 663, 881, 130, 532, 437, 291, 292, 293, 664, 665, 666, 667, 668, 1005, 882, 131, 312, 313, 314, 669, 670, 671, 672, 673, 1006, 1007, 883, 132, 1008, 333, 334, 335, 674, 675, 676, 677, 678, 1009, 884, 133, 539, 354, 355, 356, 679, 680, 681, 682, 683, 1010, 885, 134, 546, 375, 376, 377, 684, 685, 686, 687, 688, 1011, 886, 135, 1012, 1013, 1014, 1015, 1016, 1018, 1019, 1020, 1021, 1022, 1017, 211, 1023, 1024, 1025, 1026, 1027, 1029, 1030, 1031, 1032, 1033, 1028, 219, 1034, 1035, 1036, 1037, 1038, 1040, 1041, 1042, 1043, 1044, 1039, 107, 118, 507, 419, 448, 459, 460, 461, 462, 463, 464, 465, 466, 237, 238, 239, 574, 575, 576, 577, 578, 871, 119, 519, 426, 258, 259, 260, 619, 620, 621, 622, 623, 960, 872, 120, 526, 431, 273, 274, 275, 624, 625, 626, 627, 628, 961, 873, 121, 531, 438, 294, 295, 296, 629, 630, 631, 632, 633, 962, 874, 122, 966, 315, 316, 317, 634, 635, 636, 637, 638, 963, 964, 875, 123, 967, 336, 337, 338, 639, 640, 641, 642, 643, 965, 876, 124, 538, 357, 358, 359, 644, 645, 646, 647, 648, 968, 877, 125, 545, 378, 379, 380, 649, 650, 651, 652, 653, 969, 878, 126, 970, 971, 972, 973, 974, 976, 977, 978, 979, 980, 975, 212, 981, 982, 983, 984, 985, 987, 988, 989, 990, 991, 986, 220, 992, 993, 994, 995, 996, 998, 999, 1000, 1001, 1002, 997, 108, 109, 506, 420, 447, 451, 452, 453, 454, 455, 456, 458, 240, 241, 242, 579, 580, 581, 582, 583, 863, 110, 518, 427, 261, 262, 263, 584, 585, 586, 587, 588, 917, 864, 111, 525, 432, 276, 277, 278, 589, 590, 591, 592, 593, 918, 865, 112, 530, 439, 297, 298, 299, 594, 595, 596, 597, 598, 919, 866, 113, 920, 318, 319, 320, 599, 600, 601, 602, 603, 921, 922, 867, 114, 923, 339, 340, 341, 604, 605, 606, 607, 608, 924, 868, 115, 537, 360, 361, 362, 609, 610, 611, 612, 613, 925, 869, 116, 544, 381, 382, 383, 614, 615, 616, 617, 618, 926, 870, 117, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 213, 938, 939, 940, 941, 942, 944, 945, 946, 947, 948, 943, 221, 949, 950, 951, 952, 953, 955, 956, 957, 958, 959, 954, 478, 551, 482, 552, 840, 553, 842, 554, 844, 555, 846, 556, 848, 557, 850, 558, 852, 559, 854, 479, 560, 450, 561, 855, 562, 856, 563, 857, 564, 858, 565, 859, 566, 860, 567, 861, 568, 862, 1255, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 1277, 481, 839, 841, 843, 845, 847, 849, 851, 853, 1239, 190, 191, 192, 181, 182, 183, 184, 440, 185, 441, 186, 187, 188, 189, 1233, 484, 1253, 1254, 1256, 1257, 1258, 1259, 1260, 1264, 1265, 1263, 1267, 1268, 1269, 1270, 1271, 1272, 1273, 1274, 1275, 1276, 485, 486, 487, 488, 489, 490, 1266, 8, 12, 13, 15, 16, 17, 18, 51, 52, 53, 54, 55, 77, 476, 477, 85, 86, 87, 90, 91, 92, 95, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 2, 3, 4, 5, 6)
    Run Time: 0.001505
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeindexPRIMARYparent_node_id4 1114Using where; Using index
    SIMPLEforumeq_refPRIMARYPRIMARY4admin_tez.node.node_id1 
  8. 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 > 1560980054)
    ORDER BY session_activity.view_date DESC
    Run Time: 0.002850
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEsession_activityALLview_date   227Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4admin_tez.session_activity.user_id1 
  9. SELECT data_value
    FROM xf_data_registry
    WHERE data_key = ?
    Params: boardTotals
    Run Time: 0.000411
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 
  10. SELECT * FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY post_date DESC LIMIT 10
    Run Time: 0.000510
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postpost_date4 19Using where
  11. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112678'
    Run Time: 0.000178
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  12. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.018008
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  13. 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: 746
    Run Time: 0.001234
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  14. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72679 AND user_id = '0'
    Run Time: 0.000194
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  15. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000214
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  16. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112676'
    Run Time: 0.000157
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  17. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.010729
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  18. 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: 746
    Run Time: 0.001128
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  19. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72677 AND user_id = '0'
    Run Time: 0.000237
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  20. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000407
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  21. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112675'
    Run Time: 0.000168
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  22. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011749
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  23. 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: 746
    Run Time: 0.001118
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  24. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72676 AND user_id = '0'
    Run Time: 0.000232
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  25. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000223
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  26. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112673'
    Run Time: 0.000141
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  27. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011245
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  28. 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: 746
    Run Time: 0.001098
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  29. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72674 AND user_id = '0'
    Run Time: 0.000199
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  30. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000253
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  31. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112664'
    Run Time: 0.000421
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  32. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011949
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  33. 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: 746
    Run Time: 0.000924
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  34. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72665 AND user_id = '0'
    Run Time: 0.000230
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  35. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000194
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  36. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112660'
    Run Time: 0.000169
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  37. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011089
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  38. 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: 746
    Run Time: 0.001057
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  39. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72661 AND user_id = '0'
    Run Time: 0.000357
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  40. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000169
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  41. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112658'
    Run Time: 0.000262
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  42. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011190
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  43. 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: 746
    Run Time: 0.001231
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  44. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72659 AND user_id = '0'
    Run Time: 0.000284
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  45. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000482
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  46. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112655'
    Run Time: 0.000292
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  47. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.010765
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  48. 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: 746
    Run Time: 0.001089
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  49. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72656 AND user_id = '0'
    Run Time: 0.000212
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  50. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000224
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  51. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112654'
    Run Time: 0.000283
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  52. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011969
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  53. 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: 746
    Run Time: 0.000909
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  54. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72655 AND user_id = '0'
    Run Time: 0.000202
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  55. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000203
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  56. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112653'
    Run Time: 0.000219
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  57. SELECT last_post_date FROM xf_thread WHERE node_id IN(1261,97,98,99,100,101,102,103,104,105,106,107,108,478,479,1255,491,1277,1239,1253,178,179,1213,1214,1215,1216,176,177,1217,1218,1219,1220,174,175,1221,1222,1223,1224,172,173,1225,1226,1227,1228,170,171,1229,1230,1231,1232,162,163,164,165,166,167,168,169,207,214,154,155,156,157,158,159,160,161,208,215,145,146,147,148,149,150,151,152,153,209,216,136,137,138,139,140,141,142,143,144,210,217,127,128,129,130,131,132,133,134,135,211,219,118,119,120,121,122,123,124,125,126,212,220,109,110,111,112,113,114,115,116,117,213,221,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,481,839,841,843,845,847,849,851,853,190,191,192,181,182,183,184,440,185,441,186,187,188,189,1233,484,1254,1256,1257,1258,1259,1260,517,384,385,386,1234,399,400,401,446,516,387,388,389,1235,402,403,404,445,515,390,391,392,1236,405,406,407,444,514,393,394,395,1237,408,409,410,443,513,396,397,398,1238,411,412,413,442,512,1170,414,222,223,224,704,705,706,707,708,910,524,1171,421,243,244,245,809,810,811,812,813,911,536,433,279,280,281,814,815,816,817,818,1172,912,1175,300,301,302,819,820,821,822,823,1173,1174,913,1177,321,322,323,824,825,826,827,828,1176,914,543,342,343,344,829,830,831,832,833,1178,915,550,363,364,365,834,835,836,837,838,1179,916,1180,1181,1182,1183,1184,1186,1187,1188,1189,1190,1185,1191,1192,1193,1194,1195,1197,1198,1199,1200,1201,1196,1202,1203,1204,1205,1206,1208,1209,1210,1211,1212,1207,511,1127,415,225,226,227,699,700,701,702,703,903,523,1128,422,246,247,248,779,780,781,782,783,904,535,434,282,283,284,784,785,786,787,788,1129,905,1132,303,304305,789,790,791,792,793,1130,1131,906,1133,324,325,326,794,795,796,797,798,1134,907,542,345,346,347,799,800,801,802,803,1135,908,549,366,367,368,804,805,806,807,808,1136,909,1137,1138,1139,1140,1141,1143,1144,1145,1146,1147,1142,1148,1149,1150,1151,1152,1154,1155,1156,1157,1158,1153,1159,1160,1161,1162,1163,1165,1166,1167,1168,1169,1164,510,1084,416,228,229,230,694,695,696,697,698,895,522,1085,423,249,250,251,744,745,746,747,748,896,529,428,264,265,266,749,750,751,752,753,1086,897,534,435,285,286,287,754,755,756,757,758,1087,898,306,307,308,759,760,761,762,763,1088,1089,899,1091,1090,327,328,329,768,764,765,766,767,900,541,1092,348,349,350,769,770,771,772,773,901,548,1093,369,370,371,774,775,776,777,778,902,1094,1095,1096,1097,1098,1100,1101,1102,1103,1104,1099,1005,1106,1107,1108,1109,1111,1112,1113,1114,1115,1110,1116,1117,1118,1119,1120,1122,1123,1124,1125,1126,1121,509,417,231,232,233,689,690,691,692,693,887,521,424,252,253,254,709,710,711,712,713,888,528,267,268,269,714,715,716,717,718,429,889,533,436,288,289,290,719,720,721,722,723,890,1046,1045,309,310,311,724,725,726,727,728,891,1047,1048,330,331,332,729,730,731,732,733,892,540,1049,351,352,353,734,735,736,737,738,893,547,1050,372,373,374,739,740,741,742,743,894,1051,1052,1053,1054,1055,1057,1058,1059,1060,1061,1056,1062,1063,1064,1065,1066,1068,1069,1070,1071,1072,1067,1073,1074,1075,1076,1077,1079,1080,1081,1082,1083,1078,508,418,449,467,468,469,470,471,472,473,474,234,235,236,569,570,571,572,573,879,520,425,1003,255,256,257,654,655,656,657,658,880,527,430,1004,270,271,272,659,660,661,662,663,881,532,437,291,292,293,664,665,666,667,668,1005,882,312,313,314,669,670,671,672,673,1006,1007,883,1008,333,334,335,674,675,676,677,678,1009,884,539,354,355,356,679,680,681,682,683,1010,885,546,375,376,377,684,685,686,687,688,1011,886,1012,1013,1014,1015,1016,1018,1019,1020,1021,1022,1017,1023,1024,1025,1026,1027,1029,1030,1031,1032,1033,1028,1034,1035,1036,1037,1038,1040,1041,1042,1043,1044,1039,507,419,448,459,460,461,462,463,464,465,466,237,238,239,574,575,576,577,578,871,519,426,258,259,260,619,620,621,622,623,960,872,526,431,273,274,275,624,625,626,627,628,961,873,531,438,294,295,296,629,630,631,632,633,962,874,966,315,316,317,634,635,636,637,638,963,964,875,967,336,337,338,639,640,641,642,643,965,876,538,357,358,359,644,645,646,647,648,968,877,545,378,379,380,649,650,651,652,653,969,878,970,971,972,973,974,976,977,978,979,980,975,981,982,983,984,985,987,988,989,990,991,986,992,993,994,995,996,998,999,1000,1001,1002,997,506,420,447,451,452,453,454,455,456,458,240,241,242,579,580,581,582,583,863,518,427,261,262,263,584,585,586,587,588,917,864,525432,276,277,278,589,590,591,592,593,918,865,530,439,297,298,299,594,595,596,597,598,919,866,920,318,319,320,599,600,601,602,603,921,922,867,923,339,340,341,604,605,606,607,608,924,868,537,360,361,362,609,610,611,612,613,925,869,544,381,382,383,614,615,616,617,618,926,870,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,944,945,946,947,948,943,949,950,951,952,953,955,956,957,958,959,954,482,840,842,844,846,848,850,852,854,450,855,856,857,858,859,860,861,862) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.011142
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28826Using where; Using index; Using filesort
  58. 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: 746
    Run Time: 0.000940
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  59. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72654 AND user_id = '0'
    Run Time: 0.000197
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  60. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  61. SELECT * FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY post_date DESC LIMIT 10
    Run Time: 0.000372
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postpost_date4 501Using where
  62. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112501'
    Run Time: 0.000119
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const2Using where; Using index
  63. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  64. 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: 1274
    Run Time: 0.000913
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  65. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72502 AND user_id = '0'
    Run Time: 0.000355
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  66. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000188
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  67. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112499'
    Run Time: 0.000123
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  68. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000619
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  69. 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: 1274
    Run Time: 0.000618
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  70. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72500 AND user_id = '0'
    Run Time: 0.000232
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  71. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000138
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  72. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112498'
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  73. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000772
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  74. 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: 1274
    Run Time: 0.000632
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  75. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72499 AND user_id = '0'
    Run Time: 0.000156
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  76. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000303
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  77. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112497'
    Run Time: 0.000124
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  78. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001057
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  79. 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: 1274
    Run Time: 0.000900
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  80. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72498 AND user_id = '0'
    Run Time: 0.000162
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  81. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000376
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  82. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112496'
    Run Time: 0.000107
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  83. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000948
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  84. 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: 1274
    Run Time: 0.001078
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  85. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72497 AND user_id = '0'
    Run Time: 0.000222
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  86. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000145
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  87. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112495'
    Run Time: 0.000092
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  88. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000737
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  89. 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: 1274
    Run Time: 0.001049
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  90. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72496 AND user_id = '0'
    Run Time: 0.000173
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  91. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000238
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  92. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112494'
    Run Time: 0.000206
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  93. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000968
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  94. 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: 1274
    Run Time: 0.000735
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  95. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72495 AND user_id = '0'
    Run Time: 0.000191
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  96. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000304
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  97. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112493'
    Run Time: 0.000098
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  98. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000979
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  99. 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: 1274
    Run Time: 0.000771
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  100. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72494 AND user_id = '0'
    Run Time: 0.000176
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  101. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000156
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  102. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112492'
    Run Time: 0.000157
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  103. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001090
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  104. 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: 1274
    Run Time: 0.000796
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  105. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72493 AND user_id = '0'
    Run Time: 0.000204
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  106. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000223
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  107. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112491'
    Run Time: 0.000131
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  108. SELECT last_post_date FROM xf_thread WHERE node_id IN(1264,1265,1263,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000760
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 1141Using where; Using index; Using filesort
  109. 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: 1274
    Run Time: 0.000678
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  110. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72492 AND user_id = '0'
    Run Time: 0.000184
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  111. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000227
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  112. SELECT * FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY post_date DESC LIMIT 10
    Run Time: 0.000365
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postpost_date4 152Using where
  113. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112684'
    Run Time: 0.000179
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  114. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001929
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  115. 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: 487
    Run Time: 0.000856
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  116. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72685 AND user_id = '0'
    Run Time: 0.000203
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  117. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000360
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  118. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112683'
    Run Time: 0.000146
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  119. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001933
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  120. 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: 487
    Run Time: 0.001277
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  121. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72684 AND user_id = '0'
    Run Time: 0.000150
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  122. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000203
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  123. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112682'
    Run Time: 0.000132
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  124. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001751
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  125. 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: 487
    Run Time: 0.001447
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  126. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72683 AND user_id = '0'
    Run Time: 0.000249
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  127. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000226
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  128. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112681'
    Run Time: 0.000348
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  129. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001880
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  130. 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: 487
    Run Time: 0.000816
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  131. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72682 AND user_id = '0'
    Run Time: 0.000181
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  132. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000189
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  133. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112680'
    Run Time: 0.000147
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  134. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001933
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  135. 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: 487
    Run Time: 0.000687
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  136. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72681 AND user_id = '0'
    Run Time: 0.000204
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  137. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000141
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  138. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112679'
    Run Time: 0.000095
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  139. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.006578
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  140. 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: 487
    Run Time: 0.000865
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  141. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72680 AND user_id = '0'
    Run Time: 0.000149
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  142. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000144
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  143. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112677'
    Run Time: 0.000100
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  144. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001722
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  145. 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: 487
    Run Time: 0.000633
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  146. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72678 AND user_id = '0'
    Run Time: 0.000152
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  147. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000150
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  148. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112674'
    Run Time: 0.000248
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  149. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001770
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  150. 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: 487
    Run Time: 0.000857
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  151. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72675 AND user_id = '0'
    Run Time: 0.000232
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  152. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000151
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  153. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112672'
    Run Time: 0.000180
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  154. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001382
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  155. 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: 487
    Run Time: 0.000640
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  156. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72673 AND user_id = '0'
    Run Time: 0.000178
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  157. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000264
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  158. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112671'
    Run Time: 0.000129
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  159. SELECT last_post_date FROM xf_thread WHERE node_id IN(485,486,487,488,489,490,1266) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001703
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3765Using where; Using index; Using filesort
  160. 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: 487
    Run Time: 0.000846
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  161. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72672 AND user_id = '0'
    Run Time: 0.000193
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  162. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000217
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  163. SELECT * FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY post_date
     DESC LIMIT 10
    Run Time: 0.000351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postpost_date4 20Using where
  164. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112307'
    Run Time: 0.000131
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const3Using where; Using index
  165. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.010805
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  166. 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: 52
    Run Time: 0.001278
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  167. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72309 AND user_id = '0'
    Run Time: 0.000330
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  168. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000114
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  169. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112304'
    Run Time: 0.000061
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const6Using where; Using index
  170. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.009104
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  171. 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: 52
    Run Time: 0.001059
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  172. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72308 AND user_id = '0'
    Run Time: 0.000218
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  173. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000198
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  174. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112302'
    Run Time: 0.000133
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const4Using where; Using index
  175. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.008092
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  176. 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: 52
    Run Time: 0.001012
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  177. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72307 AND user_id = '0'
    Run Time: 0.000187
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  178. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000224
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  179. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '112300'
    Run Time: 0.000164
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const8Using where; Using index
  180. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.008372
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  181. 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: 52
    Run Time: 0.001149
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  182. SELECT thread_id FROM xf_thread_read WHERE thread_id = 72306 AND user_id = '0'
    Run Time: 0.000254
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  183. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000366
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  184. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '111758'
    Run Time: 0.000135
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const3Using where; Using index
  185. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.008961
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  186. 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: 52
    Run Time: 0.000869
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  187. SELECT thread_id FROM xf_thread_read WHERE thread_id = 71761 AND user_id = '0'
    Run Time: 0.000185
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  188. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000277
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  189. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '111749'
    Run Time: 0.000152
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const7Using where; Using index
  190. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.008324
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  191. 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: 52
    Run Time: 0.000849
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  192. SELECT thread_id FROM xf_thread_read WHERE thread_id = 71755 AND user_id = '0'
    Run Time: 0.000290
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  193. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000305
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  194. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '111741'
    Run Time: 0.000154
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const3Using where; Using index
  195. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.008640
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  196. 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: 52
    Run Time: 0.001291
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  197. SELECT thread_id FROM xf_thread_read WHERE thread_id = 71751 AND user_id = '0'
    Run Time: 0.000529
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  198. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.004383
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  199. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '111733'
    Run Time: 0.000412
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const6Using where; Using index
  200. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.009669
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  201. 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: 52
    Run Time: 0.001261
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  202. SELECT thread_id FROM xf_thread_read WHERE thread_id = 71746 AND user_id = '0'
    Run Time: 0.000224
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  203. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000555
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  204. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '111649'
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const3Using where; Using index
  205. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.012042
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  206. 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: 52
    Run Time: 0.001120
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  207. SELECT thread_id FROM xf_thread_read WHERE thread_id = 71665 AND user_id = '0'
    Run Time: 0.000411
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  208. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000202
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  209. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '111646'
    Run Time: 0.000135
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const8Using where; Using index
  210. SELECT last_post_date FROM xf_thread WHERE node_id IN(8,12,13,15,16,17,18,51,52,53,54,55,77,476,477,85,86,87,90,91,92,95,193,194,195,196,197,198,199,200,201,202,203,204,205,206
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.010653
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 28367Using where; Using index; Using filesort
  211. 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: 52
    Run Time: 0.001260
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
  212. SELECT thread_id FROM xf_thread_read WHERE thread_id = 71662 AND user_id = '0'
    Run Time: 0.000234
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  213. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000166
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  214. SELECT thread.*
    	,
    	user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
    	NULL AS thread_read_date,
    	0 AS thread_is_watched,
    	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.last_post_user_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.discussion_state IN ('visible'))
    ORDER BY thread.last_post_date DESC
     LIMIT 40
    Run Time: 0.001323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadindex last_post_date4 40Using where
    SIMPLEusereq_refPRIMARYPRIMARY4admin_tez.thread.last_post_user_id1 
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,admin_tez.thread.node_id1Using where
  215. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 487
    Run Time: 0.000248
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  216. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 746
    Run Time: 0.000364
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  217. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?
    Params: 1, node, 745
    Run Time: 0.000260
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentconstPRIMARYPRIMARY35const,const,const1 
  218. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: d8dd46bbaa0d5764548d64b09320343b, , 1560984554
    Run Time: 0.007915
  219. 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, , , XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1560980954,
    Run Time: 0.000762
  220. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'node_forum_level_2', 'node_forum_level_n', 'node_category_level_1', 'wf_widget_wrapper', 'wf_widget_stats', 'forum_list', 'tinhte_xentag_bb_code_tag_tag', 'tinhte_xentag_hook_message_below', 'tinhte_xentag_hook_message_content', 'tinhte_xentag_hook_message_notices', 'tinhte_xentag_hook_navigation_tabs_forums', 'tinhte_xentag_hook_post_private_controls', 'tinhte_xentag_hook_post_public_controls', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
    	AND style_id = ?
    	AND language_id = ?
    Params: 4, 2
    Run Time: 0.000594
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 17Using where
  221. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('VNXF_Stats')
    	AND style_id = ?
    	AND language_id = ?
    Params: 4, 2
    Run Time: 0.000392
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 
  222. SELECT max(comment.comment_id)
    FROM `xf_brivium_post_comment` AS comment
    LEFT JOIN xf_brivium_post_read AS post_read ON 
            (post_read.user_id = ? AND post_read.post_id = comment.post_id)
    WHERE (comment.post_date > post_read.post_read_date) OR (post_read.post_read_date IS NULL)
    group by comment.post_id
    Params: 0
    Run Time: 0.000338
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEcommentALL    6Using temporary; Using filesort
    SIMPLEpost_readeq_refuser_id_post_id,post_iduser_id_post_id8const,admin_tez.comment.post_id1Using where
  223. SELECT comment.*
    	,
    		thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
    		thread.post_date AS thread_post_date,
    		post.*, post.user_id AS post_user_id, post.username AS post_username, post.post_date AS post_post_date, post.message AS post_message, 
    		comment.*,
    		node.title AS node_title, node.node_name,
    		user.*, IF(user.username IS NULL, comment.username, user.username) AS username,
    		user_profile.*,
    		user_option.*,
    	permission.cache_value AS node_permission_cache
    FROM xf_brivium_post_comment AS comment
    	
    		INNER JOIN xf_post AS post ON
    			(post.post_id = comment.post_id)
    		INNER JOIN xf_thread AS thread ON
    			(thread.thread_id = post.thread_id)
    		INNER JOIN xf_node AS node ON
    			(node.node_id = thread.node_id)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = comment.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = comment.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = comment.user_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 (comment.comment_id IN (2, 5, 4, 8)) AND (comment.message_state = 'visible')
    ORDER BY comment.post_date DESC
     LIMIT 20
    Run Time: 0.003416
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEcommentALLPRIMARY   6Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4admin_tez.comment.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4admin_tez.comment.user_id1 
    SIMPLEuser_optioneq_refPRIMARYPRIMARY4admin_tez.comment.user_id1 
    SIMPLEposteq_refPRIMARY,thread_id_post_date,thread_id_positionPRIMARY4admin_tez.comment.post_id1 
    SIMPLEthreadeq_refPRIMARY,node_id_last_post_date,node_id_sticky_state_last_postPRIMARY4admin_tez.post.thread_id1 
    SIMPLEpermissioneq_refPRIMARYPRIMARY35const,const,admin_tez.thread.node_id1Using where
    SIMPLEnodeeq_refPRIMARYPRIMARY4admin_tez.thread.node_id1 
  224. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('BRCEP_new_post_comments_on_sidebar')
    	AND style_id = ?
    	AND language_id = ?
    Params: 4, 2
    Run Time: 0.000382
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 

Included Files (144, XenForo Classes: 66)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Db.php
  19. library/Zend/Db/Adapter/Mysqli.php
  20. library/Zend/Db/Adapter/Abstract.php
  21. library/Zend/Db/Select.php
  22. library/Zend/Db/Expr.php
  23. library/Zend/Db/Profiler.php
  24. library/Zend/Db/Statement/Mysqli.php
  25. library/Zend/Db/Statement.php
  26. library/Zend/Db/Statement/Interface.php
  27. library/Zend/Db/Profiler/Query.php
  28. library/XenForo/CodeEvent.php
  29. library/XenForo/Options.php
  30. library/XenForo/Link.php
  31. library/XenForo/Template/Helper/Core.php
  32. library/Tinhte/XenTag/Listener.php
  33. library/XenForo/CacheRebuilder/Abstract.php
  34. library/Brivium/BriviumHelper/EventListeners.php
  35. library/Brivium/BriviumHelper/1020171/EventListeners.php
  36. library/VNXF/Stats/Listener.php
  37. library/WidgetFramework/Listener.php
  38. library/WidgetFramework/Option.php
  39. library/Brivium/CustomNodeStyle/EventListener/Listener.php
  40. library/XenForo/Router.php
  41. library/XenForo/Route/Filter.php
  42. library/XenForo/Route/Interface.php
  43. library/XenForo/Route/ResponseSuffix.php
  44. library/XenForo/Route/Prefix.php
  45. library/WidgetFramework/Route/Filter/PageX.php
  46. library/XenForo/Route/Prefix/Index.php
  47. library/vtLai/UrlKhongDau/Listener.php
  48. library/WidgetFramework/XenForo/Route/Prefix/Index.php
  49. library/XenForo/RouteMatch.php
  50. library/XenForo/ControllerPublic/Index.php
  51. library/XenForo/ControllerPublic/Abstract.php
  52. library/XenForo/Controller.php
  53. library/VietXf/MoreThread/Listener.php
  54. library/Borbole/RecentPosts/Listener.php
  55. library/LilTee/LimitPostLink/Listener/Listener.php
  56. library/WidgetFramework/XenForo/ControllerPublic/Index.php
  57. library/XenForo/Input.php
  58. library/XenForo/Session.php
  59. library/XenForo/Helper/Ip.php
  60. library/XenForo/Visitor.php
  61. library/XenForo/Model/User.php
  62. library/WidgetFramework/XenForo/Model/User.php
  63. library/XenForo/Permission.php
  64. library/XenForo/Phrase.php
  65. library/XenForo/Locale.php
  66. library/Cezz/MobileStyleSwitch/Switch.php
  67. library/WidgetFramework/Helper/Index.php
  68. library/XenForo/ControllerResponse/ReroutePath.php
  69. library/XenForo/ControllerResponse/Abstract.php
  70. library/XenForo/Route/Prefix/Forums.php
  71. library/vtLai/UrlKhongDau/Forums.php
  72. library/XenForo/ControllerPublic/Forum.php
  73. library/VNXF/Stats/ControllerPublic/Forum.php
  74. library/Tinhte/XenTag/XenForo/ControllerPublic/Forum.php
  75. library/Borbole/RecentPosts/ControllerPublic.php
  76. library/LilTee/LimitPostLink/ControllerPublic/Forum.php
  77. library/WidgetFramework/XenForo/ControllerPublic/Forum.php
  78. library/XenForo/Model/ProfilePost.php
  79. library/WidgetFramework/XenForo/Model/ProfilePost.php
  80. library/XenForo/Model/UserProfile.php
  81. library/XenForo/Model/Node.php
  82. library/Brivium/CustomNodeStyle/Model/Node.php
  83. library/XenForo/NodeHandler/Category.php
  84. library/XenForo/NodeHandler/Abstract.php
  85. library/XenForo/NodeHandler/Forum.php
  86. library/XenForo/Model/Category.php
  87. library/XenForo/Model/Forum.php
  88. library/Tinhte/XenTag/XenForo/Model/Forum.php
  89. library/Tinhte/XenTag/Option.php
  90. library/XenForo/Helper/String.php
  91. library/XenForo/Model/Session.php
  92. library/XenForo/ControllerResponse/View.php
  93. library/VNXF/Stats/Model.php
  94. library/Borbole/RecentPosts/RecentPosts.php
  95. library/XenForo/Model/Post.php
  96. library/Tinhte/XenTag/XenForo/Model/Post.php
  97. library/Brivium/CommentEachPost/Model/Post.php
  98. library/XenForo/Model/Thread.php
  99. library/Tinhte/XenTag/XenForo/Model/Thread.php
  100. library/WidgetFramework/XenForo/Model/Thread.php
  101. library/XenForo/Model/PermissionCache.php
  102. library/XenForo/Helper/Cookie.php
  103. library/XenForo/ViewRenderer/HtmlPublic.php
  104. library/XenForo/ViewRenderer/Abstract.php
  105. library/XenForo/Template/Public.php
  106. library/XenForo/Template/Abstract.php
  107. library/WidgetFramework/Core.php
  108. library/XenForo/Model/Moderator.php
  109. library/Brivium/CommentEachPost/EventListeners/Listener.php
  110. library/WidgetFramework/Model/Widget.php
  111. library/WidgetFramework/Helper/Sort.php
  112. library/WidgetFramework/WidgetRenderer.php
  113. library/XenForo/ViewPublic/Forum/List.php
  114. library/XenForo/ViewPublic/Base.php
  115. library/XenForo/View.php
  116. library/WidgetFramework/XenForo/View1.php
  117. library/XenForo/ViewPublic/Helper/Node.php
  118. library/Brivium/TableBBCode/EventListeners/Listener.php
  119. library/WidgetFramework/WidgetRenderer/Empty.php
  120. library/WidgetFramework/WidgetRenderer/Stats.php
  121. library/WidgetFramework/WidgetRenderer/Html.php
  122. library/XenForo/Route/Prefix/Members.php
  123. library/vtLai/UrlKhongDau/Members.php
  124. library/WidgetFramework/Template/Extended.php
  125. library/XenForo/Route/Prefix/Categories.php
  126. library/vtLai/UrlKhongDau/Categories.php
  127. library/vtLai/UrlKhongDau/Converter.php
  128. library/ChipXF/RemoteImageUploader/Listeners.php
  129. library/ChipXF/RemoteImageUploader/Helper.php
  130. library/Tinhte/Html5Uploader/Listener.php
  131. library/XenForo/Route/Prefix/Posts.php
  132. library/XenForo/Route/Prefix/Threads.php
  133. library/vtLai/UrlKhongDau/Threads.php
  134. library/VNXF/Stats/Route.php
  135. library/Brivium/CommentEachPost/Model/Comment.php
  136. library/XenForo/Model/Avatar.php
  137. library/Brivium/CommentEachPost/Route/Prefix/Comment.php
  138. library/XenForo/Route/Prefix/ProfilePosts.php
  139. library/WidgetFramework/Helper/String.php
  140. library/XenForo/Debug.php
  141. library/Tinhte/XenTag/Helper.php
  142. library/Tinhte/XenTag/Constants.php
  143. library/Tinhte/Html5Uploader/Template.php
  144. library/XenForo/ViewRenderer/Json.php