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 |
SHOW FULL COLUMNS FROM `xf_user`
SHOW FULL COLUMNS FROM `xf_user`
SHOW FULL COLUMNS FROM `xf_user_profile`
SHOW FULL COLUMNS FROM `xf_user_profile`
SHOW FULL COLUMNS FROM `xf_user_profile`
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('tran_board_title')
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 ('tran_board_description')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,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 |
SHOW FULL COLUMNS FROM `xf_node`
SHOW FULL COLUMNS FROM `xf_node`
SHOW FULL COLUMNS FROM `xf_node`
SELECT `xf_node`.* FROM `xf_node` WHERE (`xf_node`.`display_in_list` = 1) ORDER BY `xf_node`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | ALL | display_in_list | 354 | Using where; Using filesort |
SHOW FULL COLUMNS FROM `xf_thread`
SHOW FULL COLUMNS FROM `xf_thread`
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.* 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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`) WHERE (`xf_forum`.`node_id` IN (562, 564, 55, 443, 551, 522, 524, 552, 553, 559, 317, 349, 560, 558, 538, 526, 531, 544, 548, 547, 355, 360, 361, 362, 364, 395, 549, 350, 403, 351, 402, 352, 404, 353, 405, 376, 388, 386, 387, 399, 401, 442, 455, 456, 454, 468, 517, 515, 518, 519, 521, 523, 554, 555, 557, 359, 363, 356, 319, 382, 13, 469, 238, 239, 22, 34, 206, 215, 208, 210, 213, 214, 278, 207, 314, 313, 330, 240, 209, 211, 212, 315, 205, 340, 14, 258, 334, 223, 241, 242, 257, 228, 21, 225, 17, 43, 175, 78, 247, 71, 226, 97, 72, 74, 84, 73, 76, 77, 75, 98, 227, 164, 99, 106, 168, 107, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 124, 125, 126, 123, 188, 165, 166, 167, 101, 174, 104, 105, 169, 100, 85, 171, 170, 86, 87, 176, 185, 186, 187, 177, 88, 172, 179, 180, 178, 173, 181, 182, 248, 20, 19, 44, 183, 184, 216, 217, 218, 328, 30, 200, 23, 50, 159, 336, 309, 27, 68, 306, 57, 81, 298, 301, 302, 299, 300, 66, 303, 297, 79, 307, 82, 89, 93, 128, 312, 250, 65, 58, 83, 59, 60, 61, 62, 63, 64, 108, 94, 520, 463, 464, 109, 152, 154, 129, 156, 157, 131, 132, 139, 143, 147, 148, 150, 155, 151, 195, 196, 197, 331, 332, 338, 127, 341, 344, 345, 346, 347, 348, 458, 459, 460, 461, 471, 475, 476, 477, 478, 472, 479, 480, 481, 482, 483, 484, 473, 485, 486, 487, 488, 489, 490, 474, 492, 493, 494, 230, 231, 232, 233, 234, 235, 236, 237, 198, 435, 189, 465, 470, 499, 512, 406, 418, 427, 432, 433, 412, 413, 424, 419, 421, 422, 423, 416, 438, 440, 441, 415, 436, 437, 417, 425, 192, 244, 245, 191, 219, 220, 221, 194, 190, 193, 202, 203, 201, 243, 305, 310, 260, 329, 366, 367, 371, 372, 396, 397, 369, 373, 370, 374, 368, 377, 383, 18, 280, 264, 326, 324, 325, 339, 390, 262, 265, 266, 273, 199, 496, 510, 509, 274, 308, 161, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 261, 284, 285, 282, 316, 29, 222, 52, 53, 162, 54, 158, 500, 502, 503, 504, 501, 505, 511, 3, 5, 6, 15, 11, 506, 7, 8, 9, 10, 16, 507, 24, 462))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | ALL | PRIMARY | 399 | Using where | |||
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_forum.last_thread_id | 1 |
SELECT `xf_category`.*, `xf_node_Node_1`.* FROM `xf_category` LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`) WHERE (`xf_category`.`node_id` IN (28, 563, 457, 467, 491, 229, 224, 256, 259, 4, 12))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | 11 | Using where; Using index | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_category.node_id | 1 |
SELECT content_id, cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 844 | Using where |
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 = ?
DELETE FROM `xf_data_registry` WHERE data_key IN ('userBanners')
SHOW FULL COLUMNS FROM `xf_user_group`
SHOW FULL COLUMNS FROM `xf_user_group`
SHOW FULL COLUMNS FROM `xf_user_group`
SELECT `xf_user_group`.* FROM `xf_user_group` WHERE (`xf_user_group`.`banner_text` <> '') ORDER BY `xf_user_group`.`display_style_priority` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_group | ALL | 26 | Using where; Using filesort |
INSERT INTO xf_data_registry (data_key, data_value) VALUES (?, ?) ON DUPLICATE KEY UPDATE data_value = VALUES(data_value)
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('mh_strip_visited_thread')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 |
SELECT SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total, SUM(IF(user_id > 0, 1, 0)) AS members, SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests FROM xf_session_activity WHERE view_date >= ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | ALL | view_date | 1734 | Using where |
SELECT `xf_session_activity`.*, `xf_user_User_1`.* FROM `xf_session_activity` INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`) WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1726879188) ORDER BY `xf_session_activity`.`view_date` DESC LIMIT 50
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | ALL | PRIMARY,view_date | 1734 | Using where; Using filesort | |||
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | iapd-2021.xf_session_activity.user_id | 1 | Using where |
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.* FROM `xf_thread` FORCE INDEX (`last_post_date`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1') LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1724288688) ORDER BY `xf_thread`.`last_post_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | 82 | Using where | |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,iapd-2021.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_thread.last_post_user_id | 1 |
SELECT data_key, data_value FROM xf_data_registry WHERE data_key IN ('forumStatistics')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 |
SHOW FULL COLUMNS FROM `xf_profile_post`
SHOW FULL COLUMNS FROM `xf_profile_post`
SELECT `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.* FROM `xf_profile_post` USE INDEX (`post_date`) LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`) WHERE (`xf_profile_post`.`message_state` = 'visible') ORDER BY `xf_profile_post`.`post_date` DESC LIMIT 10
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | index | post_date | 4 | 10 | Using where | ||
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_user_ProfileUser_1.user_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_profile_post.user_id | 1 |
SELECT `xf_user_profile`.* FROM `xf_user_profile` WHERE (`xf_user_profile`.`user_id` = 2585) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.* FROM `xf_attachment` LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`) WHERE (`xf_attachment`.`content_type` = 'profile_post') AND (`xf_attachment`.`content_id` = 130) ORDER BY `xf_attachment`.`attach_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_attachment.data_id | 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_profile_Profile_1`.*, `xf_user_option_Option_2`.* FROM `xf_user` INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`) INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`) WHERE (`xf_user_profile_Profile_1`.`dob_day` = 21) AND (`xf_user_profile_Profile_1`.`dob_month` = 9) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1253840688) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') ORDER BY `xf_user`.`username` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_profile_Profile_1 | ref | PRIMARY,dob | dob | 2 | const,const | 11 | Using temporary; Using filesort |
SIMPLE | xf_user | eq_ref | PRIMARY,user_state,last_activity | PRIMARY | 4 | iapd-2021.xf_user_profile_Profile_1.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | iapd-2021.xf_user_profile_Profile_1.user_id | 1 | Using where |
SELECT `xf_user`.* FROM `xf_user` WHERE (`xf_user`.`death_day` = 21) AND (`xf_user`.`death_month` = 9) ORDER BY `xf_user`.`username` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user | ALL | 10037 | Using where; Using filesort |
SELECT `xf_andy_countdown`.* FROM `xf_andy_countdown` LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_andy_countdown | ALL | 1 |
SELECT `xf_andy_banner`.* FROM `xf_andy_banner` WHERE (`xf_andy_banner`.`header` = 1) AND (`xf_andy_banner`.`active` = 1) ORDER BY RAND() ASC LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_andy_banner | ALL | 1 | Using where; Using temporary; Using filesort |
bytes_sent | 23805 |
bytes_received | 2417844 |
packets_sent | 388 |
packets_received | 5288 |
protocol_overhead_in | 21152 |
protocol_overhead_out | 1552 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1260 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 403 |
bytes_received_prepare_response_packet | 222137 |
bytes_received_change_user_packet | 2192611 |
packets_sent_command | 193 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 140 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 66 |
packets_received_prepare_response | 2979 |
packets_received_change_user | 2037 |
result_set_queries | 61 |
non_result_set_queries | 5 |
no_index_used | 25 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 61 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 63 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 1976 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 1976 |
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 | 1976 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
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 | 7781 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 10361 |
proto_binary_fetched_int24 | 3199 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 28164 |
proto_binary_fetched_decimal | 40 |
proto_binary_fetched_float | 3 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 380 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 34997 |
proto_binary_fetched_blob | 14547 |
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 | 64 |
com_stmt_execute | 64 |
com_stmt_send_long_data | 0 |
com_stmt_close | 63 |
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 | 2121262 |