SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | 39 | Using where |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('dbtCreditsCurrencies')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_profile_Profile_3`.* FROM `xf_user` LEFT JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user`.`user_id` = '2') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.* FROM `xf_forum` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | 208 | |||||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,slivkurs.xf_node_Node_1.node_id | 1 | Using where |
SELECT `xf_mjst_department`.* FROM `xf_mjst_department` ORDER BY `xf_mjst_department`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mjst_department | ALL | 4 | Using filesort |
SELECT cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ? AND content_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ? AND content_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ? AND content_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ? AND content_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_mjst_ticket_message`.*, `xf_mjst_ticket_Ticket_1`.*, `xf_mjst_department_Department_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.* FROM `xf_mjst_ticket_message` LEFT JOIN `xf_mjst_ticket` AS `xf_mjst_ticket_Ticket_1` ON (`xf_mjst_ticket_Ticket_1`.`support_ticket_id` = `xf_mjst_ticket_message`.`support_ticket_id`) LEFT JOIN `xf_mjst_department` AS `xf_mjst_department_Department_2` ON (`xf_mjst_department_Department_2`.`department_id` = `xf_mjst_ticket_Ticket_1`.`department_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mjst_ticket_message`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'support_department' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_mjst_department_Department_2`.`department_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') WHERE (`xf_mjst_ticket_message`.`message_id` IN (9971, 9966, 9965, 9956, 9955, 9951, 9949, 9945, 9944, 9941, 9938, 9936, 9935, 9930, 9923, 9918, 9915, 9910, 9902, 9895, 9893, 9890, 9887, 9885, 9879, 9872, 9870, 9868, 9866, 9860, 9852, 9842, 9839, 9832, 9829, 9824, 9816, 9813, 9811, 9797, 9780, 9767, 9750, 9748, 9746, 9743, 9741, 9739, 9737, 9734, 9729, 9722, 9721, 9716, 9710, 9706, 9704, 9702, 9696, 9695, 9692, 9684, 9681, 9679, 9675, 9674, 9673, 9664, 9660, 9650, 9645, 9643, 9641, 9639, 9637, 9636, 9634, 9632, 9630, 9627, 9621, 9619, 9615, 9614, 9613, 9612, 9607, 9601, 9596, 9594, 9592, 9590, 9587, 9585, 9583, 9582, 9578, 9574, 9561, 9559, 9552, 9549, 9546, 9543, 9541, 9540, 9532, 9530, 9528, 9521, 9519, 9516, 9513, 9512, 9505, 9496, 9494, 9485, 9483, 9481, 9480, 9476, 9471, 9467, 9465, 9463, 9462, 9449, 9447, 9442, 9440, 9438, 9436, 9434, 9432, 9428, 9425, 9423, 9420, 9418, 9410, 9408, 9403, 9399, 9397, 9396, 9386, 9385, 9383, 9381, 9379, 9378, 9372, 9370, 9369, 9361, 9358, 9356, 9355, 9353, 9351, 9346, 9344, 9342, 9340, 9338, 9337, 9329, 9328, 9327, 9326, 9310, 9303, 9299, 9297, 9296, 9292, 9289, 9286, 9284, 9283, 9275, 9274, 9271, 9268, 9266, 9262, 9259, 9256, 9255, 9252, 9248, 9245, 9239, 9229, 9226, 9222, 9221, 9214, 9212, 9209, 9207, 9204, 9203, 9201, 9199, 9197, 9195, 9193, 9191, 9189, 9186, 9176, 9173, 9169, 9166, 9159, 9157, 9155, 9153, 9151, 9149, 9146, 9142, 9141, 9137, 9135, 9133, 9131, 9111, 9109, 9107, 9105, 9103, 9101, 9096, 9094, 9091, 9089, 9085, 9083, 9081, 9077, 9076, 9074, 9072, 9070, 9068, 9067, 9061, 9059, 9056, 9055, 9044, 9042, 9040, 9038, 9036, 9032, 9030, 9027, 9025, 9023, 9022, 9020, 9018, 9016, 9011, 9009, 9007, 9005, 9003, 9001, 9000, 8994, 8989, 8988, 8983, 8981, 8975, 8966, 8965, 8956, 8955, 8944, 8936, 8933, 8929, 8927, 8924, 8921, 8919, 8909, 8905, 8902, 8901, 8896, 8893, 8889, 8885, 8883, 8881, 8879, 8876, 8875, 8866, 8864, 8860, 8857, 8855, 8852, 8850, 8847, 8845, 8844, 8840, 8838, 8835, 8833, 8831, 8828, 8826, 8822, 8799, 8798, 8791, 8783, 8781, 8779, 8778, 8765, 8761, 8760, 8757, 8755, 8753, 8751, 8747, 8746, 8737, 8733, 8732, 8724, 8722, 8721, 8715, 8714, 8711, 8707, 8705, 8703, 8700, 8696, 8682, 8680, 8674, 8667, 8663, 8660, 8659, 8650, 8647, 8646, 8645, 8630, 8629, 8626, 8624, 8620, 8619, 8608, 8606, 8602, 8598, 8592, 8589, 8587, 8584, 8582, 8581, 8576, 8575, 8566, 8565, 8559, 8558, 8557, 8545, 8543, 8542, 8528, 8516, 8514, 8512, 8511, 8507, 8504, 8498, 8495, 8490, 8483, 8480, 8478, 8476, 8475, 8474, 8470, 8468, 8465, 8463, 8461, 8460, 8454, 8452, 8449, 8445, 8442, 8439, 8435, 8434, 8428, 8426, 8422, 8418, 8416, 8415, 8410, 8409, 8404, 8402, 8400, 8398, 8395, 8393, 8390, 8389, 8384, 8380, 8377, 8373, 8371, 8369, 8367, 8365, 8363, 8362, 8355, 8354, 8343, 8341, 8337, 8335, 8330, 8326, 8324, 8322, 8309, 8306, 8302, 8300, 8299, 8295, 8293, 8292, 8281, 8277, 8274, 8271, 8262, 8253, 8252, 8251, 8243, 8239, 8233, 8230, 8226, 8224, 8223, 8221, 8219, 8218, 8213, 8211, 8207, 8205, 8204, 8198, 8192, 8190, 8188, 8184, 8181, 8180, 8175, 8172, 8167, 8165, 8157, 8155, 8153, 8150, 8147, 8144, 8141, 8129, 8128, 8127, 8121, 8120, 8117, 8116, 8113, 8110, 8107, 8105, 8102, 8097, 8095, 8085, 8084, 8074, 8072, 8071, 8066, 8063, 8060, 8053, 8052, 8047, 8043, 8041, 8040, 8039, 8021, 8014, 8013, 8009, 8006, 8005, 7995, 7990, 7986, 7979, 7975, 7966, 7965, 7958, 7956, 7954, 7952, 7947, 7944, 7942, 7938, 7935, 7931, 7926, 7921, 7918, 7917, 7913, 7911, 7910, 7909, 7901, 7899, 7897, 7891, 7886, 7885, 7882, 7880, 7873, 7871, 7869, 7864, 7856, 7854, 7852, 7850, 7848, 7847, 7843, 7841, 7838, 7835, 7831, 7829, 7825, 7823, 7822, 7814, 7813, 7808, 7807, 7804, 7803, 7802, 7795, 7794, 7788, 7786, 7785, 7781, 7777, 7776, 7767, 7761, 7758, 7754, 7752, 7751, 7748, 7747, 7744, 7742, 7740, 7737, 7736, 7733, 7730, 7727, 7724, 7721, 7718, 7716, 7713, 7707, 7705, 7702, 7699, 7697, 7696, 7693, 7691, 7689, 7687, 7684, 7681, 7678, 7673, 7671, 7669, 7663, 7662, 7659, 7658, 7657, 7655, 7651, 7645, 7642, 7640, 7638, 7637, 7636, 7632, 7630, 7628, 7626, 7616, 7614, 7612, 7610, 7608, 7606, 7604, 7603, 7599, 7589, 7587, 7584, 7582, 7580, 7578, 7573, 7570, 7569, 7564, 7563, 7560, 7559, 7556, 7554, 7552, 7548, 7543, 7541, 7539, 7538, 7533, 7529, 7528, 7524, 7521, 7519, 7518, 7515, 7510, 7506, 7504, 7503, 7500, 7498, 7496, 7494, 7492, 7491, 7488, 7484, 7482, 7480, 7478, 7476, 7473, 7471, 7465, 7461, 7453, 7449, 7440, 7438, 7437, 7436, 7434, 7433, 7429, 7427, 7424, 7422, 7420, 7415, 7414, 7413, 7407, 7401, 7399, 7397, 7396, 7388, 7386, 7384, 7378, 7376, 7374, 7373, 7372, 7371, 7365, 7360, 7359, 7355, 7354, 7351, 7350, 7347, 7344, 7343, 7339, 7338, 7330, 7329, 7327, 7325, 7323, 7317, 7316, 7314, 7303, 7295, 7292, 7290, 7289, 7288, 7286, 7285, 7272, 7265, 7261, 7260, 7257, 7255, 7253, 7252, 7248, 7246, 7241, 7239, 7237, 7234, 7230, 7225, 7221, 7219, 7215, 7213, 7210, 7201, 7199, 7198, 7191, 7187, 7184, 7180, 7178, 7176, 7174, 7172, 7171, 7168, 7164, 7162, 7160, 7158, 7156, 7154, 7146, 7142, 7140, 7136, 7134, 7131, 7129, 7126, 7125, 7117, 7111, 7109, 7107, 7103, 7102, 7096, 7091, 7086, 7084, 7080, 7078, 7075, 7074, 7069, 7068, 7063, 7061, 7059, 7055, 7053, 7048, 7046, 7044, 7042, 7040, 7038, 7036, 7032, 7028, 7027, 7024, 7021, 7020, 7019, 7018, 7010, 7009, 7003, 7002, 6995, 6993, 6992, 6989, 6987, 6986, 6981, 6980, 6977, 6975, 6971, 6969, 6967, 6966, 6960, 6957, 6955, 6949, 6947, 6945, 6942, 6941, 6937, 6935, 6934, 6931, 6930, 6927, 6925, 6924, 6922, 6921, 6913, 6909, 6907, 6905, 6902, 6900, 6897, 6894, 6892, 6890, 6888, 6885, 6881, 6877, 6874, 6871, 6866, 6865, 6862, 6859, 6857, 6855, 6854, 6851, 6849, 6846, 6844, 6839, 6836, 6835, 6829, 6821, 6819, 6815, 6813, 6808, 6806, 6804, 6800, 6796, 6794, 6792, 6790, 6783, 6781, 6778, 6775, 6773, 6767, 6765, 6758, 6756, 6755, 6744, 6741, 6737, 6707, 6704, 6702, 6700, 6691, 6688, 6686, 6685, 6683, 6679, 6677, 6675, 6673, 6671, 6664, 6661, 6659, 6650, 6648, 6646, 6644, 6640, 6638, 6628, 6626, 6624, 6622, 6620, 6610, 6607, 6605, 6603))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_mjst_ticket_message | range | PRIMARY | PRIMARY | 4 | 986 | Using where | |
SIMPLE | xf_mjst_ticket_Ticket_1 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_mjst_ticket_message.support_ticket_id | 1 | |
SIMPLE | xf_mjst_department_Department_2 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_mjst_ticket_Ticket_1.department_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_mjst_ticket_message.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,slivkurs.xf_mjst_department_Department_2.department_id | 1 | Using where |
SELECT `xf_post`.*, `xf_bs_schedule_Schedule_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_user_User_5`.*, `xf_permission_cache_content_Permissions_6`.* FROM `xf_post` LEFT JOIN `xf_bs_schedule` AS `xf_bs_schedule_Schedule_1` ON (`xf_bs_schedule_Schedule_1`.`content_type` = 'post' AND `xf_bs_schedule_Schedule_1`.`content_id` = `xf_post`.`post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_post`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_4`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1') WHERE (`xf_post`.`post_id` IN (447235, 446303, 421026, 392541, 383081, 379399, 379301, 376970, 370047, 369471, 368428, 366491, 361857))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | 13 | Using where | |
SIMPLE | xf_bs_schedule_Schedule_1 | eq_ref | content_type_content_id | content_type_content_id | 31 | const,slivkurs.xf_post.post_id | 1 | Using where |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_user_User_5 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,slivkurs.xf_node_Node_4.node_id | 1 | Using where |
SELECT `xf_bs_schedule`.* FROM `xf_bs_schedule` WHERE (`xf_bs_schedule`.`content_type` = 'thread') AND (`xf_bs_schedule`.`content_id` = 123865) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_bs_schedule`.* FROM `xf_bs_schedule` WHERE (`xf_bs_schedule`.`content_type` = 'thread') AND (`xf_bs_schedule`.`content_id` = 176205) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_bs_schedule`.* FROM `xf_bs_schedule` WHERE (`xf_bs_schedule`.`content_type` = 'thread') AND (`xf_bs_schedule`.`content_id` = 49767) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_thread`.*, `xf_bs_schedule_Schedule_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_post_FirstPost_4`.*, `xf_user_User_5`.*, `xf_permission_cache_content_Permissions_6`.* FROM `xf_thread` LEFT JOIN `xf_bs_schedule` AS `xf_bs_schedule_Schedule_1` ON (`xf_bs_schedule_Schedule_1`.`content_type` = 'thread' AND `xf_bs_schedule_Schedule_1`.`content_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` IN (270561))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_bs_schedule_Schedule_1 | const | content_type_content_id | content_type_content_id | 31 | const,const | 0 | Unique row not found |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_post`.*, `xf_bs_schedule_Schedule_1`.*, `xf_thread_Thread_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_user_User_5`.*, `xf_permission_cache_content_Permissions_6`.* FROM `xf_post` LEFT JOIN `xf_bs_schedule` AS `xf_bs_schedule_Schedule_1` ON (`xf_bs_schedule_Schedule_1`.`content_type` = 'post' AND `xf_bs_schedule_Schedule_1`.`content_id` = `xf_post`.`post_id`) LEFT JOIN `xf_thread` AS `xf_thread_Thread_2` ON (`xf_thread_Thread_2`.`thread_id` = `xf_post`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread_Thread_2`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_post`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_4`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1') WHERE (`xf_post`.`post_id` IN (447235, 446303, 421026, 392541, 383081, 379399, 379301, 376970, 370047, 369471, 368428, 366491, 361857))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | range | PRIMARY | PRIMARY | 4 | 13 | Using where | |
SIMPLE | xf_bs_schedule_Schedule_1 | eq_ref | content_type_content_id | content_type_content_id | 31 | const,slivkurs.xf_post.post_id | 1 | Using where |
SIMPLE | xf_thread_Thread_2 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_post.thread_id | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_thread_Thread_2.node_id | 1 | Using where |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_user_User_5 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_post.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,slivkurs.xf_node_Node_4.node_id | 1 | Using where |
SELECT `xf_thread`.*, `xf_bs_schedule_Schedule_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_post_FirstPost_4`.*, `xf_user_User_5`.*, `xf_permission_cache_content_Permissions_6`.* FROM `xf_thread` LEFT JOIN `xf_bs_schedule` AS `xf_bs_schedule_Schedule_1` ON (`xf_bs_schedule_Schedule_1`.`content_type` = 'thread' AND `xf_bs_schedule_Schedule_1`.`content_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`) LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`) LEFT JOIN `xf_user` AS `xf_user_User_5` ON (`xf_user_User_5`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` IN (270561))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_bs_schedule_Schedule_1 | const | content_type_content_id | content_type_content_id | 31 | const,const | 0 | Unique row not found |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
-- XFDB=noForceAllWrite UPDATE xf_session_activity SET ip = ?, controller_name = ?, controller_action = ?, view_state = ?, params = ?, view_date = ?, robot_key = ? WHERE user_id = ? AND unique_key = ?
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('mjstStatusStyles')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.* FROM `xf_siropu_ads_manager_ad` LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`) LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`)) WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active') ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 102 | const | 1 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | slivkurs.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('xc_hide_bbcode_hidden_content')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('hidden_content')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
bytes_sent | 36718 |
bytes_received | 4436690 |
packets_sent | 286 |
packets_received | 4490 |
protocol_overhead_in | 17960 |
protocol_overhead_out | 1144 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 981 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 304 |
bytes_received_prepare_response_packet | 227639 |
bytes_received_change_user_packet | 4206656 |
packets_sent_command | 142 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 109 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 49 |
packets_received_prepare_response | 2903 |
packets_received_change_user | 1380 |
result_set_queries | 46 |
non_result_set_queries | 3 |
no_index_used | 2 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 46 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 46 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 1334 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1334 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 1334 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 2 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 1805 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 14594 |
proto_binary_fetched_int24 | 6562 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 74215 |
proto_binary_fetched_decimal | 58 |
proto_binary_fetched_float | 1043 |
proto_binary_fetched_double | 1014 |
proto_binary_fetched_date | 3045 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 27790 |
proto_binary_fetched_blob | 12833 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 47 |
com_stmt_execute | 47 |
com_stmt_send_long_data | 0 |
com_stmt_close | 46 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 4135654 |